SUMMARY

• Having overall 9+ years of working experience as Oracle Techno Functional Financial Consultant & has performed variety of roles such as Implementation Consultant, Production support analyst, and Tester.
• Have technical and functional knowledge in modules like Account Payables, Account Receivables, Order Management (O2C - Order to Cash), General Ledger, and Inventory.
• Extensive experience and knowledge of Business Processes across the E-Business Suite Financials, General Ledger (GL), Subledger Accounting (SLA), Accounts Payables (AP), Accounts Receivables (AR), E-Business Tax (with 3rd party tax setup like GST), Inventory (INV), and Order Management (OM).
• Worked on EBS Webpages, built new pages, and extended the standard oracle pages using Java based OAF framework.
• Have technical expertise in Form Personalization and customization for R12, PLSQL, XML Publisher reports, Unix Scripting.
• PL/SQL Development: Wrote custom program to process data from data file and load into base tables.
• Strong programming experience with SQL, PL/SQL and UNIX - Shell Scripting
• XML Publisher: Report changes, fixed calculation problems, added labels/fields.
• Developed custom menus and responsibilities.
• Expert in defining multi org access control in financial modules and giving access to end users on specify operating unit.
• Experience in maintaining documentation and using the Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process, Gap analysis and providing solution design and building RICE components as a part of fit-gap analysis, System configuration and testing (BR100, MD50).
• Expertise in analyzing current business processes, determining system requirements, reporting needs, GAP analysis, developing customizations and configuring applications to match those needs while incorporating the oracle best business practices.
• Extensive experience with testing, conducting Conference Room Piloting sessions (CRPs), User Acceptance Testing (UATs), status tracking and production go-live cutover.
• Extensive experience in resolving issues as per Service Level Agreement (SLA).
• Expertise in documenting business requirements, analyzing impact of the changes, preparing functional, technical specifications, developing, configuring, and performing unit testing as well as assisting the users in the UAT phase, all this following oracle AIM methodology.
• Extensive experience in R12 Implementation, Customization, and Support for Oracle Applications using Oracle development and reporting tools like SQL, PL/SQL, XML Publisher, Shell Scripting, Oracle Forms and Reports, SQL*Loader and WebADI.
• Expertise in design and development of RICE components.
• Extensively supported Financials users by troubleshooting and resolving various issues which includes supplier creation, supplier validation before make payment, supplier bank accounts validations, payment processing, and account payables period closing activities.
• Extensive experience in month end closing of Financial Modules and Reconciliation between Subledgers and General Ledger.
• Experience organizing meetings with business and follow-up on pending items with business and other team members to the deliverables within the specified timelines, have done aggressive follow-up with Oracle Technical support for all open service requests to get it resolved within stipulated time to reach timelines.
• Well-developed Interpersonal and Communication skills with excellent documentation and presentation skills to work as part of a team with aggressive time schedules.

TECHNICAL SKILLS

Oracle Applications: R12, Oracle General Ledger, Oracle Receivables, Oracle Account Payables, Oracle Order Management, Oracle Inventory, Oracle Assets, Shipping

Oracle Administration: AOL, SYSADMIN, Shell Scripting, WebAdi

Oracle Tools: Reports 6i/10g, Forms 6i/10g, BI/XML PUBLISHER

Database: Oracle 10g, PL/SQL, SQL.

Developer Tools: TOAD, SQL*PLUS, SQL* Developer, SQL*Loader

Operating Systems: HP-UX, AIX, SCO, Windows NT 4.0/2000/XP, Win 95/98/3.1.

PROFESSIONAL EXPERIENCE

Oracle Techno Functional Consultant

Confidential, IA

Responsibilities:

• Setup and implement the following modules - AR, GL, Order Management, Inventory
• Worked extensively on Data conversions in various modules as Sales order conversion.
• Involve in Gap Analysis, Documenting Requirements, Functional Setups, Interface design, migrating setups and all phases of RICE Implementation.
• Used different publishing methods using BIP templates including XML bursting, e-text, RTF and developed various Financials reports
• Designed and developed custom functionality on Oracle financial module.
• Create AIM docs MD050 based on BR100 requirement document.
• Responsible for handling Finance modules - AR, GL.
• Developed custom WebAdi Upload integrators.
• Built an interface between Oracle ERP and an external credit card authentication vendor using Java/SQL/PLSQL.
• Worked on the Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Developed automated scripts to create Sales Order for Spares New Buy Transactions and Hardware order from Oracle EBS to Oracle Fusion in OM.
• Worked on the Auto Invoice Process in AR Module.
• Responsible for Oracle Financials R12, General Ledger (GL), Accounts Receivables (AR) setups in DEV, Test, UAT and Production environments.
• Did end to end testing of Spares Intercompany transactions from Oracle EBS to Oracle Fusion
• Preparing and reviewing Technical and Functional Documents.
• Involved in the Setups of Revenue Recognition including the setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up the Daily Revenue Rule that are new in R12.
• Recommend configuration changes to improve functionality of Oracle applications.
• Responsible for all Oracle Subledger Accounting (SLA) changes and customization to meet the business requirement.
• Provided data conversions extracts to implementation partners as part of Oracle EBS to Cloud Fusion migration.
• Written Unix Shell Scripting for FTP process.
• Working knowledge of Oracle Application Framework (OAF): personalization, html pages, and java class extensions within the context of the Oracle e-Business Suite.
• Responsible for end-to-end flow of accounting in all the Oracle Subledger modules.
• Involved in resolving any critical issues and helping the customer support team and knowledge transfer.
• Developed custom menus and responsibilities.
• Development of oracle inbound and outbound interfaces to process Legacy invoices to AR, AR open transactions to banks for factoring and Web ADI to create bulk transaction adjustments.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Working on implementing and developing technical solutions in the EBS application along with appropriate functional setups and configurations required
• Preparing Functional and solution design documents for Custom components and doing the Setup Related Changes for Oracle R12 Financial suite of products
• Worked on the Functional mapping of data Conversions & Enhancements for OM, INV, AR, and GL modules.
• Designed and developed data cleansing, data validation, load processes using Oracle SQL and PL/SQL and UNIX.
• Deliver and review inbound and outbound interfaces across various data entities
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Successfully provided Technical and Functional support to the users, testers, and Business System Analysts.
• Prepared APPWORX setup document to schedule the Oracle concurrent requests.
• Go-Live Cutover and Oracle Data Migration (Sales Order Conversion, AR Invoices).
• Postproduction support and knowledge transfer (KT) to customer support team.

