Summary:

• Total 8 years of professional experience in IT industry, in the field of Data Warehousing/Business Intelligence using industry leading tools and technologies such as Informatica 7x/8x/9x, Cognos 8x, Microstrategy 8x and databases as Db2, Oracle, Teradata. Have worked in multiple projects across Retail, Healthcare, Finance and Automobile domains at various client locations in United Kingdom and United States America.
• Over 7 years of specific, current experience in Data Modeling, Data Extraction, Data Migration, Data warehousing and report generation using Informatica 7x,8x,9x, Cognos 8x Reporting and Microstrategy 9x Reporting.
• Over 3 years of experience of leading multiple ETL projects of team members between 3-7 members.
• Over 5 years of experience in Extraction, Transformation, Loading (ETL) processes using Informatica 7x, 8x, 9x. Is an Informatica Certified Developer.
• Over 3 years experience in working with reporting tools like Cognos 8x and Microstrategy 8x. Have developed complex reports, dashboards and cubes using these tools and also worked on framework modeling and schema designer using them.
• Over 2 years hands on experience on UNIX and LINUX shell scripting.
• Data warehousing Conceptual Expertise includes knowledge in building and enhancing Data Marts and Warehouses, Data Modeling through Dimensional Modeling and Logical & Physical Database Designing along with a Good overall Knowledge on the basics of other Data warehousing Concepts. 2+ years experience on data modeling tools like Erwin, Visio, IBM Design Studio.
• Vastly experienced with various Databases like Teradata, Oracle 11g/10g/9i, Db2 8x and 9x.
• Strong Database Experience with strong knowledge of writing complex SQL scripts as well as SQL tuning. Oracle SQL certified (IZ0-007).
• Experienced in writing design documents, validating requirement, perform code review, code tuning
• Proficient with Tools/Utilities such as TOAD, SQL assistants.
• Worked on both waterfall model as well as Agile methodology projects.
• Familiar with usage of tools like QC and JIRA for defect tracking.
• Involved in 24*7 production support for ETL job runs and reporting.
• Experience in writing Testing scripts & scenarios based on Functional & Business requirements and solution design.
• Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.

Technical Skills

ETL Tools - Informatica 7x/8x/9x.
Reporting Tools - Cognos 8x, Microstrategy.
Modeling Tools – Erwin, IBM Design Studio, and Microsoft Visio.
Programming – UNIX and Linux Shell Scripting
Database – Oracle 9i/10g/11g, Db2 8x, 9x, Teradata, Sybase, etc
Platform - Linux, UNIX, Windows

Certifications

Informatica Certified Developer
Cognos Certified Report Author

Professional Experience

DETAILS OF THE PROJECTS WORKED ON

01

Project Name

Release 1 – GCD Data warehouse – Sports activity Datamart build

Confidential
Functional Area Retail & Datawarehousing, ETL
Description of the project

Purpose of this project was to build multiple datamarts containing user activities and ecommerce related information and club them together to build Global consumer data warehouse. As part release1, scope is to build the Sports activity data mart that comprises of building around 12 fact tables and 20 dimension tables related to user and their sport activity related information. Informatica was used to build various incremental and Initial load scripts. Oracle 11g was used as backend. Oracle streaming used to copy data from various source systems to GCD staging database and Informatica jobs run on them and populate various dimension and fact tables in the datamart.

Role

:Informatica Technical Lead and Developer.

Responsibility

:Requirement gathering, validate and review data model, designing (Technical Design) ETL interfaces, reviewing mapping design by team members as well as leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows.

Duration

:From JAN 2011” “TILL DATE”

Software

:Informatica 8.6.1 and Oracle 11g

02

Project Name

Integration HUB Grandslam Feed

Confidential,Functional Area Retail & Datawarehousing, ETL
Description of the project

This project was to migrate old legacy (PL-SQL) code to new Informatica code to generate 29 incremental extracts (daily/weekly) mainly for order management/commerce related data from newly build ATG-10 and Sterling database for third party of the client for loading into their e-commerce datamarts. Since source system building was also in progress parallel hence it made it more challenging with day to day requirement changes. Source was Oracle11g and target as flat files.

Role

:Informatica Technical Lead and Developer.

Responsibility

:Requirement gathering, designing (Technical Design) ETL interfaces, reviewing mapping design by team members as well as leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows, production migration and providing stabilization support.

