SUMMARY

• Strong oracle ERP professional with 5+ years of extensive experience as Oracle Applications Techno Functional Consultant in 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 including Supply Chain Management, Financials and Manufacturing and Distribution: Order Management (OM), Account Payable (AP), Account Receivable (AR), General Ledger (GL), Fixed Assets (FA), Purchasing (PO), Inventory (INV), Bills of Material (BOM), Work in Progress (WIP), Shipping (WSH), Advanced Pricing, iStore and AOL objects.
• Experience in technical development, Functional and maintenance of Oracle E-Business Suite R12 and 11i.
• 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.
• 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, Visual Studio, Winscp, Clearcase, Kintana, Oracle Forms & Reports 10g, BI Publisher, Oracle Work Flow Builder and OEM.
• 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, PL/SQL, SQL, Mainframes, C, C++, Java, HTML, CSS, Javascript, UNIX Shell Scripting, DBA (Database Administration)

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

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

ERP Modules: Order Management, Account Payables, Account Receivables, Inventory, Purchasing, Bills of Materials, Shipping, Work in Progress, Advanced Pricing, iStore and AOL

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

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

PROFESSIONAL EXPERIENCE

Confidential

UI Developer with SQL(Intern)

Responsibilities:

• Worked as a developer as part of developing the Timesheet application modules
• Responsible for requirements gathering, writing test cases, unit testing and integration testing of the developed components
• Responsible for developing the below components:
• User interface of task creation in the job calendar and editing events and deleting events
• Displaying the created tasks in the calendar format, consolidated calendar view for all jobs and employees
• Rejecting the approved timesheets
• HTML print preview on approved reports
• Reject and approve actions for pending logs
• Experience in using SQL, HTML, CSS, and JavaScript in designing theUIapplication and writing custom code.
• Used SQL Server to perform backend operations likeSQLqueries to retrieve data.
• Improved the performance of the application by rewriting theSQL queries.
• Worked with end users to facilitate issue resolution, troubleshooting application issues.
• Experience in Database Design and Database objects deployment inSQL Server
• Created Responsive Layouts for multiple devices and platforms.
• DevelopedUser Interfacepages and settings using JS objects.
• Implemented various JavaScript/JQuery effects on the pages.
• Participate in business meetings and coordinate with Business Analysts to understand the business needs and implement the same into a functional design.
• Preparation of technical specifications as per the functional specifications and the business needs.
• Involve in the analysis, design, development and maintenance of the features that are being added to the application.
• Writing source code, preparing test data, tests and debugs programs, revising and refining programs as directed.

Confidential, IL

Sr. Oracle Applications Techno Functional Consultant

Responsibilities:

• Experience in several phases of the project like Analysis, Design & Development, Testing, Documentation of Oracle E-Business Suite(EBS) R12 applications.
• Involved in implementing and supporting Oracle Supply Chain Management and Financials Modules: Order Management, Account Receivables(AR), Account Payables(AP), General Ledger(GL) and Fixed Assets(FA).
• Worked as a Team Leader for the support Team and played a vital role in managing team members along with the deliverables
• Troubleshooted and fixed the issues in Order management application - Order import, export compliance holds, Pricing, Return Material Authorization issues, sales order workflow issues
• 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.
• Involved in maintaining functionality of AR to PA Billed revenue and OM to PA Unbilled revenue interfaces.
• Involved in configurations of Payment process profiles, Customer Setups.
• Experience withAdvancedPricingsetups inOracleOrder Management - DefiningPricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, Freight Charges
• Excellent perspective on converting the functional specifications into technical design and development.
• Working with Vendor Oracle(Metalink) through Service requests for standard Oracle issues.
• Developed Deployment Instruction documents that can enhance easy Installation of RICEW components.
• Provides support to business during their Financial Period close.
• Involved in customization of the Oracle Identity manager solution to implement the organization specific process and provisioning requirements
• Awarded with the ‘On the spot’ award from project I worked for the additional effort on developing a concurrent program in oracle apps and received Best appreciation from the client
• 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
• Good experience in handling SRT calls involving onsite, offshore teams and clients until the issue is resolved
• Extensive experience in creating CAT test cases, coordination of CAT test cases and migration of data through CAT instance implementing the test cases.

Environment: Oracle Applications 12.1.3 Oracle Database 10g, Pl/SQL Developer, SQL*Loader, Service-Now, Putty, Winscp, Report Builder 10g, TOAD

Confidential, IL

Oracle Applications Techno Functional Consultant

Responsibilities:

• Experience in developing functional Requirement documents for the assigned components in Oracle E-business suite (EBS) R12 modules
• 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 ACMP tool conversions, Setups of AOL Objects, Key and Descriptive Flex fields and various modules
• Functionalknowledge of advanced pricing,ordermanagement, Quote toOrderProcess, Shipping, inventory, Purchasing, bills of materials, Quality
• Worked onOrdermanagement,Orderfulfillment, Pricing, Defaulting rules and Processing constraints.
• Experience in creating new custom responsibilities and roles which are required for developers
• Responsible for assigning custom concurrent managers and adding concurrent jobs not found to the request group
• Involved in execution of different Test Scenarios and identified gaps in design and development.
• Involved in code migration activities between instances
• Worked on Integration Projects by Using Service Oriented Architecture(SOA) with Oracle Application
• Coordination with DBA team and testing of all Oracle suggested Patch set migrations
• Providing estimation and design 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 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 resolving business critical issues by fixing the code in Forms, Reports and PL/SQL packages.
• Coordinating with offshore team in status and completion of assigned tickets and service requests
• Involved in developing unit test specifications, test cases & test Results
• 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.
• 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, Oracle BI Publisher, Oracle Forms & Reports 10g, SQL*Loader, PL/SQL Developer, TOAD, Kintana, Winscp.