[pic]

Srini Mukka

Sr. ODI Developer

(***) 229 - 9143

acg93n@r.postjobfree.com

Summary:

. Over 13 years of extensive IT experience, includes all aspects of

Systems Development and complete Project Life Cycle in Oracle, Siebel and

oracle finance interfaces including

requirements,Analysis,Design,Development,Testing,Oracle SQL Developer

Data Modeler, ETL(Informatica &Oracle ODI) and Implementation.

. Hands on experience as Mid level Oracle Database Administration including

data architecture, logical and physical design, data modeling,

implementation.

. Expertise in design and development of application in relational

database, client server environment and web-enabled environment using

Oracle 7.3/8.x/9i & 10g and Data Warehousing Oracle ODI and Informatica.

. Arround 5 Years of hands-on on experience with Oracle Database

Administration including data architecture, logical and physical design,

data modeling, implementation in Datawarehousing using Oracle Data

Integrator (ODI) 10g/11g.

. Involved in all aspects of ETL-requirement gathering, coming up with

standard interfaces to be used by operational sources, data cleaning,

coming up with data load strategies, designing various mappings,

developing mappings, unit testing, integration testing, and supporting

Test and Production Environments.

. Good understanding of Star and Snowflake Schema, Dimensional Modeling and

Slowly Changing Dimensions.

. Extensively worked on Oracle Data Integrator (ODI) administration,

Topology manager, Designer, Operator and trouble shooting of the

packages.

. Expertise includes analysis, design, and development, testing of data

warehousing application using Oracle Data Integrator ODI (Topology

Manager, Security Manager, Designer, Knowledge Modules and Operator).

. Implimetning and supporting Test and Production environment.

. Extensively worked with database development writing stored procedures,

functions, packages, and data base triggers using SQL, PL/SQL.

. SQL Performance Tuning using TKPROF utility, Explain plan and AUTOTRACE.

. Worked extensively with SQL Loader using control files for data ware

housing and data loading into database tables.

. Extensively used Oracle Datamoduler for database design and generating

ER diagrams.

. Worked on UNIX, Ms-Dos, Windows NT and Windows 95/98/2000/XP operating

systems.

. Working on Unix batch scripts and maintenance

. Extensively. used TOAD, SQL Developer,PL/SQL Developer.

. Developed Batch programs to the preprocessing for the batch reports and

coded customized PL/SQL packages, procedures and database triggers.

. Strong understanding of business processes & interface with IT.

. Worked Clear Case, Releases deployments,Check in and Check outs.

. Strong writing and documentation skills for the management, development

and control of documentation and Involved in the end-user training.

. Experience in handling team individually and perform well under pressure

. Excellent communication skills, strong Logical, Analytical, leadership

and project management skills.

Technical skills:

Languages : PL/SQL, SQL,Pro*C, C, C++,Jav,Java Script.PSP.

RDBMS : Oracle 10g/11g, Oracle9i, Oracle8i, Oracle8,

Oracle 7.x, SQL Server,

MS Access,Postgres.

Oracle Tools : Oracle9iAS, TOAD, SQL*PLUS,SQL Loader, SQL*Impact,

SQL*NET,

Export & Import, Pro-C.

GUI : Developer6i (Forms6i, Reports6i), Developer6.0 (Forms6.0,

Reports6.0)Developer

2000, Designer 2000/6.0/6i, Discoverer,

Oracle9iAS, Oracle9iDS

ERP: : Oracle Apps 11i/10.7 SC - AP, AR, GL

ETL Tools : Oracle ODI and Informatica

Operating System : Windows 95/98/2000/XP, Windows NT, Ms-

Dos, UNIX

HP-UNIX and Sun Solaris.

Others : Erwin, ODBC, HTML, MS Project, Office 2000,

Crystal Reports,UNIX, vi editors.

Education

> Masters Degree in Computer Applications (MCA) from Osmania

University, India.

> Bachelors Degree in Arts (Maths-Economics-Statistics), SV

University, India

Certification:

> Oracle Certified Associate

