Jenn-Hwa Lee

**** **** ***** **** *. Dr. Indianapolis, IN 46226 • 317-***-**** • ntabav@r.postjobfree.com

Senior Oracle Database Administrator, Data Warehouse Architect, Application Developer, SQLServer Database Administrator, Netezza Database Administrator

• Over 18 years of experience as database administrator, data architect, Oracle web developer, and SAS programmer for medical research, regulatory affairs, clinical trials, manufacturing, sales, marketing, finance, and data publishing.

• Specialized in data processing and optimization, problem solving, performance tuning, data modeling, and application development.

• Agile learner for new knowledge and skills.

• Good team player with people-oriented approach to achieve the goal effectively.

• Good multi-culture communication skills.

EDUCATION

1983: M.S. with distinction, Computer Science, New York Institute of Technology, New York, NY

PROFESSIONAL EXPERIENCE

• Jun., 1996 – Present: Eli Lilly and Company, Indianapolis, IN

Associate consultant

Roles:

Database Administrator (Oracle DW/OLTP, Netezza DW Appliance, & SQLSERVER), Data Architect, Data Warehouse Architect (Oracle DW, Netezza DW, SAP/BW), Application Technical Lead, Oracle developer, Web developer

Projects accomplished in Eli Lilly:

Sept. 2009 - present: Support Polaris and B2B DW Systems; Data Warehouse Architect, and Database Administrator in Netezza.

(1) Designed and implemented B2B Data Warehouse using Star-Schema Data Model (Hybrid Model of Kimball and Inman Methodology).

(2) Designed and implemented Polaris Data Warehouse.

(3) Set up Netezza server to run jobs periodically for routine database maintenance including backup, statistic refresh, log file clean up, table reclaim, and performance reports.

(4) Set up and documented Netezza DW database naming standard, security SOP, and Linux/Unix NZClient installation and validation (IVI).

(5) Conducted Data Warehouse appliances evaluation and POC. Resulted in the purchase and implementation of the new DW appliance technology; successfully boosted DW performance.

(6) Provided advices for good practice and performance tuning on data loading processes and business intelligent (BI) query, Sql/Plsql, and reporting.

(7) Created new ways to allow Netezza to interface with the profile tool Trillium using SqlServer and linkserver.

(8) Championed Meta data good practice for integrated data linkage across various systems.

Feb. 2004 - present: Support Sales and Marketing DW system; Data Warehouse Architect, and Database Administrator in Oracle.

(1) Modified model design and implemented Data Warehouse and BI solution.

(2) Initiated redesign of ETL to ELT processes for intra DW dataflow; reduced the DW delivery time from 7 to 1.5 days.

(3) Initiated the design of drug distribution Datamart for BI reports; saved about 40 hours of delivery time.

(4) Initiated the creation of materialized views and carried out performance tuning for Sales Reporting; shortened the response time from more than 10 minutes to 2 seconds.

(5) Support Business Object and Hyperion for BI reporting.

(6) Support Activity ODS, e-marketing, and Pricing Information systems in Oracle databases

(7) Support Contract management and Ask Lilly systems in SqlServer databases

Jun. 2002 - Feb. 2004: Supported all GBIP (SAP) databases

Jun. 2002 - Feb. 2004: Lead DBA for GBIP (SAP) BW databases

Jan. 2002 - Jun. 2002: Lead DBA for Supply Data Warehouse databases

Jan. 2000 - Jun. 2002: Lead DBA for Promix databases

Jan. 2001 - Jun. 2002: Lead DBA for LDAM databases

Jan. 2001 - Feb. 2003: Backup DBA for EHS

June 1996 - Jan. 2000: Oracle Developer in CDF team. Designed and implemented master data applications

(1) Application lead - Developed applications to subscribe data from external data sources such as WHO and First Data Bank, integrated them into the Lilly master data system, and published the data to various Lilly business areas.

(2) Point person and developer of fifteen standard codes for web front end applications; enabled data stewards to maintain the standard codes.

(3) Designed and set up the basic architecture for subscription and publication systems; the first one to develop and use snapshots for our clients to subscribe CDF data.

(4) Designed and developed the first high performance, flexible, dynamic SOA application in Lilly in 1999 using oracle application server (web development) and dynamic views.

• Jun., 1992 – May, 1996: Medi-Span (now First Data bank), Indianapolis, IN

System Analyst

Roles:

Oracle SQL / PLSQL / Report Writer developer, Oracle Form developer, Shell Script programmer, C programmer.

Application systems developed or enhanced in Medi-Span:

Drug price update.

Dose check - ensures that the dosage of a drug prescribed by physicians is appropriate.

Patient education information - provides drug information to patients.

