Overview of Qualifications

Confidential is a Strategic and Technical Lead Consultant with over 20years' experiencein the fields of business intelligence, systems integration, process improvement, master data management MDM implementation and solution architecture for global companies. He has in-depth experience in the Oil/Gas, Telecommunications, and Insurance, Retail, Pharmaceutical, Securities Financial Exchanges, Utilities, Education, Financial industries and Department of Transporation.

Technical Skills:

Software: Kalido DIW, Kalido MDM, Business modeling, Informatica PowerCenter, PowerConnect for SAP, Real Time Webservices, SOA, Business Objects XI Data Integrator, Oracle Warehouse Builder OWB, Oracle ODI 11g, ODI 12c, OBIA, Microsoft SQL server Integration Services SSIS , Microsoft SQL Server Analysis services SSAS , Data Stage, Quality Stage, DataFlux, Cognos TM1, TOAD, Autosys, VBA, Microsoft Project 2007, SQL, PL/SQL, Shell Scripting, Oracle Designer, Erwin, Visio, Informatica DAC 7.9.6.4, Maximo, Oracle Enterprise Data Quality 12.1.3 OEDQ , Oracle Data Modeler, Oracle Spatial

Databases: Oracle 9i, 10g, 11g, Sql Server 2000, 2005, 2008, Sybase, Progress

Hardware: Unix, Linux, VAX/VMS andWindows

Versioning: CMS, PVCS and Microsoft VSS

Selected Work Experience:

Confidential

• OBIA ETLs were highly customized to match TVA business requirements
• Confidential Implemented Financial Analytics, Project Analytics, Procurement and Spend Analytics, and Enterprise Asset Management Analytics of Oracle Business Intelligence Applications OBIA
• Responsible for architecting end-to-end ELT solution using ODI 12c and Oracle EDQ processes to validate and flag the erroneous records for Data Stewards to fix the data gaps.
• Worked directly with the business team to analyze their needs and priorities to develop an dimensional model to satisfy the user requirements
• Enhance and Redesignexisting Spatial UGATE Data warehouse to support current and future reporting needs and to facilitate systems integration and to provide Single Version of Truth at UDOT
• Built new Subject areas and Custom Dimension, Fact tables and Dashboards to support Maximo PM Backlog to meet TVA-business needs

Confidential

• Designed and implemented Business Intelligence solution for a Utility Company in the areas of Customer Care and Billing Analytics using Oracle Customer care Billing and MDM.
• Designed and Implemented Change Data Capture solution using Oracle Streams technology utilizing ODI Knowledge modules.
• Implemented Customer Addresses cleansing and business rules validation check processes using Oracle Enterprise Data Quality OEDQ .
• Responsible for design and development of Oracle Data Integrator ODI ETLs

Confidential

ETL Architect/ETL Lead

• Designed and implemented Business Intelligence solution for a Petro Chemical Company in the areas of cost control, financials, safety, environmental compliance, and supply chain and constructed data integration platform that includes various sources like Oracle EBS, Microsoft SQL Server databases and flat files.
• Responsible for Implementation of integration, extraction and transformation load ETL platform.
• Responsible for design and development of Oracle Data Integrator ODI ODI Interfaces, Procedure, Packages, Scenarios and Load plans and Tools .utilizing KMs for Reverse Engineering, Loading and Integration Load ODI Objects Staging tables, Dimension and Fact tables.

Confidential

ETL Architect/ETL Lead

• Responsible for design and development of Oracle Warehouse builder OWB OWB mappings and Process Flows.
• Responsible for Implementation of integration, extraction and transformation load OWB ETL platform.
• Designed and implemented AUM Usage Data Mart for a Utility Company to monitor and track the usage and the utility billing processes.
• Responsible for Unit Testing and QA testing with defect resolution.

Confidential

ETL Architect/ETL Lead

