Oracle Developer

Mallikarjun Malyala

Senior Oracle ERP Consultant

Ph: 301-***-****, Email: ***********.****@*****.***

Summary

Over 11+ years of IT experience in developing cost effective solutions as Oracle ERP Consultant using Oracle PL/SQL, Oracle Applications and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.

Extensive experience in using SQL, PL/SQL, SQL Loader, Oracle 10g, UNIX and Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).

Techno functional knowledge in the business processes such as Oracle SCM (PO, OM, INV) and Oracle Financials (AP, AR, GL, IEX, AGIS, TCA, CM), Order to Cash (O2C), Procure to Pay (P2P), AOL and Sysadmin of Oracle EBS 11i and R12.

Extensively worked on life cycle implementations using oracle applications R12.1.3 and 11.5.10.

Hands on experience in development and extension of RICE components using SQL and PL/SQL, Customization of forms using forms personalization, Extensions of forms Oracle form builder, reports using Report builder 6i, XML Publisher and exposure to WF.

Extensive knowledge in working with the tools like TOAD, SQL Developer, SQL* Loader and performance tuning.

Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API's from legacy systems to Oracle EBS.

Designed and developed various payment formats like PAM and SEPA as per client need.

Expertise in Design and Development of interfaces and conversion programs with respect to financial modules to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc.

Proficient in creating functional and technical specifications as well as test plans and test scenarios using AIM methodology and documents such as BR 100, MD 50, MD 70, TE20, TE 40 and MD 120.

Excellent Data Migration experience from Legacy systems using PL/SQL, Oracle API and Oracle Open Interfaces

Expertise in client engagements and technical support.

Lead a team of 10+ successfully as Onsite Team Lead/Senior Developer in major full cycle implementations and end-to-end business support projects within the assigned time, cost and quality parameters

Providing standardized and global solutions to specific, segregated and customized business processes, performing feasibility analysis, impact analysis, RCAs, proof of concepts for complex business problems and issues

Strong analytical and trouble-shooting skills, excellent communication and interpersonal skills, self-motivated, quick learner, and team player.

Technical Summary:

ERP Modules

Oracle Applications R12/11i (GL, SLA, AR, AP, IEX, AGIS, CM, FA, IBY Payments, TCA, OM, PO, Sysadmin and Application Object Library)

Development Tools

OAF JDeveloper 2000 (Forms 6/9i, Report 6/9i), SQL*Plus, SQL Developer, PL/SQL Developer, SQL*Loader 6.0, Data Loader 4.0, Toad, Oracle Workflow builder, JDeveloper, BI Publisher 11g, XML Publisher and Web ADI.

Change/ Config/ Quality control Management Tools

HP PPM (Kintana), ARCS, PVCS, Stash GIT.

Programming Languages

PL/SQL, SQL, Unix Shell scripting

Fusion Middle Ware

BizTalk, SOA

Web Technologies

HTML and XML

Databases

Oracle 9i/10g/11g, SQL Server

Operating Systems

Unix/Linux, Windows 98, 2000, NT, XP, Vista and Window7

Professional Experience

Senior Oracle EBS IT Technical Consultant

Client: Hafele America Co - Archdale, North Carolina June 2016 – Till Date

Häfele America Co. serves the U.S. market with innovative services and solutions by focusing on delivering functional hardware and specialty fittings to meet construction needs. Häfele is known internationally as a leading source of hardware, fitting systems, lighting and electronic locking systems. Hafele - HAC Project includes customization and maintenance of Oracle E-Business Suite (EBS)/ Oracle Applications R12 (12.1.3) Order Management (OM), Purchasing (PO), Inventory (INV), Oracle Quote (ASO), BOM, WMS and Account Payables (AP), Receivables (AR), General Ledger (GL).

The key goals of this project are:

Customization and maintenance of Oracle Applications on R12.1.3 instance.

The key facets in this project as a Senior Oracle EBS Techno Functional Consultant are as follows:

Working as Technical Developer involved into development of RICE components (Reports, Interfaces, customizations and Extensions) and responsible for maintenance and production support.

Worked on freight rating system enhancements according to Hafele Business requirements integrating with third party Freight Rating provider (Trilogix).

Developed purchase requisition interface and work order interface to automate the process with data received from procurement forecasting application (Slim4).

