Project Developer

Chandini L.J.

[pic]

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

Address: **** * ********* **, ***-2D, Peoria, Illinois-61615

Phone: 269-***-****

Experience Summary

. Having 3.2 years of experience in Data Warehousing, working on the

tool Acsential (IBM) DataStage 7.5.2

. Worked as Design Lead in Wipro Technologies from July-2008 to Apr-

2009.

. Worked as Team Member for Tata Consultancy Services from Feb-2006 to

July-2008

. Always provided the good and high quality deliverables within the

Project deadlines.

. Possess high analyzing and Problem Solving skills.

. Provided alternative solutions for the low performance Jobs.

. Excellent written and verbal communication skills.

. Received appreciation for good interaction with the clients and

solving the Issues.

. Co-Authored a White Paper on "24x7 Availability of Data in Decision

Support Systems."

Career Profile

Dates Organization Role

February-2006 to TATA Consultancy Developer

July-2008 Services

July-2008 to Apr-2009 Wipro Technologies Developer/Design

Lead

Technology

Below is a list of important hardware, software products, tools that I

have worked with.

. Operating Systems - Windows XP/2000, UNIX

. Software Products - SQL,C, C++, Core Java, Shell Scripts, Oracle

8i/9i/10i/11g

. Tools - Acsential (IBM) Datastage 7.5.2, PL/SQL Developer, TOAD

Qualifications

Degree and Date Institute Major and

Specialization

Bachelor's of Visvesvaraya Information Science

Engineering Technological University

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date

Certified

1z0-007 Introduction to Oracle9i: SQL 12/06/2007

1z0-147 Program with Pl/Sql 02/11/2010

Project Thesis

Project - Freight Audit Processing, Order Vehicle Visibility(FAP-OVV) Aug-

2008 to Apr-2009 (WIPRO)

Highlights - Provided alternate solutions for the complex and low

performance Jobs.

Customer - General Motors

Role - Design Lead/Developer

Description - OVV(Order Vehicle Visibility)

. Design a Global Track and Trace, Ocean visibility system for the GM

Outbound Vehicle

FAP(Freight Audit Processing)

. Design a stable, reliable IT system that will be the basis for a GM

global, common freight auditing system.

. Provide key reporting capabilities for GM logistics business users

ETL Design and Implementation was involved in the following

areas

. I2(Source) to ODS interface

. ODS to DW Interface

. DW to OVV/FAP Datamart

Project - Period End Rate Change (PERC)

Dec-2007 to Feb-2008 (TCS)

Highlights - (i) Coordination with various users of Downstream Systems

for Impact Analysis

(ii) Participated in Impact analysis on various

downstream systems for the Changes in the Source

Role - Developer

Customer - The Consulting Firm

Description - This project work is to provide analysis and recommendation,

ramifications, of changing the end of period rate(currency conversion

rates) before the month-end closing, instead of using the constant value

uploaded at the beginning of the month, so that the translated

asset/liability balances reflect the actual exchange rates prevailing at

period end.

Responsibilities - (i) Involved in requirements Gathering, Impact Analysis,

Data Analysis

(ii) Involved in creation of Functional and

Technical Specs

(iii) Coordinating with the owners of ODS

Downstream Systems

(iv) Estimating Efforts

(vi) Development, Unit Testing, System

Testing

(vii) Business Induction to QA and Reporting

Team

Project - SAIL Datawarehouse Production Support Sep-2006 to

Nov-2007 (TCS)

Mar-2008 to June-

2008(TCS)

Highlights - i. Client Manager recognised to lead the team.

ii. Co-Authored the TACTiCS Paper on "24x7 Availability

of Data in Decision Support Systems."

Role - Support, Team Lead

Customer - The Consulting Firm

Description - SAIL is the Consulting Firm's Data Warehouse. It is a copy of

transaction data structured for querying and analysis. SAIL aims to be the

Firm Standard data source for data analysis through the implementation of

an enterprise data warehouse strategy in a phased manner. The data

warehouse is targeted to bring high quality, consistent and cross

functional data into a single repository providing strategic benefits to

the Firm. The Data Warehouse houses the data of Financials, People, and

Recruitment.

Project - Engagements Economic Reporting (EER) Apr-2006 to

Sep-2006(TCS)

Highlights - Received Client Appreciation Certificate

Role - Developer

Customer - The Consulting Firm

Description - Consulting assignments are called as Engagements. Several

Firm's offices need to monitor the Engagement

economics during the course of the Engagement. This process gives a chance

to correct the situation before the engagement is finished by adjusting

billing, staffing or scope.

There was no simple and automated way of combining the information in

existing systems and generate a projected economic outcome of an engagement

and information from several sources/systems/reports needs to be manually

combined to achieve the same.

EER is envisioned as a solution to all of the above pain areas. EER reports

are designed to combine information from multiple sources:

. Project Accounting for project to date data

. PeopleNet for projected staffing data and

. CER Online for projected billings and expenses.

EER provides offices with timely, accurate and complete information, which

assists in better management of their engagements, which will reduce

engagement overruns and revenue write-offs.

Key Skills

. Well versed with the concepts of Data Warehousing for the Financial

Domain.

. Good Knowledge of Operational Data Store and Staging used for

different Datawarehouse Requirements.

. Exposure to Dimensional Modelling.

. Extensively worked on Server Jobs, Parallel Jobs, Batch Jobs and

Sequencers of Data stage.

. Provided solutions for Automating the Creation of partitions on the

tables through Data stage Jobs.

. Knowledge on scheduling and running the jobs through crons, using the

UNIX shell Scripts.

. Capable of coding the Shell Scripts, that can be called through Batch

Jobs to achieve the requirements of the Project.

. Possess highly efficient analytical skills - Received client

appreciations for the same.

. Excellent Problem solving skills - Provided alternate solutions for

short term/long term fixes for Production Issues.

. Good Team working skills - Provide support and help to the team

members for procuring better productivity while allowing everybody to

express their visions.

. Good Leadership Skills - Clients identified my potential to become the

Teach lead for the Team.

. Provided Trainings on Datawarehouse Basic Concepts, Sql Concepts and

Datastage to the New Joiners.

Contact this candidate