PROFESSIONAL SUMMARY:

• Around 8+ Years of professional IT experience in all aspects of Data Warehousing System Development Lifecycles (SDLC) including, requirement gathering, data modeling, development, Testing, deployment, maintenance, and enhancements using Reporting & ETL tools - OBIEE, Oracle BI Apps, ODI, Informatica.
• Business Intelligence experience using OBIEE 12c and Siebel Analytics 8.1.1, Informatica 7, 8, 9.x, ODI 11g/12c.Implemented an easy way for the Business and end users for directly modifying and updating mouse over definitions within their control from logging into Database instead of making the changes in RPD (OBIEE Repository)
• Experience in Design, Development, Analysis, Implementation, Administration, Maintenance and Support of Siebel Analytics/OBIEE 12c, ODI 11g, 12c, Informatica 9.1.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL*Loader, SQL*Plus, Data Loader, and TOAD.
• Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise Data Warehouse (EDW).
• Extensive DW experience using Oracle Data Integrator (ODI), Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
• Experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling experience using Normalization, Fact and Dimensions Tables, Physical and Logical Data Modeling.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Strong understanding of the principles of Data Warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Modified OWB Mappings that populated large Confidential tables.
• Analyzed the Business requirement for OWB and Mapped the Architecture.
• Strong working experience with Data migration and Data integration projects
• Thorough knowledge of Software Development Life Cycle (SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing
• 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.
• Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Expertise in creating stored procedures, functions, packages, triggers, collections and bulk collections using PL/SQL.
• Experience with Oracle DML and DDL scripting.
• Experience in planning space allocation, partitioning, creating and managing table spaces.
• Expert in 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.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Experience with Application development in an Oracle Environment, Data Modeling / Relational Database Design
• Strong experience with data transfers and data sharing using flat files, database links, and web services.

TECHINICAL SKILLS:

ETL Tools: Oracle Data Integrator(ODI) 12C/11G, Informatica.

Reporting Tools: OBIEE

Database: Oracle 12C/11g/10g, MS SQL Server.

Languages: SQL, PL/SQL, C, HTML

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

Database Tool: TOAD, SQL Developer, SQL Plus

Other: Visio, MS Office, WebSphere, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

ODI Developer

Responsibilities:

• Gathered business requirements and prepared mapping specs.
• Designed and developed interfaces to load the data from multiple sources like Relational databases,flat files (.txt, .csv, .xlxs) into oracle database.
• Created reusable mappings to implement in main mappings.
• Created complex mappings with business logic to extract data from SQL Server.
• Used global and project variables (declare, evaluate, refresh)
• Created scenarios with multiple variables input/default values.
• Applied hints on ODI to extract and load data.
• Created complex mapping with multiple source columns data to 1 target column.
• Deployed code to test/UAT/production environments.
• Versioned all ODI objects, unit test documents, and scripts to TFS.
• Created alerts process to send email notification via OdiSendMail.
• Unit tested ODI mappings and procedures and documented all unit test cases.
• Took all the responsibilities of data integration, migration and conversion,
• Worked with OWB for relational, dimensional and metadata modeling. Built ETL solutions using OWB for various automated data migration processing.
• Extensively worked with PL/SQL packages, Stored Procedures based on the requirements provided by business.
• Developed Complex database objects like Stored Procedures, Functions and Triggers using SQL and PL/SQL.
• Created Tables, Indexes, Views, Triggers. Created Oracle packages with advanced SQL queries like analytical and aggregate functions to process and load daily enrollment files.
• Direct experience with Java application and/or systems integration.
• Writing complex PL/SQL scripts, packages, procedures, functions and DB triggers to implement the business logic and database jobs and File I/O tasks.
• Responsible for designing, developing, and testing of the ELT strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI.
• Hands on experience on working with ODI Knowledge Modules like, Golden gate knowledge module LKM, IKM and JKM, CKM.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Worked on customizations to the ODI Knowledge Modules as part of tuning the Knowledge Module Code based on the requirements.
• Developed packages for the ODI objects and scheduled scenarios using them.

Environment : Oracle 11g/12c, ODI 11g/12c,OWB, PL/SQL Developer, TOAD.

Confidential, Des Moines, IA

OWB/ODI Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
• Created different schemas and maintained schema objects.
• Created web forms using Hyperion planning 9.3.1.1.
• Involved in all the phases of the project from Planning, Discovery, Requirements Gathering, Design, Construction, Testing, Pilot and Deployment.
• Created new models and work flows for different data sources Oracle DB, MS SQL Server and flat files using ODI.
• Used ODI Topology Manager graphical tool to manage the data describing the information systems physical and logical architecture.
• Engaged full life cycle Essbase implementation in Hyperion 9.3 to consolidate multiple outlines for bank retail incentive plan.
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Tuned procedures SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, Auto trace and DBMS Application Info.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

Environment: Oracle Database 11g/10g, ODI 11g, SQL*Loader, SQL, PL/SQL, SQL*Developer Loader, ETL.

Confidential, Houston,TX

ODI/OWB Developer

Responsibilities:

• Created Master and Work Repository and developed the ODI mappings.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Customized the knowledge modules as required by business design as most of the data was in BLOB data type.
• Implemented the Change Data Capture (CDC) feature of ODI to minimize the data load times.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Implemented and enhanced different Knowledge Modules in mappings for loading and integrating the data from sources to targets.
• Created ODI Packages and Scenarios to execute all the mappings, procedures and shell scripts together and in desired order.
• Created procedure and inline view in ODI to divide the data which was as whole tag in the source.
• Used Security Manager to create users and profiles.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Used ODI Scheduler Agent to execute scenarios via predefined schedules or on demand.
• Responsible for performance tuning, debugging of ODI objects.
• Creating ODI Interfaces for data transfer from source to staging and also from staging to target
• Creation of staging area and operational data store (ODS) for accumulating periodical data from various data sources including legacy database.
• Parallel Design and Development on Interface Development based on the Source of the Data for Multiple Work Repository (Development).
• Created multiple work repositories for each environment (Dev, UAT, Prod).
• Understanding and processing PL/SQL Procedures, Functions and other objects into ODI.
• Used Explain Plan utility to trace and tune the slow moving processes and to review the overall processing for efficient and closed loop processing.
• Tuned mappings and PL/SQL procedures by defining hints, degree of parallelism, tweaking loading parameters and executing them in parallel threads.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Customized the appearance and text of the various objects in the user Dashboards.
• Created customized dashboard prompts as per the business requirement
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Responsible for day to day support of dashboards in production environment.
• Improvise query performance using SQL Query and filters, thus aiding in smooth operation of the query execution
• Troubleshoot the process or production issues and resolve the problems.
• Developed training documents and on-line help documents for end users.

Environment: Oracle11g, ODI 11g, OWB 10g Release2, TOAD, PL/SQL, DB2, JDE, SQL Loader, Microsoft SQL Server.

Confidential, CHARLOTTE, NC

ODI/OWB Developer

Responsibilities:

• Understood the Functionality of Duke's Application and Business requirements.
• Interacted 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.
• Modelled the data structure of the target warehouse to store the required information.
• Populated the indicators into DWH by implementing business rules
• Developed code to measure the overall accuracy of the data by setting up data quality rules.
• Designed, developed ODI 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 CDC and Business logic implementation.
• 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.
• 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, and Functions and Stored Procedures.

Environment: ODI11g, Oracle 11g, PL/SQL, SQL, SQL Loader, Toad, Flat files, Oracle 11g/10g.

Confidential, NEW YORK

ODI/OWB Developer

Responsibilities:

• Installed ODI and configured the Master and Work Repositories.
• Evolved the Topology including physical architecture, logical architecture and contexts.
• Masterminded new models for the data sources- flat files and Oracle database.
• Reverse engineered for the data sources and targets.
• Developed, supported and maintained ELT (Extract, Load and Transform) processes using Oracle Data Integrator (ODI).
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle Server.
• Implemented SCD Type 1 and Type 2 using ODI.
• Extensively used mapping operators (joiner, sorter, splitter, filter, aggregator, expression, mapping sequence, pre-mapping operator, post-mapping operator).
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
• Performed unit and integration testing. Created various test scenarios to test the application.

Environment: Oracle ODI 10.1.1.5, OWB 10gR2,Oracle9i.

Confidential

Oracle/SQL Developer

Responsibilities:

• Developed Oracle PL/SQL packages, procedures and functions.
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis
• Used Oracle Warehouse Builder to implement changes to the operational data store, as well as create data marts.
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.
• Involved in supporting and maintaining Unix shell script jobs

Environment: Oracle, PL/SQL