SUMMARY

• Around 8+ years of experience as developer in ODI, Oracle ETL developer, Business Analysis, Requirements Gathering, Development, Testing and Administration of Data Warehouses and Client/Server systems using industry standard methodologies.
• Extensive development experience in Extraction, Transformation and Loading of data from multiple sources such as Oracle EBS 11i, SAP ECC 6.0, Oracle 11g, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Hands on experience on dealing with ODI Knowledge Modules like RKM, LKM, IKM and JKM, CKM.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, OLTP and Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Expertise in developing Slowly Changing Dimension mappings using Type1, Type2 and Type3.
• Worked on ODI 11g and 12c studios using Data Warehousing tools like OBIEE, ODI.
• ODI: 4+ years of extensive DW experience using Oracle Data Integrator, Configuration and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Meta-data.
• 3 years of experience in SQL/PL/SQL and Java using different databases.
• Performance tuning the ODI jobs to improve execution performance.
• Hands on experience in installing and configuring the Oracle Data Integrator (ODI) tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Worked extensively with complex Interfaces using ODI. Expertise in implementing complex business rules by creating ODI Interfaces, using ODI Best Practices.
• Extensively used OBIEE Administration Tool for developing/customizing the Physical layer, the Business Model and Mapping layer and the Presentation layer according to the business requirements.
• Experience in debugging Interfaces.
• Modifying KMs to meet performance requirements.
• Expert in creating data visualizations such as dashboards, parameterized reports, drill down reports, and interactive reports using SSRS
• Hands on experience on developing Page level Reports, Dashboards, and Stories Using Microsoft Power BI.
• Extensive experience in implementing self-service reporting capabilities using SQL Server Analysis service, Power BI and Report Builder.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts.
• Experience in analyzing, requirement gathering, documenting and editing Business/User Requirements.
• Worked on implementing the Point of Sale in various projects.
• Designed and developed Informatica mappings from scratch to load the data from Source system to Staging system and Warehouse system.
• Code migration between the Development/QA/Prod environments, support and maintenance of daily production jobs.

TECHNICAL SKILLS

ELT Tool: ODI 12c/11g/10g

OBIEE Infrastructure: OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g/11g

OBIEE Applications: OBIA 7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing,Supply chain)

Database: Oracle10g/9i/8i, SQL Server, MS Access, OLAP.

Languages: SQL, PL SQL, Shell scripting.

Operating System: Windows 95/98/2000/XP, Windows NT, UNIX.

Database Tool: TOAD, SQL plus 11.x/10.x/ 9.x/ 8.x, SQL Developer 4.0.2.15

Query Tools & Utilities: SQL Developer, SQL*plus, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Ada Grand Rapids, MI

Sr. ODI/OBIEE DEVELOPER

Responsibilities:

• Responsible for gathering Business requirements, preparation of business requirement Specification document and performed Gap and Data Analysis.
• Developed Source to Target Mappings using ODI Designer to load data from source systems to target database, implementing the business rules.
• Developed processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on Reverse Engineering Knowledge Module (RKM), Loading Knowledge Module (LKM), Integration Knowledge Module (IKM), and Service Knowledge Module (SKM).
• Used ODI to implement CDC through Journalization Knowledge Modules (KM’s).
• Granted privileges to the ODI users using Security Manager and purged the logs in operator.
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc.
• Implemented logic to archive the source files with date stamp affixed after the successful load.
• Created variables, procedures, packages in ODI as part of Integration needs.
• Created the ODI interfaces to populate the data from files to staging tables.
• Built data visualizations in Power BI Desktop and Power BI Service.
• Designed dynamic visuals using Bookmarks, Slicers, custom tooltips in Power BI.
• Code migration between the Development/QA/Production environments, support and maintenance of daily production jobs.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Implemented the Simple Change Data Capture for stage tables available in Oracle database.
• Created the packages and Load plans to execute the mapping steps and generated the scenarios for scheduling.
• Created packages and generated the scenarios and created load plans and scheduled job on daily, bi weekly and monthly.

Environment: ODI 12.2.2.1.0 , Oracle 12.1.0.2.0 , SQL*Plus, SQL Developer, SQL, Power BI, Tableau, DB2 and UNIX.

Confidential, Buffalo, NY

Sr. ODI/OBIEE DEVELOPER

Responsibilities:

