SUMMARY OF QUALIFICATIONS

Accomplished Project Manager/Leader with 20 years of Information Technology experience, 18 of which was with Oracle technology through R12 including work with major partners. Possess a wide range of experience in finance, accounting, business analysis, and programming. Highly skilled in delivering Oracle Applications E-Business Suite solutions to meet business needs, including managing conversions, upgrades, implementations, analyses, roll-outs, and testing. Good knowledge of Procure-to-Pay and Order-to-Cash processes. Excellent communication skills. Ability to coordinate work across geographies, work with off-shore teams and being recognized as the go-to man for period end close activities. Good cross functional understanding of the modules and how they interact with each other.

TECHNICAL OVERVIEW

Application Modules: GL General Ledger , Sub Ledger Accounting R12 , AP Accounts Payable , AR Accounts Receivable , CE Cash Management , iExpenses, Alert, AME Approvals Management Engine , AOL Application Object Library , FA Fixed Assets , FSG Financial Statement Generator , INV Inventory , iProcurement, iSupplier, OE Order Entry , PO Purchasing , Workflow

Oracle Applications Releases: 10.7, 11.3, 11.5.7, 11.5.9, 11.5.10 R12.1.3

Languages: SQL, PL/SQL, UNIX Shell Scripting

Development Tools: Forms 6i, Reports 6i, Forms 10g, Reports 10g

Database Products: Oracle 7.x/8.x, Oracle 10g

Database Tools: SQL Loader, SQL Plus, Toad

Operating Systems: Sun Solaris, Windows XP/2000/NT/95/98, UNIX

Case Tools: Oracle Designer

Project Management: Microsoft Project

Other: Kintana, Applimation

PROFESSIONAL EXPERIENCE

Confidential

• In charge of P2P cycle creating and working on enhancements for PO,AP modules.
• Project manage new operating units going live on Oracle.
• Support for modules GL, AR, PA, FA and CM.
• Support for period close activities for AP module.

Confidential

Functional Consultant

• Involved as a functional consultant in the design, implementation and testing of R12 modules including GL, AR, AP, FA, CM.
• Supported extensive testing and configuration in PO, INV modules.
• Client is migrating from legacy systems to Oracle R12. Conversion work needs to be validated and open balances imported into the system.
• Designed new FSGs after getting the requirements vetted by the users.
• Provided post implementation support and conducted user training sessions for Finance modules and INV, PO.
• Communicated with the stakeholders mainly the senior management and Finance folks about the status of the month end activities for the various modules and highlighted any special issues we faced be it technical or otherwise.Did dry runs for the period close in the test instance so we could catch the errors early.
• Actively involved in project planning activities-there were lot of resources who had to leave the project midway due to contractual issues and so we had to manage existing deliverables with the few off shore resources we had. I also interviewed candidates for the roles available and kept management well informed of the hiring being done to manage the work loads. This involved lots of coordination and conference calls with the off shore project manager.
• Worked closely with the DBA teams for application and testing of patches.
• Worked closely with the project manager to ensure that items were being tracked and closed successfully during the cut over to production. We had prepared a checklist of items of such nature for each of the modules.

Confidential

Project Lead

• Complete a risk assessment project for Cisco for Finance and Manufacturing modules in an R12 environment.
• Business case is a divestiture of a business unit and the team is analyzing any business impact for specific data elements left behind in the books of the Business Unit that was divested.

Confidential

Project Lead

• Responsible for Recon for modules Receivables, Accrual, Prepayment, Liability and Undelivered Orders.
• Testing on a large scale to support major upgrades or data fixes/Change Requests.
• Planned for resources, delivery timelines for various small projects that were executed by Deloitte FDA and kept the client abreast of the progress by giving periodical status updates and answered queries should there be any lag. Basically tracked the project to ensure needed progress was being made and communicated this to the stakeholders.
• Initiated work on a prototype for R12 which is due for rollout next fiscal.
• Coordinated with Technical Developers to meet business requirements in the design and development of reports and extensions for Oracle Applications.
• Led end to end testing cycles for migration of new code, new functionality by working with DBAs, technical team and sharing the test results with the users.
• Designed new interfaces and debugged errors wherever I found them without the assistance of others.
• Support for month end close activities that involved debugging the errors, working with the users to sweep transactions to next period if needed. Sometimes there were service requests opened with Oracle support to resolve period end process issues.
• Delivered presentations on R12 functionality, prototyping using test data. Also presented to the client on how to handle legacy data, conversions from existing systems.

