Sunny Kalra

**** **** *****, *** **, Portage,****2

Email- adjwzc@r.postjobfree.com

Contact #: +1-269-***-****

Experience Summary:

Oracle Application Techno Functional Consultant with over 10 years of Industry experience in Oracle E-Business Suite Applications with deep involvement in the Implementation, Upgrade, Customization & Production Support. This covers FIT-GAP Analysis, Designing, Implementation, Development, Testing, Migration, Post Production Support of Oracle Application EBS 11i/R12 environment.

Profile Summary:

●Extensive experience in Implementation, Customization, Migration, Production Support for various modules of Oracle EBS having prime focus on Order Management (OM), Inventory (INV), Purchasing (PO), Shipping (WSH), Bill of Materials (BOM), Work in Process (WIP), Oracle Field Services.

●End to end experience in CRP and UAT cycles to complete User Acceptance Testing with extensive involvement in R12 support and project upgrades, with strong abilities to troubleshoot and think critically.

●Experience in creating Functional Design Document, Technical design Document, Test Plan for Custom Application designed and developed in integration with R12/11i.

●Rich Experience in Oracle EBS Implementation and responsible to develop and deliver RICE (Reports, Interfaces, Conversions, Enhancements) component in the domain of Oracle Application E-Business Suites.

●Experience in designing, developing, testing, performance tuning and troubleshooting PLSQL Procedures, Packages, Functions etc.

●Good Working knowledge of Procure to Pay(P2P) and Order to Cash(O2C) Cycle.

●Onsite Direct Client Interaction experience of more than 1 year in US.

●Strong knowledge of SQL, PL / SQL, Oracle Standard API, Interfaces & Conversions.

●Experience in providing Level 2/3 support to resolve high priority production support issues.

●Worked on AOL and system Administrator Tasks like creating Users, Responsibilities, Menus, Request set/Groups, Value sets, KFFs, DFFs, profile options & Concurrent programs.

●Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.

●Good Knowledge of Incident Management, Change Management and Problem Management Lifecycle and Processes.

●Ability to work effectively with Oracle Support on Sev 1 critical issues.

●Knowledge of Oracle Metalink functionality/Technical support area to aid in resolving application problems and finding solutions.

●Experience in Inbound and Outbound data migration through different middleware such as SOA.

●Extensive experience with developing interface with SOA and having working knowledge of Oracle SOA Integration (Responsible for Oracle Components)

●Self-motivated and being able to learn independently with excellent communication skills.

●Good Working Knowledge of different entities such as User Hooks and Business Events.

●Design Custom Business Events in order to implement and achieve different custom functionalities in order to meet specific business requirements.

Proficiencies:

Packages: Oracle Applications 11.5x/R12

Programming Languages: SQL, PLSQL.

Oracle Modules: Order Management (OM), Inventory (INV), Purchasing (PO), Shipping (WSH), Bill of Materials (BOM), Work in Progress (WIP), Oracle Field Services.

Oracle Tools: PLSQL Developer, Oracle Reports builder 10g/9i/6i, Oracle Forms builder 10g/9i/6i, Oracle Workflow Builder 2.6.3.5, Oracle BI Publisher, XML publisher, SOA services.

Database Tools: SQL *Plus, SQL * Loader, Toad, SQL Loader, WinSCP, Putty.

Operating Systems and Utility: Windows 7/8/10s

Project Management and Design Tools: Microsoft Visio, Bugzilla, HP ALM, Jira

Other Tools: BMC Control-M, Remedy Project and portfolio management, IBM Rational Clearcase, Tortoise SVN

Career Profile:

Date of Joining- Date of leaving

Organization

Role

Aug 2015 to till Date

Tata Consultancy services

Oracle EBS Techno Functional Consultant

May 2013 to Aug 2015

NCR Corporation Pvt Ltd

Oracle EBS Technical Consultant

Jul 2010 to May 2013

IBM India Pvt Ltd

Oracle EBS Techno Functional Consultant

Professional Experience a

Company TATA CONSULTANCY SERVICES

Total Duration August 2015 to till Date

Customer: Eaton Corporation

Project – Oracle Apps Managed Support for 11i & R12 Applications

Duration: Jan 2019 - Till date

Description: TCS has been platinum support partner with Eaton from last 15 years. This project covers the ongoing daily supports for all oracle queries, bug fixes and enhancements.

Roles: Oracle Application Techno-Functional Consultant

Responsibilities:

• Resolved diverse functional/technical issues related to INV, OM, Shipping, Purchasing, BOM, WIP, Receivables.

• Provide on-call and day-to-day Functional/Technical support and worked as a part of team in 24x7 production environment.

• Helped users in various shipping related issues and make sure that Delivery lines should get interfaced successfully.

• Acted as US and Canada site Oracle Support Lead and ticket owners.

• Conducted weekly status report meeting presentations.

• Handling problem tickets for recurring complex issues and doing problem management.

• Worked on enhancement requests for modifying/extending existing functionality of components as per business need.

• Development of Oracle reports/ad hoc SQL extracts from system to support business requirements.

