SUMMARY:

• More than 14 years experience and progressive responsibility in enterprise information system using enterprise data warehouse (EDW) and business intelligence (BI). Expertise in As - is data system and to-be data system analysis and architecture, data system gap analysis and implementation roadmap design, data system architecture and infrastructure
• BI reporting/analytics requirement to EDW data model mapping, business process model data flow analysis and business process model to enterprise data model mapping, conceptual/logical/physical data modeling with various database systems, source to target data mapping, metadata management, master data management, data system technology and tool evaluation and recommendation. In-depth understanding of software development life cycle (SDLC) methodologies, working experience in iterative and agile development of data warehouse/BI analytics project. Hands-on experience in data warehouse/BI architecture and ETL framework.
• ETL optimization, complicated ETL design, development and implementation, business requirement collection and analysis. Excellent oral and written communications skills for business and project management, team player as key contributor and supervisory tech lead. Master s degrees in software engineering and science.

TECHNICAL SKILLS:

Architecture: Data warehouse and database architecture design and implementation, data warehouse ETL framework design and implementation for enterprise information management system

Database and Data Modeling: SQL Server 2000/2005/2008/2010, Oracle 8i/9i/10g/11g, DB2 8.x, T-SQL, PL/SQL, Erwin data modeler 7.x/8.x, ER/Studio Data Architect XE6, Oracle Data Modeler 3.x, Sybase Power Designer6.x/7.x, MS Visio 2007/2010Data Warehouse Extract/Transform/Load (ETL): Pentaho Data Integration 4.x, Informatica PowerCenter 5.x/6.x/7.x/8.x, IBM DataStage 7.x/8.x, MS SQL Server Integration ServicesOn Line Analytic Processing (OLAP) and Business Intelligence (BI): SQL Server Analysis Services, Cognos Impromptu/PowerPlay/ReportNet, Hyperion BI, ArcPlan InSight

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Principal Consultant

Responsibilities:

• Analyze data reporting requirement and as-is data reporting samples from different bureaus to create reporting data set category, analyze current data status of source data system of data warehouse, create enterprise data warehouse (EDW) bus matrix, and design EDW data model based on the bus matrix, map data between data source and EDW to include subject areas of core financial, acquisition, grant, property, travel, HR and payroll.
• Work with SMEs on as-is data model and canonical to-be data modeling, to-be data dictionary, to-be data standardization, as-is data to to-be data mapping in the subject areas of core financial, acquisition, grant, property. Provide mentoring and hands-on help to junior team members in analyzing and profiling as-is data, proposing standardized to-be data.
• Take initiatives in design and implementing the Data Standardization Utility (DSU) framework for enterprise data standardization, as-is data to to-be data mapping. Design and implement change data capture (CDC) framework for core financial production data to keep data mapping current for core financial data standardization.

Confidential, Fairfax, VA

Sr. BI Data Modeler

Responsibilities:

• Design logical and physical data model of EMS (engagement management system) BI reporting by source data profiling and business process model mapping. Lead ETL development based on the established ETL framework using agile software development method.
• Take initiatives on sharable and reusable of enterprise data warehouse data object and ETL object to optimize development resource and to keep information with “one version of the truths”.
• Conduct business requirement analysis and source data profiling, redesign dimensional data model of job costing BI report, design and implement ETL framework and database objects, develop and implement ETL process.

Confidential, Chantilly, VA

Sr. Enterprise Data Architect

Responsibilities:

• Reviewed the “to-be” business process model of NGCMS (Next Generation Case Management System), and designed the conceptual data model and logical data model for the “to-be” NGCMS based on the “to-be” business process model.
• Conducted data analysis by data profiling and reversed engineering for physical/logical/conceptual data modeling to support the delivery of the “as-is” business process model of NFOCIS (National Field Office Case Information System) Case Management System.On-site IT specialist in mission-centric data warehouse (MCDW) project of FTC (Federal Trade Commission)
• Reviewed and validated the physical data model and ETL metadata linkage for MCDW POC implementation. Created user navigation interface test case for POC user test and coordinated user acceptance test. Created criteria for MCDW POC system QA test and reviewed system QA test plan and test case.
• Conducted business requirement analysis and source data profiling, design the logical/physical data model of MCDW, created ETL source-to-target mapping for iteration-based implementation. Created criteria for QA test of MCDW ETL subsystem and metadata management subsystem. Conducted ETL tools comparison (Informatica, ODI, OWB) and made recommendation for ETL tool selection.

Confidential, Rockville, MD

Sr. Data Analyst, Enterprise Data Architecture

Responsibilities:

• Designed Data Warehouse subscriber orientated architecture and ETL framework, and led the ETL development for slow change dimension (SCD) process and master data management (MDM) process using Informatica as ETL tool and Oracle as DBMS.
• Led ETL QA test and production implementation for initial data load from variety data sources to sales force Veeva application system. Lead production support and enhancement after initial data load.

Confidential, Reston, VA

Data Warehouse Architect

Responsibilities:

• Designed the enterprise data warehouse architecture, database and backend ETL framework based on dimensional data modeling methodology, and led the implementation the new infrastructure to provide the platform for project development based on multidimensional model and the backend for access of right information by right people at right time. Provided architectural document with standards, guidelines, recommendations and implementation roadmap to lead data warehousing system from IT reporting system to core component of enterprise information management system with reporting, analytics and predication.
• Made recommendations for IT enterprise data integration based on current vs. target gap analysis and provided solutions from enterprise data warehousing perspective. Actively participated in application system data modeling and relational database design/reengineering. Led and provided Erwin data modeling tool for DBA and application teams. Assisted IT application architect to establish the data modeling principles and standards for application development, and to set up and execute IT-wide data modeling implementation plan and metadata management plan. Closely worked with DBA’s, application architect and network architect for change management and activity coordination.
• Supervised and mentored other team members on enterprise data warehouse project development and daily production process by providing overview, guideline, standards, design document, sample codes, code review, hands-on help and second level data warehouse production support. Kept tracking the current trend and industry best practices in data warehouse by attending relevant classes, seminars and professional user group meetings.
• Worked with business user, business data owner and application system owner for detail business requirement, application data analysis, solution design, implementation and test plan. Created and maintained the enterprise data warehouse dimensional data modeling bus matrix, logical data model, physical data model and source to target mapping. Led ETL development and implementation based on the design and provided star schema model for BI development and implementation, multi-layer security policy execution and access monitoring.
• Took project management role on enterprise data warehouse related projects by providing project plan, time and resource estimate, project status report, and other mandatory SDLC documentations. Took initiatives and delivered enterprise data warehouse solutions to meet business requirement by completing data mart for procurement that helped procurement group to achieve 3% cost saving on purchasing, data mart for building products that standardized company-wide measurement of manufacture productivity and efficiency, data mart for house cost that empowered business management with analytical tool to target 6% saving on home building cost, data mart for customer relationship management (CRM) analytic reports, data mart for sales and sales life cycle analytic reports.
• Made recommendations and lead version upgrade of data warehouse infrastructure. Conducted new/updated software evaluation, regression test and system parallel test. Coordinated with network, SA and DBA teams to implement the version upgrade of O/S, data warehouse database, data warehouse ETL applications to development, QA and production environments. Lead data warehouse disaster recovery testing.

Confidential, Wilmington, DE

System Analyst / Lead ETL Architect

Responsibilities:

• Designed, built ETL architecture in SAP BW environment including development, QA, and production. Worked with OS team, network and infrastructure team, DBA team, and application vendors to handle technical request from project development team and production support team, includes code migrations, developer support, applications monitoring, performance resolution and tuning up.
• Installed and upgraded Informatica, Zycus, Trillium, and their related connectors in the development, QA, and production environment. Administrated ETL applications level security and user access privileges. Documented and updated the related installation and administration documentation of the applications. Provided technical help and supervisory to junior level team member. Advised other SAP BW project teams on how ETL should be architectured in design and utilized in development.

Confidential, Malvern, PA

Software Engineer

Responsibilities:

• Re-designed and generated series star schemas to support the various OLAP data cubes and reports. Created data warehouse bus matrix based on the analysis of business process. Used Erwin for data modeling, defining the logical model and generating the physical model.
• Developed ETL source to target mappings to load data into dimension tables and fact tables in data warehouse backend database. Used Informatica as ETL tool to extract source data from various data sources (Mainframe, DB2, SQL, PeopleSoft, Siebel, SAP, flatfile), transform and load to SQL 2000 Sever and Oracle 8i/9i database in data warehouse. Created new aggregates to satisfy clients' needs and to interface with BI frontend reports. Created data warehouse master universe for Business Objects reports.
• Designed, developed and maintained weekly OLAP reports in both summary level and detail level for various management teams including help desk, solution, customer care center. Up to 8 hours manual effort per report was eliminated by automated data warehouse ETL process, the used-to-be monthly reports were upgraded to weekly reports. Project full life cycle included gathering and analyzing requirements from clients, creating star schema, developing ETL using Informatica, building OLAP data cubes/sub cubes, documenting, user demo and, post-GA enhancement.
• Provided automation solution for monthly balanced scorecard process to support company’s senior executive level decision-making team. 80% manual efforts have been eliminated since then. Project full life cycle included design, development, documentation, maintenance and sun setting. Used Informatica for ETL and ArcPlan InSight for front-end reporting.