SUMMARY:

• More than 18 years SAS Developer (Professional programmer) and Statistician / Epidemiologist
• Public health, Clinical Trials for Pharmaceutical Industry, Healthcare service, Medical Research, Hospital Statistics, Banking & Financial field , Marketing Research, Sociological Research and College teaching.

PROFESSIONAL SKILLS:

SAS fields: PC SAS V6.2—V9.4, UNIX SAS V8, V9.1.3.1, 9.3, LinuxSAS9.3, IBM Z/OS SAS V9.1.3, SAS/BASE, SAS/STAT, SAS/ASSIST, SAS/ACCESS, SAS/ETS 9.1/HPF, SAS/QC, SAS/AF, SAS - MACRO, SAS-SQL, SAS/GRAPH, SAS/CONNECT and SAS/SHARE(SAS SERVER), SAS/Intranet, SAS BI (EG 4.3, Web Report studio, MS add-in, stored process, Enterprise Miner 6.2, ETL studio, DI application), SAS-DDE (write, read for deferent kind of document format), expert for SAS-ODS different MARKUP Resources (EXCELXP, TABLEEDITOR, MSOFFICE2K), SAS-Proc. Report, SAS/Graph (anno dataset proc greplay for dashboard), SAS/FSP and SAS/AF Frame with SCL, SAS-email and SAS-zip.

Related skill: SPSS 11.0, 13.0, SPSS Clementine, SAS JMP, Epi Info 6 and Epi Map, S-Plus, MS Excel., Java, JavaScript, data Warehouse (Olap, Erwin), Business intelligence tools (Olapcube, Cognos, Transformer) powerply, impromptu, Crystal Report 5.0, VFP6.0, FoxPro2.5, SQL (PL, Trans), PL-SQL, MS Access, JRview for Rave and OC.

Operating systems: UNIX (Sun Solaris), VAX, Win (XP Prof, 2000, NT4.), IBM Z/OS and OS390, FileZilla or FTP (for UNIX server) and Mainframe (JCL, COBOL, TSO), Reflection for UNIX, Linux OS (REDHAT).

Databases: Oracle 10g/9i, Medidata Rave, Oracle Clinical, SQL Server, Teradata, DB2, FoxPro database and data warehouse.

Statistical Methodologies: Statistical Analysis Plan, Experiment design, Sample size estimation, Data explore and distribution analysis, Data mining methods, Quantitative and Qualitative data analysis, Liner Model including and Multivariate analysis of variance like ANOVA, GLM, predictive model like Logistic regression, survival analysis including Kaplan-Meier function analysis, stepwise regression, Time Series / Forecasting model and nonlinear regression models like discrete choice and fraud prediction analysis, Factor pattern, Principal component Analysis, non-parameter Statistical analysis, statistical tables & graph design and Epidemiological methods like retrospective, prospective, case-control, Cohort and Intervention study.

EXPERIENCE:

Confidential, Harrisburg, PA

Sr. SAS Developer/SAS Programmer analyst/SAS FSP Programmer

Skills: LinuxSAS9.3, PCSAS 9.1.3, SAS/Base, SAS/AF, SAS/FSP, SAS-ODS, SAS-Macro, SAS/STAT, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/INTRNET, SAS/ASSIST, SAS/SHARE, Linux OS (REDHAT).

Responsibilities:

• Developed SAS AF and SCL to set up the new Frame and interface (SAS/AF) using Master/detail relationships method for customers for the new designed project ‘Significant deficiencies tracking’ from PADWIS application.
• Updated the violation program to add a group violation types based on the added contamination id, new criterion and some of functions from SCL for whole full screen application (SAS/FSP).
• Built the calculated 90th percentile program from sample file with new designed period for compliance monitoring report.
• Maintaining, rebuilding and updating the old program ‘Comp150 for Lead and Cupper’ for compliance monitoring report in huge and complicated SAS code (so far still work on it).
• Developed SAS standard reports format HTML, PDF and EXCEL with separated work books format output using SAS ODS technique.
• Developed SAS email with automatically writing and attach different kind of reports format to users directly from programs.
• Updated the huge flow chart map for the Comp150 program as part of project management, design and Improvement.
• Re-organized the old Comp150 program using recently SAS version skill according to a new design made by flow chart (still work on it).
• Developed the new SAS/FSP with two dataset for RTCR program, that use SAS update procedure to modify existing records in dataset.
• Developed the new SAS/AF Frame for RTCR assessment program from master/details way with two dataset and use the SAS update procedure to modify existing records for form viewer.
• Re built source frame from old class original component codes to current GUI frame.
• Maintain and fix current existing and using more than 20 routine programs for whole Pennsylvania area.

