SUMMARY

• More than 10+ years of IT Experience in Design and Development of software Systems in the areas of Client/Server computing and Databases using Developer2000 (Reports) and Oracle eBusiness suite (Oracle EBS).
• Proficient in Developing, Customizing, and Implementation of forms 10g, reports 10g and XML Publisher reports.
• Experience in creating Corporate Reports using XML Publisher
• In - depth experience in all stages of Oracle EBS data conversion from legacy systems (Third Party)
• Experience in working as an Oracle EBS Corporate Reporting Lead
• Good working knowledge of creating outbound interfaces for AMEX and other systems( Third Party)
• Experience in coding Interface Programs for importing data from Legacy Systems
• Experience in doing reverse engineering of legacy systems and mapping it with Oracle EBS application
• Extensive experience in PL/SQL Procedures, Functions, Packages and Database Triggers
• Strong PL/SQL skills with the ability to write efficient, complex queries against very large data sets good knowledge of tuning of queries.
• Extensive experience using AIM (Application Implementation Methodology).
• Good experience in creating Unit Test documents
• Ability to quickly learn business applications and demonstrated analytical and problem solving skills
• Extensive experience in utilizing Oracle Utility tools like SQL*Loader.
• Extensive experience using Toad tools
• Worked on Project accounting modules.
• Ability to facilitate system review, data analysis and involved in various SIT, UAT and Go-Live phases of different implementation and upgrade projects.
• Good working experience in Reports 6i, 10g, PL/SQL, XML Publisher and RDBMS Concepts.
• Good Techno-Functional knowledge of Oracle SCM(O2C, P2P, INV), BOM, WIP
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Have taken R12 Oracle GL training from Oracle Education.

TECHNICAL SKILLS

• Oracle EBS 11i/R12
• Oracle Manufacturing (INV BOM WIP)
• Oracle Supply Chain (OM Shipping QP PO)
• Oracle 9i/10g
• Languages/ Tools
• Developer/2000- Oracle Reports 6i 10g
• SQL
• PL/SQL
• SQL*Loader
• TOAD
• Oracle SQL Developer
• BI Publisher (XML Publisher)
• Unix Scripting
• Windows 2000 Server / Professional

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Oracle EBS Senior Techno Functional Consultant

Responsibilities:

• Involved in initial implementation phase and in preparation of BR100, BP040, BP080 documents.
• Holding workshop sessions to drive into the key requirements, enhancements and impact analysis for all Manufacturing Modules
• Interacting with business users to understand better their pain points and key requirements.
• Involved in the design of chart of accounts structure, which suits the current organization structure of the business.
• Designing and developing demo sessions for the Purchasing modules with the respective users of R12 Environment.
• Involved in interfaces, conversions and customizations.
• Involved in the conversion of master data and transaction data.
• Defined operating unit, Inventory organization.
• Gathering Business Requirements for upgrade considerations and documenting them.
• Trained the users and explained the basic flows of the Purchasing and Inventory modules.
• Configuring Working session exercises for the key processes.
• Involved in daily and weekly meeting with the users and took necessary action in order to enhance the user participation in the implementation activities.
• Involved in UAT and SIT with preparation of test scripts TE040 for all the financial modules
• Involved in the development and design of customer weekly statements and daily open/paid invoice extract
• Involved in design of the Standard PO Print Report.

Environment: Oracle EBS 12.2.4(Oracle Inventory, Oracle Order Management, Oracle Supply Chain)

Confidential, Maumee, OH

Oracle EBS Technical Lead

Responsibilities:

• Maintained proactive interaction with clients to understand business practices for rendering assistance in system configuration; analyzed various business functions to derive benefits that will benefit the client in terms of cost rationalization and management control.
• Implemented Existing functionality to the New Organization and Designed Functional document and New reports.
• Implemented new functionality FIFO Process in one of the Business Unit.
• Guide the Technical team on the New business and Provided the Technical Design Document.
• Worked on Mobile Application Clear Orbit and Implemented new Functionality based on Business to use this feature in Implemented same Features in other OU’s.
• Involvement on Weekly status call meetings with Client along with Team members.
• Primary Contact for Priority Incident tickets like (P1 & P2).
• Interacting with the development team and providing them the necessary documentation(MD50) for the development of the custom programs and interfaces
• Involved in the data migration of the master data and transaction data of all the Purchasing and Order Management modules.
• Involved in designing and developing the new label for Customers using Bartender Software.
• Maintained proactive interaction with clients to understand business practices for rendering assistance in system configuration; analyzed various business functions to derive benefits that will benefit the client in terms of cost rationalization and management control.
• Conducted in depth analysis on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; analyzed and understood client issues and project goals in order to deliver standard service to clients.
• Perform internal analysis and implementation of R12 EBS. Develop Business process flows for the respective Manufacturing modules.
• Involved in the identification of present gaps and work with business owners/users in the design sessions of the respective modules.
• Develop project documentation including BR100 and Project Functional Design Documentation such as BP040, BP080 documents.
• Worked with the technical team for developing custom interfaces, transaction conversion from other systems.
• Define system options, Lookups, Define suppliers, Payment Terms, customers, transaction source, transaction types and other necessary system setups of all the Manufacturing modules.
• Assisted in developing and testing of data from third party systems
• Led the test sessions Performed unit, End-to-End tests and assisted in UAT sessions with preparation of test scripts TE40.
• Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Performed role of primary support analyst providing production support of Oracle PO & OM modules.
• Involved in the preparation of various MD50 for various conversions/interfaces.
• Involved in the conversion of master data and transaction data.
• Prepared detailed test scripts on various developed reports to users for testing.
• Assisting the users and making them familiar with oracle environment.
• Providing technical support in various Oracle EBS modules like Inventory, Bill of Materials, WIP, Order Management, Purchase Order.

Environment: Senior Techno Functional Consultant involved in R12 Implementation & 11i Support of SCM modules (Order Management, Purchasing, Inventory) and MFG Modules ( BOM & WIP).

Confidential

Senior Oracle Consultant

Responsibilities:

• Supporting issues relating to various operating units in modules such as Purchasing and Order Management & Shipping.
• Provided post production support for SCM modules.
• Various test scripts have been prepared for all the modules such as Purchasing, Inventory, Order Management.
• Resolved any month end related issues involving and data fixes or configuration changes
• Prepared design documents and test case scenarios for new modifications.
• Trained the Team members and explained the basic flows of the Manufacturing modules.
• Involved in the working sessions for the key processes.
• Extensively worked with interfaces, conversions and customizations.
• Preparing the issue chart and updating the client manager regularly.
• Helping the users in resolving their issues.
• Developed data migration scripts of the master data and transaction data of the Purchasing Module.
• Gathering the necessary information for the transactional data conversion

Environment: Oracle PL/SQL, Oracle Reports 6i, XML Publisher, Toad 9.7.2, Oracle EBS 11.5.10.2

Confidential

Senior Oracle EBS Developer

Responsibilities:

• Involved in Migration Process for Master Data and Transactional Data in Purchasing.
• Prepared Test scripts all the Purchasing modules for all Data fixes.
• Involved in preparation of BR100, BP040, BP080 and TE040 Documents for the Purchasing modules.
• Present the identified gaps and work with business owners/users in the design sessions, so that it fills the identified gaps
• Involved in Designing and developing demo sessions for all the modules with the respective module users.
• Performed role of primary support analyst providing production support of PO & OM modules.
• Attending daily status calls and weekly call with client team to discuss the updates.
• Gathering necessary business requirements for any enhancements and documenting them.
• Making necessary setups required in the instance and testing the functionality along with Functional Consultant.
• Provided post go-live support for financial modules with month end closing related as well as regular issues.
• Tested various reports and worked with Functional team to modify the same according to Business needs
• Prepared detailed scripts for procure to pay cycle and for order to cash process.
• Involved in the preparation of data migration template for the master data conversion and transaction data conversion.
• Providing application support to Order Management, Oracle Configurator modules

Environment: Oracle EBS 11.5.10.2 (Oracle Order Management, Oracle Configurator, Purchase Order), Toad 9.7.2, Oracle PL/SQL, Oracle Reports 6i.

Confidential

Systems Analyst (Oracle EBS)

Responsibilities:

• Gathered data conversion requirements from BA mapped the legacy data with oracle EBS tables and did the Gap Analysis
• Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing and Order to Cash Cycle to import legacy system data into Oracle EBS
• Reconciling of data in legacy system with oracle EBS once the integration is completed
• Providing estimation for technical deliverables in different phases of implementation of the project
• Worked closely with Business Analysts in gathering functional requirements(MD 50) and created technical documentation(MD 70) which included complex data flow diagrams, unit test plans and process diagrams
• Creating new reports and modifying existing reports in BI Publisher(XML Publisher) and Oracle Reports 6i
• Created Custom new form for user data entry
• Worked on cutom.pll changes
• Providing technical support in various Oracle EBS modules like Inventory, Order Management, Purchase Order.

Environment: Oracle EBS 11.5.10.2(Oracle Manufacturing (INV, BOM, WIPOrder Management, Purchase Order), TOAD, Oracle PL/SQL, Oracle Reports6i.