We provide IT Staff Augmentation Services!

Etl Resume

OBJECTIVE

Seeking a challenging developer position in data warehousing project where I can contribute my skills and learn continuously and become an expert in the field.

TECHNICAL SUMMARY

  • Experienced in requirement analysis, coding and testing various modules in a SDLC.
  • Core competence in Data Warehousing & Business Intelligence Application Development.
  • 3.8 years of experience in systems analysis, design and development of complex ETL systems in Supply Chain Management area of manufacturing domain.
  • Experience in development and analysis across Oracle 8i/9i/10g using SQL, PL/SQL in Windows 2000/XP, Microsoft SQL server and SAP R/3 system.
  • Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers, Cursor management and exception handling.
  • Extensive Knowledge in InformaticaPower Center 8.6.0, MS SQL Server 2005, SQL Server Integration Services (SSIS) and Business Objects Data Integrator (BO-DI) and Business Objects Data Services (BODS).
  • Strong skills in solution designing, data migration and T-SQL,PL/SQL.
  • Self confident Team Player with Fast Learning Curve along with strong analytical, problem solving, knowledge transfer, communication & interpersonal skills.
  • Excellent team player and proven track record working in various team sizes performing cross-functional roles

PROFESSIONAL DATES

  • Worked at Confidential, Bangalore, India as Senior System Engineer from Jan-2008 to Jan-2011.
  • Working at Confidential, as Senior Engineer from Feb 2011 to till date.

ACADEMIC DETAILS

  • Bachelor of Engineering:- Electrical and Electronics Engineering .

TECHNICAL SKILLS

  • ETL Tools :Informatica Power center 8.6.0, Business Objects Data Integrator (BO-DI/BODS XI),SQL Server Integration Services (SSIS-2005)
  • Reporting : BusinessObjecs XI R2
  • RDBMS : MS SQL Server 2005, Oracle 9i/10g
  • Languages : T-SQL, PL/SQL.
  • Operating Systems : Windows 98/XP/NT
  • Other Tools : Erwin 7.8, MS-Visio, Toad for Oracle. SQL*Plus,

PROJECTSDETAILS

MDM -Aerospace
Client
: Confidential
Duration : March 2011 to till date
Team Size : 3
Organization : Confidential, Bangalore
Environment :ETL TOOL - BODS
Database - ORACLE 9i,SAP R/3(source)
Reporting - BusinessObjecs XI R2

Description:
Master data management attempts to bring together data related to each of the plants for HW. It provides intelligence on the materials management in each vault across the globe through reporting.

Responsibilities:

  • Day to day interaction with client on capturing requirement and documentations.
  • Development of jobs according to the ETL specifications for the staging area & warehouse data loading using data services.
  • Involved in System Testing.
  • QA migration activities.

Commercial Invoice Reporting

Client : Confidential
Duration : May 2010 to Feb 2010.
Team Size : 3
Organization : Confidential, Bangalore
Environment : ETL TOOL - Informatica power center 8.6.0
Database - ORACLE 9i,
Reporting - BusinessObjecs XI R2

Description:
The objective of Commercial Invoice Reporting was to integrate the invoice data pertaining to Orders from OLTP and report it on Business Objects so that the users are able to generate reports for US Customs audit. Access restriction to universe objects and the reports were also implemented.
I have been involved in requirement gathering, technical document specification, target data modeling, coding and testing activities. I am the offshore technical lead for the project, and hence also responsible for status reports to client, and having the bottom line for migration activities.

Responsibilities:

  • Involved in requirement gathering and analysis
  • Development of jobs according to the ETL specifications for the staging area & warehouse data loading using Informatica.
  • Performance tuning 7 years history load mappings.
  • Involved in System Testing.
  • Creating new class,objects and joins in BusinessObject universe.
  • Creating a usergroup in CMC console and assigning object level security to the new objects created.
  • Creating new reports on Deski and publishing it to Infoview and assigning restrictions to the published reports.

SIID - Post Entitlement Service Coverage Opportunity (PESCO) Reporting

Client : Confidential
Duration : Sep 2009 to May 2010
Team Size : 4
Organization : Confidential, Bangalore
Environment :ETL TOOL -Informatica power center 8.6.0
Database -ORACLE 9i.

Description:
The objective of SIID - Post Entitlement Service Coverage Opportunity (PESCO) Reporting was to provide a reporting platform to identify the post-entitlement service coverage opportunity data and prepare the foot-print of the entire software coverage at the device level. Post entitlement opportunity reporting provides information on the Entitlement Event as well as the Install Base & Contract related information for the Software Components on the device.
This project had lot of issues in all aspects like lack of clarity of requirements from client side, challenge of integrating data spread across four oracle databases, performance issues with each of the queries, data inconsistency, creating of new environment setup in $U scheduling server for Informatica.

Responsibilities:

  • Involved in requirement gathering and analysis
  • Preparing Functional specification, Technical Design documents
  • Development of jobs according to the ETL specifications for the staging area & warehouse data loading using Informatica.
  • Creating informatica environments in $U unix box.
  • Performance tuning of queries and mappings
  • Prepared Unit Test and System Test Specification Requirements.
  • Involved in System Testing.
  • Knowledge sharing to outsourced vendor and getting signoff.

Complexity Metrics

Client : Confidential, Rochester, US
Duration : March 2009 to Sep 2009
Team Size : 5
Organization : Confidential, Bangalore
Environment :OS - Windows 2003 server,
ETL TOOL - BODI,SSIS 2005
Database - ORACLE 9i

Description:
Confidential had complexity of a much larger company in terms of the number of Businesses, Product lines, Markets and countries served, SKUs within the business. The objective of Complexity Metrics project was to provide Business Intelligence insight into sales data to measure the company complexity and provide drilldown analytics to low-level. This project had key challenges data inconsistency across functions and regions, ability to extend the architecture to include additional business areas.

Responsibilities:

  • Involved in requirement gathering and analysis.
  • Data Model design and build using ERWIN data model tool.
  • Development of packages according to the ETL specifications for the staging area & warehouse data loading using BODI and SSIS.
  • Prepared Unit Test Specification Requirements.
  • Involved in ETL and Query performance tuning.
  • Maintaining VSS setup for project.
  • Involved in Stabilization, Support and Enhancement phases.
  • Knowledge sharing to outsourced vendor and getting signoff.

Sales Enterprise Data Warehouse

Project Name : Sales Enterprise Data Warehouse
Client : Confidential, Rochester, US
Duration : March 2008 to March 2009
Team Size : 10
Organization : Confidential, Bangalore
Environment :ETL TOOL -Business
Objects - Data Integrator, SSIS 2005
Database - SQL Server 2005, SAP R3, ORACLE.

Description:
Confidential is the largest supplier of photographic films in the world, for the amateur, professional, and motion picture markets. The objective of this Business Intelligence is to integrate the different source systems data into Master Database called Master Data Hub, in normalized form and achieving the Enterprise Data Warehouse for complete supply chain management business data. This Business Intelligence helped to store heterogeneous data into unified and hierarchical structural form. It helped Confidential supply chain management team to audit the master data and correct and reload the transaction data.

Responsibilities:

  • Development of jobs according to the ETL specifications for the staging area & warehouse data loading using BO Data Integrator and SQL server 2005 procedures and views.
  • Data Migration between DEV, QA and PROD environments thorough import/export utility.
  • Developed a generic solution to load 50 lookup tables from SAP-R3 tables.
  • Prepared Unit Test and System Test Specification Requirements.
  • Involved in System Testing.
  • Maintaining VSS setup for project.
  • Knowledge sharing to outsourced vendor and getting signoff.

Hire Now