PROFESSIONAL SUMMARY:

• Over 12 years of comprehensive & in - depth experience in the Information Technology (IT) industry with specialization and expertise in Oracle BI APPS Data Warehousing / Custom Data warehousing and Business Intelligence area. Accomplished Data Warehouse Architecture, ETL architecture and designer
• Performed overall project management, leading, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives for last 12 yrs.
• Experienced in Leading/Managing team on Business Intelligence projects.
• Experienced on working with major clients Confidential, Confidential, Confidential, Confidential, Confidential etc.
• Expert in Implementation of Warehousing and Database business Applications for Banking, Investment Banking, Insurance, Financial, Retail, Health Care, Human Resources, and Tele Com industries etc.
• Responsible for defining the information architecture and technology infrastructure along with the design of multi dimensional data models and the Business Intelligence delivery solutions
• Responsible for managing the data analysis, data sources, data mapping along with defining the meta data repository
• Delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with the top management and executives, business sponsors and IT department
• 7+ Yrs. experience in Managing/Leading DW Projects, Expert on estimation, planning, risk analysis, CMMi, Agile processes.
• Extensive experience in Oracle BIAPPS 7.9.6x,including BIAPPS 11.1.1.7.1 with ODI, OBIEE, RPD, Answers, Dashboards and reports
• Expert in Oracle BI DW and Custom Data warehouse methodologies, design, development and deployment.
• Over 12yrs of strong Data Warehousing experience in ETL architecture, Design and Implementations. Using different ETL tools like Informatica 5x/6x/7x/8x/9x, Informatica CDC, ODI Oracle Data Integrator, Composite, PLSQL, Eagle Pace, Exposed to Pentaho.
• Multi-tasking abilities; problem solving skills; Technical skills coupled with outstanding business sense.
• Presenting highly technical concepts in easy-to-understand language.
• Profound Knowledge of SDLC and Software Testing Life Cycle and processes.
• Provided leadership roles including client mentoring

TECHNICAL SKILLS:

BI/DW: ETL, Informatica 5x/6x/7x/8x/9x

Informatica CDC: BI/DW DAC, Oracle BIAPPS 7.9x, 11.1.1.7.1 with ODI, OBIEE 10G, OBIEE11G, Web logic BI/DW Data warehouse Dimensional modeling, Data modeling, OLAP, ETL methods, architect, DW performance tuning BI/DW ODI(Oracle Data Integrator), Composite, Eagle PACE, Pentaho, Cognos, Actuate

Design Tools: ERWIN, Power Designer, Oracle Designer, TOAD, SQL Developer

Database: Oracle10G, 11G, SQL, PL/SQL

Database: DB2, SQL Server

Languages: Java

OS: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle BIAPPS 11.1.1.7.1 , Windows R2 2008, Oracle Linux 5.7, Oracle Data Integrator (ODI), OBIEE 11G, UNIIX, Oracle11G

BI Lead Consultant/Client Manager

Responsibilities:

• One of the first set of implementations POC in the world on Oracle BIApps release 11.1.1.7.1 with ODI
• Lead/Manage implementation and OBIEE deployment on new BIAPPS release BIAPPS 11.1.1.7.1
• Define project plan and execute
• Leading the team on BI Apps implementation on different platforms like Windows 2008 R2, Oracle Linux 5.7
• Full load from EBS R12, OBIEE deployment, reports validations.
• Work directly with Confidential Engineering and Management team on implementation, configuration, and full load.
• Business meetings and discussions with Oracle team and KPI management LOE preparation
• Risk analysis Reviews

Confidential, Raleigh, NC

Environment: UNIIX, Oracle11G, Oracle BIAPPS (Financials, HR, Supply Chain & Order Management, Project Analytics, Service Analytics), DAC, Informatica 9.0, Business Objects

Lead BAPPS architect/Consultant

Responsibilities:

