Harry Yeh

(US Citizen)

631-***-****

ac2fcf@r.postjobfree.com

SAS Programmer / Statistical Data Manager

Over 18 years of experience with strong emphasis on design, analysis, and development and implementation of all kinds of Analytical Data Management systems for various industry raging from Investment Banking, Retail Banking, Financial, Credit Card, Mortgage, Clinical Trial, Pharmaceutical, Biotechnology, Healthcare, Insurance, and Telecomm etc. Expertise includes design and development of variety of application, analysis, reporting, and data management

Worked for financial companies like JP Morgan Chase, Citi Group, Dow Jones, Prudential Investment, First USA Bank, Bank One, GMAC and many small financial institutes.

Worked for pharmaceutical / healthcare companies like Johnson & Johnson, Merck & Co., Schering-Plough, Bristol-Myers Squibb, and EmblemHealth.

BASIC QUALIFICATIONS

Extensive experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, SAS/ODS, SAS/CONNECT, SAS/SHARE, SAS/EG, SAS/AF, SAS/ETS, SAS/MDDB in Windows / UNIX / VAX / Mainframe (TSO) environments

Thorough knowledge of advanced SAS/STAT procedures including ANOVA, Categorical Data Analysis, Survival Analysis, Logistic Regression, Repeated Measurement Analysis, Sampling, and Data modeling

Expertise in generating listing, table and graph of Efficacy/AE/DEMO/VITAL/ LAB by employing SAS procedures, Merge, Proc Transpose, Proc Format, Proc Summary, Proc Means, Proc Freq,Proc Report, Proc G-plot, Proc Box plot and Proc G-chart

Hands on experience and excellent knowledge of Clinical Trial research methodologies, CRT dataset creation, CDISC, Med DRA, ICH, GCP, NDA, IND, 21CFR PART 11 Rules and Regulations, ISS and ISE for NDA submission to FDA

Good understanding of clinical trial protocols, SAP (Statistical Analysis Plan), SOP (Standard Operating Procedure) and CRF (Case Report Form).

Working knowledge of clinical trials data in domains such as Demographic data (DM), Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Medical History (MH) and Vital Signs (VS).

Familiar with ICH, FDA and CDISC regulations and guidelines such as 21 CFR-Part 11, E3, E6 and E9.

Working knowledge of CDISC standards including models SDTM, ADaM and ODM.

Experience in creating and validating Safety (ISS) and Efficacy (ISE) tables, figures and listings (TFL).

Experience in producing RTF, PDF, HTML files using SAS ODS facility.

Excellent communication skills, detail oriented, delivery on time, hard-working and team player.

Experienced in statistics modeling and analysis: FREQ, LOGISTIC, GLM, PHREG, GENMOD, MIXED

Extensive experience in designing, developing and testing of applications, reports and models in SAS

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

TECHNICAL SKILLS

SAS:

SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/EG, SAS/ETS, SAS/IML, SAS/EIS, SAS/AF, SAS/ACCESS, SAS/CONNECT, SAS/SHARE, SAS/MDDB

Language:

Splus, SPSS, Visual Basic, Unix Shell script, MOTIF, VAX DCL, JCL, CLIST.

Database:

ORACLE, SYBASE, Microsoft SQL Server, DB2, UDB, Teradata, INFORMIX XPS, Microsoft ACCESS, IDMS, INQUIRE.

Modeling Tool:

Designer, ERWin, RationalRose, PowerDesigner.

Data Mining:

SAS Enterprise Mining, BusinessObjects Business Miner.

Platform and Server:

UNIX (and derivatives), Linux, MS Windows Server, MVS/TSO, VAX/VMS, OpenVMS, CMS, Apache, BEA Weblogic Server Enterprise, Microsoft IIS, Site Server.

Data Quality:

Trillium, SSA, SAS, DataStage.

Hardware:

SUN, HP, IBM Mainframe, IBM RS, DEC VAX, DEC Alpha, Intel.

POFESSIONAL EXPERIENCE

Citigroup 01/16 – Present

Sr. Data Manager / SAS Tech Lead

Developed and architected SAS data integration subsystems to support CCAR and Stress Testing, DFAST, PPNR enterprise risk / compliance reporting systems.

