Data Manager

DIVYA NARESH GUPTA

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

Phone : +91-977*******

Personal Details

Date of Birth 12th August, 1986

Nationality Indian

City/State/Country Mumbai/Maharashtra/India

Technology Summary:

Skill Set Coding Languages : PL/SQL, Unix Shell Scripting

Summary

Concepts : RDBMS, ETL, Datawarehousing

Tools :

ETL - Informatica Powercentre 9.0.1,

8.6,

Informatica Data Quality

Reporting - Business Objects (Designer, Desk-I,

Web-i) V R3/R2,

Xcelsius 2008,

Database - Oracle Toad,

PL/SQL Developer

Hyperion Oracle Essbase

Testing - HP Quality Centre

OS : Windows XP, Unix

Databases : Oracle 10g, 9i, SQL Server 2005

Certifications

Informatica Certified Developer (v 8.6)

Oracle Certified Associate (OCA) in Oracle 9i

Experience Summary:

Duration Organisation Designation

Dec 2011 - Till NSE Infotech Services Ltd. Associate systems

Date Analyst

Sep 2008 - Jun TATA Consultancy Services Systems Engineer

2011 Ltd.

Projects and Responsibilities:

DWH Modernisation Migration of FAO Intraday & EOD load from Perl to

Informatica to enhance loading performance and

(Aug 2012 - Till provide enriched data retrieval.

Date) Understanding of data flow, business concepts,

data dependencies, impacted universes, etc.

Prepare optimal design for the entire application

from ETL and structural perspective, development

of same, preparation of test cases, parallel

loading, unit testing.

Co-ordination with users for data validation on

user reports, troubleshooting and fixing

discrepancies.

Migration of existing dimension loads which run

via PRO*C scripts to Informatica.

Impact Analysis on existing user reports.

Data integration, changes in LDM, removal of

unwanted data.

Support

Activities Change management requests

(Dec 2011 - Till User BO query error troubleshooting, optimization

Date) of user queries, user access management

Daily ETL load monitoring and root cause analysis

of any task failures. Providing permanent fixes

to code bugs.

Daily end-of-day orders & trades data load health

checks, daily aggregates & datamart creation,

zero key checks in fact tables, monthly

tablespace monitoring, server space management,

partition creation, co-ordination with dba.

Hyperion Essbase ETL monthly data loads,

provision of online and offline dashboards to

users.

Mode of Trading /

Transactional To provide monthly turnover data for CM,FO & CDS.

Alerts for Reports also required the percentage turnover

trading members based on terminal categorisation for the mode of

based on trading (dma, mobile, algo,ibt, etc.)

Surveillance To detect unusual member or client trading

Obligation for activity based on various parameters.

Brokers Co-ordination with business users for requirement

(Dec 2012) understanding and analysis.

Build universe and Desk-i reports.

Create Free-Hand SQL reports with prompts for

start date and end date for data analysis

flexibility to users.

Prepare test cases and run reports for data

validation over specified timelines.

Neat on Web (NOW)

- Users generate daily turnover reports for various

Datawarehouse segments. When adhoc reports are to be created

creation that require large historical data, the source

(May 2012 - Jul files and reports generated of previous days have

2012) to be accessed manually to create a compiled

version of the statistics on the timeline

required.

To create a stand alone schema for NOW data for

loading data on a daily basis.

To identify the facts and dimensions and create a

logical data model.

To build ETL workflow in Informatica scheduled to

load the daily NOW data.

To build a universe on the schema and provide

access to users on Web-i to retrieve the data

from the database or generate customized reports

Migration of the existing shell scripts to

Informatica or procedures for daily statistic and

member activity report generation going to senior

management.

Train/help users with basic functionality of

Business Objects for report generation.

Daily Statistics

Migration The migration is required to enhance the

(Feb 2012 - Apr performance, since the current application is

2012) time consuming due to large data volume and the

indirect reference to the base tables for data

every time the view is hit for data retrieval.

To eliminate the dependency on procedure and

scripts taking around 6 to 7 hours of statistics

computation.

Migrate the application to Informatica

Categorise the BO reports to display Business and

System statistics separately.

Impact analysis and code changes of enhanced

trading machines.

Enterprise Data

Warehouse support It is a Production Support project which provides

real time level 2 and level 3 maintenance and

(Feb 2011 - Jun support to different line of businesses like

2011) Finance, Professional Educational, Supply Chain,

and others for Ethicon Endo-Surgery, Inc.

ETL support consultant (L2 & L3)

Informatica 7, Maestro Scheduler, Cognos(Report

Studio)

Lifescan

Migration Project The purpose of this project was to migrate Cognos

(May 2010 - Jan ETL working applications from Data Manager to

2011) Informatica - Powercenter. Cognos-Data Manager

Catalogs were to be analysed in terms of design,

functionality and performance, and developed

using Informatica. Analysis included design

optimization and performance improvement on the

part of the developers

Informatica Designer/Developer/Tester(Unit

Testing)

IRIS - To build an Operational Data Storage (ODS) which

Foundational was to be populated with data coming from various

Release sources that had to be cleansed and processed

(Jul 2009 - April according to the business requirement.

2010) Informatica Developer/ Tester(Unit Testing)

IKON Oracle Apps

CRM Testing IKON office solutions collects about one million

(Jan 2009 - Jun meter reads a month from customers and service

2009) technicians for usage billing. In order to reduce

the error rate when meter reads are registered it

is imperative to validate the meter reads at the

time of entry. The objective of this project was

to test the meter reads in different forms of

Oracle apps (CRM).

Oracle Product Consultant/Tester

Oracle Apps, HP Quality Centre

Educational Qualifications:

Degree and Date Institute Major and Percenta

Specialization ge

of Marks

B.E. Cummins College of Electronics and 64.33%

(June - 2008) Engineering for Telecommunication

Women, Pune Engineering

University.

H.S.C.(April-2004) Kishinchand Science Stream 88.50%

Chellaram College,

Mumbai.

S.S.C. Convent of Jesus NA 85.73%

(April-2002) and Mary-Fort,

Mumbai.

Contact this candidate