Worked on OneWeb customization/enhancements (Online Web portal) which transforms online entered data into Oracle Quotes and to identify items and mark them with eye catcher. This way, website will highlight certain items that they would like to promote.

Worked on Chase Paymentech Project where Hafele integrates with Chase bank for credit card processing to handle payments while processing Quotations and Sales Orders.

Developed GA Fusion program to combine offline and online data into one platform to unlock what digital marketing plays in offline sales growth.

Involved in 3PL (3rd Party Logistics) integration enhancement changes which is third party logistics for Hafele America who provides delivery services. Hafele outsource delivery services by sending booked orders and gets confirmation once delivery is done to customers.

Involved in EDI (Electronic Data Interchange) files (850,855,810,856 and 997) processing to exchange data in a standardize format between business partners using EDI translation software (GENTRAN).

Developed custom reports using sql and xml publisher as per business requirements.

Developed views to build reports using Qlikview software.

Performs data loads and catalog updates received from product team to maintain up to date price book for online users.

Worked on enhancements and issues of critical business processes like Rescheduling of Orders, Transform, Item Scrapping Process, submit sales reports to FTP site on daily and monthly basis, daily application checks which reports issues in application on daily basis and sends email to notify users to correct them.

Involved in weekly meeting with business and functional team to understand the business process and transform functional specifications into Technical components.

Involved in Month End activities and contributed for smooth period closing.

Involved in creation of Users, grant roles and responsibilities for new hires based on operating Unit.

Working on Production issues through manage engine tool and resolve them as part of maintenance.

Document all the changes going into production as part of release management.

Involved in data cleanup scripts to cleanse data in Oracle and development of data extraction scripts for SAP migration for SD, MM and EWM modules.

Environment:

Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.1.3)), AP, AR, PO, OM, GL, INV, ASO, Oracle Forms & Reports 10g, Workflow Builder, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX,TOAD, FileZilla and Putty.

Senior Oracle EBS Techno Functional Consultant

Client: CCHS ( Cross Country Home Services ) Sunrise, Florida Feb 2015 – June 2016

CCHS business is into Home Warranty services catering the Home insurance needs. CCHS - Atrium Project includes implementation, and customization of Oracle E-Business Suite (EBS)/ Oracle Applications R12 (12.2.5) Account Payables (AP), Purchasing (PO), General Ledger (GL), Order Management (OM), and Inventory (INV), Oracle Quote (ASO), Service Contracts (OKS), Quality, BOM.

The key goals of this project are:

Re-implement the Oracle Applications on to R12.2.5 instance.

The key facets and achievements in this project as a Senior Oracle EBS Techno Functional Consultant are as follows:

Working as Technical lead facing client for requirement gathering along with functional team, design and develop complex solutions.

Worked on the client requirement for creating Party, Customer, Customer Sites, Bank Accounts and Credit cards, Customer Org Contacts etc. using oracle standard API’s This services are utilized from custom third part application, ECM and COM portal as per business.

Worked on various conversions activity such as Customer Conversion, Invoices and Receipts conversion and PO Conversion.

Worked on Analysis, design and implementation of custom enrollment process, which includes integration of oracle modules, Campaign, Marketing, Quotes, Order Management, Service Contracts and AR process.

Created custom Interface between Order management and Service Contract for enrollment process.

Developed custom solutions like Activity Stream Framework to capture the actions logged during business processes.

Worked on Oracle Quality Module, created and modified collection plans as per the client Needs.

Worked on oracle payment process, developed custom Check layout and reports (formatting checks and positive pay file layouts) in AP.

Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables

(AR_PAYMENTS_INTERFACE_ALL), from interface table to the Base Interim tables and finally to the base table.

Extensively used PL/SQL Collections while developing the code.

Support on ORACLE Campaign and marketing modules, Development of Custom OA Framework Pages as client requirement.

Developed reports for correspondence using XML/BI publisher reporting.

Worked on Quote to Order cycle according to CCHS business requirements.

Exposing PL\SQL procedures as REST services using SOA gateway administrator for consumption.

Involved in weekly meeting with business and functional to understand the business process.

Worked on the new Version control software GIT/Stash for migrating code to higher instances.

Environment:

Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.2.5)), AP, AR, PO, OM, GL, INV, OKS, ASO, Oracle Forms & Reports 10g, Workflow Builder, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX,TOAD, GIT/STASH and Putty.

Senior Oracle EBS Technical Consultant

