Oracle Consultant

Janardhan Gaddam

Sunnyvale, CA

******.***********@*****.***

Ph: 313-***-****

Professional Summary

Oracle Apps Techno Functional Consultant with proven experience in Oracle EBS Application Releases R11.5.10.2, R12.0.6, R12.1.3 and R12.2.4. Significant customer-facing experience in delivering custom enterprise solutions to Motorola Mobility, Qualcomm, Motorola Solutions, Almac etc. Having around 9 years of experience in the IT Industry in implementation, upgrade and customization of Oracle e-Business Suite Applications.

Oracle EBS Techno Functional Consultant

Functional experience in configuration, setup, unit and integration testing of various Oracle Application Modules and customizations for meeting gaps in client requirement and application.

Expertise in RICEW component design, development and having good functional and technical exposure on different modules of Oracle Application like General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets, Project Accounting, Cash Management, Order Management (OM), Purchasing (PO), Inventory (INV), Advance Pricing, BOM, WIP, I-expenses, I-Procurement, I-store, E-Commerce Gateway, Oracle Mobile Applications Framework, Service Contracts, Web ADI and Oracle Alerts.

CRM functionality setups, business process, end to end transaction processes, client requirement FIT GAP analysis with Oracle seeded functionality, identifying the customization areas needed to meet client’s requirements.

Experience in developing ORACLE APEX applications.

Good knowledge on End to End functional setups required for Order to Cash, Procure to Pay and Demand to build business process Setups.

Experience configuring the Sub Ledger Accounting SLA set ups

Period close and Quarter close experience.

Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like BRD100, MD.50, MD.70 and TE.20

Good Expertise in TCA (Trading Community Architecture).

Experience working with large multisite enterprise resource planning (ERP) systems and cross functional teams.

Experience in developing self-service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.

Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions and Integration

Extensive experience in conversion of legacy data into Oracle Applications developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.

Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.

Extensive experience in developing custom forms using forms 6i/10G.

Extensive experience in customizing the forms functionality using Form Personalization, Logical apps rules and Custom.pll

Extensive experience in developing custom reports and customizing standard reports using reports 6i /10G.

Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.

Expertise in Oracle XML Publisher and Discoverer reports.

Knowledge on UNIX Shell Scripting and OBIEE Reports.

Knowledge on Oracle XML Gateway and EDI.

Good Expertise in developing applications using SQL, PL/SQL, Advanced level of PL/SQL concepts, Database Triggers, Stored Procedures, Oracle 11g/10g/9i/.

2 R12 upgrade experience

Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD

Experience in customizing Workflows using Workflow Builder 2.6.3

Experience in working with ITG Kintana/ HP PPM change management and PVCS migration tool.

Good functional and development expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle P2P and O2C modules.

Exposure to data support on Multiple Environments like UAT, SIT, CAT, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board

Received many appreciations, certificates, prizes from client for identifying and fixing the production issues.

TRAININGS

Oracle E-business suite R12.1 supply chain management and Oracle Financials, Procurement Cloud Implementation.

Conducted training on EBS Supply chain modules, Finance, Oracle Discoverer, Oracle Forms /Reports and XML Publisher.

Trained in Oracle ADF/ SOA Suite / OA Framework.

TECHNICAL SKILLS SUMMARY

Oracle Apps Modules

: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets, Project Accounting, Cash Management, Order Management (OM), Purchasing (PO), Inventory (INV), Advance Pricing, BOM, WIP, I-expenses, I-Procurement, I-store, E-Commerce Gateway, Oracle Mobile Applications Framework, Service Contracts, Web ADI and Oracle Alert.

Database Tools

: TOAD, Oracle SQL Developer

Other tools

: Clear case, Kintana, QC, JDeveloper, Winscp, Putty, Secure CRT,

SQL*Loader, Service Now, HP PPM, CVS, Data Loader.

Languages

: SQL, PL SQL, JavaScript, HTML, XML, Shell Script, Core Java

Databases

: Oracle 9x/10.0.2.0/11g

Operating Systems

: Windows-98/2000/NT/XP, MS-DOS, UNIX/HP-Unix

Knowledge

: Oracle Forms 6i/10g/11g Builder, Oracle Reports6i/10g/11g Builder, BI/XML Publisher, Oracle Discoverer, Oracle Workflow, Advanced Level PL/SQL concepts.

PROFESSIONAL EXPERIENCE

Oracle Techno Functional Consultant (Nov’08 – Till Date)

Projects Handled

Linkedin Corporation Nov’16 to Till Data, “Oracle Apps Techno Functional Consultant”

