Oracle Apps Lead Consultant Resume
Houston, TX
SUMMARY
- 10+ years of experience as Oracle Applications (EBS) Consultant with working experience in Oracle Application E - Business Suite Versions R12/11i in multiple Oracle Application projects.
- Extensive experience in Oracle CRM (CRM, Install base, Field Service, Teleservices, Depot Repair, Service Contracts), Oracle Supply Chain Management (SCM), Oracle Manufacturing (MFG), Oracle Financials E Business Suite, Oracle cycles Procure To Pay (P2P) and Order To Cash (OTC)
- Experience in implementation Process mapping, configuration, as is analysis, to be process development integrating various modules, Fit - Gap Analysis & Developing Functional Design Specifications, test scripts and end user training
- Proficient in Technical Analysis, Configuration and testing of new Development, customization of existing systems, involving Technical expertise on different modules PO, AP, AR, INV, OM, BOM, WIP, Advanced Pricing, Quality, GL, AME, Service Contracts, Install Base, Field Services, Tele Services and Depot Repair
- Involved in implementation, Upgrade, Rollouts and Support of Oracle Applications E-Business Suite using SQL, PL/SQL, Developer Suite 10g, with hands-on experience of various RICE components
- Have experience on Trading Community Architecture (TCA). Multiple full Life Cycle Implementations and upgradations from 11i to R12. Technical impact assessment and estimate proposals for Oracle apps R12 Upgrade/re-implementation.
- Leading/mentoring teams on technological and process fronts. Capable to work independently and Team environment plus sharp first look analysis
- Experience managing technical quality deliverable/ resource/schedule/risks throughout the project, working extensively under onsite-offshore model using AIM Methodology.
- Prepared AIM documents like BR100, MD050, MD070, MD120, CV040 and TE020.
- Design and development of interface, conversion programs and external packages and custom applications and to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
- Involved in Oracle Apps. Interface Enhancement, Report Customization, Forms personalization’s and other regular activities like Registering Forms and Reports, creation of Users, Responsibilities etc.
- Well versed with Development and Implementation of large application oriented project. Excellent communication skills, good interpersonal skills and am dedicated, disciplined and a good team player.
- Having International Onsite Experience in Europe (Netherlands )
TECHNICAL SKILLS
Oracle E-Business: Oracle Apps R12, Oracle Apps 11i, CRM, Oracle Supply Chain Management (SCM), Oracle Manufacturing (MFG), Oracle Financials E Business Suite, Oracle cycles Procure To Pay (P2P) and Order To Cash (OTC), AME, Oracle BPEL, SQL, PL/SQL, Reports, XML Publisher Reporting Tools, Forms, AOL, System Administration
Tools: TOAD, SQL Loader, SVN, MS Visio, and MS-Office, UPK
PROFESSIONAL EXPERIENCE
Confidential, Houston TX
Oracle Apps Lead Consultant
Responsibilities:
- Review of the existing business processes.
- Involved in the functional Global design solution architecture in manufacturing stream.
- Identify the GAP requirements to assess its fitment with respect to the functionality provided by the Application.
- Prepare High Level Business Process flows of ‘As is’ and simulation covering prototyping of the “To Be” Business Process flows.
- Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, training, conversions, customizations and implementation of modules
- Wrote Functional Design Document (MD050s) and Technical Design Documents (MD070s) based on the Business Requirement document
- Reviewing the functional documents(MD050s) and Technical Design Documents (MD070s)
- Analyzing the existing solutions and enhancing the existing solution to be global solution.
- Prepared the RICE Tracker for tracking the progress of the RICE components and discuss with users to progress the components.
- Helped QA analysts and technical team with troubleshooting and fault resolution
- Prepared the Unit test plans and supported the users in CRP, SIT and UAT.
- Involved in the RFC process and created the kintana packages for the promoting the code and AOL objects from development to CRP, SIT, UAT and Production instances.
- Prepared the UPKs and Training materials for End user Training.
Environment: Oracle Applications R12. Services (Install base, Teleservices, Field Service, Depot Repair and Spares Management), Order Management, Inventory and BOM
Confidential, Denver CO
Oracle Apps Lead Consultant
Responsibilities:
- Involved in requirement gathering from global users
- Involved in Gap Analysis.
- Involved in the technical feasibility of the requirements
- Analyzing the requirements and preparing the functional documents
- Leading technical onsite & offshore project team, task allocation, status monitoring and ensuring quality & timely delivery of the deliverables
- Wrote Functional Design Document (MD050s) and Technical Design Documents (MD070s) based on the Business Requirement document
- Reviewing the functional documents(MD050s)
- Involved in preparation of As Is and To be process flows
- Peer reviewing the code and documents
- Analyzing the existing solutions and enhancing the existing solution to be global solution.
- Prepared the RICE Tracker for tracking the progress of the RICE components and discuss with users to progress the components.
- Involved in setting up users and defining resources and assign roles as per the requirements using CRM Administrator responsibility
- Helped QA analysts and technical team with troubleshooting and fault resolution
- Prepared the Unit test plans and supported the users in CRP, SIT and UAT.
- Involved in the RFC process and created the kitana packages for the promoting the code and AOL objects from development to CRP, SIT, UAT and Production instances.
- Helped the Team members in resolving the CRP, SIT and UAT issues.
Environment: Oracle Applications R12. Services (Install base, Teleservices, Field Service, Depot Repair and Spares Management), Order Management, Inventory and BOM
Confidential, Denver CO
Lead Oracle Apps Technical Consultant
Responsibilities:
- Prepared the Architecture diagram
- Involved in the technical feasibility of the requirements
- Involved in Gap Analysis.
- Leading technical onsite & offshore project team, task allocation, status monitoring and ensuring quality & timely delivery of the deliverables
- Analyzing the requirements and preparing the Technical documents(MD070)
- Peer reviewing the code and documents
- Validated technical designs created by Developers against functional specifications.
- Developing the extensions for the flexible Application
- Developing the User authentications.
- Prepared the User Manual for the QA Certs Automation.
- Developed the XML Publisher reports.
- Developed XML templates according to customer’s requirements and required format based on Oracle
- Tuned SQL and PL/SQL to improve the performance of custom programs.
- Prepared the Unit test plans (TE020) and supported the users in CRP, SIT and UAT.
- Involved in the RFC process and created the kitana packages for the promoting the code and AOL objects from development to CRP, SIT, UAT and Production instances.
- Helped the Team members in resolving the CRP, SIT and UAT issues.
Environment: Oracle Applications R12. Oracle Quality, OM and INV, Oracle Forms, Reports, Form Personalization, TOAD, UNIX, BI (XML) Publisher, SQL * Loader, PL/SQL, API.
Confidential, Denver CO
Lead Oracle Apps Technical Consultant
Responsibilities:
- Gathering, refining, and documentation of the business rules, functional and technical requirements.
- Prepared the programs to load Price List Lines, Modifier Lines, Price List Qualifiers, Modifier List Qualifiers, Modifier Line Qualifiers and Secondary Price list uploads.
- Leading technical onsite & offshore project team, task allocation, status monitoring and ensuring quality & timely delivery of the deliverables
- Establishing quality processes and ensuring processes are followed as per defined standards and guidelines
- Wrote SQL Scripts to create, alter, and drop database objects like tables, views, and sequences.
- Worked on Customizations using Oracle Apps standard API & Packages
- Resolving the issues related to Procure to Pay (P2P) and Order to Cash (O2C).
- Prepared Technical Spec for JDI Pricing Tool
- Prepared the User Manual for the JDI Pricing Tool.
- Responsible for writing Functional (MD050), Technical Specification (MD070) and Test Scripts.
- Performed Technical review of the code and mentoring juniors in the team
- Prepared the programs to assign the Items, Export Attributes and BOM to the Inventory organizations of the sales Offices.
- Helping the Team in resolving the Functional issues.
Environment: Oracle Applications R12. Advanced Pricing, Inventory, Bill of Materials, Oracle Forms, Reports, Form Personalization, TOAD, UNIX, BI (XML) Publisher, SQL * Loader, PL/SQL
Confidential
Lead Oracle Apps Technical Consultant
Responsibilities:
- Gathering, refining, and documentation of the business rules, functional and technical requirements.
- Performed GAP analysis and prepared solution presentation for review
- Analyze requirements and provide support to offshore.
- Involved in Code and AOL programs migration to CRP testing environment from DEV
- Prepared Conversion Mapping document (CV040)
- Developed Export Programs.
- Created test scripts for every level of testing from unit testing stage to integration testing.
- Partner with Oracle support team, business team, and other vendor parties to identify and remedy key issues introduced by upgrade.
- Conduct Technical analysis for developing new exports.
- Updating of Technical documents (MD070), Unit Test documents (TE020) and Setup documents (BR100).
- Trouble shooting route cause analyze, Rework and defect analyze.
- Review the Design docs, Testing etc.
- Developed Unix Shell Scripts to migrate the Form Personalization code, XML Publisher code to different instances.
- Worked actively to trouble shoot defects and problem during the string and user acceptance testing and resolve issues
- On-Site Coordinator
Environment: Oracle Applications 11i and R12, Oracle 10g. HRMS, PA, PO, AP, GL, AR, TCA, Oracle Reports, TOAD, UNIX, BI (XML) Publisher, SQL * Loader, PL/SQL
Confidential
Senior Oracle Apps Technical Consultant
Responsibilities:
- Client Interaction, collecting requirements.
- Analyze requirements and provide support to offshore.
- Customization and Developing of Inbound and outbound Interfaces.
- Developed control files for SQL* Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system
- Developing the Custom forms.
- Creation of utl files Registered Executable and Concurrent Programs.
- Creation of MD070 For functional design documents and Test cases.
- Peer review and quality control
- Involved in client discussions for resolving the issues.
- Responsible for creating Responsibilities, Users and assigning them to the Users.
Environment: Oracle Applications 11.5.10.2, Oracle BPEL, Toad, PO, AP, AR, OM, Install Base, Oracle Forms, TOAD, UNIX, BI (XML) Publisher, SQL * Loader, PL/SQL
Confidential - Troy, MI
Oracle Apps Technical Consultant
Responsibilities:
- Registration of Forms, Reports, Tables, Concurrent programs, Interface, Packages and value sets
- Registered Executable, Concurrent Programs and assigned the programs to appropriate responsibility.
- Customization Design and Development of forms and reports for PO, INV & OM modules.
- Testing and Code walk through for Customized reports.
- Code review, Peer review, Team building and Motivation
- Technical guidelines and training, Quality process check
- Trouble shooting route cause analyze, Rework and defect analyze
Environment: Oracle Applications 11i, PO, INV and OM, Forms, Reports, SQL * Loader, PL/SQL
Confidential, Columbus, OH.
Oracle Apps Technical Consultant
Responsibilities:
- Creation of MD .070 Application Extensions Technical Design
- Creation of TE .020 Unit Test Script
- Creation of database objects
- Execution of Test Plan
- Review and Maintenance of Documents, Code, database objects
- Developing SQL Query and Oracle Reports according to the Super user requirement.
- Registered Executable, Concurrent Programs and assigned the programs to appropriate responsibility.
- Designing and implementing interfaces/Custom Interfaces for Oracle apps consolidation.
- Participation in Technical Reviews, development and testing.
- Status monitoring and reporting to Program Manager.
Environment: Oracle Applications Release 11i Implementation PO, INV, BOM & OM, SQL * Loader, PL/SQL