Professional Summary:

**+ years of extensive experience in Oracle Applications R12/11i EBS full life cycle implementations, business process analysis, evaluation, upgradation, rollouts, enhancements, data conversion and integrations of Oracle Financials and SCM modules with third party applications.

Experience in various business process like Order to Cash (O2C) & Procure to Pay (P2P)

Hands on experience in Oracle EBS on requirement study, fit gap analysis, solution design, application setup and testing of Oracle financials and SCM modules.

Highly skillful in Designing completely new system and troubleshooting the legacy systems with unique ability to deliver under critical time bound requirements.

Expertise in Development of Inbound & Outbound Interfaces, Conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using SQL, PL/SQL, Data Load, SQL*Loader, PL/SQL and UTL File Utility for Outbound Interfaces.

Customizations of Oracle Workflows, Oracle Reports using XML Publisher, and Oracle Forms & Reports, Form Personalization’s.

Has expertise in Oracle Applications E- Business Suite on Oracle General Ledger ( GL ), Subledger Accounting (SLA), Accounts Receivables (AR), Accounts Payables (AP), Financial Accounting Hub (FAH), Oracle Purchase Order ( PO ),Oracle Project Accounting (Project Foundation, Project Costing, Project Billing) and OTL modules and has Good Knowledge in Oracle Workflow Builder.

Active Participation in different phases of CRP1, CRP2, SIT, UAT, Production Cutover, Cutover Support.

Expertise in various Application Extensions, Conversions, and Process Re-engineering (RICE) and preparing Technical Document Design and Testing Documents developed through Oracle User Productivity Kit Professional (UPK) tool.

Experienced in coordinating and translating the information between The Client, Business users, Business Analysts, End users and offshore developers within Project and Tech Mahindra.

Complete understanding of the Oracle Upgrade process involving in pre-upgrade analysis, pre-upgrade configurations, patch planning, post upgrade configurations, testing, CEMILI identification and migration and post upgrade support.

Extensive working experience in Production support and Month End Support– Identifying issues, prioritization, performing root cause analysis, and providing solutions as needed.

Proficient in creating SR’s with Oracle Technical Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) sessions with Oracle Support Team

Hands on experience in writing test cases as part global GL period close which includes GL period closing activity including running revaluation, reporting currencies, translation, MRC, consolidation, reconciliation GL with sub ledgers, SLA drill down reports and opening and closing GL periods

Proven hands on experience in understanding various types of EBS interface testing requirements, designing effective testing cycle, drill down to PLSQL validation, EBS open interface tables, writing SQL to match with base table data.

Working Experience with onsite offshore model and managing offshore resources. Ability to adopt and master quickly new software technologies. Excellent team player with good communication and interpersonal skills.

Academic Details:

Bachelor of Engineering in Instrumentation from Marathwada University, India 2002

Client: GE Appliances (Louisville, Kentucky)

