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
• Experience in SAS/BASE, SAS/SQL, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS Enterprise Guide
• Experience in working with SAS ENTERPRISE GUIDE for reporting and analytical tasks.
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
• Hands on experience working with SAS Enterprise Guide, Information Map Studio, Data Integration Studio and Web Report Studio.
• Created complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO.
• Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE.
• Industry analytics experience using statistical analysis and predictive modeling
• Strong experience in coding using SQL, Procedures/Functions, SAS macros
• Hands on experience in using different Statistical tools such as SAS, 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
• Solid understanding and proficient use of various SAS procedures.
• 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
• SAP PM for Logility software implementation.
• Extensive experience in preparation of reports, tables, listings and graphs
• Demonstrated strong analytical skills and problem-solving skills with superior attention to detail

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 BI Tools: Data integration studio, Web report studio, OLAP cube studio, Information Map Studio, Delivery Portal, SAS Management Console, SAS Scoring Accelator

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
• Experiences using SAS Version 9 (especially the Business Intelligence Platform tools) SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Tomcat/ Apache.
• 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.
• Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/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
• Wrote SAS & SQL code for querying data from large datasets and extracted data from Oracle DB
• Merging SAS datasets using various SQL joins such as LEFT JOIN, RIGHT JOIN, INNER JOIN and FULL JOIN as well as using SAS procedures such as SET, MERGE, PROC APPEND etc

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

Confidential

Research Assistant

Responsibilities:

• Developed and tested mathematical models using SAS and Matlab and performed simulations
• Performed exploratory data analysis and applied the appropriate statistical method
• Held responsible for Creating complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO and data extraction, analysis and published results using SAS ENTERPRISE GUIDE.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Provided estimates for project work and detail resource plan for SAP ECC 6.0 CRM implementation utilizing SAP PPM 5.0.
• 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, SAS Enterprise Guide, SAS Web Report Studio, Matlab, Minitab, Maplesoft, SAP PM, 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
• Built SAS programs to perform Hypothesis testing, comparing independent& Paired groups
• 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
• Prepared an analyzed of costs and benefits for the management

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

Confidential, TX

Graduate Teaching & Research Assistant

Responsibilities:

• Executed advanced statistical techniques such as regression analysis, multivariate analysis, and categorical data analysis for numerous class projects
• 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