Client: NIH – NBS (National Institutes Of Health – NIH Business Solutions) Maryland

June 2014 – Feb 2015

National Institutes of Health (NIH), part of the U.S. Department of Health and Human Sciences – Supporting Scientific studies that turn discovery into health.

The key goals of this project are:

Support of Oracle Applications 11.5.10

Re-implement the Oracle Financials Modules on to R12.1.3 instance.

The key facets and achievements in this project as a Senior Oracle EBS Techno Functional Consultant are as follows:

Worked on 11i Payment formats enhancements as per new PAM Payment formats.

Worked on Re-class functionality to reconcile the payments across NIH systems.

Techno-functional Lead for reporting and interfaces of Oracle EBS in AR, AP and SLA modules.

Participated in the design discussions of the project, contributing to deliverables like to-be process flows.

Worked on Receivables, Payables related SLA Custom Sources for Fund type, apportionment category, based on Revenue distribution lines, Expenditure item and customer agreements.

Worked on Project Maintenance form customizations and personalization changes

Developed reconciliation reports needed for treasury systems using pl/sql procedures and BI Publisher.

Involved in the development of the several customizations which includes analysis, design, development, testing and implementation of Oracle ERP solution.

Interacting with client, analysing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business & creating TE20 and testing the changes and implementing the same in Test environment & production.

Responsible for Migrations of the technical objects from Development instance to other testing instances and production using the migration tools such as putty, HP PPM and SVN.

Environment:

Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.1.3)), AP, AR, GL, AOL, Oracle Forms & Reports 10g, Workflow Builder, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX,TOAD, SVN and Putty.

Senior Oracle EBS Onsite Technical Lead

Client: Neste Oil – Finland(Europe) (Infosys Technologies Pvt Ltd) October 2011 – May 2014

Neste Oil is a Finnish oil refining and marketing company producing mainly transportation fuels and other refined petroleum products. Neste Oil has three business areas: oil products, oil retail and renewable fuels. It produces, refines and markets oil products and shipping and engineering services, as well as licensing production technologies. Infosys was assigned to re-implement the Oracle Applications several financial modules (AP, AR, FA, GL, IEX, CM, Ebtax and AGIS). Client was using Oracle E-Business Suite financial modules on 11.5.10 and moved to R12.1.3 globally for all entities.

The key goals of this project are:

Re-implement the Oracle Financials Modules on to R12.1.3 instance for all entities of Neste Oil.

Standardize the financial business process across the geographies and legal entities.

Pilot solution to be implemented for selective entities and same solution to be rollout across all geographies.

The key facets and achievements in this project as a Senior Oracle EBS Developer Consultant are as follows:

Onsite Lead facing client for gathering business requirements along with functional team and involved into End to End cycle from fit gap analysis to development and deployment.

Effective Onsite Offshore Coordination along with critical objects development at client side.

Designed and Developed Custom Pl/SQL programs, Host scripts, SQL Loader scripts, Reports,

Forms extensions in Oracle Financials (AR, AP, GL, IEX (Collections), AGIS, CM, FA and Ebtax)

And Oracle SCM (INV, OM, PO).

Used Oracle API's across the customization of the Order to Cash process.

Developed custom Interface Program to load on-hand inventory transactions from external flat files into Interface tables.

Designed and developed new interfaces for AGS and IEX modules to automate the process.

Designed and developed alerts, interface reconciliation reports forwarding the Interface errors.

Design and development of RICE Components

Extensive design and developments of custom PL/SQL programs for Interfaces and Conversions for Oracle financial modules.

Developed Customer Collection Process (Dunning Letters) customization.

Code enhancements and lookup definition to cater the needs of new product line.

Designed and Developed shell script and SQL loader program to load the data into staging tables.

Enhanced interface setups for transferring the files to respective trading partners.

Developed outbound interfaces as part of collection process as per business requirements.

Advanced PL/SQL development in financial system specific to the client.

Followed AIMS template (MD050, MD070, BR100…etc) to manage Project & Documentations.

Developed various Custom reports on the basis of business requirements used for month end closing

Using Oracle reports and XML publisher.

Involved in Forms Extensions and Personalization as per the business requirements.

Developed custom forms using Oracle form builder.

Converted various custom RDF reports to XML reports.

Anchor proof of concept development to validate proposed solution and reduce technical risk.

Prepare estimates, release plan and road map for future releases and participate in cut over activities

