********************
-- IT professional with 6 year experience in ETL tools like DataStage 7.5 PX, Informatica 6.1 and MS DTS2000..
-- 6 year experience in OLAP tools such as BusinessObjects 5.7, Discoverer 9i and Crystal reports 9.
-- 8 year experience in Oracle, Extremely Strong at PL/SQL and performance tuning.
-- 3 year experience in SQL server 2000 and IBM DB2 8.0.
-- 5+ year experience in Data Modeling, adept at Erwin, Oracle Designer and Powerdesigner.
-- Proven track record in building Datawarehouse from concept to production.
-- 5 year experience in web application, specifically in Plumtree Portal,Oracle iPoral Java, JSP and Weblogic.
-- Good experience in Oracle Application R11, PeopleSoft HR and their backend data integration.
-- Good experience in B2B and EAI tools like Datastage TX 7.5(Mercator),Webmethods 6.1 etc..
-- Strong analytical and problem solving abilities
Certificates
************
Oracle Certified DBA in 9i database (OCP 9i)
Oracle Certified DBA in 8i database (OCP 8i)
Microsoft Certified Solution Developer (MCSD)
Microsoft Certified DBA in SQL server 2000 (MCDBA2000)
Sun Certified Web Developer (SCWCD on J2EE)
Sun Certified Java Programmer (SCJP)
Professional Experience
***********************
Chartered Semiconductor Manufacturing Mar 1999 – Present
* Principal System Analyst , English working environment
PROJECT #1 CRM Datamart and Dashboard, Apr 2005 – Present
Environment : BusinessObjects 5.7, Datastage EE 7.5 PX, Oracle 9i,Plumtree Portal 4.5, Java, JSP
Role : Project Leader
Project Description :
CRM datamart and Dashboard combine sales, forecast, budget ,finance and Opportunity into one and show the entire picture for the salesman and CSR.
Responsibilities:
* Generated the requirement documents and Designed the Data modeling for CRM datamart.
* Integrated the Portal security with LDAP.
* Designed and implemented ETL job to pull the data from various sources like LDAP ,CRM,BDW and Finance.
* Designed and implemented the row-level security for the Dashboard.
* Designed and implemented 21 plumtree gadgets for Dashboard.
* Setup the BusinessObjects universe, Designed and developed BO reports for opportunity tracking.
PROJECT #2 Centralized DataWarehousing, May 2004 – Now
Environment : BusinessObjects 5.7, Datastage EE & TX 7.5, Oracle 9i, IBM DB2, Webmethods 6.1, Erwin
Role : Project Technical Leader, Project DBA
Project Description :
This is a large project with bedget US$1.5M. We consolidated several datamarts into the central datawarehouse which was serving to the different datamarts ,B2B,customer , Portal and EAI. BusinessObject was used as OLAP TOOLS, Datastage EE was used as ETL , Webmethod was used as EAI.
Responsibilities:
* Setup the Business Objects repository, Design and implement Biz, PO, Planning and P&L universes.
* Designed and developed BO reports.
* Analyzed and transformed Business Model into DW Star schema.
* Setup Oracle 9i RAC database with Oracle consultant, built application schema, fine tuned SQL and involved other regular DBA activities.
* Designed and Implemented ETL jobs using Datastage to pull the data from Oralce ERP,IBM Siview, Promis and other various heterogeneous systems to CDW
* Designed and Implemented ETL jobs for data migration to migrate 273 tables and saved US$60k budget
* Designed ,implemented and deployed Webmethods model which is used to validate XML doc ,map internal format XML into RosettaNet PIP3A4 and 3B2
* Created XML Doctype and generated order confirmation and shipping notification XML Doc for TN.
* Configured TN to receive inbound XML doc and to delivery outbound XML doc to Intel,Boradcom etc
PROJECT #3 Management Digital Dashboard, Feb 2003 – Mar 2004
Environment : Java, JSP, Business Objects, Oracle ,Datastage EE, Plmtree Portal, Weblogic,PowerDesigner
Role : Project Leader, Project DBA
Project Description :
Dashboard is OLAP based and Portal faced application to measure the business and operation performance. Which contains over 400 reports and graphs to indicate the various important KPIs in Sales, Operation, Supply Chain , Finance, Tapeout and QC.
Responsibilities:
* Interacted with user to define KPI(Key Performance Index)
* Business Process Re-engineering to standardize the processes in each Fab.
* Built KPI universe using BusinessObjects ,Design and develop BO reports and publish to web
* Setup Database and Design application schema.
* Designed and Implemented ETL job using Datastage to pull the data and build the summary tables.
* Created Plumtree Gadgets using Plumtree API,Weblogic APP Server, Java and JSP)
* Post support, maintenance and enhancement
PROJECT #4 Peoplesoft Datamart, Oct 2003 - Dec 2003
Environment : Business Objects 5, Oracle 8i,PowerDesigner , Datastage
Role : Project Leader, Project DBA
Project Description :
Peplesoft Datamart is designed to replace the SQR reporting tools from Peoplesoft. It greatly reduced IT’s work by implementing the user-friendly Datamart. Users can easily create the PS reports using BusinessObjects.
Responsibilities:
* Communicated with HR Users to generate requirement analysis Documents.
* Setup the HR Datamart Database (Oracle9i) and design application Schema.
* Designed data modeling using Designer2000 based on Star Schema.
* Built ETL job using Datastage to pull the PeopleSoft Data.
* Created BO repository, implement row level security in supervisor and build universe.
* Designed and Created 20 BusinessObjects reports
PROJECT #5 Oracle Application R11 Datawarehousing ,Jan 2000 - Jan 2001
Environment : Oracle 8i,Discoverer,BusinessObjects,Oracle ERP,Informatica,PowerDesigner
Role : Project Technical Leader, Project DBA
Project Description :
Whole project contains three datamarts.OE,PO and Finance .Each datamart contains 30 to 50 reports. Informatica is used as ETL tool.
Responsibilities:
* Collected the requirements from CSR, Planning, SMO and Finance users.
* Setup Database
* Transformed Business model into DW Star schema.
* Involved the data conversion from 10.7 to R11 using PL/SQL stored procedure
* Setup Inforatica Reporsitory Server,Created the Mapping and workflow for the ETL job using Designer and workflow manager to pull the data from Oracle R11
* Built Discoverer EUL and reports
* Created BO Universes and reports
PROJECT #6 Ramco Payroll Datamart , Oct 2001 - Dec 2001
Environment : Sql server 200, DTS ,Business Objects, Erwin
Role : Project Leader
Project Description :
The datamart is designed for the analytical reporting of Ramco Payroll.
Responsibilities:
* Work with Payroll team to collect the requirements
* Design data modeling using Erwin.
* Designed and implemented ETL jobs using DTS
* Created BO repository , Universe and BO Reports.
PROJECT # 7 Manufacturing ODS, Mar 2000 - Jun 2000
Environment : Informatica Oracle 8i,Discoverer,BusinessObjects,Promis,Java , JSP and Pro C
Role : Project Leader, Project DBA
Project Description :
This Manufacturing ODS is designed for WIP tracking. The DB size for this datamart is huge ,more than 2TB. Informatica and PL/SQL are used to pull the data from Promis. JSP is used to build the website to publish the static reports.
Responsibilities:
* Worked with Fab engineer to generate requirement analysis documents.
* Setup Database and create application schema
* Designed data modeling for ODS.
* Created ETL jobs using Informatica and PL/SQL (which is used to handle the complex logic)
* Designed BO Universe and created BO reports.
DuPont Electronics Singapore Pte(Singapore) Dec 1997 – Mar 1999
* System Analyst , English working environment
PROJECT # 8 Executive Information System(EIS), Jun 1998 - Dec 1998
PROJECT # 9 Compaq EDI Project, May 1998 - Jun 1998
PROJECT # 10 Compaq&West Digital SOI Project ,Dec 1997 - Apr 1998
Environment: Cognos Powerhouse, COBOL, Visual Basic, MS Access,Sql server, Crystal Reports, DuPont TSC(ERP)
Role : System Analyst
Project Descriptions :
EIS is a Business Intelligence system used by top management. EDI project is actually enterprise application integration(EAI) based on EDI file. It is used to do auto booking, confirming and shipping alert. SOI project is forcibly introduced by Compaq . It changed the order workflow to move the inventory into Compaq.
Responsibilities:
* Requirement Analysis
* Database and System Designing.
* Implementation and Deployment
* A lot of support, maintenance activities.
Education:
* Master in Computing, Nankai University
* Bachelor in Computing, Nankai University
Training
Ascential Datastage EE, Datastage TX, Metastage trained in Ascential
BusinessObjects Supervisor, Designer, Webintelligence, Broadcast agent and User trained in MGB
Oracle Discoverer 3.1 Admin and user trained in Oracle University
Oracle Financial Functional Foundation, OE, PO and Forecast trained in Oracle University
Oracle Advanced PL/SQL trained in Oracle University
Oracle 8 Database Performance tuning trained in Oracle University
Oracle Portal technical Foundation trained in Oracle University
Project management trained in Primavera
Documentum (Content Management) Technical Foundation trained in Documentum
Awards
2004 Recognition Award for Peoplesoft Datamart Project
2003 Recognition Award for the Dashboard Project.
2003 Recognition Award for the Customer portal reporting .
2002 Recognition Award for Operation Datasore(ODS) Project
2002 Recognition Award for tuning Datawarehouse and increasing loading frequency
2001 Recognition Award for Management Portal(Oracle Webdb).
2000 Recognition Award for the implementation of Oracle R11 datawarehouse(Score project).
1999 Recognition Award for Y2K Project.
1998 Recognition Award for Compaq EDI Project
Reference
Available upon request