Project Oracle

Professional Summary

**+ years of professional experience in Oracle E-Business Suite 11i/R12/Fusion Cloud Applications involving modules such as Order Management, Inventory, Shipping, Purchasing, Work in Progress, Bills of Material, Accounts Receivables, Accounts Payables, General Ledger, Fixed Assets, Sub Ledger Accounting, Iprocurement and AME/BPM.

Technical Lead in SCM track during End-To-End implementations of Oracle E-Business Suite Applications 11i/R12 at Activision Blizzard.

Having Good Experience on OTBI/BI Reports/ESS Job Registration.

Development of step-by-step job aids, delivery of end-user training and mentoring.

Having Good Experience developing interfaces using Oracle FBDI and ADFDI templates, SOAP and Restful Web Services.

Key responsibilities include Solution Design, Technical Design, development, testing and other activities that are part of SDLC life cycle and coordinate with Onsite/Offshore teams to deliver solutions as per customer/business needs.

Part of Oracle E-Business Suite Applications R12.1.3 Upgrade project at Beach Body.

Expert in technical areas/tools such as Oracle PL/SQL, Reports 10g, Workflow Builder, BI/XML Publisher, OAF and JDeveloper.

Expert in OAF customizations and personalization’s.

Exposure to working at area of well diversified & multi-cultural environments – Worked as Project coordinator in India and Onsite.

Expert in handling production issues in real time.

Strong working knowledge of business flows like Order-to-Cash and Procure-to-Pay with the dependencies and relationships between Oracle Applications modules.

• Good understanding of Code movement using FND_LOAD for concurrent Programs, Request sets, AOL objects and BI Publisher templates, Value sets, Forms, Functions, Responsibilities, Menus, XML Data templates etc.

Possess strong problem solving, analytical and critical thinking skills to provide data-driven and result-oriented solutions to complex business problems, resulting in Cost Optimization and Revenue Growth.

Good Knowledge on Oracle Integration Cloud(OIC).

Education

Master of Computer Applications (MCA), Osmania University, India – 2008

Bachelor of Science (Computer Science), Sri Krishnadevaraya University, India – 2005

Experience Summary

Organization Designation From To

Zensar Technologies Computer System Analyst May-2010 till date

Professional Experience

Organization : Zensar Technologies, California, US. Sep 2019 to Till to Date

Client-Project : Gilead Sciences - KITE Pharma - MES Integration with EBS

Role : Computer Systems Analyst

Technologies : Oracle E-Business Suite R12 Applications - OPM, Iproc, Inventory, OAF; PAS-X Integration

Description : Kite Pharma, a subsidiary of Gilead Sciences, develops cancer immunotherapy products with a primary focus on genetically engineered autologous T cell therapy with chimeric antigen receptors.

Key Responsibilities:

Requirement gathering, Solution Design and Development in Inventory and OPM modules

PAS-X Integration design requirements

Rapid Response Planning System Integrations

Iproc Local Hosted Catalogs, Punch outs and PO cXML Integration.

E2E testing custom object for upgrade project (12.2.8).

Customized the Iproc Page using Oracle Application Framework.

Organization : Zensar Technologies, Chicago, US Aug 2018 to Aug 2019

Client-Project : USG Corporation - Segmentation Project with EBS

Role : Oracle Cloud/ERP Developer

Technologies : Oracle E-Business Suite R12 Applications - Finance, Oracle Cloud SaaS, Procurement

Description : USG Corporation, also known as United States Gypsum Corporation, is an American company which manufactures construction materials, most notably drywall and joint compound. The company is the largest distributor of wallboard in the United States and the largest manufacturer of gypsum products in North America.

Key Responsibilities:

Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walk through.

Designing Solution and MD070 as per the Functional Specification document.

Involved in end to end testing.

Developed on OTBI/BI Reports/ESS Job Registration.

Developed of step-by-step job aids, delivery of end-user training and mentoring.

Developed interfaces using Oracle FBDI and ADFDI templates

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Designing Test Cases as per the requirement.

Good in using PL/SQL Collections and Oracle Advanced Queues.

Writing Unit Test cases and testing after completion of the Web services.

Supported all go-live activities and post-production troubleshooting.

Participating in project meetings as necessary

Organization : Zensar Technologies, India, California, US. Nov 2014 to Aug 2018

Client-Project : Activision Blizzard AMS

Role : Technical Specialist

