SUMMARY

• Over 18years of experience with strong emphasis on design, analysis, and development and implementation ofall kinds of Analytical Data Management systems for various industry raging fromInvestment Banking, Retail Banking, Financial, Credit Card, Mortgage, Clinical Trial, Pharmaceutical,Biotechnology,Healthcare, Insurance, and Telecommetc.Expertise includes design and development of variety of application, analysis, reporting, and data management
• 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/MDDBin 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,ProcTranspose,ProcFormat,ProcSummary,ProcMeans,ProcFreq,ProcReport,ProcG - plot,ProcBox plot andProcG-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 ofclinical trial protocols,SAP(Statistical Analysis Plan),SOP(Standard Operating Procedure) andCRF(Case Report Form).
• Working knowledge of clinical trials data in domains such asDemographic data (DM), Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Medical History (MH) and Vital Signs (VS).
• Familiar withICH,FDAandCDISCregulationsandguidelinessuch as21 CFR-Part 11, E3, E6 and E9.
• Working knowledge ofCDISC standardsincluding modelsSDTM,ADaMand ODM.
• Experience in creating and validating Safety (ISS) and Efficacy (ISE)tables, figures and listings (TFL).
• Experience in producing RTF, PDF, HTML files usingSAS 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, SAS/DI, 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, SAS/DI (Data Integration Studio).

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.

Platformand 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

Confidential

Sr. Data Manager / SAS Tech Lead

Responsibilities:

• 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, SAS/DI, and SAS/SQL to support MRMS (Model Risk Management System).

Confidential

Sr. SAS Programmer

Responsibilities:

• 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, SAS/DI, 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.

Confidential

Sr. SAS Tech Lead

Responsibilities:

• 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/DI routines to support enterprise data distribution.

Confidential

SAS Data Warehouse Technical Lead

Responsibilities:

• 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.

Confidential

SAS Data Warehouse Tech Lead

• Participated inthe 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, andODM 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.

Confidential

Sr. SAS Tech Lead

Responsibilities:

• 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 SASProcCDISC 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).

Confidential

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.

Confidential

Sr. SAS Tech Lead

Responsibilities:

• 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.

Confidential

Senior Database Developer

Responsibilities:

• 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.

Confidential

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.

Confidential

Sr. SAS Data Architect

Responsibilities:

• 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.

Confidential

Sr. SAS Data Architect/Tech Lead

Responsibilities:

• 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.

Confidential

Lead SAS Data Architect

Responsibilities:

• 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.

Confidential

SAS Data Warehouse Tech Lead

Responsibilities:

• 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.

Confidential

Sr. SAS Data Architect

Responsibilities:

• 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.

Confidential

Senior Database Developer

Responsibilities:

• 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.

Confidential

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 anEnterpriseReporting System using WEB enabled OLAP tools.
• Designed and developed various Oracle/Sybase GUI applications using C andMOTIF.

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

Confidential

SAS Data Mining Architect and Technical Lead

Responsibilities:

• Designed and developed a data warehousing system for Confidential 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.