Summary

8 years of experience in various phases of Software Development Life Cycle including requirement gathering & analysis, architecting, design, development, testing, implementation and maintenance usingOracle Application.

• Over 8 years of experience as an Oracle Apps Finance-Functional and Project Costing and Billing Consultant primarily working on Oracle 11i & R12 Financials modules like AP, AR, FA, Projects Costing and Billing, GL, PO and System Administration. Over a year of overseas experience working directly with business users at Chicago, USA and Amsterdam, NL.
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) cycle, Fixed Asset to GL and Account Generator Workflow.
• Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Technical responsibilities include: interfacing the Modules, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing, documentation and providing production support.
• Experienced in implementation, customization and Application support activities of Oracle Apps 11i & R12 Financial modules (GL, AP, AR, FA) using AIM implementation method & integration with Inventory modules (PO, OM, INV).
• Responsible for resolving critical Functional Issues related to financial module like (AP, GL, FA and Sys Admin. Setups in PROD Instance. E.g. Calendars, Currency Rates, Chart of Account (COA), Cross Validation Rule and Security Rule Maintenance.
• Working with Different Functional & Technical teams to support existing systems and implement new systems, processes and procedures. Research, evaluate and establish business processes associated with ERP.
• Performed fundamental administrative tasks including registering applications and reports, defining new users, responsibilities, profiles, menus, and setup value sets in the application.

Technical Skills

• ERP: Oracle Applications (R11i), (AP, AR, FA, PO, Project Costing and Billing, Cash Mgmt, Oracle Alerts and AOL)
• Oracle Tools/Components: Pl/Sql Developer, Data Loader, Remedy
• Languages: SQL, PL/SQL
• RDBMS: Oracle 8i, 9i
• Environment: UNIX, MS Windows 98/NT/2000/XP
• Functional Domains: Financial Services

Education

• Bachelor of Engineering (B.E.) in Information Technology

Professional Experience:
Currently I am working with a Foreign MNC IT services company at Mumbai as Senior Consultant. Prior to this I served Tata Consultancy Services for 5 years and 8 Months as IT Analyst.

Project Details:

Client: Confidential , Amsterdam, NL. Duration: Jul2011 - Till date
Project: Confidential
Role: Oracle Apps Finance Functional Analyst

Confidential , is a part of Canon Europa, Netherlands Oracle Apps Production support and Enhancement project, which deals with the existing system support and new initiatives and activities carried out for various business applications. As a part of this assignment, I have worked on financial modules like Fixed Asset, Oracle Cash Management, General Ledger, Payables and Receivables and reinforcing my functional knowledge of Oracle Financials.

Responsibilities:

• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Involved in doing various setups and preparing mapping document BR.030 and setup document BR.100for Canon Portugal Financial modules.
• Testing of various test scenarios of Quote to Cash, Requisition to Purchase Order cycle in Oracle Purchasing. Working on various Alerts related issues.
• Involved in functional testing of various bug fixes.
• Prepare issue and risk tracker and submit to client weekly basis.
• Worked with technical team to resolve / provide technical issues.
• Writing / executing scripts to perform various extracts from database.
• Handling daily tickets related to various user problems in FA, AP, AR, GL, CE modules
• Working on CR's (Understanding the requirement, prepare understanding document, prepared technical design document, preparing test cases and UAT).
• Fully involved in month end closing process of financial modules.
• Raising SR on Oracle metalink for various issues related to OKL, AR, AP and GL.

Client: Confidential , UK. Duration: Sep, 2010 - Jul2011
Project: Confidential
Role: Oracle Apps Finance Functional Analyst

Confidential , is a Confidential , UK Oracle Apps Enhancement project, which deals with the new initiatives and activities carried out for various business applications. As a part of this assignment, I have worked on financial modules like Oracle General Ledger, Payables and Receivables and reinforcing my functional knowledge of Oracle Financials.

Responsibilities:

• Prepare MD-50(Functional design document) for the various reports and Interfaces which includes AR Invoice, Statements and AP invoice Interface.
• Daily tasks included attending meetings with the client project manager and review the project status.
• Test the various reports with the help of TE30 (Test Cases).
• Preparation of GL extract for the legal Audit purpose.

Client: Confidential - USA. Duration: Jan 2009 - Aug. 2010
Project: ASM Domestic/International
Designation: Team Lead

ASM Domestic is a part of Confidential and Confidential . support, which deals with maintenance and production support activities carried out for various business applications. Being in this project, I have worked on financial modules like Oracle General Ledger, Payables and Fixed Asset, i-Procurement (Release 11.5.9, 11.5.10.2), reinforcing my functional knowledge of Oracle Financials. A Brief detail of our client's portfolio is as follows.
Responsibilities:

• Developed AP Invoice Interface:
• Took the requirement and proposed the solution to the business users.
• Populated data into interface tables AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE by using standard and custom validations using PL/SQL procedures.
• Customized the workflow for FA Account Generator Process "TRU Generate Default Accounts" with new custom settings for UK instance.
• Resolved the issues related to security rules which were affecting the FSG reports.
• Worked on the issue where the drill-down from the GL to the FA Sub-Ledger was not available.(Found bug in the Oracle Standard system).
• Developed a new SQL script to extract all the assets data.
• Daily tasks included attending meetings with other team managers, review and approval of technical design documents and technical mentoring of team members on Oracle tools and applications products.
• Supported all the production environments and users on a daily basis by responding to emergency requests.
• Developed new SQL reports, customized and optimized existing ones in Accounts payables
• Support Analyst tasks included the management of the complete TAR life cycle, troubleshooting end user problems, development and delivery of training for key users.
• Worked closely with clients, achieving outstanding results at all full life cycle of the systems - data modeling, process analysis, programming and testing, delivery, training and maintenance.
• Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables

Confidential- USA. Duration: Oct 2007 - Dec 2009
Project: Terex Management System (TMS)
Role: Oralce Apps Fixed Asset Implementor

Terex has initiative called TMS for its ongoing Oracle Apps implementation at various sites across the globe. Terex uses Oracle apps to manage their Financial, Manufacturing, Supply Chain and Employee.

Responsibilities:
I worked as a Techno-Functional consultant and my task includes requirements gathering, Implementation, Migration, helping user with UAT and regular interaction with users for analysis of the system.

Implementation of Oracle Financials:

• Implementation of the Oracle Fixed Assets and Payables applications (Release 11.5.10.2).

Customization and Migration:

• Registration of Custom Reports in Custom Top.
• Removed Hard Coded Values from Custom reports by adding Parameters.
• Loading the legacy data into Oracle database through SQL *Loader.

Organization Hierarchy:

• Knowledge of MULTI_ORG Environment.
• Design and Developed Reports in MULTI_ORG Environment.
• Registration of Custom Reports in Custom Top.

User Interaction:

• Auto-Invoice, AR and AP Invoice setup.
• Provide user training for the existing system, new updates and customized applications take place in the TMS.
• Customer and Supplier creation and related set up.

Client: Confidential - India
Duration: Dec 2004 - Sep 2007
Project: Confidential
Designation: Analyst Programmer

Confidential is the project name for TCS internal IT implementation and support. The objective of which is to automate the entire business processes and function of TCS. TCS has implemented and using Oracle Project and Financials.
Responsibilities:

• Worked on Oracle Project life cycle, Billing, costing modules and Project management.
• Developed, enhance and modified the various client extensions and various interface like Projects invoices to AR and supplier invoice to AP.
• Requirement Analysis.
• Modified and created new concurrent programs as well as executables files when reports were created.
• Register using AOL registering tables, forms, reports and pl/sql procedures, functions and packages, Created executable using AOL in the developed environment
• Defining users and assigning responsibilities as user requirement
• Creating list of values, Enable DFF on form
• Involved in setup of Set of Books (Chart of Accounts, Calendar and Currency).
• Defined value sets and value set values, KFF, DFF etc.
• Involved in setting up the cross validation and security rules.
• Converted User Requirements into formal Functional specifications and Interfacing with client.
• Developed mapping documents for the columns of source application and oracle applications
• Developed stored procedures, functions and packages in augmenting the business using PL/SQL.
• Developed custom reports such as Customer Information report, User Application Responsibilities report.
• Responsible for resolving critical Functional Issues related to Financial and Manufacturing modules. Created Incremental maintenance Setups in PROD Instance.
• Working with Different Functional & Technical teams to support existing systems and implement new systems, processes and procedures. Research, evaluate and establish business processes associated with ERP.