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

SKILLS

• 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

EXPERIENCE

Confidential

Sr. Oracle Financials Functional Analyst

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
• Developed and executed test cases/test scripts for HIGLAS HCRs and break/fix
• Supported the transition of new Medicare contractor organizations to HIGLAS
• Supported CFO and A-123 Audits
• Analyzed the new features in Release 12 including SLA, 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

Sr. Oracle Financials Functional Consultant

• As a member of Oracle Applications Implementation Team, participated in
• Cox Communications, Inc CCI 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.
• Requirements gathering/analysis
• Configuration of Payables module
• Conversion of legacy data and Creation/execution of test scripts

Confidential

Oracle Financials Functional Lead

• Implemented the financial modules and performed several activities as follows:
• 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 .
• 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 the Test Strategy for different test events
• Developed Month-end, Quarter-end and Year-end close Procedures
• Coordinated and facilitated the development and testing of data conversions, interfaces, reports and other customizations extensions.

Confidential

Oracle Applications Consultant

• 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.

Confidential

• 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

Oracle Applications Consultant

• Vectren 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.

Confidential

• 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.
• Participated in Systems Analysis, Design Development of Client/Server applications.
• Pragnya Systems P Ltd. Hyderabad Consultant Sep-94 Jan-98
• Designed/developed custom reports
• Created and executed Test Scripts to confirm the proper development and configuration of the system.
• Analyzed the systems and business needs, producing functional specifications.
• Provided domain knowledge.