SUMMARY

• Experienced working in SAS/BASE, SAS/MACROS, SAS/STAT, SAS/ACESS, SAS/ODS, SAS/SQL and UNIX Environment.
• Experienced in creating source to target mapping using MS - EXCEL, VISIO and ACESS.
• Experienced in performing various joints based on the cardinality of the datasets and assessed the QA of the target Database.
• Analyzing various tables using data manipulation techniques like merging, appending, concatenating and sorting.
• Having the good experience in cleansing the data and checking the data quality and good experience in system testing and regression testing.
• Having experience in UNIX to execute theSASmacros and programs, strong knowledge on UNIX.
• Expertise in using variousSASprocedures such as Univariate, SQL, Freq, Means, Compare, Sort, Transpose, Report and Tabulate.
• Having experience in UNIX to execute theSASmacros and programs, strong knowledge on UNIX.
• Expertise in using variousSASprocedures such as Univariate, SQL, Freq, Means, Compare, Sort, Transpose, Report and Tabulate.
• Worked in remediation (Performance Tuning) team for improving query performance of user queries and production SQL's. Worked in several areas of Data Warehouse including Analysis, Requirement Gathering, Development, Testing, and Implementation
• Command in inputting complex internal data sets, using import/export wizard, PROC IMPORT and PROC EXPORT,SAS/ACCESS,SAS/SQL to import different types of external data files (.csv,.xls,.txt, etc.) intoSASlibrary and exportSASdatasets into different types of external data files.
• Experienced in analyzing the Metadata to know from where the data migrated from data warehouse.

TECHNICAL SKILLS

• SQL
• SAS/BASE
• SAS/MACROS
• SAS/EG
• SAS/ACESS
• SAS/ODS
• SDLC
• ELT
• MS-OFFICE SUITE

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

SAS Programmer Analyst

Responsibilities:

• Experience analyzing and interpreting data; maintaining and managing large datasets, including ability to ensure the integrity of data.
• Strong analytical skills and ability to use a variety software such asSAS, SQL, data visualization software, other related statistical programs, MS Excel, and MS Access.
• Proficiency in MACRO programming inSAS, using macro loops, macro variables, conditional macro execution, distinguishing global and local macro variables, and creating or referencing macro variables from within the regular DATA STEP.
• Created reports inSASand exported to Excel spreadsheets, created web reports using Web Report Studio.
• Experience working with SAS Clients like SAS Enterprise Guide, SAS Enterprise miner, Base SAS.
• Expertise in using variousSASprocedures such as Univariate, SQL, Freq, Means, Compare, Sort, Transpose, Report and Tabulate.
• Command in inputting complex internal data sets, using import/export wizard, PROC IMPORT and PROC EXPORT,SAS/ACCESS,SAS/SQL to import different types of external data files (.csv,.xls,.txt, etc.) intoSASlibrary and exportSASdatasets into different types of external data files.
• Experience in creating the Transport Files to use in different environments by using PROCEDURES such as CPORT, CIMPORT.
• Advanced skills on data cleaning and manipulation using PROCEDURES such as SUMMARY, SORT, FREQ, MEANS, UNIVARIATE, FORMAT, TRANSPOSE, PRINT, PRINTTO etc. and manySASdata steps such as ARRAY, MERGE, SET, etc.

Environment: SQL, SAS/SQL, SAS/BASE, SAS/MACROS,ETL, AGILE, SDLC, ER-STUDIO, MS-OFFICE SUITE.

Confidential, Greensboro, NC

SAS Programmer

Responsibilities:

• Reading and understanding the study annotated Case Report Forms, Study Definition documents, software tools and working with SAS.
• Importing and exporting raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures.
• Worked on Data Management SAS DATA step processing, PROC SQL for data extraction, write datasets, Report and use of PROC REPORT, DATA NULL, SAS Macro processing.
• Generated analysis data sets for both safety and efficacy parameters based on the guidelines provided in the SAP (Statistical Analysis Plan).
• Developed routine, user friendly SAS macros to create tables, and listings for inclusion in Clinical study reports and regulatory submissions.
• Produced summaries and statistics using PROC MEANS, PROC SUMMARY, PROC FREQ, and PROC ANNOVA.
• Used SAS ODS to create RTF, HTML, and PDF outputs files in the process of producing reports
• Developed and validated SAS programs for SDTM and ADAM datasets.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS TOOLS - SAS/BASE, SAS/SQL, SAS/CONNECT AND SAS/ACCESS.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Efficiently generated SQL queries for data manipulation, analysis and report generation.

Environment: SQL, SAS/BASE, SAS/MACROS, SAS/EG, SAS/ACESS, SAS/ODS, SDLC, ELT, MS-OFFICE SUITE.

Confidential, Raleigh, N

Data Analyst/ SAS Programmer.

Responsibilities:

• Demonstrates knowledge of multiple system format requirements, data cleansing tools, parsing tools, business rule requirements for formats, and recognition and resolution of data formatting errors.
• Experienced in UAT (User Acceptance Testing) to check for the use case criteria and test plans and test cases on the sprints
• Worked with various SAS products SAS/BASE, SAS/STAT, SAS/GRAPH, and SAS/MACROS to develop required solutions.
• Generated Tables, Listings, and graphs using procedures like PROC FREQ, PROC REPORT, PROC TABULATE, DATA NULL, and PROC GPLOT.
• Optimized data format for further analysis in terms of cleaning, validation, formatting and Labeling using PUT/ INPUT Functions, LABEL statement, and PROC FORMAT.
• Extracted datasets from database using SAS/ACCESS, LIBNAME Statement and other import methods.
• Supports and facilitates procedure identification and documentation.

Environment: SQL, SAS, MS Excel, ETL, SDLC, AGILE(SCRUM), MS-OFFICE.

Confidential, Frederick, MD

Data Analyst.

Responsibilities:

• Utilize a multidisciplinary approach to Data Analytic problems combining technical expertise with analytics and business knowledge
• Work with Data Scientists and business partners on embedded cross functional teams; developing subject matter expertise in the business as well as advanced analytics.
• Experienced in creating KPI’s, aggregates and calculated key figures in MS-Excel
• Execute rapid development of new data work tracks with fast iteration over quick sprints
• Leverage and enhance the data infrastructure required to support needs of data science and analytics.
• Contribute to an environment that supports innovation and process improvement.
• Contribute to the development of corporate research data files, information platforms or data spaces designed for exploring and understanding the data.

Environment: SQL, ETL, Workflow, Data mapping, MS-OFFICE.