CURRICULUM VITAE

Looking for a SAS programmer / statistician position that utilizes my analytical skills and enables me to make a positive contribution.

Summary of qualification:

• More than 7 years of working experience in data analysis, computer programming and database system administration. More than 6 years of extensive working experience in SAS programming and data analysis.
• Certified Advanced Programmer and BASE SAS Programmer with expertise in SAS8.0, SAS9.1.3, SAS9.2 STAT, SQL, MACRO, GRAPH, ODS and UNIX , STAT10.0, SPSS, MS-Excel, MS/ACCESS.
• Double Master Degrees in Applied Statistics and Computer Science with experience in statistical modeling, ANOVA/MANOVA, regression analysis, logistic regression, time series analysis, survival analysis, and nonparametric analysis Experienced in manipulating medical-insurance claim data, clinic-trial data, Categorical Data Analysis, longitudinal and cross-sectional data Power analysis and sample size calculation.
• Experienced in statistics modeling and analysis: FREQ, LOGISTIC, GLM, PHREG, GENMOD, CATMOD, MIXED, ARIMA.
• Extensive experience in designing, developing and testing of applications, reports and models in SAS.
• Extensive experience in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/INSIGHT, SAS/ANALYST, SAS/ODS, and SAS/GCHART.
• Extensive experience in importing various external data files into SAS Dataset / SAS library by SAS/INFILE, SAS/IMPORT, SAS/SQL, and SAS/ACCESS.
• Proficient of connecting SAS System with database systems, such as Microsoft SQL and Oracle, to retrieve data and create SAS data sets.
• Excellent experience in exporting SAS results to different formats, such as HTML, Excel, and PDF by using SAS/ODS for report and presentation
• Expertise in clinical data analysis in Biological/Pharmaceutical, clinical data management, and healthcare industries.
• Excellent presentation skills using Microsoft PowerPoint, SAS Table, SAS Graph, and SAS Chart.
• Solid background and formal education in statistics modeling, experimental design, and other statistics concepts.
• Proficient with SQL, C, VB programming languages.
• Extensive experience in Microsoft Office suite, including Microsoft Word, Excel, Access, PowerPoint, and Outlook.
• Excellent organizational, teamwork, presentation and interpersonal skills
• Applying critical thinking, problem solving, and decision making skills to dismantle complex problems and optimize solutions.

Computer Skills

SAS: SAS Certified Base Programmer, SAS Certified Advanced Programmer

• SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/INSIGHT, SAS/REPORT, SAS/TABULATE, SAS/Access.
• Operating Systems: Windows Microsoft Certified System Engineer , UNIX, LINUX.
• Programming Languages: SQL, C, VB, and Pascal.
• Database: Oracle9i, DB2, FoxBASE, Debase MS Access.
• Software: MS Word, MS Excel, MS PowerPoint, MS Access, Adobe Photoshop, STATA SPSS.

Professional Experience:

Title: Senior SAS consultant/Programmer

Confidential

Worked on the following SAS Applications Capital Reporting, Actuals Reporting project, Costing, Consolidated Forecasting Application Reporting, Written SAS Scripts for the Applications based upon the business requirements. Created Assessment, Monthly, Quarterly, Volume Trend, Cost Trend, P L Reports for the Customers using SAS Reports and Macros. The data warehouse is built to track and analyze the sales and distribution logistics of the different lines of business across the company.

Responsibilities:

• Wrote SAS code using SAS/Base and SAS/Macros to import data from external data files, such as Excel, Access, and Oracle.
• Gathering Business Requirements from the users. Converting Business Requirements into Technical Specifications.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Created datasets and generated reports using PROC Tabulate, PROC Report, Data Null, SAS arrays, PROC SQL and Macros.
• Analyzed large data sets consisting of million records, created complex SQL queries to access database, as per the business requirements.
• Developed, modified, validated and implemented SAS programming work according to Statistical Analysis Plan SAP .
• Prepared efficacy and safety summary results with tables, data listings, graphs/box plots and reports.
• Cross-validate SAS programs authored by other SAS programmers as a part of quality assurance.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance using PROC REG, PROC CORR, PROC GLM, PROC ANOVA.
• Performed statistical analysis, generate reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
• Produced customized reports by using TABULATE, REPORT, and SUMMARY, provide descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE
• Analyzed data with various statistical models using PROC GLM, PROC ANOVA, PROC MIXED.
• Developed SAS macros for data cleaning and Reporting and to support routing processing
• Developed and maintained general-purpose SAS programs/Macros for the validation, Extraction, Presentation, manipulation, analysis, and reporting
• Use SAS to analyze data, statistical tables, produce listings and graphs for reports
• Formated HTML PDF and RTF reports, using SAS - output delivery system ODS
• Developed and implemented complex oracle SQL, PL/SQL script to import data.

Title: SAS programmer

Confidential

Responsibilities:

• Wrote SAS code using SAS/Base and SAS/Macros to import data from external data files, such as Excel, Access, and Oracle.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Created datasets and generated reports using PROC Tabulate, PROC Report, Data Null, SAS arrays, PROC SQL and Macros.
• Prepared efficacy and safety summary results with tables, data listings, graphs/box plots and reports.
• Cross-validate SAS programs authored by other SAS programmers as a part of quality assurance.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance using PROC REG, PROC CORR, PROC GLM, PROC ANOVA.
• Performed statistical analysis, generate reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
• Produced customized reports by using TABULATE, REPORT, and SUMMARY, provide descriptive statistics using PROC MEANS, PROC FREQ, and PROC UNIVARIATE
• Analyzed data with various statistical models using PROC GLM, PROC ANOVA, PROC MIXED.
• Developed SAS macros for data cleaning and Reporting and to support routing processing
• Developed and maintained general-purpose SAS programs/Macros for the validation, Extraction, Presentation, manipulation, analysis, and reporting
• Use SAS to analyze data, statistical tables, produce listings and graphs for reports
• Formated HTML PDF and RTF reports, using SAS - output delivery system ODS
• Developed and implemented complex oracle SQL, PL/SQL script to import data.
• Documented SAS code and design reports

Title: Data Analyst

Confidential

Responsibilities:

• Maintained large data sets combining data from various sources in varying formats using SAS/ACCESS to create SAS data sets
• Created complex SQL queries to access ORACLE database
• Generated datasets needed for statistical analysis using Set and Merge
• Created SAS data sets for analysis, performed data quality checks, validation, mapping and preparation
• Used SAS extensively for data step manipulation, data correction and data cleaning
• Created mockup table and listings for statistical analysis
• Designed correlation computation, hypothesis test, and regression model construction
• Performed data analysis using SAS statistical procedures such as MEANS, GLM, REG, LOGISTICS, ANOVA, CORR, UNIVARIATE and others to create output datasets
• Used statistical methods to analyze the consumer behavior, segment targeted customers, and identify the customer groups that generate the greatest returns for the retailer using the customer databases
• Involved in writing/modifying existing SAS programs to perform statistical analysis, and prepare summarization
• Exclusively used Macro facility for ad hoc jobs
• Provided programming support, utilized and modified standard programs to generate statistical analysis database, data displays, listings, summary, tables, graphs and reports for presentation of results in compliance with relevant SOPs
• Generated ad-hoc and quality customized reports using PROC REPORT, PROC TABULATE, PROC SQL and PROC SUMMARY
• Used SAS/ODS to create HTML, RTF and PDF outputs files in the process of generating reports Developed and maintained SAS macros for use across studies

Title: Senior Business Analyst

Confidential

Responsibilities:

• Forecasted demography and electricity development of major cities in northeast China performed electric resource supply and demand analysis to support the development conducted electric power system construction planning for Jilin province.
• Developed models to predict electricity demand and economic changes use AMOS to develop electricity construction suitable development model analyzed whole province electric system product, business and management data and generated various statistical reports using SAS, SPSS, STAT and MS Excel. Marketing analysis, Investment analysis, customer satisfaction surveys and analysis. Designed questionnaires and sampling procedures and supervised collection of the data, data analysis, and research reports.
• Worked on Data Cleaning and Statistical techniques like Regression Estimates, Time Series Analysis and Cohort Analysis.
• Created customized reports for Census reports using SAS/BASE, SAS/MACROS, SAS/ODS, STAT, SPSS and Excel.

Title:SAS Statistician

Confidential

Responsibilities:

• Conducted competitive analysis for product to identify key Customer behaviors, patterns for Behavior-based advertising and the profit forecast. Customer opinion surveys and analysis.
• Performed advanced data manipulation as well as SAS modeling drop/keep variables, sort, merge, concatenate/join files, etc. proc REG, proc GLM, proc FREQ, proc ANOVA, proc LOGISTIC, proc TABULATE, proc REPORT imputed missing data, performed time series analysis.
• Created customized reports for Census reports using SAS/BASE, SAS/MACROS, SAS/ODS, STAT, SPSS and Excel.
• Presented qualitative data in form of Graphs, Tables and Charts. Statistical analysis of product sales, performance of sales department, regional sales, monthly, quarterly and yearly sales reports. Used the biostatistics software GraphPad Prism to do statistics, curve fitting nonlinear regression and scientific graphing.
• Conducted in-depth data analysis using traditional Cross tabulations and advanced multivariate techniques. Manipulated medical test data, modeling and analysis Transfered and migrated data from one platform to another

Title: Database manager

Confidential

Responsibilities:

• Performed several data analytical tasks. Analyzed technology data and generated various statistical reports using SPSS, MS Access and Excel.
• Developed Oracle database including analysis, design and odeling created tables, constraints, indexes, views, sequences, triggers, stored procedures tuned SQL statements. MS Visual Basic was used for user interface, MS Access SQL Server was used as a back-end database.
• Used Dynamic Data Exchange DDE feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports and Graphs.
• Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets.
• Created SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Prepared graphs using the modified data for business analysis.