SUMMARY

• Over 7+ years of IT hands on experience with System Analysis, Design, Implementation, Upgrade, Customization, Testing, Production Support and Administration of Oracle Applications Fusion and (EBS) R12/11i among different industries.
• Experience in Cloud Financials GL, AP, AR, Collections and Credit Management, CE, FA, FAH.
• Worked in Fund Accounting, Cash Accounting, Accrual Accounting (GAAP)
• Actively involved in End2End Implementation & Upgrade projects and support activities of functional modules(GL, FA, AR, AP, CM, AGIS, Purchasing, Order Management, Inventory, I - expenses, I-procurement-BTax and SLA)
• Have successfully performed various data conversions like Customer Master Conversion, Open AR conversion, Receipts conversion, Supplier Conversion, Customer payment trend conversion data mapping and data validation.
• Implemented and Supported GL, Purchasing, FA, AP, iSupplier, AR, iReceivables, SLA, AGIS, EB Tax, Collections, Credit Management, Cash Management in multi OU, multi country and multicurrency environment.
• Implemented and supported Customer Data Hub (CDH) and implemented optimum customer structure model with TCA best practices using party, party sites, accounts, account sites, Account relationships, Party relationships for making credit management, collections and channel revenue modules to work properly. DQM optimization and management and part of the data steward team.
• Act as a Business Analyst for Oracle Cloud implementation.
• Expertise in implementing and maintaining ERP based business solutions and best practices across process areas of Procure-To-Pay and Order to Cash.
• Have good understanding on Financials Cloud for GL and Payables modules.
• Manage and Maintain Oracle EBS: Impact analysis, design, development, implementation, testing, user training, reporting and process improvement.
• Deeply involved with SOX Audits and implement recommended improvements.
• Manage and development of offshore and onshore/managed resources for delivery on ERP solutions (extensions, interfaces, conversions).
• Managed Change Management Processes to manage software releases, application patching and changes to production configurations while maintaining industry standards.
• Keen ability to engage the business and SME's in order to understand, design, and deliver performance improvements to EBS system.
• Manage and troubleshoot functional and technical issues spanning multiple modules.
• Ensure current environment is operating effectively and optimized to leverage all available features.
• Work creatively and analytically in a problem-solving environment demonstrating teamwork, innovation and excellence.
• Involved in E2E activities like requirement gathering, GAP Analysis and mapping the requirements with Standard functionalities, Configuration, Documentation, Regression, QA and End user testing, Preparation of End user manuals and End user training.
• Carried out Full Life Cycle Implementation of Oracle Finance Modules and Support in different industries and various versions of Oracle R12 (12.1.3 and 12.2.6) and 11i (11.5.10).
• Ensure smooth Period end closing and GL Reconciliation activities.
• Managing day to day issues with on and offshore resources and coordination of variety of initiatives.
• Coordinating project management activities by working closely with the testing and development teams.
• Drive analysis to define Integration plans for acquired systems and data conversions to bring acquired businesses on board to the Oracle ERP system.
• Requirement Gathering, CRP, SIT, UAT, Parallel run testing, Conversions, Key User Training, End-to-End Testing, Go Live Training, Go live cutover plans and Go Live Support.
• Prepare and maintain BR100 (Configuration Documentation) MD50, MD70 (functional & technical documentation), DFD Diagrams, Use Case Analysis, Process Modelling, Data Modelling, Interface Design, Data Storage Design in developing custom RICE Objects (Reports, Integration, Conversions, Extensions, Workflows).
• Data conversions like Customer Master Conversion, Open AR conversion, Receipts conversion, Supplier Conversion, Customer payment trend conversion data mapping and data validation.
• Work with System Auditors to perform the ERP Audits and make sure the modules meet Governance, Risk and compliance standards.
• Implement and manage enhancement requests and new functionality with the business users. Provide training, documentation for the impact of the new functionality on the current business processes.
• Work directly with different Support teams, development team, Operations team and Project manager for successful delivery of new functionality in the next releases of Oracle ERP.

TECHNICAL SKILLS

Oracle Cloud: Project Portfolio Management and General Ledger

Oracle E-Business Suite R12/11i Modules: General Ledger, Accounts Receivables, Cash Management, Project Costing, Project Billing and Oracle Time & Labor

Technological Environments: Microsoft Windows, Linux

Database Tools: Toad and SQL Developer for PLSQL

Office Applications: Microsoft Office Suite (MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook)

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: and Utilities: Putty, SQL Developer, TOAD, SVN, HP Quality Center, Serena, WinSCP

Operating systems: Windows 7, Windows XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Boulder, CO

Sr. Oracle Finance Functional Consultant

Responsibilities:

• Worked as a Functional consultant for the implementation of Oracle Project Accounting (Costing & Billing) and integrated with other Oracle Applications such as Account Payables, Fixed Assets, Purchasing Order and Sub Ledger Accounting.
• Prepared and implemented project plans, held status update meetings with stakeholders.
• Managed internal project for Oracle e-business suite enhancements and interfaces of Oracle EBS with other systems for distribution centers, EDI, point of sales system.
• Supervised functional and technical resources, held weekly status meetings with project resources to ensure project is on track and critical issues are being resolved in a timely manner.
• Strong expertise in Oracle Financials.
• Configuring the Oracle Cloud Applications to meet requirements along with documenting application set- Confidential .
• As a Functional Consultant implemented the setups and configurations of the functional areas in Oracle Fusion Financials Management (General Ledger, Accounts Payable, Asset Management, Payment & Collections, Financial Accounting hub ( FAH), Accounts Receivables, Cash & Expense Management)
• Actively involved in training the client on Inventory, Order Management, Advance Pricing Management Modules and devising workflow procedures in ERP environment.
• Modifying the Existing objects like OBIEE reports, Oracle PL/SQL Packages, RDF reports which are affected with the changes in the GL Accounting program.
• Worked on the end to end implementation of Financial Accounting Hub ( FAH) - worked on configuring the various sources, setup the event model, worked on the FAH uptake process
• Integration of Sun's financial systems into Oracle's Global Single Instance.
• Giving the month end support for all financial modules for 3 operating units and worked on shifts to address all operating unit issues and helped the users through screen share to fix the issues.
• Testing any changes in Oracle, NOETIX, Vertex, and E- Biz tax.
• Configure setups for AR, Fixed Assets, Project Costing, Financial Accounting hub (FAH), Project Billing, GL and CM.
• Reconciled converted Financials for 2 countries across the globe which included Revenue, invoices, costs, budgets, agreements and funding transactions encompassing both financial and non-financial.
• Involvement in business requirement, GAP analysis, process mapping, solution design, configuration, customizations, user training for Oracle EBS at Site level.
• Configured of key areas in Project Costing, Project Billing, Auto Accounting, suitable Business flow setups to the client.
• Provides training to business teams on Oracle R12 in account payables and payments.
• Provided custom solution to integrate third party Tax API (ADP), to Oracle EBS.
• Worked on billing events, Project costing, Budgeting and Project Management.
• Created Project Costing Concepts Expenditure Item Date Accounting with Common Accounting Period, Project Template and Project Type.
• Key team member of Oracle EBS 11i to R12.2.4 upgrade project.
• Managed implementation and enhancements to Business users for Oracle Financial Application Modules, AR, FA, AP and Cash Management.
• Responsible for all functional testing Order Management and Advanced Pricing Modules.
• Worked with technical resources for fixing of production issues and development of custom reports and programs.
• Prepared test scripts for oracle applications testing.

Confidential - Indianapolis, IN

Oracle Finance Functional Consultant

Responsibilities:

• Involved in the Retro fitment of 70 custom interfaces from 11i to R12 upgrade.
• Taking care of Oracle EBS related development and retro fitment activities.
• Working closely with onsite counterpart and client SME and involving in requirement analysis, design, build, production deployment phase and in translating business needs to solutions.
• Developed Purchase order report, Sales Order Report and many custom reports using XML Publisher.
• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API's.
• Worked intensely on customer import from third party system (MIDAS) and updating them in Oracle to interface them into TCA API's in AR.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Ordered from legacy system.
• Extensively worked on various product specific bugs in Oracle cloud ERP applications, during the various rollouts by extensively testing the core functionality and work in collaboration with Oracle support for issue resolution to reduce the overall impact on the implementation deadlines.
• Monthly Information Statement MIS preparation about specific expenses for Management's internal purpose by data mining in ERP Oracle Application.
• Responsible for all functional testing Order Management and Advanced Pricing Modules.
• Worked with technical resources for fixing of production issues and development of custom reports and programs.
• Developed a XSL template for customizing the PO document XML/BI Publisher.
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in INV, WMS, OM, PO, BOM & WIP Modules. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications

Confidential - Parsippany, NJ

Oracle Finance Functional Consultant

Responsibilities:

• Worked on 11.5.10 to R12 upgrade project, involving moving the finance modules - GL, AP, AR and PA to R12 version, which included data extraction, conversion and interfacing and validation of trial balances on these modules.
• Working as Oracle apps Finance functional lead consultant responsible retro fitment and Fit Gap analysis of various Financials modules like Accounts Payable, Accounts Receivables, General Ledger, modules between 11.5.10 and R12.2.4 version of Oracle Apps,
• Requirements gathering, fit gap analysis with Standard Oracle apps functionality.
• MOAC Responsibility design.
• Prepared Functional and solution design documents for Custom components
• Done the Setup Related Changes for Oracle R12 Financial suite of products
• Wrote SQL scripts to assist in the identification of Projects revenue issues such as to verify the information contained in the PA-AR invoice interface.
• Functional Testing for Configuration done for various changes for custom and standard oracle components
• Working with Oracle support for standard oracle related bug/issue resolution for Oracle R12 Upgrade Related issues
• Involved in UAT testing Cycles, with issue trackers and SME's sign off.
• Assisted in developing and testing soft.
• Provided the application support for Project Accounting on regular basis and as well in PA closing time
• Import/Clear All Receivables interfaces.
• Ensure that the Create Accounting program in Receivables has successfully completed and resolving any issues that arise.
• Reviewed the Un-Posted Items reports to confirm that all items are posted to the General Ledger

Confidential - Morrisville, NC

Business Analyst

Responsibilities:

• Provided analysis, design, installation, setup and rollout of Oracle 11i Order Management Logistics, Manufacturing module and established proof-of-concept.
• Setups included Multi Language, Multi Reporting Currency, Multi Organization
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules
• Developed interfaces and data conversion programs for applications
• Addressed operational problems, concerns, and questions posed by users
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Setting up profile options values (standard and custom), set up for OM, AR and PO.
• Involved in Inventory org setups.
• Was involved in the 4-D methodology (Discover, Design, Develop and Deploy).
• Preparing technical specifications for the sub modules like (Customers, OM, Shipping, Interfaces, etc.).
• Implementation methodology documentation including technical specs and functional specs.
• Liaising with client key users and technical team, conducting CRP/testing
• Ensuring order Processing/Booking (OM) during month/quarter/year end and resolving inter-company accounting issues.
• Responsible for transfer of data from External systems like Web, EDI, PO to OM.
• Responsible for transfer of data from OM to AR and ensuring no records are stuck in the interface.
• Resolved issues related to flex fields and sysadmin setups.
• Design of custom forms and extensions for OM and PO module.