Experience
2018 — Now
2018 — Now
Review database set-up specifications.
Provide leadership, project specific training, stakeholder management, external sponsor support, resource management, and project management for the required programming tasks supporting clinical trial activities.
Interact with sponsors and internal stakeholders with regard to statistical programming issues.
Assist project teams in the resolution of problems encountered in the conduct of their daily work.
Deliver best value and high quality service.
2012 — 2020
2012 — 2020
• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Extracted, transformed and loaded data from large Teradata tables using Data stage in data ware house. Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Create partition tables and apply threading techniques using SASTRACE.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Performed Data analysis, mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Efficiently prepared and published various performance reports and presentation
2009 — 2012
2009 — 2012
Raleigh-Durham-Chapel Hill Area
• SAS programming expertise in producing ADAMS, Tables, Listings and Graphs from SAS/BASE, SAS/MACRO and SAS/GRAPH, SAS/SQL, SAS/ STAT.
• Develop, modify and validate SAS programming work according to Statistical Analysis
plan (SAP).
• Created and validated ADAM datasets like ADSL and BDS datasets for the study
• Created tables, listings, graphs for safety reports.
• Performed Statistical Analysis using SAS/STAT procedures PROC MEANS PROC FREQ
etc
• Worked on datasets like Demographics, AE, Vitals, Concomitant medication, Physical
Examination, Labs.
• Generate reports, listings and graphs using SAS/BASE, SAS/MACRO, SAS/SQL and
SAS/STAT.
• Create reports in RTF/pdf format using SAS Output delivery system as per the client requirement.
2006 — 2009
2006 — 2009
Raleigh-Durham-Chapel Hill Area
• Extract data from Oracle database using SQL pass through facility, MS Access, Tagsets Excel sheets, and Delimited text files. Import and export procedures were applied in these procedures.
• Extracted, merged the data from diverse sources using matching conditions and then upload in to the data warehouse based on user defined Business rules.
• Develop SAS Reports using PROC REPORT, PROC TABULATE and load SAS data sets as tables into Oracle and SQL Server using SQL pass through facility, library reference method.
• Validate data and create reports using different procedures like Freq, Means, Transpose, Datasets, Sort, Compare, SQL, REPORT and SAS/ODS facility.
• Create, enhance and incorporate new systems with existing systems SAS Programs for generating reports, graphs, tables and lists.
• Indexing huge SAS data sets and utilizing those indexes as a part of SQL queries for quick results and write SQL joins to Merge the data sets to find exceptions from different tables.
Education
Nagarjuna University
Bachelor's Degree, Pharmacy
2000 — 2004