Summary

• Around 7 years of experience in Information Technology in designing, developing, architecture, administration and implementation of Data Warehouse Applications under different environments. Core focus on Data Warehousing OLAP tools mainly ODI and PL/SQL.
• ODI: 4 years of extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Meta-data.
• Data Modeling: 2 years of Data Modeling experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Primary responsibility include but not limited to 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.
• Worked with Java based web technologies for analysis, design, development, re-engineering, maintenance, installation, implementing and testing of web and standalone application.
• Used Spring MVC framework to design and develop standalone application which could provide real time data of Virtual systems running on a Sun Sandbox.
• Worked extensively with various flavors of Linux systems to generate systems statistics by writing shell scripts.
• Configured hibernate to interact with backend database to interact with front end web application.

Technical Skills

Experience

Confidential

Sr.ETL Developer ODI

• Confidential is a leading wine seller in USA and Canada. They produce wines, rebrand wines and market other spirits produced in various other parts of the world. It generates sales and inventory data all across the world. They have developed a centralized Data Warehouse which sits on Exadata server which integrates data generated by it and its subsidiaries all throughout the world to generated better reports for analysis.
• Confidential involved in migrating data associated to Winerack, a subsidiary of CBI a retail chain in Canada, which sells in house produced wines. I had to integrate daily sales and inventory data generated by Winerack into Oracle Data Warehouse in daily or for a period. It involved but not limited to understanding Wirerack sales model using the legacy warehouse SQL Server procedures and tables and re-modeling data to meet standards in current system using Agile Scrum methodology. Used SAP adapter to retrieve data from iDocs to an XML file. Generate interfaces to load data from Magstar database to Oracle staging repository. Then create interfaces and procedures to transform and load data based on period based partitions in target Data Store. Performed Unit testing to validate the data loaded into target systems and check for any data loss. Create Tidal scripts to periodically execute scenarios to load data from source to destination.

Responsibilities:

• Created ODI Interfaces/Packages using ODI on daily basis.
• Created Scripts to handle History Restate of huge tables containing multiple Partitions and data ranging from few millions to 3 billion.
• Leveraged ODI 12c features such as enhanced flow control by using Splits, Joins, filter and set operators to map source with target.
• Performed ODI management which includes monitor performance of ODI, components availability, track logs and reviewing session activity to monitor database activity in detail.
• Data load from SQL Server to Oracle involving various complexities and various business transformations.
• Customized KM to support dynamic as well user provided name table.
• Automated data validation process by creating application to validate the data between two different source systems.
• Created and modified multiple pl/sql procedures and function for optimization and new ETL requirements.
• Handled multiple businesses Logic, to load the data into large table using exchange partition mechanism.
• Involved in the Analysis, Design, Coding and Testing of the application.
• Designed and created Mapping documents, ETL architecture documents and specifications.
• Created source to target mapping documents by analyzing various source systems.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical or Business Requirement issues.
• Development of detailed specifications for data management scripts.
• Designed Documents for performing unit testing and string testing of developed code.
• Good experience in ODI components like designer, topology manager, operator and on other ODI concepts Master Repository, work Repository, Project Models, sources, targets, Interfaces, Packages, Scenarios, Knowledge Modules, metadata.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Extensively used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Used ODI for Reverse engineering to retrieve metadata from data storage and load it to the repository.
• Used topology manager for registering source and target technologies along with logical and physical schemas.
• Used ODI Operator for migrating code from one environment to another by generating and deploying scenarios
• Used surrogate key assignment and change data capture.
• Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Used Operator for production support and debugging of ODI jobs
• Worked with advanced PL/SQL like Advanced queues, XML type, Object types, DBMS scheduler etc.,
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created SQL Loader control files for moving the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Used Database triggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
• Developed UNIX shell scripts in VI Editor with embedded SQL Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

Environment: Oracle Data Integrator 12c, Oracle Data Integrator ODI 11.1.1.7 , Oracle 11g, Microsoft SQL Server 2008, PL/SQL, Toad, Shell scripting.