• Worked on fixing issues with customizations, reports, interfaces, custom programs and PLSql Codes.

• Developed test cases and UAT test plans for ensuring correct functionality.

• Root Cause Analysis for the incidents/issues faced by users.

• Tracked and logged solutions in incident report tool Remedy.

• Worked with Change Management teams and support production movement of components.

• Attended weekly change review meetings and presented the change for approval.

• Followed Change management process to ensure smooth migration of changes to live instance.

• Assisted customers with post production validation and testing of components.

• Provided support and resolved incident related to 2rd party integration using SOA and Tibco.

• Worked on ControlM scheduling.

Customer: Eaton Electrical Sector

Project: Oracle Unicorn Implementation

Duration: Aug 2018 to Dec 2018

Description: Eaton Corporation has recently started joint venture and setup a new warehouse in Germany. As a part of this joint venture, Eaton has planned to perform actual shipping through this warehouse as per agreement leading to the need to implementing procurement, inventory and Order management module.

Roles: Oracle Application Technical Consultant

Responsibilities:

Involved in requirement gathering, FIT-GAP analysis & process study.

Collected project business requirement through meeting with business and understanding the expectation.

Worked on Supply chain orchestration, back to back supply order & Drop ship cycles.

Facilitated smooth testing during CRP & UAT phase and played a vital role in tracking/resolving all bugs which have been raised during these test cycles.

Interact with the business users through regular meetings and provided updates on all open issues.

Execute Super user training and preparation of training material.

Perform Enhancement in different Interfaces in order to generate data as per region specifications.

Worked on P1 (Critical) and P2 (High Priority) Bugs found during SAT and UAT and resolve them within SLA.

Perform cut-over and go live activities. Provided 3-month warranty support and assisted user in resolving issue and understanding new system developed.

Customer: Eaton Industrial Sector

Project: Oracle ERP Implementation and Enhancement

Duration: Jan 2018 to Jul 2018

Description: This project covers development/modification to different components which belongs to Oracle Industrial sector.

Roles: Oracle Application Technical Consultant.

Responsibilities:

• Involved with business from very start to understand the GAP from Oracle ERP perspective and help them with FIT-GAP analysis.

• Responsible to design new label templates and files in the software system Loftware.

• Heavily involved in Data migration activities like data mapping from legacy and further final data migration to single global instance.

• Performed enhancement in existing interfaces and implemented new functionalities as per business requirements.

• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

• Worked on reusing /developing/configuring interface to provide data transfer between Oracle and SAP using synchronous SOA services & oracle web services

• Facilitated smooth testing during CRP & UAT phase and played a vital role in tracking/resolving all issues.

• Interact with the business users through regular meetings and provided updates on all open issues.

• Perform cut-over and go live activities. Provided 3 months warranty support and assisted user in resolving issue and understanding new system developed.

Customer: Eaton Industrial Sector

Project – Eaton Unify Implementation

Duration: Aug 2015 – Dec 2017

Description: This project covers methodology for integration of R12 unify oracle instance (Financial center) with 11i plant via SOA as middleware technology involving multiple plant systems. Initially, TIBCO was used to provide the integration. It covers developing and testing financial interfaces and integrating them with SOA.

Responsibilities:

• Designed and Developed New Outbound Interfaces such as Purchase Order Interface, Receipt Interface etc. which are used to triggers data through SOA middleware.

• Successfully designed Custom Business Events which are used to invoke SOA web services which in turn generate Payload and transfer Payload to other Systems.

• Designed and Developed New Inbound Interfaces such as Customer Maintenance Interface which are used to receive customer related data from through SOA Middleware and create and update new/existing customers at ERP end.

• Payload procedure has been written from scratch for integration with SOA using advanced PLSQL object type.

• Implemented Debatching logic in order to keep minimum load on SOA and avoid performance related issues at SOA end.

• Developing testing scripts and supporting QA and User Acceptance testing

• Completed the go-live including movement of code to production and provided warranty support for six months.

Troubleshoot and debug different issues related to Payload Generation Failure at SOA end.

Participated and Contributed in Technical calls and discussions with other vendors such as Delloite and resolve certain critical issues.

Perform Enhancement in different Interfaces in order to generate data as per Brazil specifications

Company NCR CORPORATION PVT. LTD

Total Duration MAY 2013 TO AUGUST 2015

Organization:

NCR Corporation India Pvt. Ltd.

Project Name:

Oracle Enterprise Services CHINA Implementation

Start and End Date:

May 2013 to December 2014

Team Size:

4 Members

Organization:

NCR Corporation India Pvt. Ltd.

Project Name:

Oracle Enterprise Services EMEA Implementation

Start and End Date:

January 2014 to September 2014

Team Size:

4 Members

Organization:

NCR Corporation India Pvt. Ltd.

Project Name:

Oracle Enterprise Services US Implementation

Start and End Date:

October 2014 to July 2015

Team Size:

6 Members

Description:

Oracle Enterprise Services (Oracle ES) is a multi-year, transformational project that will replace many of NCR’s IT applications that currently enable NCR service delivery (e.g., D1, SMC, GCEW ) with a common suite of applications, which will help standardize and streamline actions and processes throughout NCR Services. NCR currently uses a large number of different systems linked to each other. The Oracle system replaces more than 70 applications, integrating functions such as call handling, logistics and purchasing into one system.