> Oracle 8i Database Administration (Corporate Training)

> Oracle 9i Database Administration (Corporate Training)

> ORACLE SOA suite 11g developer (Corporate Training)

Professional Experience:

Bank of America, Addison, TX

ODI Consultant June 2014 - Till Date

Bank of America is one of the world's largest financial institutions,

serving individual consumers, small-and middle-market businesses and large

corporations with a full range of banking, investing, assetmanagement and

other financial and risk management products and services.

Responsibilities

> Worked extensively on OLTP and Dataware house projects involving

Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and

Packages, Oracle Supplied Packages,

> Worked with Topalogy settings like Physical, Logical architecture

and Context configuration in ODI as a ODI Admin.

> Working with Data Modeler and scheduling the process.

> Working on ODI operator to monitor the process and resolve the error.

> Design and development of ODI interfaces, packages and Load plan.

> Exporting and importing the Data Modeler, scenarios packages,variable folders and load plans for integration,test and production

environment setup.

> Wrote complex PL/SQL queries and performed data analysis.

> Modified and enhanced existing systems to incorporate new

functionality and to optimize them for performance.

> Worked on Database Design, Data Modeling, Migration, and Systems

Architecture, Planning, Designed the PL/SQL Procedures to load data

from Flat files and Oracle into the target Oracle database.

> Developed UNIX Shell scripts to automate repetitive database

processes.

Environment: Oracle 10g/11g,Oracle Data Integrator (ODI 10g/11g), Toad,

PL/SQL Developer 8.0.4, Shell scripting, SQL*loader, Oracle SQL Developer

Data Modeler,UNIX/LINUX, Windows NT.

Snap-On Business Solutions, Richfield, OH

May'2010 - May 2014

Sr. ODI Developer

Snap-on Incorporated is a leading global innovator, manufacturer and

marketer of tools, diagnostics, equipment, software, and service solutions

for professional users. Products and services include hand and power tools,

tool storage, diagnostics software, information and management systems,

shop equipment and other solutions for vehicle dealerships and repair

centres, as well as customers in industry, government, agriculture,

aviation and natural resources. Products and services are sold through the

company's franchisee, company-direct, distributor and Internet

channels. The objective of the current project is to perform E-T-L and E-L-

T on the raw data provided by the different Projects Like TOYOTA,GM and

MOBIS agents manufacturer and load it into the targets which will be used

by the EPC application users.

Responsibilities:

> Worked with the Business analysts and analyzed various sources for

requirements gathering, business analysis, testing, metrics and

project coordination.

> Analyzed and overviewed the database design for better understanding

the relations, associations and dependencies within the database.

> Involved in various projects related to Data Modeling, System/Data

Analysis, Design and Development.

> Expertise in development, care, and maintenance of logical and

physical data models, along with corresponding metadata

> Experience in developing DDL scripts to create and alter Oracle

Objects and upgrades.

> Analysis and design of ETL Processes design documents and detail

design documents.

> Responsible for Unit Testing and Integration testing of mappings and

workflows.

> Worked with Topalogy settings like Physical, Logical architecture

and Context configuration in ODI as a ODI Admin.

> Working with Data Modeler and scheduling the process.

> Working on ODI operator to monitor the process and resolve the error.

> Design and development of ODI interfaces, packages and Load plan.

> Exporting and importing the Data Modeler, scenarios packages,variable folders and load plans for integration,test and production

environment setup.

> Creating database procedures,functions,triggers and Packages

> Developed various complex queries to generate various reports to

predict business trend.

> Performance Tuning done by using Explain plan and query optimization

techniques and created necessary indexes..

> Prepared Test cases and testing procedures for the database packages

and ETL interfaces and packages.

> Extensively used ACCUREV and JIRA Tools for Implementing the code

Changes.

> Created Materialized Views and partitioning tables for performance

reasons.

> Preparing the Deployment instruction document for Test and production

environment.

Tools: Accurev 4.7.3, JIRA, BeyondCompare2, TextPad.

