Oracle Sales

Location:

Plano, TX, 75025

Posted:

February 15, 2011

Contact this candidate

Resume:

MAHESH BHAGAVATULA

CAREER OVERVIEW

• Over ** years of extensive experience in Software Application Development across all Oracle

Tools, including 12 years of experience with Oracle Financials, Oracle Applications

Manufacturing (Discrete), Oracle Depot Repair and Oracle Install base.

• Technical and functional consulting experience in all phases of implementations and development

lifecycle.

• Demonstrated ability to successfully implement Oracle modules across several different

processes.

• Capable of designing and developing all financial and manufacturing modules; skilled as a

Developer in Oracle Forms, Oracle Reports, PL/SQL, SQL *Plus, Toad, SQL Developer, Forms

Personalization, XML Publisher and Oracle Workflow.

• Outstanding communication and interpersonal skills.

• Experience managing an offshore team of 10 members assigning service tickets/projects tasks and

tracking the progress of all tasks assigned in Microsoft project central.

• A key member of 1099 implementation team for 9 years and involved in all aspects of 1099

support in Oracle Applications.

SKILLS SUMMARY

Oracle Application Releases: R12, 11i, R11, 10.7 NCA, 10.7 S.C., 10.6

Modules: AP, AR, FA, CE, GL, AOL, OE, INV, WSH, Quality, IB, PO, QP, BOM,

WMS, EDI

Environment: Windows 3.11, Windows 95/98/2000/NT/XP, UNIX, MS-DOS, LINUX

Languages: SQL, PL/SQL, Shell Scripting, C, FORTRAN, JAVA

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

Software: Forms 10g, 6i, 4.5 Reports 10g, 6i, Reports 2.5, Discoverer 3i, 4i, 10g,

Work Flow Builder, PWA, PVCS, SQL Navigator, TOAD, Exceed,

WS_FTP Pro, Mercury, Formscape, Taviz, ADI

Tools: MS Word, MS Power Point, MS Excel, MS Outlook, MS Visio

Hardware: Sun SPARC Solaris, HP

ACADEMIC QUALIFICATIONS

•Master of Business Administration in Management Information Systems, Fogelman College of

Business and Economics, University of Memphis (July, 1997).

• Bachelor of Electronics and Communication Engineering, University of Madras, India (June,

1994).

PROFESSIONAL EXPERIENCE

Vighna Infosolutions Inc., Plano, TX November 2010 to Present

Independent Consultant (Contract Management)

Client: FlowServe Corporation

• Modification of existing custom code to interface internal purchase orders to sales orders.

Creation and modification of existing custom value sets to help run the concurrent programs tied

to custom code run successfully for different operating units and the manufacturing organizations

tied to the same.

• Custom Alert creation to capture incomplete sales orders causing the MRP process to fail.

• Business specifications on changes to existing custom code written for overseas team to complete

coding and delivery.

• Replication of existing custom reporting process in Oracle and building Discoverer workbooks to

help business users view data similar to legacy system in Access.

Red River Solutions, Addison, TX June 2009 to October 2010

Independent Consultant

• Dallas Independent School District November 2009 to October 2010

o Research and solving the multitude of workflow bugs in self service applications.

o Research on the failure of standard purge process in causing huge backlog of completed

workflows leading severe performance of the applications suite.

o Systems study of the various processes in Grants Accounting, Learning Management, Human

Resources, Internet Expenses tied to the various workflow processes.

o Analyzing the failure of Generate Run Balance process in Payroll. Working with Oracle

Support to provide the latest version of Generate Run Balance Packages to synchronize the

weekly, bi-weekly payroll runs with balances.

• Masergy June 2009 to March 2010

Developed SQL*Loader scripts/custom stored procedures in support of the conversion of

legacy receivables data into Oracle receivables which included customer conversion, open

balance conversion, cash conversion.

Developed custom stored procedure to translate legacy system’s three tier customer parent

child structure into oracle using the standard customer interface process as well as Oracle

API’s provided in the application framework to mirror the legacy system accurately.

Developed custom stored procedure to combine header and detail transaction lines from

legacy system using the standard auto invoice process and adding the requested logic to apply

negative lines as credits to prior generated invoices.

Developed custom stored procedure to handle lockbox files within different organizations and

creating separate lockbox files for each organization after initial data mining and research to

provide a complex custom lockbox process capable of handling intercompany receipts.

Custom XML report created to identify several scenarios of receipts being sent in one

lockbox file.

Developed custom stored procedure to extend the standard statement generation functionality

and combining with XML to provide a custom generated statement addressing all business

needs to include the standard invoices, credit and debit memos as line items as well as open

receipts tied to each customer.

Developed custom stored procedure to extend the standard dunning letter generation

functionality and combining with XML to provide a custom dunning letters per the business

rules suggested.

Worked in multiple roles during the length of the project to provide PMO functionality as

well as functional help whenever required to reach the expected milestones in the project.

Lucidity Consulting Group, Richardson, TX April 2007 to June 2009

Senior Applications Consultant

