Manager Data

Vanaja Eppanapalli

Phone: 510-***-****

*.******@*****.***

____________________________________________________________________________

_________________

SUMMARY:

* 7+ years of experience in Analysis, Design. Development,

Implementation and Testing of Data Warehousing Applications and

Business Intelligence reporting tools in industries with Financial and

Health Care Domains.

* Extensive experience in Data mining and relational Database design,

documentation and implementation.

* Experience in diversified fields in Data Warehousing. Worked on

various projects involving Data warehousing using Informatica Power

Center 8.x, 9.x (Source Analyzer, Warehouse Designer, Transformation

Developer, Mapplet and Mapping Designers, Task Developer, Workflow &

Worklet Designers, Repository Manager, Designer, Workflow/Server

manager, Workflow Monitor)

* Extensively used Hyperion Essbase for overall architecture and

strategy for the deployment.

* Experience with Hyperion Essbase utilizing with EAS, MaxL and Calc

scripts.

* Experience in preparation of Functional Specification Document based

on the Business requirements.

. Experience in diversified fields in Data Warehousing.

. Strong knowledge of analytical tools/techniques (Excel, Access,

Teradata, Hyperion Essbase, OBIEE, plsql, Oracle, RDBMS)

. Designing data models using ERWin.

. Extensively used Toad, SQL Navigator, and SQL*Loader.

. Excellent analytical and problem solving skills in large environments

. Good oral and written communication and inter personal skills and

ability to work in a team environment

EDUCATION:

. Master of Business Administration

TECHNICAL SKILLS:

Hyperion Essbase (BSO & ASO) and security

ETL Tools Informatica 8.x/9.x,

Dashboards & Answers

OBIEE/Siebel Analytics

Oracle 9i/10g, PL/Sql

Toad, Erwin, SQL *plus, Sql * Loader

Unix and Shell scripting

WORK EXPERIENCE:

Kaiser Permanente, Pasadena, CA

Nov' 08 -Till Date

ETL/Essbase Developer

Project : Kaiser Permanente Individual and Families Plans (KPIF)

Kaiser Permanente is a leading non-profit Health Insurance organization

rendering its services in CA, NW, CO, HI, OH and GA regions.

Responsibilities :

. Involved in the Design, Development, Testing phases of the Data

warehouse

. Formalization of user requirements and creation the formal subject

area description based on functional sets and binary adjacency

matrixes, functional specs and technical specs, metadata for the data

warehouse, database naming convention and PL/SQL coding convention

using Microsoft Word, Excel.

. Involved in Developing ETL Strategy using PL/ SQL.

. Logical database modeling using Erwin including definition of business

entities and their relationships.

. Worked on Source to Target Mappings and Design Documents.

. Worked extensively on Power Center client tools such as Source

Analyzer, Data warehouse designer, Transformation developer, Mapplet

designer and Mapping Designer.

. Created Mappings using Mapping Designer to load the data from various

sources, using different transformations like Unconnected and

Connected lookups, Router, Aggregator, Joiner, Stored Procedure,

Update Strategy for Daily Load.

. Expert level experience in all areas of Essbase such as outline

design, member formula, Calc script, Business Rules, MaxL Script,

Report script, Load rules, ASO and BSO storage

. Experience with logical cube design and physical deployment of cubes

. Well versed in cube optimization techniques to maximize performance

and minimize memory requirements

. SQL skills to load data into cubes

. Responsible for overall architecture and strategy for the deployment

of Essbase ( system 11)

. Established standards for the technology including identification of

appropriate uses

Environment: Hyperion Essbase 11.x, Informatica 9.6, Oracle10g, Windows,

Unix, Unix shell scripts and TOAD.

Union Bank, San Francisco, CA

May' 07 - Oct' 08

ETL Developer

Project: Enterprise Mortgage Data Warehouse (EMDW)

The primary objective of Enterprise Mortgage Data Warehouse (EMDW) was to

enable management, marketing and remittance collection teams to obtain

information about the loan products and analyze the various metrics and

understand the performance of the organization. The data used for

generating reports was sourced from Oracle and flat files using Informatica

Power Center. The reports were generated and delivered to users using

Siebel Analytics. Budgeting, marketing and forecasting decisions are based

on the reports produced using EMDW.

Responsibilities:

. Analyzed source data and gathered requirements from the business

users.

. Worked on Informatica's tools - Source Analyzer, Warehouse Designer,

Mapping Designer, Workflow Manager and Workflow Monitor.

. Various kinds of transformations were used to implement simple and

complex business logic. The mappings involved extensive use of

transformations like Filter, Router, Expression, and Union.

. Developed, tested Store procedures, Functions and packages in PL/SQL

for Data ETL.

. Involved in SQL & PL/SQL programming for procedures, functions,

packages to extract data from various source systems.

