Oracle Project

Name : Phanindhar Reddy Jagganna

Contact Mobile Number: +1-601-***-****

Email Address : ********@*****.***

Summary of Experience and Qualifications:

13+ years’ experience with Oracle E-Business Suite / Applications - Performing Technical work mainly within the Self-Service modules of Oracle E-Business Suite (EBS) (Oracle Applications / Oracle Financials for Enterprise Resource Planning (ERP)), Oracle technologies projects at Synthesis-Systems, DELL International, United Health Group, OSI Consulting, IBM and Hexaware. The Wide technical and the strategic background, experienced at functioning with business leaders to transform business needs into technology results.

Expert in Oracle Application Framework (OAF) with alternative solutions to the Business team, Oracle Interfaces or conversions, analyzing integration issues and providing solutions to leverage Oracle applications functionality.

Functional responsibilities: Understand and modify Oracle application configuration like DFF, System Setups, and Profile Options etc. as required. Performing test plans, test cases, test scripts creations and performs functional testing. And getting sign-off from the stakeholders or Business Team.

Technical (technical lead, developer, etc.) activities: interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, Producing documentation, and providing production support.

Coordinating with Business analysts on technical designs and solutions for the requirements.

Expert in Oracle Applications R12 Upgrade, Implementation, Support Projects and Oracle Fusion Middle-ware Implementation Projects using the Oracle SOA suite 11g, WEBADI. And worked on Project Development projects based on Oracle ERP Modules and experience and expert in Finance, Order to Cash, Supply Chain and Procure to pay in Oracle EBS modules.

Experience and expert in the PMP, ITIL and Agile Process Framework.

Experience in UNIX, OAF, JAVA, JSP, SQL, PL/SQL, EDI, Oracle Forms, Oracle Reports, XML Publishers, Performance tuning and Optimization, Oracle Workflow Builder, EDI, SQL*LOADER and BPEL, Oracle SOA suite in 11g, WEBADI.

Trained and Good Knowledge in ADF, Sales-Force Administrator, Kofax Capture/ Markview, OBIEE.

JOB INTERESTS

Oracle E-Business Suite Implementations and Upgrades / Technical Lead/ Techno-Functional Consultant / Business Analyst / Architect / Technical Lead (Oracle / Oracle E-Business Suite: CRM, ERP, including Oracle R12 and 11i / Implementations, Upgrades, Customizations, Extensions, Interfaces, Support).

Functional and Technical Skills:

Operating System

Any Windows version and Linux and Unix

Languages

SQL, PL/SQL, JAVA, JSP, UNIX

Database

Oracle 8i/9i/10g/11g/12c

ERP Version

11i and 12R

Middle-Ware

Oracle SOA suite

ERP Modules

Experience in Various Modules like General Ledger (GL), ASCP (Advance Supply Chain Management), PO (Purchasing Order), AP (Account Payable), AR (Account Receivable), INV (Inventory), I-Store, Mobile Applications (MSCA) and OM (Order Management), Fixed Assets (FA), Sub-Ledger Accounting (SLA), (Project Accounting), E-Tax And Expertise knowledge in the Retail Industry and Health Industry.

Tools

J-Developer, Workflow, Page Personalization, Logical Apps Rules, Forms Personalization, XML Publisher, Oracle Reports, Oracle Forms, TOAD, SQL * Loader, SQL Developer, Putty, Win SCP, ITG and version Control Share-point, OAF (Oracle Application Framework),UTL_FILE, Shell Script, UNIX

Professional & Project Management Certification

Year

Company

Certification Name

2014

United Health Group

ITIL Intermediate Service Operation

2013

United Health Group

ITIL Foundation

2011

OSI Consulting

IZ0-451 – SOA Foundation

2009

IBM

IZ0-200 Oracle 11i E-Business Essentials.

Education:

1999-2003

Jawaharlal Nehru Technological University

B. Tech - Engineering

WORK EXPERIENCE:

DELL Print JUNE-2015 – Till date

Title: Oracle EBS Technical Lead

Company: DELL Texas

Project Type: Development (R12 Environment) (Working ~ 20% Functional and 80% Technical within Oracle E-Business Suite.). Implementation for the US and Canada.

