| SUMMARY - 1 7 years of experience in IT industry with planning, requirement gathering, data analysis,design and modeling, programming, testing, Database Administration and production support.
- 7 years in data warehouse and BI solution in full life cycle of data warehouse /BIdevelopment as architect, database administrator, developer, involved in product evaluation, define development standard, design, modeling, programming, testing, production deployment and support.
- PeopleSoft EPM 8.9 data warehouse full life cycle development with model design and review, Ascential DataStage programming, testing and tuning, Oracle PL SQL programming
- DBA for Oracle 7/8/9 and MS SQL Server 2000.
COMPUTER SKILL - Oracle7/8/9/10, MS SQL Server 4.2/6.5/7/2000, PL/SQL, Trans-SQL
- PeopleSoft EPM 8.9, ERWin, Cognos, MS Analysis Services
- DataStage 7.5, Informatica 6.5/8.11, SQL Loader, MS DTS, C/C , Visual Basic, Java Script
- Solaris 2.x, HP-UX 11, Windows NT/2000, Unix shell programming
EXPERIENCE Confidential - In public retirement system conversion project, analysis requirements and data, developed mapping and Informatica program to convert public retirement system from AS 400 to Oracle/Solaris system.
- In building underwriter performance analysis and action planning applicaion, gathered and analyzed requirements, designed ETL mapping logic, developed Informtica progra m .
Confidential - Worked on PeopleSoft EPM 8.9 financial and HR data warehouse , resolved customer change requests and system investigation requests, maintained design document and data dictionary, ETL programming, performance tuning and production issues with Oracle 10g/DataStage 7.5/HP-UX 11/Cognos 8.2.
- Supported PeopleSoft EPM 8.9 production system and investigated enhancements and re-implementation.
Confidential - Collected requirements, designed ODS, modeled with ERWin, and converted 100 tables with more than 200 mappings from decommissioned application, completed unit testing and system testing, together with Informatica 8/DB2 9/Cognos 8 server upgrade and Data Analyzer installation on Solaris 2.9 with Oracle 10g repository.
- Reviewed data warehouse program and gave recommendation, maintained production system with DB2 9/Informatica 8/ERWin 4.2
Confidential - Assisted planning and implemented PeopleSoft EPM/Financial data warehouse with Oracle 10g/DataStage 7.5.1/PeopleTool 4.5/HP-UX 11. Worked as tech lead on every detail through the project, defined development standard, incremental load strategy, batch operation, migration procedure, designed and reviewed LF models, created and updated database objects, coded DataStage and PL/SQL and reviewed code from consultants, tuned DataStage and database to load data end to end under 4 hours daily, and built production environment with batch team and DBA.
- Developed Student data mart with Informatica 6/MS SQL Server 2000/Trans-SQL/Windows 2000.
|
Privacy Policy
