Kalpana Chamarti

908-***-****

acoyyq@r.postjobfree.com

Summary: Informatica Developer

. 7 years of experience in data warehouse projects involving UNIX/

Informatica/ Cognos and Oracle PL/SQL programming as design and

implementation strategies.

. 9 years of experience in Pro*C/C/C++/Unix/Nmake/Sablime at progressive

levels of responsibility in software design, development, testing,

software configuration management.

. Strong experience in design and implementation of ETL using Informatica

PowerCenter.

. Very good understanding & design knowledge of Data warehouse modeling,

Star/Snowflake schemas.

. Excellent interpersonal skills and a good team player with a drive to

take up new challenges in a fast paced environment with a commitment to

excel.

. Experienced in all phases of Software Development Life Cycle (SDLC).

. Extensive experience in Oracle PL/SQL programming, SQL*Plus, Database

Triggers, Packages, Cursors, Stored Procedures, Functions and management

of Schema objects. Proficiency in Data Definition and Data Manipulation

languages.

. Experience in using UNIX platform with shell scripting.

. Experience at various levels and functions in data warehousing in design,

development, testing and production, maintenance. Experience in complete

data warehousing application and client-server based business

applications.

. Strong knowledge of Data Warehousing, Data modeling, end-to-end business

intelligence solution.

. Created Informatica mappings to load data using transformations like

source qualifier, sorter, aggregator, expression, joiner, connected and

unconnected lookup, filters, sequence generator, router and Update

strategy.

. Extensive knowledge of Lookup caches and transformations.

. Expertise in building complex business rules by creating complex

mappings/ Mapplets, shortcuts, reusable transformations.

. Involved in creating folders and code migration.

. Extensive experience in supporting Informatica applications.

. Extensive experience in error handling and problem fixing in Informatica.

. Proficient in using Informatica workflow manager, workflow monitor.

. Worked with Performance tuning and identifying the bottlenecks.

. Worked with different sources like SQL Server, xml, and Flat files.

. Clear and thorough understanding of business process and workflow.

. Excellent quantitative and analytical skills.

. Good Team Player committed to customer satisfaction and quality.

Key Skills:

. Involved in all aspects of the BI process - gathering requirements from

the end users, designing standard contracts between interfaces, designing

the technical blue prints for various data mappings, coming up with data

load strategies while incorporating data cleaning solutions whenever

possible, developing and implementing actual solutions, performing the

unit testing, integration testing, regression testing (as needed) and UAT

in development and QA environments

. As a liaison between the business and the IT Team, was involved

identifying core requirements and used the business domain knowledge on

design, test and implementation of ETL process and final reports

. Experienced in working with the DBA team in designing data marts and

enhancing existing Data repositories

. Experienced in using all the PowerCenter transformations in the designer,

and used the debugger extensively for troubleshooting mappings

. Designed sessions, event wait/raise, assignment, e-mail, and command

tasks in the Workflow Manager

. Involvement in performance tuning of Informatica sessions, by identifying

the bottlenecks at various places, applying proper techniques (reviewing

the data/ index cache sizes, buffer sizes, optimizing source/ lookup

queries) and comparing results against production through put.

. Extensively used SQL*Loader, Stored Procedures, Functions, Packages,

Triggers, Joins, Cursors, aliases, Sequences, etc while working with

Oracle

. Experienced in coding complex database queries to produce adhoc reports

for business users.

. Strong understanding in writing UNIX/ LINUX shell scripts to handle data/

scheduling anomalies.

. Debugging various production issues and providing production support.

. Experienced in making appropriate documentation and providing knowledge

base support documents

Technical Skills:

ETL Tools: Informatica 9.1 and prior

OLAP tools: Cognos (Impromptu/ Power play/ Report Net), OBIEE

RDBMS: Oracle 11g & prior, DB2 UDB, Sqlserver 2000/ 2005

Languages: SQL, PL/SQL, Shell Programming, C, Pro*C, C++, Java

OS: HP-UNIX, LINUX, Sun Solaris, Windows servers

