Summary




4 years of IT experience in roles like Functional Consultant and Business Analyst, 2 years in Oracle Applications Financials ; Release 11i and 12.
Exposure across wide range of industries like Business Intelligence, Telecommunication, Technology, Education and Gas and Oilfield.
experience in Procure to Pay P2P and Order to Cash O2C business process.
Involved in 2 implementation projects and 1 production support project of Oracle E-Business Suite.


Employment

March, 2009 -  July, 2009
Oracle Financials Business Analyst

The main project focus was to make Oracle Application SOX compliance and remove the various inconsistencies in the Application database in regards to active user profiles, responsibilities, duplicate menus/functions etc. Leverage IT team to focus on technical and true development activities and increase functional subject matter experience of Business team. Served as primary contact between the technical team and the management. Suggested best practices that should be followed in setting up security for Oracle Financials that were lacking in the current system.
Environment : Oracle EBS 11.5.10, R12, Oracle GL, AP, AR, PO, Toad, Discoverer, FSG, Oracle Reports 6i, BI Publisher formerly XML Publisher.

March, 2008 -  February, 2009
Oracle Financials Functional Consultant

Operations and maintenance support for Oracle Financials 11.5.9. Testing of iExpense module and its integration with Projects and Payables ; designed and customized its approval adjustment and approval routing workflow. Involved in requirement gathering, GAP-Analysis, CRP, test plan cycle and UAT. Extensively worked on Discoverer tool for designing various reports and worked closely with HR team in keeping Application SOX compliance. Team leader for O and M support for the following modules PO/AP and AR.
Environment : Oracle Apps 11.5.9, GL, AP, AR, PO, CM, FA, OM, iExpense, Discoverer 4i and Toad.

July, 2007 -  February, 2008
Oracle EBS Functional Analyst

Assisted the functional and technical team of Financial Services in a project to recover the financial application and correct or re-implement the current application. My role was to provide guidance in recovering the existing financial application and identify mechanisms by which they can carry forward with the re-implementation without detrimental impact on day-to-day operations. Detailed design of Global Chart of Accounts, Intercompany Accounting and Accounting flex fields. System testing and documentation for re-implementation of Oracle release 11.5.10 core financials : Accounts Receivable, Accounts Payables, Oracle Purchasing and iProcurement. Prepared and wrote User Acceptance Testing UAT scenarios and scripts. Created business area, custom folders and configured security privileges with help of Discoverer Administrator tool.
Environment : Oracle GL, AP, AR, FA, Oracle EBS 11.5.10, TOAD, SQL Loader, ADI.

June, 2005 -  July, 2006
Business Analyst

John Energy is a part of John Group of Companies that concentrates in providing outstanding services in the arena of Oil and Gas Field. It s also the first Indian Company to implement Microsoft s Navision ERP.
My role : Identified high-level requirements for developing and documenting business requirements, writing scope documents and Use Cases. Utilized Rational Unified Process RUP to create use cases, activity, class diagrams and workflow process diagrams. Developed process models, business policies etc. Prepared Test Plans based on these documents, tested functionality of the application using WinRunner. Written complex SQL queries to test the Backend functionality of the application.
Environment : Oracle, MS-SQL, UML, Rational Tools, Clear Quest, Test Director, Office Suite, MS-Visio and Project.

August, 2006 -  July, 2007
Graduate Teaching Assistant

Provided complete Desktop support and technical assistance to the Information Technology unit in Mason, the faculty and staff on campus, 5 labs with more than 350 workstations. Installation, configuration and troubleshooting of print servers and network printers. Maintenance of Active Directory, Network groups and domains. Addressed issues that came in through Mason Enterprise Services Architecture MESA ticketing system.

Education

Training

CISCO
Certified Network Associate CCNA
Advance Networking Protocols in Telecommunication ANPT


Skills


Oracle Applications 11i 11.5.9/11.5.10, Release 12 Oracle E-Business Suite Oracle Financials : General Ledger GL Payables AP Receivables AR Purchasing PO Fixed Assets FA Cash Management CM iExpense iProcurement PL/SQL SQL*Plus Shell Scripting Perl UML C/C++ VB. NET Application Implementation Methodology AIM Discoverer FSG Oracle Reports ADI, SQL Loader Workflow Builder BI/XML Publisher Toad Linux/Unix Windows 7/Vista/XP Windows Server 2000/2003 Apple OS X
Excellent functional experience in Oracle GL, AP, AR, PO, CM and iExpense.

Knowledgeable in Order Management OM, FA, Projects, OBA, E-TAX.
Extensive experience in all life cycle stages of implementation, Requirement Gathering, Solution Design, GAP Analysis, Custom Development, System Configuration, Test Plan Cycle, CRP, UAT, Cut-Over and project co-ordination activities. Thorough understanding of Generally Accepted Accounting Principles GAAP, Business Accounting theories, practices and financial business processes.


Miscellaneous

Quality Analyst, Summer Intern Summer 2003 Summer 2004
John Energy Ltd, Ahmadabad, Gujarat India
Involved in User Acceptance Testing UAT and interfaced with automation team to ensure the automated scripts comply with system test requirements. Created and maintained Rational Repositories using Rational Administrator. Extensively used SQL Queries for data handling in back end testing.