PROFESSIONAL SUMMARY:

• SAS® Certified Advanced Programmer on various platforms, including SAS® 9.2, SAS EBI. Extensive experience in SAS®/BASE, SAS®/MACRO, SAS®/SQL, SAS®/GRAPH, SAS®/ODS, SAS®/ACCESS, SAS®/IntrNet, and SAS®/STAT. Excellent in producing reports employing various SAS procedures and handling large databases to perform complex data manipulation, quality assurance and quality control
• 12+ years of experience working with Confidential and Pharmaceutical data from pharmaceutical company and various Confidential using SAS and JAVA
• 12+ years expertise in Database Programming and ETL (SQL, SQL - Plus, PL/SQL), and Data Management and Data Analysis in SQL Server, Oracle, Sybase, SAS, MS Access, and Excel.
• Over 7 years of experience with various data warehouse, data modeling and data mining
• Object-Oriented Professional Java programming and web development experiences using J2EE, JMS, JDBC, CORBA, LDAP, XML, JSP, DTD, XSL, DHTML, HTML, CSS, ASP, JavaScript, and iPlanet web server.
• Attention to details with strong quantitative and solid analytical, problem solving and strategic thinking skills, commit to high-quality deliverables, and personality growth with positive attitude while working well independently and in teams.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst/SAS Developer

Responsibilities:

• Support Confidential Food Safety and Inspection Service with Data Analysis Group mainly using SAS, SQL server and Sybase, etc., intensively worked on projects about Salmonella, E. coli and Lm, etc. pathogen data analysis, reports, tables, graphs and documentation creation; Created a lot of SAS Macro components and SAS program to simplify and consolidate SAS programs for various pathogen and residue data within Sybase and SQL server data warehouse by working closely with a group of SAS developer and Statistician.

Confidential

Data Analyst/SAS Developer

Responsibilities:

• Support a federal Confidential grants agency for Confidential - http://www. Confidential .hhs.gov), Health Workforce Statistics (HWS), UDS Performance Data, NCHS vital statistical data, ACS, Confidential, BLS, CMS, ARF, Census 2010 projects within HRSA Data warehouse team, in performing data acquisition, requirements and data analysis, and statistical analyses using SAS and MS Office on data provided in various formats and ETL with SQL server and stored procedures. Work closely with data owners and customers to identify/collect project requirements and data sources, data process and aggregation rules, and statistical analysis formula/rules.
• Perform task management work schedule, data preparation and manipulation, database model creation and update, database table and view structure create and update, database loading, database backup and restore, document edition and review, report and graph generation, final data QA/QC and delegation, web application task list and testing case documentation and testing. Diligently followed the rule of software product life cycle to perform the daily duties, provide proposal and solutions, and share knowledge cross the team and involved parties to ensure accurate and high-quality end product delivery with humble and grateful heart. Provide ad-hoc support to HDW data warehouse and OIT for various projects and Ad-hoc requests. Meet clients and stakeholders weekly. Work proactively with the clients and data owners to build a very positive relationship with clients with minimal supervision. SAS, SQL, SQL Server, Informatics and MS offices, etc. are mainly used.

Confidential

IT Statistician/SAS developer

Responsibilities:

• Supported the Division of Reproductive Health ( Confidential ) at Confidential for data manipulation, database management and statistical data analysis on several projects - Washington State pregnancy history data year, and Reproductive Health Survey Project for Eastern Europe countries, etc.. Propose and design the methodology for data cleaning and data processing, database creation and database management from various raw data files, such as text file, SPSS files, and raw SAS files; Design and develop SAS program to create analysis databases for longitudinal or hierarchical data analysis; Perform statistical analysis to predict the effects of Inter-Pregnancy Interval on birth outcomes, STD and Disease Prevention Intervention on Condom Use, using SAS/BASE, PROC SQL, SAS macros, SAS/STAT, and SUDAAN. Create documentation and results for presentation on weekly meeting with Senior Statistician, Epidemiologist and Confidential Scientists.

Confidential

Responsibilities:

• Confidential for state-specific population-based data. Responsible for weighting PRAMS data to generate weight variables in order to reflect an entire state’s population of women delivering a live-born infant; Simplified SAS macro programs to make it more robust and efficient using SAS; eliminated hundreds of comparison datasets and lines of code for fuzzy matching using PROC SQL; and reduced repetitive code for calculating weight variables with SAS MACRO. Investigated, documented and cleaned up over 60 SAS macro programs and hundreds of datasets; greatly improved the efficiency and readability of SAS programs, and it is much appreciated by direct supervisor and clients.

Confidential

Data analyst/SAS developer

Responsibilities:

• Supported a large international pharmaceutical corporation-Pfizer, and an undisclosed government agency with database design, data collection, database management, statistical data algorithms analysis, create flowchart diagrams, develop programs and macros, refine approaches to problems, merge multiple files and use array processing for data manipulation, perform quality assurance and quality control, and statistical modeling activities; Produced several Fact Books, including graphs, charts and tables using MS Office. Intensively used SAS/Base, SAS Macros, SAS DDE, SAS ODS, SAS/Stat, SAS/Graph, Proc SQL, SQL, MS Access, MS Excel, PowerPoint, and S-PLUS, etc. on data step processing, database management, data modeling, and web-based user interface to dynamically access analytical datasets with SQL Server 2000, ASP, JSP, JavaScript and HTML.
• Intensively work on projects that investigated differences in health characteristics, behavioral risks, and health insurance coverage of the U.S. population among different races, genders, and age groups, etc. Produce consolidated financial and statistical summaries outputs associated with prevalence of obesity, cancer and various conditions, distributions of risk groups, and medical costs associated with hospital stays and healthcare visits in the U.S. Examine trends and disparities in the health objectives over time and across socio-demographic groups, and prepare data. SAS®, Excel, HTML, and Graphical outputs from my programs contributed to the pharmaceutical company’s publishing a number of medical facts brochures and manuscripts on the topics listed above.
• Worked closely with statisticians, and provided extensively support to statistical analysis using Chi-square and/or logistic regression test for variable screening based on the significance of tested variables in multiple models. Created/modified macros shared across all models and created/updated SAS programs using logistic regression to test the significance of variables in different models, and generated summary table listing significant variables.
• Actively involve in redesigning the architecture and flowcharts, leading and overseeing the progress of the projects. Create/update task lists and project documentation. Provide extensive quality assurance and quality control for programs, results, and documentation. Demonstrate the ability to work independently with minimal supervision for high quality product, and function effectively in a fast-paced, multi-project team environment.