Conducted data quality checking and data cleansing tasks as part of Data Steward Process.

Developed Data Dictionary and Master Data Standard to support Data Governance.

Developed data access SAS modules to integrate enterprise data from various sources including Oracle, SQL Server, Sybase, DB2, Teradata, MongoDB, Hadoop, SAS.

Designed and architected API packages with SAS/ACCESS and SAS/SQL to support MRMS (Model Risk Management System).

EmblemHealth 09/14 – 12/15

Sr. SAS Programmer

Developed SAS ETL process to support Data Warehousing System with source data from FACETS and other systems.

Developed data cleansing and data reconciliation process in SAS/SQL and SAS/MACRO.

Conducted daily data steward meeting.

Developed Data Governance Process and Reference Data Standard.

Developed SAS reporting system to monitor the daily data warehouse process.

Conducted performance tuning and process optimization for the SAS ETL process.

JP Morgan Chase 09/12 – 08/14

Sr. SAS Tech Lead

Developed marketing data warehousing system to support customer prospecting and marketing campaign.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Oncology Center, UPMC 07/11 - 09/12

SAS Data Warehouse Technical Lead

PATHWAY portal Architect for full-cycle design and deployment of the NDA data warehouse.

Evaluated and selected hardware, DBMS, OLAP and ETL tools.

Deployed meta-data repository for Designer2000 models and star schema meta-data.

Deployed Oracle Express Web to provide OLAP capabilities on intranet.

Developed data mapping to import clinical data via SAS CDISC SDTM, ADaM, and ODM.

Developed data export process via SAS CDISC SDTM, ADaM, and ODM.

Environment: HP, NT, Oracle8, Oracle Express Server 6.2, Oracle Express Web Agent, SAS.

Merck & Co. 02/10 - 07/11

SAS Data Warehouse Tech Lead

Participated in the Corporate Data Warehousing System initiative.

Conducted project scope analysis and user requirements analysis.

Designed virtual warehouse structure integrated with Enterprise Portal.

Developed dimensional models and aggregations for DSS.

Developed data mapping to map clinical data to CDISC SDTM, ADaM, and ODM standard.

Evaluated and selected hardware, DBMS, OLAP and extraction tools.

Developed various prototypes and demos for different warehouse strategies.

Conducted candidate review, phone screening and in person interview.

Environment: IBM RS/6000, HP, NT, Teradata, Oracle8i, Informatica, Microstrategy DSS Suite, Trillium, SAS.

Doingwap Corp. 11/07 – 02/10

Sr. SAS Tech Lead

Wrote SAS code using SAS/Base and SAS/Macros to import data from external data files, such as Excel, Access, and Oracle.

Worked on QC of table listing and graph created by other programmers.

Maintained study documentation and issue log.

Gathering Business Requirements from the users. Converting Business Requirements into Technical Specifications.

Import data using SAS Proc CDISC SDTM, to input clinical data,

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, 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).

Schering-Plough 08/06 - 11/07

SAS Data Warehouse Technical Lead

Architect for full-cycle design and deployment of the NDA data warehouse.

Evaluated and selected hardware, DBMS, OLAP and ETL tools.

Deployed meta-data repository for Designer2000 models and star schema meta-data.

Deployed Oracle Express Web to provide OLAP capabilities on intranet.

Environment: HP, NT, Oracle8, Oracle Express Server 6.2, Oracle Express Web Agent, SAS.

GMAC 01/05 – 08/06

Sr. SAS Tech Lead

Developed marketing data warehousing system to support customer prospecting and marketing.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Johnson & Johnson 11/02 - 12/04

Senior Database Developer

Developed a NDA Data Entry System using ORACLE FOARM, SAS/AF/FSP, SCL, MACRO.

Developed data transformation process between third party database and ORACLE.

Developed an automated process package that creates FDA submission files.

Environment: VAX/VMS, DCL, Oracle, Oracle Form, PL/SQL Stored Procedures, SAS.

Nestle USA 04/01 – 11/02

Sr. SAS Data Architect

Developed data warehousing system to support database marketing and customer retention.

Used SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Managed meta data dictionary using SAS utilities.

Developed data export procedure and SAS routines to support enterprise data distribution.

JP Morgan Chase 05/00 – 04/01

Sr. SAS Data Architect