Tools: Erwin, MS-Word, MS-Excel, MS-PowerPoint, Nmake,

Sablime

Education:

M S Computer Science, NJ

B. Tech Electronics, India

Visa Status: U.S.Citizen

Work Experience:

NYC Dept. of Finance, New York City March 14 -

Present

ETL Developer

New York City's Department of Finance (DOF transformative initiative,

known as the Citywide Payments & Receivables Repository (CPRR) Program

makes the entire payment process easier for any individual or entity

making payment to the City and optimize the City's management of the full

life cycle of accounts receivable, from origination through to

settlement. This project requires the integration of the agency system

with the CPRR, in order for the agency to be able to send receivables to

the CPRR and for the agency to receive payments through the CPRR against

those receivables, as well as for retail transactions. Finally, CPRR

provides an interface to the City's Financial Management System (FMS) in

order to report the revenue collected by CPRR on behalf of the agency.

My Role

. Member of an ETL Team to build new Data Mart and load the same to

Reports.

. Built complex Informatica processes to generate CSV output files and

designed UNIX Scripts, and FTP the same to the destination servers .

Designed many other Data marts.

Responsibilities:

. Extracted data from Oracle, XML and flat files.

. Understood the Organization's Business Requirements.

. Worked with business analyst to gather the business requirements and

involved in weekly team meetings.

. Worked with Logical data model /Physical Data model (Star Schema)

. Developed complex mappings using Informatica power center designer to

transform and load data from source systems like Oracle, XML, flat files

to loading Oracle target to the database.

. Worked on Slowly Changing dimensions.

. Have a Good Experience on Performance Tuning.

. Extensively used various types of transformations such as Expressions,

Aggregator, Joiner, Filter, Update strategy, lookup (connected and

unconnected) to load the data.

Environment: Informatica Power Center 9.1, Oracle 11g, PLSQL, Erwin 3.5,

UNIX, LINUX, Cognos 10, Project Place.

AT&T, NJ July 13 - Dec 13

ETL Developer

System XR is a business intelligence solution designed as reporting

solution for System X clients. It takes data from various sources like

orders, call volume, switch data and loads data marts. System XR also

provides reporting for wireline, U-verse and DirectTV orders.

My Role

. Involved in developing the conceptual, logical and physical data model

and used star schema in designing the data mart

. Translated the Business rules into ETL Processes that load the repository

for Metadata management.

. Performed thorough analysis of data and worked on enhancements and

troubleshooting processes.

. Provided production support of the nightly batch.

. Designed processes to load data for System XR.

Responsibilities:

. Installed and configured Informatica Power Center and Informatica Client

tools.

. Worked on performance tuning on both Informatica and Oracle.

. Monitored the workflows, reported errors, analyzed the session logs to

determine the slowing factors for the processes.

. Worked on migration of Informatica 8.1.1 to 9.5 version.

. Worked on shell scripting to aid with the Informatica workflows.

. Extracted the data from Oracle, Flat files into data warehouse.

. Worked with different transformations like source analyzer, lookup

filters.

. Created session, batches and scheduled it.

. Created User, folders and User groups.

. Created various mappings using designer that include source qualifier,

Expression, Aggregator, and Lookup Transformations.

Environment: Informatica Power Center 9.5, MicroStrategy, Oracle 11g, Toad,

UNIX, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.5

BMW North America, NJ Oct 11 - July 13

BI Resource

Project: KPI - Key Performance Indicators

The BMW Dealerships are rated for their performance on various measures.

The idea of this project is to show their growth in the last 12 - 13 months

YTD, and project their best approaches for better business. There is a

constant need for upgrading the calculations for these reports with the

ever changing market. These monthly/yearly reports were generated using

Informatica.

My Role

. Part of an ETL Team to build new Leads Data Mart and load the same to

extract KPI Reports

. Built complex Informatica processes to generate CSV output files and

designed JCL's/ UNIX Scripts to handle the scheduling for the jobs, and

FTP the same to the destination servers for 4 KPI's.

. Designed many other Data marts and KPI's.

Responsibilities:

. Extracted data from Db2, Sqlserver, xml, flat files.

. Understood the Organization Business Requirements.

. Worked with business analyst to gather the business requirements and

involved in weekly team meetings.

. Worked with Logical data model /Physical Data model (Star Schema)

. Developed complex mappings using Informatica power center designer to

transform and load data from various source systems like flat files, Db2,

Sqlserver and loading Oracle target to the database.

. Worked on Slowly Changing dimensions.

. Have a Good Experience on Performance Tuning.

. Extensively used various types of transformations such as Expressions,

Aggregator, Joiner, Filter, Update strategy, lookup (connected and

unconnected) to load the data.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2, SQL SERVER '00/

'05, SQL, PLSQL, Erwin 3.5, UNIX, LINUX, Cognos 10, Project Place, MS VISIO

Dow Jones, NJ Jan 10 - Aug

11

ETL developer

Project: CIDW - Customer Intelligence Data Warehouse

The CIDW warehouse is the solution for analysis and integration of the

Print Edition and Online Wall Street Journal (WSJ.COM) customer data. It

contains subscribers, non-subscribers and prospects related information.

CIDW extracts data from various source databases. The project is concerned

with extraction of such data from various sources and loading them in a

consistent and integrated database using Informatica as the ETL tool.

Marketing and Advertising departments use the data in CIDW for campaigns,

behavioral targeting and other marketing programs such as consumer

retention and market events. CIDW also serves as the source from which

several systems extract valuable data in order to perform various analysis

functions and reporting related to demographics and help target marketing

and promotion campaigns (e.g., direct mailings, e-mail).

My Role

. Involved in developing the conceptual, logical and physical data model

and used star schema in designing the data mart

. Translated the Business rules into ETL Processes that load the repository

for Metadata management.

. Performed thorough analysis of data and worked on enhancements and

troubleshooting processes

. Provided production support of the nightly batch.

. Designed processes to load data for MYWSJ.COM; personalized consumer

application for WSJ.COM.

Responsibilities:

. Installed and configured Informatica Power Center and Informatica Client

tools.

. Extracted the data from Sql server, Flat files into data warehouse.

. Worked with different transformations like source analyzer, lookup

filters.

. Created session, batches and scheduled it.

. Created User, folders and User groups.

. Created various mappings using designer that include source qualifier,

Expression, Aggregator, and Lookup Transformations.

Environment: Informatica Power Center 8.6, Cognos (Impromptu/ PowerPlay/

ReportNet), Oracle 8i/9i, UNIX, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.5

Alticor, MI Jun 08 - Dec

09

Informatica Developer

Alticor is a global company offering products and manufacturing and

logistics services in more than 80 countries and territories world-wide.

Through its subsidies and affiliates, Alticor owns or manages manufacturing

and distribution facilities throughout the world. The Application for

which we have worked was AMD; AMD is the second largest chip producer

company in the world. We develop the data mart to process and store all the

employees' information in a single database. Finally, doing the potential

transformations of the data to the Oracle data mart.

Responsibilities:

. Collaborated with business analysts and DBA for requirement gathering,

business analysis and designing of data marts.

. Worked on dimensional modeling to design and develop star schema,

identifying fact and dimension tables for providing a unified view to

ensure consistent decision making.

. Worked with heterogeneous sources from various channels like Flat files,

Sql Server.

. Worked on Workflow and Session Level Grid.

. Configured and Installed Informatica Power Center

. Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping

Designer, Workflow Manager, Workflow Monitor and Repository Manager.

. Extensively used transformations like Aggregator, Expression, Router,

Filter, Lookup, Sequence Generator, and Update Strategy.

. Analyzed session log files in case of session failed to resolve errors in

mapping or session configuration.

. Performed Unit testing and verified the data.

. Modified some of the existing reports fixing some of the issues related

to performance and data quality etc., during production support.

. Worked on Performance Testing, Unit Testing.

Environment: Informatica 8.6, OBIEE 10g, Flat files, XML, Oracle 9i/10g,

Windows NT.

