SUMMARY

• 8 years of profound working experience in Programming in SQL, PL/SQL, OBIEE, . NET. Worked extensively in developing ETL/ELT for supporting Data Extraction, Transformation and Loading using ODI.
• Experience in Data Warehousing using Oracle Data Integrator(ODI), Configured and setup ODI, Master Repository, Work repository, Projects, Models, Sources, Targets, Procedures, Packages, Knowledge Modules, Interfaces, Scenarios, Contexts etc.
• Extensive development experience in Extraction, Transformation and Loading of data from multiple sources such as Oracle , MS SQL Server, Legacy systems, Flat Files and XML Files into EDW (Enterprise Data Warehouse) systems.
• Good knowledge of Data Marts, Data warehousing, OLAP , Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Tab.
• Proficient in developing and maintenance of database objects like PL/SQL blocks, Stored Procedures, Packages, Functions, Types, and Views etc .
• Experience in development skills in Oracle tools and technologies including Oracle Forms and Oracle Reports.
• Experience in all the phases of SDLC, including requirements gathering, system design, Development, Unit testing, Integration testing, implementation and production support.
• Experience in Software Quality Assurance (QA) in Manual Testing, Database Testing, User Acceptance Testing, Regression Testing.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g, SQL Server 2012/2014 /2016

Development Tools: Toad, Oracle SQL Developer, Putty, Visual studio 2012/2010.

ETL/ELT Tools: ODI Studio 12c/11g, Informatica Power center 9.5

Version Controls: Microsoft Visual Source Safe (VSS), ClearCase

GUI: Oracle Forms 11.x,Oracle Reports 11.x

Modeling Tool: Visio, Notepad ++, Ultra-Edit, Beyond Compare

Languages: SQL, PL/SQL, .Net.

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse Engineer/ODI Developer

Responsibilities:

• Installation and configuration of ODI 12c and responsible for configuration of Master and Work repositories.
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Loaded data from different source systems to target warehouse using interfaces with Knowledge modules like LKM, IKM and CKM for data quality check.
• Used Oracle Data Integrator ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Responsible for designing, developing, and testing of the ELT strategy to populate the data from various source systems (Flat files, Oracle, SQL SERVER) feeds using ODI.
• Performed scheduling with ELT jobs using Agents in ODI.
• Created OLAP requests in OBIEE answers and multi-level requests drill-downs and guided navigation.
• Responsible for Data Modeling. Created Logical and Physical models for staging, transition and Production Warehouses.
• Configured ODI Agents on windows server and tested them to execute and schedule ODI scenarios.
• Responsible for data modeling using Toad Data Modeler by creating Fact Tables, Dimension Tables, Physical and Logical modeling.
• Involved in requirement gathering sessions for the new database, application design and development.

Environment: : Oracle 12c, ODI Studio 11g/12c, OBIEE, SQL, PLSQL,OLAP, Toad, Clear Case, Toad Data Modeler .

Confidential

Oracle/ODI Developer

Responsibilities:

• Primary responsibility include installing and configuring the Oracle Data Integrator ODI software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Created external tables to load data into oracle database from data files.
• Design, Develop, Unit Test and maintain complex Oracle partitioning, Sub-partitioning & Indexing Scheme, Create Data Models, PLSQL procedures, packages, and triggers for Data Extraction, Transformation and Loading.
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Deploying Scenarios from one environment to other environment.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• Extensively used ODI tool to create data warehousing OLAP model.
• Analyzed the Business requirement for Oracle Data Integrator (ODI) and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Designed, created and documented multiple interfaces of using the Informatica Power Center.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked with Analytic functions to compute an aggregate value based on a group of rows, aggregate functions and other different built Oracle Functions.
• Created functional and technical design documents and developing unit test case documents.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.
• Coordinated with QA and Production support teams during code deployment in their respective environments.

Environment: : Oracle 12c/11g, ODI 11g/12c, Informatica Power Center, OLAP, OBIEE, SQL Server 2016/2014R2, SQL, PLSQL, Toad, Oracle SQL Developer, UNIX, Shell Scripting, AWS.

Confidential

Oracle/ODI Developer

Responsibilities:

• Developed Oracle Database Objects: Tables, Views, Stored Procedures, Functions, and Packages.
• Developed new/ modified existing Oracle Packages, Stored Procedures for implementing Internal Risk Modeling functionality.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Worked on slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration
• Used Oracle Data Integrator (ODI) Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Involved in fixing any regression defects of the past iteration(s) all the while deploying current release and working on development simultaneously.
• Coordinated with QA team to help them understand the requirements.
• Improved execution of queries by using Bulk Collections, Indexes, and Materialized Views.

Environment: Oracle 12c/11g, ODI 11g/12c, SQL, PLSQL, Toad, Oracle SQL Developer, Clear Case, Putty.