PROFESSIONAL SUMMARY:

• SAS Base Programming Specialist with over 8 years of experience in data management and statistical programming in Banking and Finance domain, Pharmaceutical clients and Contract Research Organizations (CRO).
• Over 9 years of extensive experience in ETL/ Data warehouse and database testing.
• Extensive experience in Statistical Analysis, Reporting and Data Management involving analysis, design, development, testing and validating the applications.
• Expertise in SAS BASE procedures like PROC SQL, PROC IMPORT/EXPORT, PROC PRINT, PROC SORT, PROC REPORT, PROC FORMAT/INFORMAT, PROC CONTENTS, PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC UNIVARIATE, Proc Append, Proc Datasets, Proc Tabulate, Proc Summary, etc.
• High proficiency in understanding of Clinical Data Interchange Standards Consortium (CDISC) process relating to data standards including Study Data Tabulation Model (SDTM), Analysis Dataset Models (ADaM).
• Generated Reports, Tables, Listings, Graphs and Summaries as per company standards and in compliance with 21 CFR Part 11, FDA and other regulatory compliance.
• Knowledge of Clinical Trials (Phases I - IV), preparation of safety reviews, adverse event report reviews, risk factor, integrated safety and efficacy summary (ISS & ISE) for FDA submission.
• High proficiency in understanding of clinical trial Study Protocol, Design document, Statistical Analysis Plan (SAP), and Case Report Form (CRF/eCRF), annotated case report forms and company Standard Operating Procedures (SOP).
• Extensive experience in generating SDTM datasets for Lab, AE, DM, EX and VS from raw data sets by following CRF, Dataset Specifications, ADAM and CDISC SDTM standards.
• Extensive experience in SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS and SAS/SQL.
• Knowledgeable in CRF-Annotation and Serious Adverse Events (SAE) in clinical data analysis.
• Review and provide inputs for essential trial documents such as protocol, CRF, Data Management Plan (DMP), and Statistical Analysis Plan (SAP).
• Expertise in preparation of reports, tables, listings and graphs, sorting and merging of data validations.
• Strong expertise using SAS/GRAPH to produce Graph by using SAS procedures PROC GPLOT and PROC GCHART.
• Proficient in importing or extracting data by connecting SAS System to database systems such as MS SQL, Oracle, Excel, flat files and exporting data to generate dynamic reports in HTML, RTF, XML, Excel, and PDF formats by using SAS/ODS.
• Knowledge of handling clinical trial data such as demographic data (DM), adverse events (AE), ECG data (EG), subject visits (SV), vital signs (VS) etc.
• Thorough understanding of Software Development Life Cycle and its various stages.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/REPORT, SAS/Enterprise Guide, SAS V8, V9

SAS Procedures: Print, Means, Univariate, Freq, Sort, Summary, Format, Transpose, Compare, Correlation, Regression, Contents, SQL, Tabulate, Import, Export, GchartGplot, Report

Operating Systems: Windows 2000/XP/ 7/8.1, UNIX, Linux, Sun Solaris, MS DOS

Statistical Packages: SAS, SPSS, Tableau, Minitab, Statistica, R, Python, Matlab

Programming Language: SAS 9.4, R, Python, SAP ABAP/4, CICS, HTML, XML, VB, C, C++, Java

Databases: Oracle, MS-SQL Server, Sybase, DB2, MS Access, Teradata, Informatica

Application Software: MS Office (Word, Excel, Power Point, Access), Visio

Testing Tools: HP ALM, HP QTP, Rational suite, Selenium, SoapUI, Pega, Version One, PCF Cloud, JIRA

Concepts: SDLC, Object Oriented Analysis and Design, Unified Modeling Language (UML), Assembly and System Level Testing, exposure in Agile (Scrum), SAFe Agile

PROFESSIONAL WORK EXPERIENCE

Confidential, Atlanta, GA