Duration

:From JUL 2011” “To DEC 2012”

Software

:Informatica 8.6.1 and Oracle 10g

03

Project Name

Enhancement, Maintenance and Support of Large Retail Warehouse

Confidential,Functional Area Healthcare and Retail; Datawarehousing, ETL and Reporting
Description of the project

Provide maintenance and support to large warehouse for a UK Retail and healthcare major. This includes lead a team of 8 people to perform day to day scheduled ETL jobs in Informatica and Linux scripts and issue resolution in case failures. This assignment includes various day to day data related issue resolution and also to perform various maintenance activities in the warehouse. This also includes performing design work and leading small teams in development and deployment of various small ETL projects.
Some of these projects are –

• Bossbars Automation,
• ROI Transaction data Error handling and automation,
• ABACUS to APT data transmission,

Tools utilized were Informatica 8.1, Db2 9.5 and Linux scripting.

Role

:Team Lead and Developer

Responsibility

:Requirement gathering, data modeling and designing (Technical Design) ETL interfaces as well as leading the team in coding, testing phase for any development activities. In support handling all Client escalations, provide technical guidance to team members in various ETL issues and also provide ETL monitoring support from onshore.

Duration

:“From AUG 2009” “To JUN 2011”

Software

:IBM Balanced Warehouse (Db2 9.5 & Linux), Informatica 8.1, Linux scripting.

04

Project Name

Data Migration from Unix & Db2 8.1 to IBM balanced warehouse 9.5

Confidential,Functional Area Healthcare and Retail; Datawarehousing, ETL and Reporting
Description of the project

To migrate data from old warehouse in Unix & Db2 8 platform to new IBM balanced warehouse platform for a large UK retailer. DB2 SQL and Linux scripting as well as Informatica were used for data migration and setting up various ETL interfaces. Apart from old existing interfaces several new interfaces were designed in Informatica. Data modeling activities were performed using the tool IBM Design Studio. There were 20 odd new reports were created on top of this warehouse. The role was Requirement gathering, preparing DLD, data modeling, Reviewing the codes and UTP prepared by team members. Further performed framework modeling in Cognos, report design and deployment activities. Also acted as technical lead to help team resolving any issue related to coding and report build. Tools utilized were Informatica 8.1, Cognos 8.3 (Framework manager and Report Studio), Db2 9.5 and Linux scripting.

Role

:Informatica and Cognos Developer

Responsibility

:Requirement gathering, data modeling and designing (Technical Design) reports and ETL interfaces as well as leading the team in coding, testing in both ETL and reporting phase.

Duration

:From APR 2008” “To JUL 2009”

Software

:IBM Balanced Warehouse(Db2 9.5 & Linux), Informatica 8.1, Linux scripting, Cognos 8.3

05

Project Name

MI Dashboards Project

Confidential,Functional Area Retail; Datawarehousing and Reporting
Description of the project

To create set of Dynamic dashboards and reports for Sainsbury’s. The role involved working in the requirements gathering, design till development stage. It involved identification of list of metrics, attributes, and reports in the requirement stage to technical designing of the reports layouts and Dashboard layouts. Worked as team lead to develop set of business critical dashboards (10 dashboards) and reports (122 reports). Tools utilized were Microstrategy 8.1 Desktop and Web and Teradata as database.

Role

:Microstrategy Technical Specialist and Lead.

Responsibility

:Requirement gathering and designing (Technical Design) reports and Dashboards as well as leading the team and also developing reports and dashboards.

Duration

:“From MAR 2007” “To APR 2008”

Software

:Microstrategy 8.1 and Teradata

06

Project Name

Loan System Solution

Confidential,Functional Area Finance; Datawarehousing, ETL and Reporting
Description of the project

This project was mix of ETL and reporting works. First phase of the project involved building various ETL mappings in Informatica to populate the Loan data warehouse for an US Financial major and the second phase involved generation of business reports (12 reports) from the Loan warehouse. In ETL part Informatica mappings were created and scheduled to load data from Loan system flat files to a ODS database and then from ODS to Data warehouse. In the Reporting module simple monthly, yearly, zonal reports, and cube design were performed. Teradata used as Back end database and Informatica Power Center 7.1 was used as ETL tool and Cognos 8.1 (Report Studio for reporting and framework manager for modeling) used Reporting purpose.