• Lead Oracle BI architect
• Define project plan for Redhat requirements and work with Redhat management to execute.
• Lead the SDLC process initiative for defining at Redhat,
• Requirement gathering and analysis, Business meetings and discussions with end users,
• Architecture design and Implementation Leading the team, Techno functional lead for different towers (Finance, HR, Sales etc), Analyzing existing Client systems to understand the existing architecture, Define Hardware and Software architecture, redesigning the existing ETL process,
• LOE preparation, Rick analysis and Management,
• Design & review DW performance analysis,
• Release management, Reviews

Confidential, Birmingham, AL

Environment: Windows7, Oracle10G, SQL Server 2008R2 used for DAC Informatica Repository, OBIEE Analytics Oracle Business Intelligence Analytics Application, OBIAPPS-PeopleSoft Adapter, Informatica 9.0

Lead Architect/ Dev team Manager

Responsibilities:

• Manage the development team Onsite/Offshore
• Lead ETL Architect
• Define and implement the project plan and activities
• Lead/Mange requirement gathering team for multiple modules, Design the architecture for customizing Oracle Data warehouse. Involved in working with multiple BA team SME team, OBIEE on design and integrating custom DW model with Oracle BIDW.
• Work closely with OBIEE team on metric definition design and corresponding data, ETL requirements and design and review periodically, Analyzing existing Client systems to understand the existing architecture
• Worked on OBIEE, RPD configurations and OOTB reports, Security implementations.
• OBIEE deployment, OOTB RPD configurations, Answers and Dashboards validations
• Design of Hardware and Software architecture, Re-designing the existing ETL code for difference modules like HR, Finance, and Supply Chain. Lead performance tuning activities
• Reviews
• Release management and delivery

Confidential, San Francisco, CA

Environment: Windows/ Confidential Linux Server, Oracle Application Server HTTP Server, Oracle 9i database used for DAC Informatica Repository, and Oracle 10g for OBIEE Analytics Oracle Business Intelligence Analytics Application, OBIAPPS-PeopleSoft Adapter, Informatica 9.0

BI Lead Consultant /Architect

Responsibilities:

• Lead ETL architect, Requirement study and analysis.
• Design DW architecture and ETL methodologies for custom DW and integration with Oracle BIDW
• Discuss with Client side Point of Contacts and fetch requirements/facts about existing system.
• Analyzing existing Client systems to understand the existing architecture
• Design of Hardware and Software architecture
• Leading performance tuning activities
• Closely work with OBIEE development in order to make sure the report requirements are met.
• Design the presentation Layer and develop reports
• Lead the SDLC process and reviews.

Confidential, San Deigo, CA

Environment: Linux Server, Oracle Application Server HTTP Server, Oracle 10G database used for DAC Informatica Repository, and Oracle 10g for OBIEE, Oracle Business Intelligence Analytics Application, OBIAPPS-PeopleSoft Adapter, Informatica 8.6.1

Architect/Technical Lead/Manager

Responsibilities:

• Onsite Manager/Lead Architect, Lead requirement gathering team for multiple modules
• Reviews, Release management and delivery
• Work with business and management on project status updates and reviews
• Design the architecture for customizing Oracle BIAPPS Data warehouse
• Redesigning the existing ETL code for difference modules like HR, Finance, and Supply Chain.
• Worked on OBIEE OOTB RPD configurations, answers, dashboards and reports
• Worked on implementing security on OBIEE RPD
• Work with multiple BA team SME team, OBIEE on design and integrating custom DW model with Oracle BIDW
• Work closely with OBIEE team on metric definition design and corresponding data, ETL requirements and design.
• Analyzing existing Client systems to understand the existing architecture
• Design of Hardware and Software architecture
• Lead performance tuning activities

Confidential, San Diego, CA

Environment: Windows/ Confidential Linux Server, Oracle Application Server HTTP Server, Oracle 9i database, and Oracle 10g for OBIEE Analytics, Informatica 8.6.1, Control M, Informatica CDC

Dev team Lead/manager/Architect

Responsibilities:

