Project System

Objective:

To pursue a career in the field of IT, fulfilling increasing

responsibilities, continually acquiring new skills and constantly working

towards meeting the corporation's goals as well as individual growth.

Summary

. Have more than six years of experience in Software Development.

. Have four years of experience in Data stage 7.5.

. Hands on experience in Data warehousing using Data stage (Server &

Parallel Extender).

. Excellent knowledge in Data Warehousing Concepts.

. Have around 6 years of experience in PL/SQL programming.

. Proficient in Design and performance tuning of database applications

and ETL jobs.

. Excellent leadership and communication skills.

. Exposure to playing Client facing roles in various projects.

. Also have hands on experience in ETL & Reporting tools like

Informatica PowerCenter 7.1, Sunopsis V3, Crystal Reports XI.

Employment Profile

Organization Name Designation Duration

IBM India Private Ltd. Senior System Engineer July 2008 - July 2009

Mindtree Ltd Associate Consultant September 2004 - July

2008

Datacons Private Ltd. Programmer Analyst November 2003 - September

2004

Kirloskar Electric Programmer Analyst November 2003- February

Company Ltd. 2003

Recent Accomplishments - IBM India Private Ltd.

Project: Kasikorn Bank -DataWarehouse Migration

Duration: July 2008 - July 2009

Client: Kasikorn Bank, Thailand

Role: ETL Senior Developer

Description:

The Kasikorn Bank is one of the leading banks in Thailand providing a Wide

Range customer - driven banking services. The DWH-Migration project will

consist of following large categories of work:

. To extend and implement a common database repository (EDW) that will

store the entire bank's information. Both development and production

environments will be upgraded with the latest version of tools.

. To Migrate historical data from existing Oracle DWH to DB2 EDW. The

one-time history load will include 3 calendar years of financial data.

. Create interfaces, where do not exist, to re-direct the source data

feeds from DWH to EDW based on the frequencies.

. Create extracts from EDW tables for loading the external downstream

systems.

Responsibilities

. Analyzing and understanding business requirements.

. Provide estimations for the business requirements.

. Design, Develop and Unit Test Complex ETL jobs.

. Performance tuning of ETL jobs.

. Reviewed jobs and played a module lead role.

. Mentoring team members.

Environment: Datastage Version 7.5.2, DB2 Version 8.2, UNIX

Accomplishments - Mindtree Ltd.

Project: CIT - Sales Force Automation

Duration: April 2007 - July 2008

Client: Commercial Investment Trust, NJ, US

Role: ETL Lead

Description:

Salesforce.com is the worldwide leader in on-demand customer relationship

management (CRM) services. They deliver integrated, completely customizable

enterprise applications for companies of all sizes to manage their sales,

marketing, customer service, and other critical business functions. In

sales force automation (SFA) application, various reports are developed

using BOXI, Crystal Reports XI and data is integrated using Datastage

7.5.1.

Responsibilities

. Analyzing and understanding business requirements.

. Provide Estimation for the requirements.

. Interacting with the Client for collecting the requirements and

documenting the same.

. Data Modeling and Design of Minor End to End enhancements.

. Design and Develop Complex ETL jobs.

. PL/SQL Procedures, UNIX Scripting.

. Database tuning

. Support of existing ETL jobs under three different Business units.

. Independently involved in design, develop and release.

. Develop Reports using Crystal Reports XI.

. Prepare Metrics report for each member of the team to generate the

effort and schedule variance.

. Review code of team members.

. Mentor juniors in the team.

. Worked Onsite for a period of Three months for analysis and knowledge

transition.

Environment: Datastage Version 7.5.1, Oracle 10g, BOXI, UNIX, Crystal

Reports XI, SQL Developer

Project: SAP- Scenario Testing

Duration: April 2008

Client: SAP, Bangalore

Description:

A pre-sales activity to provide a proposal to win project for Mindtree. The

project to be obtained was testing the SAP BW - Version 7 tool. The

objective of this is to study the requirements of the customer and propose

innovative solutions that Mindtree can provide in order to win the customer

and project for Mindtree.

Responsibilities:

Was involved in the presales phase of the project to gather requirements

from the client with constant client interactions and present to them an

innovative solution and approach to their requirements. Won the project for

Mindtree.

Environment: SAP BW

Project: AIG Reinsurance- eTreaty Data Migration

Duration: July 2006 - February 2007

Client: American International Group, Inc.

Role: Offshore Lead

Description:

This Project involves the Data Migration of the existing Reinsurance

Systems SRI and RDPS into the new eTreaty system. The eTreaty system will

be a new treaty reference application intended to replace and expand the

functionality of the existing SRI, Treaty Search, and RDPS treaty databases

and related applications. Data Migration involves validating the

correctness of the existing data and a one time, complete migration of the

existing Data in the two systems SRI in SQL Server and RDPS (VSAM Extracts)