Duplicate therapy - ensures that two different drugs prescribed by physicians do not have the same effect.

Cross Check - detects drug to drug interactions.

Aller Check - detects potential allergic reactions that may be caused by drugs.

Warning Label - retrieves warning messages for a drug and prints them on a label.

Monthly Clinical Update - Automates clinical product generation for more frequent releases.

• March, 1990 – May, 1992: System Analyst, Dow Elanco, Indianapolis, IN

• Oct., 1989 – Feb., 1990: SAS contractor, Quality Control, Eli Lilly and Company, Indianapolis, IN

• Aug., 1985 – Sept., 1989: System Analyst / CLINFO Manager / SAS Programmer, Methodist Hospital, Medical Research, Indianapolis, IN

SKILLS

• Database administration

• Performance tuning

• Trouble shooting

• Problem solving

• Backup and recovery

• Software installation

• Upgrade and patching

• Data pump (exp/imp)

• Data guard

• Database copy

• Data replication

• Data quality assurance and integration

• Account management

• Schema management

• Data warehousing

• Business intelligence • SQL/PLSQL Programming

• Linux/Unix shell programming

• SAS programming

• C programming

• Web application programming

• SOA development

• Meta data management

• Master data management

• Data processing optimization

• Data cleansing

• Data movement

• Data transformation

• Data security

• OLTP • Requirements gathering

• DW architecture design

• Business area analysis

• Data analysis

• Project design and development

• Data modeling

• Dimensional modeling

• Auditing

• SOP documentation

• Prototyping

• Proof of concept

• Messaging gateway

• Testing

• OLAP

TECHNOLOGIES

• Oracle Database Admin (DW and OLTP) • SqlServer Database Admin. • NETEZZA DW Database Admin.

• SharePoint

• Enterprise Manager • Trillium

• TOAD • Power Designer

• Oracle Designer

• AWR/ADDM/ Statspack • Structure Query Report • C/ProC

• Visual Basic

• Linux/Unix

• Oracle Data Warehousing

• SSIS • Oracle Application server

• VMS

• NETEZZA Data Warehousing

• Business Object • Oracle Form

• SAS

• SAP/Business Warehousing

• Informatica Mapping

STRENGTH

Good in Architecture Design; Strategic Thinking; Optimization Design; Performance Tuning; Problem Solving; Fast Learning; Sharing knowledge and know-how with others; Affecting others positively; Leveraging leadership when possible; Coaching, Mentoring, and Helping others

APPLICATION/SYSTEMS

• Sales Reporting Systems • Clinical Trial systems • HL7 system

• Service Management • Corporate Integration Agreement Systems • Contract Management Systems

• Virtual Privacy Office

• Data Sharing System

• Supply Data Warehouse

• E-Marketing Systems

• Standard Code Front End Appl.

• B2B Data Warehouse Systems • Drug-Price Update Systems

• Sales data Warehouse Systems

• Informatica Mapping

PROFESSIONAL CERTIFICATIONS

IT Infrastructure Library (ITIL) foundation V3 Certificate

Certified Data Management Professional (CDMP)

Oracle Certificates in SQL/PLSQL, database management, backup & recovery

ACTIVITY / NETWORKING / AWARDS

• Member of IOUG, INOUG, DAMA, TDWI, NETEZZA Users’ Group, NETEZZA Developer’s Network

• Presentations at INOUG Conferences of the following topics:

Oracle Data Pump

Oracle Password management in HTML application using dynamic SQL

• Presentation at Lilly:

Data Warehouse Appliances

Column based database

How to create a virtual private database.

• Initiated and delivered ‘Tip of the Day’ Program among Lilly DBAs and DAs for knowledge Sharing

• Eli Lilly 2010 SAA Regional Award Winner

• Eli Lilly 2006 SAA Regional Award Winner

RESIDENCY STATUS: US Citizen

TRAINING COMPLETED

• Data Modeling with PowerDesigner. (Sybase Education Services)

• Netezza Data Warehouse Appliance Usage. (Netezza)

• Netezza Analytic Training / Overview: I-class: NZ analytics; NZ matrix; and Hadoop.

• Trillium Software System: Essentials. (Trillium Software)

• Oracle Database 11G: New Features for Administrators. (Oracle University)

• Oracle Database 10G: Implement and Administer a Data Warehouse. (Oracle University)

• Oracle Database 10G: SQL Tuning Workshop. (Oracle University)

• Enterprise DBA part1: Database Administration. (Oracle University)

• Enterprise DBA part2: Performance and Tuning. (Oracle University)

• Enterprise DBA part3: Network Administration. (Oracle University)

• Oracle8: Backup and Recovery Workshop (Oracle University)

• SQLserver Database Administration

• Oracle Designer

Contact this candidate