AnupamaMullapati

PROFESSIONAL SUMMARY

• Extensive experience in data manipulation and generating customized reports with SAS data steps and procedures including Data NULL , Proc Datasets, Proc Format, Proc Contents, ProcFreq, Proc Transpose, Proc Tabulate, ProcGplot, ProcGchart, Proc Print, Proc SQL, Proc Summary and Proc Report.
• Extensive experience in developing standardand Ad hoc Reports, tables, listings and graphs.
• Experience in preparation of FSD Functional Specification document / TSD Technical Specification Document from BRD Business Requirements document .
• Proven experience in requirement gathering, Client co-ordination, Data Mapping, Data Analysis.
• Proficient in Base SAS, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/ODS and SAS/SQL in Windows, UNIX environment.
• 7 yearsof SAS programming experience in Healthcare and Pharmaceuticalindustry.
• Ability to deal with large datasets with more than a billion records.
• Experience in analyzing data, creating various reports based on the client needs.
• Great understanding of data management principles and database design.
• Proven skills in Data Cleansing, Data Archival, Data Migration utilizing SAS on UNIX and Windows.
• Compiled statistics and created detailed reports and graphs for management and customer review using SAS/Graph, SAS/ Macro, SAS/SQL, SAS/ STAT etc.
• Extensive experience in operation of relational database management systems.
• Proficiency in using SAS/ACCESS to import various external data files into SAS library, and extensively used SAS Proc SQL for advanced data query.
• Extensive experience and proficiency in using SAS ODS to create output files in a variety of formats including RTF, HTML and PDF.
• Working on the ICD-9 to ICD-10 conversion project.
• Hands on Experience working on different platforms like Windows, UNIX and HP-UX.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and Access tables.
• Involved extensively in Data Extraction, Transformation, Loading and Analysis for Healthcare Insurance.
• Very good command in acquisition modeling, validation, statistical consulting, and providing helpful recommendations in maximizing profits.
• Experience with databases like Oracle 8i/ 9i, SQL Server 2008, Teradata and MS Access.
• Proven ability to work under pressure, prioritize and meet deadlines. Open to dynamic work environment and ability to work collaboratively with business analysts, testers, developers and other team members in the overall enhancement of software product quality.
• Strong communication and presentation skills. Detail oriented and able to multi-task effectively.
• Strong quantitative and analytical abilities to analyze and validate data.

TECHNICAL SKILLS SUMMARY

• SAS Versions: SAS 8x, SAS 9x
• PROCs Used:SQL, MEANS, DATASETS, REPORT, SUMMARY, TABULATE, FORMAT, IMPORT, EXPORT, TRANSPOSE, COMPARE, GCHART, GPLOT
• Databases, Platforms: ORACLE, DB2, TERADATA, UNIX, WINDOWS
• Other Technologies and Tools: F-Secure SSH client, Toad, Teradata SQL Assistance, Lotus notes, EditPlus, Ultra Edit, PuTTySSH client, HP ALM, Autosys, Attachmate Reflection SSH client, MS Office

PROFESSIONAL EXPERIENCE

Confidential

Role:Sr.SAS Programmer/ System Business Analyst

Responsibilities:

• Used SAS base code macros to generate reports and perform ETL processes data extraction, transformation and loading, validation . Monitored and managed the data feeds into the data warehouse and extraction transformation and loading to analytical database.
• 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 different input styles to read the TXT, CSV and XML files to read into SAS create SAS datasets and wrote complex SQL to join SAS datasets and Oracle tables.
• Develop end-to-end reporting based on business requirements using SAS views from Oracle database tables using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create SAS reports.
• Analyzed various tables using Data manipulation techniques like merging, appending and sorting.
• Worked with large data sets 15 million records using Pass Thru SQL technique.
• Generated highly customized reports of claims data using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL. Monitored and managed the execution plans for SQL code using SQL developer.
• Actively involved in analysis of Claims data, Membership data and Service Line data and created delimited files to send it to Business users for further analysis.
• Documented the Business Process and Business Functionality, and translated them to requirement specifications document.
• Created new SAS datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and other conditional statements.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE, PROC MEANS, and PROC FREQ. for creating a preferred list of customers as per the given requirements from business analysts.
• Provide analytical and technical support for member/eligibility and claims data.
• Responsible for production updates monthly, quarterly and semiannual by processing client's eligibility and claims data from different carriers.
• Solve complex issues and implement solutions to enhance productivity, improve quality and customer satisfaction.
• Worked in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan.
• Work with team to achieve timely resolution of all production issues.
• Conduct code review and testing of final results to ensure the work delivered by the team is of high quality standards.
• Work with business to prioritize production issue resolution.
• Work with the Business Analyst in process improvement initiatives as directed by the business.

