We provide IT Staff Augmentation Services!

Data Warehouse Specialist Resume Profile

Summary of Experience: -

  • Having 10 years of diversified IT experience in all the phases of design, development, testing, migration and Application Support of full life cycle of Data warehousing and Business intelligence implementation.
  • Having 10 years of Experience in ETL methodology for Creating Source-to-Target ETL mappings to cleanse and match-merge, deploy and execute ETL mappings, Schedule, Manage, Troubleshooting, Performance-tuning Data Warehouse / ETL Loading processes using multiple tools like Oracle Data Integrator ODI , Informatica and Oracle Warehouse Builder OWB .
  • Exposure to different kind of reporting tools like OBIEE , SAP BO ,BIAPPS DAC ,Discoverer
  • Exposure to Oracle ERP application modules like GL,AR,AP and INV
  • Excellent technical competencies, understanding in the areas of Data Warehousing / Business Intelligence applications.
  • Architected and implemented multiple data warehouses and data marts. Actively involved in designing the Data Model using E/R Diagrams and Normalization with the help of ER-Win tool.
  • Proven Experience in scheduling jobs using CONTROL-M
  • Proven experience in design, construction, testing, and administration of Enterprise Data Warehouses, Data Marts, ODS and Data integration.
  • Proven Experience in RDBMS concepts and significant experience and expertise in database programming using SQL and PL/SQL that includes stored procedures, functions, Packages, collections and bulk collections etc.
  • Worked with data transformations and loading using Export/Import file packages and SQL Loader
  • Experience in writing UNIX shell scripts for regular Maintenance and Production Support.
  • Strong practical experience and exposure in Design, Analysis, Development and Implementation
  • Hands-on experience leading all stages of system development efforts, including requirements definition, design, architecture, testing, maintenance and support.
  • Designed and developed different ETL Logics on various domains to extract the data from desperate source systems.
  • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and process flows
  • Designed and developed efficient Error Handling methods and implemented throughout the mappings.
  • Interacted with Client to get the requirement specification/Clarification for ongoing process
  • Experienced and effective in visualizing and implementing creative solutions to the most complex requirements
  • Excellent communication skills, able to explain complex technical structures in an understandable user-friendly format.
  • Excellent Analytical and Problem Solving Skills.

work Experience: -

Confidential

Data Warehouse Specialist, ETL Architect, ETL Solution Design, ETL Development.

Responsibilities:

  • Worked as ETL Architect and ETL Designer in coordination with Business Analysts in gathering the requirements and designed the Source to Target Mapping Specification Documents.
  • Architected and implemented multiple data warehouses and data marts for different subject area.
  • Actively involved in data modeling using dimensional modeling with the help of ER-Win tool.
  • Involved in Dimensional modeling design for Star and Snow flake schemas.
  • Set up the ODI repositories for Development, Testing and Production. Set it up the standalone and Java EE agents on clustered Web logic server and prepared high availability environments.
  • Extensively involved in requirements gathering, Design, Development and Unit Testing of ODI ETL interfaces, Packages and Procedures created/modified for Data Extraction from different sources like Oracle DB, Flat files, and MS Access.
  • Set up the ODI master and work repositories for Development, Testing and Production systems.
  • Set up Physical and Logical architectures including contexts in Topology.
  • Developed ODI models to import data from different sources like Oracle EBS, SAP, External Files and Oracle Database.
  • Imported metadata into ODI repository and Designed developed the ELT interfaces Procedures, Packages, Scenarios and load plans in ODI.
  • Set up the ODI agent Java and Standalone on both windows and Linux systems.
  • ODI interfaces and packages created/modified for Data Extraction from different sources like Oracle DB and Flat files .csv, XML, .txt .
  • Developed SQL Scripts , and Stored Procedures, Functions, and Packages using PL/SQL based on business rules to generate comprehensive logics like balancing the levels in the Dimension hierarchy tables, checking consistency and loading run log tables, and populating level numbers in the de-normalized table etc and used in the ETL mappings and Process flows.
  • Involved in Performance tuning of ETL Mappings by modifying the source views, Materialized Views, and by using the Analytical functions like LEAD, LAG, ROW NUMBER, and RANK etc.
  • Extensively used SQL tuning tools like Explain Plan, SQL Trace and Hints for tuning complex SQL statement.
  • Successfully Implemented change data capture using Oracle Triggers.
  • Created/Modified Materialized Views
  • Created the UNIX scripts for the scheduling of the workflows in Control-M
  • Created the Production Support Document and assisted the Production Support Team with all the production related issues.