Environment: Oracle 10g/11g,Oracle Data Integrator (ODI 10g/11g), Toad,

PL/SQL Developer 8.0.4, Shell scripting, SQL*loader, Oracle SQL Developer

Data Modeler,UNIX/LINUX, Windows NT.

Oct 2006 - April 2010

CNSI-INC,MD.

Provider One is a eCAMS product developed for the State of Washington.

Provider One features automated payment system which will eventually

replace the current Medicaid Management Information System (MMIS) and the

Social Service Payment System (SSPS) as well as similar providers paid via

manual payments. The MI MMIS system has a Several Systems like Provider,

Claims, Financials, DRB system, Client Buyin,TPL system,Payroll system,Siebel, etc subsystems. I worked for Payroll,DRB system,client buyin and

Siebel system, As a Database lead developer,responsible for the design,development of financial payroll,DRB system,Client Buyin WinFile and

Siebel interfaces and various PL/SQL Scripts for automating the

operational tasks, and also responsible for making technical document for

the subsystem's. I am writing the interfaces for the other modules which

are related to the Payroll system like TPL,FLS and Provider Modules.

> Translate the requirements, business rules into technical

requirements

> Involved in creating the User Interface, writing the business logic

component and writing stored procedures

> Wrote Procedure and Functions in report builder program units to

overcome the redundancy of code, for fast calculation and to use

object-oriented methodology.

> We have extracted data form system, that is stored outside the

database in flat files using drivers and snding data to Datwarehouse

team. They are useful in the ETL process of Data warehouse and can be

queried in parallel

> Tested all developed/modified reports on development database.

> Interaction with Development Team in fine Tuning the SQL and PL/SQL

Codes.

> Application Tuning was done using SQL_TRACE

> Practical understanding of the Data modeling (Dimensional &

Relational) concepts like Star-Schema Modeling, Snowflake Schema

Modeling, Fact and Dimension tables

> Writing database creation scripts and triggers

> Maintaining a Test & Development Databases.

> Writing interfaces to ecams to Siebel .

> Wriniting interface for oracle financils AP, AR modules

> Working with Data Modeler and scheduling the process.

> Working on ODI operator to monitor the process and resolve the error.

> Design and development of ODI interfaces, packages and Load plan.

Environment: Oracle 9i&10g, PL/SQL, UNIX, Toad, Oracle financials,ODI.

April 2006 - September 2006

Network Solutions, VA

Domain Billing System.

As a PL/SQL Programmer, I am responsible for designing the various PL/SQL

Scripts for automating the various day to day operational tasks, and also

finding out the configuration mistakes and making the corrections for the

same after clear observation of the bills generated. Working on the

production server for generating the bills for the huge amount of

customers.

Worked with Network Solutions as Team member Billing (BSS Operations) in a

24 * 7 Operation. Network Solutions is the original domain name registrar

and the leading provider of Internet, with a huge Customer base.

Responsibilities include:

> Creation and modification of various SQL and PL/SQL scripts like

Procedures, Functions and Packages using PL/SQL

> Operational level exposure to Singl.eView Billing Software from INTEC.

> Part of the technical support group involved in clearing problematic

cases and enhancing the system with required automations.

> TUXEDO startup, Shutdown and trouble shooting.

> Checking observation sent by QA/QC and coordinating with other people

to solve problems.

> Designed the Test Cases for Unit testing, Integration Testing, System

testing and Load testing

> Developed Interface program to upload the invoices information into

Oracle Payables from the feeder system with the necessary validations.

> Developed an interface program to load the legacy invoices from the

feeder system to the Apps with validations.

> Loaded receipts into applications using lockbox master program with

transmission format and control file creation.

Environment:

Application Package: INTEC Convergent Billing System

(Singl.eView).

Backend : Oracle 9i

Technologies : J2EE, XML, Tuxedo, WSDL, Beans, CORBA.

Operating System : UNIX.

ERP : AR,AP and GL Modules

Capgemini, India

June 2004 - February 2006

Senior Consultant

GlaxoSmithKline Global Supply Chain (GSK-GSC)

