Manager Data

LUCEY CHEN

Professional Summary

Sevenyears of experience in Information Technology with a strong background in Informatica PowerCenter, Oracle, SQL Server.

Experience in implementing Data warehousing technologies in diversified industries like Banking, Mortgage, Pharmaceuticals, Healthcare and Insurance.

IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.

Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.

Strong knowledge of Dimensional Modeling, Star and Snowflake schema.

Extensively involved in documentation and technical designs, and unit test.

Experience in UNIX Shell Scripting on UNIX & Linux platform.

Experience in full life cycle software development including requirements definition, design, architecture, development, testing, implementation and support.

Experience in automation of ETL process, error handling, and auditing purposes.

Worked extensively in data warehouse using Informatica PowerCenterversion 8.x to 9.x.

Proficient in both Ralph Kimball and Bill Inmon Methodologies of Data Warehousing models.

Experience in SDLC Project Management and Resource Planning using Agile methodologies.

Proficient in using Informatica PowerCenter tools to design data conversions from wide variety of source system.

Proficient in writing SQL queries, Stored Procedures, Functions, Packages and Triggers.

Extensively used Flat files to load data from source systems to targets using direct and indirect methods.

Experience in implementing the best practice standards throughout the development cycle following the Informatica Velocity methodology.

Involved in 24/7 production role in a shift basis.

Technical Skills

OS

Windows, Linux, Unix

Data Warehousing

Informatica PowerCenter 8.x to 9.x (Source Analyzer, Data Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Worklets, Workflow Manager, Workflow Monitor, Repository Manager, Informatica Administrator, Informatica Scheduler), MDM

Data Modeling Tools

Erwin, Microsoft Visio

Databases

Oracle, MS SQL Server, MySQL, Netezza, MS Access

Reporting Tools

Business Objects XI, Cognos 7.1/6.1,MicroStrategy 8

Programming

SQL, PL/SQL, T-SQL, C++, HTML

Scripting

Windows Power Shell, Unix Shell Scripting

Other Tools

Toad for Oracle, SQL Navigator, Control-M, Tivoli, Autosys, MS Office

Education/Certifications

M.S. in Computer Science

B.S. in Information Technology

Professional Experience

Sutter Health – Roanoke, VA Feb 2014 – Present

Sr. ETL Developer

Sutter Health is a not-for-profit health system headquartered in Sacramento. MajorService lines of Sutter Health-affiliated hospitals include cardiac care, women’s and children’s services, cancer care, orthopedics and advanced patient safety technology. In this project, the goal is to build a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities:

Worked on requirements gathering, architecting the ETL lifecycle, creating design specifications, and ETL design documents

Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time

Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems

Responsible for unit testing and integration testing of Informatica code development for scheduled release

Scheduled the workflows to pull data from the source databases at specified time intervals, and maintain most current and consolidated data

Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool

Developed and maintained ETL mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files, and loaded into Oracle

Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle

Developed Informatica process to replace stored procedure functionalities and meet to SLAs

Done Modeling and populating the business rules using mappings into the Repository for Metadata management

Experience with high volume datasets from various sources like Oracle, Text Files, and SQL Server Relational Tables and xml targets

Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables

Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs

Environment: Informatica PowerCenter 9.5, Oracle 11g, XML, SQL Server, Tivoli,UNIX shell Scripts, and Flat Files.

Health Management Services – Jacksonville, FL July 2012 – Jan 2014

ETL Informatica Developer

HMS is a wholly owned subsidiary of HMS holdings corp. HMS is the nation’s leader in cost containment solutions for government-funded, commercial, and private entities. HMS helps clients ensure that healthcare claims are paid correctly and by the responsible party, and that those enrolled to receive program benefits meet qualifying criteria.

The main objective of the project was to help the decision making team of the organization, to monitor/improve the sales and to explore avenues for new business opportunities. DW team is responsible for building different Data Warehouse and providing reports for Production and Midstream groups.

Responsibilities:

•Extensively used Informatica Client tools – PowerCenter Designer, PowerCenter Repository Manager, PowerCenter Workflow Manager and PowerCenter Workflow Monitor

•Extracted data from multiple source systems, like Oracle, XML and Flat Files

•Developed the source to target mapping document for ETL development in Informatica

•Involved in translating business requirements to Technical specifications

•Designed, developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process

•Workedclosely with source system SMEs to identify the source data to populate to the Data mart

•Created pre and post session Stored procedures to drop,recreate the indexes and keys of source and target tables

•Performed system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data mart tables according to the source to target mapping document

•Developed ETL procedures to transform the data in the STG tables according to the business rules and requirements

•Created and executed unit test plans based on system and validation requirements, troubleshoot, optimize, and tune ETL processes

