Yen Ong

About Yen Ong

To work as data warehouse designer/developer and develop new data marts and warehouse for business partners in the organization through which data can be self-service, data mining, daily operation reports, and distribution can be faster and safe. Experience Summary:• Extensive experience in the IT industry with extensive ETL, SQL and Data Analysis.• Experience in Data Warehousing, Data Migration, Data Integration, Data Quality, and Data Cleansing.• Extensive fine tuning of queries to quickly return a large volume of data. • Excellent troubleshooting and analytical skills.• Experience in ETL using Informatica, SSIS SQL Server and Ascential DataStage version 7.5 (DataStage Manager, DataStage Designer, DataStage Director, DataStage Administrator). • Fine tune ETL jobs for high performance.• Experience in building Data Warehouse using Star Schema Model.• Experience in Oracle Golden Gate for data replicating.• Experience in logical and physical database design and fine-tuning Oracle store procedure• RDBMS experience with Oracle including database development, PL/SQL programming and DBA.• Experience in Business Object Designer, Supervisor and Reporting.• Excellent rapport with team members and a daily status report is sent to the manager.Technical Skills:Languages: SQL, PL/SQL, Unix scripts, COBOL/COBOLII, FORTRANDatabase: Oracle, MS Sql Server, Ms Access, DB2Data modeling tools:Embarcadero, Microsoft VisioUtilities: PL/SQL, Oracle SQL developer, SQL Server Management Studio SQL Server BI Development Studio (MS Visual Studio 2008)ETL Tools: Informatica Power Center SSIS MS SQL server Ascential DataStage 7.5.Operation System: Lunux/Unix IBM MainframeReporting Tools: MicroStrategy Business Object SSRS WebReport

Experience

1. Technical Lead - Etl Data Integration

   Nationwide

   Mar 2016 — Present

Education

• Minnesota State University, Mankato

  Bachelor of Science (B.S.), Computer Science

Skills

• Data Warehousing
• Sharepoint
• Shell Scripting
• Web Services
• Databases
• Agile Methodologies
• Soap
• Ibm Db2
• Sql Tuning
• Business Objects
• Software Development Life Cycle (Sdlc)
• Sdlc
• Sql Server Integration Services (Ssis)
• Oracle
• T-Sql
• Informatica
• Unix
• Data Modeling
• Ssis
• Business Intelligence
• Pl/Sql
• Software Development
• Scrum
• Db2
• Etl
• Enterprise Architecture
• Sql
• Visio
• Linux
• Microsoft Sql Server
• Extract, Transform, Load (Etl)
• Oracle Sql Developer
• Datastage
• Xml
• Database Design
• Integration
• Oracle Sql
• Ssrs