SKILLS

ORACLE certified Oracle 8i DBA, B.Sc, M.Phil in Computer Science, PhD in Data Processing and Management. BI, EDW/ETL, Data Management Solutions Architect with over 20 years of IT experience.

OS: UNIX Solaris, HP-UX, AIX , Linux, Windows OS, etc

Programming: Shell, PL/SQL, PERL, C/C , Java, JavaScript, ColdFusion, T-SQL, VB, ASP.net, etc

Packages:, SAP Business Objects Data Services, DataStage EPM , Informatica GoldenGate Real-time Integration, Oracle, Sybase, DB2, SQL Server, Teradata, NeoView, Vertica, HANA, ERWin, ER Studio, Cognos ReportNet, Business Objects/Crystal Report, SAS, ESP, Tivoli/Maestro, PVCS, etc.

Expertise: Data Warehousing Data Integration, BI Reporting, OLAP, Big Data and High Performance in-memory Database Solutions, Data Mining and Information Retrieval, Data Management, DB Design and Performance Tuning, SOA and Web Services Architecture, eBusiness Solutions, Systems Integration, etc.

WORK EXPERIENCE

Confidential

• Data warehouse and BI application enhancements, master data management, data model updates, EDW performance tuning and system admin, etc Informatica PowerCenter, IDQ, Oracle11g .

Confidential

• ETL Architect/Team Lead, Blue Cross Blue Shield Montana Data Warehousing Project
• - Data integration architecture reviews and recommendations
• - Estimates of ETL work/re-work and updates of project plans
• - Design and development of DataStage ETL modules for Geography, Provider and Group subject areas
• - Design of Audit, Balance and Control ABC foundation for ETL operations ERWin, SQL Server , etc.
• - Promoting best practices and standards.

Confidential

• - Data integration / ETL architecture assessments and recommendations
• - Voyager ETL performance enhancements and database tuning Informatica, Oracle10g, ERWin
• - Proof of Concept on big data solutions Vertica and proposal of next generation of Data Intake systems to enhance EDW processing capacity long term business goals for 40M covered members .

Confidential

• - Support HP China healthcare team on joint efforts with AGHIT Asia Gateway Healthcare Information Technology Corp. bidding on China Ministry of Human Resources and Social Security MOHRSS China medical record retrieval and analytics multi-level national data centers and BI reporting structures project
• - High level architecture data integration proposals and detailed system solutions, SOW review and revision
• - Proof of Concept on healthcare BI with KPI operation reports to MOHRSS
• - Data modeling for POC MOHRSS data store.

Confidential

• - Developed data conversion and integration plans, with data profiling, and cleansing efforts on tax address, billing address and practice location address consolidations
• - Designed membership and provider management data feeding solutions point-to-point for third party clients SAP BODS, Oracle 10g, PL/SQL, XML, etc
• - Managed systems infrastructure upgrade and migration to SAP BODS v4.1 and Oracle 10gR2
• - Performed Oracle and ETL tuning, including system optimizations and enhancements.

Confidential

• - Provided long term solutions for bank EDW infrastructure, and data integration
• - Designed and developed ETL modules SAP BODI XI, Oracle 10g, SQL Server, Redbrick DB
• - Developed/enhanced City Data II data warehouse in subject areas of Deposits, Loans, Opportunities, etc
• - Designed ABC audit, balance, and control modules ERWin, Oracle, BODS , and operation reports.

Confidential

• - Proposed solutions and process architecture for JP Morgan Chase GMRD Data Integration, to meet increasing business and data demands
• - Conducted GMRD source datasets Bloomberg and FT profiling and validation ProfileStage, DataStage8.1, Oracle 10g RAC for gap finding and bridging
• - Prepared project proposal, task plans and risk control strategies Roadmap
• - Met and discussed with corporation senior management CDO for project and funding approvals.

Confidential

