Sales Project

Contact Info:

Ashish Chaturvedi

Cell: 510-***-****

E-mail: *****************@*****.***

Summary:

Present with 14 years of experience, 12 years in ETL, Informatica as Administrator, Architect,

Developer and Team lead roles. 7 years in relational database design development and

Client/Server systems with good knowledge of Oracle tools and others. Excellent knowledge in

developing interfaces using ETL tool (Informatica) and working on data migration and

integration in a Data warehouse environment with Vertica,Oracle,SqlServer as database.

Experience with Data analyzer(BI tool) in Web Channel analytics (click stream analysis)

warehouse environment. Good exposure to Hyperion planning and essbase environment with

knowledge of Hyperion server architecture, installations and backend platform support.

Proficient in system analysis, design, requirements gathering, developing applications and

programming. Extensive experience in Production support environment for data migration from

People Soft to Sales Reporting.

IT Skills Summary

Core: Oracle, DB2, Vertica, Informatica (Administration and Development including Grid)

Tools: Informatica Power center, Vertica, Data Analyzer, Autosys, PL/SQL, SQR, Hyperion

Business Intelligence suite, Hyperion essbase

Industries: Software development, Banking, Health care, Insurance, Staffing, Marketing,

Construction

Operating System: Windows, Unix

General: Data Modeling, Requirements Gathering, Application Development, Production

Support

Experience Summary :

Risk Management Solutions July 2011 To current

7575 Gateway Blvd Contractor (40 hrs per week)

Newark, CA Principal Engineer

Kaiser Permanente July 2010 To July 2011

Hacienda drive Contractor (40 hrs per week)

Pleasanton, CA Informatica lead

Wells Fargo Bank June 2009 To June 2010

333 Market Street Contractor (40 hrs per week)

Sanfrancisco, CA Informatica lead

ROBERT HALF INTERNATIONAL October 2001 To May 2009

5735 West Las Positas Blvd Full time (40 hrs per week)

Pleasanton, CA – 94588 Senior Developer

KANA COMMUNICATIONS Sep 2000 To Sep 2001

181 Constitution Drive Full time ( 40 hrs per week)

Menlo Park, CA – 94025 Software Engineer, Lead

Interfaces(ETL)

ROBERT HALF INTERNATIONAL Aug 1998 To Sep 2000

5720 Stoneridge Drive Full time (40 hrs per week)

Pleasanton, CA – 94588 Programmer, Developer

RAI PREXIM (INDIA) PVT.LTD Dec 1994 to Jan 1997

9A Connaught Place Full time (40 hrs per week)

New Delhi – 110001, India Project Engineer

Education Summary :

UNIVERSITY OF CALIFORNIA Sep 1997 to May 1998

Berkeley Extension Certificate(CIS)

Berkeley, CA – 94720 Passed with Distinction

SOUTH GUJARAT UNIVERSITY August 1990 to July 1994

Regional College Of Engineering Bachelor Of Engineering

Surat – 395007, India Passed with First Class

PROJECT DETAILS

ELA (Exposure Loss Project: Build and Tune ETL processes for Exposure Loss data warehouse at

RMS to run risk simulation reports for Insurance and reinsurance

Analytics Warehouse)

companies.

Technical Environment : Informatica, Vertica

• Design and development of ETL layer to load massive amount of data

generated by disaster simulation engines into loss analytics warehouse for

generation of reports to provide risk estimation and analysis

• Warehouse development in Vertica database.

• ETL process design and development using Informatica 9.5 with special

attention to performance tuning for large loads.

• Responsible for laying out the Informatica Server architecture with

Integration service on GRID and high availability.

• Implementing the Informatica setup in AWS (amazon cloud services) for

higher scalability of nodes.

Project : Build and Tune ETL processes for Membership datawarehouse at

MDW (Membership

Kaiser

Data Warehouse)

Technical Environment : Informatica, Oracle

• Design and development of Interface to migrate large volumes of membership

data for all us region into membership datawarehouse for downstream

reporting.

• Development in oracle database schema and views and Informatica(ETL)

tool.

• Two stage loading with a conforming area and the reporting area. Audit data

and control metrix stored in Audit shcema with error handling.

CDW (Claims Data

Project : Build and Tune ETL processes for Claims datawarehouse at Kaiser

Warehouse)

Technical Environment : Informatica, Oracle

• Design and development of Interface to migrate Transactional system data

for Colorado region into claims datawarehouse for downstream reporting.

• Development in oracle database schema and views and Informatica(ETL)

tool.

• Two stage loading with a Staging area and the reporting area. Audit data and

control metrix stored in Audit shcema with error handling.

CDR (Corporate Data

Project : Build Corporate Data Repository for Robert Half International

Repository)

Technical Environment : Informatica, DB2, Sun-Solaris, shell scripts

• Design and development of Interface to migrate Transactional system data

into Corporate Data repository for reporting.

