We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume Profile

Summary: 10 years of experience

  • 10 yrs of experience in IT Industry, in Data warehouse Tools Data stage, informatica and 6 months of expr in BO.
  • Strong Skills on ETL IBM Infosphere DataStage and Informatica .
  • Certified IBM Infosphere DataStage Developer for version 8.5, on November 30th 2013.
  • Good Analytical and problem solving skills.
  • Good SQL, PL/SQL skills.
  • Self-motivated, adaptive to new technologies, team player with good interpersonal and communication skills.

IT Experience:

  • Working as Sr.Technical Lead in InfoTech Enterprises Limited Hyderabad from 04th April 2010 to 21st Jan 2014
  • Worked as Sr.Software Engineer in Wipro Technology , Bangalore from Jan14th 2008 to 1st April 2010
  • Worked as Technical Consultant in PT.Emerio Indonesia. From march 26th 2007 to Dec 2007
  • Worked as Sr.Software Engineer in Patni Computer Systems Limited, Mumbai from February 2006 to Dec 18th 2006
  • Worked as Software Engineer in Smart vision solutions, Hyderabad, from September 2003 to Feb2006.

Technical Skills:

  • ETL Tools : DataStage 7.1, 7.5.1, 8.1, 8.5
  • Informatica Power Center 7.1, 8.1
  • OLAP Software : Business Objects 6.5
  • Operating System : Windows 2000/NT
  • Databases : Oracle 9i, 10g
  • Programming Languages : Sql, PL/SQL.
  • Project Profile:
  • Project 1

Confidential

Role DataStage Designer Lead

  • The Bulk Delivery Logs application ,is divided into 2 processes, The process fetches data from the Canada Logs, US Logs International Logs application and load into target database.
  • The Process is:
  • Initial load Initially process the complete data for Canada logs, US logs International logs
  • Daily Process
  • In Bulk Delivery Logs application, ETL process need to process TIFF images, Raster files, and Digital data LSAS file with extension .txt
  • Water marking the Raster file and placed in the target location, capture the file size.
  • From Water marking exe file ETL team is expecting a file in return, the file should consist of New File Name, Status code of the water marking process, and file size in bytes.

Roles Responsibilities: -

  • Understand the existing system and gather the requirements and get it sing-off from customer.
  • Prepare High Level Document and Low Level document for the project
  • Supporting the team during the Design phase.
  • Involved in development for complex jobs
  • Reviewed the jobs developed by the team members
  • Involve in Scrum call to update the customer on project status on daily basis.

Project 2

Confidential

Role Sr. Tech Lead

Fetch the Source file from Govt site and process the data, The Source file format is in XML, This Project will be developed and solution is provided using Data stage tool, The purpose of the project is for inserting or updating the ABCrown database to keep history data current and accurate for AB Regulatory Customers

Roles Responsibilities: -

  • Understand the existing system and gather the requirements and it sing-off from customer.
  • Prepare High Level Document and Low Level document for the project
  • Supporting the team during the Design phase.
  • Involved in development for complex jobs
  • Reviewed the jobs developed by the team members
  • Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.

Project 3

Confidential

Role Tech Lead

The Confidential Project will develop and implement a solution in the Data stage that replicates the current ABCrown Manual entry association of the same prototype. The purpose of the prototype is for inserting or updating the ABCrown database to keep history data current and accurate for UK Regulatory Customers

Roles Responsibilities: -

  • Understand the existing system and gather the requirements and it sing-off from customer.
  • Prepare High Level Document and Low Level document for the project
  • Supporting the team during the Design phase.
  • Involved in development for complex jobs
  • Reviewed the jobs developed by the team members
  • Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.

Project 4

Confidential

Role Tech Lead

The Confidential Regulatory data loading Project will develop and implement a solution into the Data stage that replicates the current UK Regulatory Manual entry association of the same prototype. The purpose of the prototype is for inserting or updating the UK Regulatory database to keep history data current and accurate for UK Regulatory Customers