• Designed and implemented Turn-Around Cost Control TACC data warehouse solution for monitoring and reducing Turnaround costs in multiple Chevron Refineries.
• Managed software design and technical architecture of complex system, using project management and planning skills to minimize development time and maximize client acceptance.
• Led a group of technical on-shore and off-shore developers and support team.
• Responsible for Implementation of integration, extraction and transformation load Datastage ETL platform that includes various sources like Maximo, Primavera, SAP, Ariba, Microsoft SQL server databases and flat files.
• Designed a generic architecture which gives the flexibility to add more refineries in the future.
• Implemented Data stage Web services to invoke ETL jobs from a front-end application.
• Designed and developed Audit Engine for data reconciliation, validation, and data comparison between source and target systems at the end of daily ETL runs.
• Created Datastage design templates for developers to start-up with coding from technical specifications.
• Designed Datastage jobs and sequences and automated them to meet project daily reporting needs.

Confidential

ETL Architect/ETL Lead

• Deployed a robust business intelligence solution that increased the ability to monitor Meter to Bill process on a daily basis and provided the ability to reconcile source system Meter Determinants
• Designed and implemented generic Visio Mapping template that facilitated automatic generation of Informatica ETL mappings which reduced significant time and effort.
• Lead development initiative to adhere Informatica best practices and standards outlined in Informatica's Velocity Methodology.
• Worked extensively on Informatica partitioning when dealing with large volumes of Meter Reads dataand also partitioned the tables in Oracle for optimal performance.
• Led a group of technical on-shore and off-shore developers and support team.
• Managed software design and technical architecture of large complex system, using project management and planning skills to minimize development time and maximize client acceptance.

Confidential

ETL Architect

• Deployed a centralized POIDM Data mart and Reporting solution to increase the visibility, monitoring, tracking and reporting the critical point of interest POI information.
• Worked directly with the business team to analyze their needs and priorities and developed strategies to deliver and successfully implement the POIDM Data Mart reporting solution.
• Used DataFlux as an ETL to load Source data into Cision Target database.
• Converted Cision Migrator Sql Server Stored procedures into highly maintainable DataFlux Architect jobs.
• Confidential DataFlux Consultant
• Responsible for ETL design to implement Informatica POC and built ETL framework and completely automate and deploy the end-to-end solution.Designed OBIEE Analytics reports and Dashboards for POIDM data mart.
• Designed DataFlux architect jobs as a template jobs to be used in Batch mode/real-time mode which can accept input from Web services.Established DataFlux best practices and Naming conventions standards.

Confidential

TM1Architect

• Implemented CognosTM1 cubes by extracting data from PeopleSoft EPM financials and HR modules.
• Developed ETL feeds through Turbo Integrator and involved in all aspects of TM1 development such as build and implement dimensions, cubes and TI processes and wrote TM1 rules.
• Automated nightly TM1 dimensions and cube refresh process through 3rd party scheduling software.
• Utilized TM1 rules to feed data between TM1 cubes.
• Implemented the TM1 ETL processes utilizing Turbo Integrator.
• Extracted the data from PeopleSoft EPM using TM1 Turbo Integrator.
• Designed Turbo Integrator process to send email notifications about the TM1 Turbo Integrator error log file in case of failure.

Confidential

Technical Analyst/Lead

• Deployed a centralized Tax Data warehouse and Reporting solution to increase the visibility, monitoring, tracking and reporting the core tax information.
• Worked directly with the business team to analyze their needs and priorities and the technical team to develop strategies to deliver and successfully implement the Tax Data warehouse reporting solution.
• Created and managed solution proposals, design documents and specifications
• Designed and Implemented PeopleSoft EPM Journal Batch Upload processes to upload Journal entries from excel spreadsheets into EPM.
• Managed integrated test system ultimately providing successful customer acceptance testing, which was a key component in making Tax data warehouse project successful.
• Performed activities including execution of test plans.
• Designed robust error and exception handling strategy.Managed and mentored development resources.
• Established ETL software development standards and processing, including informatica coding standards and peer code review processes.