Overview

Audrey Chang has 16 years IT experience focused on providing Data Warehouse/Business Intelligence DW/BI and Data Management solutions. She is specialized in data analysis, data warehouse architecture, data modeling, data integration and business intelligence design. She has great Oracle database certified background to support her data architecture work with performance consideration.

Areas of Expertise

• Excellent in data architecture, data management and data analysis
• Certified Oracle OCP, and advanced skills in SQL, ETL, DW/BI design and implementation
• Proven ability in logical thinking, troubleshooting and high quality detailed design
• Excellent at delivering well-tuned solutions to existing/new architecture
• Strong Release Management via System Life Cycle experience SDLC or Agile of various systems

Professional Experience

CONFIDENTIAL

• Leading a team of 27 offshore and onsite to deliver media and customer reporting solutions via a global EDW data platform. The team consists sub teams of API, Linux, ETL, QA teams as well as 2 project managers for client deliverables and project plannings.
• The EDW data platform leverages API/.NET extracting Ad exchange data from multiple publisher sources, and ETL/Informatica processing data into a customized Data Warehouse solution Server in order to support a scalable marketing reporting solution for advertisement subscribed by clients.
• Led the team to migrate the system to cloud based server hosting platform Amazon Cloud, while continued maintaining production and development for client deliverables.

CONFIDENTIAL

• CONFIDENTIAL Within the Agile project environment, built the ETL architecture platform which tightly coupled with IBM MDM solution, standardized the loading strategy and delivered six major releases for data load/extract of the plan contract data.
• Heavily involved in physical data model design customized for different subject areas as required by the business. Mainly focused on fine-tuned database design and trade-off among read, load, index and partition strategies.
• Served as a SQL expert and provided recommendation in SQL tuning across the development teams.
• Led the release process across multiple pre-production and production environments.
• Led the DataStage 8.0 to 8.1 upgrade initiative and completed the grid platform upgrade in 6 months.

CONFIDENTIAL

• Responsible for a system design which streamlines 500 million daily suspicious financial activity reports into a consolidated data warehouse repository.
• Served as a hand-on data expert focusing data architecture design, data modeling, database performance analysis, ETL development IBM DataStage and various data management topics.
• Led the ETL architecture and loading strategy in multiple IBM DataStage servers and Oracle 10g/11g databases environment.
• Heavily involved in SQL tuning within/across the development team.

CONFIDENTIAL

• Way Ahead is a program planning office leading re-engineering efforts of the future design of the health information management system under DoD MHS.
• Provided the data strategy as a long term approach for the program office engagement in building the new centralized core systems target budget of 1.8 billion contracts .
• Served as the data architect focusing on Data Architecture, Data Migration and Business Intelligence BI design aligned with the new system architecture. Heavily engaged in coordinating re-architecture of multiple systems, providing guidance on assessment of new technologies and advising best approaches of information system architecture to the lead military officers.

CONFIDENTIAL

Transportation Security Administration TSA IHOP project

• IHOP project is re-engineering the existing various HR systems into integrated E-recruitment systems for recruitment hiring to support. Data Warehouse approach was brought as the key centralized system data area.
• Served as a database architect to perform system/data analysis, data modeling and database design in the non-integrated and integrated star-schema enterprise data warehouses, as well as the multi-stage ETL approaches between two data warehouse systems.

CONFIDENTIAL

Securities and Exchange Commission SEC

• Developed multiple data mart applications that use Conformed Dimensions to provide an integrated, enterprise data warehouse to SEC. The data marts support serial insider trading analysis, insider trading network analysis, disgorgement/penalties financial analysis, collections analysis, money distribution analysis, and broker dealer/investment advisor examinations analysis.
• Served as Senior Data Warehouse Consultant during the requirements gathering, design, development, testing, and deployment phases.
• Designed and developed the star schema data models, ETL architecture and components using SSIS on the SQL Server platform , Business Objects components Universes and Reports , and Sybase/Sybase IQ performance tuning tasks for all data marts.

CONFIDENTIAL

• Designed all components of a cross-application, reconciliation data mart to insure information quality. Designed and developed ETL using PL/SQL and System Assurance reports to analyze and reconcile information.
• Led the team to deliver multi-schema Oracle database infrastructure which maximizes database performance, data security and user usability. Coached the team to deliver well-tuned high performance design and code as a SME contact using Oracle expertise.Managed the release team to build ETL processes/scripts, database scripts and migration process. Supported deployment across all development, testing and production environments.
• Supported and coordinated with other teams such as Advantage 3 application, conversion, interface and integration for production execution planning to schedule production initial load.

CONFIDENTIAL

• Delivered the FileNet P8 solutions, which is an Enterprise Content Management ECM product, to support the Disability Determination process of Medicaid for the State of Ohio.
• Developed the data mart, ETL components and multiple custom reports to provide an analytics reporting application and dashboard reports using FileNet Process Analyzer to the end users.

CONFIDENTIAL

• Performed data validation and data analysis on the production result converted from a legacy database using complicated SQL join queries.
• Utilized the SQL tuning skill to provide automated solution for the post-production data cleanup task against a live-production database.
• Led the data analysis, validation, and reconciliation effort to compare data from Conversion Result and legacy database for pre-production validation. This critical task determines the go-live risk level.

CONFIDENTIAL

• Performed database/ETL design and development efforts to create a data warehouse application for the State of Virginia which integrated state and federal of corporate entities and individuals to identify delinquent and evasive tax payers. An automated feedback loop process was implemented to upload suspicious corporations and individuals for audit process in the Tax processing application.
• The data warehouse application identified 73 million in delinquent tax revenue in the first year.
• Served as the SME of the source system database design of the Virginia Revenue source system, and leveraged this knowledge in designing the fundamental Front-End Black box for CR system using Informatica. This staging design optimized seeding process of the ETL for each tax type subject area.
• Provided analysis on data sources for each team member with the expertise of the Revenue database and consulted with high-performance designs..

CONFIDENTIAL

• Served as application engineer to redesign the fundamental 3-tier infrastructure of the Return Process System. This design is customized to handle the massive volume of the returns in Virginia Revenue and Tax System and their complex relationship in order to process 10 million returns per year.
• Designed and developed the core system of the Posting Rules Validation and used by all Tax return components in the Virginia Revenue System.
• Implemented the Virginia Corporation Tax Form Edit packages total of 42 return forms under the Return Process System and the Audit Process.
• Implemented the Kansas Corporation and Individual Tax Form Edit packages.