• - Analyzed UBS business requirements and identified data gaps between source systems
• - Designed and implemented low-latency ETL processes for UBS Security Master Database development
• - Identified and promoted best practices for UBS equity trading data integration program
• - Provided assistance to UBS data modelling ERWin , QA and Production Operation teams Informatica 7.1.2, Oracle 9i, ClearCase, PL/SQL and Unix Shell scripting, etc .

Confidential

• - Designed and developed Cash Management Data Mart Informatica and Sybase
• - Identified and promoted best practices for BGI data warehousing initiatives, and educated the client about concepts and methods of data warehousing, and dimensional data modelling, etc.
• - Created and maintained project task plan, and provided regular status updates to both Knightsbridge and BGI management teams.

Confidential

• - Data profiling and gap analysis Perl, Unix, Oracle, CDMA
• - CoSORT DDF and SORTCL components design and implementation for pre-ETL process
• - Design and implementation of Informatica ETL modules Unix, Oracle, Teradata .

Confidential

• Development of BLIS Data Warehouse, Decision Support and BI Web Reporting Systems
• - User requirements analysis, data modelling, and ETL staging table design ERWin, ER Studio, Oracle
• - ETL modules design and development PeopleSoft Apps, DataStage, Unix Shell, PERL, Oracle PL/SQL
• - Data analysis, data-driven decision support, and Web reporting Cognos ReportNet
• - ETL job scheduling and dependency management IBM/Tivoli TWS - Maestro
• - DataStage ETL server admin, ETL jobs and database performance tuning
• - Data validations, auditing and cleansing
• - Metadata management MetaStage , etc.

Confidential

• Bell Nexxia Network Inventory Management NIM project
• - User requirements analysis, data modelling, staging database design
• - DataStage ETL jobs design/coding/test DataStage/PX, TeraData, DB2, Java, Shell, Oracle PL/SQL
• - Near Real-time data warehousing DataStage, Oracle, Java, Vitria .
• EDS and Bell Canada Change Management Database CMDB Project
• - User requirements analysis, data modelling, staging DB design and creation
• - Design/development of Web-based components for user security, data validation, cleansing, OLAP and BI reporting ASP, VB, Crystal Report /Business Object, SQL Server, DTS
• - Design/development of ODS ERWin, SQL Server , and ETL modules for extracting, consolidating, and loading data from multiple sources of EDS and Bell Canada
• - Near Real-time ETL/data warehousing.
• PVC-OARS data extract, analysis and reporting for networks capacity management, EPMR prime reports, revenue assurance reports, etc DataStage, PERL, Shell scripts and Oracle PL/SQL
• IOM Integrated Order Management system PVC-OARS data consolidation and system integration
• eCommerce Applications development EJB WebLogic, J2EE, Oracle PL/SQL
• PVC-OARS Bell Nexxia broad-band network Order Assignment Record System development

Confidential

Main Duties: Financial data modelling, Sybase DB Admin, architecture design for Trust Investment systems Web Service Development of Java thin client interfaces for Investment Risk Management System Java, Jakarta, Sybase Development of Information and Report Server Operational Data Store for searching and viewing financial statements, and online Forms and Reporting components Java, HTML, Java Servlets, TCP/IP LPD, Socket Comm Development of Personal Portfolio Services HTML interface linking from Risc6000 Web to AS400 DB , etc.

Confidential

Main Duties: Lead developer on KINDS Knowledge-based Interface to National Datasets project Development of WWW search engines and interfaces for searching and manipulating metadata and geo-spatial data Arc/Info, PERL, JavaScript, SASPAC, Barts/Ordnance Survey mapping datasets and UK Census 91 dataset, Census boundary dataset, etc Meta data creation and repository management for UK national datasets Geo-spatial data warehousing and data mining PERL, Oracle, SAS Geo-spatial data processing and analysis Informatica PowerCenter, SAS, PERL, Oracle, Arc/Info, Imagine .