Senior SAS Analyst Resume Profile

Summary of Credentials

11 years of analytics experience with expertise in data analytic techniques, prescription and patient level analysis, Payer ,Plan and PBM level analysis
Extensively worked on Market research and Data analytics leveraging the expertise in Life sciences and technical knowledge on retail and hospital drugs.
Strong operational, data management and data visualization skills
Developed SAS Analytics engine for high end business users exclusively for analytical purpose.
Experienced in analysis, planning, scheduling, effort estimation, design, development, testing, S/W configuration management and delivery activities.
Developed applications on Mainframe and Windows using COBOL, SAS languages etc
Experience with IMS/ WK/SDI/ data sources
Commercial analytics/ Managed Care analytics/ Targeting/Segmentation on various therapeutic areas

Technical Skills:

Professional Experience:

Role: Manager/Senior SAS Analyst

As a manager, was involved in analysis, understanding client processes and worked efficiently to meet targets.
Managed and guided the data development team on extracting and mapping the data for the business questions within the managed market arena
Delivered ad hoc reports meticulously with 100 accuracy on time with value added analysis
Physician level Targeting report generation Decile Ranking
Data management and data integration at payer/plan level
Extensively supported the statistical team providing them with the adhoc data extracts
Subject matter expert of the data and conducted training across cross functional teams internally and also trained clients on how to interpret the finger tip formulary data
Design and develop new processes, identify repetitive tasks and automating using SAS Macros

Environment Languages: SAS DWBI, PC SAS with SAS Enterprise Guide, Excel and VBA

CONFIDENTIAL

Role: Onsite Coordinator/ Data Analyst

Analyzed large sets of data using SAS SQL and identified trends, breaks and product utilization
Developing and modifying SAS macros for the automation of monthly/weekly reports
Cross-functional data merge between Drug Distribution Data DDD , Prescription Data Rx .
Involved in production fixes, trend break analysis using SAS 9 SAS EG
Managed 5 offshore resources and mentored them on managed care analytics
Involved design, development maintenance

Environment Languages: SAS DW, Mainframe, SAS 9, SAS/EG, SAS Macro, SAS SQL,

SAS/Graph, SAS/STAT, SAS/ACCESS, SAS/CONNECT, JCL, COBOL, IDMS, Fileaid, Panvalet,
ENDEVOR, Excel, VBA

CONFIDENTIAL

Report generation using SAS,
Understanding OLP process, execute the job for OLP-Dump
Gathered requirements, scoped out the study and provided insights to clients
Adhoc analysis on ROI, Segmentation etc
Identified trends and did extensive market study on competitor brands and provided insights which drove strategic decisions

Environment Languages :IBM Mainframes, OS 390, Windows XP, COBOL, JCL, SAS

CONFIDENTIAL

Project Description:

Interacted with the business and Identified weekly, monthly reports and automated the data mining process
ETL data for the general repository of ANZ customer data base
Modeled and Validated the warehouse data and bridged the gap between the IT and the business functions