Environment: Oracle EBS 12.1.3, O2C cycle, GL, AR, UAT, SIT, BR100, Unix, Appworx, Java, GitHub, WinSCP, PL/SQL Developer

Sr. Oracle EBS Consultant

Confidential, Chicago IL

Responsibilities:

• Provide technical and functional support in production environment particularly in the GL (General Ledger), AP (Account Payables) modules.
• Provide support in resolving Incidents (Tickets/Issues) as per Service Level Agreement (SLA), also creating new Service Requests (SR’s) if necessary, in Meta link to solve the issues by applying additional Patches/Data fixes when required.
• Production Support to take care of smooth functioning of Oracle EBS Financial modules as well as work on Change Requests (CR’s) to bring out enhancements in the system.
• Responsible for Oracle Financials R12, General Ledger (GL), Accounts Payables (AP) setups in DEV, Test, UAT and Production environments.
• Wrote Unix Shell scripts to process PL/SQL scripts on daily basis and load data into the User Defined tables or create files based on the project requirement.
• Configure and Test EBS application and custom software components for effective Solution design of Oracle EBS Financials solution
• Gathering the Requirements from Client, and mapped client requirements with oracle payables.
• Preparation of business test scripts and tested all business cases.
• Worked on Improvement and Query tuning of existing system.
• Responsible for Oracle Financials R12, General Ledger (GL), Accounts Payables (AP) setups in DEV, Test, UAT and Production environments.
• Period Close for Account Payables, Quarter Closure and Year End Closure Experience.
• Apart from resolving day to day incidents, taking care of Oracle Month End period closing and reconciliation of Oracle Subledgers with General Ledgers.
• Classification of Incidents, generating monthly statistics, presenting to the business IT team, and taking appropriate actions like giving user training/sending weekly emails by giving process details where users need to take action to avoid errors.
• End user training and updating of user manuals when changes in the process or new processes are built and new users onboarded.
• Worked extensively in Oracle development tools and utilities, including PL/SQL, XML Publisher, Inbound/Outbound interfaces.
• Handling all client-facing activities like requirements elicitation, business consulting, presentations, etc. in developing new Reports and enhancements.
• Preparation of Oracle Standard Operating Procedure (SOP) documents and User training.
• Raising Technical Assistance Request (TAR) with Oracle Support
• Testing the patches received from Oracle in Non-Production Environments
• Application of patches in the Production environment.
• Root Cause Analysis (RCA) of the problem
• Making the required setup changes and test the same in Non-Production Environments
• Applying the set-up change in Production Environments
• Preliminary & Feasibility study of new requirements
• Implementation, testing of CRs and deployment.

Environment: Oracle EBS 12.1.3, AP, GL, SLA, E-Business Tax modules, Unix, Java, UAT, SIT, BR100, WinSCP, TOAD

Oracle Techno Functional Consultant

Confidential

Responsibilities:

• Worked on development of interfaces, Data conversions.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Involved in customer conversions to load customer details into HZ tables by creating staging tables and performing validation and finally loading them into base tables using TCA APIs.
• Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches and Bank Accounts, etc. from legacy system to Payables.
• Responsible for Journal Imports from all other modules like Account Payables (AP) and Account Receivables (AR) into General Ledger (GL).
• Implemented several custom logics for Form Personalization using Zoom functionality
• Used FNDLOAD to migrate concurrent programs, request sets, forms menu and personalization by downloading LDT files.
• Debugged complex PL/SQL Interface programs.
• Setup alerts to monitor record counts and errors in AP/GL interface tables.
• Expertise in System Administrator responsibility to create users, responsibilities, value sets and request sets.
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Submitted Service Request with Oracle Support in different scenarios for providing solutions to the bugs identified during Production support, resolved various bugs, working in collaboration with Oracle support.
• Used Bulk Collect feature to improve performance.
• Developed PL/SQL procedures, functions, packages to validate the data and insert the validate data into Oracle Standard interface tables.
• Proactively tuned SQL queries and views using Explain Plan, Hints and indexes and SQL trace.
• Setup of On Demand Invoicing features, Configuration and implementation of fixed assets, XML Gateway transmissions in Oracle AP.

Environment: Oracle E-Business R12, TOAD, AP, AR, GL, PL/SQL Developer, XML Publisher