Environment: SAS V8x/ 9x, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS, PL/SQL, ORACLE 11g, Teradata, MS office and UNIX

Confidential

Role: SAS Programmer

Responsibilities:

• Created and maintained SAS Datasets that are extracted from an Oracle Database.
• Developed programs for routine and complex SAS SDTM datasets, ADAM datasets, tables, listings and figures according to statistical analysis plan.
• Designed flowcharts indicating the input data sets and the operations that would be performed sorting, merging, etc. to get the desired output as per the specifications.
• Created derived datasets by annotating the analysis variables based on Statistical Analysis Plan.
• Derived analysis datasets by adding array variables for running up the Cox proportional hazard model for risk of a particular adverse event by implementing ProcPhreg procedure.
• Summarized the Time to Event analysis using Kaplan-Meyer survival analysis and graphs including identification of censored observations and confidence intervals for estimated event probabilities using ProcLifetest.
• Worked with annotated datasets in SAS Graph to generate more customized and detailed graphs.
• Prepared safety analysis data sets for analysis using SAS Data step programming and SAS Stat Procedures.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS BASE and SAS Macro facility.
• Used SAS for pre-processing data, SQL queries, data analysis, graphics, statistical analysis and generation of reports.
• Responded to adhoc requests by the statisticians with detailed listings generated with data step and Proc Report.
• Modified existing macros and developed new macros to generate discrepancy reports and QC reports.
• Developed SAS code to clean the invalid data from the database.
• Created Summary Reports and Tabular Reports.
• Created standard ad hoc reports with clinical variables.
• Developed macros to generate MedDRA and WHODRUG mismatch reports for AE, MH, CM and PK data.
• Involved in clinical data validation and code validation by writing the competing code and checking that the output is consistent to assure the clinical data meets the standards.
• Generated reports in RTF, PDF and Excel formats using SAS ODS.
• Review of Module 5 clinical documents, and updating Clinical regulatory database CREDI
• Involved in validating the transport files for electronic submission to FDA.

Environment: SAS8x/9x SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/Connect, SAS/Assist,UNIX, Windows, MS suite, Oracle, Toad, Attachmate Reflection SSH client, Attachmate Reflection FTP client, Edit Plus, CREDI Novartis clinical database .

Confidential

Role: Regulatory SAS Programmer/Analyst

Roles and Responsibilities:

• Responsible for providing Clinical SAS programming and analysis support for clinical studies across multipleprotocols for the submissions like NDA and Safety.
• Developed programs for validation of tables and listings for clinical study reports.
• Setting up SAS datasets by extracting data from Oracle Clinical using PROC ACCESS, SQL Procedures Pass-through facility and Oracle Libname Engine.
• Created and maintained SAS datasets that are extracted from Oracle databases using SAS DATA STEP and PROC SQL.
• Used Sorting and Merging techniques on the raw data sets for value added data preparation, to get the required Reports or Analysis data sets.
• Produced Ad-hoc reports as per requests.
• Developed and updated existing MACRO programs.
• Modified SAS Macros related to multiple studies.
• Involved in the support of Phase II and III clinical trials Regulatory submissions.
• Worked on the safety ISS and efficacy ISE listings for the various studies
• Contributed to the development of standard operating procedures SOPs .
• Created CRT Case Report Tabulations datasets using ODM model of CDISC standards for FDA/Global Submission.
• Used SAS ODS to generate the reports in RTF and EXCEL formats.
• Worked on multiple protocols and/or drug compounds at a time.
• Conducted analysis on the raw data to determine the quality and validity of data.
• Review of specifications, mock-up tables.
• Maintained appropriate study application documentation.
• Used Base SAS SAS Macros to generate reports of clinical data and assisted in the validation of clinical data from Clintrial or other electronic sources.
• Performed QC Quality Check extensively on tasks performed by other team members and involved in datavalidation and data cleaning in all phases of Clinical studies.
• Program documentation on all programs, files and variables was performed for accurate historical recordand also for future reference.

Environment:SAS 8x, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/ODS, SAS/GRAPH, Oracle8, Window NT/ 2000, MS tools, UNIX.