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.
  

Professional Experience

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

Project Name: Release 1 – GCD Data warehouse – Sports activity Datamart build

Client Name: Confidential, US
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

Project Name: Integration HUB Grandslam Feed

Client Name Confidential, US
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

Project Name: Enhancement, Maintenance and Support of Large Retail Warehouse

Client Name: 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.

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

Client Name: 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

Project Name: MI Dashboards Project

Client Name 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

Project Name: Loan System Solution

Client Name 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.

Role: Informatica and Cognos Developer

Responsibility

Design mappings to populate data from Loan system files to Loan data warehouse using Informatica PowerCenter 7.1 and design reports on Cognos8.

Duration: “From FEB 2006” “To FEB 2007”
Software: Informatica PowerCenter 7.1, Cognos 8 and Teradata

Project Name: Fidelity Global Platform BI Solution

Client Name: Confidential
Functional Area: Finance; Datawarehousing & Reporting

Description of the project

US financial lead firm planned to launch Global Platform (GP) as a service for Talent Management, HR data management, HR administration, Payrol solution to their various clients. Business Intelligence was a key component in the overall design of GP.
The main objective of this project module was to Evaluate and compare various market leading BI reporting tools (BO XI, Cognos8, Microstrategy 8, Pentaho, and Jasper Reports) and recommend one them to be used in the GP for reporting.

• Validate overall future state Global Platform architecture on BI perspective and approach to achieve the immediate and future goals. Asses and make recommendations against best practice in the Data Warehouse implementation.
• Completed a Proof of Concept that involved Report generation and features evaluation (as per GP requirements) on Cognos 8.1. Tools utilized were Cognos 8.1 Framework Manager, Report Studio, Query Studio and Oracle 9i.

Role: System Analyst and Cognos Developer

Responsibility

Worked as analyst for comparing and selecting BI reporting tool for the program and also was part of the architecture team which involved validation of the existing GP architecture and designing the future GP architecture blueprint.

Duration: “From JUL 2005” “To FEB 2006”

Project Name: Sales Cube POC

Client Name Confidential
Functional Area Automobile; Datawarehousing & Reporting

Description of the project

This was a POC project that involved Cube design and Report generation using Cognos Powerplay for an Automobile major in China. The main AIM of the POC was to test –

• To use existing framework manager model in Transformer to create the transformer specific model.
• To test the performance of a cube holding 1.5 GB of data containing various automobile sales information. 5 User reports were created in Powerplay cube.

Role: Cognos Developer

Responsibility

Gather requirement from the client, Develop transformer model and cube and test them.

Duration: “From JAN 2005” “To Jun 2005”
Software: Cognos Powerplay Transformer, Powerplay Cube and Oracle 9i
Client Name: Confidential

Academic Qualification

Degree: Bachelor of Technology
Discipline: Computer Science & Engg.