EXPERIENCE SUMMARY:

• Oracle Applications (EBS) Sr. Technical Consultant
• Having 15 years’ experience as an IT Professional and 13 yrs. using Oracle 11i / R12.
• Roles performed - Team Lead, Senior Technical Consultant, Analyst and Developer
• Implementation experience performing Technical work (Implementation, Rollout, Support, Conversion, Migration and integrations) ranging the different versions of oracle ERP applications 11i and R12. (Oracle EBS)
• Experience with full lifecycle implementations, extension, design and development (RICE / CEMLI) around Supply Chain Management, Procurement, Distribution, Manufacturing and Finance
• Proficient in functional and technical aspects of Oracle Modules - Financial (GL, AR, AP, CM, SLA), i-Expenses, Supply Chain Management (SCM) Modules, Oracle Distributions (Purchasing (PO), Inventory, Order Management (OM) and Shipping (WSH), OTC, Warehouse Management System (WMS), Trading Community Architecture (TCA), Oracle Service Contracts(OKS), Oracle Discrete Manufacturing (WIP, BOM, MRP, QA), Knowledge of Oracle Projects, Alert Manager (ALM), Sys Admin, Workflow, OAF and AOL.
• Experienced in order to Cash(OTC) and Procure to Pay(PTP) Cycles.
• Experienced in Performance Tuning.
• Upgrades; Migrations, Rollouts, Customizations and Extensions; Interfaces, integrations and Data Conversion.
• More than 6 Full life-cycle implementations of Oracle E-Business Suite
• Extensively used Oracle Application implementation methodology (AIM)
• Extensive knowledge of Oracle Apps tools, CEMLI, RICE and shell scripting.
• Knowledge of Web Center, Control-M Job setup and scheduling.
• Knowledge of Service Now, JIRA Ticketing systems and SVN Version Control System.
• Exposure to Oracle Retail Suite (ReIM, RMS9 and RMS14, SIM)

Oracle Tools/Components: Oracle Forms, Reports, SQL*Plus, SQL*Loader, Oracle Discoverer, Oracle Workflow, XML Publisher, Unix Shell Scripting, OAF Personalization and Customizations. Knowledge of OBIEE, APEX, EDI, ODI, SOA, Web Center and ADF.

Misc.: JIRA, GIT, SVN Version control system, Service-Now, TSRM, SQL Navigator, Toad, MS VSS, Smart FTP, MS Visual Basic, MS Access, Putty

Languages: SQL & PL/SQL, Java, HTML / XML

OS: UNIX (Sun/Solaris), LINUX, MS-Windows & MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Oracle Support Engineer

Environment: Oracle 11g, SQL, PL/SQL, R12 EBS, ReIM, EDI, RMS14, SIM, RIB, Unix, Control-M

Responsibilities:

• Working in R12 SCM and Finance(Payables, GL), Oracle Retail Invoice Management in Production support and Development.
• Working in the production support of EBS Payables integrated with Mainframe system and RMS.
• Perform trouble shooting production issues (Day to Day production Support)
• Working on Control-M Batch job processes involving Unix Shell Scripts, Pro*c and PL/Sql scripts.

Confidential, Atlanta, GA

Oracle Support EngineerTechnical Consultant

Environment: Oracle 11g, SQL, PL/SQL, R12.2.4

Responsibilities:

• Perform trouble shooting production issues (Day to Day production Support) and provide technical and techno-functional support for existing oracle E-Business modules;
• Analyze support tickets related to Oracle i-Expenses, Oracle Projects (PA), General Ledger(GL), Oracle Payables (AP), Order Management (OM), etc.
• Actively involved in system Administration, Application Object Library (AOL), Oracle Workflow Administration related works and issues.
• Maintain the work as per standards using SVN, Version Control system.
• Respond to the customer tickets for the issues related to OAF Personalization, XML Publisher Reports, Oracle Forms and Reports and UNIX shell Scripting program issues.
• Handling the issues arising during the data flow between the Integrated Systems. E-Business System is integrated with other systems using Oracle SOA. Integration programs include third party software such as, e.g. Atlas to Oracle, WEB Center Capture, Verifier, Imaging.
• Worked on Service Requests with Oracle Support team to resolve bottleneck issues

Confidential

Oracle Senior Technical Consultant

Environment: Oracle 11g, SQL, PL/SQL, R12.1.3

Responsibilities:

• Also, acted as Team lead, involved in Assessment of Time lines for different objects of Technical work, guided the team in completion of work in stipulated timeframes, updating the client with project status on regular basis.
• Developed Oracle conversions include custom conversions from Legacy applications (BI Cause way) to OracleAP (Suppliers, Open Invoices), INV (Item master), AR (Customer master, AR Open invoices, Receipts API), CE APIs (Bank, Brach, Bank Account), GL Interface, BOM (Master Data for BOM and Routings) and WIP (Jobs).
• Technical work - involved in implementation of Finance (GL, AR, AP, CM), OTC, Distribution and Manufacturing modules (PO, INV, OM, WMS, WIP, BOM, MRP, QA and Shipping). .
• Developed many xml reports as part of implementation.
• Migration of Master data, Transactional data, and development of reports for various modules are part of technical work handled during the implementation.
• Also involved in post-production support activities.

Confidential

Oracle Senior Technical Consultant

Responsibilities:

• Petrofac works on a full-fledged implementation constituting Human Resource (HRMS - Payroll, OTL), Finance (AR, AP, GL, CM) Projects, Purchasing, Manufacturing and Distribution Inventory modules (OTC, PO, INV, OM, WMS, WIP, BOM, MRP, QA and Shipping).
• Technical work involved Technical Support to Day to day business, working on Oracle project, bug fixing, reports development, Custom Objects development and Roll out work.
• Custom objects worked on includes Reports, Form Personalization, Client Extensions apart from Code pack preparation, shell scripts, Version History maintenance (SVN) and Ticketing system of Global Service Desk (GSD) maintained by IBM.
• Work also included Assigning the team with Tickets, Giving Time frame for tickets based on complexity, updating the SVN with completed objects, maintaining version history.
• Involved in legacy conversion to ERPP2P, OTC, Item Master and Interface development and product support, workflow customizations and AME Setups.
• Provided oracle Views to the OBIEE team to develop OBIEE Reports.
• Tuning of Oracle Views used for OBIEE, to increase the report performance.

Confidential

Technical Team Lead

Responsibilities:

• A full-fledged implementation constituting Purchasing, Inventory, Project Contracts and Finance modules (GL, AR, AP).
• The Customer Care and Billing (CC&B), MDM, WAM modules of Oracle Utilities should be integrated with E-Business Suite.
• Technical work involved Data migration for Oracle Utilities, Data Migration for E-Business Suite, large number of reports development, Custom Objects development and post production support.

Confidential

Team Lead

Responsibilities:

• Confidential is using R12 version of E-Business Suite.
• They need Customizations in PO Approval Workflow and Quote Approval Pages. Also, they need the Leave approval workflow to be modified as per their requirement.
• Technical work involved Customization to the Quote Approval Process and HRMS Leave Approval Workflow and customization to the Quote OAF Page.

Confidential

Technical Lead

Responsibilities:

• A full-fledged implementation constituting Purchasing, Distribution, Inventory, Manufacturing and Finance modules (GL, AR, AP, CM, PO, INV, OM, OTC, TCA, MES, WIP, BOM, MRP, QA and Shipping).
• Technical work involved Data migration, Oracle project discussion, large number of reports development, Custom Objects development and post production support.
• Worked on Bank Statements import and reconciliation using SWIFT940.
• Custom objects developed includes Average Cost Update program, Sales order Import, EFT Payment Instructions, Sub-Distribution (Drop Ship) program, Program to Integrate Weigh Bridge with Oracle Application and a custom program to maintain Import/Export Sales Information (TREO) for Kenya Revenue Authority (KRA).
• The development work constitutes OAF Personalization and Workflow. Purchase Order Notification and Purchase Requisition Notifications are to be customized as per client requirement. Enabling DFF in Purchase Order form and displaying the fields in the Purchase notification was another extension work performed.

Confidential

Oracle Team Lead (Offshore)

Responsibilities:

• Performed the role of Offshore Team Lead as well as involved in the development work.
• Maintaining the status reports and participating in the internal status meetings to review the work progress, etc.
• Upgrade from 11i to R12 and Development of Reports and Data Conversions.
• The objective of Technical Team was to identify the custom objects in 11i which needs to be remediated, analyse the custom objects, remediate them as per requirement and migrate them to R12 Instance.
• Performed the role of offshore Team lead, monitoring the Team, assigning objectives and timeframe for the team, maintaining the status reports that needs to be sent to client on site, conducting daily status meetings with offshore team and participating in status meeting with onsite team, assisting the team in completion of work and giving the deliverables on time to the client

Confidential

Oracle Technical Consultant

Responsibilities:

• Developed multiple Reports and PL-Sql programs.
• Performed the role of on-site co-ordinator. Sending Project Weekly Status, attending weekly status meetings, Requirement gathering and Analysis of new development work, Assigning the work to the team in off-shore, monitoring the off-shore team work, assisting the team in completion of work and giving the deliverables on time to the client.

Confidential

On-Site Co-Ordinator

Responsibilities:

• Developed multiple Reports, interfaces, Conversions.
• Developed Extension program for Average Cost Update of Layer costing method.
• Involved in developing plsql package to import Discrete job information from legacy to Oracle Application to create jobs, Complete jobs.
• Involved in implementation of Finance (GL, AR, AP), Distribution and Manufacturing modules.
• Worked closely with a variety of users from the operating line in order to understand their requirements. Designed solutions that met the customer expectations.