PROFESSIONAL SUMMARY

• Over 8+ years experience as an Oracle Functional analyst in Oracle E-Business Suite with exposure to Implementation, Support, Upgrade and testing of Oracle Applications.
• Extensive work experience on Oracle Apps Modules which include Account Receivables, Advance Collections, I-Receivables, Accounts Payables, I-Expense, Purchasing , I-Procurement ,I-Payments, General Ledger , HRMS ,Trade Management and E-Commerce Gateway.
• Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, CRP (Conference Room Piloting), Solution Design, Proof of Concept, Unit Testing, UAT and User Training.
• Experience in Oracle 8i/9i, PLSQL, SQL*PLUS, Oracle Reports, Forms, Discoverer (3i/10G), XML Publisher (5.6.3) and Oracle Workflow.
• Module implementation for Oracle E-Business 11i (11.5.10.2) and R12 (12.1.3) for Financial Modules.
• Excellent knowledge on Functional Analysis and Implementation, Training the client’s super users and users on the application and conducted pilot testing, integrated testing, design validation and setups.
• Experience with Other Utilities: TOAD, SQL*Loader.
• Expertise in configuring, using & administrating version control systems like Visual SourceSafe (VSS), CVS and PVCS.
• A good team player with excellent technical, communication & interpersonal skills.
• Motivated and determined to deliver high quality deliverables within deadlines with minimal supervision.

EDUCATION

• Bachelors in Electronics and Communication Engineering
• Pursuing ‘Chartered Financial Analyst’ degree .

FUNCTIONAL SKILLS

Oracle Modules

Core Knowledge in Accounts Receivables(AR),Accounts Payables(AP), Purchasing ,General Ledger (GL), IPayment , I-Receivables , Advance Collections ,,Core HRMS ,Trade Management and E Commerce Gateway

Basic Knowledge in Order Management ,Inventory and Project Accounting

TECHNICAL SKILLS

Languages

SQL, PLSQL.

Databases

Oracle 9i,10G /11G, MS-Access.

Reporting Tools

Toad, SQL Plus, Oracle Reports and Forms (6i), Discoverer 3i/10G, Workflow Builder, SQL Loader and XML Publisher.

Version Control

Microsoft Visual Source Safe, CVS.PVCS

Operating System

Windows 2000/NT/XP/2003.

Environment

Oracle Applications – EBS 11.5.8,11.5.10.2 and 12.1.3

PROFESSIONAL EXPERIENCE

Client: Confidential Chicago May 2012 – Present 
Oracle EBS Financial Consultant – Oracle Re-Implementation

Environment: Applications – EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher

This Project is to Re-Implement Oracle from the current existing 11.5.10.2 Instance. The main agenda was to Retire the existing Customizations and use Standard Oracle Features to Conduct Business.

Roles & Responsibilities:

• Study the Current State Functionality for AP, AR, FA and GL Modules.
• Present the Changed Architecture and new Features that R12 offers.
• Conduct discussion on Conversion Strategies for Financial Modules.
• Prepare the Future State Design Document across Financial Modules.
• Conduct CRP Sessions to test the System Functionality.
• Preparation of Functional design documents for new Customizations.
• Design of End to End Test Plan for the go-live of Oracle Systems
• Work Closely with Other Module Leads to define the dependency on each Modules.
• Provided End user Trainings for new Functionality in R12

Client: Confidential Dec 2010 – April 2012
Oracle EBS Financial Consultant – New Enhancements / Maintenance Project

Environment: Applications – EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher

OSC and DOB had formed a partnership to develop an integrated Statewide Financial System (SFS) to support the State of New York‘s accounting and management of finances. The State of New Yorkwould implement a single instance of Oracle PeopleSoft Financials software with security controls to maintain separation of duties. A new statewide Chart of Accounts (COA), designed for more robust financial management, reporting and analysis, would serve as the backbone for this integrated system .The main role in this project was to Determine the Impact on Agencies Financial Systems and Processes as a result of new changes to SFS.

Roles & Responsibilities:

• Design of new Budget Structure in GL based on State allocated Appropriations and Segregations.
• Modification of Entire Rollup Structure for Chart of Accounts and definition of new Summary Templates.
• POC and Implementation of Encumbrance Accounting for the New Budget setup.
• Modification of Check Printing Templates in Payables.
• POC for AP/AR Netting which was over looked during the Upgrade to R12.
• Handling of other Functional issues across financial modules on a needy basis ( Receivables ,Payables, ,Purchasing, I-Expense and General Ledger ).
• Preparation of Functional design documents for new Customizations.
• Involved in the design of End to End Test Plan for the go-live of Statewide Financial Systems
• Provided End User Trainings to understand standard ERP business definitions.
• Involved in the design of End to End Test Plan for the go-live of Statewide Financial Systems.
• Involved in unit testing, module testing and integration testing.
• Handled Statewide Agency Meetings on a weekly Basis for Go-Live Readiness.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.

Client: Confidential, Rohnert Park, CA Jan 2010 – Nov 2010
Role : Oracle Financial Consultant - Implementation

Environment: Oracle Applications – EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher, Oracle Discoverer

Confidential- Solar Depot / DC Power Systems is a wholesale distributor and systems integrator of solar electric and solar thermal systems. For over 30 years, Solar Depot has been designing and supplying solar energy systems for residential, commercial, and industrial applications, making Solar Depot among the largest and most experienced solar integrators in the United States. Solar Depot implemented Oracle EBS R12 for US Entity .With launch of Canada operations, the requirement is to implement a separate company as Solar Net Canada.

Roles & Responsibilities:

• Single point of contact for the Business System Analysts and End users for gathering all requirements for Canadian Implementation of Oracle EBS (AR,AP,I-Procurement and I-Receivables).
• Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation (including BRD and BR100s) for financial modules AR and AP.
• Modification of XML Templates for Netting Reports and Check Printing Formats.
• Functional Design for Customization of I-Procurement/I-Receivables Pages and End to End Testing.
• Customization of Refunds Functionality in AR
• Implementation of Lockboxes with RBC Bank via EDI.
• Provided assistance in EDI Implementation of Vendor Payments.
• Segregation of transactions into a Separate legal entity, operating unit and inventory organization.
• Design and Unit testing of Oracle Discoverer Reports for new entity.
• Modification of customer facing documentation to show Canadian subsidiary name, currency, logo, and addresses.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.

Client: Confidential, Fond Du Lac-WI Sep 2007 – Dec 2009 
Techno Functional Financial Consultant – Implementation/Support
Employer: Keane Inc, US

Environment: Oracle 11.5.10.2, Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Workflow Builder.

Confidential is the world’s leading manufacturer of recreational marine propulsion engines. A $2.3 billion division of Brunswick Corporation (NYSE: BC), Confidential and its 6,200 employees worldwide provide engines, boats, services and parts for recreational, commercial and government marine applications. Confidential Implemented Oracle (11.5.10.2) in 2006 and was using all legacy applications to run it’s core business before implementation of Oracle .This project deals with support of core Financial modules which includes Account Receivables, Advance Collections, Account Payables ,Purchasing, I receivables ,I expense and I payment modules. The support also included some Supply Chain Modules.

Roles & Responsibilities:

• Handling of Functional and Technical Support issues across financial modules (AR, Advance Collections, AP, GL, Purchasing, FA ,Trade Management and ‘I’ modules) from very high to low severity.
• Involved in assisting Business with Period Close Issues and Reconciliation.
• Provided Functional assistance in the Implementation of I-Receivables and Advance Collections.
• Implemented Lockboxes in AR with Chase Bank which reduced a lot of manual effort in applying Cash in AR.
• Implemented I-Payment for Credit Card Processing of Financial Transactions. This enabled credit card payment of Invoices and Orders by external customers via I-Modules.
• Implementation of Deductions in Trade Management.
• Customization of Check Printing and Remittance Advice Processes in Payables.
• Encryption of Bank Accounts from Database Tables
• Developed Outbound Interfaces to Banks to send Financial Transactions from Oracle via EDI.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.
• Increased customer/end-user satisfaction by developing programs which helped in automation of Business processes.
• Provided End User trainings and transition on newly implemented business processes. Also provided assistance in helping user to understand standard ERP business definitions.
• Actively involved in executing technical design and sizing on proposed enhancements. Also involved in scoping and designing of the project from the scratch.
• Coordinated and performed code review of deliveries from offshore team.
• Involved in Source Code Management using CVS.
• Responsible for executing projects though complete project lifecycle of requirement definition till go-live. Managing schedules, resources for the project and interacting with end users and other stakeholders for project delivery.
• Involved in unit testing, module testing and integration testing. Handled Customer teleconference pertained to Oracle TAR (Technical Assistance Request) support and Status review meetings.

