We provide IT Staff Augmentation Services!

Sr. Odi/etl Consultant Resume

Edison, NJ

SUMMARY:

  • Around 14+ years of IT experience in the Design, Development, Implementation and Testing of Enterprise Data warehouse and Data mart applications for Sales, Logistics, Costumer support, Finance, Pharma, Manufacturing, Government Agencies using Oracle Data Integrator(ODI) and Informatica Power Center, IBM InfosphereDataStage 8.5/11.5 (Enterprise Edition).
  • Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data Mart Life Cycle development.
  • Subject matter expert for OBIEE expertise in Oracle BI server, Oracle BI Answers, BI interactive Dashboards and Oracle BI Publisher
  • Experience in providing end to end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD),Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects(Dashboards, Pages, Folders, Reports).
  • Strong experience in ETL(Extraction, Transformation and Loading) process using different tools like Oracle Data Integrator (11.1.1.6), Informatica Power Center (9.5/8.5/8.1.1/7.1 ), IBM InfosphereDataStage 8.5/11.5 (Enterprise Edition).
  • Involved in Data profiling, Data cleansing and legacy Data translation using Oracle AMB and IDQ.
  • Extensively used ODI(Oracle Data Integrator) to extract data from different sources using Oracle Data Integrator tools - Security Manger, Topology Manager, Designer and Operator.
  • Performed ETL process to load data from different sources into data warehouse using Oracle Data Integrator(ODI) and Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
  • Experience in integration of various data sources databases like Oracle, SQL Server, Flat Files, Access, Hyperion, Sybase and DB2 into staging area. And also involved in migration of data from Informix 2.4, Teradata 7.1 to oracle database.
  • Extracted client information data and history from JD Ewards, SQL server, Oracle E-Biz ERP applications to OBIEE which is OLAP tool.
  • Designed and developed complex mappings and varied transformation logics using transformationslike connected and unconnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more. Experience in execution of Sessions, workflows and worklets.
  • Strong Oracle skills that include build/maintain tables and indexes, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions and performance tuning of SQL queries and Good knowledge in XML, HTML.
  • Experience in Performance tuning, Backup/Recovery of Informatica Repositories. Good knowledge in latest Domain, Node and services concepts in Informatica 8.1.1. And experience in creating web service providers and consumers in Informatica 8.1.1.
  • Worked in product based company and involved in installation and maintaining of Oracle Data Integrator (ODI) and PowerCenter 8.5 on different platforms like Solaris, Linux, AIX and upgraded from different versions latest versions.
  • Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS:

ETL Tools: InformaticaPowerCenter 9.5/8.5/8.1.1/7.1./6.1, Oracle Data Integrator(ODI) 11.1.1.5/11.1.1.6/11 g/12c, SQL Server,Data Transformation Services(DTS), Integration Services(SSIS), Oracle Golden Gate 12.1.2,IBM InfosphereDataStage 8.5/11.5 (Enterprise Edition).

ERP: Oracle E-Business Suite 12.1.1, JD Ewards.

Databases: Oracle 11g/10g, DB2 8.1, Sybase12.5.1, MS SQL Server 2000, Informix2.4, Teradata 7.1, MS Access 7.0/97/2000.

Database Modelling: Erwin 3.5.2/4.0/4.3

Data Profiling Tools: Oracle AMB, Informatica Data Quality (IDQ).

OLAP Tools: MSSQL Server 2005 Reporting Services, Business Objects 5.x/6.0, Crystal Reports, Cognos7, OBIEE (11.1.7,10.1.3.3.X, 10.1.3.4.0 )

Query Tools: Toad, SQL Navigator, SQL Assistant, SQL Developer

Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, UNIX Shell Scripting, Perl 5.1, XML, HTML.

Methodologies: Ralph Kimball, Bill Inmon.

PROFESSIONAL EXPERIENCE:

Confidential, Edison, NJ

Sr. ODI/ETL Consultant

