Tejaswini Mogal

Partner with Marketing Strategy and DBM’s to create the target audience for direct mail. Creating and maintaining data marts, preparing data for marketing, modeling and analysis. Gathering business requirements and converting them into functional and technical requirements. Providing SAS programming support for department initiatives such as system conversion, program modification and program enhancements to improve efficiency. Ensuring full understanding and accurate execution of all statistical models in LINUX SAS environment. Maximizing file penetration rate and return of investment through development of new client file strategy, data analysis, segmentation techniques, and list selection. Analyzing historical customer and marketing data to identify trends and patterns that can be leveraged to optimize the effectiveness of customer contact strategies.

Perform data analytics to mine customer, prospect, competitor, and market information to develop actionable insights to improve customer experience and business performance. Use a variety of tools and models to stage and process data, translate results into insights to address business question. Work on data crunching, analyzing the data and making the data available for various Campaigns, Customer and Prospect Database development, and Analytics for the various businesses throughout Bloomberg. Establish and provide weekly reports and dashboards of campaign performance to help improve list selection, segmentation, and data mining efforts.

Gathering data from the Oracle database based on the report requirements from the end-users. Writing macro code to run the reports on daily, weekly and monthly basis. Scheduled the jobs on vi crontab. Used the BI tools like SAS MC, SAS IMS, SAS WRS, SAS OLAP cube studio to create various reports for different end users.

Gathering data from the DB2 database based on report requirements from various LOB. Create .xls or .pdf reports as per the requirements, using proc report, proc tabulate and Data _null_ to create reports. Worked on creating and making the data available on the MVS/TSO (used only for data entry into mainframes) Engaged in SAS peer code review, after completing every code, and checked for SQL standards and complete documentation and maintained a record on the share-point.

Data extracted from the Oracle database for reporting purposes. Extensively used PROC-SQL pass-through and PROC Append (Bulkcopy) to write statistical results to the Oracle database. Worked independently on multiple work orders to create ad-hoc reports and also automated few of the reports to obtain monthly reports. Worked as a key member (team of 4 members) on the migration project. Was responsible for transferring the PC- SAS QA environment jobs to the new UNIX production environment and prepared documentation for the same. Worked on scheduling the jobs and also monitored the jobs in the production environment. These jobs were scheduled using the vi-crontab scheduler in order to run the jobs on the required time basis to create daily, weekly and monthly reports and sent via email to the requestors under different LOB’s. Worked on encrypting the SAS codes using 7-zip and password encryption in the production environment and automated these jobs on daily, weekly and monthly basis. Worked independently on maintain the historical finance related data into SAS datasets, such that it was used in creating stored procedures and also extracted using Microsoft ad-ins (Excel). Assisted in performing the high level testing (UAT testing) which involved testing and evaluating the results obtained from the queries on Oracle database and the EDW database.

Developed SAS programs to load data from the source and create study specific datasets using DATA Step statement. Queried data from host and moved data set across platforms (from PC to UNIX and Vice Versa) using SQL and PROC SQL Pass through Facility to work with Oracle Supported and enhanced existing SAS programs, which create SAS data sets and other data files. Developed new or modify macros for report generation using SAS / Macros as per the statistician’s requirements. Developed SAS programs for statistical analyses using different procedures such as Means, Freq and Univariate. Studied specific datasets, which are used as source datasets for report generating Programs. Used PROC tabulate/PROC reports & standardized reporting programs into macros. Generated interactive reports which included various graphs using plot and chart procedures.

Performed data analysis mainly using MS-EXCEL for Regression and ANOVA. Worked extensively with MS-Excel, using vlookups, created pivot tables and OLAP cubes.