During every roll out by supporting multiple R12 EBS application, monitor, analyze, resolve support tickets, provide weekly Status report and manage customer expectation.

Environment:

Oracle E-Business Suite (EBS)/ Oracle Applications (R12 (12.1.3)), AP, AR, PO, OM, GL, INV, OKS, ASO, Oracle Forms & Reports 10g, Workflow Builder, XML Publisher, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, OAF, UNIX,TOAD and Putty.

Achievements:

Recognition by Neste Oil CEO for Successful Pilot Entities Go-live and solution/Technical design for Global Roll-outs.

Recognized and won Most Valuable Player (MVP) award and Bravo award for an exceptional work done in Pilot entities implementation and during the Global Roll-outs.

Best Team recognition in the Oracle Practice.

Senior Oracle EBS Technical Lead Consultant

Client: JP Kenny Inc – Infosys Technologies Pvt Ltd May 2011 – Sep 2011

The key facets and achievements in this project as Techno-Functional Consultant were as follows:

Developed BI Publisher Reports and Check Printing reports.

Designed and developed custom PL/SQL programs, SQL Loader scripts, XML Reports in AR, AP and GL and service contracts.

Implemented Bills of Materials (BOM) interface using open interface tables by doing necessary validations.

Developed customized reports like Invoice print and various other reports in Inventory module as per client needs.

Converted various oracle reports to xml publisher reports in BOM and WIP modules.

Developed Oracle Alerts, Workflows.

Handled components of Oracle Application Frame work (OA Frame Work) personalization like VO, CO, AM, EO extensions, Page extensions.

Migrating the OAF extended objects from one instance to other instance.

Followed AIMS template (MD050, MD070, BR100…etc) to manage Project & Documentations.

Performance Tuning of custom programs.

Involved in Forms Extensions and Personalization as per the business requirements.

Converted various custom RDF reports to XML reports.

Worked on various enhancements using form personalization.

Developed test plan, test scenarios and executed user-acceptance test cases and ensured proper cutover plan & successful Go-Live.

Environment:

Oracle EBS R12, Developer 2000(Forms 6i, Reports 6i), TOAD, XML Publisher Oracle OAF

And Oracle Workflows.

Oracle EBS Technical Consultant

Client: New Edge USA LLC – Capgemini Pvt Ltd July 2010 – April 2011

Project Name: R12 New Edge Fast Program

Newedge is a rapidly growing global Financial Services organization, Newedge is running the global FAST program to address the needs for standardizing and improving its process and technology frameworks that will help them with process improvements and accomplish complete finance transformation. The project is to implement a multi-country rollout to provide a Finance transformation framework for Newedge with Financial Accounting Hub, Thin GL, and Supporting Reference with appropriate application Architecture to help process high volumes and with a Financial Industry focused reporting solution using the full suite of products.

Responsibilities:

Developed BI Publisher Reports and Check Printing reports.

Designed customizations, interface/conversion mapping document.

Developed Currency Rate Interface.

Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR (Lockbox).

Worked on FSG report generations for financial reports.

Worked on migration of FSG using data links.

Extensive involvement in design, development, Unit Testing, UAT and Regression Testing.

Creation of LDT files to load Executables, Concurrent Programs and Request sets.

Customized various RDF reports as per the business requirements.

Designed XML publisher reports. These are configured to generate output in PDF formats

Involved in the maintenance, enhancements and new development of Registration of Reports and forms in Oracle Application R12, Discover Reporting, Unix Shell scripts.

Preparation of MD65, MD70 Documents.

Using FNDLOAD utility for transferring Concurrent Programs, Request Sets, Value Sets and Request Groups from one Instance to another Instance.

Performance Tuning of custom programs.

Mentoring the team on BI Publisher reports.

Got trained in OBIEE.

Environment:

Oracle EBS R12, Developer 2000(Forms 6i, Reports 6i), TOAD, XML Publisher

Achievements:

Successful team coordination and managing the project team at offshore and coordinating with Onsite members.

Technical Staff Consultant

Client: Oracle Corporation – India (Oracle SSI) Nov 2006 – June 2010

Project #: R12 Russian Localization Phase I, Phase II and Phase III – RLP Project

Client

Oracle Russia (RU) (Oct-08 to June-10)

Role

Technical Consultant

Environment

Oracle Application Release 12, Oracle 10g