Global Supply Chain is the system via which GlaxoSmithKline manages its

supply/demand from/to the Global Suppliers as well as Customers.

It links individual elements of a supply/demand chain to improve overall

resource management and provide global visibility of forecast demand,

material replenishment, and physical flow transactions.

The system is developed using the Unix shell scripting and Oracle PL/SQL.

Unix shell scripts make the part of the overnight Batch run and handle the

validations and loading of the data coming from various sites in the world

into the Database. Then the batch runs the replenishment plan processes,

which generate the Planned Arrivals for the Customers, and informs the same

to the Supplier.

Any errors/exceptions generates during the Batch processing is informed to

the Supplier/Customer via an automated e-mail sent out by the Shell

scripts.

Manugistics (a Third party tool) sits on top of the GSC Central system as a

query tool and is used to view, enter, calculate or extract information.

The Manugistics system issues replenishment plans to each of the primary

and secondary manufacturing sites.

Responsibilities:

> Developed forms, menus and libraries extensively in content

correlation System using Oracle Form 9i and deployed the Forms in

Oracle 9iAS under UNIX environment.

> Created and used Object Libraries (OLB) for reusing and

standardization of the Forms.

> Report Triggers were extensively used for creating dynamic tables and

dynamic queries.

> Developed SQL scripts to create database tables, synonyms, sequences

and created users, roles and granting privileges for them

> Written Procedures, Functions and Packages using PL/SQL.

> Written Scripts for Loading ASCII/Flat files onto the Oracle database

using SQL * Loader and UTL_FILE.

> Written test case for the procedures and function.

> Technical interaction with team..

> Ccreated audit tables and triggers.

> Utilized tools TOAD during development of the application.

> Involved in direct discussion with the Functional/End-Users to study

the system requirement and develop Functional and Technical

specifications to meet their requirements.

Environment: Oracle 9i, Forms 6i, Reports 6i, Business objects 5.1.6, SQL,

PL/SQL, SQL*PLUS, TOAD, SQL* Loader, Windows 2000/NT, UNIX.

October 1999 - May 2004

Stock Holding Corporation of India Ltd.

Executive

Project: 1

NTPC PENSION ACCOUNTING SYSTEM

This project is for handling the Pension Fund (PF) requirements of NTPC by

Stock Holding Corp. of India Ltd. This system is designed to maintain data

relating to the PF of 25,000 NTPC employees from all branches of NTPC in

India

The Pension Fund Accounting System will be used to calculate the benefits

for the employees after separation. The system will be used basically to

calculate the regular periodic contributions of employees.

NTPC will register the employee details through registry module, based on

this details SHCIL will process his Annuity,Refund and Settlement

depending his separation type.The system will provide information regarding

purchase price of Annuity, Commutation Amounts and Pension contribution

refunds details will enter in to accounts.

This system will provide various functionalities like

a) Reconciliation of the contribution as computed by the system

b) Computation of pension on superannuating, death or permanent disablement

c) Computation of outstanding from employees in case of separation.

d) Providing various reports to NTPC

e) Accounts reports

i) Balance sheet ii) BankBook Reports iii) Payment, Receipts and Journal

Reports

Responsibilities:

> Worked in System Analysis, Design, developing, and testing of Oracle

Forms and Oracle Reports using Oracle9iDS.

> Developed forms, menus and libraries extensively in content

correlation System using Oracle Form 9i and deployed the Forms in

Oracle 9iAS under UNIX and Windows environment.

> Worked extensively on the hierarchical model of Forms.

> Developed reports extensively on Oracle Reports 9i and deployed the

reports in Oracle 9iAS under UNIX and Windows environment.

> Report Triggers were extensively used for creating dynamic tables and

dynamic queries.

> Developed SQL scripts to create database tables, synonyms, sequences

and created users, roles and granting privileges for them

> Written Procedures, Functions and Packages using PL/SQL.

> Written Scripts for Loading ASCII/Flat files onto the Oracle database

using SQL * Loader.