Role:

Worked as an Oracle Application Consultant as a part of Development Team involved in developing functionalities in Oracle Applications (Inventory/CRM Teleservice/Field Service).

Key Responsibilities & Achievements

Designed and Developed New Enhancements and RFC (Request for Change) which had been assigned and deliver them within specified SLA.

Designed and created custom form using Form Builder 10g. Registered the form and migrated.fmx executable file to $AU_TOP on forms server of client.

Worked on standard Business events and successfully added subscription to business events just to meet different custom business requirements.

Successfully designed Custom Business Events and perform certain required tasks just to meet adhoc requirement.

Extensively used CRM API's for upload the service request information from D1 (Legacy System) to Oracle Apps ERP.

Extensively used standard API USER HOOKS just to achieve different business requirements.

Design a Template Upload Interface which basically uploads Template Master and Template mapping data from Legacy (D1) application to Oracle Applications.

Design a Skill Upload Interface which basically validates and upload/assign skills to respective resources from Legacy (CSA) to Oracle Applications.

Design Customer Conversion just to upload Customer Related Data (BILL_TO & SHIP_TO) in Oracle Applications.

Developed SQL*Loader control programs and PL/SQL validation procedures to migrate data from one to another instances using DBLINK.

Efficiently Design Different kinds of Database Objects like Table, Views, Indexes, Sequences and Constraints etc.

Expertise in AOL and System Administrator Activities such as Creating Profile Options, Value Sets, Concurrent Programs, Menus,Functions,Request Groups and Responsibilities.

Interacted with business users to resolve any issues during the development, Mock testings,

Pre-Production testing and production phase.

Checking code in SVN and get it migrated to target instances by coordinating with Release Management Team.

Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Efficiently Design Technical documents like F-Spec (Functional Specification) and D-Spec (Designed Specification) for every RFC (Request for Change) delivered by me.

Actively interacted with users in gathering requirements for development.

Worked on P1 (Critical) and P2 (High Priority) Bugs/JIRAs found during SAT and UAT and resolve them within SLA.

Played a major role and provide extensive support at the time of User Acceptance Testing (UAT), System Acceptance Testing (SAT) and Go Live.

Company IBM INDIA PVT.LTD

Total Duration JULY 2010 TO MAY 2013

Organization:

IBM India Pvt. Ltd.

Project Name:

Bharti Airtel Oracle Application Support and Operations

Start and End Date:

March 2011 to May 2013

Role

Permanent

Organization:

IBM India Pvt. Ltd.

Project Name:

Bharti Airtel Oracle Application Support and Operations

Start and End Date:

July 2010 to March 2011

Role

Contractual (Was on the Payroll of Synova Innovative Technologies Pvt Ltd)

Role: -

Worked as an Individual Contributor in Oracle Application Support Team. Worked on Incidents logged by users for different issues and data upload requests.

Key Responsibilities & Achievements

Created Concurrent Programs and Executables, add concurrent program definitions to particular Request Groups.

Developed stored procedures to accomplish different custom requirements.

Troubleshoot on different issues reported by Business team and resolve them within SLA.

Configuring Descriptive Flexfield and Value Sets just to meet different business requirements.

Upload Business data in staging tables using SQL Loader and then upload them in Base tables using Oracle Standard API.

Designed Custom Packages just to meet custom business requirement using Oracle Application Standard APIs.

Creation & Follow up of Oracle SR (Service Request)/ER (Enhance Request) for respective issues.

Developed Custom forms and registered them in Oracle Applications.

Worked and Coordinated with DBA on 1Critical Performance issues which had occur to users while accessing Oracle Applications.

Provided Level 2 support to the business users to identify the problem and give a quick solution.

Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Perform end to end testing and get RFC(Request for change) delivered Sign Off from Business as any RFC (Request for Change) gets deployed in Production.

Experience includes application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.

Perform UAT and Coordinated with Business and Functional heads just to ensure successful Implementation of any Change.

Participated in different technical calls and resolve issues related to different oracle and custom applications.

Qualification:

B.E. (Electronics &

Communication)

Manav Rachna College of Engineering, Faridabad

(Maharshi Dayanand University, Rohtak)

2004-2008

69 %

A.I.S.S.C.E. (XII)

Vidya Devi Jindal School, Kosi-Kalan (C.B.S.E.)

2002-2003

70.8%

A.I.S.S.E. (X)

Vidya Devi Jindal School, Kosi-Kalan(C.B.S.E.)

2000-2001

76.6%

Certifications:

Oracle Inventory Cloud 2019 Certified Implementation Specialist

Oracle Database: SQL Fundamentals I

Extra Curricular Activities:

Received Bravo award for exceptional Performance while working with IBM India Pvt. Ltd.

Received Technical Expert Award while working with NCR Corporation Pvt.Ltd.

Got an “Outstanding” Recognition for resolving bugs and provide extensive support to Business during GO Live Activity.

Contact this candidate