Oracle Applications Consultant

Lokesh Galappa

ac37hn@r.postjobfree.com Cell: 408-***-****

PROFESSIONAL SUMMARY:

Result oriented professional with 16 years of experience in Oracle and related technologies.

Proven expertise in requirement gathering, analysis and design of software solutions to support the business needs of the Global Corporations.

Good experience in mentoring and providing technical assistance for juniors and offshore analysts.

14+ years of experience in Oracle ERP Systems providing solutions to business/system problems, and implementing the same through customer acceptance and final delivery of the solution.

Strong experience in Enterprise Resource Planning, Object Oriented Programming Methodologies.

Extensive experience in the Functional and Technical aspects of Oracle Applications 11i

(11.5.6, 11.5.7, 11.5.10). Worked across different modules of the Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, BOM, Oracle Order Management, Service Contracts, and Installed Base.

Strong experience in Oracle Applications (OM, Purchasing, Bill of Material, Inventory, Install Base), PL/SQL, SQL, Oracle Forms 6i, Reports and Oracle Workflow, TOAD, PL/SQL Developer.

Extensive experience in design, development and unit testing in Oracle Reports6i, PL/SQL Concurrent programs, conversions,interfaces,Oracle Forms 6i, and Performance Tuning.

Proficient in Oracle Order to Cash and Procure to Pay flows.

Good understanding of Oracle SOA, and BPEL.

Good experience working with AIM and Agile Methodologies.

Involved in various Software Development Life Cycle (SDLC) phases - including requirement gathering, functional design, technical design (MD070), unit-test plans

(TE020), execution and application maintenance.

Good Experience in integration of Oracle with Oracle SOA and WEB Services for enabling B2B.

Experience in Post production support and enhancements.

Good experience in using Kintana package for migration of database objects.

Proficient in SQL and PL/SQL tuning techniques

Good Analytical and problem solving skills

Proficient in estimating efforts in design, development, unit testing.

Experienced in interacting with business users, offshore/Onsite teams

Proficient in Oracle forms and reports.

Working Knowledge in Java.

PROFESSIONAL EXPERIENCE

Client: Google Inc, San Jose, CA. Nov 16 – Present Employer: HCL Americas (Nov-16 tilldate)

Role: Senior Software Engineer

Responsibilities:

Review functional design and prepare technical design for supply chain process Provide development, release management, logging, testing, and bug triaging for Oracle E- business Suite

Effort Estimation, Design, Develop, Test and Deploy the application. Defect tracking and resolving using defect tracking system Build UIs and APIs to support logistics to track inventory at 3PL locations Integrate data exchange with 3PLs and suppliers

Build APIs to process various inventory transactions on receipt of B2B messages from partners Implement Cycle counting by integrating cycle count process with 3PL partners through B2B Prepare technical design and Unit test cases

Co-ordinate with other teams and partners to deliver on time Unit testing and Integration testing

Code Review and Performance fixes

Client: Google Inc, Mountain View, CA. Jun 13 – Nov 16 Employer: Horizon Technologies Inc.

Role: Supply Chain Analyst

Responsibilities:

Designed systems/applications/integrations, developed test cases, involved in testing the system/integration and prepared user manuals for the following: Item integration between PLM and Oracle to import items from PLM to Oracle Transactions Engine to derive inventory transactions to be played when material is moved between two locations across globe.

Build new Integration with 3PL and vendors.

Client: Google Inc, Mountain View, CA. Jun 09 – Jun 13 Employer: Wipro Ltd

Role: Oracle Apps Supply Chain consultant

Responsibilities:

Designed and developed custom module to support logistics handled by 3PLs and tracking inventory.

Designed and developed custom APIs to process various Inventory transactions on receipt of B2B message from 3PL.

Designed and Developed interfaces for Inventory transactions.

Implemented Cycle counting by integrating cycle count process with 3PL partners through B2B.

Replicated the logic to process cycle count entries for serialized items with quantity only

(from Oracle cycle count entries form) as this feature was not supported in Oracle cycle count entry processing API in 11.5.10. Developed interfaces for cycle count entry, cycle count adjustments.

Preparing Technical design and unit test cases and coordination with UI and Oracle SOA team for development and testing.

Designed and Developed a cost valuation engine to derive cost using organization hierarchy.

Designed and Developed custom module to handle RMA.

Developed interface to create non-standard WIP jobs to track the material sent to vendors for repair.

Extensively worked on oracle database types.

Developed APIs to process Purchase Order Receipts Inbound on receipt of B2B message.

Developed PL/SQL concurrent programs for reporting which would send output as email attachment.

Responsible for quality and on-time delivery from offshore team.

Fixed various performance issues in SQL, and PL/SQL Client: Cisco Systems, San Jose, CA Apr 08 – May 09 Employer: Wipro LTD

Role: Technical consultant

Responsibilities:

Involved in upgrade of Oracle Applications from 11.5.6. to 11.5.10 covering Service Contracts and Install Base Oracle modules.

Analyze existing application extensions and customizations to identify the changes required with respect to upgrade.

Design and development of technical components, database triggers, PLSQL bolt-on programs and modifications to custom libraries.

Preparing unit test scripts and executing the test cases.

Technical design review and code review for the components developed at offshore and support to offshore team

Planned and executed multiple test to arrive at the right sequence of migration of database objects, address interdependencies that resulted in successful migration.

Importing Install base records from other systems using oracle Installed base APIs.

