Project Data

Pooja Katiyar

Email : *******.*****@*****.***

Phone: +1-206-***-****

Career Summary

Working for more than 7 years in Data warehousing and Business

Intelligence on complete development life cycle data modeling, implementing

and operating for enterprise data integration and helping in growth of

Organization.

> Working for more than 7 years in Data warehousing and Business

Intelligence using Informatica tools.

> Strong experience in Informatica (Power center, Power exchange, web

services), Oracle (Sql, Pl/Sql) and Sybase (Ase/IQ).

> Created database objects like stored procedure, functions, packages,

indexes, triggers, analytical functions, DB performance tuning using SQL,

PL/SQL.

> Experience in processing entire data warehousing architecture like Data

mart, EDW and ODS.

> Competent in data warehouse project planning, data modeling, development,

support and enhancements.

> In-depth knowledge of DW concepts on Dimensions, Facts, dimensional

modelling, slowly changing dimensions, OLAP.

> Worked with scripting in Unix, Dos, power shell.

> Worked end to end (design, development, testing, implementation and

support) life cycle in multiple projects.

> Involved in understanding Business process and coordinating with Business

users for requirement gathering. Also worked in Source data analysis,

identifying business rules, data migration and data modelling.

> Worked as an ETL team lead too.

> Good grasp on leaning new tools and technology.

> Experience in Banking, finance and life insurance domain.

> Ability to manage multiple task assignments successfully.

> Active member of Informatica forums

> Achieved six-sigma green belt.

Technical Skills

> Informatica Power center 8.X, 9.X

> Informatica Power exchange 9.X for DB2 system

> Database: Oracle (sql, Pl/Sql), Sybase ASE, Sybase IQ

> Scripting: basic Unix, Dos, Power shell

> PL/SQL Developer 7.0, Toad, Rapid SQL, Sql developer GUI

> Operating System: Unix, Windows, AIX

Academic Credentials

Bachelor of Engineering (Computer Science), 2006 from B.I.S.T

Bhopal (India)

Project Overview

Lenora Systems, Oct,2014 - Till date (US)

Details:

Working for an insurance firm on job scheduling, DW Production support

and load monitoring.

iCreate Software Ltd., Aug,2012-Feb,2014 (India)

iCreate is a product based firm which also provides customized banking

related solutions to client. They have developed products like Bizscore,

NPA for regulatory reporting.

Responsibilities:

> Apart from regular projects I have also worked on couple of other

demo/poc/consulting as and when required:

Client demo: Developed and presented data mart (end to end) for

poc and demo purpose to an Arabian bank.

Worked with some on-going to meet FTR and OTD for projects as per

project demand (HDFC npa, CITI bank initial phase project take off)

Worked on proof of concept for a Philippines bank (to assure

client we can handle data and provide them ROI effective solutions)

Provided consulting for Syndicate bank performance and data load

issues.

> Worked as a lead consultant on three projects and managed team of 3 to 5

resources.

> Tool/Technology: primarily worked with Informatica power center, Oracle

> Apart from Power center have also learned and used IDQ, Sybase IQ and Sql

server for poc and client demo purpose

> Played a key role in formulation of strategies and ETL development for

extraction, transforming & loading of data from different sources through

power center and complex Pl/Sql coding

> Worked on performance tuning in Informatica and Oracle.

> Worked on all phases of testing -unit, system and user acceptance

testing.

> iCreate Product implementation and up gradation.

> Production movement of code and support to end users.

> Business requirements in case of any enhancement/change request and

providing the optimum solution within the specified timeline.

PriceWaterhouseCoopers, June-2010-Aug2012 (India)

Description:

Apart from below project have worked for couple of months with Icici

bank for helping with new team setup, developing and team orientation for

sales and management related expense project.

Worked with Icici prudential. ICICI Prudential is the largest private

insurance company and second largest overall in India after LIC. As the

organization is growing, so are the information needs as well as the

speed with which this information is required. The current information

dissemination setup is not performing to its full potential and requires

either a quick upgrade or potentially a replacement. The client has

recognized the shortcomings of the existing setup and has engaged PwC to

review, re-architect and implement the data management platform for the

enterprise.

Tool/Technology: primarily worked with Informatica power center, power

exchange, Oracle and Sybase IQ/ASE

Deliverables:

> Also developed, tuned and supported live Informatica web services in

Power center

> Extensively worked on complex SQL, Pl/SQL and query/DB tuning

> Successfully designed, developed and implemented a data mart from scratch

> Developed module for sales and management related expenses reporting data

which helped client in analysis

> Worked with existing Data warehouse for development and enhancement

> Extensively worked on performance tuning for a data hub

> Catered to ad-hoc change requests and last moment code changes.

> Single handedly developed and implemented sales and management related

expense ETLs

Tata Consultancy Services, Jan, 2007-June, 2010 (India)

Description:

Worked on couple of projects for GE (Ge money, Ge asset management

accounts). Joined as a fresher and got opportunity to learn and implement

DW concepts. Learned and used Informatica Power center. Also learned VB

scripting and did six sigma green belt improvement project and

certification.

Deliverables:

> Worked on different projects of credit cards, mortgage, asset management

as ETL developer

> Worked on complete life cycle of DW project (including ODS)

> Tool/Technology: primarily worked with Informatica power center, Oracle

and Unix scripting

> Helped in generating test data, test results and helped with unit

testing, UAT and PVT

> Developed a micro to generate dummy test data in required file format

> Done Six sigma and created micro for live project improvement

> Learned Erwin.

> Documented UTP, UTR, PVT, LLDs etc.

Appreciations

Bagged appreciation for leading a naive team to achieve successful

implementation of complex requirement and deliveries on time.

Client appreciation for excellent commitment and on time delivery

excellence

For excellent delivery quality from client and on project learning

excellence from higher management.

Training and Certification

Imparted Informatica training to batch of fresher's

Six Sigma green belt certified

NCFM certificates for stocks and mutual funds

Foundation of data analysis on EDX honour code certification

Personal Details:

Current Address 13718 NE 12th ST APT G104, Bellevue WA 98005

Contact No. 206-***-**** / 206-***-****

D.O.B 06/12/83

Linguistic Proficiency English, Hindi

Nationality Indian

Visa Status H1B

Contact this candidate