• Supported a massive conversion process from Oracle to JDE being the SME on all client

interfaces and extracting files for conversion in all financials modules which includes possible

lookup migrations, vendors extract, customers extract, open receivable invoices, asset

information, closing balances for fiscal years and detail general ledger line information for the

past five years.

• Vendor Conversion, Invoice Interface in R12 Payables. This includes setting up of invoice

sources/pay groups within Payables/Purchasing lookups to help streamline conversion.

Participated in upgrade tasks to compile reports in 10g and checking for possible changes to

standard tables that have undergone change with R12 changes done by Oracle. Forms

customizations were verified in newer version of tool before the upgrades were done.

• Interface Payroll Checks from banks to Cash Management.

• Transaction Interface in Canadian currency with tax lines tied to transactions. Custom Invoice

created in French and English version to be printed in postscript printer.

• Assets Conversion to Corporate and tax Books though additions API and tax interface tables.

Custom account generator code in conjunction with asset conversion to provide required accounts

for non-regular segments.

• Modified extract files from Oracle to Hyperion. Customized existing version and added

additional fields for Hyperion loads.

• Customized Standard Journal entry Reserve Ledger Report and extended the data created to

be viewed in Discoverer.

• Customized Inventory location detail report, Lot status master report, Inventory Valuation

report, Indented Formulas Report in Oracle Process Management as custom reports using the

features provided by XML Publisher.

• Installed base & Quality Plans conversion from legacy system and history conversion from

OM within Oracle. This involves understanding of Order Management, Inventory, Depot Repair,

Quality and detailing the scope and direction of integrating the same with Installbase.

• Conversion of Item Master and converting it across multiple organizations.

• Conversion of Multiple Item Categories and Item Catalogs. Conversion of Open Sales

Orders. Conversion of Bill of Materials.

• Conversion of Routings.

• Supported several custom Interfaces, Reports and backend routines.

• Modified Purchase Order, Quality Reports and Sales Order report using XML Publisher.

• Personalization to Depot repair forms.

• Personalization of telesales form.

• Personalization of transaction form to default transaction type to salesperson for specific

transaction batch sources and complete the personalization by populating the distribution lines

with receivable account combination from the salespersons table.

• Ported custom application from access database into Oracle to integrate and function with

oracle payables. Custom form built on custom table ported from access to provide seamless

transition between applications.

• Auto printing of packing list and customer invoice upon transaction batch creation.

• Modifications to existing custom reports in discoverer.

• Responsible to provide work estimates and meet deadlines.

• Performed coordination with the users and applicable technology teams to ensure the timely

resolution of daily processing difficulties and issues.

• Diagnosed problems and assisted in development solutions with offshore & onsite teams.

• Feedback on WMS table structure and API info for interface program creation and

modification.

First American, Westlake, TX April 2001 to April 2007

Senior Programmer/Analyst, Senior Oracle Applications Specialist & Team Lead

• Functional Implementation of Oracle Apps 11i: The ACH set up was transferred from the vendor

site level to bank accounts level per Oracle recommendation.

• The Custom ACH code and positive pay code were modified based on business scenarios that got

presented for each client.

• Bank reconciliation was appropriately changed based on the request provided with standard BAI2

files requiring less coding and custom formats necessitating custom code to be written.

• Functional Implementation of Oracle Apps 11i: Bank Account, Pay group, Invoice Source setup.

Custom formatting program setup and attaching them to respective bank accounts.

• Developed, tested and implemented 1099 legacy payment conversion process to integrate the

1099 history with payments in Oracle that need to be reported to IRS.

• The standard 1099 Forms and 1099 Electronic Media Program were modified to include legacy

system payment information to enable complete reporting to IRS.

• End to end technical/functional support of AP issues which included research on yearly patches

that needed to be applied suggested by Oracle, conducting mock 1099 Form runs to test payment

alignment in 1099 Forms, suggesting printer set-up solutions to business groups during printing

before January 31st deadline, sending mock test tapes to IRS using IRS Fire website by the

February 14th deadline and support of business groups during tape submission in April.

• Various customizations of standard Oracle Reports like Final Payment Register, per user request.

• Developed a three way match report to match the approvals with requests on a day to day basis.

• The Common Interface Form to provide the interface results for transactions, invoices &

customers was designed, developed, tested and provided to the customers. Developed a three

way match report to match the approvals with requests on a day to day basis.

• Customized the standard check report to provide the look and feel of the customer's legacy

manifest report.

• Account Generator work flow was modified to exhibit the dollar amounts associated with

accounting assignments of assets down to final segment in chart of accounts rather than plain

association to first couple of segments by default.

• The customer sites were transferred from one org to another org within Oracle as part of this

conversion keeping the header information intact for data integrity purposes.

• The system references from sites created formed the key drivers for the pricing schemes and the

fee types and fee associations related to them.

• Designed, developed, tested and implemented the whole transition from one organization to

another and converted the entire custom pricing between organizations seamlessly.

• Developed, tested and implemented invoice import process for several bank clients to facilitate

check printing for several clients originating from the same legacy system.