Client: Confidential Apr 2007 – Aug 2007
AR/Ireceivables Consultant – 11.5.8 to 11.5.10 – Technical Upgrade
Employer: Keane India

Environment: Oracle 11i (11.5.10), Database Oracle 10G, Windows XP professional.

Confidential has been a leading player in healthcare product and services in the UAE since its foundation in 1969. It was one of the first companies to have started pharmacies, private clinic and healthcare marketing and distribution services in the country. The company has intensive operations into the main sectors of the healthcare industry, providing advanced distribution and marketing services in the field for the whole of the UAE.

Roles & Responsibilities:

• Involved in Gulf Drug Establishment (GDE) –an R11 Upgrade assignment in the capacity as Techno - Functional Consultant.
• Conducted Oracle standard functionality and GDE specific business process testing for AR,AP and I-Receivables modules for R11 upgrade.
• Involved in System Integration testing and supported UAT.
• Provided end user trainings and transition on newly implemented business processes. Also provided assistance in helping user to understand standard ERP business definitions.

Client: Confidential Jan 2006 – Mar 2007
Functional HRMS Consultant
Employer: Keane India

Environment: Oracle 11i (11.5.10.2), Oracle 9i, Windows XP professional, CVS, Oracle Report Builder 6i, Workflow Builder.

Confidential is an Investment which offers Investment management, Retirement planning, Brokerage, Human resources and Benefits outsourcing services to more than 22 million individuals and institutions as well as through 5,500 financial intermediary firms.This Project was mainly into managing of Advanced Benefits and Payroll for Confidential’s clients in North America. Some of the prestigious clients of Confidential included GM, Pfizer, and Bank of America. This Project included the implementation of Annual Enrollment (period of electing yearly benefits) for different clients for period of 10 months and dealing with maintenance of post implementation issues.

Roles & Responsibilities:

• Complete End to End Implementation of core HR and Oracle Advanced Benefits for a group of Confidential’s clients. the implementation was carried out at Confidential’s location which included a complete life cycle.
• Implementation included setting of New Benefit structure (Program, Plan Type, Plan and Options) as per the client’s requirements. The setup also included Life Events, Rates and Premium Setup.
• Involved in the migration of Client’s employees into Oracle for maintaining core HR and Benefit related data.
• Extensively developed interfaces to Load Rates and Premiums for corresponding Benefits Structure
• Involved in the setup of Carrier Extract definitions and Payroll Extracts.
• Extensively used Oracle 6i Reports, Discover and also XML reportsfor reporting purposes.
• Handling of Functional and Technical Support issues across Core HRMS and OAB (Oracle Advanced Benefits) post implementation.
• Provided End user trainings for Life Events management and correction of Rate/premium Processing.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.

Client: Confidential June 2004 – Dec 2005
Technical Analyst - Implementation
Employer: Keane India

Environment: Oracle 11.5.10.2, Oracle 9i, Windows XP professional, Oracle Report Builder 6i,Workflow Builder.

Confidential ACS use to run their financials on Solomon located in UAE. Projects were tracked and managed via spread sheets. Due to the repeated control issues surrounding the projects administration and sensitive and complex nature of project accounting, there was a desire and need to implement robust and common processes and systems, to reduce redundant finance functions and to leverage the use of Oracle at ACS. Hence this project was to implement Oracle Applications for Novar by merging it with the UAE operating unit of Honeywell .This implementation included various Oracle modules like AP,AR,GL,SCM and PA.

Roles & Responsibilities:

• Involved in Complete life cycle of project from Implementation to Post go live support.
• Extensively developed reports using Oracle Reports(6i) and Discoverer(3i/10G)
• Instrumental in the development of various interfaces, conversions and other enhancements which included part of customizations in Receivables (AR) , Payables (AP) and Project Accounting(PA).
• Involved in Data migration and validation of various data from Legacy systems into Oracle.
• Designing of various database objects that include Tables, relationships, views.
• Coordinated and performed code review of deliveries from team members and peers.
• Wrote Unit Test cases and Integration Test Cases.
• Implemented Custom Error Handling to handle exceptions.
• Involved in testing & fixing bugs during Implementation.Client interaction to understand problems/needs and respond back with time lines.