We provide IT Staff Augmentation Services!

Bi/dw (odi) Consultant Resume

SUMMARY

  • Over 10+ years of industry experience in architecting data - related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
  • ODI: 5+ 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, Metadata.
  • 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.
  • Extensively worked with large Databases in Development, Testing and Production environments.
  • Strong knowledge on OBIEE and Oracle Pl/SQL
  • Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • 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.
  • 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.
  • Self-starter, entrepreneurial, highly motivated team- player with excellent communication / problem-solving skills. Quick learning ability vis-à-vis new technology
  • Hands on experience on Big Data (HIVE,PIG), Tableau

TECHNICAL SKILLS

ETL Tools: Oracle Data Integrator.(ODI 11g)

BI Tools: OBIEE, Cognos reporting tool

RDBMS: Oracle 11i/10g/9.x/8.x, SQL Server 2005,MS Access

Languages/Scripting: SQL, PL/ SQL,UNIX Shell Scripting

Operating Systems: UNIX/LINUX, MS-DOS, Windows NT/2000/XP

Design / Application Tools: Microsoft Visio (Visio Soft Diagram), TOAD, SQL Navigator, SQL Developer etc.

PROFESSIONAL EXPERIENCE

Confidential

BI/DW (ODI) Consultant

Responsibilities:

  • Created ODI jobs to replicate the existing process of Shell scripts and SQL scripts Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target
  • Created ODI Package of various complexity and automated process data flow
  • Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment
  • Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same.
  • Created Topology connection for reading xml logs and writing into oracle db.
  • Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
  • Created ODI Interfaces to load data into ODS for downstream systems.
  • Created ODI Interfaces to load data into dimension and fact tables for traffic and billing data mart.
  • Used IKM, LKM, JKM & CKM knowledge modules to create ODI Jobs for data loading.
  • Created packages and it’s scenario to automate loading jobs.
  • Created Shell scripts to archive source files in the server
  • Used ODI to build performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
  • Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.

Confidential, Clearwater, FL

Senior ODI Developer

Responsibilities:

  • Asses the system requirement for Oracle Data Integrator (ODI) software Installation as per Oracle guidance.
  • Gathered ELT requirements from Business team and designed its high level documents.
  • Installed and configured the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings.
  • Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
  • Configured ODI Agents on Windows server and tested them to execute and schedule ODI Scenarios.
  • Setup Security for accessing ODI s/w by creating groups and users into Security Manager.
  • Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.
  • Installed and configured ODI 11g on windows environments.
  • Created and configured ODI 11g Agent and Installed it as a window services.
  • Implemented mappings in ODI 11g using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components.
  • Debug the mappings using debugger to resolve code issue.
  • Used RCC (Repository consistency check) utility to check consistency of both master and work repositories before doing upgrade
  • Involved in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Worked in importing data from heterogeneous data sources like database, flat file, XML files, excel.
  • Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
  • Export/Import interfaces, packages and it’s scenarios across different environments.
  • Implemented Interfaces for loading Source data into Staging area and Staging data into Dimension and Fact tables of Reporting Data mart.
  • Designed end to end ELT process flow and implemented it using ODI packages.
  • Created static and dynamic variables and used them as declare, set, evaluates and refresh types.
  • Implemented ODI procedures to execute pre and post process commands such as disable and enable Indexes.
  • Implemented Success and Failure Notifications into ODI Packages.
  • Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.
  • Created test cases for end to end and rated testing of ELT Packages.
  • Performed unit and system testing of ELT Packages.

Environment: Oracle 11g, ODI, ODI 11g, TOAD, PL/SQL, DB2

Confidential

Senior Developer

Responsibilities:

  • Responsible for developing, supporting and maintaining the ELT (Extract, Load and Transform) processes using Oracle Data Integrator (ODI).
  • Installation & configuration of Oracle Data integrator, configuration of Master and Work Repository.
  • Responsible for Design, Development and implementation of multiple ODI interfaces
  • Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service).
  • Responsible for issue resolution and performance tuning of ODI Interfaces.
  • Created Source and Target systems physical and logical data server connections into ODI Topology Manager
  • Created ODI Variables and used it into ODI interface, Procedure and Packages
  • Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
  • Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
  • Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
  • Used Refresh, Set and Evaluate ODI variables types into ODI Packages
  • Created Scenarios of ODI Packages for migrating code into Prod execution repository
  • Migrated Code from Development to Testing to production.
  • Created Views, Functions, Procedures and Packages in PL/SQL for ODI process.
  • Identified and fixed bottlenecks and tuned the complex ODI Interfaces for optimized performance.
  • Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans

Environment: Oracle 11g, ODI 11g, SOL*Plus, TOAD, SQL*Loader, Shell Scripts, UNIX, Siebel 8.2.2.

Hire Now