Roles Responsibilities: -

  • Understand the existing system and gather the requirements and it sing-off from customer.
  • Prepare High Level Document and Low Level document for the project
  • Supporting the team during the Design phase.
  • Involved in development for complex jobs
  • Reviewed the jobs developed by the team members
  • Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.

Project 5

Confidential

Role Team Lead

  • Confidential is an intranet web based CRM system for Corporate customers. SMART delivers sales, pipeline management, relationship management, account planning processes and information for the front line business staff in Major Corporate, Large Corporate PACS and ultimately FI. The SMART application is a composite of a Siebel front end application, supported by data drawn primarily from the Wholesale Data Warehouse using the Datastage ETL Tool, and financial and analytical reporting provided through Business Objects. It forms a key part of Corporate Market's strategic architecture at present. IT has recommended that it is replaced by the HBoS' Microsoft Dynamics platform.
  • Current project has been initiated to implement some business critical fixes to ensure that the solution remains robust through during 2009 till the completion of the Integration.
  • The current Marketing Bulk upload process will be enhanced to provide a strategic, automated and less manual solution with appropriate error handling and job status reporting. Also this process will be brought within the overall service cover and SLA provided by ITSD, which would be inline with the existing SMART batch processes

Roles Responsibilities: -

  • Involved in requirement gathering.
  • Prepared Low Level Document for the project
  • Supporting the team with the Design.
  • Involved in development for complex jobs Siebel loading
  • Reviewed the jobs developed by the team members
  • Raised the Change request using HP service manager to move code to UAT and PROD.
  • Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.

Project 6

Confidential

Role Team Lead

  • Confidential will introduce a new Customer Master Database CMD that will drive accurate, compliant reporting of risk and new compliant credit application and assessment processes. CMD will store and maintain a single view of LTSB corporate customers. The overall aim is to obtain Advanced Internal Ratings Based AIRB status under the BASEL II accord as expected of a Tier 1 financial services organization.
  • In CORMAC project we have involved in many application and many tool we have used,
  • EBCDIC files, Teradata source, Siebel source, webservices, XML ouput, oracle source,
  • There are 6 feeds in CORMAC project.

1 Data feeds from CMD database to SMART application

2 Data feeds from CMD database to Rhea application

3 Data feeds from Crisp application to CMD database

4 Data feeds from Rhea application to CMD database

5 Loading the CAP Common systems accounts into CMD database Added based on CR054/055

6 Also includes the changes done as part of Address Id resolution in CMD SMART data feed

Roles Responsibilities: -

  • Involved in requirement gathering.
  • Prepared Low Level Document for the project and various components of the project.
  • Supporting the team with the Design. Trained the team members in related to the project
  • Involved in development for Complex jobs SCD,Siebel loaing,XML output,Webservice load
  • Reviewed the jobs developed by the team members
  • Raised the Change request using HP service manager to move code to UAT and PROD.
  • Involved in preparing the Weekly Task sheet and conducting the weekly meeting with client to update the work status.
  • Prepared training documents.
  • Conducted training sessions to fresher's

Project 7

Confidential

Role Team Member

Confidential is replacing DTS system sql Server to Informatica 7.1, All the application using the DTS should be moved to Informatica 7.1, There are various source systems used to load MIS warehouse which is done both on daily basis and some monthly, This project will create Informatica ETL mappings required for data feeds/fetch from Sql server and updating attributes and entities within MIS based on specified events. The scope of the project is to build, test, implement and schedule ETL workflows

Roles Responsibilities: -

  • Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica.
  • Created mappings and transformations and target tables.
  • Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
  • Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, union Transformations and Mapplets and then load to data warehouse
  • Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
  • Prepared UTC,Dataflow diagrams,
  • Prepared workflow documents, mapping documents
  • Prepared training documents,

Project 8

Confidential

Role Team Member