Confidential

Consultant

• Maintaining Oracle Payables systems for this enterprise.
• Reconcile Payment information with Oracle GL and legacy systems.
• Design processes for end users to facilitate their daily functions. End user training was part of the job. Participated in analysis, design and configuration for R12 initiative.
• Requirements lead for a new datawarehousing initiative that involved OBIEE reports, Informatica Tools.
• Train end users in using the new technology by scheduling training sessions on Oracle and OBIEEE functionality based on user group preferences.
• Customised 10 reports during my tenure including end to end testing of functionality, validating data for accuracy and completeness.

Confidential

Lead Implementer

• Setup Projects Accounting, Fixed Assets, AP, AR, GL modules in addition to configuration of iExpense and itime modules.
• Tested customized and very complex bonus payout codes and designed its integration to Paychex. Also worked on file transfer to GL.
• As Project Lead for this exercise meant decision making, working with the DBA teams and also Project Management. Successful go-live of all 8 modules.
• Being the only functional consultant on this project also did Project Management activities like budgeting, project scheduling, delivery tracking and in charge of ensuring that the end users received adequate support from the support team post implementation.
• Led this project from start to finish including Requirements Documentation, Design of the COA, customization of reports and end to end testing before go live.
• DLC is a mid -sized consulting company so having done the setups and configured Oracle for a good 8 modules is an achievement in itself. Ensured successful go-live in a year.

Confidential

Receivables Lead

• As the AR lead for this Project, worked on setting up new transaction types that fetch data from interface tables from feeder legacy systems.
• Setup complex revenue recognition rules for a behemoth like Verisign and designed new AR interfaces to integrate with Order Management and Fixed Assets Led a team of developers for customization of forms and reports.

Confidential

Receivables Lead

• Worked extensively on reconfiguring the auto accounting setups and the revenue recognition rules to point to product based revenue from cost center based revenue.
• Developed new FSG reports and setup new cross validation rules in GL.
• Tested various XML reports that were customized to client requirements in Order Management. Production Support for various modules GL, OM, AR, AP, FA.

Confidential

Project Lead, Oracle Financials

• I was the project lead /team lead for the entire rollouts of UK, Hong Kong, Singapore and Australia.
• Led a team of 10 technical developers giving them functional design specs and rollout guidelines.
• Supported GL, AP, AR and PA modules for Kanbay India that were already implemented.
• Led the testing team comprising three team members to design test cases for any new patch releases and to test system functionality. I reported to my Project Manager based in the US.

Confidential

ERP Consultant

• As an ERP consultant, the responsibilities included handling both functional and technical requirements in General Ledger, Fixed Assets, Project Accounting, Accounts Payable and Accounts Receivable.
• Worked extensively on FSGs, Receivables and Assets creating many user defined reports catering to management specific requirements. I was the leader of the team that designed activity based costing systems for management control and internal audit.
• My extensive financial knowledge coupled with my Apps experience were very useful. Was the design lead for implementation of project accounting module documenting the business procedures and practices.
• Extensive interaction with management and manufacturing departments to capture accurate cost data. Included defining cost bases, burden cost codes, resource lists, project types, defining project organization hierarchies and tuning the FSG requirements alongside.
• Concentrated on rectification of some of the setups and modification of existing FSGs while also purging some of the irrelevant existing ones.

Confidential

ERP Consultant

• As an Oracle Consultant for Motorola, responsible for supporting an entire Oracle Application production setup involving OE, AR, GL, AP and FA. The work involved development, enhancement, maintenance and working across organizational boundaries.
• In charge of maintaining close relationships with IT and business management on technical, project, and budgetary matters.
• Implemented work changes directed by the client through documented change requests with the concurrence of upper management.
• Responsible for detailed analysis and documenting the requirements of the Business process in order to implement system designs and changes in Project Accounting.
• Designed and wrote the INTERFACE PROCESS for posting the raw cost and burden cost separately to GL, which was not provided as a standard functionality in any form.
• Developed and Customized Reports and Processes in PA, AP and GL.
• In PA, designed and wrote challenging reports. Totally 15 new reports and two processes were developed. Some of the reports are listed below.
• Comparisons of provisional and actual burden amounts.
• Material and Labor balance audit
• Expenditure reports
• Raw costs transferred to GL
• Process for posting burden amounts separately to GL.
• In SYSAD, installed new printers to the application. This involved writing a very challenging printer driver argument script for formatted check printing.
• Developed the invoice import interface for AP.
• Developed the journal import interface for GL
• In charge of Oracle Application Administration/DBA related activity for AP, GL and PA modules

