PROFESSIONAL SUMMARY:

• Around 8 years of IT and over 5 years of experience in Business Intelligence and Data warehousing, Data Modeling, ETL Design, Database Development using ODI, OBIEE, SQL, PL/SQL, Oracle 11g/10g/9i/8i in Windows and Unix environments.
• Expert in developing ETL for supporting Data Extraction, Transformation and Loading using ODI/Synopsis
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Third Normal Form (3NF), SCD, Surrogate keys, Normalization/De-Normalization.
• Worked extensively with complex interfaces using ODI. Expertise in implementing complex business rules by creating ODI interfaces
• Experience in Installation of ODI 10g/11g/12c.
• Performed loading of delta changes to target table with CDC and Time stamp process.
• Performed Versioning of ODI objects using external versioning tools and using internal ODI versioning using Solutions.
• Upgrading from ODI 11G to ODI 12c 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 12c.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions table and Physical and Logical data modeling
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Developed database objects like functions, triggers and packages using PL/SQL.
• Commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Experience in Installation, Configuration, and Administration of OBIEE 11.1.1.3 / 10.1.3.4.1
• Extensively worked with Administration Tool to customize the RPD in all the layers Physical, BMM and Presentation Layers.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Used PL/SQL Collections, BULK Collect, For ALL, Table Types, and Record Types.
• Wrote complex stored procedures and packages .
• Extensively used Analytical Functions Rank, Dense Rank for complex reporting purposes and hierarchical data
• Create new tables, views, materialized views, Packages, Stored Procedures and functions per the requirements.
• Developed database objects like functions, Store Procedures, triggers and packages using PL/SQL.
• Created packages and procedures to automatically drop and create views.
• Expertise in dynamic SQL, collections, exception handling, database design.
• Implemented CDC through ODI Journalized Knowledge Modules (KMs).
• Excellent analytical and interpersonal skills and strong ability to perform as a team.
• Ability to produce clear documented and commented code.

TECHNICAL SKILLS:

Application Tools: Reports 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, OBIEE 10.1.3.x

BI Tools: OBIEE 10g/11g, BI Publisher 10g/11g

Databases & Tools: Oracle 10g/9i/8i/7.x, TOAD, SQL*PLUS,SQL* Loader.

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, XML.

Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

ETL Tools: ODI 10g, ODI 11g, ODI 12c

Methodologies: Dimensional Data Modeling Logical / Physical

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Senior Oracle Data Integration/ Data warehouse Developer

Responsibilities:

• Worked with Business Users to understand requirement and perform gap analysis before starting development.
• Created technical documentation related to development work and submit it to Manager for approval.
• Worked with DBA team to create tables, Indexes, Constraints as required.
• Involved in ODI upgrade from 11g to 12c.
• Was part of validation to team unit test mappings after upgrade from 11g to 12c.
• Created numerous ODI Interfaces (Mappings in ODI 12c).
• Invloved in Product Support to monitor nightly batch run and fix issues within time to meet SLA.
• Worked with ODI Graphical (Designer, Topology Manager, Operator and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration, Service)
• Performed reverse engineering of databases using ODI Designer tool
• Used ODI Security manager for managing users and permissions
• Used ODI Designer in order to generate documentation for the application
• Used ODI Topology manager module to manage the data information systems physical and logical architecture.
• Created, executed and managed ETL processes using ODI.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
• Implemented Incremental Load mappings for Fact mapping.
• Email Notification using ODI Send Mail Tool.
• Imported data from XML and flat flies to load them into Data Warehouse leveraging ODI Agent memory to cache data.
• Customized knowledge module to include Oracle Hints, which improves query performance
• Ran Explain Plan to check the cost of query and tune the query with necessary changes.
• Involved in understanding Java code for the current business process and rewriting them into ODI (Oracle Data Integrator) objects like interfaces, procedures, variables, functions and packages.
• Optimized SQL statements, PL/SQL blocks, created and modified triggers and stored procedures to enhance the performance of project.
• Wrote PL/SQL blocks to handle large data volume to perform Insert/Update/Delete operations.
• Created log tables while handily hundreds of millions rows to make sure if the job fails, it will pick up with the indicators logged in the log table.
• Using ODI, Developed, maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• 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 PL/SQL database triggers.
• Migrated code from one environment to other by creating versions using Sub-Version Tool (SVN).

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

Confidential, Hartford, CT

Senior Oracle Data Integration Admin/ Developer

Responsibilities:

• Interacting with client for appropriate requirement specifications.
• Performed extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements
• Identifying source data that concerns specifying business rules to transform source information into key indicators.
• Modeling the data structure of the target warehouse to store the required information.
• Populating the indicators by implementing business rules
• Measuring the overall accuracy of the data by setting up data quality rules
• Designed, developed ODI (Oracle Data Integrator) objects for ETL Project, gathering requirement specification documents and presenting 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, Golden gate Change Data Capture and Business logic implementation.
• 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.
• Helped QA team in writing the appropriate 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.
• Implemented CDC through ODI Journalized Knowledge Modules (KMs).
• Designed, developed and modified materialized Views, Tables, Packages, Functions and Stored Procedures.
• To implement the Business Rules, created PLSQL database triggers.
• Assisting DBA with installation and configuration of Oracle Data Integrator (ODI)
• Assisted DBA with upgrading ODI 11g to ODI 12c
• Created and managed Master and work repositories for Dev, Test and Production environments.
• Customized Emails to send out all the details about every ODI object like interfaces, variables and packages with No of inserts, updates, errors.
• Migrated and converted the flat source files from multiple sources to ORACLE 11g.
• Created and configured topology manager including data servers, physical and logical schemas, agents, contexts.

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

Confidential, Irving, TX

Oracle Data Integrator/ PLSQL Developer

Responsibilities:

• Analysis and design of current ETL implementation.
• Installed and configured the Oracle Data Integrator (ODI) Setup
• ODI Installation, Configuration, creating master and Work repository. Setup of Topology, data Stores, projects and Security as ODI administrator
• Used Oracle Data Integrator for performing ETL, Data Integration, Data Cleansing efforts.
• As per the business requirement created source to target mappings using filters, joins and different SQL expressions.
• Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Analytics.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer in OBIEE 11g.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Assigned Object level and Data Level Security.
• Developed Repository from scratch based on Business requirement.
• Responsible in configuring Data Servers used in the project using Topology Manager.
• Played a crucial role in assigning USER PROFILES to developers.
• Interacted with SME’s to gather subject area specific requirements and developed Packages using the developed interfaces, procedures and variables.
• Used PL/SQL functions to perform control logic.
• Debug the sessions by utilizing the logs of the sessions.
• Responsible for Metadata Administration and managed models and reverse engineering.
• Responsible for Topology Administration and performed actions through the topology manager module.
• Involved in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Extensively worked on Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables
• Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Used BULK COLLECT and External Tables for improving performance.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Performance Tuning of ETL jobs by providing appropriate knowledge modules.
• Customized Knowledge Modules (KM) to meet specific interface requirements.
• Creating backups for the interface and also exporting and importing the interfaces from one project to another.
• Worked on error handling for complex interfaces.
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.

Environment: ODI 10g/11g, OBIEE 11.1.1.7.0, BI Publisher 11.1.1.7.0, Oracle 11g/10g, TOAD, SQL, PLSQL, Windows 2008 Server and Linux.

Confidential

Oracle Data Integrator/PL/SQL Developer

Responsibilities:

• Extensively used ETL to load data from Oracle, XML files and flat files.
• Worked on complex mappings in ODI to map the source xml data with Oracle Data Servers
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces.
• Developed different procedures, Packages and PL/sql program Units in Oracle Database.
• Configured ODI agent and leveraged Knowledge Modules to define workflow and task automation
• Installed ODI, created and configured master, work repositories and the agent
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Identifying the poor performing SQL’s & PL/SQL blocks and fixing the tuning issues.
• Developed PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.
• Worked on Partitioning and indexing concepts (Local and Global) indexes on partition tables.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Configured Oracle Data integrator (ODI) Master Repository & Work Repository on Oracle Database.
• 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 Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (ODI).
• Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle Data Mart.
• Understanding the developed project in OWB and implemented the concepts in ODI.
• OGG is used ODI with the best possible performance to implement CDC concept.
• Used Knowledge modules LKM, RKM, IKM and JKM and Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it etc.
• Fixed several customer performance issues in Oracle Database
• Managed and maintain different ODI Versions using ODI Solution
• Developed several business flows and models in ODI
• Worked on several customer enhancements in ODI
• Customized ODI KM like LKM and IKMs
• Tested different business flows
• Prepared technical design documents
• Involved in implementing new module using Java, Pl/Sql
• Deploying and testing web services components in WebLogic Server
• Involved in bug fixing of existing programs and delivery in a short time frame

Environment: ODI 10g/11g, OBIEE 11.1.1.7.0, BI Publisher 11.1.1.7.0, Oracle 11g/10g, TOAD, SQL, PLSQL, Windows 2008 Server and Linux