Oracle EBS R12 (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Oct-2016 to Till Date

Project Summary: GE Appliances is an appliance company headquartered in Louisville, Kentucky. It is owned by Haier, it is one of the largest appliance brands in the United States and manufacturers appliances under the brands of GE, Profile, Cafe, Monogram, and Hotpoint.

As a Project Lead was responsible in Development Activities

Requirement gathering, analyzing, documenting and designing the solution.

R12 Development – Create Technical designs documents and develop the application as per Functional design.

Dimensions of Data Quality

Developed an AR Interface from a Legacy system called Orion

Developed FA Periodic Mass copy Program

As per the New Enterprise Standards Chart of Account (ESCOA), Modified all the existing Finance Related Reports and Interfaces (SSS GL, SSS CM, FA Periodic Mass copy)

Developed MOR & GAP Rates Inbound Interface from GE Treasury Server

Developed AR Invoices Inbound interface from third party system (Concur) for Poland Site

Developed Web cash Interface for Payments (from R12 Oracle AP module to web cash server).

Onsite team member at the client and coordination with offshore Technical, functional and testing team including working as liaison between business users, offshore team, helping offshore team to understand data conversions, customizations, integrations, execution of test cases across Financials.

Involved in testing the Functionality on the application for all new change request and new Roll Outs specific to Project Accounting Module using the existing Capgemini Specific Testing Scripts

Design the technical solution for Finance (GL, AP,AR and FA) Project costing, Project Billing and Cost Management

Closely worked and coordinated and tested with the technical teams to deliver the solutions as per the functional designs.

Designed and Performs detailed Validations on Inbound and outbound interfaces required to third party and Oracle EBS.

Data conversion of customers, suppliers, open AR transactions, GL balances, budgets and fixed assets

Application: Oracle EBS R12.2.6, Modules: GL, AR, AP OM, PO, BOM, WIP

Reporting: Oracle Developer

Tools/Language: Oracle Workflow Builder, Chainsys Apploader, SQL*Loader, XML Publisher, Toad, SQL Developer, UTL File, SQL Trace, TKproof, Chainsys Loader for MDM Data.

Client: GE Aviation

Oracle EBS Financials Implementation(R12)

Role: Oracle Apps Technical Consultant

Duration: Apr-2015 to Oct 2016

Project Summary: GE Aviation, a subsidiary of General Electric, is headquartered in Evendale, Ohio, outside Cincinnati. GE Aviation is among the top aircraft engine suppliers and offers engines for the majority of commercial aircraft. GE Aviation is part of the General Electric conglomerate, which is one of the world's largest corporations

Our Current project is a support and maintenance project. we support 6 operating units based in Europe Region and the main location is Prague. We are supporting in Manufacturing & Financial Modules for all 6 sites Czech Republic, Poland, Unison Poland, Germany, Mexico, Romania and Turkey. Every Quarter we have enhancement requests which are identified during support. Also Based on the priority of Business Requirements Emergency change requests are raised every quarter enhancement requests.

Responsibilities:

As a Project Lead was responsible in Development Activities and Support of the Project. Also monitoring the delegation of work to the team. Below are the few responsibilities

Requirement gathering, analyzing, documenting and designing the solution.

R12 Development – Create Technical designs documents and develop the application as per Functional design.

Responsible for identifying, analyzing, and resolving technical problems with Oracle Applications.

Developed Global DR4 Interface of GL Module to be used across all the sites (Poland, Mexico and Turkey)

Design data migration strategy for day to day data, PO’s, Items, Suppliers, AP Open invoices.

Developed a Program to create the On-Hand Quantity in Inventory

Developed a Program to create the Customers, Accounts, party sites, Party Relationships, Account Relationships

Developed a Program to create the Item Orderability, Po Modifiers & Qualifiers, BOM & Routings, and Sales Agreements

Developed a Program to create the Billing References in R12.2.4 (User Defined Attributes)

For CZECH site, Developed BOM Routings Interface

Developed a Program to create the Move Orders for the Released Jobs.

Developed Item On-Hand Report, Inventory Ageing Report, WIP Dispatch List Report

Developed one of the most challenging Report called LOT Genealogy report as per the requirements and Developed more than 20 Reports using XML Publisher

Helping the team for any technical issues and Coordinating with team and project manager.

Execute Test Scripts as per Shakedown and Regression test documents.

Prepared the training material for UAT and conducted web sessions to train the business users.

Cut-over planning and go-live activities, followed by production support.

Environment: Oracle R12 (Payables, GL, AR, FA, BOM INV, WIP), Oracle Workflow Builder, Report Builder, SQL Plus, SQL Developer, Toad, SQL Loader, Oracle Forms & Reports 6i

Client: GE Healthcare

Oracle EBS Implementation(R12)

Role: Oracle Apps Technical Consultant

Duration: Jun-2014 to Mar-2019

Project Summary: GE Healthcare (NYSE: GE) provides transformational medical technologies and services to meet the demand for increased access, enhanced quality and more affordable healthcare around the world. From medical imaging, software & IT, patient monitoring and diagnostics to drug discovery, biopharmaceutical manufacturing technologies and performance improvement solutions, GE Healthcare helps medical professionals deliver great healthcare to their patients.

Responsibilities:

As a team member, was responsible for

Reviewing and analyzing the MD60’s in the project.

Developing Interfaces based on the Customer Requirements.

Developed Internal Sales Order (ISO) Interface

Developed Inbound Receipts Interface

Preparing the MD70 documents.

Provided the Support during the testing phase

Delegation of work to the team.

Helping the team for any technical issues.

Coordinating with team and project manager.

Responsible for end to end flow of various Testing Phases including and not limited to Unit Testing, Functional Testing, System Integration Testing of various business processes in Oracle Financials

Prepared the training material for UAT and conducted classroom/ web sessions to train the business users.

Environment: Oracle R12 Financials (GL, Payables, Receivables)

Client: GE Aviation

Oracle EBS R12 (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Oct-2012 to May 2014

Project Summary: GE Aviation, a subsidiary of General Electric, is headquartered in Evendale, Ohio, outside Cincinnati. GE Aviation is among the top aircraft engine suppliers and offers engines for the majority of commercial aircraft. GE Aviation is part of the General Electric conglomerate, which is one of the world's largest corporations.

We successfully implemented Oracle R12 ERP Financials for GE Aviation -Turkey and Mexico and Poland business sites from end to end.

Implemented Oracle R12 Financial (GL, AP, AR, CM and PO) for GE Aviation Turkey. They were using local 3rd party applications for reporting before R12 implementation

Implemented Oracle R12 Financial (GL and AR) for GE Aviation Mexico. They were on Oracle 11i and as a global rollout it needs to be updated to R12.

Responsibilities:

Requirement gathering, analyzing, documenting and designing the solution.

R12 Development – Create Technical designs documents and develop the application as per Functional design.

Responsible for identifying, analyzing, and resolving technical problems with Oracle Applications.

Design and develop Inbound and Outbound Interfaces to integrate with 3rd party applications and Custom reports in XML Publisher and Conversion programs for Oracle Reports.

Developed PO and PO Receipts Inbound Interface for Turkey Site

Developed around 25 Reports using XML Publisher, also Includes Enhancements Change Requests.

Support and fix bugs raised by customers during SIT, UAT and post go live support.

Providing customized solutions as per customer CR’s and ER’s. Creating Reports, Interfaces, Configuration, and Enhancements (RICE) methodologies for requested Customers using Oracle standards.

Specifically develop resolutions to technical issues with Oracle software by setting up oracle test cases in replicated environments, analyzing data setups, applying patches and creating workaround solutions according to Oracle methodologies.

Suggest a variety of Oracle based technical resolutions, and assist customers, developers and analysts in solving technical problems.

Documenting, developing and testing Unit Test Plans.

Environment: Oracle Applications 12.2 (GL, AP, AR, CM), SQL, PL/SQL, HP Quality Center.

Client: GE - OTL (Oracle Time and Labor)

Oracle EBS R12 (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Feb-2012 to Aug-2012

Project Summary: GE Business is using the Oracle Time and Labor Module for their employees and the scope of the project is to develop the base location fields and capture the base location details of the employees

Responsibilities:

Developed the Three fields (Country, State and City) in the OTL Page.

Using LDT Files, Created the dependent value sets for each field and also created the country, state and city fields using FNDLOAD Utility.

Developed the reports for Each employee to pull the base location and working hours of the employee.

Environment: Oracle Applications R12 SQL, PL/SQL, Oracle Database 10g, Reports 10g, TOAD, SQL*Loader, Putty, WinSCP

Client: GE Energy

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Mar-2011 to Jan-2012

Project Summary: GE Energy is a manufacturer of Digital Meters and vast variety other products and has foot print in all parts of world has embarked on upgrading the database of BRAVO Instance from 10g to 11g Bravo ERP Techstack Upgrade Project [Bravo OLTP Database Upgrade from 10gR2(10.2.04) 64-Bitto 11gR2(11.2.0.2) 64-bitunder]. The Scope of the project is to execute the test scripts in Manufacturing (BOM, WIP, and ASCP & Quality), SCM (Inventory, Purchasing and Order Management) and AP Modules. This project also involves Shared Services viz... APEX, Regression Testing Team (execution of automated test scripts using HP Quality Centre). GE Energy wants to test the business scenarios in above modules to ensure the total functionality is working on par with 10g database after upgrading the database to 11g version

Responsibilities:

Executing Functional & Technical Test Scripts in Manufacturing (BOM, WIP) and SCM modules (INV, PO and OM) also custom test scripts as required. Was coordinating activities with Functional and Technical Consultants. Initiated Oracle Service Requests for the issues arising during execution of the test scripts. Initiated DBA (ERP EDD team-GE Support Central) tickets for applying upgrade patches for different releases, creating DB links request for source and ASCP instance. Initiated tickets internally with Help Point (GE Support Central – Expert team) for resolving the issues in custom business scenarios and helped support Shared services APEX Team & Regression Testing in resolving the issues pertaining to their area.

Environment: Oracle Applications 11i (BOM, WIP, INV), Oracle Database 10g/11g, SQL, PL/SQL

Client: WHO-Global Management System

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Mar-2011 to Jan-2012

Project Summary: WHO needs a System to manage and monitor the Travel needs for its Staff member as well as for Non-staff. Travel Solution is a Custom Bolt-on to meet the Travel Solution requirements. That supports the functionalities like, Event Management, Participant Management, Travel request & Claims Management etc.

Responsibilities:

Includes Enhancements in PO Interface

Expenditure Item date for all PO distributions should be TR - first departure Date.

GL date for all PO distributions should be, highest of PO Creation Date (SYSDATE) or Biennium start date (this is derived based on Project Start Date).

If multiple Projects are involved, GL date on distribution line should be derived from respective Project Start Date

TR revisions: This enhancement includes the logic to identify the invoice created for Traveller PO, if invoice created then the program should not error out and should further process the Program as exists

Includes Enhancements in Invoice Interface

To show the TR numbers in the Attribute 5, Attribute 6 and Attribute 7 of the Credit Memo for the Travel Claim NO SHOW cases

Includes Enhancement in Travel Authorization Report

Dynamic Text to be displayed when the payment method is 'Traveler Check'

'' Note: The amount paid to the traveller will be rounded to the nearest 50.''

Environment: ERP Applications Oracle EBS 11i (PO, GL, TR)

Client: Agilent Technologies

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Dec-2008 to Aug-2009

Project Summary: Agilent Technologies, a spin-off of Hewlett-Packard Company. Agilent has a long history of innovation and leadership in the communications, electronics, semiconductor, test and measurement, life sciences and chemical analysis industries. From home entertainment to homeland security, from food safety to network reliability, and from communicating wirelessly to discovering the genetic basis of disease, Agilent provides the measurement capabilities that make our world more productive and a safer, healthier, more enjoyable place to live.

This project is FY09 represents Financial Year 09, which is a combination of different requirements

Responsibilities:

Responsible for preparing the technical specification from the functional requirements Document, designing the program, programming and production migration.

Responsible for preparing procedures, functions, packages as per requirement.

Involved in unit testing, solving issues during integration testing and acceptance testing.

Involved in migrating components to instances.

Preparing Code reviews and test scripts.

Using Form personalization and provided an alert mechanism that will inform the CSR when copying quote in case an item within the quote is discontinued or going to get discontinued before the quote expiration date or there was any BOM change between the time the item was created and the system date at the time of the copy.

When creating a quote or booking an order the CSR may need to get easy access to the Product Line information of the products they’re entering. This solution is implemented by using an unused free format field in both OC and OM that could be used to populate with the Product Line information.

Environment: Oracle Applications 11i (OM), SQL Loader, UTL File Utility, Workflow Builder, Toad, Forms 6i & Reports 6i

Client: Agilent Technologies

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Apr-2008 to Nov-2008

This project is FY09 represents Financial Year 09

Responsibilities:

Purchase Agreement validation on Order Capture:

Validation is implemented using Oracle Forms personalization; Validation is triggered when the quote status changes from “Draft” to “Bid” and custom message is populated

Brazil Flex field validation:

Validation is implemented using Oracle Forms personalization, validated the site globalized flexfields that are linked to the Bill To site on the order record and if any of the globalized flexfields are NULL, then a Popup window should be populated with message “Bill to Address: Customer ID is not complete. Contact CMD to have it populated.”

Environment: ERP Applications Oracle EBS 11i (PO, AR)

Client: Agilent Technologies

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Dec-2007 to Mar-2008

Project Summary: Indirect PO Accrual Notifications Development,

This is to capture the notification process to requestors of Indirect Material Purchase Orders to acknowledge confirmation of receipt of good/services

Oracle Everest: Workflow message generated and distributed to PO owners on monthly basis for all PO’s meeting appropriate criteria

Responsibilities:

Developed a New Workflow Process, This Workflow will route e-mail notifications based on certain criteria

A concurrent Program “Agilent PO Accrual Notifications” is developed which would be responsible for sending out notification for each eligible validated record in the Custom notification table

Developed the Body content of the for each different Notification

Client: Agilent Technologies

Oracle EBS 11i (Implementation/Enhancement Project)

Role: Oracle Apps Technical Consultant

Duration: Mar-2007 to Dec-2007

Project Summary: RBE is a maintenance project being executed for Agilent Technologies-Singapore, aims at modifying or developing the change requests for Oracle Applications 11i (11.5.10.2) in Financial, Manufacturing and Logistics modules

As a team member, was responsible for the following

Automation of PO Auto Closure: - Enhanced the code logic for all PO that has past 90 days or more from the promised/needed by date, Notification would be sent that the PO will be finally closed in the next 90 days, Another Notification will be sent on the 150 days or more from the promised/needed by date that the PO would be finally closed in the next 30 days.

Customization of Workflow on AP Holds(XXATAPHOLDS.wft), which consists “AP Price Hold Process”, AP Quantity Ordered Hold”, to send the notifications, first notification to the PO requestor and if not responded in 3 days, a notification is escalated to his manager for responding, also modified the Notification Content.

EMG market Segmentation: Customer Industry, Lifecycle and Distribution data needed to be pre-populated in Oracle as one of a fixed list of choices. The data is provided for population in the form of an excel file list of Customer-Ship-To-Site-Code with three assigned data fields, developed the coding to populate the data in oracle and Enabled the DFF segments for Customers using atrtributes9,10qnd 11

Deliver design documents, (MD070’s), Unit Test Results (TE30), Release Notes

KiranKumar Settypally

Oracle Applications Technical Consultant

Email: adke4t@r.postjobfree.com Contact No: 502-***-****

Contact this candidate