Confidential, Berlin, CT

Sr. SAS Programmer/BI Developer/Analyst

Skills: SAS9.2 BI for Unix environment (SAS Enterprise Guide 4.3, SAS DI Studio 4.2, SAS Web Report Studio, SAS MS Add-in, BI Dashboard 4.3, information Map studio, Information Delivery Portal, Base SAS, SAS Stat., SAS Graph, OLAP Studio, Enterprise Miner 6.2, SAS/ASSIST, Forecast Server 3.1), IBM Mainframe Z/OS and SAS 8.2( JCL, VSAM), database: DB2, Oracle. Statistics Methodology & Data mining ODS for different MARKUP Resources for report (Proc. report, Proc. tabulations and Proc. print), MS Access, and JavaScript.

Responsibilities:

• Transferred SAS code, row data and flat file from mainframe to UNIX environment.
• Compared extracted data from DB2 and oracle database using SAS comparison procedure and techniques.
• Built DI job for pulling out data and ETL area from oracle database.
• Re-built all projects and report using SAS Enterprise Guide project and stored process procedures.
• Set up new style report format to focus on PDF, multiple sheets excel files and dashboard report by ODS different MARKUP Resources.
• Made more complicated SAS code or SAS macro in E-guide program for some projects directly as scheduling jobs.
• Modified and review existing forecasting Models and build new one in UNIX platform.

Confidential, Groton, CT

Sr. SAS Statistical Programmer

Skills: Confidential system, Unix SAS V9.2, V8, PC SAS V9.2, SAS/Base, SAS/STAT, SAS/SQL, SAS-ODS, SAS-Macro, SAS/Graphand reporting system. Database including: MarketScan, i3, NHANES, NHIS, Pharmetrics.

Responsibilities:

• Put updated SAS dataset for tables into Confidential system.
• Updated Statistical Analysis Plan and table shells.
• Market analysis for Confidential using special server and database like MarketScan, Pharmetrics.
• Created Perceptive dataset and Value added dataset for report using different procedures like PROC MIXED, PROC LIFETEST, PROC PHREG, PROC ANOVA, PROC TTEST, PROC CORR.
• Generated efficacy related analysis datasets and transport files for Confidential submission by using XPORT option and PROC COPY.
• Validated subject summary tables, efficacy tables of sensitivity and specificity and ROC graphs.
• Set Functional Specifications, Test Plan (requestor specified portion), and LoT (programmer specified portion).
• Tested of new software/existing software used to produce requested data presentations.
• QC of data presentations and Changes to the original request.
• QC and generating analysis data sets, tables, listings ( Confidential ), summaries, exploratory data analysis, safety and efficacy reports using SAS.
• Worked for Algorithms and other required information.

Confidential, Franklin, TN

Sr. SAS Programmer analyst /SAS Developer

Skills: PC SAS V9.2, SAS/Base, SAS-ODS, SAS-Macro, SAS/STAT, SAS/ETS/HPF 9.1(PDLREG, MODEL), SAS/SQL, SAS/Graph (anno dataset proc greplay for dashboard), SAS/AF Frame and SCL, Cport and Cimport Transfer, SAS Web Report Studio, Enterprise Miner 5.3) and SAS EBI, DB2 database, Cognos9.

Responsibilities:

• Set up the Frame and interface for standard reports for customers companies using SAS AF and SCL for compliance financial report.
• Developed SAS/Intranet core and standard web-based reports format HTML, PDF and EXCEL format output by ODS.
• Built the SAS program for dashboard data picking up from four or five different source and more than 20 reports.
• Made the dashboard graphs using SAS for business analysis as reference for customer’s company’s strategic decision.
• Developed SAS projects for standard and ad-hoc reports for clients business analysis using.
• Set up different special reports or new design projects following business analysts.
• Made Statistics analysis project for Clients Company like predictive or forecasting model for financial companies.
• Analyzed and make SAS code around different banking accounts like cars, transactions, new open, kept, close or risk score, analysis and time period include cycles, month or special time analysis.
• Other skill for use including SAS BI, ETL method, Enterprise Miner and SQL server operating system.

Confidential, Thousand Oaks, CA

Sr. SAS Statistics programmer/SAS BI Developer

Skills: Unix SAS V9.1.3, V9.2, PC SAS V9.2, SAS9.2 BI (SAS Enterprise Guide, SAS DI Studio, SAS Web Report Studio, SAS MS Add-in), SAS/Base, SAS-ODS, SAS-Macro, SAS/SQL, SAS/Graph (anno dataset proc greplay for dashboard), SAS/STAT, UNIX, SQL server, Medidata Rave DB, Oracle Clinic DB, JRview for Rave and OC, Cognos9, Reflection for UNIX.

Responsibilities:

• Created documents for different BI procedure as non-SAS programmer user’s training or Systems user instructions.
• Made routine report from different Dept including UK, PA and other CA group using SAS BI, SAS base or SAS ODS.
• Developed dashboard graph report for Lab testing as different testing type and analytic item name.
• Developed BI Report using EG 4.2, Web Report studio, MS add-in, stored process.
• Picked up new request for report system from different studies, all of job including develop, testing, production and set up Cron job by scheduled time.
• Developed statistical methods as index in report for requestors.
• As lead SAS Programmer in charge all kink of report design, format, quality and correct results.
• Peer review for finished SAS code for other SAS Programmer.
• Prepared SAS INTRNET as latter’s reporting system reform as well to Ad hoc reporting.

Confidential, Camp Hill, PA

Sr. SAS Programmer Analyst

Skills: Unix SAS V9.1.3, V9.2, PC SAS V8.2, SAS/Base, SAS/Intranet, SAS-ODS, SAS-Macro, SAS/SQL, SAS/Graph (anno dataset proc greplay for dashboard), SAS/STAT, SAS/ETS, SAS/QC, UNIX, Mainframe (IBM Z/OS) and ( JCL, VSAM), Oracle, Teradata and DB2 database, Cognos9, Java, JavaScript, and SAS9 BI for client end (Enterprise Guide, Web Report Studio, SAS Add-in MO, ETL, DI, Dashboard) and SAS-ODS, Enterprise Miner for data mining and Statistics Methodology.

Responsibilities:

• Worked on online reporting system design, Healthcare researches, implementing project design, and data analysis, SAS coding, and setting up routine reports.
• Developed SAS/IntrNet core and standard web-based online reports output by Application Broker and WEBOUT function.
• Set up ODS multiple drills down method combined some optional function from SAS table editor.
• Used JavaScript method to set up report interface as application into hyperlinks for users.
• Developed metric dashboard report system as business evaluation by trend and bar graph analysis.
• Developed SAS9. BI project using EG, Web report studio and customized OLAP report from data warehouse.
• Set up the methods to pull out data as EDW operational Analytics from Oracle, Teradata, and DB2 database.
• Migrated from Unix SAS low version (V8) to higher version (V9.1.3).
• Developed Health insurance fraud detection analysis method for payment department as special project.
• Built Statistics predictive model for company’s business forecasting analysis by product’s codes, claims and cost.
• Developed the qualitative technique to set up forecasting model for volumetric inquires early warning system (view).
• Provided the critical and necessary analytic support for strategic initiatives within Healthcare Delivery Systems.
• Developed statistical methodology to build and maintain the indication system for metric as quality evaluation.
• Transferred SAS codes from UNIX system to Mainframe system.