into the target eTreaty systems (DB2 Version 7.2). It involves complex

Datastage jobs to migrate the existing data to the new system. This system

migrates the data and provides a detailed AUDIT Report with successful and

rejected records and their counts during migration.

Responsibilities:

. Requirements gathering phase of the project. Collating their needs by

constant Client Interactions and come up with a suitable design.

. Involved in complete Design and Development of the Data Migration

project.

. Data Modeling and database tuning for the project.

. Independently involved in the complete Data Quality Analysis of the

existing system.

. Development of Complex Datastage Jobs.

. Performance Tuning of the ETL Jobs and database.

. Assign tasks to team members.

. Review the code developed by team.

. Generate Audit Reports, prepare documents like mapping documents, design

documents etc.,

. Worked Onsite for a period of three months for Requirement gathering and

Data Quality analysis.

Environment: DB2 Version 7.2, SQL Server, Datastage Version 7.5, RUMBA

Project: IATA Central Invoicing System

Duration: September 2005 - June 2006

Client: International Air Transport Association, Geneva

Role: ETL and Oracle Senior Developer

Description:

The T2005 Program is a centralized system which integrates various

interdependent IATA projects each of them rendering different solutions to

IATA.

The Accounting Project is part of the T2005 program. The T2005 Accounting

Project has resulted from an assessment of the actual local office

practices in terms of invoices/billing the agents for the services rendered

by IATA or IATA partners, and the need to be compliant with local and

European regulatory requirements.

T2005 Accounting Project delivers the following:

- A centralized and highly automated invoice system.

- Integration and standardization of the accounting systems and practices.

- A centralized and streamlined accounting organization.

- Delivering timely, relevant and accurate financial and business

information.

- Replacing agents and third party invoices by electronic invoices.

Responsibilities:

. Independently built the data model for the system.

. Independently involved in the Design and Development of VAT Engine driven

by PL/SQL which is the heart of the application that handles the invoice

generation, Tax calculation, Currency Conversions.

. Tuning of SQL queries and database as when required.

. Independently involved in development of ETL jobs using Sunopsis V3.

Environment: PL/SQL Programming, Oracle 10g, SUNOPSIS V3, JDK 1.4, JBoss

Version 4.0.0 RC1, Version Name: Zion, JBoss Eclipse IDE Version: 3.1.0,

Client, Hibernate 2.1, Ant-contrib 0.6, Tomcat 4.1, EAP, Windows XP

Professional

Project: Prudential Prelude System

Duration: December 2004 - September 2005

Client: Prudential, Singapore

Role: Developer

Description:

Prelude is a decision support system, which will serve as the basis for the

immediate need to support profitability calculation and KPI reporting, and

also be a regional repository of organizational information in the long

term. Prelude will be the profitability analysis database required to

identify value creation in PCA funds businesses across the region that

would help in consolidation and reporting against financial and non-

financial performance metrics for all levels of management and provide

drill-down analysis of key movements.

The Prelude system provides an automated and integrated process to

extract data from a number of operational systems and data files, transform

this data into meaningful information by applying business rules and

transformation logic Allocation of KPI's across dimensions using PL/SQL is

used. Based on the diverse allocation needs across different cost centers

and the system is flexible within a given framework to handle any kind of

new allocations that may come up in the future. This is then published in

report format through a browser based application, Informatica Power

Analyzer.

Responsibilities:

. Involved in Design and Development of the Allocation Engine done for

the system using Oracle 9i, PL/SQL programming.

. Involved in building the data Modeling for the Allocation Engine.

. Development of PL-SQL procedures (Like the generic Matview refresh

Layer, used to sequentially refresh all the matviews), views,

functions and matviews.

. Involved in development of ETL jobs using Informatica PowerCenter 7.1.

Environment: PL/SQL Programming, Informatica PowerCenter 7.1, Oracle 9i,

Informatica PowerAnalyzer 4.1, Erwin 3.5.2, TOAD 7.6

Accomplishments - Datacons Private Ltd

Project: Maybank Unit Trust Berhad System

Duration: June 2004 - September 2004

Description:

MayBank Unit trust system Berhad (MUTB) is a system developed to

efficiently manage operations for Unit Trust Products. May Bank Unit Trust

system was 3-tier Architecture. Presentation Layer was developed using Java

/ JSP and XML, Java Beans / EJB Container were used for the middle tier or

Business Logic layer with BEA Web logic platform 8.1 as application server.

Finally the backend part was done using Oracle 9i (Toad 7.0). The reports

are handled using Reports 6i. The whole MUTB transaction system follows the

4 i principle as the rule engine while saving, retrieving and updating

records. This product has an end-to-end integrated solution of unit trust

operations.

Responsibilities:

. As a team member involved in coding backend PL/SQL programming

(Packages, Views, Procedures, Functions).

