Data Warehouse

AMALA CHUNDURI

(P HONE ) 512-***-**** (E MAIL ) A MALA _ CHUNDURI @ HOTMAIL . COM

PROFILE

Business Intelligence Professional with experience in data warehousing, data analysis, and data

modeling.

Experienced in designing and developing transformations, mappings and sessions in Informatica to

extract and load target data marts.

Highly adept at client interactions.

Extensive experience in all phases of data warehouse development lifecycle from gathering business

requirements, creating data models, to designing business intelligence functionality.

Good knowledge in dimensional modeling, star-join schema modeling, and snow-flake modeling.

Proficiency in performing various ETL operational activities including capturing changed data,

monitoring jobs, troubleshooting, and analyzing data.

Adeptness in tuning complicated Oracle SQL and PL/SQL procedures using Explain Plan to analyze

SQL statements.

Highly knowledgeable in improving queries response time using various Oracle utilities such as

Materialized Views, Indexes.

Specialization in developing documentations, standards, and procedures for operating and administering

the data warehouse environment to ensure the security, integrity, and availability of data.

Permanent resident of the United States of America.

TECHNICAL SKILLS

Dataware Housing Tools: Informatica Powermart, Informatica PowerCenter 7.1.4/8.6, OBIEE, BO XI R3

(completed training)

Databases: Oracle 10G, DB2 8.0, SQL Server 2000

Operating Systems: Linux, Unix, Windows XP

Application Packages: SubVersion, Visual Source Safe 6.0

Tools: Visual Interdev 6.0, Tivoli Maestro

PROFESSIONAL EXPERIENCE

TOPPAN PHOTOMASK INC, Round Rock, TX 2006-2008

Maintained and enhanced the primary warehouse application for the organization. Worked as the subject matter

expert on the organization’s warehouse.

Development/Maintenance

Upgraded Informatica V7.1.4 to V 8.6. Performed this upgrade with minimal DBA support.

Performed most of the Informatica administration tasks independently.

2

AMALA CHUNDURI

Maintained and enhanced almost 600 Informatica mappings and sessions.

Developed Unix shell scripts and Oracle database packages, procedures and PL/SQL scripts.

Created an innovative interface to load data tables, using Informatica’s UDO (Unstructured Data

Object) feature.

Created scripts, to perform data profiling, on the data warehouse tables.

Enhanced quality of the data coming from the sources by performing data cleansing.

Performance tuning of sessions. Brought down the time of workflow from 2 hr to 25 mins.

Business User Support

Interfaced with senior members of the business community to gather requirements and implement

enhancements.

Training/Mentoring

Led a team of developers in the course of the activities described above. Trained and mentored them

to be independent in their role.

Created an offshore team and ensured that development was made possible at a lower cost.

IBM BUSINESS CONSULTING SERVICES, Austin, TX 2004-2006

Analyzed, designed, architected, and tested datawarehouses for multiple clients. Informatica was used as the

primary tool of development. Worked as a Advisory IT Specialist/Architect in the CRM-Financial Services,

Marketing and Customer Intelligence Practice of IBM Global Services. Clients were major financial institutions

(banks and insurance firms). Worked on couple of products and claims processing

Data modeling

Performed requirements analysis by interviewing client team members.

Gained understanding of the Insurance Information Warehouse (IIW) data model.

Performed data modeling tasks in order to model the client’s requirements into the existing IIW

framework.

Data analysis

Created scripts, to perform data profiling, on the data warehouse tables.

Enhanced quality of the data coming from the sources by performing data cleansing.

ETL design and development

Designed numerous mappings as proof of concept for loading the data from XML and mainframe

binary files into the staging database.

Developed the transformations using Informatica.

Off shoring

Coordinated with a team of developers in India since clients wanted to explore low cost options.

3

AMALA CHUNDURI

Reviewed the work products of the team in India and provided feedback.

Implementation Lifecycle experience.

Worked on a team that designed the ETL solution architecture. Assisted in analysis, macro and

micro design of the warehouse.

Conducted architecture review sessions, by involving key members from the client and IBM.

Designed, implemented and tested numerous Informatica mappings.