Environment: Oracle 11g, Oracle Data Integrator ODI 11g, SQL, PLSQL, SQL DEVELOPER Oracle ESB ,Actuate, SAP BO ,UNIX JAVA and Windows XP

Confidential

Data Warehouse Specialist, ETL Architect, ETL Solution Design, ETL Development and Onsite Coordinator.

Responsibilities:

  • Worked as ETL Architect and ETL Designer in coordination Business Analysts in gathering the requirements and designed the Source to Target Mapping Specification Documents.
  • Architected and implemented multiple data warehouses and data marts for different subjects.
  • Actively involved in data modeling using dimensional modeling with the help of ER-Win tool.
  • Implemented Dimensional modeling using STAR schema.
  • Set up the OWB repositories for Development and Testing. And also created source and target locations for all sources to deploy the OWB objects like Dimensions, ETL mappings and process flows.
  • Extensively involved in requirements gathering, Design, Development and Unit Testing of OWB ETL Mappings and Process Flows created/modified for Data Extraction from different sources like Oracle DB, Flat files, and MS Access.
  • Developed ETL scripts using various OWB Transformations like Expression, Lookup, Aggregator, Joiners, Splitter, Filter, Pivot/Unpivot, De-Duplicator, Stored Procedure, Table Functions, Robust Analytical Functions, Update/delete Strategy, Pre/Post Mapping Operators etc...
  • Set up the ODI master and work repositories for Development, Testing and Production systems.
  • Set up Physical and Logical architectures including contexts in Topology.
  • Developed ODI models to import data from different sources like Oracle EBS, SAP, External Files and Oracle Database.
  • Imported metadata into ODI repository and Designed developed the ELT interfaces Procedures, Packages and Scenarios in ODI.
  • Set up the ODI agent on both windows and Linux systems.
  • ODI interfaces and packages created/modified for Data Extraction from different sources like Oracle DB and Flat files .csv, XML, .txt .
  • Developed SQL Scripts , and Stored Procedures, Functions, and Packages using PL/SQL based on business rules to generate comprehensive logics like balancing the levels in the Dimension hierarchy tables, checking consistency and loading run log tables, and populating level numbers in the de-normalized table etc and used in the ETL mappings and Process flows.
  • Created Process flows and Schedulers to run the Process Flows automatically.
  • Involved in Performance tuning of ETL Mappings by modifying the source views, Materialized Views, and by using the Analytical functions like LEAD, LAG, ROW NUMBER, and RANK etc.
  • Extensively used SQL tuning tools like Explain Plan, SQL Trace and Hints for tuning complex SQL statement.
  • Successfully Implemented change data capture using Oracle Triggers.
  • Created/Modified Materialized Views
  • Created the UNIX scripts for the scheduling of the workflows in Control-M
  • Created the Production Support Document and assisted the Production Support Team with all the production related issues.

Environment: Oracle 11g, Oracle Data Integrator ODI 10g, SQL, PLSQL, SQL LODER, SQL DEVELOPER, TOAD, Informatica, Oracle BI APPS, DAC, Oracle ERP applications FIN, OM, FA and INV modules , OBIEE 11G, Oracle Warehouse Builder OWB 11g, Control-M, Shell scripts, UNIX JAVA and Windows XP

Confidential

Data warehouse Technical Consultant, Data integration solution Design,

