SUMMARY

• Over 10+ years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects
• Data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis, data validations, and data triangulations
• Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH, SAS/IML, SAS Enterprise Guide
• Experience in pharmaceutical and medical data statistics
• Strong experience in coding using SQL, Procedures/Functions, SAS macros
• Hands on experience in using different Statistical tools such asSAS, IBM SPSS, Minitab, R
• Excellent background in general linear models, categorical data analysis, survival analysis, multivariate analysis,design of experiments, randomized trial designs and survey design and analysis, Principal component analysis, as well as creating SAS datasets, debugging programs, and documentation
• Generated reports using PROC REPORT, and PROC TABULATE for customized report writing.
• Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel, Pivot tables and SAS on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows
• Experience in creating SAS programs for EDIT CHECKS and performed data validation on raw data sets and created data set for analysis
• Extensive experience in preparation of reports, tables, listings and graphs
• Experience in advanced statistical analysis, predictive modeling in Banking

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/Macros, SAS/STAT, SAS/ETS, SAS/Access, SAS/AF, SAS/IML, SAS/SQL, SAS AF Frame, SAS Enterprise Guide, SAS Web Report Studio

Programming: SAS, R, Matlab, Visual Basic SQL, PL/SQL and Unix

DBMS: Oracle 11g/10g/9i, SQL Server, Microsoft Access, ArcGIS Server

Operating Systems: Unix, Windows 3.1, Win NT 4.0, Windows 2000/XP/7, MS-DOS

MS Office suite: MS word, MS PowerPoint, MS Excel

PROFESSIONAL EXPERIENCE

Confidential

Statistical Application Analyst

Responsibilities:

• Developed, debugged, and validated the project specific SAS programs to generate derived SAS datasets, summary tables, and data listings in accordance with departmental standards
• Performed statistical analysis using SAS and R
• Responsible for loading, extracting and validation of client data
• Analyzing raw data, drawing conclusions & developing recommendations
• Writing SQL scripts to manipulate data for data loads and extracts.
• CreatedSASdataset from tables in Database usingSAS/Access and Retrieved the Sales data from flat files, oracle database and converted toSASdata sets for Analysis usingSAS/STAT procedures
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Performed data step manipulations for data quality assurance/validation of table, listing and summaries
• WroteSAS& SQL code for querying data from large datasets and extracted data from Oracle DB
• MergingSASdatasets using various SQL joins such as LEFT JOIN, RIGHT JOIN, INNER JOIN and FULL JOIN as well as usingSASprocedures such as SET, MERGE, PROC APPEND etc

Environment: SAS9.4, SAS/SQL,SASMacro,SAS/ACCESS, SAS/STAT, SAS/SCL, SAS/ODS, SAS/Graph, UNIX, SAS Enterprise Miner, SAS Enterprise Guide R, Windows 7, MS SQL Server, MS office

Confidential

Research Assistant

Responsibilities:

• Developed and tested mathematical models using SAS and Matlab and performed simulations
• Performed data analysis for medical data and pharmaceutical data
• Design and developed programing codes for chemical Langevin equation
• Performed stochastic metabolic control analysis of insulin signaling pathways
• Created analysis datasets, summary tables, listings and plots
• Extensively worked on PROC REPORT and PROC TABULATE to produce reports for the purpose of validation

Environment: SAS 9.2, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, SAS/Graph, UNIX, SAS Enterprise Miner, R, Matlab, Minitab, Maplesoft, Windows 7, MS SQL Server, MS office

Confidential

Statistical Analyst/SAS Programmer

Responsibilities:

• Performed exploratory data analysis, tested and applied the statistical method to perform analyses
• Implemented time series risk models for the economic capital estimation and stress testing
• Conducted and performed surveys by applying sampling techniques and counting responses
• Evaluated reliability of source information by weighting raw data and organized results for analysis
• Programmed, tested, and documentation of statistical programs for use in creating statistical tables
• Prepared and created conclusions and forecasts by analyzing and interpreting data summaries
• Oversaw the installation and configuration of new SAS software and other software systems
• Worked as an analyst at two SAS Fraud projects

Environment: SAS9.2, SAS/STAT, UNIX, R, Matlab, Minitab, Windows XP, MS SQL Server, MS office

Confidential, TX

Graduate Teaching & Research Assistant

Responsibilities:

• Developed regression models for class projects
• Worked with existing data sets, generated hypotheses, conducted statistical analyses using SAS
• Conducted complex data management and analysis with large complicated datasets
• Delivered clear and succinct graphical presentations of data
• Designed and developed GUI interfaces by using SAS AF/Frame
• Produced data listings, summary tables and graphics for interim and final analyses and publications
• Taught Statistics and Developmental Mathematics course for undergraduate students

Environment: SAS9.1, SAS/ACCESS, SAS/STAT, SAS/IML, UNIX, Matlab, Minitab, Windows XP, MS office