Confidential is migrating to an externally hosted web-based CRM salesforce.com solution as a result of which it needs to synchronize specific functional entities between PGP data warehouse and Salesforce.com. P G will be using Informatica 8.1 with Informatica Connector to feed data to and from saleforce.com

Roles Responsibilities: -

  • Creating the Low level Design Document.
  • Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica.
  • Created mappings and transformations and target tables.
  • Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
  • Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouse
  • Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
  • Prepared UTC,Dataflow diagrams,
  • Prepared workflow documents, mapping documents
  • Prepared training documents,
  • Prepared Visio.

Project 9

Confidential

Role Team Member

Confidential is one of the largest fleet management companies in the world, with earning assets of over 9 billion and more than 1.2 million cars and trucks under lease and service management globally including the United States, Canada, Mexico, Europe, Japan, Australia and New Zealand. GE Capital Fleet Services is one of 24 companies that compose GE Capital, one of the largest diversified financial service companies in the world.

Roles Responsibilities: -

  • Involved in Taking the Back up of repositories and in creation of folders in Repository manager and import and export of tables from one repository to the other repositories.
  • Involved in creating mappings according to the requests.
  • Involved in doing analysis for the Change and Support requests.
  • Involved in testing of Informatica when oracle is upgraded.
  • Involved in monthly activities like triggering the e-billing,
  • Involved in creating reports in BO according to the requests.
  • Involved in Daily and monthly Loads of data.

Project 10

Title : Staples Strategic Sales Analysis System:

Confidential

Confidential is a global retailer of office furniture, personal computers, printers and consumer electronics. They believe in selling recycled, eco-friendly products. This Project builds Corporate Data to suit requirements of Data Ware House for providing sales analysis and purchase analysis for taking business decisions by identifying key financial metrics like amount sold, quantity sold and revenue.

Roles Responsibilities:

  • Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica.
  • Performed data cleansing and transformation using INFORMATICA.
  • Created mappings, mapplets, and transformations and target tables.
  • Used Workflow Manager to read data from sources, and write data to target databases, and manage sessions.
  • Created data mappings to extract data from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouseLoading facts and dimensions from source to target data warehouse.

Project 11:

Title : Gap Sales Information Warehouse

Confidential

Confidential a leading international specialty retailer offering clothes, accessories and personal care products for men, women, children and babies. This project captures data from desperate OLTP sources and loads it to the corporate warehouse after series of refinement processes. The goal of this project is to provide strategic information to business users for taking business decisions.

Roles Responsibilities:

  • Developed data Mappings between source systems and warehouse components.
  • Used ETL Tool INFORMATICA for extraction, transformation, and loading in Data warehousing.
  • Performed data cleansing and transformation using INFORMATICA.
  • Created and monitored workflow tasks and sessions using informatica power center.
  • Designed and developed expression, joiner, look up, filter, aggregator, update strategy transformation to generate consolidated data identified by dimensions using Informatica tool.

Project 12:

Project : Classic foods ltd CFL

  • Confidential ,usa is in the business manufacturing goods and beverages with factories all over the globe, this has many products with different flavors and the product sales is through many channels like csd ,institutional and dealers including north America, Africa, pacific Europe
  • At present the product and sales data is kept at their respective branches and the data is collected from other sources to excel tables in the form of daily weekly ,monthly,quaterly basis for each sales region and branch and colleted at corporate office for aggregation the data as per the report requirement and generated reports manually

Roles Responsibilities:

  • Involved in data analysis and data cleansing
  • Involved in Data Extraction, Transformation and Loading ETL process
  • Created mappings to extract from different source files, transform the data using Filter, Lookup, Update Strategy, Aggregator, Expression, Router, Joiner, Sorter, Rank Transformations and then load to data warehouse.
  • Developed and tested mappings.
  • Created sessions, database connections using Workflow Manager.

Suresh Kumar. R

Hire Now