Responsibilities:

  • Worked on complete SDLC System Development Life Cycle including system analysis, high level design, detailed design, coding and testing.
  • Involved in designing of logical model and physical model.
  • Created all necessary data structures like Tables, Views, Procedures, Triggers, functions, packages, materialized views etc.
  • Implemented Dimensional modeling of CONSTELLA schema with the help of ER-Win tool.
  • Actively involved in data modeling using dimensional modeling with the help of ER-Win tool.
  • Set up the ODI master and work repositories for Development, Testing and Production systems.
  • Set up Physical and Logical architectures including contexts in Topology.
  • Developed ODI models to import data from different sources like Oracle EBS, SAP, External Files and Oracle Database.
  • Imported metadata into ODI repository and Designed developed the ELT interfaces Procedures, Packages and Scenarios in ODI.
  • Set up the ODI agent on Oracle Web Logic Server.
  • ODI interfaces and packages created/modified for Data Extraction from different sources like Oracle DB and Flat files .csv, XML, .txt .
  • Implemented Slowly Changing Dimensions of SCD Type1, Type2 and Type3 in Oracle Data Integrator.
  • Imported metadata into ODI repository and Designed developed the ETL Mappings and Process Flows in ODI.
  • Developed ODI models to import data from different sources like Oracle EBS, SAP, External Files and Oracle Database.
  • Set up the ODI repository for Development, Testing and production. And also created source and target locations for all sources to hold all the ODI objects like Projects, Models, interfaces, procedures and Packages.
  • Developed SQL and PL/SQL scripts using procedure and functions for implementing some logics in ETL mappings like getting profile values from Oracle EBS, to truncate Materialized View Logs etc.
  • Identified and worked on various bugs and provide better solution for enhancements and implementation in the production system.
  • Creation of technical design documents.

Environment: Oracle 11g, SQL, PLSQL, SQL LODER, SQL DEVELOPER, Oracle ERP applications OTM and FIN modules , RP32 systems, OBIEE 11G, Oracle Data Integrator ODI 11g, Shell scripts, UNIX and Windows XP

Confidential

Data integration consultant, Data integration solution Design, Integration

Responsibilities:

  • Worked as ELT Architect and ELT Designer in coordination Business Analysts in gathering the requirements and designed the ELT design document for the source Oracle ERP and the Target Hyperion planning and ESSBASE
  • Extensively involved in requirements gathering, Design, Development and Unit Testing of ODI Interfaces and Packages created/modified for Data Extraction from different sources like Oracle ERP GL,FA,HRMS and Flat files
  • Architected and implemented multiple ODS to suit with the target Meta data structure Hyperion Planning and Essbase .
  • Implemented Dimensional modeling using STAR schema.
  • Set up the ODI repository for Development, Testing and production. And also created source and target locations for all sources to hold all the ODI objects like Projects, Models ELT interface, procedures and Packages.
  • Developed SQL Scripts , and Stored Procedures, Functions, and Packages using PL/SQL based on business rules to generate comprehensive logics like balancing the levels in the Dimension hierarchy tables, checking consistency and loading run log tables, and populating level numbers in the de-normalized table etc and used in the ETL mappings and Process flows.
  • Created Packages and Schedulers to run the ELT flows automatically.
  • Involved in Performance tuning of ELT interfaces by modifying the source views, Materialized Views, and by using the Analytical functions like LEAD, LAG, ROW NUMBER, and RANK etc.
  • Extensively used SQL tuning tools like Explain Plan, SQL Trace and Hints for tuning complex SQL statement.
  • Successfully Implemented change data capture using ODI.

Environment: Oracle 10g, Oracle Apps 11.5.10.2 R12, Hyperion planning 9.3.1, Hyperion Essbase 9.3.1, Oracle Data Integrator 10g, SQL, PLSQL, SQL LODER, SQL DEVELOPER, OBIEE 10G, Shell scripts, UNIX and Windows XP

Confidential

Data integration consultant, Data integration solution Design, Product Oracle AIA PIP Development, OPD services

There are three areas for integration:

  • Utilization of PeopleSoft GL configuration / setup by Oracle FSAH.
  • Sending of FSAH accounting results to PeopleSoft GL with correct information for posting.
  • Ability to drill from PSFT GL balances to FSAH details.