Developed enterprise data warehousing system to support OLAP reporting and enterprise business intelligence including data mining.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Hewlett-Packard 08/99 – 05/00

Sr. SAS Data Architect/Tech Lead

Developed marketing data warehousing system to support customer prospecting and marketing.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Harmonic Communications 02/98 – 08/99

Lead SAS Data Architect

Developed marketing data warehousing system to support customer prospecting and marketing.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Telephia 07/97 – 02/98

SAS Data Warehouse Tech Lead

Developed marketing data warehousing system to support customer prospecting and marketing.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

JP Morgan Chase 01/96 - 07/97

Sr. SAS Data Architect

Developed marketing data warehousing system to support customer prospecting and marketing.

Designed and developed SAS data mining process to discover KPI related customer attributes.

Developed SAS data access routines to support ETL process to get data from various sources.

Conducted data quality checking and data cleansing process to ensure data accuracy.

Designed and created various SAS data reports base on business requirements.

Developed standard meta data dictionary using SAS/MACRO and PROC FORMAT.

Developed data export procedure and SAS routines to support enterprise data distribution.

Bristol-Myers Squibb 01/95 - 01/96

Senior Database Developer

Developed a NDA Data Entry System using ORACLE FOARM, SAS/AF/FSP, SCL, MACRO.

Developed data transformation process between third party database and ORACLE.

Developed an automated process package that creates FDA submission files.

Environment: VAX/VMS, DCL, Oracle, Oracle Form, PL/SQL Stored Procedures, SAS.

AT&T 08/93 - 01/95

OLAP Architect and Project Lead

In charge of the design and development of a Global Data Warehousing System.

Designed and implemented dimensional models and aggregations for DSS.

Developed and deployed a common meta-data model in the Enterprise Repository.

Designed and developed staging process for the warehouse system.

Developed an Enterprise Reporting System using WEB enabled OLAP tools.

Designed and developed various Oracle/Sybase GUI applications using C and MOTIF.

Environment: Solaris, NT, Oracle8, Sybase10, SAS, Informatica, Business Objects, C, Shell Script.

Dow Jones 10/92 - 08/93

SAS Data Mining Architect and Technical Lead

Designed and developed a data warehousing system for Dow Jones marketing.

Conducted dimensional modeling and aggregations optimization.

Designed and developed extract and transformation from OLTP to the warehouse.

Deployed data mining applications for marketing and financial analysis.

Environment: Solaris, IBM, Sybase10, Seagate Crystal Report, SAS.

Prudential Investment 02/92 - 10/92

SAS Data Architect / DBA

Performed database design for a real-time security/trade management system.

Conducted logical and physical database design and business rules enforcement.

Developed a strategy to migrate data from legacy system to new databases.

Performed database tuning and development DBA support for project team.

Environment: HP, IBM, Sybase10, SAS, Seagate Crystal Report, C, Visual Basic.

Paragon 02/91 - 02/92

Data Warehouse Consultant

Conducted database design with star schema for a Marketing Data Warehouse.

Developed a messaging process to transfer data into the warehouse.

Developed batch programs that can dynamically create cubes for OLAP tools.

Developed a DSS using Cognos Power Play and Seagate Crystal Report.

Environment: Solaris, IBM, Oracle7.3, SAS, Cognos Power Play, Seagate Crystal Report.

Bell Labs 01/90 - 02/91

SAS Project Leader

Project leader of the AT&T Portfolio Management Data Warehousing System.

Conducted logical and physical database design and implementation.

Developed data staging application that collects data from various ODS.

Developed a data mining application with combinations of statistics and neural network architecture to help AT&T credit score modeling and market segmentation of database marketing.

Environment: Sun/Solaris, IBM, Oracle7, C, MOTIF, Shell Script, SAS.

Bellcore 05/89 - 01/90

Senior Database Developer

Designed and implemented a data warehousing system for database marketing.

Performed logical and physical database design and implementation.

Developed packages and stored procedures to enforce business rules.

Developed data mining and reporting applications integrated to the warehouse.

Environment: Sun, Oracle7, C, Motif, Shell Script, SPlus, SAS.

EDUCATION

MS in Computer Sciences.

MS in Mathematics.

References are available upon request.

Contact this candidate