PROFESSIONAL SUMMARY:

• With overall Seven plus (7+) years of experience as a dedicated Business Oriented Professional, worked as Oracle PL/SQL Developer using the Oracle Relational Database Management System (RDBMS), Integration Analyst, Oracle Data Integrator (ODI), ETL Developer, and Data
• Warehouse Analyst. Expert in Data Modeling, OLAP, ETL Design and involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Development, Testing, Performance Tuning, Implementation, Troubleshooting and error handling in ETL process using ODI 12c/11g/ 10.1.3.4/10.1.3.5, with timely delivery against aggressive deadlines.
• Good experience in working with versions of ODI like 12c, 11g and 10x.
• Extensive development experience for the Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server, DB2, Flat Files and XML Files into ODS (Operational Data Store) and EDW (Enterprise Data Warehouse) systems.
• Expertise in all ODI tools such as Topology, Operator, Designer and Security Manager.
• Experience in creation and management of Master and Work repositories for all the environments like Dev, Test and Production.
• Good experience in handling interfaces, mappings and implementing complex business rules using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Good experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
• Optimized the knowledge modules to improve the functionality of the process.
• Good experience on Oracle SQL and PL/SQL.
• Experience in writing, testing and implementation of Procedures, Triggers, Functions and Packages at database level using PL/SQL.
• Worked with Star Schema/Snowflake schema design, Fact and Dimension tables and Physical and Logical data modeling.
• Experienced in implementation of Type - II Slowly Changing Dimension (SCD) logic in ODI environment.
• Expert in SQL and extensively involved in writing scripts for Data Analysis, Manual and Automated Testing.
• Experience in debugging Interfaces and Identifying bugs in existing Interfaces.
• Hands on experience in Performance Tuning at ODI and Database levels.
• Extensively experience in development of E-LT and ETL Mapping in Oracle Data Integrator.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Experience in Business Requirement Analysis and Data Analysis.
• Worked on Retail, Banking and Financial domains in ODI Projects.
• ODI Best Practices Implementation.
• Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
• Motivated to take independent responsibility as well as to contribute to be a productive team member.
• Strong Team Building and Mentoring skills and excellent Team leadership capability.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, ASP.NET, HTML, CSS, JavaScript, XML, C, C++

Operating Systems: Windows XP, Windows 7, Windows 8, Linux/UNIX

Database: Oracle 12c/11g/10g/9i/8x, SQL Server 2000/2005,SQL*Plus, SQL*Loader

ETL Tools: ODI (Oracle Data Integrator) 12c, 11x,10x, Informatica 9, 8x.

Reporting Tools: OBIEE 10.x/11g

DB Tools: TOAD, SQL Developer

Other Tools: MS Office, Microsoft Project, Adobe Photoshop and Adobe Dreamweaver

Data Modeling/ Warehouse: ERwin Data Modeler r8 / r7, Dimensional Data Modeling-Star, star and snow flake model, ETL, ELT, OLTP, OLAP, SQL, PL/SQL, Stored Procedures, Triggers, Data Loading and Integration.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL/ODI Developer

Responsibilities:

• Created numerous ODI Interfaces (Mappings in ODI 12c).
• Worked with ODI Graphical (Designer, Topology Manager, Operator and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration, Service)
• Performed reverse engineering of tables using ODI Designer tool.
• Created, executed and managed E-LT processes using ODI.
• Error handling in ODI using the E$ tables of CKM
• Customized ODI Knowledge modules like Loading Knowledge Modules and Integrated Knowledge Modules.
• Preparing documents for every mapping and Data Migration document for smooth transfer of project from development to production environment.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-Write on MVs.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Staging the Source Data from XLS, CSV, XML and Access into Oracle Database.
• Cleansing and transforming the data.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in ODI environment.
• Implemented Incremental update merge for FACT and DIM mapping.
• Email Notification using ODI Send Mail Tool.
• Experience with Performance Tuning for Oracle RDBMS.
• Imported data from XML and flat flies to load them into Data Warehouse.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Optimized SQL statements, PL/SQL blocks, created and modified triggers and procedures to enhance the performance of project.

Environment: ODI 12c, PL/SQL, SQL, SQL Loader, Toad, ETL, ERwin 7.x, Flat files, Oracle 11g/10g, MS SQL Server 2008/2005, OBIEE 10.1.3.x, Shell Programming, SQL Developer, Toad, Unix scripting, Windows, OBIA/BI APPS 7.9.6/7.9.5.

Confidential, Orrville, OH

Lead / Sr. ODI Consultant

Responsibilities:

• To understand organizations business requirements and functionality.
• Interacting with client for appropriate requirement specifications.
• Modeling the data structure of the target warehouse to store the required information.
• Measuring the overall accuracy of the data by setting up data quality rules.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Designed, developed ODI (Oracle Data Integrator) objects for ETL Project, gathering requirement specification documents and identifying data sources.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order etc.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and Created the Process flows, ER-Diagrams, High Level architecture diagrams.
• Designed and developed complex Interfaces using oracle data integrator (ODI) that involved Slowly Changing Dimensions, Error handling, SCD types.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.
• Designed, developed and modified materialized Views, Tables, Packages, Functions and Stored Procedures.
• To implement the Business Rules, created PLSQL database triggers.

Environment: ODI 12c/11g / 10.1.3.4, ODQ, PL/SQL, SQL, SQL Loader, Toad, ETL, Flat files, Oracle 11g/10g, Shell Programming, Toad, SQL Developer, Unix scripting, Windows XP

Confidential, Houston, TX

ODI Developer

Responsibilities:

• Designed, developed ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Installed ODI studio on Citrix windows 2003 server and created privileges to DW team.
• Involved in creating Data warehouse Star schema using ERwin 7.3, with multiple Facts and Dimension tables.
• Customized Emails to send out all the details about every ODI object like interfaces, variables and packages with No of inserts, updates, errors and which object has error out for what reason.
• Installed, Maintained and Documented the ODI setup on multiple environments.
• Migrated and converted CSV and flat files from multiple sources to ORACLE 11g.
• Involved in design, development of ODI (formerly known as Sunopsis) for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.
• Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements.
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.

Environment: Sunopsis/ODI, OBIEE, GDW, Oracle Applications 11.0.4,12.1.2, SQL Server, Toad, ERwin 7.2, B2,SQL Server, Toad, ERwin 3.5.

Confidential, Paramus, NJ

Lead / DW (OWB) Developer

Responsibilities:

• Involved in writing project documentation.
• Imparted to team members in OWB and Data Warehousing concepts.
• Helped the team in fixing technical issues and tuned database queries for better performance.
• Developed and implemented a strategy for the install and configure of Oracle Warehouse Builder 11G.
• Developed various ETL mappings in OWB for extracting data from various sources involving flat files and relational tables.
• Various kinds of transformations were used to implement simple and complex business logic. The mappings involved extensive use of transformations like Filter, Router, Expression, and Union for loading data into target tables.
• Support OWB database and data warehouse production support which requires off-hour availability and connectivity.
• Ability to document new and enhanced functionality in the form of ETL specification documents.
• Performance tuning OWB ETL mappings to diagnose slow performing mappings and develop solutions to improve mappings performance.
• Ability to analyze existing ETL code OWB mapping, PL/SQL and determine impacts and remediation.
• Create Oracle Workflow and schedule jobs.
• Used Lookup Transformation to access data from tables, which are not the source for mapping.
• Solely responsible for the daily loads and handling the reject data.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Changed some stored procedures in Oracle 9i as per the Business Requirements.
• Used SQL tools like SQL Navigator to run SQL queries and validate the data in warehouse.
• Used workflow manager and work flow monitor to run and monitor jobs.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Associated with Production support team in various performances related issues.

Environment: OWB 10g, PL/SQL, SQL Navigator, DB2, Teradata SQL Assistant.

Confidential

OWB /ETL Consultant

Responsibilities:

• Mentored and guided offshore team in identifying the performance bottlenecks, ETL Tuning, Error Handling and resolving other technical challenges.
• Managed client relationship with quality output and providing optimal support.
• Delivering a comprehensive business intelligence and data warehousing (BI/DW) solutions.
• Creation of Dimensions, Facts for the Star schema design.
• Extensively worked on creating multi-level with Multi-hierarchy Dimensions.
• Staging of Legacy data into Oracle using OWB.
• Creating maps for Extraction, Transformation and Loading process in OWB.
• Also worked extensively on designing complex transformations with Delete/update options for the SCD.
• Design and develop configuration files, tables, views, functions procedures and complex Dynamic insert or update scripts using Toad; implemented best practices to maintain optimal performance.
• Created system for capturing, reporting, and correcting error data.
• Generating UNIX Shell Scripts.
• Performed Performance Tuning tasks.
• Interacting with the Business teams and executing the changes in the data.
• Review peer documentation.
• QA Testing and Preparing the assumptions and Exceptions Document.
• Provide on-call support to production system to resolve any issues.

Environment: OWB 10g, PL/SQL, SQL Navigator, Toad, ETL, Flat files, Shell Programming, UNIX scripting, Windows XP.