PROFESSIONAL SUMMARY:

• Around 10+ years of progressive experience in the field of Business Intelligence and Data warehousing
• Functional exposure in creating data modeling for data warehousing
• Exhaustive Customer interaction across geographies
• Experience in creating ETL mappings and workflows by using OWB, Informatica and ODI
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases
• Experience in installation and configuration of Oracle Business Intelligence Applications, Oracle Warehouse Builder, Informatica, Oracle Data Integrator and Oracle Database
• Proficient in implementing ETL QA procedures and Exposure to all stages of Software Development Life Cycle
• Expertise in performance tuning of the mappings, ETL Environments, procedures, queries and processes
• Experience in creating Business Model layers, Dashboards, and Reports in OBIEE
• Experience in installation and configuration of Hyperion sharedservices,Planning and FDQM
• Experience in implementing OBIA Finance, Procurement and Spend,HRMS and EAM analytics
• Experience in all phases of the project (Discovery, Design, Development, Testing, Deployment and Production Support) including Business Requirement gathering and GAP Analysis

TECHNICAL SKILLS:

ETL Tools: Oracle Data Integrator,Informatica,Oracle Warehouse Builder,FDQM

Reporting tools: OBIEE,Oracle BI Apps,Hyperion

Tools: SQL Developer, Toad, PL/SQL Developer

RDMS: Oracle

Operating System: UNIX, Linux, MS Windows

Languages: SQL, PL/SQL

EXPERIENCE SUMMARY:

Confidential

Software Engineer

Responsibilities:

• Analysis of business needs and in corporate the same into the ETL Design and Implementation.
• Good understanding of Dimensional Modelling using Star schema and Snow Flake schema
• Extensively worked on ETL tools (i.e. Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer) for creating Sources/Targets, Mappings/Mapplets and Reusable Transformations.
• Monitoring and trouble shooting of the loads (post MTP/Pre Prod Test Load) and load stabilization.
• Extensively worked on SCD types mapping/Interface creation.
• Extensively worked on creating to schedule the workflow/Process flow.
• Implemented complex business rules in Informatica by creating re - usable transformations, robust mappings/mapplets, utilizingvaried transformation logic like lookups, router, filter, expression, aggregator, joiner, update strategy, normalizer and more
• Expertise in handling and loading high volumes of data into data warehouse in a given load window
• Extensive experience in integrating disparate data sources (flat files, XML, CSV) with multiple relational databases
• Support for CIT & SIT activities and defect fixing.
• Expertise in Developing strategy and system design for data flows from the various systems - from traditional OLTP and the legacy systems, into the OLAP (Data warehouse).
• Extensively involved in writing Initial evaluation and High level/Low level design documents pertaining to Business requirements considering their functional aspects.
• Extensively worked on installing and Configuring OBIEE and OBIA Applications with Informatica and DAC.
• Extensively worked on Development/Customization of OBIEE/OBIA Repository across Physical, BMM and Presentation Layers and configuring metadata objects as per design.
• Developed many complex Dashboards/Reports with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBI Presentation Services.
• Configured iBots to deliver proactive alerts and notifications to the key reporting users to obtain daily and weekly reports.
• Implemented both Object level and Data level security by creating roles and web groups accordingly.
• Design Hierarchies for Dimensions and specifying the Logical Level for Metrics for Reporting needs.
• Administration and Performance Tuning of Reporting Objects (Dashboards/Reports) in Answers.
• Involved in customization of DAC and providing Support/Troubleshooting of DAC Loads to ensure that all the extracts are completing within the specified Time window.
• Analysis and Trouble shooting of all ongoing Production support incidents/issues pertaining to Analytics and Data warehouse towards fixing the issues.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBI Repository.
• Involved in OBIEE Repository and Web catalog migration from DEV - QUAL - PROD environments.
• Implementation of OBIEE Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones
• Involved in Detailed Hardware level Design for Installation and Configuration of Hyperion Products
• Extensively worked on installation and configuring of Hyperion Products i.e. Shared Services, Planning, Essbase, HFM, FDQM, FR.
• Experienced in Extracting and loading the cubes/dimension from Hyperion as well to Hyperion using ODI.

Confidential, Mooresville, NC

Informatica Developer

Environment: Informatica, Teradata, Mainframe and Linux

Responsibilities:

• Analysis of Lowe’s deliverables such as Business Requirement Document (BRD) / Business Solutions Document (BSD) and Data Models.
• Work on solution design and access to proper environments.
• Analyze design data models and develop high level design (HLD) / solution specification document (SSD) for ETL (Extract Transform Load) outbound feed.
• Utilize Lowe’s Global Integration Center (GIC) as well as CSC leading practices for ETL.
• Design / Build / Test and Deploy.
• Develop and Unit Testing of Informatica ETL code and Mainframe jobs to move data from source directly to target, utilizing staging areas if necessary.
• Perform migration of ETL code and support migration to production environment.
• Collaborate with operational project teams for test data and test environment preparation.
• Conduct ETL Test Analysis, Test Planning, Test Preparation and Test Execution phases.
• Test Environment & Data Coordination.
• Support for CIT & SIT activities and defect fixing.
• UAT support for test planning, preparation and execution phases for the time period identified in the Project Milestone Schedule.
• UAT Support consists of coordination with program team for data availability, attendance of UAT meetings with users, attendance of UAT defect triage meetings, responding to and resolving ETL defects identified during UAT, and data capture and data refresh as needed in environment.
• Support for migration of ETL objects to production environment.
• Post Deployment support for 4 weeks following ‘go live’ date of the project.
• Weekly activity Status Report.

Confidential

ETL Consultant

Environment: Informatica 9 and OBIEE 11.1.1.7, OBIA 7.9.6.4, Oracle EBS R12.1.3 and DAC 10.1.3.4.1

Responsibilities:

• Requirement gathering and Analysis
• Created SCD Type I, II and III Using informatica power center designer.
• UAT support for test planning, preparation and execution phases for the time period identified in the Project Milestone Schedule.
• OBIA Components installation and Configuration
• Customization of BI,Informatica and DAC
• Security level implementation(Datalevel,Object level and Column level)
• Deployment and Production Support
• Implementation of OBIEE Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones

Confidential

ETL-Lead Consultant

Environment: OBIEE 11.1.1.7.1 , ODI 11.1.1.7.1 , Oracle EBS R12.1.3, OBIA 11.1.1.8.1 and Linux

Responsibilities:

• Requirement gathering and Analysis
• System and Solution Design
• Data Modeling and Design
• OBIA configuration/ELT Custom interface/BI custom Reports

Confidential

ETL-DWH Lead Consultant

Environment: OBIEE 11.1.1.7, OBIA 7.9.6.4, Oracle EBS R12.1.3, Informatica 9.x and DAC 10.1.3.4.1

Responsibilities:

• Requirement gathering and Analysis
• Created SCD Type I, II and III Using informatica power center designer.
• UAT support for test planning, preparation and execution phases for the time period identified in the Project Milestone Schedule.
• OBIA Components installation and Configuration
• Customization of BI,Informatica and DAC
• Security level implementation(Datalevel,Object level and Column level)
• Deployment and Production Support
• Implementation of OBIEE Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones

Confidential

BI Lead Consultant

Environment: OBIA 11g, OBIEE 11g, ODI 11g, EBS R1213, Sieble 8 and Oracle 11gDB

Responsibilities:

• Installation and Configuration of OBIA/OBIEE
• Requirements Gathering and Analysis
• Solution Design
• Datamodel Design document
• Security level implementation(Datalevel,Object level and Column level)
• Custom ELT interfaces,packages,scenoris
• Custom OBIEE reports/Dashboard and RPD
• Production Support

Confidential

Hyperion Admin/ODI Technical Consultant

Environment: Hyperion 9, Hyperion 11, SQL Server, PeopleSoft

Responsibilities:

• Installation and Configuration of Hyperion 9.3.1
• Upgraded the Hyperion 9.3.1 to 9.3.3
• Upgraded the Hyperion 11.2.1
• ELT Development
• Production Support

Confidential

Hyperion Admin/OBIA Consultant

Environment: OBIA 7.9.6.3, Informatica, DAC Hyperion 11, EBS R1213

Responsibilities:

• Installation and Configuration of OBIA 7.9.6.3
• Installation and Configuration of Hyperion
• Created SCD Type I, II and III Using informatica power center designer
• Created ETL Mappings using various transformations like source qualifier, Filter, mapplet,Lookup,Update stragey etc.
• Security Implementation for OBIA
• ELT Development for Hyperion
• Production Support
• Implementation of OBIEE Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones

Confidential

ETL Consultant

Environment: OBIA 7.9.5.2, ODI 10g, EBS R1150

Responsibilities:

• Installation and Configuration of OBIA 7.9.5.2
• ELT Development for custom Datawarehouse
• Production Support

Confidential

Hyperion Admin

Environment: Hyperion, Oracle

Responsibilities:

• Design Hardware details for Development, UAT and Production environment
• Installation and Configuration of Hyperion Products

Confidential

BIAPPS Consultant

Environment: OBIA 7.9.6.2, Informatica, DAC, EBSR12.

Responsibilities:

• Installation and Configuration of OBIA products
• Configure functional configuration for all the modules
• Deployment, Production Support and Maintenance

Confidential

BIAPPS Consultant

Environment: OBIEE 10.1.3.x, OBIA 7.9.5 and Informatica 7

Responsibilities:

• Installation and Configuration
• Requirements Gathering and Analysis
• High level/low level Design
• Development and Testing
• Deployment and Production Support