PROFESSIONAL SUMMARY:

• Having 8+ years of extensive experience in Statistical analysis system (SAS) Programming with strong emphasis on analysis, development, design, testing and implementation of various projects.
• Hands on experience in SAS Programming, MergingSAS Data Sets, DevelopingSASprocedures, Macros, Preparing Data, Producing Reports, SASFormats,SASFunctions,SASInformats, Storing, ADHOC reporting, supporting the reporting functions and Managing Data inSASFiles.
• Extensive experience in working on SAS versions using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/ETL, SQL, SDTM, ADAM, Excel, MS Office tools.
• Expert in working with SAS Enterprise Guide for reporting and analytical tasks and scheduling Stored Procedures.
• Experience in Base SAS, SAS/Stat, SAS Macros, SAS/Graph, SAS/Connect, and SAS/Access on Windows and Unix platforms and competence in carrying out statistical analysis of large - scale data
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE,PROC IMPORT/EXPORT,PROC CONTENTS,PROC UNIVARIATE,PROC GPLOT, Data NULL and PROC PRINT
• Good skills in statistical parametric analysis methods such as Correlation, Regression, Analysis of variance and general linear models usingSASSTAT procedures such as PROC ANOVA, PROC GLM, PROC CORR, and PROC REG.
• Expert in Data extraction from several databases including Oracle, SQL Server and other external files using SAS/ACCESS, SAS/SQL pass through facility, Libname statements, PROC IMPORT procedure and also via SAS Data steps.
• Experienced in producing RTF, EXCEL, PDF, HTML formatted files using SAS ODS facility.
• Created reusable Macros extensively, used existing Macros, and developed SAS Programs for cleaning, validation, and analysis and Report generation.
• Good experience in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically and proficient in Integration of various Data Sources like MS-Access, Flat and CSV Files
• Solid foundation in use of SAS macro, SAS/Connect, SAS/Access, SQL, Oracle, Teradata relational table structures and FTP interfaces between platforms and the UNIX environment.
• Excellent command in writing complex script for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SASon various environments.
• Familiar with different phases of clinical trials, study protocols and analysis plans of pharmaceutical data from EDC and has experience in QC.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamworkand strong communication skills.
• Excellent oral and written communication skills. A quick learner with an eye for detail and excellent analytical and quantitative skills.Ability to work independently as well as collectively & willing to relocate.

TECHNICAL SKILLS:

SAS Application Release: SAS 9.1/9.1.3/9.2/9.3/9.4

Operating System: Windows 98/ 2000/ XP/ NT/ 7, Linux RHEL and UNIX

Tools: SDTM, ADAM MS Office 2003/ 2007/ 2010 , MS-Word, MS-Excel, MS-Access, MS-PowerPoint.

SAS Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/STAT,SAS/ODS, SAS/Graph, SAS/Macro, SAS/EG

SAS Procedures: PROC PRINT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY, PROC TRANSPOSE, Data Null, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, PROC ANOVA. PROC GPLOT, PROC FORMAT and SORT.

Languages: SAS/SQL, HTML,XML,VBA, ORACLE/SQL

Databases: MS SQL Server (2000, 2008), Oracle 8i, 9i, 11g, DB2, Teradata, MS Access.

WORK EXPERIENCE:

Confidential, Pittsburgh, PA

Sr.SAS Developer

Responsibilities:

• Run various queries usingSAS/Base,SAS/SQL andSAS/MACRO for ad-hoc reports according to the Users requirement.
• Converted ORACLE data tables intoSASdata files usingSASSQL Pass through Facility, and uploadedSASdata files into ORACLE tables usingSASDbload procedure.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Prepared and tested ETL codes as part ofSASprojects and managed data integration development tasks in collaboration with other technical teams
• Imported user-written code to generate DI transformationsand performed the ETL tuning by using lookup instead of join if possible, removing unnecessary components, making use of the indexes on the tables etc
• Analyzed business workflow and system needs for conversions and migrations.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs usingSAS ToolsSAS/Base,SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Created Data Architecture/ETL Processing and designed data warehouses, detailed data stores (DDS), and reporting data marts using relational and dimensional modeling techniques for utility,Utilized slowly changing dimensions to track changes over time
• Defined and documented business logic and system processes.
• Programmed to produce data listings usingSAS. Converted MS-Word documents and Excel tables intoSASdata sets.
• Designed, Developed and Deployed reports in MS SQL Server2012 environment using SSRS
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Involved in development and enhancements ofSASPrograms.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance (ANOVA) using PROC REG, PROC CORR, PROC GLM, PROC ANOVA.
• Successfully generated permanent and temporarySASdatasets and effectively usedSAS/STAT for response-surface regression modeling..
• Created survival graphs in Excel by transportingSASdata sets into Excel spreadsheets.
• Developed ETL packages using heterogeneousdatasources (SQL Server, Flat Files and Excel source files) and then loaded thedatainto destination tables by performing different kinds of transformations using SSIS.
• Ensured quality of dataset at the protocol level while working to deliver competitive advantage and cost efficiency to the company as a whole. Achieved these tasks by serving as member in data management team.
• DevelopedSASmacros for data cleaning and Reporting and to support routing processing.
• Performed Consumer profiling, Sales forecasting and testing of financial and business models.
• Connected to DB2 database and extracted the data using LIBNAME and processed the data using business logic to produce Reports.
• Extensively used theSAS/ Macro facility for automation process and to write weekly and monthly reports.
• Produced RTF, MSWORD and HTML formatted files usingSAS/ODS to produce ADHOC reports for presentation and further analysis.

Environment: SASV9.4,Excel,UNIX,Oracle,SAS/SQL,SSRS,SSIS,SAS/ODS,SAS/Graph,SAS/STAT,SAS/Macro,SAS/ACCESS,Oracle,XML,DB2,SAS/BASE,SAS/STAT, SAS/EG.

Confidential, Milwaukee, WI

SAS Programmer/ Analyst

Responsibilities:

• Provided logistic analysis to support critical business decisions of the management team, such as cost savings and efficiencies for domestic freight shipments and moving materials.
• Collected logistic data, defined core problems, recommended resolutions, and presented key information and thorough review of report data.
• Assisted in creating & enforcing SOPs for 3pls / service providers for execution
• Logistic Modeling i.e. Conduct Analytical studies through various reporting tools on forecasts, transit time, EDI, sourcing & volume trends etc and provide best solutions to company.
• Focus on and drive key performance indicators with 3PL’s to meet company objectives and goals
• Getting reports done by connecting to DB2 data base.
• Creating the SAS program to generate daily report for client.
• Maintain existing program. If some changes required the change the code.
• During new requirement, interaction with the client to gather the requirement.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Created complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Tested and debugged existing macros.
• Created SAS Customized Reports using the Data Null technique.
• Developed routine SAS macros to create tables and listings.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Used PROC REPORT to generate reports. Developed annual reports based on existing data.
• Imported data from excel sheet for analysis in SAS.
• Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.

Environment: Base SAS,DB2, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Reports, Windows XP professional.

Confidential, Long Beach, CA

SAS Clinical Programmer

Responsibilities:

• The project has safety and efficacy data that included different interventions of diabetic drugs in a random population.
• Generated effective methods and implement previously outlined analysis plans.
• CreatedSASBase,SAS/SQL,SAS/Macro,SAS/STAT datasets.
• Built easily maintainedSAScode to solve complex problems in the analysis and reporting clinical trial data and for the review, exchange, transformation, and submission of data
• Experience in data transforming and analyzing Case Report Form (CRF) data, use of Open CDISC validator.
• Involved in delivering output using ODS (Output Delivery system) and has experience in QC.
• Using the Statistical procedures like PROC UNIVARIATE,PROC FREQ,PROC CORR,PROC MEANS, PEOC REG and PROC ANOVA.
• Standardized CRF modules are optimized for specific clinical trials to improve the efficiency in database design, and the production of tables and listings.
• Good knowledge in different phases (phase I to IV) of clinical trials.
• Used Clinical trials data like Demographics (DM), Adverse Events(AE),Laboratory data(LB), Vital Signs(VS) Disposition (DS) and Medical history (MH) etc.
• Generated programming Tables, Listings of Phases I, II, III and IV clinical trial data; required in CSRs, safety reports, efficacy reports, EDC by SDTM and ADAM standards etc. ensuring on-time quality delivery.
• Generating annual safety reports, creating interim safety listings and analyzing which is a part of the company's risk management strategies.
• Experience in extract, transform and loading (ETL) data from different sources.
• Very good experience in analyzing Case Report Forms (CRF) data, Clinical Trials, Clinical Data Analysis, Validations and Documentation.
• Generated TLGs (Tables, Listings and Graphs) for different phases of clinical trials for FDA submission. Using SSRS generated parameterized reports .
• Importing and exporting raw data files in different formats (Excel, CSV, Tab).
• Extensive programming experience with PROC Freq, PROC Report, PROC Tabulate, PROC Transpose, PROC FORMAT and PROC INFORMAT.
• Generated final output’s in required formats (.Lst, Rtf, Html, Pdf) by using SAS/ODS. Tested and debugging existing MACROS.
• Performed different kind of rasformations using SSIS.
• Team coordination and willingness to learn.
• Responsible for assisting in the communication of study results via regulatory submissions, and manuscripts.
• Effectively translate statistical concepts and concerns to non-statistical audiences.