•Responsibility to create interactive dashboard reports as per the Business requirements

•Documented, maintained and ensured the process and quality of the system

Environment: Informatica Power center 9.1, Oracle 10g, XML, SQL Server,Toad for Oracle, Flat Files, UNIX Shell Scripts, and Business Objects XI.

Aon Hewitt – Miami, FL April 2011 – June 2012

ETL Developer and Support Engineer

Aon Hewitt specializes in the outsourcing of corporate human resources (HR) programs such as healthcare benefits, payroll administration, stock options and investment accounts to the client companies. This project is to merge few source system and make one centralized claim data warehouse.

Responsibilities:

•Worked closely with team of Business Analyst / Developers and testers to understand the business requirement and the existing ETL flow

•Extensively used Informatica Client tools – PowerCenter, Repository Manager, Workflow Manager and Workflow Monitor

•Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse

•Experienced in migration of ETL from one environment to other

•Provided guidance and specifications to developers for the maintenance and enhancement of custom ETL code.

•Responsible for being on 24*7 on call to help various ETL and non ETL issues

•Worked closely with report team tobetter understand user requirements and develop and fix the ETL code

•Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager

•Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance

•Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data

•Developed UNIX shell scripts using PMCMD utility and scheduled ETL load

•Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment

•Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads

Environment: Informatica PowerCenter 9.0, Oracle 10g,XML,UNIX Shell Script, Toad for Oracle, Cognos.

Metavante Image Solutions –Louisville, KY March 2010-March 2011

ETL Developer

Metavante Banking Solutions offers the most comprehensive set of integrated products and services, primarily for financial services providers. Metavante also provides risk protection products to individual and institutional clients. Some of the risk protection is Market risk associated with Equities, Debts, Bonds or other investments and credit risk associated with Mortgage or Loans for Fixed Income Options. The responsibility of this project to completely integrate the business to single environment. Development and implementation of ETL logic using Informatica ETL Tool, SQL Scripts and UNIX scripts to mortgage data warehouse.

Responsibilities:

•Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse

•Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document)

•Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN

•Extensively used Informatica Client tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager

•Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse

•Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations

•Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager

•Identified bottlenecks in existing sources/targets, resolved performance issues, and improved ETL run time

•Involved Integrating testing for code development to be released

•Prepared code migration documents for deployment

•Actively involved in production support, and implemented to fix solutions to issue tickets raised by user community

Environment: Informatica PowerCenter 8.6, Oracle10g, XML, Business Objects and UNIX.

Abbott Pharmaceuticals – Louisville, KY July 2009 – Feb 2010

ETL Developer

This Data Warehouse is constructed to stage the Sales & Distribution and Inventory related data for Abbott Pharmaceuticals (Pharmaceuticals and Hospital related products). Informatica was used to Extracting data from source system to target systems. There are numerous sources of data coming into the warehouse including Oracle and flat files.

Responsibilities:

•Understanding Client requirements for populating data in the target system

•Developed ETL jobs to extract data from source systems like SAP, DB2, Flat Files, Oracle, MS SQL and XML’s

•Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table

•Implemented slowly changing dimension tables

•Developed workflows and sessions associated with the mappings using Workflow Manager

•Involved in performance tuning to optimize session performance by eliminating performance bottlenecks

•Created the test scriptfor query validation of source and target table

•Used the mapping parameter to make the mapping more flexible

•Involved in the code review, and peer to peer testing

Environment: Informatica PowerCenter 8.5, Oracle 9i, MS SQL Server 2008, UNIX SHELL script, XML, Autosys.

Bank of China – Beijing, China Aug 2008 – May 2009

ETL Developer

It is one of the 5 biggest state-owned commercial banks in China. As China’s most internationalized and diversified bank, Bank of China provides a comprehensive range of financial services to customers across the Chinese mainland as well as 41 countries and regions. The Bank’s core business is commercial banking, including corporate banking, personal banking and financial markets services. The Banking Data Warehouse (BDW) system is designed to handle the increasing data volumes generated by the bank's growing, active client base while improving customer service levels. The BDW Solution provides quick access to data to enable a more informative decision making

process. BDW helps people do their jobs more effectively and efficiently. Data is accessible and flexible and presented in a usable format, allowing more time for analysis.

Responsibilities:

•Assisted in building the ETL source to Target specification documents by understanding the business requirements

•Developed ETL processes to migrate data from various formats (MS SQL Server, MySQL, flat files, etc.) to target database architecture in Oracle

•Tuned Informatica mappings and sessions for optimum performance

•Worked on Informatica PowerCenter tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer

•Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation

•Used Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data

Environment: Informatica PowerCenter 8.1, Oracle 9i, MS SQL Server 2005, Flat Files, MySQL.

Contact this candidate