SUMMARY

• Strong oracle ERP professional with 11+ years of extensive experience as a Techno Functional Consultant in Oracle Applications, Developing, Implementing, Support, testing and maintaining projects' lifecycle globally.
• Exceptionally well organized with Strong Communication, Inter - personnel, Analyzing Skills and a desire to learn new technologies and tools.
• Implemented and supported various Oracle e-business suite modules: Order Management (OM), Account Payable (AP), Account Receivable (AR), Purchasing (PO), Inventory (INV), Shipping (WSH), Advanced Pricing, iProcurement, iPayments, iStore, Oracle Transportation Management, Oracle XML Gateway and AOL objects.
• Experience in technical development, Functional and maintenance of Oracle E-Business Suite R12 and 11i and Oracle Fusion Apps.
• Expertise in end to end functional flows and supported all Inbound or Outbound transactions of Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Experience on development of RICEW (Conversions, Reports, Interfaces, Extensions and Work flow) and Menus, Functions, Value Sets, Multi Org, Concurrent Programs, Lookups, Database Objects and Shell scripts.
• Worked as Support Consultant and responsible for the Tickets Handling, Issue Resolution and Enhancements/Customizations to resolve the issue.
• Experience in creating Concurrent Programs, Form and Functions
• Experience in Descriptive Flex-fields, Key Flex Fields, Value sets, Menus, and Responsibilities setups in Custom Applications and defining Profile Options, Lookup values by using Application Object Library (AOL)
• Experience in working with tools PL/SQL Developer, TOAD, Winscp, Kintana, Oracle Forms & Reports, BI Publisher, Oracle Work Flow Builder, OEM, OA Framework, Oracle ADF, JSON, SOAP UIs, Restful WebService, SVN, Git.
• Worked with frontline business users in gathering requirements and translating, documenting them as functional designs
• Good experience in programs debugging, issue resolutions and providing new business solutions.
• Experience in writing triggers, packages, procedures and functions in PL/SQL for data validations and loading.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast paced and team-oriented environment.
• Excellent communication and interpersonal skills to handle the client meetings and solution discussions.

TECHNICAL SKILLS

Languages: Oracle Applications R12, Oracle Fusion Apps, PL/SQL, SQL, Mainframes, C, C++, Java, HTML, CSS, Javascript, UNIX Shell Scripting, DBA (Database Administration), JSON.

Tools: Visual Studio, TOAD, PL/SQL Developer, Winscp, Kintana, Oracle Forms & Reports 9i/10g, BI Publisher, OEM, SQL Developer, Putty, Oracle Work Flow Builder, Jdeveloper.

Frameworks: Oracle Applications Framework (OAF), Oracle ADF, Springs Framework, Ionic Framework.

Enterprise Applications: Oracle E-Business Suite 11.5.10.2, 11.5.8, R12, Oracle SOA Suite (10g, 11g), Oracle Fusion Apps.

ERP Modules: Order Management, Account Payables, Account Receivables, Inventory, Purchasing, Shipping, Advanced Pricing, iStore, iProcurement, iSupport, Oracle Transportation Management and AOL

Databases: Oracle 9i, Oracle 10g, Oracle 11g, MySQL, MS Access, SQL Server

Operating System: Windows XP/Vista, Windows 7, Windows 10, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential - Sunnyvale, CA

Sr. Oracle Applications Consultant

Responsibilities:

• Experience in several phases of the project like Analysis, Design & Development, Testing, Documentation
• Designed various high level designs for the solutions and then created subsequent low level designs for the solution build.
• Created and exposed various API in Oracle Install Base using open standards.
• Created various Mobile GUIs using ionic framework.
• Worked as a Team Leader for the support Team and played a vital role in managing team members along with the deliverables
• Acted as a primary developer for Implementing break fix/enhancement and new components/reports for the client.
• Experience in working on FND LOAD for migrating concurrent programs, value sets, descriptive flex fields, lookups between instances.
• Extensive experience in Ticket assignment, SLA adherence, Metrics preparation and monitoring.
• Involved in Internal Quality Assurance and External Quality Assurance for each component, Business Continuity Plan, Defect Prevention, Root Cause Analysis, Audit using Integrated Project Management System.
• Played a crucial role in coordinating with support, development and testing teams during various testing phases, prepare release rollout plans for all releases and finally provided agreed warranty support.
• Good experience in handling SRT calls involving onsite, offshore teams and clients until the issue is resolved
• Involved in developing unit test specifications, test cases & test Results

Environment: Oracle Applications 12.1.3 Oracle Database 10g, Pl/SQL Developer, SQL*Loader, Service-Now, Putty, Winscp, Spring Framework, SOAP UI, TOAD

Confidential - Sunnyvale, CA

Sr. Oracle Applications Consultant

Responsibilities:

• Involved in developing and implementing Oracle iSupport for Trimble.
• Involved in managing and administering Oracle R12 application setups, concurrent jobs and managers
• Involved in Initial Feasibility Study for the Business requirements & assisting Functional resources for POC (Proof of Concept).
• Performed data conversions, Setups of AOL Objects, Key and Descriptive Flex fields and various modules.
• Experience in creating new custom responsibilities and roles which are required for developers
• Involved in execution of different Test Scenarios and identified gaps in design and development.
• Involved in code migration activities between instances
• Coordination with DBA team and testing of all Oracle suggested Patch set migrations
• Developed Deployment Instruction documents that can enhance easy Installation of RICE components.
• Involved in fixing the bugs identified during the migration through Test instances.
• Experience in preparing Knowledge transfer documents to support team.

Environment: Oracle Applications 12.1.3, OAF, Oracle Forms & Reports 10g, SQL*Loader, PL/SQL Developer, TOAD, Kintana, Winscp.

Confidential - Charlotte, NC

Sr. Oracle Applications Consultant

Responsibilities:

• Involved in analysis, design, development, testing and implementation of Oracle Applications R12
• Involved in implementing and supporting Oracle Modules: Account Receivables (AR), Oracle Purchasing/ Oracle Order Management/ Oracle Transportation Management/ Oracle Inventory/ Oracle Shipping.
• Excellent perspective on converting the functional specifications into technical design and development.
• Working with Vendor Oracle through Service requests for standard Oracle issues.
• Created and implemented design for Service Oriented Architecture for Integration with various legacy systems.
• Provides support to business during their Financial Period close.
• Worked on various EDI Integrations (EDI850/ EDI810/ EDI856/ EDI210) with partner systems and dealers.
• Provide design & estimation for Enhancement and new change request received from clients.
• Identifying changes in existing integration flow and modifying existing programs to improve the performance.
• Involved in configurations of Payment process profiles, Customer Setups.
• Involved in creating scripts to monitor and send alerts as mails using Unix Shell scripting.
• Experience in creating database objects like tables, views, functions, procedures, triggers etc.
• Involved in developing reports, concurrent programs, AOL objects etc. as per the business requirements.
• Involved in resolving business critical issues by fixing the code in Forms, Reports and PL/SQL packages.
• Conduct ticket assignments and status review meetings within Onshore offshore model.
• Involved in managing and monitoring the Service Requests in Oracle Support.

Environment: Oracle Apps 12.1.3, Oracle 10g, Oracle XML Gateway, OTM, OAF, Kintana, PL/SQL Developer, TOAD, Winscp, Putty

Confidential, Camel, Indiana

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in gathering and developing functional requirements documents for the assigned components.
• Interact with business users and translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Identified and worked on fixes of the reusability/Changes in existing integrations flow from Payables to Downstream Systems and highlight gaps if any by working closely with related teams
• Developed good expertise and worked on application issues raised in touch point systems like SAP, Tradesphere, Tesseract, various order import systems, Solution Builder, Open text system and other custom applications like e-Contracts and e-licensing.
• Involved in direct interaction with the onsite functional consultants for clear visibility of requirements.
• Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
• Coordinated with offshore team in modifying the existing payment programs
• Extensive experience in migration of code through testing instances, performing testing according to the test cases written before moving into production
• Involved in identifying and fixing critical issues in business identified in PL/SQL Packages, Forms, Reports, Setups, etc.

Environment: Oracle Apps 12.1.3, Oracle Forms & Reports 10g, PL/SQL Developer, UNIX, FTP, Oracle Database 10g

Confidential - Albany, NY

Oracle Applications Techno Functional Consultant

Responsibilities:

• Responsible for creating and executing complex SQL Queries for conducting back end testing.
• Actively involved in all phases of the Software Testing like Analyzing System Requirements, Test Strategy, Test Planning, Test Case Design and System Testing.
• Developed and executed Test Cases based on the requirement documents.
• Responsible for managing and maintaining Punch-out vendors.
• Participating in Toll gate processes, creating and maintaining documents.
• Involved in AOL objects setups like Descriptive Flex Fields, Key Flex Fields, Value sets, Look ups, etc.
• Involved in coordinating between onsite business analysts and offshore support teams.
• Responsible for handling/resolving application and database related issues in the live production environment.
• Played vital role in resolving business critical issues in PL/SQL Packages, Reports etc.

Environment: Oracle Apps 11i, Oracle 10g, PL/SQL Developer, SQL developer, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

• Responsible for creating and executing complex SQL Queries for conducting back end testing
• Actively involved in all phases of the Software Testing like Analyzing System Requirements, Test Strategy, Test Planning, Test Case Design and System Testing.
• Developed and executed Test Cases based on the requirement documents.
• Design and develop custom forms using Oracle forms and Custom PLL.
• Design and develop custom reports using Oracle Reports and BI Publisher.
• Involved in AOL objects setups like Descriptive Flex Fields, Key Flex Fields, Value sets, Look ups, etc.
• Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
• Experience in creating tables, views, functions, procedures, triggers etc.
• Involved in coordinating between onsite business analysts and offshore support teams.
• Responsible for handling/resolving application and database related issues in the live production environment.
• Played vital role in resolving business critical issues in PL/SQL Packages, Reports etc.

Environment: Oracle Apps 11i/R12, Oracle 10g, PL/SQL Developer, SQL developer, UNIX.