Responsibilities:

  • Extensively involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources moving the data fromPRS (Pole Record System) to DWH.
  • Designed fact and dimension table implementation in Star Schema model based on requirements.Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
  • Migrated and converted the flat source files and xml files from multiple sources to ORACLE staging tables.
  • Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
  • Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements
  • Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
  • Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
  • Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
  • Handled error through exception handling and configured the event-based scenarios to send the alert emails.
  • Experience in Performance tuning, Backup/Recovery of ODI Repositories. Good knowledge in latest ODI11g and involved in installation and maintaining of Oracle Data Integrator (ODI) on Linux.
  • Involved in writing complex SQL’s and modified database structures including tables, triggers and user-defined functions to support application enhancements.
  • Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
  • Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards
  • For conditional and exceptional reporting used dashboard Links, Images features. Customized the appearance and text of the various objects in the user Dashboards.Created customized dashboard prompts as per the business requirement.
  • Understanding and discussing the new requirements from Business analysts through regular interaction.

Environment: Oracle Data Integrator 12C,Oracle Golden Gate 12.1.2, Oracle 12c, PL/SQL, Oracle SQL Developer.

Confidential, Basking Ridge, NJ

Sr. ODI/ETL Consultant

Responsibilities:

  • Involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 11g to DWH.
  • Involved in Installation, configuration and administration of development, execution repositories in ODI11g.
  • Built transformations, configured servers and established connections to various sources and targets
  • Created logical tables and defined the complex joins for a business model.
  • 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.
  • Migrated and converted the flat source files from multiple sources to ORACLE staging tables.
  • Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
  • Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements
  • Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
  • Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
  • Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
  • Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
  • For conditional and exceptional reporting used dashboard Links, Images features. Customized the appearance and text of the various objects in the user Dashboards.Created customized dashboard prompts as per the business requirement
  • Responsible for migrating the web catalog and RPD from DEV and PROD environments.Responsible for day to day support of dashboards in production environment.
  • Understanding and discussing the new requirements from Business analysts through regular interaction.

Environment: Oracle Data Integrator 11.1.1.5, OBIEE 11.1.1.7,Oracle Golden Gate 12.1.2, Oracle 12c, PL/SQL, Oracle SQL Developer.

Confidential, Portland, OR

Lead ODI/ETL Consultant

Responsibilities:

  • Involved in installation, configuration and administrator of Oracle utility Analytics which has different oracle tools like OBIEE, APEX, ODI 11.1.1.6, Goldengate.
  • Extensively involved in design, development of ODI for ETL Project, gathering requirement specification documents and presenting and identifying data sources moving the data fromOMS (Outage Management System- ERP) to DWH.
  • Involved in Installation, configuration and administration of development, execution repositories in ODI11g.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data warehouse.
  • Built transformations, configured servers and established connections to various sources and targets
  • Developed new dimensions, facts and aggregate tables. Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
  • Created logical tables and defined the complex joins for a business model.
  • Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance using the Security settings in Oracle Business Intelligence Administration Tool.
  • 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.
  • Migrated and converted the flat source files from multiple sources to ORACLE staging tables.
  • Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
  • Customized Email distributions to get the error messages and output from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements
  • Extensively used Oracle data Integrator to extract data from legacy to Oracle database as per mapping rules.
  • Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
  • Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
  • Handled error through exception handling and configured the event-based scenarios to send the alert emails.
  • Experience in Performance tuning, Backup/Recovery of ODI Repositories. Good knowledge in latest ODI11g and involved in installation and maintaining of Oracle Data Integrator (ODI) on Linux.
  • Involved in writing complex SQL’s and modified database structures including tables, triggers and user-defined functions to support application enhancements.
  • Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
  • Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards
  • For conditional and exceptional reporting used dashboard Links, Images features. Customized the appearance and text of the various objects in the user Dashboards.Created customized dashboard prompts as per the business requirement
  • Responsible for migrating the web catalog and RPD from DEV and PROD environments.Responsible for day to day support of dashboards in production environment.
  • Designed a customized Meta data repository (.rpd) with necessary logic.Implemented security by creating roles, web groups, and external tables.
  • Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment
  • Understanding and discussing the new requirements from Business analysts through regular interaction.

Environment: Oracle Data Integrator 11.1.1.6,IBM InfosphereDataStage 8.5/11.5 (Enterprise Edition),Oracle Business Intelligence EE 11.1.7(OUA),Oracle Golden Gate 12.1.2, Oracle 11g, PL/SQL, Oracle SQL Developer, TOAD, Redhat Linux.

Hire Now