> Utilized tools TOAD during development of the application.

> Involved in direct discussion with the Functional/End-Users to study

the system requirement and develop Functional and Technical

specifications to meet their requirements.

Environment: Oracle 9i, Forms 6i, Reports 6i, Business objects 5.1.6, SQL,

PL/SQL, SQL*PLUS, TOAD, SQL* Loader, Windows 2000/NT, UNIX.

Project 2: Bid Module for Security Lending System.

Stock-lending product facilitates the SHCIL to lend the scrip's to its

borrowers in the form of loan. This scrip's are collected from account of

lenders who have account with SHCIL. SHCIL works as AI in this process. Bid

module will help the branches to broadcast for deficit quantity for their

demand and get the scrip from various branches who are willing to lend it

for loan period.

Responsibilities:

> Worked in System Analysis, Design, Testing, Development and

implimentation

> Developed forms, menus and libraries extensively in content

correlation System using Oracle Form 9i and deployed the Forms in

Oracle 9iAS under UNIX and Windows environment.

> Programmed Stored procedures, Functions and Package to implement

business rules.

> Designed the database using Designer 2000 (involved E-R, DFD, FH,

Server Model Diagrams)

> Detected and corrected bugs during system integration and user

acceptance testing.

> Involved in code review, Code walk through, Unit testing etc.

> Involved in direct discussion with the Functional/End-Users to study

the system requirement and develop Functional and Technical

specifications to meet their requirements.

Environment: Oracle 8i, Forms 6i, Reports 6i, Designer 2000, Windows 98,

UNIX,, Shell Scripts, PL/SQL, SQL, SQL*PLUS, SQL Loader.

Project 3: Account Opening Module for CDSL

Opening of Accounts, Monetary Processing, Data Transfer to and From

Depository, Interfaces to Entry and authentication, consistency checks,

validation with existing data and transfer of receivables to accounting

interface. Various Reports viz. Client Intimation, MIS, reports to statuary

bodies. The client will approach the account opening operation team and

submit his application form as per format which has been mentioned by SHCIL, they will enter clients name, nominee details, residence details, bank

details and proof of residence .The system is providing data verification

facility. After verification the data is downloaded into a file as per CDSL

mentioned file format and then this data is uploaded to CDSL (depository).

The depository will give a response file, it contains client permanent id.

The account opening team will upload this responsible file through system,

then client account is made active in SHCIL back office.

Responsibilities:

> Worked in System Analysis, Design, developing, and testing of Oracle

Forms and Oracle Reports using Oracle9iDS.

> Developed forms, menus and libraries extensively in content

correlation System using Oracle Form 9i and deployed the Forms in

Oracle 9iAS under UNIX and Windows environment.

> Worked extensively on the hierarchical model of Forms.

> Developed reports extensively on Oracle Reports 9i and deployed the

reports in Oracle 9iAS under UNIX and Windows environment.

> Report Triggers were extensively used for creating dynamic tables and

dynamic queries.

> Developed SQL scripts to create database tables, synonyms, sequences

and created users, roles and granting privileges for them

> Written Procedures, Functions and Packages using PL/SQL.

> Written Scripts for Loading ASCII/Flat files onto the Oracle database

using SQL * Loader.

> Utilized tools TOAD during development of the application.

> Involved in direct discussion with the Functional/End-Users to study

the system requirement and develop Functional and Technical

specifications to meet their requirements.

Environment: Oracle 8i, Forms 6i, Reports 6i, Designer 2000, Windows 98,

UNIX,, Shell Scripts, PL/SQL, SQL, SQL*PLUS, SQL Loader.

Project 4: Stock Lending

This project is developed for Stock Holding Corporation of India Ltd, to

help its demat Account Holders take the advantage of their dematerialized

shares lying Ideally in their demat account with Stock Holding Corporation.

The project keeps Track of client details, their holdings in different

shares, the present value of there Portfolio. In case any client is willing

to lend his shares to other clients, who needs the Shares for a period of

time he can lend them by issuing a letter of his willingness to lend

