SUMMARY:

• Having 10 years of diversified techno functional expertise in Oracle Applications R12/11i, with extensive exposure in for Design, Development, Configuration, Implementations, Production Support and Upgrades in Supply Chain and Manufacturing Modules.
• Proficient in all phases of Oracle Applications 11i implementation with major focus in Oracle Supply Chain Modules (INV, OM, PO, WIP, BOM, WMS, ICM, PIM/PDH), Financials (GL, AR, AP), AOL, Advance Pricing, Shipping and System Administration module.
• Well experienced in design and development of Reports, Interfaces, Conversions and Extensions (RICE), Implementation and Support of various Oracle Apps modules. Involved in implementing versions/upgrades of Oracle Applications 11i, and recently involved in implementing Oracle Applications 11i/R12 for Oracle Business.
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and sysadmin setups documents.
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Expertise in implementing and strong knowledge of Order To Cash (O2C) and Procure To Pay (P2P) business flows.
• Designed Custom Reports, Forms, Workflow Customizations, Forms Personalization and all other RICE objects to meet customer requirements in Fresh Implementation and Production Support projects of Oracle Applications.
• Hands - on experience in Data Conversion, Data Migration and Developing Interfaces, Extensions in various Oracle ERP modules.
• Worked on creating SQL*Loader control programs, PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Proficiency in understanding client’s needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Worked with Offshore Technical team on Development, Testing and Migration of Objects.
• Expertise in MTI and month end closing activities in Inventory.
• Hands on experience in troubleshooting issues and resolving tickets on priority.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.

TECHNICAL SKILLS:

ERP: Applications 11i, R12(11.5.10.2,11.5.10, 11.5.9, 11.0.5, (12.1.3))

EBusiness suite Modules: INV, OM, PO, WSH, WMS, BOM, ICM, WIP, AP, AR, GL, PO, SYSADMIN

RDBMS: Oracle v 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, C, C++, Java

Tools & Utilities: Forms 6i/9i, Reports 6i/2.5, SQL*Loader, Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, XML Publisher, MS Visio, Data Loader, OIT 8.3.7

Hardware: HP 9000, Intel Pentium based PC s

Documentation: AIM Documentation (MD50, MD70, MD120,CV60,CV40)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. Oracle Applications Techno Functional Lead Consultant

Responsibilities:

• Implementation and support of Inventory INV, Order Management OM, Purchasing PO and O2C modules in Oracle Applications.
• Worked on requirement gathering for custom interfaces, prepared MD50 functional design documents and worked with Developers for Unit testing with different test cases created.
• Worked with Business users in UAT (User acceptance test) for the interfaces designed.
• Worked with Oracle Support to create Service Requests and provide required information requested and escalate when necessary.
• Worked on managing and provided assistance for developers, business users, testers for delivery of a project.
• Capability and strong communication skills to schedule the calls with business and understand the functionality.
• Responsible and played a major role to track and delivery of project within the specified guidelines.
• Implementing the business requirements into Standard ERP functionality and worked in the design and development of the RICE objects.
• Involved in all major device launches and expert in handling and supporting the Pre-Orders.
• Worked on the design and definition of Item templates for pre-defined items.
• Worked on providing detailed system requirements specifications, complex data flow diagrams, test plans, swim lane and process diagrams using standardized documentation methods.
• Worked on developing documents and manages requirements throughout project.
• Experience in Agile methodologies.
• Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
• Worked on the Drop Ship Orders and configuration.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Worked on the customization of Item Assignment, Item Import and sending the Item Info from PDH to other systems.
• Tested and verified the data upon completion of Data Migration and supported during pre-production and prod support activities.
• Scheduled the meetings, gathered the status and delivered to the client from offshore and onsite team members.
• Arranged the calls to check and keep track of bugs or tickets within team members to fix the open issues.
• Participated in multiple complete life-cycle implementation projects involving Oracle EBS.
• Proficient in formulating functional and technical design specifications, Proof of Concepts, user training and support.
• Provided Assistance in managing the relationship between business users and IT.
• Managed the delivery of a small part within a project for maintenance and testing.
• Extensive experience in managing teams across time zone both on-site/off-shore models.
• Proficient in building new team and mentoring new team members in the technical and functional aspects of Oracle EBS.
• Performed required setups to load items, item categories, item cross references, Customers, Customer sites and Onhand balances data from legacy systems in oracle.
• Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.
• Involved and worked with business users for fixing the item issues related to PDH which includes Item Status, Assignments, and discrepancies of item in other external systems.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Involved in the design (MD50), Implementation (BR100), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120) as per the client’s requirement.
• Created Descriptive Flex fields to house few data elements for Items, Locators and Customer sites.
• Created Shipping Lookup to house the carrier information based on the Ship to Country.
• Defined Carriers and Ship Methods in OM.
• Work with product owners to understand and develop business cases and determine relative priorities.
• Played a major role to Assist in enforcement of project deadlines and schedules
• Accurately prepare written business correspondence that is coherent, grammatically correct, effective, professional, and engaging.
• Expert in implementing the solutions and supporting red Hat Issues and production issues after Go- Live.