. Used Lookup Transformation to access data from tables, which are not

the source for mapping.

. Build Session, Worklets/Workflow, Create/Modify Parameter File.

. Extensively worked with flat files and excel sheet data sources. Wrote

batch scripts to automate flat file transportation local to

Informatica server.

. Implemented Slowly Changing Dimensions - Type I & II in different

mappings as per the requirements.

. Provided detailed analysis of data issues, mapping data from source to

target for ETL, design and data cleansing on the Enterprise Data

Warehouse.

. Participated in weekly end user meetings to discuss Data Quality,

performance issues and ways to improve data accuracy and new

requirements etc.

. Worked with Siebel Analytics Developer to create Repository with

Siebel Analytics Admin tool.

. Setting up Delivers to configure iBots based on the threshold value to

the users.

. Worked extensively in Siebel Answers and Dashboards.

. Created and granted privileges for the users using Analytics Catalog

Manager.

. Creating and modifying RPD (Physical, Business model & mapping and

presentation layer) using Siebel analytics administration tool

. Involved in SQL & PL/SQL programming for procedures, functions,

packages to extract data from various source systems.

. Generated the SQL and PL/SQL queries using TOAD tool.

. Optimized queries using TKPROF, Explain Plan, providing hints,

analyzing tables, adding necessary Indexes on tables.

. Generated Unix shell scripts to automate the ETL process.

Environment: Informatica, Siebel Analytics, Oracle 9i/10g, PL/SQL,

SQL*Plus, SQL*Loader, Unix shell scripts, ERWin

Fujitsu Ltd, Sunnyvale, CA

Nov' 05 to May' 07

Data Warehouse Developer

Project: TRUSTEDANSWER.COM

Trustedanswer.com provides customer support to web sites on 24*7 basis. It

provides all aspects of support from traditional phone-based support to web-

based self-service, with special expertise in building and deploying

knowledge base technology with graphically rich knowledge articles as the

basis for all our solutions.

Responsibilities:

. Involved in the Design, Development, Testing phases of Data warehouse

. Analysis, Requirements gathering, function/technical specification,

development, deploying and testing.

. Involved in Design and Data Modeling using Star schema.

. Logical & Physical Database Layout Design using Erwin.

. Involved in fixing invalid mappings, testing of store procedures and

functions, unit and integration testing of Informatica Mappings,

Sessions, Workflows and the target data.

. Created Informatica mappings for initial load and daily updates.

. Developed several mappings to load data from multiple sources to data

warehouse.

. Developed, tested Store procedures, Functions and packages in PL/SQL

for Data ETL

. Performed Data conversions.

. Involved in troubleshooting the load failure cases, including database

problems.

. Tuning of Informatica mappings.

Environment: Informatica 6.2/5.1 (Power Mart/Power Center), Siebel

Analytics, Oracle 9i, Windows XP, TOAD and Erwin.

Blue Dart Express-DHL India Ltd., Hyderabad, India

Sep' 04 to Oct' 05

Database Developer

Worked on the C4 Roads shipment application. The application receives

messages from various applications regarding shipment and processes every

message to generate alerts for the staff and admins.

Responsibilities:

. Involved in Analysis, design and development and testing phase of

application.

. Extensively worked in writing SQL Queries (Sub queries and Join

conditions, correlated sub queries),

. Wrote Stored Procedures, Functions, Packages, Fixed Income etc. in

SQL*Plus.

. Development and Testing of advanced SQL and dynamic PL/SQL code tuning

based code in support of Reports.

. Written many database triggers for automatic updating the tables.

. Optimization and Performance Tuning of SQL queries using indexes.

. Developed shell scripts for job scheduling

. Developed Unix Shell scripts for job scheduling.

. Involved in performing code and unit testing for complex scope modules

and projects.

Environment: Oracle 9i, SQL, PL/SQL, UNIX, SQL* Loader, TOAD, Windows 2000,

SQL*PLUS.

ICICI Bank, Mumbai, India

May' 03 to Aug' 04 Database Developer

The requirement was to develop an integrated banking maintenance system

capable of generating fixed deposit receipts, duplicate fixed deposit

receipts, interest warrant receipts, premature withdrawal receipts,

maturity receipts and monthly statements.

Responsibilities:

. Involved in preparing documentation and user support documents.

. Wrote packages, triggers, stored procedure and functions for the

registration, billing, shipping and promotions.

. Created database triggers for automatic updating of the tables.

. Worked on optimizing existing procedures and functions using PL/SQL.

. Developed the UNIX shell scripts to send the monthly invoice through

email retrieved from database.

. Generated monthly sales report for managers review using SQL*PLUS

report. Performed System testing and monitor the efficiency of the

program.

Environment: Oracle 8i, PL/SQL, SQL *plus, Toad, UNIX, SQL Loader and

Windows NT.

Contact this candidate