Candidates About

 

Rajesh Kumar

Oracle Apps EBS Techno Functional Consultant

Summary:

·         Having 14 years of diversified Technical & Functional expertise in Oracle Applications R12/11i, with extensive exposure in Design, Development, Configuration, Implementations, Production Support and Upgrades in Financial, Supply Chain, and Manufacturing & HRMS/Payroll/Benefit Modules.

·         Proficient in all phases of Oracle Applications R12/11i implementation with major focus in Financials (GL, AR, AP, CM, SLA, FAH), Oracle Supply Chain & Manufacturing Modules (INV, OM, Advance Pricing, Shipping, PO, WIP), Oracle HRMS & Payroll, AOL, and System Administration module.

·         Extensive experience in design and development of Oracle application framework, Oracle SOA Suite 11g & 12c, Oracle BPEL Process manager, Oracle Reports, BI/XML Publisher Reports, Oracle Apps Forms, Interfaces, Conversions, Extensions, Workflow, Unix Shell Scripts, form Customizations, Custom.PLL, Forms Personalization and all other RICE objects to meet customer requirements in Fresh Implementation and Production Support projects of Oracle Applications.

·         Extensive experience with PL/SQL & SQL.

·         Experience working on SQL*Loader, SQL* Plus.

·         Prepared the Technical Specification documents, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents & Sysadmin setup documents

·         Worked on Documentation using AIM methodology for Technical Design Documents (MD70), Functional Design Documents (MD50), Installation Documents (MD120), Business Requirements Setups (BR100), Conversion Mappings (CV40) and Conversion Test Plans (CV70).

·         Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).

·         Experience in Order to Cash (O2C) and Procure to Pay (P2P) business flows.

·         Proficiency in understanding client’s needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.

·         Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.

·         Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.

·         Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values set, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.

·         Worked with Offshore Technical team on Development, Testing and Migration of Objects.

·         Experience in month end closing activities in Finance.

·         Hands on experience in troubleshooting issues and resolving tickets on priority.

·         Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.

·         Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.

 

Education & Certification:

 

Ø Masters in Computer Applications from Kurukshetra University, INDIA.

Ø Masters in Mathematics from Kurukshetra University, INDIA.

Ø Bachelor in Computer Science from Kurukshetra University, INDIA.

 

Trainings:

 

§  Oracle HRMS functional from Oracle Corporation.

§  Oracle Apps Forms and Reports development training from Sonata Software Limited.

§  Oracle Workflow Builder from Sonata Software Limited.

§  Oracle Discoverer from Sonata Software Limited.

§  XML Publisher Reports from Sonata Software Limited.

§  UNIX Shell Scripting from BirlaSoft Limited.

§  OA Framework & Java training from Birlasoft.

§  Oracle Lease Management from Birlasoft Limited.

 

 

Technical Skills:

 

ERP	Oracle Applications R12, 11i
E-Business Suite Modules	AP, AR, GL, CM, SLA, FAH, FA, PO, SYSADMIN, INV, OM, PO, HRMS, Payroll/Benefit, OIC
RDBMS	Oracle 12c, 11g, 10g, 9i, 8i
Operating Systems	LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP
Languages	SQL, PL/SQL, C, C++, Java
Tools & Utilities	Oracle application framework(OAF), Oracle SOA Suite 12c/11g, Oracle BPEL process manager, Forms 10g/6i, Reports 10g/6i, XML/BI Publisher, SQL*Plus, SQL*Loader, Oracle Workflow Builder, TOAD, SQL Developer, JDeveloper, MS Visio, Data Loader, WEBADI, DATALOAD, WINSCP, Putty, SecureCRT, SecureFX, Perforce, BMC Remedy, HP Quality center, Appworx, Sharepoint, Microsoft word, excel, PowerPoint
Documentation	AIM Documentation (MD070, MD120, MD050, BR100, CV60, CV40)

 

Professional Experience:

 

Helena Chemical Company, Collierville TN                                                                 Feb 2016 – till date

Role                             Oracle Apps Techno Functional Consultant

Project Description    It is Oracle Apps R12 reimplementation project. My role is Oracle Apps Techno Functional Financial & SCM and HRMS consultant.

Client Description:  

Founded in 1957, Helena Chemical Company has grown to be one of the nation’s foremost agricultural and specialty formulators and distributors in the United States. Products and services offered include Crop Protection Products, Fertilizer and Fertilizer Application Services, Specialized Nutrients, Seed and Seed Treatments, Financial Services, and Precision Ag Services and Software.  Helena also offers its own line of products — Adjuvants, Bioscience, Branded Fertilizers, Nutritionals, Seed Treatments and Value-Added Products — through the Helena Products Group (HPG).

 

Responsibilities:

§  Worked on OAF form development, customization and personalization.

§  Worked on Oracle SOA suite 12c/11g and developed web services.

§  Deals in Oracle BPEL Process Manager development.

§  Worked on design, development, support and customization of RICEW in (GL, AP, OM, INV, PO, HRMS, Payroll and Benefits) modules.

§  Worked on SQL and PLSQL.

§  Worked on inbound and outbound interfaces.

§  Worked on design and development of HR Employee/Assignment/Address inbound import interface.

§  Developed outbound interfaces for New Hire, W4, W2, Tax, Direct deposit & Payroll data.

§  Worked on design and development of AP Vendor Prepayment OAF forms and Approval workflow.

§  Worked on design and development of Product Load OAF Page and item import from Monsanto to Oracle EBS.

§  Worked on design and development of Cigna HR and Benefit from Oracle HR to Cigna.

§  Worked on design and development of custom prepay approval hierarchy setup form.

§  Worked on oracle form personalization.

§  Worked on various Oracle Report/ BI publisher reports development and customization.

§  Provided support to issues related to WEBADI.

§  Worked on performance tuning of existing custom interfaces.

§  Worked on MD050 and MD070 documents.

§  Deals in key flex filed and descriptive flex field.

§  Support, enhancement and bug fixes of custom interfaces.

§  Unit testing of the object developed.

 

Environment: Oracle Applications R12.1.3 (HRMS, Payroll, Benefit, INV, OM, PO, AP, AR, GL, AOL, SYS ADMIN), Oracle Database 12c/11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy.

 

 

Boart LongYear, Salt Lake City UT                                                                            Jul 2015 – Jan-2016

Role                             Oracle Apps Techno Functional Consultant

Project Description    It is Oracle Apps R12 reimplementation project. My role is Oracle Apps Techno Functional Financial & SCM consultant.

Client Description:   

Boart Longyear offers a full range of drilling products to suit many applications in the mining and drilling industry globally. Boart Longyear is a leading manufacturer and supplier of drill rigs to the global mining industry. A global full-service team provides every angle of support including maintenance, spare equipment sales, commissioning, training, rentals, rig customization and service exchange, and other drilling products.

 

Responsibilities:

§  Worked on support and enhancement of RICEW in Financial (GL, AP, OM, INV, and WIP) modules.

§  Worked on SQL and PLSQL.

§  Worked on inbound and outbound interfaces.

§  Worked on design and development of GL journal import interface.

§  Worked on design and development of Inventory ONHAND custom conversion.

§  Worked on design and development of WIP Work Order custom conversion.

§  Worked on design and development of Copy Supplier Site custom conversion.

§  Worked on design and development of custom integration (Inbound & Outbound) between mobile application and Oracle R12 by calling web services.

§  Worked on custom form development for IR/MD.

§  Worked on oracle form personalization.

§  Worked on Oracle Report/ BI publisher report.

§  Worked on performance tuning of existing custom interfaces.

§  Worked on MD050 and MD070 documents.

§  Deals in key flex filed and descriptive flex field.

§  Support, enhancement and bug fixes of custom interfaces.

§  Unit testing of the object developed.

 

Environment: Oracle Applications R12.1.3 (INV, OM, PO, BOM, WIP, AP, AR, GL, AOL, SYS ADMIN), Oracle Database 12c/11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy.

 

 

Cummins Columbus IN                                                                                             Feb 2015 – Jul 2015

Project Description    It is Oracle Apps R12 Support and Enhancement project. My role is Oracle Apps Techno Functional Financial consultant.

Role                             Oracle Apps Techno Functional SME          

Client Description:

Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service diesel and natural gas engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems.

 

Responsibilities

§  Worked on support and enhancement of RICEW in Financial (AR, AP, GL, and CM) modules.

§  Worked on configuration in R12 EBS financial modules.

§  Worked on root cause analysis of various production issues.

§  Worked on SQL and PLSQL. Deals in inbound and outbound interfaces.

§  Worked on Oracle Report/ BI publisher report support and fix.

§  Worked on MD050 and MD070 documents.

§  Deals in key flex filed and descriptive flex field.

§  Deals in WEBADI & DATALOAD.

§  Support and enhancement and bug fixes of custom interfaces.

§  Worked with Oracle on production support issues related to financial modules.

§  Worked with Oracle support to resolve the complex issues in production over the period end.

 

Oracle Applications R12.1.3 (INV, OM, PO, AP, AR, GL, AOL, SYS ADMIN), Oracle Database 11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, Toad, SQL Developer, BMC Remedy, APPWORX.

 

 

CUNA Mutual Madison, WI                                                                                        Oct 2014 – Jan 2015

Project Description    It is Oracle Apps R12 project. My role is onshore Oracle Apps Techno Functional Financial consultant.

