Malkapuram Srinivas

Phone: 402-***-****©

E-mail: abnw8c@r.postjobfree.com

Summary:

Over TEN years of experience in various Business Applications development using

various suite of Oracle Products on UNIX and WINDOWS environments with active

involvement in numerous life cycle implementations.

Experience in Building & Extending Self Service applications using OA Framework.

Experience in Setting up and Maintaining Oracle 11i Workflow for e-Business suite

and also for custom Modules.

Involved in Production support of Oracle 11i e-Business Suite Web Applications,

Manufacturing Applications, Contracts, iProcurement and several other core

Modules.

Extensive experience in Oracle Applications (11i, 10.7 NCA) in various modules

(OM/Purchasing/INV/HRMS/ i*Expense/ AP/ AR/ OE/ GL/ FA/ AME/ Workflow/

i*Procurement, i*Store, Contracts/XML Publisher) & Manufacturing Modules.

Experience includes in Financial, Telecommunication, Manufacturing, Automobile,

Customer Service, Trading and Consulting.

Highly proficient in using Oracle Tools including SQL, PL/SQL, Reports 3.0/6i,

Forms 4.5/5.0/6i/10g, Oracle Configurator, SQL*Loader, External Tables, Pro*C,

OEM, Portal.

Proficient in Advanced Queuing, Partitioning, Transportable Tablespaces,

Database Tuning, Performance Tuning and DBA Skills.

Proficient in writing Unix Shell Scripts to automate tasks, to transmit reports and to

setup CRON Jobs.

Excellent skills in interpersonal communication as well as in technical documentation

& exposure to Oracle SOA.

Education:

Master’s in Engineering from University of Toledo, OH, USA.

Bachelor’s in Engineering from Osmania University, India.

Technical Skills:

Database: Oracle 10g, 9i, 8i, 7.x.

Operating Systems: Unix, Linux, Windows, Solaris.

ERP: Oracle E-Business Suite /Oracle Applications: R11i.x, 10.7

Modules: BOM, AOL, WIP,AR, AP, GL, HRMS, Payroll, OE, FA, AOL,

i*Procurement, i*Expense, i*Store, Contracts, XML Publisher.

Oracle Tools: Oracle Application Server, Developer2K, iDeveloper,

Oracle Configurator(OCD), Discoverer, Designer,

Workflow Builder 2.x, AME.

WEB: JDeveloper with OA Framework, JTT, JSP, HTML, XML, Javascript

APPS utilities: FNDLOAD, WFLOAD, jpxImport.

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

Pg 1 of 7

Employment Experience

Solution Architect,

TD Ameritrade Holding Corporation. Dec’06 – Present.

Environment: I*Expense, OA Framework (e-Business Suite), Oracle Apps (HRMS,

OM,INV, AP, AR, GL, FA, WIP) AME, Ariba, i*Procurement,

Workflow Builder, Discoverer, Designer, Java, JSP,HTML, XML

Publisher, Noetix Views.

Projects at TD Ameritrade:

Replacement of Ariba System with i*Procurement and customizing using OAF.

Replacement of Concur Expense System with i*Expense.

Setup and Maintenance of Oracle 11i Workflow Builder 2.6

Oracle HRMS Application, Integration

ERP Integration with Corporate Directory

PO Reports & Punchout’s using Oracle XML Publisher & Message Gateway.

Responsibilities:

Solution Architect and Delivery lead role in the project of replacing Ariba System with

Oracle’s i*Procurement

Setup and Maintained the Workflow for 11i e-Business Suite by partitioning the WF

Tables.

Worked with functional team while migrating the data from the legacy Concur Expense

System to Oracle i*Expense system.

Setup Workflow Directory Service and synchronized with Oracle Internet Directory.

Setup Background WF Engines, Implemented Notification Mailers, Customized Logos on

Oracle’s WF Web pages and had setup several business event systems.

Customized and Implemented ER system in I*Expense for 14,500+ employees.

Provide Production support and maintain the Financial Users for GL, AP, AR, Projects,

Contracts and FA Modules.

First tier resource for questions concerning the application functionality.

Coordinate patches and upgrades for the applications.

Worked with Functional teams to define business requirements.

Designed and coordinated all data conversion development / testing tasks.

Developed and customized e-Forms using Oracle’s OA Framework

Implemented numerous and sophisticated workflows using Workflow Builder

Notifications rolled out using Workflow, AME and also XML Gateway notifications.

Developed New XML Reports, Maps using Oracle XML Publisher to transmit through

OSN Network.

Strong Functional experience in AP, GL, FA, AR & iProcurement.

Integrated employee Data from acquired companies into HRMS production tables using

API’s.

Developed key database objects to import into Oracle HRMS Application.

Developed Interfaces for employee benefits, 401K plan and other Payroll features.

Attended Oracle SOA Trainings.

Pg 2 of 7

Tower Lead,

General Motors, MI. Jan’06 – Dec’06.

Environment: Oracle Configurator Developer (OCD), Workflow Builder, Designer,