certain shares of any particular company. The application is processed and

the lender account is debited by that much number of shares from his

account with Stock Holding. There is a pool of requests for

borrowing of shares. Once the borrowers request is processed and the

requested number of shares are available for lending the borrower's Demat

account with Stock Holding is credited with the shares. This is a very

risky propositions, as t he default on the part of the borrower is

involved in it . The market value of the portfolio is calculated on

daily basis based on the market prices of the shares on the previous day.

Once the borrower returns the borrowed shares, the borrower's account

is debited and the lender's account is credited with the shares and the

lender also gets some amount of percentage for lending of his shares.

This project also handles the pledging of demat shares with Banks, which

have a tie up with Stock Holding for some amount.

Responsibilitie:

> Worked in Coding, Testing and Documentation.

> Worked in creation of Sequences for automatic generation of

voucher numbers

> Worked in creation of Views for hiding of actual Tables and

Queries.

> Extensively worked in writing SQL Queries (Sub queries and

Join conditions, correlated sub queries),

> PL/SQL Programming. Designed and Developed various Complex

Forms, Menus, Reports

> PL/SQL Libraries. Also wrote stored procedures, Functions,

Packages etc.

> Development and Testing of advanced SQL and PL/SQL based

code in support of Reports.

> Export and Text IO packages and Written many Stored

Procedures and in many Forms and Reports.

> Written many database triggers for automatic updating the

tables.

> Created indexes on tables and Optimizing Stored procedure

queries.

> Worked in the direct interaction with the End Users and

implemented reviews of the application.

Environment: Windows NT, Oracle 8i, PL/SQL, SQL* PLUS, TOAD,PL/SQL,

Developer 2000 and Pro*C

Project 1: CEDTI accounting Package

This Package maintains the Database of employee's records. The user has to

enter the details of all employees like Date of joining, working lab etc.

The package will retain this information and user can view this as and when

required. This package automatically calculates the PF of an employee on

request by the user. The user can not modify the PF calculations if desired

but can edit the data of an employee. This package will give reports of

monthly salary of all employees and Year wise salary & PF calculation

details of all the employees. ActiveX DLL has been used for the purpose of

calculations. This package is exclusively developed for the CEDTI staff.

With slight modifications it can be used for any organization.

Responsibilities:

> Worked in Creation of database tables,Coding and Testing

.

> Worked in creation of functions and procedures

> Worked in creation of atual Tables and Queries.

> Worked in the direct interaction with the End Users and

implemented reviews of the application.

> Worked in user training program

Environment: Windows95,MS access,VB.5.0

Project 2: Stores Management Automation of CEDTI

This package is complete conversion of the CEDTI stores System (Manual)

into Computerized Semi Automated System. The three main users of this

package are the Director, Stores and the indentor (staff). When a person

wants material from the stores, he will send a requisition note to the

stores manager. He will check the stock of the required material. If

available he will issue them to the indentor. If not then a note to the

indentor of it's non availability to indentor. Then indentor will send the

quotation to stores manager who will forward it to the suppliers. On

receiving the details of the stores manager will forward it to indentor who

will choose a suitable supplier for his product. Then the Stores Manager

will send a requisition note to director for his approval to buy the

material. After the approval the store Manager will order for the material.

On receiving the material from the supplier the Store Manager will inform.

This package maintains the detailed record of all the goods, which are

issued to various personnel. This package also lists the goods but is

issued to each individual employee.

Responsibilities:

> Worked in preparation of the algarithems and Coding.

> Worked in creation of database objects.

> Worked in creation of Views for hiding of actual Tables and

Queries.

> Extensively worked in writing SQL Queries (Sub queries and

Join conditions, correlated sub queries),

> Worked in PL/SQL Programming and various Complex Forms,

Menus, Reports

> Worked in the direct interaction with the End Users and

implemented reviews of the application.

Environment: Windows NT, Oracle 7.3, PL/SQL, SQL* PLUS, TOAD,PL/SQL,

Developer 2000 and Pro*C

Contact this candidate