Confidential

Responsibilities:

• Software engineer Participated in the design and implementation of Confidential project to develop standards-based distributed object framework to interchange Confidential t information across federal healthcare enterprises for DOD, VHA, and IHS clinicians and other health care providers and to meet stringent security and privacy requirements (HIPPA). The Confidential receives CHCS HL7, PDTS and SADR data from EI/DS system and stores it in Oracle repositories and provides the means for VHA to request it.
• Designed and created SAS datasets from various data sources- Health Level Seven (HL7/CHCS) data, PDTS Pharmacy Data, and SADR (Standard Ambulatory) Data; developed SAS Programs/Macros to access and analyze health data and demographic data from different Oracle databases, flat files and Excel files, for HL7, PDTS and SADR data types; created SAS statistical analysis reports and presentation, and system performance statistics summary report for each data type and MTFs, using various procedures, SAS graph, and ODS, HTML, etc. Implemented data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases, and analyzed data using descriptive statistics, multivariate techniques, etc.
• Responsible for requirement analysis, detail design, develop and unit test CORBA-compliant JAVA components according to CORBAMED specifications (HL7, COAS, PIDS, TQS), implementing JDBC connection strategy for database connection check-in and checkout to serve the entire Confidential framework application services and administration web service, Java message services to deliver and handle XML, and/or object message through the system, and data services to communicate with ORACLE database. Automatically load HL7, PDTS, and SADR files into Confidential data repositories by Confidential framework from DOD, and retrieve Confidential t medical data through CORBA interfaces in VHA sites from Confidential framework. Also played a main role to gather user requirements, design web application architecture and workflow, implement the menu system for navigation, develop Java/JSP/HTML web pages to monitor and control Confidential framework activities, generate dynamic system statistics reports, and perform system analysis and web administration for Java web-based application on iPlanet web server.
• Intensively practiced object-oriented design methodology, JAVA, SAS, Oracle, JSP, and Access, etc. on various platforms. Designed and developed ORACLE database management system. Supported system integration test, test plan review and deployment of the deliverable software and documentation (SAS, Oracle, SQL, SQL-PLUS, Rational Rose, ClearQuest, ClearCase, JDBC/ODBC, J2EE, CORBA, SonicMQ, iPlanet, LDAP, XML, XSL, JSP, JavaScript, DHTML, FrontPage, JDeveloper, and UNIX Shell Scripting)

Confidential

Responsibilities:

• System Architect Designed and developed Internet computer tracking system, medical technology and equipment on-line quote and shopping system, and marine-call tracking system 3 internet web applications using three-tier architecture and JRun web server, designed, developed these Oracle database systems, and implemented user interfaces for data entry, editing, retrieval, formatting, and conversion, and present data using reports and statistical graphics. Intensively used SQL, SQL-Plus and PL/SQL programming in Oracle, and performed Oracle DBA activities like creating database, space management and security management. Designed and developed an Access Database and user interface application for Department of to input, query, and report all kinds of project fund applications, review ranking information, and project funding grant from local organizations around the country. Friendly user interfaces, reports and VBA code were generated with Microsoft Access 97.
• Confidential, Confidential Graduate Research Assistant Designed and developed web-based Electrocardiogram (ECG) viewer, integrated with OAS and PL/SQL based front-end middle tier on Windows NT, for an Oracle biomedical signal database system on HP-UX server. Developed programs to create various databases, developed a strategy to include control structures and conditional statements to meet the business rules for handling different ECG data format files, and created JAVA applet to dynamically display ECG signal on-line. It significantly increased the application for healthcare professional research and academic purpose (Oracle 8, PL/SQL, SQL, SQLPLUS, Java, JDBC, and SAS, Java, Swing, socket, and multiple threads, C/C++, TCP/IP protocols, Solaris UNIX, Oracle, SQL, PL/SQL, Access)

Confidential

Responsibilities:

• SAS programmer Responsible for statistical analysis of the Confidential ’s Compensation injury and illness treatment database system to create SAS programs, generate statistical reports and prepare documentation for Epidemiologist’s publications using SAS, JMP, and Microsoft suite software (Word, Excel, Access, etc.).

Confidential

Responsibilities:

• Graduate Research Assistant Developed a database system in support of the coal preparation and enhancement research project from Department of Energy using MS Access and Excel to process the laboratory research data, and analyze the test data to get statistics and regression reports by using JMP software. C/C++ language was used to simulate the separation process of fine coal product from the coal plant resources. The research project greatly upgrades the fine coal products from various coal plants and their environment.

Confidential

Responsibilities:

• Engineer Developed a MS Access database management system to access library resources, investigated and analyzed China fertilizer production and development status, to help the administrator in the Ministry of Chemical Industry to predict and determine the development direction and strategy for Chinese fertilizer and product development from Chemical Mines.