• Played an active OBIEE developer role.
• Developed OBIEE reports for the end users and also trained the users on the reports usage.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Customized out of the Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications
• Used PL/SQL Developer for running SQL queries.
• Competent in understanding the functionality of the core Oracle financial modules and their interplay in the overall accounting structure of an organization.
• Extensive experience on creating BI reports in different subject areas, critical analysis and upgrade of the existing reports
• Performed gap analysis and provided a timeline for the requirements.
• Implemented External Table and BI SQL group provider security
• Setting/Migration of users/groups and security to new environment.
• Implemented Usage tracking to know the usage of the reports & dashboards.
• Involved in the security part of the project like adding users & providing the necessary Access Rights.
• Implemented Object and Data level security.
• Developed interactive dashboard using various objects such as embedded content, images, text, charts etc.
• Generated tableau dashboards with combination charts for clear understanding
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD).
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Designed Report Templates using XML publisher.
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Performing Unit testing, providing test cases for the QA team (TCOE).

Environment: ODI 12.2.2.1.0 , Oracle 12.1.0.2.0 , SQL*Plus, SQL Developer, Tableau SQL, DB2 and UNIX.

Confidential, Houston, TX

Sr. ODI/OBIEE DEVELOPER

Responsibilities:

• Engaged in design reviews to ensure that all established design standards are being followed, functional performance requirements are met and development standards are adhered to.
• Involved in designing of new POS (Point Of Sale) systems and Customer engagement applications.
• Designed and developed ODI mappings, variables, sequences, packages, procedures, scenarios for integrating Oracle retail applications like RMS/ReSA, Xstore (Pos), Customer Engagement (Cloud), Order Broker (Cloud), Order Management Systems (Cloud), data warehousing with JDA MMS.
• Worked on ODI 12c installation and configuration.
• Performance tuning of SQLs, ODI CDC mappings. Scheduling ODI jobs, configuration, monitoring and altering mechanisms.
• Participation in architecture and design sessions with team members.
• Used Topology Manager to manage the data which is used for describing the information systems, physical and logical architecture.
• Developed ETL code to extract data from DB2 source system to Oracle, SQL Server and other SQL databases.
• Created reusable mappings for most complex requirements.
• Created complex mappings with transformation objects such as Joins, Expressions, Filters, Case, Variables, Sequence, etc., to implement complex logic.
• Code migration between instances DEV, UAT, Performance Testing and PROD.
• Monitored incremental and full load of data ODI.
• Worked with the Oracle support by creating SR tickets.
• Created cross technology procedures between IBM DB2 and Oracle in ODI.
• Created different kind of variables (e.g. to fetch last run date) and used them in the ODI interfaces.
• Worked on Loading and Integration KM in flow tab in ODI Interfaces. Created all the types of ODI variables and used in the packages for automation of jobs.
• Involved in writing test cases and data validation before moving an application into testing environment and documenting the same.
• Code deployment using ODI import and export option and verifying the import report generated by ODI.
• Modified ODI mappings, procedures for various ETL loads to delimited files, CSV files and XML files.
• Implemented error handling functionalities and mappings in ODI.

Environment: ODI 12.2.2.1.0 , Oracle 12.1.0.2.0 , SQL*Plus, SQL Developer, SQL, DB2 and UNIX.

Confidential, Fort Worth, TX

Sr. ODI/OBIEE Developer

Responsibilities:

• Resolved day to day production issues.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, MS SQL Server and Oracle) feeds using PL/SQL and ODI.
• Involved in gathering requirements to implement OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and answers) using Repository Variables, Session Variables.
• Gathering requirements from users to develop interfaces, packages, load plans.
• Worked on data integration blueprint. Installed, configured and tuned ELT infrastructure.
• Produced catalogues of logical and physical schemas. Database design and implementation for numerous applications used by several devices in retail space such as scanner, POS (Point of Sale).
• Experience in dimensional modeling such as Star Schema, Snow-Flake Schema, creating facts, dimensions and Measures.
• Created SQL scripts for sourcing data which includes creating tables, materialized views, stored procedures, and loading data into the tables.
• Used ODI Designer for importing tables from database, reverse engineering to develop projects, and release scenarios.
• Used user functions for converting date format from AS400 to Oracle.
• Implemented Synchronous and Asynchronous Change Data Capture (CDC) techniques.
• Used Knowledge Modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking and integrating it.
• Applied slowly changing dimensions (SCD) in various mappings to load data from source to target and maintained current and historical data year wise in all brand dimensions.
• Used OBIEE 11g/10g to create dashboards and reports.
• Developed and customized the Business Model and Mapping (BMM) layer, Physical layer and Presentation layer as per the business requirements.
• Created aggregate tables in physical layer, and created dimensional hierarchy in Logical layer for several subject areas.
• Worked extensively on OBIEE Presentation Services to create reports as per the client requirements and also created, modified and formatted multiple requests along with charts and filters in BI Answers.

Environment: Oracle Data Integrator (ODI) 11g/10.1.3.4, Oracle 11g/10g, SQL Server 2008, SQL*Plus, SQL Developer, WinNT/XP, Flat Files, XML files and UNIX.