SUMMARY

• SAS/ Statistical programmer with over 7+ years of experience in data management, data analysis, and statistical modelling in various domains including Banking, Healthcare, Insurance, and Retail.
• Extensive experience in Statistical Analysis, and Reporting involving analysis, design, development, testing, and validating the applications.
• Data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.
• Extensive experience in SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS and SAS/SQL.
• Expertise in BASE SAS procedures like PROC SQL, PROC IMPORT/EXPORT, PROC PRINT, PROC SORT, PROC REPORT, PROC FORMAT/INFORMATS, PROC CONTENTS, PROC MEANS, PROC GCHART, PROC UNIVARIATE, PROC GPLOT and more.
• Creating new SAS programs using SAS/MACRO to improve ease and speed of modifications as well as consistency of results.
• Proficient in importing or extracting data by connecting SAS System to database systems such as Microsoft SQL, Oracle, Excel, flat files and exporting data to generate dynamic reports in HTML, RTF, XML, Excel, and PDF formats by using SAS/ODS.
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS Macro to improve ease and speed of modifications as well as consistency of results
• Knowledge in statistical analysis methods such as logistic regression, linear regression, t - test, ANOVA along with analyzing p-value generated from various statistical procedure.
• Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc. in marketing domain.
• Clear understanding of data modeling principles like star and snow-flake schema, dimensional data model etc.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Advance SQL skills with ability to code complex queries to load, clean, format, and store data.
• Excellent communication skills, a very good team player. Ability to work independently under minimum supervision, in a fast paced environment and under deadlines.

TECHNICAL SKILLS

Language: SQL, SAS, HTML, PHP, Python

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

SAS Tools: SAS9.1/ 9.2/9.3, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/STAT, SAS/VA

SAS Procedures: Proc Print, Gplot, Format, Freq, Means, Univariate, Report, Transpose, Summary, Tabulate, Sort.

Data Analytic Tools: -SAS 9, R, ACL, Tablaue, Excel (XL Miner)

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Data Analyst

Responsibilities:

• Generated statistical analysis files, summary tables, listings and graphs using SAS/BASE, SAS/GRAPH and SAS/STAT. used statistical modeling to forecast
• Optimization of Data extraction in SAS Financial models from different Data sources including DB2, Oracle, and MS SQL server.
• Extensively worked on SAS ODS to create customized excel templates on SASGRID to replace windows DDE.
• Program forecasting and variance analysis on a monthly, quarterly, and annual basis considering outlooks from one to ten years
• Created SAS macros for Data Science team to use across different financial models.
• Replaced back up process using SAS datasets, CSVs excel reports with Oracle (8i/9i) and MS SQL and MS access Database tables.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Created stored procedures on SQL server to use them in SAS programming.
• Test and debug analytical code.
• Implement a variety of analytical techniques, ranging from forecasting, to statistical modeling and numerical optimizations on a wide range of data sources.
• Coordinating offshore team on requirements analysis, configuration, testing of multiple SAS models and jobs.
• Supported in debugging Production issues and rerunning the failed jobs as needed.
• Created documentation and worked with SASGRID admins to deploy code from Development to QA and Production environments.
• Use SAS VA for data visualization.

Environment: SAS9.3, SAS9.4, SAS/ACCESS, SAS/BASE, SAS/SQL, SAS/Macro, SAS/Graph, SAS/CONNECT, SAS/ODS, SAS/VA, MS ACCESS, Oracle, UNIX.

Confidential, Salt Lake City, UT

Data Analyst

Responsibilities:

• Generated statistical analysis files, forecasting models, summary tables, listings and graphs using SAS/BASE, SAS/MACROS, SAS/GRAPH and SAS/STAT.
• Prepared new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Formats, and Functions..
• Defining, Manipulation, Controlling and Reporting/Storage of Clinical Data by using PROC SQL.
• Transformed SAS program result to SAS VA to visualize data and pprepared reports.
• Generated routine and ad-hoc reports using PROC PRINT, PROC FREQ and PROC REPORT.
• Generated required Charts, Graphs and reports using Proc REPORT, Proc GPLOT and SAS/Graph for graphical analysis.
• Developed and improved the efficiency of programs through the use of SAS macros.
• Used SAS/ODS facility to generate custom reports and thus directing SAS output to RTF, HTML and PDF files.
• Worked on extending SAS Enterprise Guide and Enterprise miner capabilities by developing customized add in programs
• Develop program specifications and design documents.
• Review ADS specs and output for own projects or other projects.
• Successfully moved data through multiple platforms by importing and exporting from and to external data sources like Excel, Access, Delimited files, PC files and Spreadsheets using Proc Import, Proc Sql and also Dynamic Data Exchange (DDE).
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.

Environment: SAS 9.3, SAS/ Base, SAS/ Macro, SAS/Access, SAS/Connect, SAS/Graph, SAS/Stat, SAS/VA, Excel, Word, Windows 2000 Server, UNIX.