The main objective of the Russian Localization project is to convert all the existing Reports, Forms and Interfaces of the Russian Clients from 11i to R12 using the new BI/XML Publisher architectural changes. Also Modify/ Create New Reports/ according to the new R12 architecture.

Russian legislation requires that the input VAT from purchased goods/services, which is used to manufacture goods for, export sales and sales without VAT must be accounted separately from other incoming VAT. Also there are some specific rules for VAT accounting in case of export sales. This task is called the Separate VAT accounting.

One of the essential tasks of VAT accounting is ‘VAT refund for purchased assets’. This task needs several complex actions to be done so the task could be completed successfully. VAT Refund for Purchased Assets is a component of the whole Russian VAT solution and must be fully integrated with the other components of the whole solution, such as the Separate VAT solution.

Russian Localization on VAT is a solution to have a central place for all Vat transaction entry and processing. All the tax received and paid from customers, suppliers and employees has been maintained at one place. For the Vat transactions entered in corresponding receipt, payment or invoice and accounting entries will be created AP, AR and GL modules to meet the Russian Legislation and Tax Structure.

Responsibilities:

Worked as primary owner for all technical components assigned for development.

Worked closely with Functional consultant and customer in designing and implementing the new requirements of customers.

Involved in Translating the Reports into Russian Language.

Involved in Monitoring the Service Requests raised by the customer, analysing the issues and resolving the issues as per customer’s Requirements.

Development and Testing Involved of BI/XML Publisher Reports and interfaces for VAT reporting.

Project #: R12 X-Country Localization

Client

Oracle X-Country (Jan-08 to Aug-08)

Role

Technical Consultant

Environment

Oracle Application Release 12, Oracle 10g

The main objective of the X Country Localization project is to convert all the existing Reports, Forms and Interfaces of the several Country Clients from 11i to R12 using the new BI/XML Publisher architectural changes. Also Modify/ Create New Reports/ according to the new R12 architecture.

Cross Country Localization on vat On Prepayment is a solution to calculate tax based on Proforma Invoice or Prepayment Receipt accordingly.

Responsibilities:

Worked as primary owner for assigned objects.

Worked closely with Functional consultant and customer in designing and implementing the new requirements of customers.

Technically providing work-around solutions for various customer issues.

Interface/Conversions:

Developed New Custom Program CLE VAT On Prepayment Based on EMEA VAT Repository Using EB-Tax Module and receivables Modules

Developed Custom Program CLE VAT on Prepayment for interfacing transactions using API.

Involves in Impact Analysis from Oracle Application Version 11i to R12.

Project #: R12 Report Transition Project

Client

Report Transition project (RTP) (Jan-07 to Dec-07)

Role

Technical Consultant

Environment

Oracle Application Release 12, Oracle 10g

The idea of this project is to replace the EMEA Localization Reports by a core product solution based on XML Publisher. As part of this project we have developed several reports, which will be owned by GL, AP, AR, SLA and FA product teams.

Responsibilities:

Worked as primary owner for assigned objects.

Worked closely with Functional consultant and customer in designing and implementing the new requirements of customers.

Technically providing work-around solutions for various customer issues.

Involved in Translating the Reports, Programs and Forms into Russian Language.

Reports:

Involved in BI/XML Publisher Reports.

Reports Includes like FA Statement of Equipment Receipt for Assembly.

Involves in Impact analysis of Oracle Application version 11i to R12.

Environment:

Oracle EBS R12, Developer 2000(Forms 6i, Reports 6i), TOAD, XML Publisher.

Software Engineer

Client: Sriven Multitech PVT LTD – India July 2005 – Nov 2006

The project involved implementation of Release 12 Oracle Financials for one of the leading multimedia Company located in Hyderabad, US.

Roles & Responsibilities:

Development of PL/SQL packages, functions and procedures for data extraction for migration and developing new reports and customizations as per client need.

Work with cross work streams, and determining solution design impacting the core frameworks and components

Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.

Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support.

Preparation of Technical Design Document (MD070).

Worked closely with Functional consultant and customer in designing and implementing the new requirements and technically providing work-around solutions to customer Issues.

Attended an in-house training in Oracle Applications Financials.

Environment:

Oracle EBS 11i/R12, Developer 2000(Forms 6i, Reports 6i), TOAD.

Education

Masters of Computer Applications from Osmania University, Hyderabad, India.

References & Recommendation Letters

Available on Request

Contact this candidate