Worked on Forms Personalization to address specific business requirements in Oracle Service Contracts form.

Developed Custom forms as per the new requirements using Oracle Forms 6i.

Developed Custom report to extract the Installed base records for a specific period/customer etc.

Enhanced the program for mass loading of service contracts which handles creation of new service contracts, Update of service contracts, changes in service levels etc.

PL/SQL Concurrent Programs for processing high volume of Install base records by batching it into smaller chunks using BULK processing techniques.

Tuning long running SQL queries.

Client: Infocus Corp, Portland, OR. Oct 06 – Apr 08 Employer: Wipro LTD

Role: Oracle Apps Techno Functional Consultant

Responsibilities:

Solved Service Requests which involves problem solving, analyzing and understand the business flow and functional aspects for Supply Chain Management modules OM, PO, INV and Install base.

Handled Code reviews, Internal and External Quality assurance reviews, conducting quality analysis meetings.

Actively involved in preparing understanding documents, Design Documents, and Test Plans.

Tracking of service requests and assigning it to team members. Adherence to SLAs of service requests.

Modified Purchase order and Sales order workflows as part of enhancement.

Reprocessing / progressing the sales/purchase orders which are stuck in workflow activities.

Handled Customer teleconference pertained to Oracle TAR (Technical Assistance Request) support and Status review meetings.

Train new joinees on Oracle Applications and on the job training and mentoring.. Client: Rabo Bank Mar 06 – Sep 06

Employer: Bearing Point

Role: Oracle Apps Technical Lead Consultant

Responsibilities:

Involved in Requirement Analysis, Preparations of Technical Specifications Document, Design and Coding, Application Implementation, Unit Testing, System Testing, and Documentation.

Responsible for design reviews and code reviews

Developed custom forms as part of customizations on Oracle Lease management module.

Migration of code to test and production environment using Kintana tool.

Created new workflow processes for processing of data and sending notification on failure.

Involved in unit/system testing of extensions to oracle applications. Client: Oracle Corporation, India Feb 04 – Mar 06

Employer: Sonata Software

Role: Oracle Applications Consultant

Responsibilities:

Implementation of Oracle E-business Suite 11.5.10 for JM Family Enterprises.

Involved in development and customization of Forms & Reports and Development of Interfaces on Service Contracts and Claims modules of Oracle CRM product for JM Family Enterprises, one of America’s largest private diversified automotive corporations.

Extension of Standard oracle service contracts authoring form using object groups.

Unit and Integration testing of service contracts form and outbound interface for territories

Migration of code to test and production environments using Kintana tool.

Implemented Oracle Metadata and Spreadsheet in few of the custom forms Post Implementation support for UK Clients: Network Rail, and Hertforshire County Council.

Recording bug history and weekly reporting of bug status.

Prioritizing the bugs reported and work on the bug as per the priority.

Understanding the issue, root causing and providing suitable fix.

Migration of bug fixes to test and production environment using Kintana tool.

Performance tuning of long running programs and SQL queries.

Preparing technical design for enhancements.

Developing custom forms / Pl/SQL programs as part of enhancements Project: Multifond May 03 – Jan 04

Employer: FINCH Software

Multifonds is an Enterprise Product developed and implemented across the globe in the Financial Services domain. Multifonds is a fund administration /accounting software that supports processing of various financial funds like mutual funds, pension funds, insurance companies and other investment funds. It includes operations like stock market transactions, shareholders transactions, futures transaction, tax calculations, valuation and back valuation of NAV and fund units. Multifond has a large customer base especially in the Europe and US. Role: Oracle Developer

Responsibilities:

Analysis of new requirement and propose solution.

Implemented data encryption /decryption using oracle APIs

Prepare technical documents for the new enhancements.

Develop new oracle forms and reports.

Enhance existing oracle forms/reports.

Create new tables, Indexes, Views, and packages.

Unit and system testing.

Prepare Migration Instructions to migrate the code to test and production environments. Project: OMEGA Sep 01 – Apr 03

Employer: Netsoft Business Solutions

OMEGA is a mid range ERP product which caters to the business needs of medium sized establishments. Omega supports the business by providing software solutions for the following business processes:

Purchasing, Sales and Marketing, Finance, Human Resource, and Inventory. Role: Oracle Developer

Responsibilities:

Migration of code from Forms 4.5 version to Forms 6i.

Migration of code from Reports 2.5 to Repors 6i.

Adding new forms, reports, and program units for customer specific requirements.

Prepare design documents for new enhancements.

Training new joinees on Oracle SQL, PL/SQL, Forms and Reports. Project: SHAHI ERP Aug 00 – Sep 01

Employer: Shahi Export House

Role: Oracle Developer

Shahi Export House is one of the leading garment exporters of India. Shahi ERP was an ERP developed in house. Worked on payroll and planning modules of Shahi ERP. Responsibilities:

Requirement gathering, analysis, and propose solution for Payroll and Planning modules.

Created tables, Indexes, views, triggers, Packages

Created API for computation of tax, Increments, Overtime wages, and payroll processing.

Created various reports related to Payroll like Payslip, Form 16, Arrears, Increments slips, overtime payments.

Created planning workbench form which would display the availability of machines for a given period.

Unit and system testing.

Loading data from legacy systems using SQL Loader. EDUCATION:

B.E in Mechanical Engineering from Bangalore University, India.

Contact this candidate