SUMMARY

• Having overall 8+ years of working experience as Oracle Techno - Functional Financial Consultant & TEMPhas performed variety of roles such as Implementation Consultant, Production support analyst, and Tester.
• Has 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 teh 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).
• Has technical expertise in Form Personalization and customization for R12, PLSQL, XML Publisher reports, Unix Scripting.
• 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 teh 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 teh 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 teh changes, preparing functional, technical specifications, developing, configuring, and performing unit testing as well as assisting teh users in teh UAT phase, all dis 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 teh deliverables within teh specified timelines, has 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, OracleReceivables, Oracle Account Payables, Oracle Order Management,Oracle Inventory, Oracle Assets, Shipping

Oracle Administration: AOL, SYSADMIN, Shell Scripting

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

Sr. Oracle EBS Techno Functional Consultant

Confidential, Round rock TX

Responsibilities:

• Setup and implement teh following modules - AR, GL, Order Management, Inventory
• Involve in Gap Analysis, Documenting Requirements, Functional Setups, Interface design, migrating setups and all phases of RICE Implementation.
• Designed and developed custom functionality on Oracle financial module.
• Create AIM docs MD050 based on BR100requirement document.
• Responsible for handling Finance modules - AR, GL
• Worked on teh Setup of OM module - including defining of Transaction Types, Price Lists, Defaulting Rules and Processing Constraints.
• Worked on teh 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.
• Preparing and reviewing Technical and Functional Documents.
• Involved in teh Setups of Revenue Recognition including teh setups of Invoicing and Accounting rules, setting up deferred revenue rules, setting up teh 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 teh business requirement.
• Responsible for end-to-end flow of accounting in all teh Oracle Subledger modules.
• Involved in resolving any critical issues and helping teh customer support team and knowledge transfer.
• 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 teh above modules.
• Preparing Functional and solution design documents for Custom components and doing teh Setup Related Changes for Oracle R12 Financial suite of products
• Worked on teh Functional mapping of data Conversions & Enhancements for OM, INV,AR,and GL modules.
• Deliver and review inbound and outbound interfaces across various data entities
• Jointly worked with teh QA team in formulating teh Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Successfully provided Technical and Functional support to teh users, testers, and Business System Analysts.
• Prepared APPWORX setup document to schedule teh 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, Appworx, GitHub, WinSCP, PL/SQL Developer

Sr. Oracle EBS Consultant

Confidential, Chicago IL

Responsibilities:

• Provide technical and functional support in production environment particularly in teh 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 teh 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 teh system.
• Responsible for Oracle Financials R12, General Ledger (GL), Accounts Payables (AP) setups in DEV, Test, UAT and Production environments.
• Gathering teh 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 teh 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 teh 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.
• Issues related to System Defect:
• Raising Technical Assistance Request (TAR) with Oracle Support
• Testing teh patchesreceived from Oracle in Non-Production Environments
• Application of patches in teh Production environment.
• Issues related to Process:
• Root Cause Analysis (RCA) of teh problem
• Making teh required setup changes and test teh same in Non-Production Environments
• Applying teh set-up change in Production Environments
• In case of Change request:
• 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, 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.
• Expertise in System Administrator responsibility to create users, responsibilities, value sets and request sets.
• Developed custom templates for teh invoice reports by calling sub templates in XML/BI Publisher.
• Submitted Service Request with Oracle Support in different scenarios for providing solutions to teh 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 teh data and insert teh 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