SUMMARY:

• Result oriented senior IT professional with over 24 years of experience implementing Data Warehouse, Business Intelligence(BI) and ETL/ELT(Data Integration) projects across several verticals/sectors and Customer, Supplier, Hierarchy Master Data Management (MDM).
• Implemented Data Governance and Master Data Management - Hierarchy Management and Multi-Domain project
• Defined governance processes around data quality, data security, and data integrity
• Implemented Bill Inmon and Ralph Kimball Methodologies.
• Has thorough knowledge in Data Warehouse and Data Mart Design and Data Warehouse Bus Architecture, Designed Relational (Entity Relationship) and Dimensional (Star/Snow Flake Schema) Data Models
• Designed and developed Extract, Transform, and Load (ETL) Architecture using Informatica Velocity Methodology
• Have worked on OBIA (Supply Chain & Order Management/Sales, Finance, Project Analytics)
• Created OBIEE RPD, Reports Dashboards, Created execution plans in DAC.
• Defined key business drivers for the data warehouse initiative, Delivered a project scope that directly supports the key business drivers, Worked on Estimation, Project Management & Co-ordination, Delivery Management
• Involved in pre-sales activities like study and analysis of business process, proposing solution, creating POC, responding to RFI & RFP and deal closing

KNOWLEDGE

Technologies:

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2003/2000, Sybase 12.5/11.x, DB2, and Teradata

ETL: Informatica 9.x/8.x/7.x/6.x/5.x/4.x, Data Stage 8.x/7.x, PL/SQL, TSQL, ODI

BI (Reporting): OBIA 7.9.x, OBIEE 11g/10g, Cognos, Business Objects, Tableau, Qlikview

MDM and Data Quality: Oracle Hyperion Data Relationship Management 9.x(MDM), Informatica (Siperian) MDM 9.x, IDQ, IDD

Data Modeling: Erwin and Power Designer

ERP: Oracle Apps 11/12.1.x, JDE

Industry/Vertical Expertise: Finance/Banking, Insurance, Telecom, Oil and Energy, Human Resources, Healthcare, Manufacturing & Logistics

PROFESSIONAL EXPERIENCE:

Confidential, CA

Solution Architect

Responsibilities:

• Providing Architectural and Technical Guidance to project team for conversion from Legacy System to Application Database
• Coordination with Development and QA team for quick turn around with regards to delivery of quality deliverables
• Implemented Best Practices and Documentation Templates for all phases of SDLC
• Hands on development using Informatica, PL/SQL, OBIA Data Warehouse
• Managed and Supported Product and Customer MDM.
• Managed Communications with Stake holders
• Managed and Monitored Production Implementation Release Cycles
• Onsite-Offshore Co-ordination

Technologies: Oracle 11g, Informatica 9.5.x, IDQ, Informatica MDM, Oracle SQL Developer, OBIA-OBIEE, Cognos10.2, Linux

Confidential

Technical Program Manager

Responsibilities:

• Providing Architectural and Technical Guidance to project team
• Managing and monitoring project deliverables and status reporting
• Coordination with Development and QA team for quick turn around with regards to delivery of quality deliverables
• Report Development
• Managing communications with stake holders

Technologies: Oracle 11g, Informatica 9.5.x, Informatica Data Quality, Oracle SQL Developer, Cognos10.2, Linux

Confidential

Onsite Architect/Coordinator

Responsibilities:

• Managing a team of 25 resources
• Creating execution plans and tasks in DAC
• Reviewing and Migrating code to Production
• Conducting sessions with BAs and Technical Teams
• Helping Data Modeler in modeling SCM BI Custom Solution
• Tracking Project Status and Reporting to Stake Holders
• Involved in customization of SCM and CommOps Modules
• Maintained and enhanced Product MDM.
• Providing Technical Guidance to the Technical Architects, ETL and OBIEE Reporting teams

Technologies: Oracle 11g, Informatica 8.x, Informatica MDM, Oracle Apps R11, OBIA 7.9.5, PL/SQL, OBIEE 10g/11g, DAC 10.x, Linux and Toad

Confidential

Solution Architect

Responsibilities:

• Architecting and Managing SCM BI Custom Solution project, Upgrade from OBIA 7.9.6.2 to 7.9.6.3 and OBIEE 10g to 11g
• Creating execution plans and tasks in DAC
• Conducting sessions with BAs and Technical Teams
• Creating Data Model for SCM Custom Solution
• Tracking Project Status and reporting to stake holders
• Providing Technical Guidance to the Technical Architects, ETL and OBIEE Reporting teams

Technologies: Oracle 11g, Informatica 9.x, Oracle Apps R11/12, OBIA 7.9.6.3, PL/SQL, OBIEE 10g, DAC 10.x, Oracle Data Modeler, Linux, and Toad

Confidential

Manager

Responsibilities:

• Managing SCM BI Solution project
• Conducting sessions with BAs and Technical Teams
• Tracking Project Status and report back to Vertical Head
• Creating Demo and POC for clients, to win business from client.
• Pricing the solution for market penetration and revenue generation
• Providing Technical Guidance to the Architect, ETL and Reporting teams

Technologies: Oracle 11g, PL/SQL, MS SQL Server, TSQL, OBIEE 10.1.x, Qlikview, Business Object, Oracle Data Integrator

Confidential

Architect - Contractor

Responsibilities:

• Architecting ETL solution for RBI Regulatory Reporting
• Interacting with client technical staff for technology solution briefing
• Involved in requirement gathering and Source System Analysis, Kimball Matrix to map dimensions and facts
• Helped create Logical and Physical Dimensional Data Model
• Guided team to develop Source to Target attributes mappings specification, and ETL Strategy, develop Test Strategy

Technologies: Oracle 10g, PL/SQL, ODI

Confidential, San Jose, CA

Technical Manager

Responsibilities:

• Project was related to implementation of Data Mart for Sales Enablement Program for Confidential
• Involved in requirement gathering and Source System Analysis, Kimball Matrix to map dimensions and facts.
• Created Logical and Physical Dimensional Data Model.
• Developed Source to Target attributes mappings specification, and ETL Strategy.
• Designed OBIEE Reports and Dashboards.
• Managing support activities
• Interface with MDM repository
• Design Test Strategy

Technologies: Oracle 10g, PL/SQL, Informatica 8.6, OBIEE 10.1.x, Teradata, MS SQL Server, TSQL, PostgreSQL, Access, Toad, $U and Kintana

Confidential, TX

Manager

Responsibilities:

• Created hierarchies in Data Relationship Management (DRM) with the help of DRM functions such as Import, Blender
• Created properties in DRM(MDM) for metadata attributes of Financial Management and Financial Planning applications
• Created validations, verifications and Property Queries for maintaining data quality within DRM(MDM)
• Created export, export books for Financial Management and Planning
• Created DIM/Informatica mappings, Sessions, Workflows for loading metadata from DRM (MDM) into Financial Management and Planning applications
• Created automation (batch) script for executing DRM export and loading metadata into Financial Management and Planning, using DIM workflows.
• Conducted brain storming sessions with business users to gather information
• Defined Data Governance (DG) Policies, Standards and Best Practices
• Helped client setting up DG committee, Identified Application, Data Stewards
• Created jobs in Datastage for execution of complex transformations.

Technologies: Oracle’s Hyperion Data Relationship management (MDM), Oracle 10g, Hyperion Financial Management, Hyperion Planning, Informatica, Data Integration Management (DIM) Adapter, Datastage v8, Mercury Quality Center, and Windows Batch

Confidential, AZ

Data Architect

Responsibilities:

• Data modeling, Developing Use Case diagrams
• Develop Conceptual/Analysis, Logical and Physical data models.
• Create DDL scripts for generation of database.

Technologies: Informatica PowerCenter 6.2, Oracle 9i, Toad, Shell, Oracle Designer 6i, Rational XDE, Visio, MS Project 2000, cccHarvest, UNIX (Solaris), and Windows XP/2000

Confidential, NJ

ETL Lead

Responsibilities:

• Contribute in requirement gathering and studying existing documentation and analyzing business users requirements
• Lead a team of developers and monitor status
• Create technical specifications documents
• Well versed with IIW (Insurance Information Warehouse) Model
• Design and develop mappings. Implement changes in Test and Production.
• Develop Shell scripts for ETL automation and batch process
• Promote changes within different environments (copying mappings, sessions and workflows between repositories)
• Define a suitable architecture for data integration from multiple, disparate data sources
• Review/analyze existing ETL design solutions; identify issues and provide new design solutions
• Define technical requirements, Technical Design & direct the ETL process, including data quality & testing
• Informatica repository/server administration, Back up repository

Technologies: Informatica Powercenter 6.2, Oracle 9i, PL/SQL, DB2/UDB, Business Objects V6.X, Toad/SQL Navigator, Shell, Erwin, Visio, Autosys, MS Project 2000, PVCS, UNIX (HP-UX Superdome) and Windows XP/2000

Confidential, VA

ETL Lead

Responsibilities:

• Define a suitable architecture for data integration from multiple, disparate data sources
• Review/analyze existing ETL design solutions; identify issues and provide new design solutions
• Define technical requirements, Technical Design & direct the ETL process, including data quality & testing
• Informatica repository/server administration, Back up repository

Technologies: Informatica Powercenter 6.2, Oracle 9i, PL/SQL, Business Objects V6.X, Toad/SQL Navigator, Shell, Erwin, Visio, Autosys, MS Project 2000, PVCS, UNIX (HP-UX Superdome) and Windows XP/2000