ETL Manager / SAS Programmer

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Implemented Credit Risk Analysis reporting system based on credit Scores and data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per casecreation and modification of views, accessing multiple databases.
• Wrote programs in SAS generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.

Confidential, Atlanta, GA

ETL Manager / SAS Programmer

Responsibilities:

• Analyzed the requirements and design the application as per the requirements of the users.
• Created and edit check programs to find data discrepancies in raw datasets provided by Data Management Group.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS tools-SAS / Base, SAS /Macros, SAS/Graph, and SAS/SQL.
• Used SAS/ Macro facility to provide reusable programs that can be conveniently used from time to time and, created tables, graphs and listing reports.
• Analyzed and evaluated data for completeness, correctness and consistency.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Maintained appropriate documentation surrounding archiving financial data.
• Involved in statistical analysis, reporting, and validation.
• Successfully created reports in HTML, PDF and RTF format using SAS ODS.

Confidential, Atlanta, GA

Onsite ETL Manager / SAS Programmer

Responsibilities:

• Extensive ETL testing experience in areas of OSS, BSS, Bill ordering and customer care applications.
• Provided analytical support, scheduled reports, and ad hoc reporting including database queries to extract necessary data using SQL.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc. to develop solutions.
• Responsible for maintenance and enhancements work in reporting system using SAS/Base, SAS/SQL, SAS/ Stat, SAS/Graph.
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports.
• Responsible for the generation of different plots which made the comparisons easy using SAS/GRAPH and the Proc Gchart, GPlot.
• Produced quality customized reports by using PROC TABULATE, REPORT and SUMMARY and also provided descriptive statistics using PROC MEANS, FREQ.
• Developed and designed SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs. ETL / Extract data from warehouse /databases and created SAS statistical analysis reports.

Confidential

Offshore ETL Manager / SAS Programmer

Responsibilities:

• Produced quality customized reports by using PROC REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Used SAS/Base, SAS/SQL procedures and provided programming expertise for employees and sponsors.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS output to RTF, Excel and HTML files.
• Used basic set, merge, update statements to create new datasets from existing datasets to meet requirements.
• Used several numeric and character functions in SAS programs.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS tools-SAS /
• Base, SAS /Macros, SAS/Graph, and SAS/SQL.
• Created datasets from raw data files (Excel, CSV, etc.) and Oracle SQL related files.
• Used SAS/ Macro facility to provide reusable programs that can be conveniently used from time to time and, created tables, graphs and listing reports.
• Extracted data from different data sources including Oracle tables using Proc SQL, Proc Import, and SAS/Access.
• Generated derived data sets from raw data sets using Proc Sort and used Merge, Set, Format and Functions.
• Generated various kinds of reports like Listings, Tables, and Figures (TLGs/TLFs), and ad-hoc reports using Proc report, Proc Gplot etc.

Confidential

Senior ETL Lead

Responsibilities:

• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Design of ETL technical architecture for data extraction and feed to MDM Batch process.
• Design of error handling techniques to process MDM and ETL errors for further reprocessing.
• Performed data quality analysis using advanced SQL skills.
• Provided technical assistance for creation of stored procedures and queries for automation of testing processes.
• Provide leadership and ETL Informatica expertise in implementing the ETL solution for MDM Implementation.
• Validated the Report GUI for Report testing and Functional testing of the reports by looking against the data displayed in data mart and reports.

Confidential

ETL Lead

Responsibilities:

• Implemented procedures for testing, debugging and documentation of applications with Informatica.
• Developed and executed SQL queries for backend testing using SQL Navigator.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Created complex SQL, triggers, PL SQL stored procedures, T-SQL queries and UNIX scripts to perform data validation testing; also utilized ETL, EDI, OLAP, and flat files for data profiling and data validation testing.
• Extensively used UNIX VI editor to create/modify/view the files on the server.

Confidential

ETL/DB Tester

Responsibilities:

• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Executed the workflows in the workflow manager, to start the ETL process.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.