Confidential, Dearborn, MI

SAS Programmer

Responsibilities:

• Utilized SAS/ACCESS to extract data from Oracle and other relational databases for analysis
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE and PROC SORT
• Tested and debugged existing MACROS
• Extensively used PROC REPORT and PROC TABULATE to create reports
• Generated safety tables, which also involved in analyzing data and generating Reports
• Created reports using the DATA NULL and the PROC REPORT for the submission as per the regulations and company standards
• Validated SAS data sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE
• Formatted HTML, RTF and PDF reports using SAS output delivery system ODS
• Worked with automation team to automate the reports using SAS/DDE and VB macros.
• Performed quality control checks on tables, listing etc generated by other team members.

Environment: SAS9.3, SAS/BASE, SAS/MACRO, SAS/Access, Enterprise Guide, SAS/STAT, MS-Excel, Visio, ORACLE, Windows 7.

Confidential, Philadelphia, PA

SAS Data Analyst

Responsibilities:

• Developed automated reporting processes from existing reports taking into consideration regulatory reporting compliance and internal partner requirements.
• Involved in Extensive coding in base SAS (including Creating Derived Datasets, Tables to produce desired output format, analysis Datasets, Tables, Listing.)
• Importing data from different file formats and creating datasets to get desired output using Import procedure.
• Developed fully automated SAS programs on a UNIX Platform utilizing MS Excel as the output product.
• Sorting the data and deleting duplicates by using procedures like PROC SORT in order to produce quality results
• Developed Excel and PDF formatted files using SASODS to produce ad-hoc reports for presentation and further analysis.
• Creating SAS code to clean the invalid data using SAS Macros and SQL procedure. .
• Developed SAS programs to format the data for understanding and used various validation techniques such as proc summary, proc means, and other data step techniques.
• Developed SAS Customized Reports using REPORT, TABULATE procedures and DATA NULL .
• Generated the reports in desired output format (HTML, PDF and RTF format files) for decision making using SASODS (OUTPUT DELIVERY SYSTEM).

Environment: SAS9.2, SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/ODS, UNIX, MS Access, Excel

Confidential, New York NY

SAS Programmer

Responsibilities:

• Developed complex SQL queries using various joins and developed various dynamic SQL(Sub queries and Join conditions, correlated sub queries)
• Gathered requirements on ongoing projects
• Developed SAS codes as per the requirement.
• Designed SAS Macros which can be generalized for Organizational Use
• Ensured Data Quality and Data Integrity
• Prepared QC documents (Test Plan and PRN).
• Created Adhoc reports as per statistician requirements.
• Generated output in various formatted files such as Excel sheets, RTF, and HTML using SAS/ODS
• Documentation of development code and the test cases involved.
• Designed, developed, and conducted unit test plans to ensure application code is functioning correctly.

Environment: SAS9.2, SAS/SQL, SAS Macros, SAS/ODS, PROC MEANS, SAS/BASE, SAS/STAT, Windows XP.

Confidential

SAS Programmer

Responsibilities:

• Involved in writing, analyzing, and presenting of clinical trial reports for Phase I and Phase II of clinical trials.
• Accessed SAS clinical tables using SAS Access facility to connect to Abbott’s oracle database.
• Performed Edit check programming to identify potential data issues and conducted data validations as per data dictionary guidelines.
• Used BASE SAS to perform sorting, indexing, merging of the datasets.
• Worked on data analysis, statistical analysis and generated Reports, Listings and Graphs using BASE SAS and SAS procedures such as PROC SUMMARY, PROC TABULATE, PROC FREQ, PROC SG-PLOT, PROC PLOT, and ODS procedure.
• Transformed existing raw data into standardized CDISC SDTM/ADaM domain datasets using various SAS procedures.
• Extensively used SAS/MACRO facility to provide reusable programs that can be conveniently used time to time and created tables, graphs and listing reports.
• Prepared/reviewed protocol documents, case report forms, annotated CRF, and statistical analysis plans for clinical trials.
• Worked with different CDISC data models such as SDTM, ADaM, and Define. Xml.
• Provided SAS programming support to Statisticians, Data Managers, and the Medical Writers to develop reports.
• Generate Ad hoc statistical analysis Reports/Listings as required.
• Generated Integrated Summary of Efficacy (ISE) and Integrated Summary of Safety (ISS).
• Responsible for writing and debugging statistical programming and documented programming
• Develop SAS programs for ad hoc tables and listings.
• Integrated with Clinical, Regulatory and Data Management colleagues to coordinate collection and reporting of clinical studies.
• Experience in the development and review of SAS programs for management and reporting of clinical trial data.
• Accessed External Excel files, Stored and Retrieved SAS data sets moving data through multi platforms.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/ODS, SAS/STAT, Windows XP, MS ACCESS, Excel.