Created test strategies and test templates for Unit testing of end-to-end architecture.

Participated in the System testing and defect fixing.

Performed data quality fixes for production data.

WIPRO TECHNOLOGIES, Bangalore, India 2002-2003

The client was Medtronic (www.medtronic.com). The project was Performance Tuning and Support. The

technical environment was Informatica Power Mart 5.1, Business Objects 5i, Tivoli Maestro, Oracle 8

In the Medtronic data warehouse the source data from an AS/400 file in one of the JDE distribution systems is

sourced into the Staging data store via Oracle/AS400 gateway. Cleansed data is loaded into the Operating data

store using PL/SQL procedures. The data from the operating stage area is extracted, transformed and loaded into

different data marts using procedures and Informatica Power Center 5.1 mappings.

Designed and developed transformations, mappings and sessions in Informatica to load target data

marts.

Enhanced the existing mappings made adaptive changes to the data warehouse environment to meet

the changes in the source system, due to business requirements and product upgrades.

Monitored and supported the data warehouse production environment on a day-to-day basis.

Investigated problems and performed troubleshooting of production problems.

Created scripts in Unix Shell commands to schedule jobs in Tivoli Maestro and maintained the

sessions and batches at required frequency.

Optimized and fine tuned mappings for better performance and efficiency.

Created and executed sessions and batches using Informatica Server Manager.

PATNI COMPUTER SYSTEMS LTD., Mumbai, India 2000-2002

The client was GECTIP project link and the project was production support, and performance tuning. The

environment was Informatica Power Center 6.0, Oracle 8.0, Business Objects 5i

The data warehouse of GECTIP has data flowing from its OLTP systems like Seibel, Oracle Financials and web

applications. The data is extracted, transformed and loaded into the data warehouse using PL-SQL procedures

and Informatica mappings.

Designed extract and load routines for Dimension and fact tables. Created and enhanced mappings

and mapplets in Informatica for extraction, transformation and loading of data. Implemented PL-

SQL procedures in Informatica. Created sessions and batches, thus scheduling extract and load

routines.

Performed performance tuning of session and SQL optimizations. Responsible for source system

analysis, data transformation, loading, quality control of the Informatica mappings, validation for

data marts, operational data store and data warehouse.

Modified and enhanced the existing Business Objects Universe for the redesigned data marts.

Preparing Specification Documents for the Redesign of the user changes to the mappings and

Universes.

4

AMALA CHUNDURI

Created XML targets with multiple groups in the user required hierarchical format so that the data

could be viewed in parent child expandable and collapsible manner on the browser.

Worked closely with the end users and decision makers to develop the transformation logic to meet

business requirements.

The client was Systech System and the project was the development of a web application. The environment was

HTML, ASP, VBScript, Java Script, IIS4.0, OBDIITouchNet System is a Vehicle Exhaust Gas Analyzer System,

which is used for inspection of vehicles in Texas Vehicle Emission Testing Program.

Designed the technical architecture, and end-to-end solution of the complete web application.

Defined strategies for requirement gathering, analysis and estimate preparation, and project

management

Created the functional and design document and data flow diagrams with Visio. Created prototypes,

web pages using ASP and VB Script .

Created test cases for integration testing, testing and debugging.

Performed overall functional support for all the different modules.

The client was Farm Express and the project was the development of a web application. The environment was

HTML, ASP, VBScript, Java Script, IIS4.0 .Farm Express is an UK based company, which has developed a

vertical portal to provide e-commerce facility to the farmers across UK.

Perfomed requirement analysis for the assigned modules and prepared effort estimates for the

creation and delivery of the web pages.

Created ASP pages. Created SQL Server Objects (extensive use of stored procedures). Designed

and implemented unit and integration test cases. Performed manipulation of XML files.

E D U C AT I O N

Masters, Computer Management, Devi Ahilya University of Indore, India.

Post Graduate Diploma, Information Technology and Management, All India Mgmt. Association, New Delhi,

India.

BE, Electronics and Telecommunication, Govt. College of Engg. Aurangabad, Maharashtra, India.

Contact this candidate