We provide IT Staff Augmentation Services!

Independent Consultant Resume

Plano, TX

Career Overview

I have 13 years of extensive experience in Software Application Development across all Oracle Tools. He has worked for 1 years with the Oracle Financials, Oracle Applications Manufacturing (Discrete), Oracle Depot Repair and Oracle Install base. He has technical and functional consulting experience in all phases of implementations and development lifecycle. He has demonstrated the ability to successfully implement Oracle modules across several different processes. He is capable of design and development of all financial and manufacturing modules. He is also skilled as a Developer in Oracle Forms, Oracle Reports, PL/SQL, SQL *Plus, Toad, SQL Developer, Forms Personalization, XML Publisher and Oracle Workflow. He has strong communication and interpersonal skills. Mahesh has managed an offshore team of 10 members assigning service tickets/projects tasks and tracking the progress of all tasks assigned in Microsoft project central. Mahesh has been a key member of 1099 implementation team for 9 years and involved in all aspects of 1099 support in Oracle Applications.


Professional Experience

Confidential, Plano, TX November 010 to Present
Independent Consultant
FlowServe CorporationNovember 010 to Present

  • 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 sales orders that were incomplete 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.

Confidential, Addison, TX June 009 to October 010
Independent Consultant
Dallas Independent School DistrictNovember 009 to October 010

  • Research and solving the multitude of workflow bugs in self service applications.
  • Research on the failure of standard purge process in causing huge backlog of completed workflows leading severe performance of the applications suite.
  • Systems study of the various processes in Grants Accounting, Learning Management, Human Resources, Internet Expenses tied to the various workflow processes.
  • 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.

ConfidentialJune 009 to March 010
1 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 organizations 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.

Confidential, Richardson, TX April 007 to June 009
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 R1 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 R1 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.

Confidential, Westlake TX April 001 to April 007
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 BAI 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.
  • Bank reconciliation was appropriately changed based on the request provided with standard BAI files requiring less coding and custom formats necessitating custom code to be written.
  • Developed, tested and implemented invoice import process for several bank clients to facilitate check printing for several clients originating from the same legacy system.
  • Bank reconciliation was appropriately changed based on the request provided with standard BAI files requiring less coding and custom formats necessitating custom code to be written.
  • Developed, tested and implemented invoice import process for several bank clients to facilitate check printing for several clients originating from the same legacy system.
  • Bank reconciliation was appropriately changed based on the request provided with standard BAI files requiring less coding and custom formats necessitating custom code to be written.
  • Support on EDI Invoice Inbound and check outbound in AP and transaction inbound and credit/debit memo outbound in AR.
  • Created Custom OM Reports and INV Reports.
  • Identifying Customizations to 10.7 reports as part of the conversion from 10.7 to 11i under a new chart of accounts.
  • Upgrading reports/forms from 10.7 to 11i using Reports 6i and Forms 6i tools and adding required changes to suit the new environment.
  • Managed a team of 10 Application consultants in Bangalore, India.
  • Successfully delivered multiple projects and quality service on post production issues from offshore team.
  • In the role of Project Lead with offshore team, gathered all business requirements and mentored the offshore team to deliver end-to-end AR, AP module related conversion/interface tasks.
  • Modified custom output files being sent to Hyperion for new loads and changes to existing loads.


Confidential- Dallas, TX Mar 98 to Apr 01
Systems Consultant

  • Developed SQL*Loader scripts in support of the conversion of legacy General Ledger data into Oracle General Ledger.
  • Developed stored functions, which were used by multiple custom conversion/interface processes to ensure data consistency within the Oracle Financial and custom modules.
  • Developed triggers on custom tables to ensure data integrity and enhance existing functionality.
  • Developed PL/SQL scripts to handle the validation and loading of legacy General Ledger data into Oracle General Ledger interface tables.
  • Developed PL/SQL scripts to handle the validation and loading of legacy General Ledger Budget data into Oracle General Ledger budget interface tables.
  • Developed UNIX shell scripts to automate the data load process.
  • 7 Customized the positive pay report in oracle payables. The customization involved concatenation of required columns to provide an output file for banks.
  • Customized the standard journal entry and journal detail reports to accommodate additional flex field values, locations in this case, and calculate the totals for the same.
  • Customized the rollup range definition reports to provide child ranges associated to each parent value for all the segments in the flex field structure.
  • Successfully replicated the legacy system\'s profit ranking report in oracle applications. The basic unit in the report is the individual location of each motel. The location is rolled into areas. The areas are rolled into their respective regions. The report ranks the individual locations in a given area, the areas in a given region, the areas in all regions and regions attached to the company for a given period.
  • Customized the CIP Assets Report, Tax Additions Report, Annual Additions Report and Retired Assets Report in Fixed Assets to accommodate additional columns.
  • Prepared conversion and interface requirements documentation using the Oracle AIM Methodology.
  • Developed a form, which maps the legacy location to location values in the Applications. This empowered the user to enter the mapping value for any legacy location across all modules.
  • Developed the controllable profit performance ranking report for the Red Roof locations, districts and regions.
  • Developed an extended version of the controllable profit ranking report ranking the areas, districts and regions for the Red Roof and Motel6 locations.
  • Prepared conversion and interface requirements documentation using the Oracle AIM Methodology.
  • Developed custom scripts to transfer data from legacy system to interface tables in Cash Management.
  • Modified PL/SQL scripts to pass parameters from the applications and transfer data to general ledger interface tables as part of the payroll automation project.
  • Modified internal forms and reports to suit business needs using Developer 000.
  • Customized the standard oracle check report in AP using Reports ..
  • Modified stored procedures to change web forms in the company\'s Intranet.
  • Developed update triggers to transfer data from Oracle tables to the legacy system.
  • Developed SQL*Loader scripts to migrate data from the existing legacy system to the temporary tables in Oracle Applications.
  • Developed SQL queries to create the data file required for loading into the temporary tables.

Skills Summary
Oracle Application Releases:R1, 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 9/98/000/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. Reports 10g, 6i, Reports ., 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,
Bachelor of Electronics and Communication Engineering,

Hire Now