Motorola Mobility Inc May’14 to Oct’ 16, “Oracle Apps Techno Functional Consultant”

Qualcomm Inc May’12 to Mar’14, “Oracle Apps Techno Functional Consultant”

Motorola Solutions Jan’12 to April’12 “Oracle Apps Techno Functional Consultant”

Almac Clinical Services, UK Jun’10 to Jan’12, “Oracle Technical Consultant”

Supervalu Service US, Mar’09 – May’10, “Oracle Apps Technical Consultant”

Roles & Responsibilities:

Interfacing with management on all Oracle EBS project related issues, changes, reporting and impacts ensuring that comprehensive information is provided to all stakeholders in a timely manner.

Responsible for Month End Activities and Year End Activities for support related projects.

Leading team of offshore and onshore model and owning the monthly release deliverables.

Gathering, refining, and documentation of the business rules, functional and technical requirements.

Responsible for Complete test cycle in Unit Testing, User Acceptance Testing

Preparing Implementation Notes and coordinating with migration teams for successful code release.

Worked on Setups required for AR Lockbox process.

Attend meetings and follow up on resolution in all phases of SDLC process.

Review development design for customer code and applications, approve development requests for production issue resolution (custom issues)

Manage change control process, approval of code migration from Development, Test and Production environments and present changes at weekly status meeting

Creation of technical, functional and requirement documentation.

Responsible for Post production activities of projects which are implemented in production.

Development of custom components based on business requirements.

Linkedin Corporation – Oracle Techno Functional Consultant (Oct’16 to till date)

Implementation Project

● Presently working on Oracle R12 Account Receivables module as a techno functional analyst for project “Abacus”, Goal is to interface the invoice, receipts and service contracts with third party system from oracle and vice versa.

● Prepared Proof of Concept document for implementation of Oracle APEX and set up development instance from scratch.

● Worked on Setups required for AR Auto Invoice, AR Lockbox process.

● Developed Oracle APEX application for Error Handling Report which makes business user to rectify the error records using APEX application for updating and deleting the existing records.

● Worked on preparing design for revenue recognition process.

● Developed SOA Web Service for integration between AQ tables of Oracle System push the data to third party system.

● Developed API for implementing the design functionality of revenue recognition process.

● Working in an Agile Scrum way, comprising of 2 weeks of each sprint. Each sprint features completion of development, analysis, unit testing, technical design document and overall flow document for the scope of the sprint followed by the Demo at the end.

● Interpreting customer business needs and translating them into application and operational requirements.

● Working with cross-functional teams to gather requirements design the process and implement effectively.

● Developing new reports and modifying existing accounting reports in Discoverer.

● Functional work includes oracle application setups such as lookup, accounting rule, receipt class, payment methods.

● Development work in PL SQL core programming, Oracle applications concurrent programs, DDL and DML scripts for new and existing objects such as tables, views, packages, procedures, form personalization.

Motorola Mobility – Oracle Techno Functional Consultant (May’14 to Sep’16)

Implementation and Support Project

Interact with business users regularly on ongoing support issues and provide accurate solutions.

Involved in Implementation of end to end functional setups required for O2C business process Setups, New inventory org creation and related setups.

Configuration of CRM foundation related all setups like Employee, Resource, role types, roles, role assignments etc.

Good Exposure on process and setups related to AR Intercompany Transactions.

Performance tuning of slow running programs and applications.

Developed Sub Ledger Reconciliation Report using XML Publisher.

Modified SLA Definition as per client's requirement and resolve problems with SLA.

AR Receipts adjustment upon cancellation of Orders.

Period End activities for various financial modules.

Reconfiguration of Legal Entity, Operating Unit and Inventory Setup related to specific Organization.

Implemented Setups of IR/ISO sales order, Back 2 Back sales order, RMA sales order and Drop Shipment process.

Created Inter Company price list for Inter Company transactions in Order Management and Inventory application.

Analyzing the Clients requirements and implement the same in ERP system.

Implementation of function and technical design and setups for Electronic Data Interchange (EDI) 850 E-commerce gateway process.

Developed the XMLP reports using xml publisher reporting for multiple EBS modules like OM, Purchasing, Shipping, Accounts receivables, Accounts Payables, project Accounting etc.

Extensively worked on preparing end 2 end test scenarios, test scripts on different applications to help the users for better understanding the application.

Involved in System testing for Order Management seeded functionalities

Created Materialized View for GL Account Analysis Report.

Worked on OAF Personalization of Supplier, Customer, and Bank and Branches OAF pages.

Prepared PL/SQL package for to generate payment format file for CITI bank.

Developed Mobile Application to release hold for an Orders using Oracle Mobile App Framework.

