SUMMARY:

• Senior Business Intelligence/Data Warehouse Architect with over 16 years of consulting experience from leading consulting firms( Confidential, Confidential )
• Architected, trained and/or managed technical staffs to deliver business intelligence solutions addressing clients’ critical business analytics needs
• Solid technical skills in ETL/ELT(hand - on and architectural domain knowledge in Informatica and Oracle Data Integrator), Enterprise data modeling and Data warehouse,
• Experienced in installation, configurations and customizations for Oracle Packaged Analytics BI solution (Oracle BI APPS including HR Analytics, Siebel CRM Analytics, Financials Analytics, Procurement & Spends Analytics, Supply Chain Analytics, Order Management, Oracle Primavera P6 Project Analytics )
• Experienced in Oracle Analytics Cloud (OAC), Oracle Business Intelligence Cloud Services (BICS)
• Balanced combination of business management/functional knowledge and deep hand-on technical expertise, as well as project management skills

TECHNICAL SKILLS:

• BI tools: Oracle OBIEE version 10g & 11g and 12C, Oracle Analytics Cloud (OAC), Oracle Business Intelligence Cloud Services (BICS); Tableau, Business Objects, Cognos.
• Oracle BI Applications(architectural blue print, Implementation roadmap and estimation, installation, configurations, customization, custom design, build, deployment), Oracle Data Warehouse Administration Console (DAC 10g, 11g), Oracle BI Configuration Manager, Functional Setup Manager
• Oracle Data Integrator (ODI 11g, 12C) for BI Apps, ODI integration with Oracle GoldenGate
• Oracle BI Applications: HR Analytics, Siebel CRM Analytics, Financials Analytics, Procurement & Spends Analytics, Supply Chain Analytics, Order Management, Oracle Primavera P6 Project Analytics, Oracle Financial Services Analytics Application (OFSAA)
• Informatica 8, 9 Product Suite Installation, Configuration, and upgrade (Power Center, Data Explorer, Data Quality Workbench, Power Exchange for Hyperion Essbase Oracle EBS, Siebel),
• Hyperion Essbase, Hyperion Interactive Reporting/Brio, Oracle Product Quality Suite, Hyperion DRM suite, Mainframe DB2, SyncSort(ETL Tool), Business Objects, Tableau, Qlik DB2 UDB, Oracle, Sql Server
• NoSql, Oracle Big Data Appliance, Enterprise R,
• Dimensional Data Modeling(Erwin, Embarcadero), Data Warehouse Architecture, ETL Architecture, Data Quality, Analytics dashboard and report design

PROFESSIONAL EXPERIENCE:

Confidential

BI APPS Financial Analytics consultant

Responsibilities:

• Performed OBI BI APPS 11.1.1.10.2 Installation with ODI(Oracle Data Integrator), setup Initial data load Financial Analytics and Procurement & Spend modules through BI Configuration manager and functional setup manager
• Enable Analytics service offerings BI APP Configuration Manager, set up load plans, performed functional configurations and parameters setup, performed domain load plan and module specific load plan to load data; trouble shoot data load issue in ODI
• Independent OBIEE BI/DW Consultant providing hand-on technical expertise and architectural advisory to OBIEE Financial Analytics implementation in conjunction with enterprise wide Oracle eBS R12 global roll-out/upgrade from eBS 11i;
• Managed enterprise wide financial statements and fiscal budgeting reporting requirement gathering on existing platform, reviewed and consolidated existing reports(Oracle Standard reports, FSG, Oracle Discover reports non-Oracle reports, etc.) and mapped them into sets of reports on new reporting solutions and platforms
• Supported and trained over 45 CPAs/Accountants across AP, AR, Fixed Asset, GL, PO teams in Finance department over 3 locations (Santa Clarita, Seattle, and Australia), managed solution testing and bug fixing process throughout development, CRP4, SIT and UAT cycles
• Performed customization of ELT mapping, Interface, data store of out-of-box ODI Package, regenerated scenarios and load plan to accommodate customized mapping interfaces
• Performed All necessary DAC and ETL Informatica configurations to automate ETL sourcing from Siebel 8.1 and other data sources.
• Provide subject-matter-expert advice to lead client Informatica upgrade to version 9 across all environments; Instrumental in performance tuning, OBIEE system environment setup and upgrade
• Designed, built and deployed Global Pricing Analytics Component, which enables client's analytic insights into product cost, pricing, margin as well as currency exchange impact from global perspective, integrated such custom built component using Informatica and DAC with existing BI Application including Supply Chain, Financial, and Order Management
• Worked with client's accounting/financial resources and pricing resources to finalize functional requirements and translate them into technical solution design and implementation
• Designed and built data model for cost, pricing and product margin subject areas and integrate them into existing OBIEE Analytics Warehouse
• Architected overall ETL framework and built ETL solution using Informatica to extract data from EBS (US region), JDE World(China, South Africa), JDE E1 (Japan, Europe, Australia) and load data into OBIEE Analytics Warehouse
• Instrumental in standing up Financial AP, GL modules in 10g out-of-box OBIEE solution in a fast-track mode sourcing data from JD Edwards ERP; Performed tasks such as standard and custom configurations for Financial Analytics BI Applications including ETL component - Informatica, DAC, RPD, dashboards as well as related security settings
• Served as key architect to design, build, customize and deploy project and portfolio management BI solution using Oracle Primavera P6 Analytics on OBIEE
• Provided subject-matter-expert expertise to OBIEE repository RPD design and development to help client project fully leverage Oracle BI capability in term of features, function and performance
• Reviewed and guided architectural design and development for OBIEE RPD, security, as well as canned report and Ad Hoc Report
• Presented OBIEE HR analytics at HR global Work shop to HR leaders and users from US and Europe, elaborated HR Analytics Out-of-Box features and content through dashboard and Answers live demo
• Prepared and co-led HR analytics functional requirement gathering and clarification workshops to drive detailed technical configurations for HR Analytics OBIEE solution
• Installed and configured HR Analytics on 11g platform and performed initial data load sourcing from PeopleSoft HCM 9.0 using Informatica and DAC.
• Analyzed data element from PeopleSoft and legacy HR system, created/modified data model and ETL to integration data from multiple sources; delivered Ad Hoc reporting capability for workforce profile and compensation subject areas
• Guided client resource mapping legacy financial system data element to Oracle BI APPS Universal adaptor for Financial Analytics implementation

