SUMMARY

• Over a decade of progressive experience in Oracle E-Business Applications with prior professional experience in accounting, audit and finance
• Extensive experience in the implementation and maintenance of Oracle Applications Modules: GL, AP, AR, CM, FV, PSA, PO, Oracle Loans, Oracle System Administration, iTime & iExpense, Oracle Federal Financials and Oracle Federal Administrator
• Expertise in all phases of Software Development Life Cycle (SDLC) including requirements gathering, gap analysis, design, development, customization, configuration, testing, training, deployment and production support

• Oracle Applications R 10.7, 11.0.3, 11i, 11.5.10 and R12
• Languages: SQL and PL / SQL
• Oracle Utilities: SQL* Loader and SQL *Plus
• Other Software: TOAD, Microsoft Office tools, Visio, Lotus Notes, PVCS Version Manager, Applimation Integra Apps, Data Loader, AutoSys, Rational ClearCase, Rational ClearQuest, ManageNow and Remedy

Confidential
Sr. Oracle Financials Functional Analyst (Contractor for IBM)
Nov. 2004 - Feb. 2013
Confidential, is a single, integrated dual-entry and FFMIA-compliant accounting system that processes the mission critical payment calculation for Medicare benefits to Part A and Part B, Medicaid Grants, and Children\'s Health Insurance Program (CHIP) for the entire nation. HIGLAS also incorporates internal CMS administrative program accounting transactions. HIGLAS involves implementation of several Oracle Federal Financials Applications such as GL, AP, AR, CM, PSA, HTB, FA (Federal Administrator), SA (System Administration), PO, Oracle Loans, OBIEE, Custom Grants and CAN/BACS

Key Accomplishments:

• Worked on the HCRs (HIGLAS Change Request) involving several SDLC tasks including requirements gathering, review meetings, business rules and scenarios, functional design, development, configuration, testing and training
• Conducted/Participated in Solution Reviews for PMR's (Problem Management Records) and Working Group Sessions for HCR's
• Performed financial reconciliation and TROR (Treasury Report on Receivables) reconciliation and resolved reconciliation issues/variances
• Performed several month-end activities for the smooth and timely period close for the sub-ledgers and the General ledger
• Prepared and provided the month-end financial statements for certification
• Supported CFO and A-123 Audits
• Supported the transition of new Medicare contractor organizations to HIGLAS
• Developed and executed test cases/test scripts for HIGLAS HCRs and break/fix
• Analyzed the new features in Release 12, performed impact assessment and set up the Environment with a view to upgrading to R12
• Prepared BR 100 documents regarding setup changes and performing the configuration changes in several development, test and production instances
• Updated As-Is Process Flows and Functional Specification Design documents

Confidential, Atlanta, GA

Confidential, is one of the largest cable providers in the nation. CCI implemented various Oracle R11i (11.5.9) Oracle Application modules to replace various legacy systems.
As a member of Oracle Applications Implementation Team, participated in

• Requirements gathering/analysis
• Configuration of Payables module
• Conversion of legacy data and Creation/execution of test scripts

Jul 03 - Jun 04
American Insulated Wire (AIW), a Leviton company, is one of the leading manufacturers of insulated wire and other electrical goods. Replacing various legacy systems, AIW has implemented Oracle R11i (11.5.9) Financials (GL, AP and PO) and Manufacturing Applications (WIP, BOM, Costing, SCP, INV and Quality).
Implemented the financial modules and performed several activities as follows:

• Designed a flexible, multi-organizational structure for future growth and change
• Streamlined business processes
• Analyzed/identified business requirements
• Performed fit/gap analysis and solution design
• Carried out module configuration
• Developed Month-end, Quarter-end and Year-end close Procedures
• Developed the Test Strategy for different test events
• Coordinated and facilitated the development and testing of data conversions, interfaces, reports and other customizations & extensions.

Nov 01 - Jun 03
Confidential, is one of the largest management and IT consulting firms in the world. As a part of developing a fully integrated financial system for its North American Region Entities and Business Units (US, Canada and Mexico), it has implemented Oracle R11i Financials (GL, AP, AR, CM) & Project Accounting, iTime & iExpense, HR, Oracle Tutor, Oracle Financial Analyzer and Discoverer Reporting Tools.
Participated in all the phases of the project during its full life cycle and performed several activities as follows:

• Analyzed/identified business requirements
• Performed gap analysis and developed solution alternatives.
• Participated in module configuration
• Designed/developed several programs for the conversion of vendors, customers, supplier invoices and employees
• Designed/developed several interface programs regarding positive pay, check printing, bank statement import, employee time and expense, customer information and tax rates and locations
• Created/executed Test Scenarios/Test Scripts and provided user training.

Environment: Oracle Applications 11.5.4(11i Multi-Org, Multi-Currency), Reports 6i, Oracle 8i, Oracle Workflow 2.6 and HP-UNIX.

Oracle Applications Consultant

• Automated the import of Procurement Card Transaction Files into Oracle Accounts Payable System. This involved development of an interface to automatically load the Procurement Card files into the Open Invoice Interface tables in Accounts Payable.
• Involved in System administration and Production Support Activities.

Environment: Oracle Applications 11.5.3(11i Multi-Org), Reports 6i, Oracle 8i and Sun SPARK Solaris.

Confidential, is in the business of generation and distribution of power and gas in the states of Indiana and Ohio. It is the result of the merger of Indiana Energy and SIGCORP. It has also acquired Dayton Power and Light's natural gas distribution business.

• Participated in the upgradation of the system from Oracle Applications 10.7SC to Oracle Applications 11.0.3 during the first phase. As a part of upgradation, involved in various System Upgrade steps including running various Standard/Custom Reports in 10.7 and 11.0.3, comparing the data in reports from 10.7 to 11.0.3, researching standard/Custom Report Variances, testing custom interfaces, custom forms and other custom code.
• Participated in the migration of the newly acquired companies to the upgraded Oracle Applications 11.0.3 during the second phase. As a part of migration, involved in the design/development of Conversion/Interface programs and creation/execution of test scripts.

Modules Implemented: AP, PO, CM, PA, GL and Oracle HRMS.
Environment: Oracle Applications 10.7SC/11.0.3, Forms 4.5, Reports 2.5, Oracle 8.x and HP-UNIX.

• Participated in the ERP (SAP and Oracle Applications) Applications implementations
• Planned and executed various Implementation steps including business process study, requirements gathering/analysis, gap analysis, module configuration and testing.
• Created and executed Test Scripts to confirm the proper development and configuration of the system.
• Designed/developed custom reports

• Participated in Systems Analysis, Design & Development of Client/Server applications.
• Analyzed the systems and business needs, producing functional specifications.
• Provided domain knowledge.

Confidential

Jun-1992 - Jan-2000

• Planned and executed various professional assignments in the areas of Accounting, Auditing, Taxation, Project-Finance and Company Law matters in a variety of Business settings.
• Planned and conducted various types of audit like statutory audit, internal audit, revenue audit, concurrent audit, inspection and investigation.
• Planned, designed and developed appropriate accounting systems, internal control systems, procedures, policies and input/output documents, preparation and finalization of accounts and accounting statements.

• Passed CPA Examination (American Institute of Certified Public Accountants)
• Chartered Accountant (Institute of Chartered Accountants of India)
• Bachelor of Commerce (Nagarjuna University, Andhra Pradesh, India)
• Post Graduate Diploma in Computer Applications
• Oracle Financials Course