SUMMARY

• Oracle EBS techno functional consultant with 9+ years of experience in Oracle E - Business suite(EBS) R12(Financials and Supply Chain modules), Requirements gathering and management of documentation. Software Analysis of applications with strong understanding of software development life cycle
• I mplemented Oracle E-Business suite(EBS) and configured the systems for various clients from different sectors of the industry like Manufacturing, Banking, Oil and Gas, Telecommunications etc. Some of the clients are GE Energy, KEY Energy, Dover, Colorcon (to name a few)
• Expertise in (Procure to Pay) P2P and (Order to Cash) O2C cycles.
• Helped in resolving various critical issues for the customers which involved consolidation, period close, trial balance etc.
• Well versed in documentation of Business Requirements Documentation (BRD) and Functional Specification Documentation (FSD).
• Experience in conducting GAP Analysis, User Acceptance Testing (UAT) and Cost Benefit Analysis.
• Strong understanding of the business process, Definition of the Scope of the Project, User and system requirements, and implementation to functional and technical specifications
• Expertise in SQL programming, PL/SQL programming, RICE components such as Reports, Interfaces, Conversions etc.
• Excellent presentation combined with a proficiency in problem abstraction, leadership skills, and ability to work in cross functional team gained from professional training and many years of industry related work experiences in functional areas such as client service delivery and information technology.
• Excellent interpersonal and communication skills (oral and written) and a highly motivated professional. Successful in meeting deadlines and can handle pressure while coordinating multiple tasks.
• Quick learner with ability to master new concepts and applications.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle on-site and off-shore.
• Involved in both functional and technical analysis which enables effective gap analysis and propose effective solution.
• Implementing critical code and data fixes.

TECHNICAL SKILLS

ERP Applications: Oracle Applications 11.5.10, 12.1.x,12.2.x Operating Systems Windows, Linux

RDBMS: Oracle 9i, 10g, 11g, 12c

Programming Languages: SQL and PL/SQL

Other Software Packages: MS-Word, MS-PowerPoint, MS Excel, Service NOW ticketing tool

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS functional Consultant

Responsibilities:

• Work on month end closure activities and support the users with all the issues arising during period closure in various modules like Oracle Fixed Assets, Account Payables, iProcurement, Oracle General Ledger, SLA.
• Work on ICPR testing and Oracle Incentive Compensation(OIC) end-to-end flow testing. Modify OIC setup, as required.
• Day to day activities include but not limited to, working on user enhancements, support customer issues, work on L2 production issues in Service Now.
• Conduct meetings with users regularly to understand their requirement, perform GAP analysis, suggest best approaches, prepare MD50 and work on solution development coordinating with other teams as required.
• Define Suppliers, Supplier Sites, Supplier types and pay groups to classify suppliers into various categories.
• Configure EBS application as required by the users’ business process and maintain documentation for the business process / setup.
• Troubleshooting the Period End Closings by reviewing Holds, Unaccounted Transactions, Transferring Approved Invoices and payments to GL.
• Implement WebADI for users to upload and download data in excel format.
• Work with development team during the data migration from Legacy systems to Oracle environments.
• Support iProcurement issues like setting up vacation rules, delegating approvals, running few custom reports and analysis, setting up trading partners, creating requisitions and managing approvals etc.
• Configured Inter Company set-ups and Security Rules.
• Perform functional testing of several OAF page personalizations, issues related to iProcurement.
• Monitor the production tickets logged by users in procure to pay and record to report processes.
• Analyze, review the setup based on business flow of all markets.
• Provide functional and methodological capabilities in testing the solution and obtaining business team signoff.
• Configured Asset Flex Fields, Asset Categories.
• Functional SPOC for many of the custom reports related to GL, iProcurement, Projects, FA and AP modules.
• Worked on MD50, change request documents and many test case documents.
• Prepare SOPs to share to the business users and circulate within the team as part of knowledge sharing.
• Assist peers in day-to-day activities and provide clarification of solution in detail when needed.

Confidential

Oracle EBS functional Consultant

Responsibilities:

• Worked as a functional bridge between users and technical development team for P2P modules (AP, GL, INV, OM, PO, iProcurement) in an onsite - off shore model.
• Day to day activities include perform internal analysis and implementation of R12 EBS, develop business process flows, identify the gaps and provide production support
• Prepared the Oracle Application Setup documents (BR.100), Functional spec documents (MD.050) and Technical design documents(MD120) for the new requirements
• Configuration for the creation of Account Payables invoices, tax calculation, help users make payments through payment workbench and payment manager.
• Worked on item-to-container relationship conversion related to WMS module. This conversion will help the business identify the relationship between a container item and a load item and the quantity that can be filled in the container item.
• Worked on configuring shipping networks, many modules related to O2C(Order to cash) cycle.
• Worked on XML publisher reports like Packing Slip report, pick slip report related to Shipping Execution module
• Worked on customizations of Bill of Lading report pertaining to Shipping execution as per business requirements like inserting company logo, publishing some content, removing few columns etc.
• Responsible for on-site and off-shore co-ordination for the smooth delivery.
• Responsible for resolving month-end and quarter-end closing issues.
• Worked on creating finance functional setups like account code combinations, inter-company rules etc. during different phases of the project like SIT, UAT, Production go-live.
• Provide post Go-live support.

Environment: Oracle Applications R12.1.3, R12.2.x, 11i, SQL, PL/SQL, SQL Developer, TOAD, SQL* Loader

Confidential

Oracle EBS functional Consultant

Responsibilities:

• Worked on end to end financial setups for various EMEA and North America customers
• Profound knowledge in Accounting concepts like SLA (Sub ledger accounting). Have brief understanding on inter and intracompany setups.
• Experienced in generating and understanding AP Lists, Tkprof, diagnostics, DBMS log output files, trace files with binds and without binds, locating and resolving issues.
• Communicated and collaborated with clients to analyze information needs and functional requirements
• Worked on AP, GL, CM, EbTax, iExpense modules bugs and helped customers resolve payment dashboard issues like, IBAN disappearing only the first time upon update, unable to update payment DFFs, solved issues related to payment rejections by checking on the functional flow and setup on customer’s instance through a web conference.
• Worked on L2 production service requests raised by various customers and helped in offering optimal solutions to resolve issues.
• Worked on many PPR(Payment Process Request) tickets raised by customers and provided end to end support, right from defining a PPR to making a payment successfully.
• Worked on level2 support tickets raised by various customers related to (procure to pay) P2P cycle like issues while creating purchase order, creating invoices, payments make to corresponding invoices, GL posting issues etc.
• Debugged standard and custom APIs to help customers cater to their business requirements.
• Handled many invoice workbench issues like prepayment application/unapplication, troubleshooting ‘Funds Check Hold’ issues, invoice cancellation issues etc. to name a few.
• Assisted many customers in guiding them with end to end functional setup of Separate Remittance Advice (SRA) and thereby handling most of the technical and functional issues like, occurrence of special characters in SRA, errors with “xdodelivery.cfg” file etc.
• Worked on migration of payment terms to R12 and handled related issues.
• Contributed to knowledge repository with documents on functional concepts such as future dated payments, Payment Process Request and issues faced etc.
• Handled various issues like balancing Trial Balances and worked on accounting issues (provided data fixes when transactions could not be accounted) and fixed them.
• Resolved VAT tax issues for middle east customers and helped them with end to end functional setup.
• Received a nomination for exceptional service by customers on several instances

Environment: Oracle Applications R12.1.3, R12.2.x, 11i, SQL, PL/SQL, Oracle Reports, XML Publisher reports, SQL Developer, TOAD