SUMMARY

• Over 7+ years of Professional Experience in Sr. Business Analyst for Clinical, Business Analysis, Data Analysis in Banking, Media, Marketing, Retail, CPG and Healthcare projects. SAS programming/analysis experience on UNIX, MAINFRAMES and Windows platforms.
• Expertise in processing large datasets for transformation, data cleansing, data scrubbing, data profiling and applying business logic rules to new data.
• Expertise in building mathematical and statistical models in SAS and Risk Management Groups.
• Created Financial and Retail Modeling Datasets. Used the procedures SQL,TABULATE,FREQ, FORMAT and GRAPH to generate modeling reports.
• Strong SAS programming background for maintaining existing code,ad hoc reportingand supporting the reporting functions.
• Expertise in writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
• Developed SAS programs to generate new datasets from raw data files using Import Techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions using (HTML, Excel, PDF, Word, and XML) and converting various files types to SAS Datasets.
• Experience with PROC, SQL, SAS Array and SAS Macros and developing new Codes.
• Ability to work independently, collectively, good communication skills, a leader, builder as well as quick and self - learner, and able to deliver under pressure.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Business Analyst

Responsibilities:

• Interact with Business users for requirement gathering.
• Analysing the specifications provided by credit bureau and discuss with the IT teams for data preparation as per the bureau requirements.
• Responsible for Data validation of the data being sent to Credit Bureau using SAS.
• Download the data using SQL.
• Prepare the summary reports across the products (Credit Cards, Loans like home loans, vehicle loan etc, OD).
• Have the reviews with the portfolio teams on the data reconciliation.
• Test the new logic in SAS and provide the signoff to the IT team on the implementation of the new logic.
• Performed extraction, transformation and loading of large Oracle tables.
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Used SAS Macros and procedures like Proc SQL, Transpose, Univariate, Means, Freq.
• Developed SAS Macros for Data cleaning, Data mining and Reporting and to support routing processing.
• Formatted HTML, PDF, CSV and RTF reports, using SAS - Output Delivery System ODS.
• Extracted data from Data Warehousing tables and Data marts.
• Performed data scrubbing using SAS/BASE and Macros.
• Used programming tools such as SAS BASE V9.1.3 (Windows and UNIX), SAS Enterprise Guide V3, SAS MACRO, SAS ACCESS, PROC SQL, Oracle9i, Advanced Microsoft Excel, MS office suit.
• Automated creation of Daily, Monthly and Quarterly report to support requirements from business partners.
• Creating customized reports in Enterprise Guidefor the users
• Upgraded SAS versions.
• Coordinated the production of quarterly, scorecard reports for senior management.
• Extracted data from the database using SAS/Access, SAS SQL proceduresand create SAS data sets.
• Coding SAS programs with the use of BASE SAS and SAS MACROS for Ad-hoc Reports
• Created the process flow for Dispute Resolution from Credit bureau and customers.
• Perform detailed analysis of the disputes raised by the customer and credit bureau.
• Worked on data preparation for campaign Management for new loans and top ups.
• Customers are being scored on SMG3 and validated on SAS based on the various score card parameters.
• Based on the credit score the credit limit is being assigned for the customers.
• Worked on creating the automations in Excel VBA for preparing the input files for scoring the customers.

Confidential, NY

Business Analyst

Responsibilities:

• Understanding the requirements of the Application
• Developed analysis datasets based on the guidelines provided in the SAP (Statistical Analysis Plan).
• Provide SAS Programming and analysis support for phase II.
• Generated reports on AE (Adverse Events) and SAE (Serious Adverse Events) Demographics, Laboratory shift tables by referring to the Statistical Analysis Plan and the Mockup Shells.
• Validated TLGs by writing competing code and comparing the values produced with the source report values.
• Created ad-hoc reports requests.
• Extracted data from the database by SQL PASS THROUGH FACILITY and LIBNAME facility.
• Created reports in RTF, PDF, Excel and HTML formats using ODS statements
• Developed macro programs defining the macro parameters using different debugging options like MPRINT, MLOGIC, and SYMBOLGEN.
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference.
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference
• Created Summary tables using procedures like PROC TRANSPOSE, SORT, FREQ, MEANS, SUMMARY, UNIVARIATE, AND TABULATE.
• Created electronic datasets (i.e., SAS Transport Files) for submission by using PROC EXPORT for FDA submission.
• Closely work with the statisticians and data managers to identify common factors across the projects.

Confidential, NY

Data Analyst

Responsibilities:

• Creating and produce market research reports on specific products and markets.
• Worked on data preparation and generating reports for online Survey Data.
• Handled projects with Concept test, Product test, Tournament, Drug assessment for Pharmaceutical and research studies including banking industries.
• Worked on SAS, Quantum (Market Research Tool), SPSS and Quanvert.
• Created frequency tables for questioner data.
• Individually handled level 2/3 Adhocs and Trackers/Continuous projects.
• Worked on Editing (Data cleaning) and Tabulation (Reports) using Quantum and SAS.
• Prepared frequency reports and data marts for the different clients like Mcneil, P&G, TIAA, Star bucks etc.
• Making recommendations to senior managers based upon research findings.
• Defining target markets and opportunities within the same brands.
• Processing and analyzing raw data into reports for senior managers.
• Work with external data suppliers regarding data accuracy and integrity.
• Responsible for the development of client reports on current trends.
• Making sure that methods of data collection are effectively and accurate.