Responsibilities:

  • Developed data flows to transfer accounting entries from ebiz to PeopleSoft
  • Wrote java class files to build dynamic view on Oracle apps database based on chart of account id's
  • Implemented parallel running mechanism for scenarios in ODI
  • All major types of ODI objects to be created and used for this development Ex: Interfaces, Packages, Procedures, Variables and Scenarios
  • Thorough knowledge in ODI installation on Windows/Unix boxes.
  • Wrote PIP installation and upgrade scripts.
  • Wrote PLSQL scripts to identify newly process record from EBIZ

Environment: Oracle 10g, Oracle Apps 11.5.10.2 R12, PeopleSoft, Oracle Data Integrator 10.1.3.x 11g, SOA10.x 11.x, AIA2.X 3.X, Jdev10.x 11.x

Confidential

Data warehouse Consultant, ETL Design, OWB development, Production support,

Responsibilities:

  • Used TKPROP, EXPLAIN PLAN utility in tuning the SQL Queries.
  • Wrote UNIX Shell scripts to transfer files from different servers like third-party FTP/SFTP server, execute OWB mappings/Process Flows from shell scripts and schedule the shell scripts for daily/monthly jobs through Control-M.
  • Creating OWB Process Flows for controlling the sequence of data load steps, command tasks and created workflows with success or failure notification through email. Implementation of parallel processing of ETL tasks within the OWB Process Flows.
  • Implemented Slowly Changing Dimensions - Type 2 mappings as per the requirements.
  • Developed ETL scripts using various OWB Transformations like Expression, Lookup, Aggregator, Joiners, Splitter, Filter, Pivot/Unpivot, De-Duplicator, Stored Procedure, Table Functions, Robust Analytical Functions, Update/delete Strategy, Partition Exchange Loading, Pre/Post Mapping Operators etc...
  • Implemented Oracle Change Data Capture CDC to capture the incremental load from the sources. Used the Control Table Logic in order to implement in the Change Data Capture.
  • Worked with different source systems like IBM Mainframes DB2, XML files, SQL Server.
  • Worked as ETL Architect and ETL Designer in coordination Business Analysts in gathering the requirements and designed the Source to Target Mapping Specification Documents.
  • Developed a PL/SQL stored procedure which will generate the INSERT statements into the source tables this is used by the testing team for the testing purpose.
  • Performed System Testing, written System Test Cases for Data Validation, Data Transformation, Data Quality, and Regression Testing and assisted the testing team with the Performance Testing.
  • Created the UNIX scripts for the scheduling of the workflows.
  • Created the Production Support Document and assisted the Production Support Team with all the production related issues.

Environment: Oracle 10g, SQL, PLSQL, SQL LODER, TOAD, Oracle ERP applications FIN, OM, FA, OPM and INV modules , Oracle Discoverer 10g, Oracle Reports D2K , Oracle Warehouse Builder OWB 10g, Shell scripts, UNIX and Windows XP

Confidential

DW Technical Consultant and OWB development

Responsibilities:

  • Interacted with the Business analysts and the end users for requirements gathering.
  • Implemented Dimensional modeling using SNOW FLAKE schema.
  • Involved in creating locations to get the data from Oracle Applications and designed complex ETL mappings and process flows to apply the business rules and to load the information into target database.
  • Developed SQL and PL/SQL scripts using procedure and functions for implementing some logics in ETL mappings like enabling and disabling the indexes, and refreshing Materialized Views.
  • Scheduled the Jobs for Daily Load.
  • Set up the OWB repository for Development and Testing environments.
  • Defined the Data Rules and DATA Profilers to detect the erroneous data and moved to the error tables.
  • Involved in Performance tuning of ETL Mappings by modifying the source views, Materialized Views, and by using the Analytical functions like LEAD, LAG, ROW NUMBER, and RANK etc.
  • Created Process flows and Schedulers to run them automatically.

Environment: Oracle 9i, Oracle Apps 11.5.10.2, Discoverer 4i 10g, Developer 2000 6i OWB 9i,SQL,PLSQL and TOAD

Hire Now