Environment: Oracle E-Business Suite [R12 (12.1); Order Management (OM/ONT), Receivables

(AR), Trading Community Architecture (TCA/HZ)], Oracle credit management, Fixed Assets (FA), Cash Management (CM), Project Accounting (PA), Inventory (INV), USDOMS Application, ERAM Application, DSA Application, Oracle Service Bus (OSB), Sales-Force, Oracle (12c): PL/SQL, SQL. SQL Developer, J-Developer, Kofax, Markview.

Designing integrations between O2C (Order-to-Cash) systems - including Oracle Applications (E-Business Suite) R12, ERAM Systems and other internal systems. Gathering requirements, designing solutions, configuration changes, setting up Proof of Concept (POC) demos, designing customizations/extensions, testing solutions, generating/ performing test scripts, writing documentation, etc. Primary Oracle modules: Order Management (OM), Accounts Receivable (AR), and TCA Customer Master (HZ), General ledger (GL), SLA (Sub-Ledger Accounting), Fixed Assets (FA), Cash Management (CM), PA (Project Accounting), Inventory (INV).

Development of Oracle Application Framework (OAF), Oracle Workflow Objects from simple and complex solution. Modifying the Interfaces to process new requirement changes Advance Queues (AQ), PL/SQL scripts.

Configured Oracle DFF (Descriptive Field-Fields) and Integrated in OAF pages for the Business needs and setups done for multiple modules as required for the Business.

Converting Oracle Forms (FMB) to OAF with new features and provide the sessions or demo to the business team and PO (Product Owner) on how to use the new OAF forms developed. And Fixing the existing Custom or Seeded Oracle Form and Oracle Reports issues.

Prepared the standard documents, BR100 setups document, MD50 Functional documents, MD70 Technical documents for the Objects developed.

Developed new Interfaces in OM, AR, AP, and GL for the new source systems in the Oracle Application systems.

Translate Business and integration requirements into configurable component designs and IT solutions.

Developed Multiple Custom XML Publisher, Oracle Reports as per Business Requirements.

Propose solutions to Business, Technical and Functional Teams. Design and Document solution for presenting to stakeholder for sign-off or agreement.

Provide alternate solution to Business team if there any Oracle Product limitations.

Creating User Stories which are required for each phase of the Project for tracking purpose. (AGILE Process)

Interview and shortlist of resource for the Project.

Project Characteristics:

Interfacing Orders and Customer information from DSA, DOMS, and GCM and other Internal Applications and external third party systems to Oracle EBS (OM/AR).

Integration Financial Systems - United Health Group April-2013 – May-2015

Company: United Health Group

Title: Oracle EBS Technical Project Lead

Project Type: Upgrade from 11i to R12 and R12 Enhancement and Production support (Working ~ 20% Functional and 80% Technical within Oracle E-Business Suite.).

Environment: Oracle E-Business Suite [R12 (12.1); General Ledger (GL), Receivables

(AR), Trading Community Architecture (TCA/HZ)], Oracle Payables (AP), Fixed Assets (FA), Cash Management (CM), Advanced Supply Chain Planning (ASCP), Sub-Ledger Accounting (SLA), Cash Management (CM), Project Accounting (PA), Inventory (INV), Loader Balancer, NOETIX, Settlement Plus (.Net) Application, EDI, Oracle (12c): Data-stage, PL/SQL, SQL. SQL Developer, J-Developer, XML, Oracle Reports, Oracle Forms.

Responsible for process rebuilding and gap analysis for incident, problem, change, availability management as per ITIL framework as a part of organizational initiative. And Working with Activision Business users and core functional team to identify Technical requirements.

Acting as a communication focal point between the Client and Service Delivery. And helped the team members to resolve the issues.

Developed XML Publisher reports as per Business Requirements.

Worked on Various custom developments for every quarter releases and Developed Simple to Complex OAF Objects and Interfaces which are required for the Business team.

Developed Web-ADI Interface to users to upload the Forecasting data in the Custom table directly.

Enhanced and fixed issues encountered in the Custom Oracle Forms and Reports.

Developed Multiple Custom Interfaces in OM, AR, AP, FA, CM, GL for the requirements and Prepared MD70 Technical documents for the Objects developed.

Proving the workarounds to the business team for incidents encountered and later provide the permanent solution. Managed support tickets through HPSM tools.

Conducting sessions with Business team to explain the changes (Demo), results and impact for the sign-off.

Analysis of project risk and preparing action plan to mitigate the risk. And Recommends technical and process improvements.

Participate in upgrades by researching changes to functionality, developing test scripts, testing changed functionality and determining impact on customizations.