Technologies : Oracle E-Business Suite R12 Applications - Finance, Oracle Cloud SaaS, Project Costing, iExpenses

Description : Activision Blizzard is the world's leading pure-play online and console game publisher. Activision Blizzard was formed by combining Activision, one of the world's leading independent publishers of interactive entertainment, and Vivendi Games, Vivendi's interactive entertainment business, which includes Blizzard Entertainment.

The project involves supporting their internal Oracle ERP global instance for EU, APAC and NA. The client is into the business of publishing games. The hardware is sourced globally and assembled at different locations and delivered onto the Sales territories. Studios are located at different places around the globe which design and test the games. Online web portals allow users to order products which are integrated with Oracle as regards supply chain and financials. One of the key parts of the business is transfer of information to and from 3PL (Third party logistics/Suppliers) through Oracle interfaces

Key Responsibilities:

Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walk through.

Designing Solution and MD070 as per the Functional Specification document.

Created Procedures, Functions and other database objects using SQL and PL/SQL.

Interacting with Business Users for analyzing their issues and to provide them proper and permanent solutions by replicating the issues in development environment.

Closely monitoring critical alerts.

Closely with Sys-admin & DBA teams for regular Functional issues, Patch Applications, Data fix, Code fix, Scheduling of several scheduled requests.

Closely interacting with onsite team in deriving delivery dates of components and driving team in a direction to achieve the same deadlines and Conducting Technical Review & Code Walk through

Coordinating with Teams (TIBCO, DBA) for Integration Testing.

Performing code reviews and ensuring that the objects are delivered with zero defects

Supported all go-live activities and post-production troubleshooting.

Participating in project meetings as necessary.

As part QR team developed multiple inbound and outbound interface objects.

Integration from Workday to EBS and Active Directory.

Organization : Zenar Technologies, India April 2014 to Sep 2014

Client-Project : Beach Body Oracle EBS Upgrade

Role : Senior Software Engineer

Technologies : Oracle E-Business Suite R12 Applications SCM and Finance Modules

Description : Beachbody LLC is an American multinational corporation that uses multi-level marketing to sell fitness, weight loss, and muscle building home-exercise DVDs.

The project is to go for up-gradation of Oracle Ebiz from 11.5.9 to R 12.1.3.

Responsibilities:

Identifying the customizations that need to be upgraded.

Doing the impact analysis of the customizations and finding out if there is any way to minimize the customization in R12.

Designing and Building the customization.

Involved in test cycles and ensuring that the customization is mapped to the existing Business Process.

Maintaining the objects version control using Perforce

Prepared Code Migration and Unit test documents

Involved in end to end testing.

Supported all go-live activities and post-production troubleshooting.

Participating in project meetings as necessary

Organization : Zensar Technologies, Hyderabad, India May 2010 to Mar 2014

Client-Project : Activision Blizzard EBS Support

Role : Associate consultant

Technologies : Oracle E-Business Suite 11.5.10.2 –SCM

Description : Activision Blizzard is the world's leading pure-play online and console game publisher. Activision Blizzard was formed by combining Activision, one of the world's leading independent publishers of interactive entertainment, and Vivendi Games, Vivendi's interactive entertainment business, which includes Blizzard Entertainment.

Responsibilities:

Break/Fix Production issues,

End-user training assistance to explain how the application works from a technical perspective, resolving the tickets, working on the change requests and Impact analysis.

Analysis of problems to determine root causes.

Develop Projects and new programs as per technical specification, Development methodologies and standards.

Modification of existing programs for change requests (Ticket).

Help Desk Ticket Coordination with On Site Team members and User.

Prepare Analysis and Technical Specification Documents and Impact Analysis report in Client’s specific Format for projects and new program’s.

Coordinating with Teams (TIBCO, DBA) for Integration Testing.

Personalizing Seeded Forms by Using Form Personalization.

Monitoring and resolving the interface errors, reaching out to business in case of any involvement from their side.

Analysis, coding and testing for of changed request. Prepare Pre study Document and Technical Specification documents, UTP (Unit test plan) and Impact Analysis reports for new and changed program codes.

Analysis, coding and testing of enhancement or change request.

Developed XML Bursting Program to send the output as an email.

Personalizing Seeded Forms by Using Form Personalization.

Preparation of Document of Understanding and Technical Specifications.

Monitoring System Jobs and involvement in Administration related tasks.

Contact this candidate