Confidential

Consultant- Oracle Financials

• Did a presentation on migration from 10.7Apps to 11I Apps involving technical and functional aspects for Jostens Inc., Minneapolis, USA.
• In charge of team selection and recruitment for Oracle Apps team.
• Did case study on migration of Oracle Apps from 10.6 character version to 11i.

Confidential

ERP Consultant

• As an Application Consultant at the client site in the US, was involved in mapping the Business Needs of the client to Oracle Applications and to identify the areas that needed customization and the set-up required for implementing Oracle Projects, Oracle Purchasing, Oracle Payables and Oracle General Ledger.
• Was responsible for discussion with the client regarding the proposed solution and design for customization and the migration strategy.
• Oracle Project Accounting
• Involved in the preparation of the detailed design for the Project accounting module after studying the business requirements. This included, defining expenditure categories, expenditure types, defining project organization hierarchies, defining the implementation options, PA periods and additional budget entry methods to suit the client's requirements.
• Defined resource lists and project types. Involved in defining suitable project templates for the specific needs of the client. Also defined cost bases, burden cost codes, burden structures and burden schedules for burdened projects.
• Developed and customized various reports to suit the clients need, which included:
• Comparison of project expenditures on similar projects
• Customer wise Project Summary report
• Project wise detail and summary commitment report
• Project wise expenditure summary report
• Developed Project wise Budgeted, Revenue and expenditure amount report.
• Involved in the demonstration of Oracle Projects, to the client which included:

• How to use Oracle Projects and to organize the project setups
• To Manage budgets and Costing in Oracle Projects
• To track activities, cost, revenue and billing for services performed for and reimbursed by the client
• Taught users how to use project status Inquiry to review project summary amounts.

Confidential

ERP Consultant

Oracle General Ledger

• Reviewed set of books, accounting period and calendar. Also reviewed accounting structure, validation rules, rollup groups, and security rules. Defined journal sources and categories, and various accounts, defined recurring journals, mass allocations, revaluation, conversion rates.
• Developed Budget Upload with an error correction form in accordance with AOL standards.
• Configured the Financial Statement Generator FSG .
• Developed GL Interface with Legacy Payroll System.
• Oracle Payables
• Was involved in defining Payment Terms, Financial and Payable Options, Approval Codes, and Distribution Sets to simplify Invoice Processing.
• Upload Vendors from Legacy System with an error correction form.
• Loaded Invoices from the legacy system.

Confidential

Oracle Consultant

• System Administration and Application Object Library
• Registered Custom Applications, Oracle IDs, Tables and Forms.
• Defined Data Groups, Menu, Report Security Groups and responsibilities.
• The system involved the computerization of various departments like production, finance, circulation, purchase, stores and personnel. The system catered to various functions like circulation trends, costing, employee personnel master, maintenance and printing. The entire system was designed using Designer/2000 and the development was done using Developer/2000.
• Manufacturing Module
• Development and implementation of printing and maintenance functions of the system.
• Finance Module: Requirement analysis, design, testing and implementation of costing, general ledger and fixed assets of the system. As the module leader, headed a team of 10 people.

Confidential

Programmer Analyst

• As a Programmer Analyst at IPA Scales, Bangalore was involved in coding and testing.
• The project involved developing a web based Library Information System. Scope included tracking right from the issuing of books, tracking and returns of the books.
• As a Team member, involved in the design, development and database web server administration.
• Involved in the design of interface systems from Tally to FoxPro system.

ACCOMPLISHMENTS

• Reduced monthly close process time in Oracle EBS from 5 days to 1.5 days.I redesigned the close processes for AP,AR,FA and GL to achieve this.
• Presented a solution on the ROI for each team member based on hours worked and costed against his utilization and revenue earned. This model earned me good recognition at Kanbay Inc and is still being followed.
• While at Midal Cables I revamped the costing for an entire product group consisting of 3 products that more accurately gave the costs. This helped the management to increase profit margin on a per unit basis.
• Trained the entire set of users in Kanbay Inc on PA functionality and demonstrated Mass Allocation functionality in GL that was later implemented by them under my guidance.