OBIEE Senior Specialist/Data Warehouse Architect

Responsibilities:

• Designed, built and deployed business intelligence solution using OBIEE 11g and BI Applications
• Worked with client functional team to refine functional requirements; performed fit-gap analysis between Oracle BI Applications and functional requirements
• Guided client in defining KPI metrics according to client’s processes and strategies, coached client in understanding and making best decisions to take best possible advantage from Oracle OBIEE BI Applications
• Acted as technical OBIEE lead responsible for delivering 2 modules in parallel: Procurement & Spend module(40% Customization) and a 100%custom module built for client’s land leasing operations
• In charge of dimensional data model design and refinement for custom built module from scratch
• Managed 6 OBIEE developers throughout ETL and report design, development, integration test, User Acceptance test and pre go-live preparation
• Created and maintained project plan for 2 work streams,, managed risks and prioritized tasks for team members; closely interacted with client’s functional team to ensure alignment between technical delivery and functional requirements
• Provided guidance for OBIEE upgrade from 10g to 11g, supervised and performed quality-assurance checks upon upgrade activities
• Provided development standards to team members, drove technical design review with clients to obtain sign-off, performed code reviews and owned defect management process of User Acceptance Test

OBIEE Senior Specialist/BI Solution Architect

Responsibilities:

• Designed, built and deployed business intelligence solution using OBIEE10g sourcing data from Essbase to deliver Sales and Financial dashboards and reports
• Managed 3 OBIEE developers from requirement, design, test to deployment of the solution within 3 months
• Resolved technical issues with regard to OBIEE 10g and Essbase Integration by arranging and facilitating meetings with Oracle technical representatives
• Managed project schedule, resource allocation; provided status to client IT executives

Confidential, San Jose, CA

OBIEE/BI solution Architect

Responsibilities:

• Proposed and successfully executed fast-track delivery methodology that delivered customized OBIEE BI Application HR analytics within 12 weeks from requirement to deployment
• Key OBIEE architect responsible for data model enhancement to accommodate recruitment requirements; Performed integration and customization of Informatica components within OBIEE HR BI Application, as well as new metrics definitions for new reports and dashboards needs
• Analyzed data source including EBS, planning data source in Essbase, and 3rd party recruitment systems and designed data integration and change capture architecture
• Performed Executive dashboard and report gap analysis and report layout& navigation design; Performed RPD design and build, merger and deployment

OBIEE Data Integration and BI solution Architect

Responsibilities:

• Designed, built and deployed business intelligence solution using OBIEE 10g covering Financials Analytics, Supply Chain Analytics, Project Analytics, and Services (100% custom) modules
• Key architect responsible for integration and customization of Informatica components and DAC component within OBIEE BI APPS platform
• Analyzed data sourcing from Siebel, EBS and other operational systems and integrated DAC components across Siebel data source and EBS data source
• Performed Executive dashboard and report gap analysis and design; RPD design and build, merger and deployment

