ETL Technical Lead
Resume:
Ramakrishna K E-Mail: ***********.***@*****.*** Tech/Team Lead Contact No: +91-998*******/998-***-****
To attain a challenging position, gain knowledge, experience and grow with the organization in a way that leads to value addition to me as well as to the organization.
Total 7.4 Years of Hands on Experience in working with various ETL Tools (Informatica, BODS/BODI & Talend)
Strong data warehousing experience with extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.5/9.1.1/8.6/8.1/7.1.
Experience in working with RDBMS like Oracle, SQL Server and as well as external Sources.
Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing, in a corporate-wide-ETL Solution using Informatica & BODS/BODI.
Extensively working on Business Object Data Services/ Data Integration components
Extensively worked on Informatica Designer components – Source Analyzer, Target Designer, Transformations Developer, Mapplets and Mapping Designer.
Having experience in SAP – Informatica & SAP – BODS interface.
Good knowledge in Data warehouse concepts.
Experience in Supply Chain Management, especially in Production Planning & S&OP.
Exposure to Data warehousing and RDBMS concepts.
Experienced in developing Data Marts and designing Star Schema and Snow flake schema.
Experienced in data analyze, data module designs.
Have work experience with Data warehouse administration console scheduler tool.
Systematic & strong analytical skills with the ability to understand and interpret functional and technical requirements, quick adaptability to new technologies, functional areas & client business
Excellent Inter-personal and Communication skills.
Good Team player with positive attitude and enthusiasm makes me outstanding team player.
Proficiency at grasping new technical & functional concepts quickly and utilize the same in productive manner.
Ability to multi-task, Deadline-oriented, highly disciplined.
Currently working as a Technical Lead for IGATE Global solutions Ltd, Bangalore & Hyderabad from Nov’13 to till date.
Worked as a SrIntegration Consultant for Sonata Software Ltd & (IntelliCompute Technology Pvt Ltd), Bangalore from Aug’12 to Nov’13.
Worked as an Informatica consultant for Essar Information Technology Ltd, Mumbai from Jul’10 to Jul’12.
Worked as an Associate Consultant for Yell Ad works India Pvt Ltd, Bangalore from Jun’08 to Jul’10.
Master of Computer Applications (MCA) from Bangalore University.
ETL Tool : Informatica Power Center 7x/8x/9x,
SAP BODS/BODI 3x/4x, Talend,
Src & Tgt used in ETL : SAP (ECC, BI), In & Out-bound BAPI’s,
Oracle, SQL Server 2008 & Flat files
Database : Oracle, SQL server 2008
IDE : TOAD & SQL developer
SCM (JDA) tools : i2 FP, i2 MDM 6.2.4, i2 DM & i2 PM
Operating System : Windows XP, Windows Server2000, Windows 7, Unix, Linux
Scheduling Tools : i2 CIS, Administrative Management Console
Assignment # 1
Project : GE IP Technology & Services Spend Reporting
Company : IGATE Global solutions Ltd
Name of the Client : GE Intelligent Platforms
Role in the project : Tech Lead
Duration : Jun’15 to Till Date.
Technologies used in project : BODS/BODI, SAP ECC,Oracle 11g, SQL Developer, UNIX Shell script
Description: GE IP Technology & Services Spend Reporting (IP) business is planning to enhance the phase 2 & Sprint 3 requirements in existing Phase 1 project. Addition of dimensions and fact in database & creation of new BO reports.
.
Roles & Responsibilities:
Design the Database Movement Plan for Database Objects, ETL Jobs, Data source files & Transformations using Oracle & Informatica.
Consolidate all the ETL Jobs and Data objects in common Informatica folders and also required aggregations as defined in ETL Job scope.
Automate scheduled mechanism for ETL jobs & data distribution as required.
Setup the database schema layer in Oracle AS-IS in the New Environment.
Test the Database & ETL objects after they are move to new environment. i.e. unit testing, system testing and user acceptance testing by connecting to existing reports.
Complete Testing of ALL ETL Job Runs, BO universes refreshes & Reports to ensure they perform same as in AS-IS environment.
Procure UAT sign off from ALL Stakeholders/Owners.
Prepare required documentation as defined by the GE process,
Transition application support to the RTS team as per process
Prepared High level estimates, system integration support and worked in code migration activities moving the code from DEV/QA/PROD
Performed ETL Tuning on the Informatica code and bring down the ETL resource time to half of the time.
Assignment # 2
Project : GE Energy Management Power Conversion
Company : IGATE Global solutions Ltd
Name of the Client : GE Energy
Role in the project : Team/Tech Lead
Duration : Mar’15 to Till Date.
Technologies used in project : Informatica 9.5.1, Oracle 11g, SQL Developer, UNIX Shell script
Description: GE’s Power Conversion (PC) business is planning to move existing PC DataMart database from IS Environment to EM Environment & consolidate all PC databases in one Environment and provide single access to all reporting applications. This provides support & help to achieve database consolidation and scale PC database growth.
The scope of this RFP is to partner with a vendor & execute / implement below tasks with end to end responsibility by vendor.
Move existing PC DataMart Database along with ETL jobs and Transformations to EM environment using Informatica & Test all the existing BO reports & universe function AS-IS.
Migrate all Business Objects reports & universes including user’s setup into Tableau Dashboards/Reports. This might also involve any additional ETL changes using Informatica.
Migrate all Spot fire reports & queries into Tableau Dashboards/Reports. This might also require any additional ETL changes using Informatica.
.
Roles & Responsibilities:
Design the Database Movement Plan for Database Objects, ETL Jobs, Data source files & Transformations using Oracle & Informatica.
Consolidate all the ETL Jobs and Data objects in common Informatica folders and also required aggregations as defined in ETL Job scope.
Automate scheduled mechanism for ETL jobs & data distribution as required.
Setup the database schema layer in Oracle AS-IS in the New Environment.
Test the Database & ETL objects after they are move to new environment. i.e. unit testing, system testing and user acceptance testing by connecting to existing reports.
Complete Testing of ALL ETL Job Runs, BO universes refreshes & Reports to ensure they perform same as in AS-IS environment.
Procure UAT sign off from ALL Stakeholders/Owners.
Prepare required documentation as defined by the GE process,
Transition application support to the RTS team as per process
Prepared High level estimates, system integration support and worked in code migration activities moving the code from DEV/QA/PROD
Performed ETL Tuning on the Informatica code and bring down the ETL resource time to half of the time.
Assignment # 3
Project : New Biz Model (Hyperion Transformation)
Company : IGATE Global solutions Ltd
Name of the Client : GE Oil & Gas – Subsidiary of GE Energy
Role in the project : Project Lead (Technical Lead)
Duration : Dec’13 to Feb’15.
Technologies used in project : Informatica 9.5.1, Oracle 11i, SQL Developer, UNIX Shell scripting,
Hyperion Planning, ODI & Essbase & Financial Reporting
Description: The Project New Biz Model is completely a development project. The development includes implementing a new Application using Hyperion Essbase Database which will collect Actual Data that is Booked Orders and Forecasting data (Inquire to Orders) estimates for Order metrics for Turbo-machinery Segment, O&G Region and all Oil & Gas Legal Entities. The Business need is the possibility to have ongoing opportunity tracked in SFDC (High Probability, Medium Probability, Won) into the New Biz Model ITO (Order tracking repository) for allowing TM ITO Finance team, Sales Development, Planning team make their analysis over order for finally building accurate order and sales plan. The Informatica & Hyperion tools and Oracle database involved in this project are Hyperion Planning and Hyperion Essbase and Hyperion Financial Reporting.
.
Roles & Responsibilities:
Gathered the requirements from the client for the ETL Objects implementation
Having daily interaction with the client for gathering the requirements and status updates
Perform the Gap analysis Come up with ETL requirements based on existing ETL CODE developed.
Come up with analysis documents based on comparison between existing ETL and TOBE ETL
Creation of ETL Detailed Design documents, Mapping Specification, Data Flow Diagram documents
Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to team members & include important test cases particular to particular ETL logic
Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
Mentor the team members by providing assistance with the functional environment/Technical aspects
Used Informatica designer to create complex mappings using different transformations to move source data to a Data Warehouse
Prepared High level estimates, system integration support and worked in code migration activities moving the code from DEV/QA/PROD
Performed ETL Tuning on the Informatica code and bring down the ETL resource time to half of the time.
Developed PL/SQL procedures/Packages for loading the data from stage table to Facts/Dimensions with complex transform logic
Assignment # 4
Project : In-Store Execution
Company : Sonata Software Ltd
Client : PepsiCo International
Role : Sr Integration Consultant
Duration : Mar’13 to Nov’13.
Technologies : BODS/BODI, Oracle, Solman, Quality Center, TDM
Description: PepsiCo is one of the leading food and beverage companies in UK & US. After the success of Power PepsiCo International implementation for producing a wide range of products under various Brands. MYBUY (Performance Optimization UK Region) is a first step on the European Sector to implement the SAP ECC/BI functionalities to cover all our basic needs in finance, operations and commercial. The major aim of MYBUY is to define common data for all the regions at the same time, using the same processes in the same way. This is achieved based on agreed data standards in a way that will be flexible and user controlled. SAP Business Objects Data Services with its varied options and flexibility to adapt to all business needs provides the platform to integrate all the legacy systems to SAP ECC& BI functionalities to make the data common across all the systems.
Roles & Responsibilities:
Understanding Business Requirements Document (Functional Specification Docs).
ETL Specification document to understand the ETL requirements (High Level Design Docs).
Worked on Business objects Data integrator for developing jobs (BODS).
Prepared ETL Mapping documents (Detail Level Docs).
Prepared Production Cut over plan to move project to Live.
Documentation of Project &Updation of Data model.
Data Loading, Unit Testing of jobs, Unit Testing of database, Scheduling, Automation of jobs w.r.t Frequency.
Bug Fixing during User Acceptance Test.
Production Support for the Project.
Designed test case documents, Involved in Unit testing and Performance tuning.
Assignment # 5
Project : Power PepsiCo
Company : Sonata Software Ltd (Intelli Compute Technology Pvt Ltd)
Client : PepsiCo International
Role : Sr Integration Consultant
Duration : Aug’12 to Feb’13.
Technologies : BODS/BODI, SAP (ECC/BI), Quality Center, Solman
Description: PepsiCo is one of the leading food and beverage companies in Europe, producing a wide range of products under various Brands. POWER (Performance Optimization Western Europe Region) is a first step on the European Sector to implement the SAP ECC functionalities to cover all our basic needs in finance, operations and commercial. The major aim of POWER is to define common data for all the regions at the same time, using the same processes in the same way. This is achieved based on agreed data standards in a way that will be flexible and user controlled. SAP Business Objects Data Services with its varied options and flexibility to adapt to all business needs provides the platform to integrate all the legacy systems to SAP ECC& BI functionalities to make the data common across all the systems.
Roles & Responsibilities:
Understanding Business Requirements Document (Functional Specification Docs).
ETL Specification document to understand the ETL requirements (High Level Design Docs).
Worked on Business objects Data integrator for developing jobs (BODS).
Prepared ETL Mapping documents (Detail Level Docs).
Prepared Production Cut over plan to move project to Live.
Documentation of Project &Updation of Data model.
Data Loading, Unit Testing of jobs, Unit Testing of database, Scheduling, Automation of jobs w.r.t Frequency.
Bug Fixing during User Acceptance Test.
Production Support for the Project.
Designed test case documents, Involved in Unit testing and Performance tuning.
Assignment # 6
Project : MDS (Mill Distribution System)
Company : Essar Information Technology ltd.
Client : Essar Steel Hazira.
Role : Integration Consultant
Duration : Aug’11 to June’12.
Technologies : Informatica 8.6, Oracle 10g, Toad, UNIX.
Description: Essar Steel Indian operations are expanding in terms of capability and capacity by implementing new production lines in the form of Plant B, ESPF, Pipe Mill, Plate Mill, ES Orissa Ltd. etc. With increasing and different capabilities and capacities, it is required to know and decide the best route for production well before starting the manufacturing for any customer demand. Mill Distribution System will be suggesting the best route amongst the many options available to meet the customer requirement in the most effective way considering cost, capacity, capability and quality constraints.
Roles & Responsibilities:
Preparing and reviewing the Technical Specifications.
To Develop an ETL processes using Informatica to load data from various data sources to target Data Warehouse.
Developed Mappings and Mapplets for reusable using Informatica Power Center Designer.
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center
Involved in the development of Informatica mappings and tuned for better performance
Attending the Calls in case of any issues during the development.
Troubleshooting the issues whenever required.
Involved in Development as well requirement gathering phase.
Developed mappings by extensively using Informatica Transformations like Filter, Expression, Source Qualifier, Lookup, Router and Update Strategy etc
Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules
Write complex SQL queries to pull and analyze data from large relational databases.
Involved in migration of Informatica & Database objects to Production ENV.
Designed test case documents, Involved in Unit testing and Performance tuning.
Assignment # 7
Project : Sangam Merger – i2 FP (Factory Planner)
Company : Essar Information Technology ltd.
Client : Essar Steel Hazira.
Role : Integration Consultant.
Duration : Jun’11 to Oct’11.
Technologies : Informatica 8.6, Oracle 10g, Toad, UNIX, i2 MDM, i2 FP.
Description: ESTL factory planner solution with reference to sap merger changes. Currently FP solution has all the order, inventory, resources modelled for plant A and not for plant B. After sap merger of plant A and plant B the orders of ESTL (plant A) and ESHL (plant B), stock and VC attributes will be under one plant code. Based on that we need to make changes in interface and our tables to add plant B resource and route selection conditions for HSM and CSP resources.
Roles & Responsibilities:
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center
Involved in the development of Informatica mappings and tuned for better performance
Developed mappings by extensively using Informatica Transformations like Filter, Expression, Source Qualifier, Lookup, Router and Update Strategy etc
Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules
Involved in migration of Informatica & Database objects to Production ENV.
Integration of Informatica, database, and shell script objects to i2 CIS.
Designed test case documents, Involved in Unit testing and Performance tuning.
Assignment # 8
Project : HPML (Hazira Pipe Mill Limited)
Company : Essar Information Technology ltd.
Client : Essar Steel Hazira.
Role : Integration Consultant.
Duration : Feb’11 to July’11.
Technologies : Informatica 8.6, Oracle 10g, Toad, UNIX, i2 MDM, i2 FP.
Description: HPML, one of the companies of Essar Group has decided to use i2 FP for its production planning after the success of i2 FP implementation for Essar Steel. On time readiness index (OTRI) is useful for the business to see and enhance the planning and production capabilities of a plant.
Roles & Responsibilities:
Performed major role in understanding the business requirements and designing and loading data into Data Warehouse (ETL)
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center
Involved in the development of Informatica mappings and tuned for better performance
Developed mappings by extensively using Informatica Transformations like Filter, Expression, Source Qualifier, Lookup, Router and Update Strategy etc
Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules
Designed test case documents, Involved in Unit testing and Performance tuning.
Assignment # 9
Project : ESPF (Essar Steel Pune Facility) Support Projects
Company : Essar Information Technology Ltd.
Client : Essar Steel Service Pune Facility.
Role : Integration Consultant
Duration : Nov’10 to Feb’11.
Technologies : Informatica 8.6, Oracle 10g, Toad, UNIX, i2 FP.
Description: i2 FP is the production planning tool. ESPF, one of the companies of Essar Group has decided to use i2 FP for its production planning after the success of i2 FP implementation for Essar Steel. Automatic planning and re-planning capabilities. Production planning of confirmed Sales order and promising of enquiries/draft Sales Orders. Accurate Inventory Requirement Planning and visibility of HR Coils lying at ESTL, Hazira (as FG, as BTR, as WIP, as In-transit) and Paint Planning. Balancing of capacity loading to get optimum utilization of resources. Grouping of similar attributes orders within 5 day bucket to optimize setup and change over.
Roles & Responsibilities:
Involved in Requirement Gathering from Business users.
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center
Developed shell scripts, sql scripts for Batch Framework of the modules
Developed mappings by extensively using Informatica Transformations like Filter, Expression, Aggregator, Source Qualifier, Lookup and Router etc
Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules
Involved in Unit testing.
Assignment # 10
Project : ESTL (Essar Steel) Support Project
Company : Essar Information Technology Ltd.
Client : Essar Steel, Hazira,
Role : Integration Consultant
Duration : Jul’10 to Nov’11.
Module : SPP, SCP, OP, FP&MA
Technologies : Informatica 7X & 8X, Oracle 10g, UNIX, i2 (MDM, FP, SPP&
SCP)
Description: i2 FPMA Implementation & Support of different modules of i2FP - S&OP for Essar Steel, Supply Chain Management is the domain that provides the company an easy platform to take decision for different areas like (sales, production, logistic etc) of the organization. Sales and operation planning (S&OP) covers demand forecasting, Sales Planning considering sales and factory level constraints and Order Promising.
Roles & Responsibilities:
Performed major role in understanding the business requirements and designing and loading data into Data Warehouse (ETL)
Extensively used ETL tool Informatica to load data from Source to Target database systems
Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Informatica Power Center
Implemented the Changed Data Capture in Trans Phase in staging area (Source to Staging)
Involved in the development of Informatica mappings and tuned for better performance
Developed mappings by extensively using Informatica Transformations like Filter, Expression, Source Qualifier, Lookup, Router and Update Strategy etc
Create Sessions and Workflows using the Workflow Manager, Tested the data extracts to check if they confirm to the business rules.
Involved in Unit testing and Performance tuning and issues resolution for daily workflows.
Assignment # 11
Project : Marketing Database 2(MDB2).
Company : Yell Adworks India Pvt Ltd,
Client : Yellow Book
Role : Integration Consultant.
Duration : Apr’09 to Jul’10.
Technologies : Informatica Power Center 7.1, Oracle,SQL, UNIX, FileZilla,
Flat files,
Description: This project relate to e-comers. Core functionality of the project is to load the US business data to staging. Standardize the staging data using MDM tools and load to the warehouse. Feed the final standardized data to print book (Yellow book US) and yellowbook.com site. The standardized data in the warehouse is the primary source of the other projects (iFlow, BPD, Caption Standardizations etc.).
MDB2 is a logical warehouse designed for enterprise information storage and reporting required for Print Book, Sales planning and YB.com
Roles & Responsibilities:
Analysis and Mapping the user requirements into ETL
Develop ETL mappings to extract data from various sources and load it into the database.
Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations
Created documents for developed tasks with detailed information about the mapping, workflows and sessions Used.
Effective Unit Test Cases creation, Unit Testing, peer to peer review and UAT co-ordination.
Execute and monitor batch jobs in Informatica MDM.
Based on business requirement executing and monitoring ETL workflows in production environment.
Every day load the data to PURISMA base tables.
Assignment # 12
Project : Yellow Book Web Search (YBWR)
Company : Yell Adworks, Bangalore.
Client : Yellow Book
Role : Associate Integration Consultant.
Duration : Aug 2008 to March - 2009.
Technologies : Informatica 7.1, Oracle 9i, Windows XP.
Description: The solution enables a centralized data store that would contain ‘Golden records’ pertaining to the customer data. This would be a single point of customer data for the enterprise wide customer data needs which would give the organization a strategic advantage.
It showcases the remarkable ease through which we can solve the most crucial problems faced by global giants in synchronizing their distributed master data. It helps them have a single view of the distributed data environment.
How much the Yellow book is spending per year/per product to get business from the Customer & spending on the search engines (Google, yahoo etc).
Roles & Responsibilities:
Worked as ETL Developer in Data loading Phase from operational system of records into staging area (Source to staging)
Involved in the designing and implementation of the mappings for stage to data warehouse data loading
Extensively involved in Data Extraction, Transformation and Loading (ETL Process) from Source to target systems using Informatica Power center
Extensively used the transformations such as Source qualifier, Lookup, Update Strategy, Aggregator, Expression, Filter and joiner.
Details of Training undergone in IGATE
SL. NO.
TRAINED ON
PERIOD
1
DataModeling
1 Week
2
Agile Methodology
1 Week
Contact this candidate