Environment: SAS/BASE,SQLserver, DB2, SSRS, SSIS, SAS/STAT, SDTM,SAS/SQL SAS/MACRO, SAS/ACCESS, Excel.

Confidential, Dallas, TX

SAS clinical Programmer

Responsibilities:

• Creating the SAS program to generate daily report for client.
• Maintain existing program. If some changes required the change the code.
• During new requirement, interaction with the client to gather the requirement.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Created complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Created SAS Customized Reports using the Data Null technique.
• Developed routine SAS macros to create tables and listings.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Data validation: data was validated before use the same for final analysis.
• Data analysis: the validated data was analyzed to get the following: market share find top customers for the target lists look for responsiveness of targets based on sales force effort
• Extensively used Arrays in SAS data steps. Merging datasets and manipulating Teradata datasets
• Extensively used SAS/Macro programming. Creating Unix scripts for file transfer and file manipulation
• Used PROC REPORT to generate reports. Developed annual reports based on existing data.
• Imported data from excel sheet for analysis in SAS.
• Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.

Environment: SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO,SAS/Graphs, SAS/Reports, Windows XP professional.

Confidential

Statistical Analyst

Responsibilities:

• Reading data from different sources like .csv, excel, tab delimited files.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Created datasets and generating reports using PROC REPORT, PROC SQL and MACROS.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports in PDF, RTF and HTML formats.
• Unnecessary data and duplicate were reported to client using data null.
• Code, and test SAS programs for the summarization, statistical analysis and reporting.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Compare the source data with historical data to get some statistical analysis.
• Perform transformations like Merge, Sort and Update to get the data in required format.
• Generate Reports in user required format by using ODS and PROC Report.
• SASdata sets are validated usingSASprocedures like Proc Means, Proc Frequency and Proc Univariate.
• Generated outputs with table of contents using ODS HTML.
• Prepared graphs using the modified data for business analysis.
• Creation of Data Sets on the Remote Server.
• Used shell programming to run weekly and monthly reports
• UsedSAS/ACCESS to gather data from RDBMS like TERADATA.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Maintained and enhanced existingSASreporting programs for marketing campaigns.
• MaintainedSASstatistical analysis for the products purchased every month.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO,SAS/ACCESS,SAS/ODS, MS Access, Excel, TERADATA.

Confidential

Jr.Databasedeveloper

Responsibilities:

• Hands on experience in interacting with end users to gather Requirements and created technical, user documentation.
• Install, Update, Configure and Maintain the MS SQL Server and alsostudied and designed the system
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• Accepts direction and requirements fromLead DB Developer and Business ProcessAnalyst.
• Converts business requirements into logicaldatabasedesigns.
• Creates databases using appropriate tools and security.
• Developed ETL packages using heterogeneousdatasources (SQL Server, Flat Files and Excel source files).
• Analyzes existing databases and recommends upgrading or re-engineering, as appropriate.
• In MS SQL Server2008 environment using SSRS developed reports.
• Parameterized reports using SSRS Drill through reports, Sub-Reports and Drill down reports.
• Loaded thedatainto destination tables by performing different kinds of transformations using SSIS.
• Create physical and logical databasemodels as per the business requirements and Maintaining, Backing-up and restoring data to prevent data loss.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.

Environment: Microsoft word, SQL, Excel, Power point, Microsoft windowsXP