• ETL lead/ Architect for the team, Requirement study and analysis.
• Design of requirement specifications,
• ETL infrastructure, design, implementation
• Control M design and Implementation
• Design the ETL architecture to bring data from DB2 environment using CDC, Analyzing existing Client systems to understand the existing architecture, Design of Hardware and Software architecture
• Worked closely with offshore and onsite team leading the ETL & Data model activities.
• Design Performance tuning of ETL infrastructure.
• Define LOE
• Define the project plans
• Make sure the SDLC process and reviews.
• Single POC for the deliverables.

Confidential, Atlanta, GA

Environment: Linux Server, Oracle 9i for Informatica Repository, Oracle 10g for DW OBIEE Analytics, Informatica 8.6.1

BI Lead Consultant

Responsibilities:

• Requirement study and analysis, Design of requirement specifications
• Design the ETL architecture to bring data from multiple source systems,
• Design the data model and extend current DW model to accommodate the new data set from multiple environments.
• Discuss with Client side Point of Contacts and fetch requirements/facts about existing system.
• Design of Hardware and Software architecture, Performance tuning of ETL infrastructure
• Work with multiple team members on a leading responsibility to make sure the delivery.
• Gap Analysis and Discussion with client to further modifications to set expectations and report SLA.
• Closely work with OBIEE team to make sure the report requirements and metric definitions are corrected on ETL and data model perspective.

Confidential, San Deigo, CA

Environment: Confidential Linux Server, Oracle 10g, OBIEE Analytics Oracle Business Intelligence Analytics Application, OBIAPPS- EBS, Informatica 8.1.1

BI Lead Consultant

Responsibilities:

• Requirement study and analysis, Design of requirement specifications, Design the ETL architecture to bring data for BIAPPS out of box mappings. Discuss with Client side Point of Contacts and fetch requirements/facts about existing system, Analyzing existing Client systems to understand the existing architecture, Performance tuning of new Mappings, Used EBS adaptors for Order management. Execution plan, run and Monitor it, Fix error on both DAC and Informatica side during the run. Gap Analysis and Discussion with client to further modify/customize reports, Environments in compliance with Oracle best practices.

Confidential

Environment: Windows/ Confidential Linux Server, Oracle Application Server HTTP Server, Oracle 9i database used for DAC Informatica Repository, and Oracle 10g for OBIEE Analytics Oracle Business Intelligence Analytics Application, OBIAPPS-PeopleSoft Adapter, Informatica 8.1.1

Sr. OBIEE Consultant/ETL Architect

Responsibilities:

• Requirement study and analysis, Design of requirement specifications, Design the ETL architecture to bring data for BIAPPS out of box mappings. Discuss with Client side Point of Contacts and fetch requirements/facts about existing system, Analyzing existing Client systems to understand the existing architecture, Performance tuning of new Mappings, Execution plan, run and Monitor it, Fix error on both DAC and Informatica side during the run. Gap Analysis and Discussion with client to further modify/customize reports, Environments in compliance with Oracle best practices.

Confidential

Environment: Windows/ Confidential Linux Server, Oracle Application Server HTTP Server, Oracle 9i, Business Intelligence Analytics Application(Tenerife V 7.9) Informatica V 7.1.4, Informatica 8.1.1, Composite, Unix

DW Project Manager/Lead

Responsibilities:

• Involved in Project planning, Requirement study and analysis, Review,/design of requirement specifications
• Discuss with Client side Point of Contacts and fetch requirements/facts about existing system. Analyzing existing Client systems to understand the existing architecture, Design the ETL architecture to bring data from various sources, Gap Analysis and Discussion with client to further modify/customize reports.

Confidential

Environment: Windows/SUSE Linux Server Environment, Oracle Application Server HTTP Server, Oracle 9i database used for DAC Informatica Repository, and Oracle 9i,10g for Business Intelligence Analytics Application, Informatica V 7.1.4

DW Lead

Responsibilities:

• Review meetings and discussions with client side managers and team. Requirement gathering and discussions with client side Business Analysts, Analysis of the requirements and interact the same with offshore development team regarding the design and implementations. Release of the requirements after review and signoff.
• Requirement study and analysis. Design of requirement specifications, Implementation of Sales Analytics
• Discuss with Client side Point of Contacts and fetch requirements/facts about existing system. Analyzing existing Client systems to understand the existing architecture, Design of Hardware and Software architecture
• Designed and developed a custom star schema. Involved in Design, development, testing.

Confidential

Environment: Oracle 9i, Informatica 7.1.1, Informatica RT, UNIX, Toad, Erwin 4.5, Citrix Windows 2000 Server

Senior ETL designer, Associate DBA, SQA

Responsibilities:

• Integrated metadata management to ensure standardized and consistent data definitions.
• Standardized data flow between source- and -data systems and central reporting and calculation Systems, Connectivity to various data sources and data providers independent of target data structure
• Provision of a centralized business rules layer for transformation and mapping, Data management layer for validation and transformation, refinement and enrichment of source data
• Lead the team in absence of the Project Lead. Assigning jobs to the TM. Reporting the status of the project to the management
• Interact with the client. Designing of Technical documents.
• Designing the Informatica sources and targets for JMS messages.
• Creation of different XML parser and XML generator transformations. Designing and optimizing the Mappings. Designing and scheduling the workflow. Managing the repositories.
• Informatica Performance tuning.
• Design and development of various interfaces.

Confidential

Environment: Oracle 9i, Informatica 6.1, Cognos 6.5, Windows 2000 Server

Senor ETL Developer, Business Analyst

Responsibilities:

• Executed data warehouse solution for Shipper Services, in the consulting capacity.
• Creation of Informatica repository and Administration of Informatica
• Design and development of various ETL mappings using Informatica.
• Managed defect prevention by convening causal analysis meetings at regular intervals.
• Experienced in Data warehouse, Data Modeling and Database Designing and all aspects of software and data warehouse development and related quality processes.
• Directly worked with project management and contributed for improving team planning, time management, productivity and quality at project application level. Extensive expertise in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets in Informatica6.1.
• The aim of the project was to source the data from the present OLTP systems to the
• Data warehouse and to create standard &ad-hoc reports from the Data warehouse using the Power Tool Cognos 6.5.

Confidential

Environment: Oracle9i, Informatica 5.1, Windows NT, SQL*LOADER,UNIX

Informatica developer

Responsibilities:

• Design and development of Data Warehouse,
• Creation of repository using Informatica Repository Manager
• Creation of the various transformations,
• Designing and optimizing the Mapping,
• Configuring and Scheduling Sessions in Server Manager,
• Configuring Informatica Server for loading of data, Creation of User Classes and assigning privileges, Informatica Server Performance tuning.

Confidential

Environment: Oracle 9i, Informatica 5.1, Cognos6.1, Erwin 3.5, Windows NT

Informatica developer

Responsibilities:

• Design and development of ETL mappings
• Creation of repository using Informatica Repository Manager
• Creation of the various transformations,
• Designing and optimizing the Mapping,
• Configuring and Scheduling Sessions in Server Manager,
• Configuring Informatica Server for loading of data,
• Informatica Server Performance tuning.

Confidential

Environment: Oracle 9i, Informatica 5.1, Cognos 5.0, Erwin 3.5, Windows NT

Informatica developer

Responsibilities:

• Design and development of ETL mappings
• Configuring and Scheduling of sessions,
• Configuring Informatica Server for loading of data,
• Informatica Server Performance tuning,
• Analyzed the specifications and identified the source data that needs to be moved to the data warehouse.
• Involved in Logical and physical database design using ERWIN, Developed various kinds of mappings

Confidential

Environment: Oracle 9i, Informatica 5.1, Cognos 5.0, Erwin 3.5

Informatica developer

Responsibilities:

• Design and development of Data Warehouse,
• Creation of repository using Informatica Repository Manager
• Creation of the various transformations,
• Designing and optimizing the Mapping, Configuring and Scheduling Sessions in Server Manager,
• Configuring Informatica Server for loading of data,
• Informatica Server Performance tuning.