. Development of reports using Oracle Report 9i for the system.

Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, TOAD, UML, Web

logic platform 8.1, ORACLE 9i v2, Reports 9i, PL/SQL. Programming

Project: Public-Mutual Berhad Online Transaction Processing (PBM-OLTP)

Duration: March 2004 - June 2004

Description:

OLTP is a comprehensive Online Transaction Processing system for Fund

holder and agent to address the current business problems and convoluted

workflow procedures that revolve around the system. The new system is

designed specifically towards handling the dynamic growing of daily

transactions, efficiency in managing operations and offer better services

requirement to fund holders, agents, IUTA and products.

Responsibilities:

. As a team member involved in Development of reports using Reports 9i for

the system.

Environment: J2EE, EJB, Servlets, Java, JSP, JDBC, XML, JAXP, WebSphere

Studio 5.0, 9iAS Developer, TOAD, UML, WEB Sphere 5.0, 9iAS v2, ORACLE 9i

v2, Windows 2000, Linux Advanced server, VSS6.0, Reports 9i, PL/SQL.

Programming.

Project: Autodeal

Duration: November 2003 - March 2004

Description:

Autodeal provides facilities of automobile sales and service and caters to

the Manufacturers and Dealers. It is a complete system that takes care of a

vehicle right from presales, sales to service and housekeeping needs. This

project deals with converting the existing system to a web enabled system

using state of art technologies (Forms 9i, Reports 9i).

Responsibilities:

. As a team member involved in Development of Masters, Transactions for the

system as per the specification using Forms 9i, PL/SQL Programming and

Oracle 9i.

. Development of Reports for the system using Reports 9i and Oracle 9i.

Environment: Forms 9i, Reports 9i, Oracle9i, PL/SQL Programming, TOAD 7.0

Accomplishments - Kirloskar Electric Company Ltd

Project: Materials Management System

Duration: July 2003 - November 2003

Description:

Materials Management System is an integrated package, which provides

application for the Material Management division of the company. This

application provides a complete management of all the activities related to

Materials management. It facilitates various transactions involved in this

division, one of them being the release of Purchase Orders for the

Materials Management and Production Planning departments.

Responsibilities:

. As a team member involved in Development of Masters, Transactions for the

system as per the specification using Forms 6i, PL/SQL Programming and

Oracle 8i.

. Development of Reports for the system as per the specification using

Reports 6i and Oracle 8i.

Environment: Forms 6i, Reports 6i, PL/SQL Programming, Oracle 8i

Project: Human Resource Information System

Duration: February 2003 - July 2003

Description:

This project is modularized into three categories.

- Career Information System (CIS) module takes care of Advertising,

Recruitment and Interviews etc.

- Personal Information System (PIS) module holds the details of all the

employees.

- Training Information System (TIS) module takes care of the Training

programs that the company needs to conduct.

Responsibilities:

. As a team member involved in Development of Masters, Transactions for the

system as per the specification using Forms 6i, PL/SQL Programming and

Oracle 8i.

. Development of Reports for the system as per Reports 6i and Oracle 8i.

Environment: Forms 6i, Reports 6i, PL/SQL Programming, Oracle 8i

Educational Background

Course Institution Period GPA

Bachelor of VISVESWARAIAH TECHNOLOGICAL 1998-2002 3.8

Engineering UNIVERSITY, BELGAUM,INDIA

(E&E)

Have also obtained GNIIT Certification(3 years Course in Computer Application)

from NIIT Ltd, GPA 3.9

Technical Skills:

Languages : PL/SQL Programming, UNIX scripting,

Knowledge of C,

C++, Java, .NET, HTML

Databases : Oracle 8i, Oracle 9i, Oracle 10g, SQL

Server Version 7.0,

DB2 Version 7.2

Data Modeling Tools : ERstudio, Erwin 3.5.2

ETL Tools : Datastage 7.5, Informatica

PowerCenter 7.1, Sunopsis

V3/ODI, SCRIBE

Reporting Tools : Crystal Reports XI

User interfaces : TOAD 7.6, Forms 6i, Reports 6i (D2K),

Forms 9i, Reports 9i

Operating Systems : Windows 98/XP/NT/2000/Vista, UNIX

Domain Knowledge : Banking, Insurance, Automotive, Airline

Awards & Certificates:

. Received Thanks award from the Project Coordinator for K-Bank project,

2009.

. Have certified training in ODI from Oracle Corporation, 2008.

. Have certified training in Project Management Skills and Microsoft

Project by QSIT and Project Management Institute, 2008.

. Recognized as Learning Catalyst, Campus Minds Learning Program for

conducting training and Mentoring Campus batch, 2007.

. Presented Technical Paper on Data Migration Approach, 2006.

. Trained in Sunopsis V3 from Sunopsis, Geneva, 2005.

. Awarded Team of the year for Prudential Prelude DW Project, 2004-2005.

Contact this candidate