Primary point of contact closing all the month and year end periods with Business team in Production. And fixing all the issues with SLA (Sub-Ledger Accounting) transfer to GL on high priority.

Provide functional and technical advice to the Supported Applications/operations on the issues those are raised by business during their day to day operations

Troubleshooting defects raised by users and correcting the configurations (or) raising SRs with Oracle Support wherever required.

Project Characteristics:

Interfacing the Invoice, Payment, Accounting, and Customer information from People-soft, Settlement-Plus etc. multiple Internal Applications and external third party systems to Oracle EBS (GL/AR/AR/FA/PA/E-Tax/SLA).

Taylor-Made Golf - Adidas August-2012 – April-2013

Title: Oracle EBS Technical and Functional Project Lead

Company: OSI consulting

Project Type: R12 Implementation (Working ~ 30% Functional and 70% Technical within Oracle E-Business Suite.).

Environment: Oracle E-Business Suite [R12 (12.1); General Ledger (GL), Receivables

(AR), Trading Community Architecture (TCA/HZ)], Oracle Payables (AP), Order Management (OM), Project Accounting (PA), Sub-Ledger Accounting (SLA), Purchasing (PO), EDI, Oracle (12c): Data-stage, PL/SQL, SQL. SQL Developer, J-Developer, Kofax, Mark-view.

Technical lead analyst on the project to implement Legacy System Maintenance Renewal process into the Oracle 12R application prepared the standard documents, and MD70 Technical documents for the Objects developed.

Interview and shortlist of Technical resource for the Project.

Developed Oracle Reports, XML Reports as per Business Requirements.

Developed the Oracle new Interfaces (Inbound/ Outbound), Conversions, Conducted performance testing and Personalized Oracle Application Framework (OAF) to meet the additional requirement for the Business need.

Developed Custom Interfaces in various modules like OM (Order Management), INV(inventory), FA (Fixed Asserts), GL(General Ledger), AR(Account Receivables), AP(Account Payables), WIP, BOM (Bill of Material), Service Contracts, Install Base, SLA (Sub-Ledger Accounting), PA (Project Accounting) etc. as per the Requirements like AP Invoice, Banks, BOM Conversion, PO Conversion and Buyer Conversion, Customer Conversion, Employee Conversion, Item, Item Catalog, Item Categories, Item Categories Assignments, Items On-hand Quantity, Price List Conversion, Sales Order Conversion, Projects Conversion.

Requirement analysis and providing different options to customers.

Review the objects development by team.

Coordinating with all stakeholders to ensure smooth deliverable and customer satisfaction.

Blue Nile April-2012 – August-2012

Title: Oracle EBS Technical Project Lead

Company: OSI consulting

Project Type: Upgrade Project (11i to R12)

Environment: Oracle E-Business Suite [11i [11.5.10], R12 (12.1); General Ledger (GL), Receivables

(AR), Trading Community Architecture (TCA/HZ)], Oracle Payables (AP), Order Management (OM), EDI, Oracle (12c): Data-stage, PL/SQL, SQL. SQL Developer, J-Developer.

Preparing Custom objects existing list for 11i to R12 Upgrade project.

Providing estimates for project task. And prepared the design documents.

Analysis of 11i to R12 changes and impact on the custom objects.

Developed new Interfaces in SCM (Supply Chain Modules) like OM, INV and Financial modules (AP, AR, GL, CM, FA) which are need for the Business and provided alternate for the better and improved solutions for the Business team.

Developed EDI Interface for Invoices.

Reviewed the objects development or modified for the Upgrade by team.

Coordinating with stakeholders regularly to ensure smooth deliverable and customer satisfaction.

Configured DFF, System Setups, and Profile Options etc. as need for the requirements.

Managing offshore team to deliver Quality Product with in baseline and ensuring Quality Assurance as per Statement of work (SOW) agreement.

Harbor Freight Tools May-2011 – April-2012

Title: Oracle EBS Technical Project Lead

Company: OSI consulting

Project Type: R12 Implementation and Production support.

Note: Though it is Upgrade project to client. It was an implementation project. 11I system was just a legacy system.

Preparing PMP, CMP Documents and Estimations given for every object in R12 Upgrade Project.

Maintaining Resource Allocation Reports.

Developed new Interfaces in SCM and Financial modules which are need for the Business and provided alternate for the better and improved solutions for the Business team.

Conducting Weekly Team Meetings.

