Experienced Oracle apps technical consultant with diverse experience in Oracle technologies. 16 years of IT experience. 13 Years of relevant experience in Oracle EBS. Worked extensively in Supply chain and EAM space and Oracle Projects. Expertise in development and enhancements of RICEW components. Good knowledge of O2C and P2P cycle. Adept in various phases of a Project Lifecycle including requirements gathering, development, testing, support and user training.
Oracle EBS, Oracle PL/SQL, OAF, Workflow Oracle forms, reports 6i, 10g and Alerts, SQL Developer, Discoverer, XML Publisher, Form Builder, Report Builder, SQL
Customers: Burns and McDonalds, HDR,
AECOM, Nutrien, Thales, NCH, SNC
Project Name: Oracle Projects EBS
R12 Product Implementation, upgrade(for few of clients) and support.
Role: Senior Developer, Location: Offshore
Team Size: 6
Duration : Aug, 2020 – Present
Project description: This project involves development and customization of RICEW components for Oracle Projects module.
Roles & Responsibilities :
Gathering requirements from the client. Development of code units for conversions/reports. Prepared technical design documents.
Customer: Potash/Nutrien, Canada.
Project Name: Potash Implementation and support(Oracle apps R12 implementation)
Role: Senior Developer, Location: Offshore
Team Size: 12
Duration : Jan, 2015 – Aug, 2019
Skills used: Oracle apps R12, Oracle SQL,
PL/SQL,OAF,Workflow
Project description: This project involves
development and customization of RICEW components for EAM, SCM and Finance modules.
Roles & Responsibilities :
Gathering requirements from the client. Development of code units for conversions/reports. Prepared technical design documents.
Customer: Brake Parts, USA
Project Name: Brake Parts(Oracle apps R12 implementation)
Role: Senior Developer, Location: Offshore
Team Size: 5
Duration : Mar, 2014 – Dec,2014
Project description: This project involves development of conversion & interfaces for Finance and SCM modules.
Roles & Responsibilities :
Gathering requirements from the client. Development of code units for conversions/reports.
Prepared technical design documents.
Skills used: Oracle apps R12, Oracle SQL, PL/SQL.
Customer: Fellowes, UK
Project Name: Fellowes Project UNO(Oracle apps R12 implementation)
Role: Senior Developer, Location: Offshore
Team Size: 10
Duration : May, 2013 – Jan,2014
Project description: This project involves development of conversion & interfaces for Finance and SCM modules.
Roles & Responsibilities :
Gathering requirements from the client. Development of code units for conversions. Prepared technical design documents.
Skills used: Oracle apps R12, Oracle SQL, PL/SQL.
Customer: Stanford University, USA
Project Name: EAM ITS
(Oracle apps R12 implementation)
Role: Senior Developer, Location: Offshore
Team Size: 5
Duration : Jul, 2012 – Jan 2013
Project description: This project involves development of conversion & interfaces for Oracle EAM(Enterprise Asset Management)
Roles & Responsibilities :
Gathering requirements from the client. Development of code units for conversions. Prepared technical design documents.
EAM - Worked on EAM for all historical data upload. (EAM Assets, EAM Activities, EAM Asset Routing, EAM Resource, EAM Asset Groups, EAM Asset activity association, Work orders, Material Transactions, Operation Completion)
Skills used: Oracle apps R12 , Oracle SQL, PL/SQL.
Customer: Stanford University, USA
Project Name: CADMS Phase 2B
Role: Senior Developer Location: Offshore
Team Size: 3
Duration : Nov,2011 – June 2012
Project description: This project involves developing reports for various level of management in Stanford.
Roles & Responsibilities : Gathering requirements from the client.
Development of reports.
Prepared technical design documents.
Skills used: Oracle Apps R12,XML publisher, Oracle SQL, PL/SQL.
Customer: IBM, USA
Project Name: Performance Redesign for AR-module(Oracle EBS)
Role: Senior Developer
Location: Offshore
Team Size: 3
Duration : March,2011 – Aug,2011
Project description: This project involves performance redesign of AR-Solution in data archive project.
Roles & Responsibilities: To develop selection & validation queries for AR module with customizations on existing packages for the new solution.
Skills used: Oracle Apps R12, Oracle SQL, PL/SQL.
Customer: Arbys, USA
Project Name: Wendy’s Arbys
Conversion
Role: Senior Developer Location: Offshore
Team Size: 6
Duration : Aug,2010 – Jan,2011
Project description:
A data migration project. It involved migration of employee’s personal as well as payroll information from Ultipro (legacy) system to Oracle Applications HRMS module. It also involves preparing custom forms to view the migrated data in Oracle applications.
Roles & Responsibilities:
Gathering requirements from the client on the customization
Created custom Forms for viewing migrated data.
Prepared Unit test cases & performed testing for the objects developed.
Prepared technical design documents for the objects developed.
Skills used: Oracle Forms Development, PL/SQL
,SQL Loader, Oracle Apps R12
Customer: ThyssenKrupp Elevator, USA
Project Name: TKE (ThyssenKrupp Elevator)
Role: Senior Developer Location: Offshore
Team Size: 12
Duration : April,2010 – Aug ,2010
Project description: This project involves Multi Language Support, in Dutch (NL) and French, to custom CEMLIS originally supported in American English (US).
Roles & Responsibilities: Performed MLS changes to forms, reports, packages and sql. Prepared documents for the changes made as part of changes incorporated and the Installation script for installing the changed objects (CEMLI).
Skills used: Oracle Forms Development, Oracle Reports Development, PL/SQL Coding, Oracle
apps R12,documentation and Testing.
Pune, Maharashtra