SUMMARY:

• Experienced Oracle Applications Techno Functional consultant, working in Oracle ERP for more than 12 Years
• Proficient in Order to Cash Business Flows, mainly working in Inventory, Order Management, Receivables, and Purchasing Modules.
• Extensively worked on various RICE objects design and development in both Oracle Applications R12 and 11i.
• Handled Multiple Implementation, Support & Maintenance projects
• Successful track record with experience as Project leader, Support Track Lead, Technical - Team Leader, Team Leader and Techno-Functional team member
• Strong Technical skills in Oracle Forms 6i, Reports 6i, SQL*Plus, Oracle PL/SQL, Workflow, UNIX and SQL* Loader
• Experience in Business requirement gathering and mapping to oracle and identifying functionality Gaps to customize to meet Business requirement.
• Well versed in authoring AIM documentation during all stages of the SDLC including BR100s, MD50, MD70, CV40, promotion, integration and configuration documents.
• Excellent communication, analytical and teamwork skills and have strong willingness for learning business process
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications R12(12.0.6, 12.1.3, 12.2.3)/11i(11.5.10.2, 11.5.8, 11.0.3). Order Management, Inventory, Purchasing, Accounts Receivables.

Oracle Tools: Reports 6i/9i/10g, Forms 6i/9i/10g/11g, Discoverer 4i/10g, Workflow Builder 2.5.

Database: Oracle 10g/9i/8i

Development Tools: SQL*Plus, TOAD, PLSQL Developer, SQL*Developer.

Scripting: SQL/PLSQL, UNIX.

Application Utilities: SQL*Loader, TKPROF, UTL FILE, FND LOAD.

Operating System: SUN Solaris, IBM-AIX, WINDOWS

PROFESSIONAL EXPERIENCE:

Confidential, Jacksoncille, FL

Oracle e-Business Suite Support Track Lead

• Manage Support Tickets & CRs for Oracle Procurements, Inventory modules
• Leading support team of 5 members
• Resources Management
• Daily/Weekly/Monthly status reporting to the Client Directors
• Process Improvements analysis
• Maintaining Support Metrics

Oracle e-Business Suite Design/Development Lead

• Design and Development Lead for NSP Decommission project.
• NSP - National Spare Parts is a Mainframe based legacy system in Ricoh for Parts ordering and maintenance. By this project all processes/functionalities from NSP will be moved to R12 eBusiness Suite system
• Requirements gathering and BRS documents preparation for various functionalities and Gaps.
• Prepared Solution Design Documents for Complex Interfaces between R12-Japan Ricoh Systems and R12-WMS systems.
• Development of interfaces with Japan and WMS systems.
• Tracking project status with team and weekly calls with client Managers/Directors

Oracle e-Business Support Track Lead (SC M) - Offshore

• Manage Support Tickets & CRs for Oracle SCM & OM modules
• Leading support team of 15 members
• Resources Management
• Daily/Weekly/Monthly status reporting to the Client Managers
• Process Improvements analysis and reduced ticket inflow in OM area.
• Maintaining Support Metrics

Oracle Techno-Functional Analyst

• Successfully managed a team of 10 of Support team and Analysts Team
• Requirement Document preparation for various Enhancement Requests
• Design Document preparation for Enhancement Requests
• Daily status report with Client Director
• Delivered Business Process Improvements documents

Design and Development Technical Team Lead (Offshore)

• Formed and lead 10 member development team at offshore
• Implementation of R12 Oracle iStore and iSupport Modules
• Design Documents and Development of complex solutions
• User Registration in Custom iStore application - using Item Serial Number
• User Mass upload Program - using WebADI iSupport form customizations
• Automatic Account assignment for external users
• Equipment Assignment for user - Primary and Secondary contacts
• Preparation of Unit test plans and Integration test plans
• Code review and documents review of team members

Technical Lead Data Migration Team (Offshore)

• Technical Lead and Lead 15 Member Data Migration & Development Team
• Preparation of High Level Technical Design Documents for various Data Migration Entities
• Preparation of Design Documents for Gaps & Interfaces
• Successfully Post Go-Live and Support activities
• Development Data Migrations for Item
• Item OnHand
• Item Category
• Related Items
• Cross Reference Items
• Interface with POS Systems
• Item Category Segments Interface
• Item Interface
• Price List Interface
• On-Hand Availability Check
• Related Item Interface
• Sub-Inventory Transfer Interface - Online
• Various Form Personalization

Techno-Functional Consultant

• Technical specialist in development and integration of OM Functionalities under single window (SWB UI)
• Preparation of High Level Technical Design Documents
• Performing unit and integration testing
• Development of Single Work Bench for Orders and Quotes
• Order Line - BOM Cost Roll up/Roll down Functionality
• Item Organization Assignment Functionality from BOM screen
• Order Search Functionality
• Quote Search Functionality
• Order Amendment Functionality

Project Lead & Techno-Functional Consultant Offshore

• Managing 5 member offshore team
• Direct Client reporting on project deliverable statuses
• Maintenance and Support after Golive
• Project management activities like PMR submission
• Development of complex interfaces in OM, AR, INV
• AR to IBS Out Bound Interface
• Developed new and customization of Oracle 6i reports
• Developed Custom Forms to show Advanced Shipment Details of Serial Numbers
• Zoom Form from Order Entry Form to show Serial Number Details

Techno-Functional Team Member Offshore

• Preparation of High Level Technical Design Documents
• Performing unit and integration testing
• Go-live activities
• Developed custom form to show Order Details for CDF Customers
• Developed Custom Form to Release holds in CDF Customer Orders with respect to the Approval Number
• Worked in Logical Apps Rules to populate Order Type and Payment Terms in CDF Customers Orders
• Form personalization in OM order forms

Techno-Functional Team Member Offshore

• Preparation of High Level Technical Design Documents
• Performing unit and integration testing
• Go-live activities
• Developed custom form to show Order Details for CDF Customers
• Developed Custom Form to Release holds in CDF Customer Orders with respect to the Approval Number
• Worked in Logical Apps Rules to populate Order Type and Payment Terms in CDF Customers Orders
• Form personalization in OM order forms

Oracle Developer

• Requirement analysis
• Develop code as per specification adhering to standards
• Unit test plan preparation and testing Developing reports
• Developing Stored Procedures and Packages in Oracle 8i
• Analysis and Debugging of the Existing Forms