Best Buy, Minneapolis May 06 - May

08

Informatica Developer

Best Buy co., Inc is North America's number one specialty retailer of

consumer electronics, personal computers, entertainment software and

appliances. Successfully developed and maintained ETL maps to extract,

transform and load data from various data sources to the enterprise data

warehouse called PMS (Product Management System). The data warehouse

contained information regarding sales data, purchase data, valued customer

information, employee information. This helps to make decisions for new

product improvements, analysis of existing product and improve customer

service.

Responsibilities:

. Installed and configured Informatica Power Center and Informatica Client

tools.

. Extracted the data from Sql server, DB2, Flat files into data warehouse.

. Working with different transformations like source analyzer, lookup

filters.

. Created session, batches and scheduled it.

. Created various mappings using designer that include source qualifier,

Expression, Aggregator, and Lookup Transformations.

Environment: Informatica Power center, Sql Server, Oracle, Windows NT, Flat

files.

LMS System, VA Apr 05 - Apr 06

PL/SQL Application Developer

Project: Learning Management System

LMS is a nothing but Learning Management System, which provides a base for

students to get connected to various courses from the course providers. The

system is being developed for National Education Foundation, which is one

of the leading providers of distance learning in the US. The current LMS

system, which is based on C++/Windows, is replaced with .NET framework and

Oracle Database and multi-tier architecture. Students login to the system,

can take over 2000 courses online. The system is currently scaled to handle

5000 simultaneous users. The administrators can form courseware, add new

courses, remove courses, add a student, allocate courses to the students

etc. etc. The system also provides grade generating tools and reports. Used

SQL to define and manipulate database tables.

. Wrote database PL/SQL triggers and procedures to provide backend security

and data consistency.

. Gathered requirements on the project.

. Performed technical and functional reviews.

. Designed and developed database tables, procedures, functions, packages,

triggers to meet business requirements.

. Developed some PL/SQL scripts that will change the server data across all

components in the system.

. Supported installation and configuration of Oracle 10g/9i.

. Performed code reviews on the procedures and triggers.

. Developed stored procedures and complex packages.

Environment: Oracle 9i, UNIX, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.5

AT&T Bell Labs, AT&T, Somerset, NJ Jun 93

- Aug 02

Member of Technical Staff - 1

Involved in the development and maintenance of the Global Transaction

Network Support System (GSS). Used Pro*C /C++/Shell for the application

development. GSS involves supporting AT&T's worldwide 800 classic and prime

services. It is a client/server system that provides provisioning and

maintenance capabilities for the advanced 800 service work centers,

downloads customers' routing plans into the network and gives external

customers update capabilities to make real time changes to their 800

services and routing plans. Performed Configuration Management and did load

building using Nmake.

Responsibilities:

. Followed application development life cycle procedure in Pro*C to

complete various feature requirements including designing, documenting,

developing, reviewing, testing and installing the changes.

. Created common library functions using C and Embedded SQL to be used

across different applications.

. Developed and maintained Scheduler tool that generates reports for the

GSS periodically. The report generator tool generated various reports

every night through Cron jobs that produced a specific formatted report

for a particular account based on database validations and feature

requirements of the system.

. Participated in the design and implementation of customer user interfaces

for AT&T Work center to monitor the transaction data of the systems on

SUN workstation and PC.

. Analyzed and worked on physical design, code implementation and test

cases to provide the management team with the performance improvement of

the GSS system.

. Wrote design documents and library functions for the application.

. Used SQL*Plus and PL/SQL of Oracle to retrieve and manipulate the system

data on the database.

. Scheduled and conducted design and code reviews.

. Provided technical support to integration and system test teams.

. Implemented functions for GSS to construct, maintain, and load all

processing logic on the AT&T Network for real-time routing, retrieval and

billing.

. Was incharge for the whole project to keep track of the version changes

using Sablime and building loads for Integration Testing, System Testing

and Production.

Environment: HP-UX 10.20, Oracle 7.3.4, Pro*C, C, C++, Shell Programming,

PL/SQL

Contact this candidate