Worked on CUSTOM.pll to make all forms read only which are accessed from Inquiry responsibility.

Using XML bursting created commercial invoice report which will be emailed to intended user automatically.

Configuring the setup for batch invoices and batch payments, multi-currency invoices

Worked extensively on reprice of items by customizing Order line standard Oracle Workflow.

Qualcomm Inc – Oracle Techno Functional Consultant (May’12 to Mar’14)

Implementation and Support Project

Worked on AR receipts, Employee and Supplier Conversions.

Developed the PL/SQL package for AP/AR/PO Attachment Conversions.

Worked on fixing the defects raised during CRP2 and UAT.

Development of Interface for loading GL Daily Rates

Worked extensively on fixed assets conversions.

Involved in AR Setups like Auto Accounting Rules.

Development of Historical Data tables which are specific to the organization.

Involved in functional support of production issues in oracle AP and AR modules wherever required.

Created category sets, category codes, default category sets for the various items in Inventory application.

Resolved the critical issues on Shipping Execution while Ship Confirming the Sales Order.

Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups.

Creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.

Item Upload conversion from legacy to Oracle ERP system.

Created setups to import Freight Costs entered at shipping into Account Receivables module

Created Automated process to assign Item categories for an item in bulk.

Worked on automation process of applying holds on sales order upon booking which have new items.

Developed package for Item Attributes Interface which updates missing attributes for items.

Perform system testing to verify the application integrations.

Reprice the order line price by customizing standard order lines workflow.

Debug the issues related to Oracle service contracts.

Good knowledge on system and user defined Order Management Holds and Hold Sources.

Troubleshooting and fixing the defects of Discoverer report which are having the issue.

Development of new discoverer report as per the requirement.

Responsible for migration of developed components to production

Support post production timelines and issues

Development of XML Publisher Reports as per client requirement.

Preparation of procedures, functions, packages as per the requirements.

Analysis of Function Design Document and preparing Technical Design Document.

Motorola Solutions – Oracle Techno Functional Consultant (Jan’12 to Apr’12)

Implementation and Support Project

Responsible for technical specification design, development of the code, unit testing the program based on six-sigma analysis and project execution.

Involved in designing, executing test cases and defect reporting

Involved in preparation of test cases for RICEW components related to Order to Cash flow.

Good Exposure on process flow of Intercompany Transactions.

Test cases uploading using Quality Center.

Involved in test cases Review (Audit).

This Project includes both Support and Enhancements (Incident and Problem Management Activities)

Involved in AR setups such as Transaction Source, Transaction Types, Receipt Classes, Auto Accounting Rules, Receipt Sources, Payment Methods, Customer Profile, Payment Terms, Auto Invoice. Successfully created all kinds of Transactions and transferred transaction to GL.

Involved in setups related to AP Payment formats.

Having good exposure on AR LOCK BOX setups like Receipt Source, Receipt Class, Payment method, transmission format and Process.

Extensively worked on Price Upload, Item

Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups as per business needs in Order Management module.

Upload, Automated process to create / update the Items, Prices in Oracle.

Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the required setups.

Worked on RMA Process, importing EDI orders, and Credit Memo process in Order Management, Account Receivables Modules.

Almac UK – Oracle Technical Consultant (Jun’10 to Jan’12)

Implementation and Support Project

Development of XML Publisher Reports as per client requirement.

Preparation of procedures, functions, packages as per the requirements.

Expertise in Setups related to creating New inventory orgs, Intercompany transactions and creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.

Preparation of migration and shell scripts.

Testing - Unit testing & Documentation.

Developed Cost of Sales GL report.

Developed Generate AR Billing Detail package.

Developed Multiselect Parameter form.

Developed custom program to interface all custom data to AR Interface table.

Developed Item Conversion to import item details from legacy system to Oracle System.

Gathering business requirements.

Developing the RDF files, XML Reports as per requirements of user.

Development of Lydall US Sales Order Acknowledgment report.

Development of Lydall US AR Invoice Report.

Supervalu Services India – Oracle Technical Consultant (Nov’08 to Jun’10)

Implementation Project

Responsible for Development and Customization of Reports and Interfaces between legacy system and Oracle Apps.

Preparation of SQL Loader scripts.

Developing of Interfaces as per client requirement.

Defining Concurrent Programs, Executables.

Worked on Open Notifications report.

Developed Manual Approvals details Report.

Developed Matching information Report for Purchase order.

Developed PO conversion to upload the Purchase Orders from Legacy system to Oracle apps system.

Developed AP Vendor Extract Interface to extract supplier details from Oracle apps to Legacy system.

Contact this candidate