SUMMARY

• Experienced Statistician/Analyst and Developer in the Healthcare and Financial Arena performing analysis, design, development, testing, risk analysis and implementation of Statistical models and applications
• Experience with Marketing and Banking fields, including predictive modelling using SAS 9.2, SAS Enterprise Miner and DI Studio.
• Experience working with EBI tools and the BI server.
• Experience in producing external files and reports employing various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Mean, Proc SQL.
• Experience working on EMR’s, CPT and ICD 9/10.
• Extensive SPSS knowledge and application skills.
• Expertise in Over 20 Statistical Testing Methods; and experience in SAS to read, Import and Export to another data file formats, including Delimited files, DBF, MDB and Spreadsheet files.
• Expertise in programming with SAS products such as SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/STAT, SAS/ACCESS, and SAS/GRAPH under Windows/Unix environment.
• Possess knowledge of job scheduling tool like Autosys.
• Experience in using SAS to read, Import and Export to another data file formats, including Delimited files, DBF, MDB and Spreadsheet files.
• Importing/exporting data files such as using SAS/ACCESS SQL Pass - Through Facility, LIBNAME, PROC IMPORT/EXPORT, PROC COPY, PROC CPORT, and Data Step programming
• Creating analysis datasets with SAS Macro, SQL, STAT, ODS, Graph and Annotate Facility, built-in or automatic Functions, Call routines, Data Step programming, and SAS Procedures.
• Debugging, Documenting, Validating, and Optimizing SAS programs for QC and QA.
• Excellent team player and self-starter with the ability to work independently and as part of a team, with great communication and interpersonal skills.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/Stat, SAS/Macros, SAS/Graph, SAS/AF, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/AF

Databases: Oracle 10g/9i/8i, MS Access, MS SQL Server 2005/2000/7.0

Development Languages: SQL, PL/SQL, Unix Shell Scripting, HTML

Operating Systems, Environments: Sun Solaris 9.0/8.0/7.0, IBM AIX, HP-UX 11i v2.0/1.6/1.5, Linux, Mainframe, WINDOWS NT/2000/XP

Data Modeling Tools: Erwin4.x/3.x

Other: MS Office, SQL

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

SAS Developer

Responsibilities:

• Worked in the Credit Risk Department for the validation of variables to be submitted to the Federal Govt.
• Generated statistical reports. Technologies like Oracle and SAS Enterprise Guide used for creating reports.
• 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.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Developed routine SAS macros to create tables, graphs and listings.
• Used Proc REPORT to generate reports. Developed annual reports based on existing data.
• Imported data from excel sheets 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 and/or ASCII files.
• Converted ORACLE data tables into SAS data files using SAS SQL ‘Pass Through Facility’.
• Developed SAS programs using Base SAS for tabulation counts, correlations and checked for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Created and implemented statistical analysis plans and specification documents, participated in database design, data collection guidelines, and logic checks.
• Applied generally accepted Programming Standards and Techniques to assure efficient program logic and data manipulation.

Environment: SAS Enterprise Guide, SAS 9.3, UNIX, SQL, ORACLE

Confidential, Houston, TX

SAS Data Developer/Analyst

Responsibilities:

• Project including post campaign analysis in marketing analysis and forecasting department.
• Build statistical predictive models by Proc logistic, validation, score and rank customers.
• Extract enrolments of Acquisition and Retention Campaign, Contract information, Renewal and Conversion data from large relational database Oracle.
• Write and test new SAS program codes and modify existing programs to run and create weekly various post campaign tracking reports to support production line.
• Post campaign analysis on enrolment, conversion rate, customer usage by channel and product.
• Compare, analyze campaign trends and research for useful findings.
• Manipulate data, perform analysis using Proc Means, Proc freq, Proc sort, Proc rank, Macro, Proc SQL, SAS data step as well as EXCEL.
• Ad-hoc queries and present results to manager and related groups.
• Used different Macro Facilities for program saving, reuse, and performance
• Directed SAS outputs to RTF, PDF and HTML files through Output Delivery System facility
• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Maintained the daily error log for cleaning the data.
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis. Presented numerical information in various formats.
• Performed statistical analysis, generated reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Report.
• Analyzed data with various statistical models using PROC GLM, PROC ANOVA, PROC MIXED.

Environment: SAS 9.2; SAS EBI tools, SAS BASE, MACRO, ACCESS, GRAPH, STAT, SQL, ODS, Oracle Database.

Confidential, Arlington Heights, IL

SAS Data Developer/Analyst

Responsibilities:

• Applied SAS/ACCESS SQL Pass-Through Facility and SAS/ACCESS LIBNAME statement to import data from Oracle database
• Team member working on the customized hospital resource management system, CPT and ICD codes, utilizing the SAS DI Studio, EG, Information Map Studio, Web Report Studio and Management Console in a client/server framework. Platforms included Oracle / Unix and Windows XP.
• Write SAS codes to create predictive modeling samples SAS data sets by merging data from multiple data sources analyse data trend, data manipulation use SAS, SQL.
• Predict target of marketing points of sales, initiative shipping and replenishment.
• Use SAS ODS, SAS Macro, Proc report, VBA Macro to create Weekly reports.
• Conduct Ad-hoc query by SAS, SQL, Excel, Access, modify and run large codes
• Performed descriptive and inferential statistics analysis and converted them to flat structure for convenient analysis with PROC TRANSPOSE and Array
• Used different Macro Facilities for program saving, reuse, and performance
• Directed SAS outputs to RTF, PDF and HTML files through Output Delivery System facility
• Cross-validate SAS programs authored by other SAS Developers 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.
• 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.
• Performed statistical analysis to assess risk and utilized statistical software like SPSS & SAS.
• Served as primary liaison between the technical team and the product team and end-users for the purpose of establishing a common understanding of requirements.

Environment: SAS 9.1 (Windows XP / UNIX); SAS EG,SAS DI Studio, SAS BASE, MACRO, ACCESS, GRAPH, STAT, SQL, ODS, Oracle Database.

Confidential, Columbia, MO

Data Developer/Data Analyst

Responsibilities:

• Wrote modular programs using SAS to analyze data and produce reports.
• Advised on survey design from data-analysis perspective.
• Wrote code for data-cleaning and logic-checking using Epi Info.
• Performed data analysis programming with complex data transformations in SAS and SPSS.
• Performed training and support for all aspects of computer use in international research.
• Assisted in developing a telehealth project for Antenatal care of women in rural areas of Missouri.
• Developed and implemented new ways for determining which diagnoses were pre-existing conditions and the environmental factors affecting individuals participating in the program.
• Created and maintained data management and statistical report programs.
• Created data sets from raw data sets for the analysis of safety and efficacy data using SAS to access remote clients.
• Generated interpretive summaries, charts, tables and listing reports in accordance with regulations including patient demography, reason of discontinuation, adverse events, vital signs and laboratory data.
• Drew conclusions based on analysis. Prepared manuscripts upon study completion, as well as various management reports related to clinical research.
• Prepare, document and test required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical reports and other similar reports.
• Ensure analysis data and programming code meet regulatory and company standards and are consistently structured to permit efficient programming and reporting.
• Assisted with analysis planning including review of table and listing mockups and analysis dataset requirements.
• Generated output files in text format HTML, RTF & PDF format using SAS ODS.
• Used SAS/Connect to access remote datasets.
• Worked closely with Statisticians, Data managers and Medical writers.

Environment: SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, PL/SQL, MS Office, Sync Sort, UNIX, Windows NT/2000.

Confidential

Developer and Data Analyst

Responsibilities:

• Principle data analyst and Developer of CROMA - a five year multiple cross-sectional and longitudinal cohort study of the prevalence and predictors of HIV infection among alcoholics entering treatment.
• Performed data analysis and graphics programming for a number of papers published by project alumni, including those from Brazil, France, China, Russia, and Indonesia.
• Provided onsite SAS/SPSS training in India.
• Provided training and support for all aspects of computer use in international research.
• Financial analysis designed & implemented using Excel.
• Association with the Targeted Intervention (T.I.) project studying the prevalence of HIV/AIDS and rate of conversion of STD to HIV/AIDS in the rural and semi-urban communities.
• Formulation and execution of projects and ensuring their smooth functioning with the whole team.
• Promotion of Education and Health and interaction with patients in the HIV/AIDS counseling center.

Environment: SAS, SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, PL/SQL, MS Office, UNIX, Windows NT/2000.

Confidential

Statistical Data Analyst

Responsibilities:

• Followed various meeting minutes, memos, and all other relevant documentations.
• Cleaned and merged verbatim text collected from CRF for data analysis.
• Automated complex table and listing formats and analytical routines with SAS Macros.
• Write more efficient programs with different types of SAS functions and call routines.
• Customized summary reports with powerful ODS options to enhance the output display.
• Maintained and tested SAS programs with SAS techniques such as defensive programming.
• Validated SAS programs using procedures and options such as PROC CONTENTS, PROC FREQ, PROC COMPARE, and MSGLEVEL.

Environment: SAS/Base, SAS/Access, SAS/Macro, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, PL/SQL, MS Office, UNIX, Windows NT/2000.