SUMMARY

• Over 10 years of experience in Oracle Application (R12 and 11i) implementation, upgrade, support, system design and development.
• Strong Experience in System Analysis, Requirement gathering, Design, Development, Conversion, Data migration, Customization, Interfacing, Implementation of business applications using Oracle ERP and Client/Server Technologies.
• Good working knowledge of all the stages of Software Development Life Cycle (SDLC) and well versed with documentation using Oracle’s Applications Implementation Methodology (AIM).
• Expertise in Oracle Applications Supply Chain Management (PO, iprocurement, INV& OM) and financial modules (AP, GL).
• Expertise in wide areas of responsibilities ranging from Client Interaction, Requirement Gathering, Process walkthrough, Functional Mapping, GAP Analysis, Functional Design documentation, Testing, Cutover and Production support.
• Experience on Procure - to-Pay (P2P) process along with the dependencies and relationships between other Oracle Applications modules and 3rd party applications.
• Actively involved in handling of many production issues and fixing Bugs, working in close proximity with Oracle Support by logging Service requests, escalations, patch analysis and application level enhancements.
• Strong verbal and written communication skills, organizational and interpersonal competencies required in dealing a client environment for successful implementation.
• Techno-functional knowledge in oracle Procure to pay modules for debugging the issues, providing custom solutions and handling integration issues.
• Proficient in designing interface/conversion program and mapping, pre-production testing and related documentation.
• Experience includes System Administration activities like managing AOL Objects, 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 or functional issues.
• Ability to manage changing responsibilities and delivering Time-critical projects on schedule. Proven ability to accept challenges and produce results in a multi-tasked environment.
• Self-motivated to learn new technologies and can work in a team or independently. Ability to communicate and work with people at different levels of Organization.
• Good experience and reviewing the PL/SQL code and Involved in peer review activities of the projects

TECHNICAL SKILLS

Oracle Applications Versions: R12/11i SCM Modules (PO, iprocurement, INV, AP, GL, OM)

Databases: Oracle 10g/9i/ 8i/8.0, SQL Server, MS Access

Languages: SQL, PL/SQLTools & Utilities Toad, Sql Developer, HP Quality Center/ALM, SQL*Loader, SQL Plus, WINSCP and Putty

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, Ohio

Solution Architect (Oracle ERP Sourcing)

Responsibilities:

• Bringing legacy systems into Oracle ERP arena by aligning it with Confidential Aviation ERP standards
• Following Fast works approach of Confidential, Requirement gathering through Business Demos / client interactions and CRP meetings.
• Analyzing Requirements and map them against Kittyhawk Oracle ERP eco system to identify deviations.
• Preparing GAP document and updating BR 100 document per Confidential AIM Standards.
• Engaging Business Functional and IT owners for closure of GAPS and conducting CRP sessions.
• Guiding development team for holistic solution to align the GAP or deviation with Aviation Standards as Lead Solution Architect for Sourcing track
• Release plan preparation and signoff.
• Lead development of custom objects and aligning it as part of CRP sessions for all SCM modules.
• RCA for Business critical issues and helping Support team as needed for closure
• Be a Functional evangelist for SCM modules to coach Business owners on Oracle ERP system.
• Preparing Functional and technical documentation as per Confidential AIM Methodology standards.
• Owning and maintaining right communication with Business owners, Site Leaders and the team for all implementation related activities.
• Planning GO Live Activities and cut Over plans and getting signoff from Business fraternity
• Working as SPOC for SCM Modules and represent Confidential Aviation in various Confidential level ERP initiatives.
• Training Site Users on Oracle ERP post implementation.
• Participating in Migration and upgrade activity planning.
• Involving in Code reviews to maintain Confidential AIM Standards.

Environment: Windows, Oracle Applications R12, TOAD

Confidential, Houston, Texas

Project Leader & On site Coordinator

Responsibilities:

• Principal consultant and responsible for implementations across the globe.
• Lead a team of 10 members to handle the site specific implementations.
• Planning the implementation road map and signoff from Business
• Identifying legacy applications to be sunset and new integrations to develop.
• Gathering the requirement by working with Business Stakeholders and Corporate
• Migration of all Buy to Pay Operating Units to Release 12 from existing 11i version.
• Analyzing existing Infra Specific Customizations and Personalization’s, map the existing functionalities to the R12 and preparing GAP Document.
• Preparing the design for each GAP and schedule them in Corporate tactical/Design calls for approval as a representative of Business.
• Data Migration and Conversion Validation and execution.
• Requirement gathering, preparation of AS IS and TO BE Diagrams, BRD, FSD and BR100 documents
• Creation of Organization Structure, Inventory Org and Project Accounting
• Creation of Set of Books (COA, Currency and Calendar)
• Defined value sets, value set values and setting up the cross validation rules
• Creation of org specific responsibilities and Locations
• Interface Monitoring and customizations ( like OHR, DWH and FAMS)
• Setting up Purchasing Option, financial Option, Receiving Options
• Setting up DFF and Purchasing Document Type
• Enabling PO/POC and RECEIPT Outbound and Inbound interfaces.
• Creating Users, Suppliers and Supplier Sites.
• Creating Jobs, mapping with Approval Groups and Approval Assignments.
• Conducted training for new business users and support teams.
• Customization and personalization as per Business requirements. Design and development of Conversions, Interfaces and Reports.

Environment: Oracle Apps 11i & R12 Purchasing and Finance Modules.

Confidential, Atlanta, Georgia

Team Leader

Responsibilities:

• Project Leader for the implementations across US and Europe.
• Requirement gathering, preparation of BRD, FSD and BR100 documents
• Creation of Organization Structure, Inventory Org and Project Accounting
• Functional setups in PO, iprocurement, AOL and sysadmin modules.
• Setting up DFF and Purchasing Document Type
• Enabling PO/POC and RECEIPT Outbound and Inbound interfaces.
• Conducted training for new business users and support teams.
• Design and development of Conversions, Interfaces and Reports.

Environment: Oracle Apps 11i Purchasing and Finance Modules

Confidential, Atlanta, GA

Team Leader

Responsibilities:

• Perform study on current business process
• Attending Business calls for providing solutions for high risk issue occurred in Business flow and enhancements, up gradation and Impact Analysis
• SSP5 Post Production (Customized iProcurement Module for Confidential )
• Setting up of Business rule, CVR & Security Rules
• Participating in business testing, debugging, Oracle setups, project management
• Customizing reports based on business requirement.
• Dashboard Report Generation and Involved in preparing metrics for functional support for the client

Environment: Oracle Apps 11i Purchasing and Finance Modules

Confidential, Atlanta, Georgia

Techno-Functional consultant (Procure to Pay)

Responsibilities:

• Provided end-user support and Implemented Approver Hierarchy, Functional/Item/Category Gate keeper Setups for few businesses.
• Analyzing and solving problems related to stuck in Requisitions / PO and resolving issues in real-time.
• Performed trouble shooting by checking workflow and validating the business customization.
• Creating Confidential Energy Ship-to-Location, Bill-to-Location and Tax codes.
• Business Objects Gatekeeper Setup Legal Entity, Account, Function Level Gatekeepers / Approver setup for COA.
• Providing technical support in guiding the users to create Requisitions/ Purchase Orders.
• Implemented functional modification for Confidential Energy NRPS (US and UK) business for converting position-based hierarchies to one-to-one hierarchy for Oracle Purchasing.

Environment: Oracle Apps 11i Supply Chain Management, ACS