Chandra A Email & Phone Number

St. Louis, Mo, Us

St. Louis, Mo, Us

• Actively involved in designing and writing technical specifications for ETL processes and BI reports.• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.• Extensively involved in various phases of unit testing and production support.• Used SAS base code to generate reports and performs ETL process on large datasets (data extraction, transformation and loading, validation). • Created and maintained DI jobs in DI studio.• Involved in production support of DI jobs and creating and maintaining flows in platform LSF.• Involved in Debugging and fixing production Issues• Developed Technical Design Document and participated in daily status meeting. • Modified macros for report generation using SAS/Macros as per the requirements.• Generated highly customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL.• Retrieved data from MS Excel, Flat files to SAS for data review and statistical analysis using Libname engine and SQL pass through facility.• Extensively used PROC Datasets and PROC Copy to modify datasets.• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.• Experience in developing technical solutions with SAS Data Integration in a SAS environment.• Integrating and managing the data mappings in DI Studio• Involved in designing, developing and implementing the DI Studio job flows to load into tables from various flat files.• Involved in migration of programs from legacy SAS programs to SAS DI jobs• Experience in Base SAS programming, SQL programming (i.e., use of SQL pass-through or PROC SQL), as well as the SAS Macro language for use in making code more efficient.• Experience in using Enterprise Guide functionality to create project flows which include data access, manipulation, summarization, and report generation to a variety of output formats.

• Actively involved in designing and writing technical specifications for ETL processes and BI reports.• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.• Extensively involved in various phases of unit testing and production support.• Used SAS base code to generate reports and performs ETL process on large datasets (data extraction, transformation and loading, validation). • Created and maintained DI jobs in DI studio.• Involved in production support of DI jobs and creating and maintaining flows in platform LSF.• Involved in Debugging and fixing production Issues• Developed Technical Design Document and participated in daily status meeting. • Modified macros for report generation using SAS/Macros as per the requirements.• Generated highly customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL.• Retrieved data from MS Excel, Flat files to SAS for data review and statistical analysis using Libname engine and SQL pass through facility.• Extensively used PROC Datasets and PROC Copy to modify datasets.• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.• Experience in developing technical solutions with SAS Data Integration in a SAS environment.• Integrating and managing the data mappings in DI Studio• Involved in designing, developing and implementing the DI Studio job flows to load into tables from various flat files.• Involved in migration of programs from legacy SAS programs to SAS DI jobs• Experience in Base SAS programming, SQL programming (i.e., use of SQL pass-through or PROC SQL), as well as the SAS Macro language for use in making code more efficient.• Experience in using Enterprise Guide functionality to create project flows which include data access, manipulation, summarization, and report generation to a variety of output formats.

• Interacted extensively with end users on requirement gathering, analysis and documentation.• Experience in leading offshore team of five people• Involved in writing and reviewing test plans and test case documents and SIT.• Involved in data validation and QC.• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.• Used SQL to perform ETL process (data extraction, transformation and loading, validation). • Effectively prepared and published various performance reports and presentations.• Performed complex Data analysis and integration testing.• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Data Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts• Experience in Data and ETL architecting.• Experience in working with SAS DI Studio• Involved in developing new data loads to existing tables using SAS DI Studio.• Created Stored Processes to provide the stakeholders easy access to the data.

• Involved in Developing, Debugging, and validating the project-specific SAS programs to generate derived SAS datasets, summary tables, and data listings according to departmental standards.• Used Sorting and Merging techniques on the raw data sets for value added data preparation, to get the required Reports or Analysis data sets.• Generated Tables, Listings and provide QC check, validation of outputs for Clinical Data• Responsible for Developing reports as per study requirements.• Performed QC (Quality Check) extensively on tasks performed by other team members and involved in data validation and data cleaning.• Extensively used Proc SQL to retrieve, update and report on information from SAS data sets and other database products.• Modification of existing SAS programs and creation of new programs and automation using SAS Macros.• Worked with Statisticians and Data Managers in analyzing the Clinical Data and generating Reports.• Created analysis datasets based on the guidelines provided in the Data Definition Tables (DDT) and following the CDISC standard.• Extracted data from ORACLE database and involved in cleaning the data (data cleansing) using various edit check techniques.• Extensively used Proc SQL, Proc Transpose, Proc Format, Proc Means, Proc Freq, Proc Printto and Proc Compare for checking the assumptions and conducting Statistical Analysis.• Used SAS ODS and tagsets to report outputs in different formats like XML , PDF, and Excel

. Assisted professors in maintaining student records using excel sheet and other software tools.. Formatted research documents and helped in proofreading the content. . Worked on forensic research project which involved analysis of Data collected from different samples by applying various statistical procedures(t-test, annova, mean, standard deviation, correlation, outlier detection) and tools(R, SAS). Captured analytical lab record data of students using data management tools.. Experience in teaching practical lab sessions for undergraduate students.. Assisted Professors in maintaining lab environment by adhering to safety rules of the University.