SUMMARY:

• Result orientedsenior IT professional with over 24 yearsof experience implementing Data Warehouse, BI and ETL(Data Integration) projects across several verticals/sectors and Hierarchy Management (MDM) for Financial Management and Planning.
• 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,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 knowledge of OBIEE. 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 Tools: Informatica9.x/8.x/7.x/6.x/5.x/4.x, Data Stage 8.x/7.x, PL/SQL, TSQL, ODI

BI Tools: OBIEE 11g/10g, Cognos, Business Objects, Tableau, Qlikview

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

Data Modeling Tools: Erwin and Power Designer

ERP: Oracle Apps 11/12.1.2/3, 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
• Hands on development using Informatica, PL/SQL, IDQ
• Managing communications with stake holders
• Onsite-offshore co-ordination

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

Confidential, Phoenix, AZ

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, Data Quality, Oracle SQL Developer, Cognos10.2, Linux

Confidential, CA

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
• HelpingData Modeler in modeling SCM BI Custom Solution
• Tracking Project Status and Reporting to Stake Holders
• Involved in customization of SCM and CommOps Modules
• Providing Technical Guidance to the Technical Architects, ETL and OBIEE Reporting teams

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

Confidential, Durham, NC

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 R12, OBIA 7.9.6.3, PL/SQL, OBIEE 11g, 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.

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, MS SQL Server, TSQL, PostgreSQL, Access, Toad, $U, and Kintana

Confidential, Austin 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, Phoenix, 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, ccHarvest, UNIX (Solaris), and Windows XP/2000

Confidential, CT

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, CT

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

Confidential, Palo Alto, CA

Project Leader/Architect

Responsibilities:

• Defining Project Plan, complying Communications Plan, Data Quality Plan, Issue Management Plan, and Change Management Plan
• Define key business drivers for the Data Warehouse initiative & deliver a project scope
• Lead/Guide Informatica, Business Object development team in designing, developing and documenting ETL solutions
• Analyzing CKMDB Data Mart (Dimensional Model - star schema) for Analytical Reporting & Campaign Management
• Designing & Developing Informatica mappings, creating sessions and workflows for Data Loads. Used Transformations like Joiner, Expressions, Aggregator, Stored Procedure, SQ, XML SQ, Lookup, Filter, Router etc
• Data load from XML files to relational db tables

Technologies: Informatica Powercenter 7.1/6.1/5.1, Business Objects 6.1, Oracle 8i/9i, PL/SQL, Toad, Shell, Brio 5.x, Erwin, Visio, Epiphany E.5, MS Project 2000, VSS 6.0, UNIX (HP-UX) and Windows 2000/NT

Confidential, Bailey, TX

Project Lead

Responsibilities:

• Designed the various facts and dimensions, which constitute the STAR and Snow-flake schemas using Kimball's methodology
• Developed scripts using Oracle PL/SQL, Used SQL*Loader to populate the facts and dimension tables in the data warehouse
• Responsible for preparation of Technical Design Document and Test procedures for the Data warehouse
• Designed and developed mappings, maplets, and sessions.
• Used Erwin to reverse-engineer and refine business data models and forward-engineer DDL scripts for the creation of database objects
• Used DB tools like DBArtisan and Oracle Enterprise Manager
• Created reports using Cognos, Business Object, PowerBuilder, and Infomaker
• Application Testing (Unit & System Level)
• Used PFC Application, DataWindows, and Windows Services
• Migrated/Upgraded PowerBuilder Applications to newer versions
• Involved in Analysis, Design, and Development of the different projects mentioned above and prepared the System Requirement Specification (SRS), Database Design and System Design(SD) documents

Technologies: Oracle 8.0.3/8i/9i, PL/SQL, Informatica 4.7, Sybase SQL Server 12.5, 11.9.2/10.0.5 , WISQL, Cognos, Infomaker, PERL, Unisys Mainframe, Power Builder 7.0/6.5/5, PFC, SilverStream 2.5/3.7.3, Erwin, Visio, WISE Deployment Script, UNIX and Windows 9X/2000/NT