Unix, PL/SQL, Java, JSP.

Responsibilities:

First tier resource for concerns from Order Work bench users and Business Owners.

Converted the Legacy OWB Tool to Oracle Configuration Developer built on 11i

Framework.

Integrated the inbuilt Workflow and customized it for North American, European and Latin

American versions of the Tool.

Provide Production support and managed the Offshore coordination during late nights.

Experience in working from a remote location managing Onsite and Offshore team.

Worked with Functional teams to define business requirements.

Designed and coordinated all data conversion development / testing tasks.

Implemented numerous and sophisticated workflows using Workflow Builder

Sr. Application Architect,

West Corporation. (NYSE: WSTC) Feb’05 – Jan’06.

Environment: Oracle 9i, Oracle eBusinessSuite, Workflow Builder,OA Framework,

Oracle Apps, Java, JSP, Javascript, JTT, VXML, Advanced Queuing,

Designer 6i, Linux.

Responsibilities:

Develop and maintain existing VXML Portal which reports the call counts and call volume

for different clients from a huge Oracle database.

Worked with Functional and Client teams to define business requirements.

Developed numerous sophisticated Core Backend Packages, Procedures and Functions

for converting the data from data files to Production Database.

Used “Oracle Heterogeneous” Services to import data from legacy systems.

Responsible for gathering and analyzing the requirements, meeting with external clients

and internal corporate resources.

Optimized long running queries, indexes by tuning query execution plans on single,

distributed and partitioned databases.

Designer 6i was used as the tool for Logical and Physical Design of the Schemas.

Developed communication between different databases using Advanced Queuing.

Developed automated and metadata driven Partition Management, Datafile, Tablespace

Management and Index Management.

Built metadata driven Exception handling and reporting. Notifications are sent to

operations personnel using PL/SQL email utilities.

Pg 3 of 7

Sr. Technical Consultant,

EATON Corporation (NYSE: ETN)

Galesburg, MI. Oct’04 – Feb’05.

Environment: Oracle iStore, Designer 6i, Linux, JSP, Oracle Apps 11i, 10g App. Server,

INV, BOM, WIP, OE, AR and Custom Quoting.

Involved in the Design and Analysis of a Mobile Diagnostics Ecommerce Website

RoadRanger.com (www.roadranger.com ). RoadRanger, the B2B and B2C Application for the

EATON Corp is a highly sophisticated Ecommerce Web Store that interacts with Vendors and

Customers in selling about the Truck Components and its tools. RoadRanger, mainly a Drop

Shipment Business Model has many dynamic capabilities such as Online Inventory Verification,

Custom Purchase Price to the Supplier based on Selling Price by EATON and various

customizations in Oracle Applications.

Responsibilities:

Responsible for Design and Analysis of the Upgrade from Merchant X Webstore to

Oracle iStore.

Developed and Modified iStore API involving heavy and sophisticated PL/SQL Stored

Procedures, Functions and Triggers.

Implemented the Various Customizations in iStore Business Components and Front End

pages using JSP.

Extensive customization in Mfg Modules (INV, BOM, WIP, OE, AR).

Successfully lead the Development and Implementation with Offshore Oracle Corporation

and Testing Team, within the time frame.

Sr. Application Developer,

First Data Corporation (NYSE: FDC). June’01 – Oct’04.

Environment: Oracle 8i, PL/SQL, Oracle Apps 10.7/11i, Forms 6i, Reports 6i, Unix, Pro*C.

(AR, AP, GL, PO, FA)

C.A.B.S is a customized, fully integrated and Secure Billing System on Oracle Applications

providing Billing solutions, Invoice Reports, Client transmissions of Highly Sensitive data through secure

networks over Web and Legacy Systems to many Vendors inside and outside of First Data. This

application involves time based CRM and client critical maintenance issues to be resolved over phone or

Internet and teleconference dialing into International Locations. This application is core billing system to

First Data Card Services, Western Union, Concord, CUETS, PAYSYS, FDRL, FDR-Aus and various

minor operating units and strictly adheres to Sarbanes-Oxley Regulations.

Responsibilities:

Responsible for design, coding, Unit testing, Implementation and Support for

Client Accounting Billing System (CABS) Modules.

Responsible for gathering and analyzing the requirements, meeting with external clients.

Technical meetings held with Application Developers and successfully lead a team of 5

developers in implementing Business logic coordinating with Users of application

including users in FDR London, FDR Australia.

Architected and designed the application framework on Oracle Apps, Oracle 8i

Responsible for Quality Inspection of the design documents in each project.

Successfully completed the Leadership task of RMS Transmission reports to Clients over

WEB and LEGACY Systems by extensive testing and communicating with the clients and

Peer developers.

Writing Scripts to Automate the Development and Production Support.

Extensive PL/SQL coding on Stored Procedures, Functions, Packages, Triggers & Forms.

Pg 4 of 7

Trained and attended various System Related and J2EE courses to enhance my

Knowledge and at the same time to mentor the new employees on board.

Projects at First Data Corporation:

11i Upgrade of Oracle Application Billing System integrating the Application with

Java

Forms & Reports Conversion from Character based to 6i to enable the

Application deploy over WEB with enhanced Security aligning with Sarbanes-

Oxley Guidelines.

Multi-Currency Functionality in CABS. (To handle International Currencies)

Single handedly handled the project of Integrating with Bloomberg to derive

Exchange Rates every morning.

RMS Transmission of Reports over Web & Legacy Systems.

Appworx Upgrade. (Tool to Submit Jobs).

Multi-Company Functionality in CABS. (To handle International Clients)

Workshops/Training Sessions at First Data Corporation:

Deploy J2EE Applications over WEB.

Oracle 9i Tuning Workshop.

Oracle Workflow Builder.

J2EE Architectural Concepts.

Honors at First Data Corporation:

Received Best Employee of Year “2002” in IT Field.

Programmer/ Analyst

Dept. of Public Welfare,

Harrisburg, PA Sep’99 – June01

Project: FEDERALIZING GENERAL ASSISTANCE

Environment: Oracle 8i, Oracle Forms, Reports, Java, SQL* Loader, Windows NT.

Responsible for the entire life cycle of the project from design, development to

implementation. Responsibilities included developing application logic, designing and

programming Application Wizards, loading the data through SQL Loader. Constructed ER

diagram, which normalized the relations. This corporate intranet application developed is useful

for all MCO’s in PA to upload the General Assistance files after validating various authentications.

Graphical User Interface Screens are developed using Java Swing inheriting MVC Design Pattern

and Architecture. Generated reports on the web browser interface from database using JDBC.

Participated in 1-Level (Unit testing), 2-Level (Form Testing) and Integration testing of the project

Project: Managed Care Organization System

MCO is developed to offer an integrated enterprise solution for the Public Welfare

Organization of PA. This project has functional modules such as Accounts Payable, Services,

General Ledger, Inventory, Human Resources, and Budgeting etc. Responsibilities included the

task of designing & developing forms related to several modules, Generating HTML reports,

coding stored procedures and triggers for editing the raw data to import from legacy databases to

Oracle database., Developed business logic which resides in the middle tier and performed

various preliminary client side validations. Developed numerous stored procedures and functions

using PL/SQL.

Pg 5 of 7

Software Engineer

Department of Parking Services,

University of Toledo, OH. Aug’98 – Jun’99

Environment: Oracle 8.0, Developer 2000, Designer 2000.

Developed an application for the Department of Parking Services, Univ. of Toledo. The

application developed is useful for issue of parking permits to students, faculty staff and other

customers, and collection of fines from the violators, generating warning reports, validation of

parking permits etc. This application is a 3-tier architecture with Java web server as the web

server and Oracle as the database server.

Office of Registration,

University of Toledo,OH.

As a member of a core team developed an application for online registration in which the

system takes care of all aspects like registration, updating, insertion and deletion of student

records, viewing the student grades etc. With this application the student can register the courses

for either the current semester or the following semester for which courses are offered, his grade

history and his financial aid information. The responsibilities included in developing this

application were design and development of database schemas, developing front-end screens

using Java swing, generating reports through the parameters passed from forms using JDBC

connectivity.

Application Developer

Lakshmi Banking Systems, India. Aug’97 – Jul ’98

Environment: Oracle 8.0, Developer 2000, Designer 2000.

Responsibilities at Lakshmi Banking Systems included developing an application of 2

modules, the Employee module and the Customer module. This application automatically

calculates the interest depending on the account type, generates periodical reports for the

balances and all the transactions are immediately updated. Worked extensively on the

implementation and maintenance of banking application. Developed application logic, constructed

an Entity-Relationship diagram that normalized the relations, Developed GUI screens, PL/SQL

procedures and functions, worked on Data Reports, carried out documentation for the concerned

modules.

Academic Projects:

Address Book: Developed a Personal Address Book in Java. The project involved

accessing an Oracle database using JDBC. The GUI was developed using the JAVA

Swing classes. The user has the option of viewing any particular record by making a

selection from a choice Box. The user also has the option of adding new records,

updating records and deleting records. This involved retrieval of data from the database

and also writing data into the database.

Text Editor: A simulation of Text Editor using Java Programming was developed. The

user interface is developed in Java Swing. This editor has all the traditional features of an

ordinary text editor such as accessing the local file system and performing operations on

them using menu bars, menu items etc.

Pg 6 of 7

Client-Server Chat System: Developed a multi-threaded client server chat system using

data structures in “C” Language. This is a full-fledged client server system using TCP/IP

to send large packets of information. Designed and developed classes for server side

and client side networking. Implemented a multithreaded server that can connect to any

number of clients.

Certifications:

Sun Certified Java 2.0 Programmer.

Oracle Certified in Deployment of J2EE Applications over 9iAS.

Honors:

Awarded Gold Medal from Osmania University for standing first in academics in B.E

Recipient of Graduate Tuition Scholarship from University of Toledo for ’98-’99.

Pg 7 of 7

Contact this candidate