SUMMARY

• 8+ years of total IT experience as an Oracle EBS Finance consultant
• Ability to learn and adapt to new technologies and processes with changing client needs
• Analyze enhancement requests from clients, identify dependencies, propose solutions to technical teams and deliver within scheduled timelines after rigorous testing.
• Solution - driven professional with extensive experience in implementing functional solutions
• Experience in all phases of Software Life Cycle Such Planning, Analysis, Designing, Development, Testing, Documentation and Post go-live support
• Good hand in requirement gathering
• Functional testing for new enhancements
• Expertise in SQL and PL/SQL programming, proficient in writing stored procedures, functions, packages and triggers.
• Good hands-on experience in UNIX Shell scripting
• Creation of business documents (Technical and Functional) CF250, BR100, BR110, MD070 and MD050
• Competent in managing R12 ERP Oracle Apps finance: AP, AR and GL and Oracle SCM Oracle Procurement, Purchasing and Service contracts with working knowledge of ASCP and FAH
• Worked on tools PUTTY, WINSCP, Tortoise SVN, TOAD, SQL Developer, PL/SQL Developer, Dell Boomi
• Developed dashboards on Tableau
• Expertise in Oracle R12 Upgrade
• Expertise in Oracle BI/XML Publisher reports
• Excellent interpersonal & communication skills

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Providing rapid and accurate analysis of production issues (including solution tracking) Reproduce, troubleshoot, resolve, and escalate issues, as necessary.
• Working on Jira, Kanban Board and Service Now incidents
• Own and drive production issues related to AP, AR, GL and PO from start to finish.
• Bill Presentment Architecture - Developing and maintaining this functionality for invoice print
• XML Gateway - Dealing with sending and receiving e-invoices.
• Bug Fixing - Identifying and fixing bugs in the existing code to ensure a smooth integration between Oracle and other systems.
• Enhancement and debugging issues related to interfaces (AR, Bank Statements, AP, and GL)
• Understanding business pain areas and building custom solutions for the same.
• Development of complex XML Publisher reports. E.g.: PPE Report, Revenue Reconciliation report, Customized trial balance etc.
• Changes to the existing discoverer reports and converting them to BI/XML Publisher
• Worked on service contract creation from third party systems (Salesforce) and flow from OKS to AR
• Building proactive programs for early issue detections and smooth period closure.
• Extensive understanding and experience analyzing and working on interfaces/integrations between Oracle, Salesforce, and legacy systems.
• Enhanced and bug fixed Purchasing interface
• Extensively worked on TCA
• Working actively on improving expense reports uploaded from third party system.
• Working with Oracle on Service Requests for resolving Data Corruption or standard bugs
• Involvement in month-end/period closure activities and resolution
• Proactively identify project technical risks and mitigation strategies.
• Designed and developed custom tables, PL/SQL API, Data Conversion SQL Loader Program to import data related to inventory from NetSuite for reporting purposes.
• Defining concurrent programs, executable, forms, request set, values sets.
• Enhanced and customized the existing process to import AR customer and receipts created through third party
• Handle urgent escalation issues, ensuring accurate prioritization based on severity and user impact.
• Enhancements - Deliver ad-hoc and planned enhancement requests on time

Confidential

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Provide detailed task planning, effort estimation and progress tracking to the project manager
• Lead - Code migration and testing activities
• Participate in change management
• Manage business expectations and ensure customer satisfaction
• Interacting with End Users, Business Users and Business Team to meet End User’s expectations
• Retrofit of finance objects mainly interfaces related to GL import, AP Suppliers, AR Receipts, and customers
• Made changes to RDF and BI/XML Publisher reports as per R12 functionality
• Converted discoverer reports to BI/XML Publisher reports
• Used Confidential inbuilt tool to recognize and analyze objects needing retrofit
• End to End Testing of the CEMLIs
• Timely resolution of defects raised during SIT and UAT phase
• Diligently work with the end user at various stages of upgrade to analyze the defect and provide appropriate resolution for AP and AR modules
• Performing Technical and Functional testing of the new Finance objects related to AP and GL
• End to end functional as well as technical testing and documentation of retrofitted objects
• Developed interfaces related to purchasing, supplier and GL with PL/SQL and shell script
• Carried out Item and supplier conversions with PL/SQL and shell script
• Carried out setups related to Supplier
• Made changes to the PO Print report
• Form personalization customizing AP Invoice workbench and AR Receipts
• Developed complex BI/XML Publisher reports related to GL-Account Analysis, AR, AP, Projects, and Inventory
• Performing Technical and Functional testing of P2P Business Cycle Flows
• Developed test cases for Oracle Cloud Payables
• Carried out end to end testing of P2P cycle on Oracle Cloud
• Tested changes related to Payment Process Profile on Cloud

Confidential

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Analyzing As-Is Process and presenting the As-IS TO-Be business process to the client
• Requirements gathering and feasibility analysis
• Effort estimation
• Task assignments
• Mentor the offshore team
• Code review to make sure it is dynamic and aligned with the business standards