Role                             Oracle Apps Techno Functional Consultant

Client Description:

For more than 80 years, CUNA Mutual Group has worked tirelessly to deliver product and service solutions that meet the unique challenges and needs of credit unions and their members. CUNA’s vision is unwavering: to be a trusted business partner who delivers service excellence with customer-focused, best-in-class products and market-driven innovation.

 

Responsibilities

§  Created functional design document (MD050) for custom Interfaces for GL and FAH.

§  Created technical design document (MD070) for custom Interfaces for GL and FAH.

§  Worked on GL Journal import interface.

§  Worked on custom PL/SQL API package development and writing SQL scripts.

§  Worked on Customization of BI publisher reports.

§  Configuring Oracle R12 General Ledger in Oracle EBS.

§  Worked on SLA & FAH configuration in R12 EBS.

§  Created BR100 (Config document) document for Oracle EBS R12 GL, SLA & FAH.

§  Configuring Key Flex field and Descriptive Flex field.

§  Worked on the troubleshooting of functional and Technical issues.

 

 

Oracle Applications R12.1.3 (GL, FAH, SLA, AOL, SYS ADMIN), Oracle Database 11g, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer, BMC Remedy.

 

 

Brinks Inc. Dallas, TX                                                                                                Jun 2014 – Sep 2014           

Project Description    It is Oracle Apps R12 data conversion project. My role is onshore Oracle Apps Techno Functional Financial consultant.

Role                             Oracle Apps Techno Functional Consultant

Client Description:

Brink’s is popularly known for its bullet-resistant armored trucks which are used to carry money and valuable goods (once used to transport the Hope Diamond from an auction to the buyer's home). Brink’s is a provider of security services to banks, retailers, governments, mints and jewelers.

 

Responsibilities

§  Created CV200 mapping documents for Oracle Apps Data conversion for AR and Contract.

§  Created functional design document (MD050) for AR customer conversion.

§  Worked on WEBADI & DATALOAD.

§  Created technical design document (MD070) for AR customer conversion.

§  Written test cases for AR customer creation/updating interface testing.

§  Worked on BI Publisher Reports and Oracle Reports.

§  Worked on custom PL/SQL API package development and writing SQL scripts.

§  Worked on functional and technical design document for custom forms GUI.

§  Functional design document for Service contract inbound interface.

§  Written test cases for service contract creation interface testing.

§  Created legacy to EBS mapping documents for Customer and Contracts.

§  Configuring Key Flex field and Descriptive Flex field.

§  Resolved technical issues related to Reports (RDF & BI Publisher).

 

 

Oracle Applications R12.1.3 (AR, Service Contracts, TCA, AOL, SYS ADMIN), Oracle Database 11g, PL/SQL, SQL, Oracle Forms 10g, Oracle Reports 10g, BI Publisher, SQL Developer.

 

 

 

QBE Insurance / Accenture Services Sydney, Australia                            May-2013 - May-2014

Project Description    It is Oracle Apps R12 & 11i Financial Support/enhancement project. My role is Oracle Apps Techno Functional Financial SME for R12 and 11i applications for all the entities which include Australia, New Zealand and Pacific Island.

Role                             Oracle Apps Techno Functional Consultant          

Client Description:

QBE Insurance Group Limited is Australia's largest global insurer. It provides insurance services to Australia, America, Europe and Asia Pacific region. QBE has around 17000 Plus employees in 38 countries worldwide.

 

Responsibilities

§  Worked on AR invoice, AR Customer, AR receipt, GL Journal Inbound Interfaces development and support.

§  Cash Management interfaces for various third party legacy systems to Oracle EBS12 for Westpac, ANZ & Commonwealth bank.

§  Custom PL/SQL package development and writing SQL scripts.

§  Oracle Reports and BI Publisher report development and enhancement.

§  Updating Functional Design documents for any redesign/enhancements.

§  Any issues/setting up Key Flex field and Descriptive Flex field.

§  Any Technical issues related to Interface (Inbound & Outbound).

§  Any Technical issues related to Reports (RDF & XML Publisher).

§  FAH integration of underwriting systems EVOLVE, TRAVEL, AOPCICS & CTPCICS to General Ledger.

§  Created various Data Load scripts across Oracle Apps modules which were re-used.

§  Worked on various config issues during development and UAT and their resolution.

§  Writing Test scripts and Test scenarios in Oracle Financials.

§  Coordinated with clients and offshore team members to gather requirements and facilitate the development.

§  Worked on various issues related to WEBADI.

§  Worked on the workflow customization.

§  Responsible for support & maintenance of AP, GL, SLA, AR, CM, AGIS, FAH and FA.

<p class="MsoListParagraphCxSpMid