Developing, Reviewing the code and Documents Prepared by the Team.

Developed new Customer and Sales Orders Interface for the New Source System.

Developed in Workflow for the new Order Types for Sales Orders.

Integrated Kofax Capture/Mark-view with Oracle Payables EBS.

Developed Oracle Custom Forms to handle Error record and Reprocess them as required for the Business team.

Customize SOA Interfaces to suite Oracle R12 Instance, deploying and unit testing.

Post-production troubleshooting and analysis of business process issues within: General Ledger Accounting (GL), Sub-Ledger Accounting (SLA), Advanced Supply Chain Planning (ASCP), Sales Order (SO), Inventory Transaction and TCA/Customer Master. Gather requirements, write functional (MD050) and technical (MD070) specifications, provide recommendations for user challenges, and implement process and system modifications. (Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using AIM guidelines.)

Harbor Freight Tools May-2011 – Sept-2011

Title: Oracle EBS Technical Consultant

Company: OSI consulting

Project Type: Integrating Oracle 11i and IBM Inventory software using Oracle SOA suite.

Preparing the Mapping document and development of interfaces for the WMS project. (Other system Inventory Transaction to the Oracle Inventory Tables).

Schedule meeting with users for requirement and sign off the Interface deliverable.

Developing and unit test the Interfaces using the Oracle SOA suit in Development instance

Deploying on web-logic server in production with DBA team.

Supporting any SOA interface issues.

Falkentire and zodiac Jan-2011 – May 2011

Title: Oracle EBS Technical Project Lead

Company: OSI consulting

Project Type: Support R12 version

Preparing PMP, CMP Documents and Estimations given for every object.

Maintaining Resource Allocation Reports.

Reviewing the code and Documents Prepared by the Team.

Developed EDI Interface for Payabables and Receivables.

Attending Status call and ensuring the customer satisfaction

Maintain Quality process through QMS documents, Metrics etc.

Interacting with Team members to ensure the concerns.

Managing the team to deliver Quality Product with in Dead Lines.

HBC Oracle, Canada Oct 2007 – Jan-2011

Title: Oracle EBS Technical Consultant

Company: IBM

Project Type: Support

Preparing Technical Design Documents and Estimations, Coding.

Reviewing the code and Documents Prepared by the Team.

On-call Job. Support to all the financial and all Oracle Implemented modules.

Developed Custom Oracle Reports and Oracle Forms.

Maintain Quality process through Rational Project Manager, Metrics etc.

Resolving Technical and Functional issues in Oracle EBS Supported Modules GL, AP, AR, ASCP, HRMS, FA, INV, PO, OM, Service Contracts etc.

Interacting with Client

Managing the team to deliver Quality Product with in Dead Lines.

HP (Outerbay), USA June-2005 - Oct 2007

Title: Oracle EBS Technical Consultant

Company: Hexaware

Project Type: Product Development

Analysis of business requirement for this project (Custom Purge Program). And Analysis of Oracle Patch to Upgrade.

Developed multiple Interface and triggers across Modules GL, AP, AR, CM, FA, INV, OM to populate the Records in the Staging tables and moving them accordingly to Archive Database.

Installation Outer-Bay product (like repository, LA, Appspack, Archive Access, Move to History etc.) and tested End of End functional testing with deep driver analysis.

Preparation of Migration scripts in the similar lines as regular upgrade script but with limited scope of history upgrade for the Modules GL, AP, AR, CM, FA, INV, OM.

Run Pre-purge Reports and Selection Programs.

Midea Group Share Co., Ltd Aug-2004 – June-2005

Title: Oracle EBS Technical Consultant

Company: Hexaware

Project Type: Implementation and Support

Developing reports, conversion and interface programs that are registered as concurrent programs and which are run from SRS form.

Writing custom packages to develop conversion programs.

Development and Customization of PL/SQL Procedures

Preparation of Technical specifications from the functional specifications received from the functional team.

Deba Denizli Printing and Dyeing Ind. Inc June-2003 – Aug-2004

Title: Oracle EBS Technical Consultant

Company: Hexaware Mumbai

Project Type: Implementation and Support

Preparation of Technical specifications from the functional specifications received from the functional.

Developed the Oracle new Interfaces (Inbound/ Outbound), Conversions cross different modules GL, AP, AR, INV, FA, OM, WIP, BOM etc.

Development and Customization of PL/SQL Procedures

Contact this candidate