• Development in shell scripts, DB2 database schema and views and

Informatica(ETL) tool.

• Two stage loading with a Staging area and the CDR. Audit data and control

metrix stored in Audit shcema with error handling.

• Extensive Production support and trouble shooting on Interface

• Job scheduling on Autosys.

Hyperion Planning

Project : Hyperion Planning for Budget operations

for Corporate

Technical Environment : Informatica, Hyperion Planning,Essbase

Budgeting

• Responsible for implementing, maintaining and supporting the hyperion

infrastructure .

• Installed shared services, essbase, planning application on windows and

solaris systems.

• Devleoped Planning migration and backup plans for the application

developed by development teams

• Extensive production support for upkeeping of the hyperion planning system

• Informatica adaptor installations for Hyperion Planning.

Project : Kana Connects Interface to Client systems

Technical Environment : Informatica, Oracle, PLSQL

Kana Conduits

• Design and development of Interface to migrate Client systems customer data

Interfaces

into kana schema

• Development in Plsql stored procedures and Informatica(ETL) tools.

• Two stage loading with a Black Box in stage II where validation and

Bussiness logic was coded using Informatica transformations.

• Extensive Production support and trouble shooting on Interface

• Job scheduling on Informatica PowerMart

Project : Payroll/Billing/AR Sales Reporting

Sales Reporting :

Technical Environment : Oracle, PLSQL, Crystal Reports, Autosys

• The project involved studying the requirements of the client for developing

new reports for management decision support. Extensive requirement analysis

was conducted with users to determine families of Sales Reports to be

generated.

• Was involved in, developing and testing the following reports based on the

user requirements:

a) Employee Scorecard reports

b) Regional Sales analysis report

c) Individual assessment summary report

d) Placement summary reports

e) Reconciliation control metrics reports

• Job scheduling on Autosys for above mentioned reports.

• Developing PLSQL filters for data transfer into hirarcheal report ready table

structure.

Project : People Soft to Sales Reporting Interface

People Soft to Sales

Technical Environment : Oracle, SQR, Crystal Reports, Autosys

Reporting Interface

• Design and development of Interface to migrate People Soft

Payroll/Billing/AR

data to Sales Reporting and their control reports.

• Development in SQR stored procedures and SQR control reports.

• Job scheduling on Autosys by UNIX scripts

• Extensive Production support and trouble shooting on Interface

Project : Reengineering Interface

Performance

Technical Environment : Oracle, PLSQL, Informatica Power mart/Power

Improvement and

center, Crystal Reports, Autosys

Reengineering of

Interface using

• Data modeling and design using ETL(Extraction Transformation and

Informatica Power

Loading) Data warehousing tool.

mart/Power centre

• Development Testing and implementation of re-architectured interface.

• Development pertaining to data warehousing concept and standards.

Project : Major Accounts data mart

MARS (Major

Technical Environment : DB2, PowerCenter, PowerAnalyzer, Autosys

Accounts Reporting

System)

• Design and development of ETL system and process to load enterprise data

into data mart for major accounts reporting using PowerCenter512

• Job scheduling on Autosys by UNIX scripts

Extensive Production support and trouble shooting on Interface

Project : Clickstream Analysis data mart

WCA (Web Channel

Technical Environment : Oracle, PowerCenter, PowerAnalyzer, Unix, Autosys

Analytics)

• Customizing of Packaged analytics suite and emplementing in corporate

environment.

• Testing and implementation lead role. Responsible for support and

enhancement as requirement changes.

• Created reports as per business requirement using power Analyzer.

CAPABILITIES

Databases

• Vertica

• Oracle

• DB2

• SqlServer

Software, Tools & Languages

Technology

• •

SQL Tuning

• •

PLSQL Optimization

• •

Informatica Power Mart/Centre Hyperion BI +

• •

Informatica Power Analyzer Hyperion Essbase

• Autosys

• SQR

• SQL Navigator

Hardware & Operating Systems

• MS Windows

• UNIX

•

Industry Software development

• Η ealth and Insurance

• Staffing

• Construction

• Marketing

EDUCATION, CERTIFICATIONS & PUBLICATIONS

•

Training Essentials of Oracle Application Development

• Concepts of Relational Database Management Systems

• Systems Analysis &Design: an overview

• Systems Analysis & Design: applying structured techniques

• Systems Analysis & Design: analyst as an internal consultant

• Programming in Microsoft Visual Basic 5.0

• Using the UNIX Operating System: Shell scripting in the C Shell, Using VI

Editor.

• Business Data Communication

• PLSQL Training from Oracle Corporation

• ETL Tool Training from Informatica Corporation

• Performance Tuning training from Oracle corporation

• Performance Tuning training from Informatica Corporation

Languages • English

• Hindi

• Nepali

University of California, Berkeley, Professional Certificate, Computer

Education

Information Systems: Analysis, Design and Management

Regional College of Engineering, India Bachelor in Engineering

Contact this candidate