OBIEE Integration and solution Architect

Responsibilities:

• 11 month role to design, build and deploy business intelligence solution using OBIEE BI Applications
• Managed 2 work streams of technical delivery in parallel; managed project work plan and delivery schedule from technical design to deployment
• Designed and built a 100% custom module (Data Model, ETL, RPD) - Quality Assurance dashboards and reporting solution using OBIEE platform tailored for client's medical lab product defect management
• Managed technical staffs and client resources t o deliver OBIEE BI Application HR module (30% custom)
• Key Architect responsible for integration and customization of Informatica components and DAC components from 5 work streams including Human Resources, Financials, Supply Chain, Sales Management and QA modules
• Led technical team to deliver all critical system go-live activities over 20+ days during holiday seasons
• Provided technical advisory and guidance for package software(OBIEE) installation, setup, upgrade and migrations among multiple environments
• Performed Executive dashboard and report gap analysis and design, RPD design and build, merger and deployment
• Release management: Planned and phrased the technical delivery according to business priorities and project schedule

ETL Architect/OBIEE Siebel Analytics Architect

Responsibilities:

• 10 month role to design, build and deploy business intelligence reporting solution using OBIEE Sales analytics and Financial Module(AR, AP)
• Analyzed Siebel CRM and Oracle EBS source data and designed integration architecture to integrate Informatica and DAC component across Siebel data source and EBS data source
• Provided technical guidance to setup ETL components in Test and Product environments
• Planned and executed code deployments for ETL components

ETL Architect and Informatica SME

Responsibilities:

• 10 month role to design, test and build ETL components to move from data from SAP into Essbase cubes
• Provided guidance to data model design and implement data change capture mechanism for ERP Source (SAP and PeopleSoft)
• Provided technical guidance to setup ETL Development, Test and Production environments
• Provided technical guidance and proof of concept to integrate Informatica component with Essbase cube data load
• Orchestrated upgrade implementation of Informatica Power Center from version 7 to version 8

Data Warehouse/ETL Architect

Responsibilities:

• 9 month role as technical lead to design, build, and deploy data model and ETL solution for a data synchronization process to update customer data warehouse with data from multiple enterprise data sources including finance, service part, vehicle, services, warranty & claims and customer
• Designed and supervised the delivery of data quality exception management reports using Hyperion management suites(Brio/Interactive Reporting)

ETL Lead/Architect

Responsibilities:

• 2 month role to provide conceptual ETL design and estimation of data consolidation effort for auto finance system upgrade

ETL Lead & Data Architect

Responsibilities:

• 10 month role to orchestrate onshore and offshore jointed development efforts ( 10 technical resources) to delivery ETL solution using Informatica PowerCenter 7 with unstructured data Option
• Responsible for data model and ETL design of control/balancing and file audit/tracking component of ETL solution for Sarbanes-Oxley (SOX) compliance requirements
• Designed, and implemented Logical data model and Physical Data model for financial reporting data mart
• Coordinated with report development team to resolve potential reporting versioning
• Conducted Informatica architecture design and code review for offshore development team

ETL architect, Data Architect

Responsibilities:

• 12 month role to construct data conversion solution to move large volume of health plan history claims data from Mainframe DB2 into National Health Plan Underwriting System RDBMS
• Designed and implemented data models, optimized partition and index for underwriting schemas

ETL Lead, Data Warehouse Architect

Responsibilities:

• 4 month role to develop methodologies and framework for data warehouse data integration architecture for 8 operating regions
• Responsible for developing ETL effort estimation for data warehouse project plan and release plan
• Performed data model reviews and documented as-is and to-be of data availability and structure to support analytical reporting needs
• Performed data profiling to identify data gaps and data quality issue

Enterprise Data Modeler, Report developer

Responsibilities:

• 3 month role to design and build system configuration management reporting tool using MS SQL server
• Designed and created Logical and Physical data models for system configuration management reporting data mart

Oracle SQL Performance Tuning

Responsibilities:

• 3 month role to perform Oracle SQL tuning for Java embedded SQL and PL/SQL using execution/explain plan and index strategies
• Guided Java developers through SQL, PL SQL re-write session to ensure system response time meet service level agreement

Enterprise Data Modeler, ETL Developer

Responsibilities:

• Designed, created and maintained LDM and PDM for ODS and Financial reporting data mart using Erwin
• Designed, built and tested ETL components using Informatica
• Designed and built Data Dictionary for Meta data management

Confidential, Irvine, CA

System Analyst

Responsibilities:

• Conducted supply chain system assessment on logistics, inventory and distribution performance using Six-Sigma methodology