Confidential, Irving, TX

Sr. Oracle Applications SCM Consultant

Responsibilities:

• Gathering the requirements from the end users and preparing the functional documents (BR100, MD50) as per the client need.
• Analyze the business requirements and define to-be solutions, focusing on standard functionality and avoiding customizations.
• Designed and worked on custom programs and functional setups as per the client requirements in Inventory & Order Management modules along with O2C cycle.
• Involved in training the users, providing the feasible solutions, played a major role in cross functional meetings and gathered/provided necessary information for P1 issues.
• Arranged the Clients Calls with Business Analyst team to understand their Business Process for migration.
• Involved in creating the Data loaders and configured the system setups.
• Coordinated with the Business Teams during CRP sessions, providing feasible solutions and additional support during testing phase.
• Integration of third party systems into ERP systems.
• Prepare solution design & functional design documents & also review them.
• Coordinate with business users for data readiness for the conversion entities & participate in converted data validation.
• Expert in coordinating with offshore, business users and on-call monitoring, can provide support 24*7 support.

Confidential, Dallas, TX

Sr. Oracle Applications SCM Lead

Responsibilities:

• Worked on the implementation of Oracle EBS R12 modules Order Management, Inventory & O2C and was involved in all phases of the implementation and post production support.
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and SysAdmin setups documents.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Was involved in various enhancements, implementations and regular support activities on Oracle E-Business suite including setups on Customer cross reference, shipping terms, pricelist assignments, processing roles, Items, Organizations, sourcing roles…
• Involved in the design (MD50) and development of the Order Tracker Interface which would enable any AT&T employee to view the requisition/purchase order/Sales Order info without having to access the Oracle application.
• Interacted with key management persons to study the current business process, Re-engineer and map to Oracle Application Functionality.
• Involved in the design and development of various validations and functionalities in the Order Import, Order Allocation Release programs to ensure the orders are imported from external systems and processed in OM, orders are allocated and fulfilled to WMS.
• Define QuickCodes that provide custom values for many lists of values throughout Order Management.
• Worked on the customization of Item Assignment, Item Import and Item Status Change for sending the Item Info from Oracle to other systems.
• Excellent experiences to train end user on the system and also provide post go live support.
• Coordinated with Technical and Business teams in order to meet the Business Requirements for identified Customizations.
• Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement in Oracle Application Object Library (AOL).
• Worked on AT&T wireless orders, supported and strong hands on experience in Order to Cash life cycle. Enhanced and implemented the changes for O2C cycle based on the client needs.
• Designed and developed the Functional Docs (MD.050), Technical Specification Docs (MD.070), and Unit Test Cases Docs (MD.120).
• Played a major role for AT&T customer orders, to process them from order entering to shipping and invoicing.
• Co-ordinated with Offshore technical team for any new enhancements and tested the solution as well as co-ordination with the DBA team for application of solution to production.
• Also involved in all major device launch activities like Ipad/I-Phone/Samsung/LG mobiles, implemented and supported the designs for the AT&T pre-orders for Order Management Module.
• Involved in the design and development of various validations and functionalities in the Order Import, Order Allocation Release programs to ensure the orders are imported from external systems and processed in OM, orders are allocated and fulfilled to WMS.
• Worked on the design of Data Migration, Interfaces, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash and Procure to Pay Cycles touching various modules such as Inventory and Order Management Modules.
• Involved in the design, development and support of the incoming pick acknowledgement, pack and ship confirmation, and receipt and deliver confirmation for all the Wireless customer orders (Direct Fulfillment).
• Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
• Tested and verified the data upon completion of Data Migration and supported during pre-production and prod support activities.
• Involved in creating the test cases for functional testing and conducted demo sessions to the users for providing more details about the functionality of new process.
• Maintained 100% ON-HAND SYNC between Oracle, DC’s & CATS (asset tracking system) for all the Wireless items. If they are not in sync, I’m engaged to clear the pending reservations.
• Involved in the designing of the material request interface which would enable the external ordering systems to forward their material request to Oracle and the Oracle EBS system will determine the fulfillment route of the same.
• Worked on creating the Pl/SQL objects and scripts as per the client requirements.
• Registered custom tables on Oracle 11i (Inventory, Order Management and AR modules).
• Involved in customizing many interfaces (Pick Release, Ship Confirm, Order Track, Shipment Extract, RMA’s...) as per the requirements for the Wireless Process.
• Supported all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting technical and functional issues. Lead development effort of enhancements, patches and upgrades.
• Worked on day - to day activities and coordinating with users, super users, WMS, Management, technical and business teams to process the orders from order entry till shipping and make sure they are invoiced. (O2C Cycle).
• Performed Tier II system troubleshooting in a production support environment for the Oracle SCM modules. Assisted users in solving both functional and system issues within agreed-to service level agreements (SLAs Provide end-user instruction, training and support to resolve application issues.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Provided techno functional support in the research and analysis of application stability improvements, requests and problems for internal users and external customers and vendors (Users).
• Created and Managed Service Requests with Oracle Support in different scenarios, for providing Solutions to the Bugs identified during Production Support. Conducted OWC sessions and resolved various bugs, working in collaboration with Oracle Support.
• Expert in identifying the issues and providing the feasible solutions on priority.
• Created NEMS Alerts to monitor various stages in the O2C & P2P life cycles to maintain a steady process.
• Track, monitor and report progress of assignments; update AOTS Tickets activity logs in a timely manner; document and track case histories, issues, and action steps taken; timely follow-up on open issues, communicating status and setting resolution expectations with users and management.
• Escalate issues according to established communications guidelines and checklists.
• Improved support policies and procedures documentation; create/update system and application documentation as required in Order Management Module.
• Maintain, tune and repair applications in a proactive manner in order to keep them performing according to technical and functional specifications; performing preventive activities.
• Creating the AOTS Charm (Change Management) tickets to deploy the code in PROD from test instances to ensure compliancy with policies, standards, and software licensing.
• Monitor Month end close process for Inventory, OM, Receiving and Shipping modules. Performed post-installation system review and ongoing support.
• Maintain, tune and repair applications in a proactive manner in order to keep them performing according to technical and functional specifications; performing preventive activities. Creating the AOTS Charm (Change Management) tickets to deploy the code in PROD from test instances to ensure compliancy with policies, standards, and software licensing.
• Hands on experience to process OM transactions, un-processed ship confirms from MTI during the Month End Closing Process.

Confidential, Torrance, CA

Sr. Oracle Applications Techno Functional Consultant

Responsibilities:

• Designed various Responsibilities with Customized Menus required for Distribution modules.
• Worked on creating the profile options to specify certain implementation parameters, processing options, and system options for OM.
• Involved in setup of Order Management Parameters to validate items, enable customer relationships, and operating unit defaults.
• Worked on custom design changes and implementation of Order to Cash life cycle.
• Worked on setups: Freight Charges and Carriers, Holds, Credit Checking, Shipping Parameters, Defaulting Rules, Processing Constraints, Order Management transaction types, Order Import Sources, Quick Codes, Sales Persons in Order Management.
• Defined Order Management Parameters to validate items, enable customer relationships, and operating unit defaults.
• Involved in Defining key and descriptive flexfields to capture additional information about orders and transactions.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Creation of conversion specifications like CV040’s for Suppliers, Open Purchase Orders, Item & Item Categories, Item On hand and Stock Locators.
• Involved in defining necessary setups to load On hand using Material Transactions Interface.
• Worked on Pick release and Ship Confirm concurrent programs which are used to release the orders and ship confirm the orders.
• Worked on design and development of Order Import conversion program which enables you to import sales orders into Oracle Applications instead of manually entering them.
• Provided solutions to several day to day Production issues and Tier 2 support for production support process and procedures.
• Gathered requirements and worked on Designation and development of an OA Framework page layout to maintain Associate Distributors Information for Primary Distributors for O2C Cycle.
• Utilized Defer interface feature while ship confirmation, for not to run Interface Trip Stop program after ship confirmation.

Confidential, TX

Sr. Oracle Applications Techno Functional Consultant

Responsibilities:

• Interacted with key users to gather the requirements and identify critical business issues.
• Actively involved in Data Migration objects of Open Sales Orders.
• Coordinated with Technical team in order to meet the Business Requirements.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Arranged the Clients Calls with Business Analyst team to understand their Business Process for migration for Order Management requirements.
• Coordinated with the Business Teams during CRP sessions, providing feasible solutions and additional support during testing phase.
• Tested and verified the data upon completion of Data Migration.
• Prepared the Functional Design Document and working on the open issues.
• Extensively worked with Business users for requirement gathering and involved in UAT, problem resolutions and bug fixing.

Confidential, Duluth, GA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Conducted number of meetings with SME’s and clients for requirement gathering and all.
• Involved in setting up Buyers, Approval Groups and Assignments, Requisition Templates, Approved Suppliers List and setups for Internal Requisitions in purchasing module.
• Creation of BR 100’s for various setups of Purchasing and Inventory.
• Designed and developed an error handling form which handles legacy and Oracle validations before sending the data into the Interface tables.
• Worked on designing of a custom commercial invoice report program to kick off from the shipping document sets along with ship confirmation.
• Involved in Implementation of Procure to Pay (P2P) cycle which includes Items and Categories, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Created data definitions and design templates for custom reports for order and inventory control using Oracles XML Publisher.
• Developed shell scripts to migrate objects from Development to Testing.

Confidential, Seymour, IN

Oracle Applications Techno Functional Consultant

Responsibilities:

• Provided Functional and Technical Support for the following modules Inventory, Purchasing, Order Management, Accounts Payables, Accounts Receivables, General Ledger, Project Accounting, Project Contracts, and Service Contracts.
• Resolved Technical and Functional issues for Standard Oracle Applications and Customizations.
• Supported 7 countries live on Oracle Applications for their Technical and Functional issues, being monitored against the SLA defined.
• Issue Analysis and resolution according to the SLA.
• Co-ordination with Onsite team for resolution of issues.
• Testing the solution as well as co-ordination with the DBA team for application of solution to production.

Confidential, Pittsburgh, PA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Prepared functional, technical design documentation.
• UTP Installation documentation and Shell Scripts.
• Created the test cases and involved in testing and reviewing the objects.
• Worked on the interfaces and data conversions for the upgrade and tested to the client satisfaction.
• Worked on Order to Cash Cycle, starting from enter order stage to move order stage followed by the ship confirm and updating the GL.
• Customized existing forms to add search criteria on descriptive flex fields.
• Involved in User interaction for collecting and documenting user report requirements and translated.
• Developed queries for summaries of AR Aging reports, AR to GL Reconciliation reports, Auto-invoice execution/validation report, Tax and Revenue reports, Receipt register reports, Un-posted Items Report, Adjustments etc.
• Developed OM queries to Count Orders by Order Types, Order Source.
• Developed Data Audit System scripts to capture the data from "before" system and after systems.

Confidential, Wichita, KS

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Oracle Applications Technical support for various components like Reports (RDF, Sql plus, discoverer), Interfaces, Alerts.
• Involved in developing the new components (Reports, PL/Sql Procedures, and Packages).
• Responsible for gathering user requirements, which involved a lot of interaction with the users
• Involved in developing the data fix scripts and Setup changes in related modules.
• Worked on Inventory Month end closing process.
• Built custom reports using Oracle Report builder 6i and integrated them with the application (based on the descriptive flex fields) to solve the client’s reporting needs.
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client
• Registration of Concurrent programs, Creation of Value sets, placing the Reports and Interfaces in the AOL directory of the server.

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on Order to Cash Cycle, starting from enter order stage to move order stage followed by the ship confirm and updating the GL.
• Developed Oracle reports and Forms as per the requirements.
• System admin responsibility in Oracle Apps 11i (registering reports, executables, value sets).
• Involved in developing the documents like MD70, MD40, and MD120 as per the standards.
• Extensively worked on complex Data Models and Data Layouts in Oracle Reports 6i.
• Developed Oracle reports and Conversion Programs.
• System admin responsibility in Oracle Apps like registering reports and forms, defining value set, alerts.
• Involved in Form Personalization.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OM) programs to support the interface requirements.
• Excellent understanding of AOL & Sys Admin, developed new reports, forms, functions, validation sets, request sets and concurrent programs.
• Created new reports Quotations received and Orders booked through TeleSales and integrated with Oracle Applications.
• Developed custom Report RMA, to execute for the required set of books.
• Developed a workflow package to run on Reminder on Thursday for all employees and warning on Monday morning to the employees who did not sent time sheets.
• Used TAR Assistance for expenditure id and functional currency in Project Accounting.
• Thorough understanding of Workflow Order to Cash and Procure to Pay.
• Customizing the Self Service Timecard to Auto-Populate the Hours Type according to Project and Task selection on the Project/Payroll Layout.