Confidential

ETL Developer ODI

• FLPIDS ODS - Farm Loan Program Information Delivery System Operational Data Store is used for the replication of OLTP system which is being refreshed as nightly basis. The sources include Microsoft Sql server, IBM AS400 and flat files. This ODS is being used for creating the views on top of which reports are generated using the Hyperion. The FLPIDS includes several modules like Direct Loan System DLS Loan Making, Loan Servicing and Special Servicing and currently in processes to build a data mart in place of ODS and generate reports using the OBIEE reporting tool.
• 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.
• Resolving day to day production issues.
• Gathering requirements from users to develop interfaces, packages.
• Deploying Scenarios from one environment to other environment.
• Upgrading from ODI 10G to ODI 11G environment.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.
• After Upgrading in Development environment performed export and import
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Export/Import interfaces across different environments
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Experience in running RCC Repository consistency check to see if master and work repositories are consistence.
• Purged the logs in the operator.
• Performed sending mails to team whenever any ODI jobs are failed by using ODI tools.
• Worked in importing data from different sources like database, flat file, XML files, excel.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning.
• 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.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Applied 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.
• Applied CDC process where we have captured only latest data to target.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.

Environment: Oracle Data Integrator ODI 11.1.1.7/10.1.3.5, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

ODI Consultant

In this project we are Collected Contacts and Profiles information from different locations and performed ETL process and finally we performed Job master for capturing only Latest Records.

Responsibilities:

• Worked along with business analysts, developers, management professionals and as well as with business users from various locations of Amway to gather requirements.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience with Business systems such as Sales, Inventory and Order Management.
• 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.
• Used odiparam.bat file for updating recently encoded password for master repository and used startscen.bat file to start the scenario using agent. These scenarios are finally deployed to production.
• Created flow diagrams using MS Visio where data from source to Atomic, Key, ODS, Staging.
• Applied 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 Designer ODI to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Oracle Data Integrator ODI reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide various brand level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Scheduled batch jobs using ODI schedule
• Created versions for interfaces using Version control.
• Primary responsibility include but not limited to 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.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator ODI .
• Created SQL scripts for sourcing data, including 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.
• Implemented Change Data Capture CDC techniques on data model level and load updated data to target.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Validate the required data at the database level by using tool Toad.
• Used Toad for analysis and maintained Database using DDL's, DML's

Environment: Oracle Data Integrator ODI 11g/10.1.3.5, Oracle 11g/10g, SQL Plus, TOAD, WinNT/XP and UNIX.

Confidential

Software Engineer Java and PL/SQL Engineer

Had to develop a web portal and a standalone application for a Sandbox administrator to view and log various Virtual Machines deployed and running in the Sandbox.

Responsibilities:

• Used Java and Spring to develop web portal to view and log statistics of various Virtual machines in the sun's sandbox.
• Had to store its usage statistics of all the Virtual Machines in a database so that statistics could be generated and used for analysis.
• I had to develop a standalone application using Swing package for administrator to actively monitor sever usage statistics and interact with the back end sandboxes..
• Worked with the development team to design, develop, test and implement the system.
• Creating Pl/SQL Functions, Procedures as per business requirement.
• Designing and modifying of Database tables, keys, indexes, grants, triggers, packages, functions and procedures etc.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Did data profiling, data cleansing
• Developed Database Triggers for the integrity and security purpose.
• Used PL/SQL Developer Tool to do the backend development.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Wrote complex Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.
• Data loading using PL/SQL.
• Used PL/SQL Developer Tool to do the backend development.
• Handled various Exceptions to trouble-shoot PL/SQL code.
• Wrote Oracle SQL using joins, sub queries and correlated sub queries.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Develop and maintain the documentation.

Environment: Java, Spring, Hibernate, Oracle 10g, SQL Loader, SQL Plus, PL/SQL, UNIX, MS Office.