Kameswara Rachamreddy (Kamesh) +1-408-***-****

Summary:

Around 11+ years of experience as an Oracle ERP technical and techno functional consultant (EBS and Oracle Cloud ERP) and proven hands-on experience in designing, Development, reports using OTBI, SQL, BIP, FR Studio, Smart View (Oracle Cloud ERP SCM (OM, Shipping, PO, WIP,BOM, Inventory ), EAS and Financials (AP, GL, AR, PA, FA) P2P, O2C, OIC, BICC and development of integrations using FBDI and Oracle cloud ERP REST api’s using OIC

Part of multiple ends to end implementation of Oracle Cloud ERP (GL, AP, AR, INV, OM, GTM) and prepared and loaded data conversions from EBS to Oracle Cloud, prepared design documents for custom reports and developed in Oracle Cloud ERP using OTBI/BIP

Worked on 11i and R12 support and development projects on SCM (PO,OM,INV,BOM,WIP) and Finance cycles.

Worked as an Oracle Cloud technical consultant and worked on building integrations, building an end-to-end integration including work with users, document, prepare mapping requirements across Oracle P2P and Coupa and bank integration.

Worked on installation, implementation of OIC integrations to connect to local databases and legacy applications.

Used OIC to build BIP report as a REST Web service to make on-demand and event-based data sharing across suppliers, customers, AP/AR invoice, Collections, and inventory Item information.

Well versed with Functional flows between sub ledger modules (AP, AR, PO, OM, FA, CE, Inventory) and GL and developed GL journal import process from third party sub ledgers

Recent hands-on experience in working in migration to Oracle cloud ERP from legacy on-premises ERP and responsible for data conversions to Oracle cloud HCM/Fin/SCM, used FBDI templates to load data, prepared data conversion test cases, developed reports using OTBI/BIP and HCM/Payroll Extracts.

Worked on oracle cloud PaaS and SaaS environment.

Customized Oracle cloud security as per the roles, enterprise security, worked with line mangers, module leads and documented jobs/role and created custom roles as per the security requirements.

Explored OIC and worked with Oracle Support and installed OIC and developed Oracle Cloud ERP integrations using SOAP/REST api’s and developed AP/AR invoice creation from third party legacy applications, used OIC adapters to connect with local home-grown applications, XML/XSLT transformations

Part of post-production support of Oracle cloud Fin/HCM modules and worked on HCM integration with bank and health care partners.

Good knowledge of Order to Cash (O2C), Procure to Pay (P2P), Supply Chain Management (SCM) and Customer Relationship Management (CRM) business flows.

Extensive experience with complete Order to Cash cycle (Quoting, Order Management, Inventory, Advanced Pricing, Shipping Execution, Account Receivables, Account Payables and General Ledger).

Proficient in Oracle EDI Development and support for EDI 810, 850, 855 documents.

Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using Oracle open interfaces and Oracle Public API’s.

Experience in developing new forms with great complexity and customizing standard Oracle forms with the use of TEMPLATE.fmb, Custom.pll.

Proficient in writing stored procedures, Packages, Triggers and Functions using SQL & PL/SQL and expertise in implementing UNIX Shell scripting.

Experienced in registering Pl/SQL procedures, Reports, Forms, XML/BI Reports, and SQL*Loader scripts as concurrent programs in the APPS front end.

Used cross-validation and value set features while implementing descriptive flex fields extensively to capture additional information in standard as well as customized forms.

Experience in supporting the production system, handling day-to-day issues.

Experienced in Implementation and Design of OBIEE (BI Server, Presentation Server, etc.), BI Applications and design of new Reports.

Worked on Oracle Intelligent Track Sensiwatch and Trace.

Knowledgeable in using Oracle utilities FNDLOAD and WFLOAD.

Good working knowledge in Technical Documentation using AIM Methodologies (MD50, MD70, CV40 AND CV70).

Solid Experience in creation of new EUL, new users, Business areas, Complex folders, Item Classes, new ad-hoc Reports, Reports, customizing already existing Reports, exporting business areas from testing to production, Maintaining schedules and Email workbooks, Techno design documentation of the reports in Discoverer 4i/10g.

Extended experience in XML/BI Publisher in creating new custom reports, cross tab reports, matrix reports, upgrading standard 6i Reports to XML/BI Publisher, migrating Data Definitions and Templates from Instance to Instance and also designing of multi layout reports.

Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios and ERDs to enable the testing of system setups.

Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem-solving skills and ability to follow through the projects from inception to completion.

Great learning skills to adapt the rapid changing technologies and implementing the same at work.

Skills:

Oracle Applications

Oracle Cloud ERP, Oracle HCM (Core, Payroll, OAB) Oracle Applications Release Oracle Manufacturing (OM, INV, PO, WIP, BOM), Oracle Financials (GL, AR, AP),EAS, AOL, Sys. Admin.

Application Tools

OIC, Reports 6i, Forms 10g/6i, Discoverer 10g/4i, Developer 2000, Developer Suite 10g, XML Publisher/BI Publisher/XSL-FO reports, Siebel, Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0), EDI, WEBADI.

Databases & Tools

Oracle 10g/9i/8i/8.0, TOAD, SQL*PLUS, SQL* Loader, SSMS.

Scripting Languages

Unix Shell scripts.

Languages

SQL, PL/SQL, XML

Operating System

Linux, Windows XP/2000

Education:

Master of Computer Applications, INDIA.

WORK EXPERIENCE:

Client: Keysight, Dallas, TX Date: SEP 22 – Till Date

Role: Oracle ERP Technical Consultant

Responsibilities:

Developed brand new custom BIP reports across AP, AR, PO, CE as per the user requirements.

Worked on OM, PO, AP custom interface to import external.

Worked R12 form to enable new lov’s in standard columns and zoom form customizations.

Worked on Order import 850 and SOA 855 EDI import process.

Developing and testing PPM Project Costing and Project billing BI and OTBI reports.

Defaulting rules in OM and PO modules.

Worked on BOM and extracts and exporting to salesforces and webforms.

Developed on asset and department wit resource creation process in WIP.

Developed new interface/conversions on AP, AR and GL import process.

Working on OM to GTM integration with customer and item trade management issues.

The project involved design and development of reports and integrations across HCM, AP, PO, OM and INV, BOM which includes work with users, document reporting requirements, evaluate reporting tool across Cloud HCM extracts and HCM Role restrictions.

Worked on manufacturing team to enable items tracking details and intended BOM information.

Worked on EAM maintenance plan.

Creating EAS actions plans.

Created EAS actions and linked to the asset.

Developing PPM Performance Measures and performance indicators report setup.

Worked on project expense costs, inventory, labor supplier cost FBDI import process.

Working on OIC integration for BIP, OTBI, BICC, FR Studio, develop reports extracts to EDW applications.

Supporting and resolving user raised incidents in Cherwell ticket tracing tool.

Developing BIP reports with multi tables and CSV formatted templates.

Support and developing new OIC integrations for HCM BICC extract reports.

Worked on development of Oracle Cloud reports, security and integrations using OIC, OTBI, BIP and FBDI, HDL, HCM/Payroll Extracts

Explored ICS/OIC adapters and developed salesforce and Oracle cloud integrations

Client: GWU, Dallas, TX Date: APR 22 – SEP 22

Role: Oracle ERP Techno-Functional Consultant

Responsibilities:

Developed brand new custom BIP reports across AP, AR, GL as per the user requirements.

Worked on Alerts modification and develop new alerts.

Worked R12 form to enable new lov’s in standard columns and zoom form customizations.

Developing MV(materialized view) in R12.2 Gold version.

Developing and testing PPM Project Costing and Project billing BI and OTBI reports.

Modified and updating oracle forms to R12.2 upgrades.

Working Oracle GTM and Oracle Cloud SCM sample integration recipe is available through Oracle Integration. The baseline integration enables party, item and trade compliance screening in Global Trade Management of orders from Order Management.

Developed new interface/conversions on AP, AR and GL import process.

Worked on new AP, GL steups.

Supporting and resolving user raised incidents in Cherwell ticket tracing tool.

Developing BIP reports with multi tables and CSV formatted templates.

Client: Trinamix, Dallas, TX Date: NOV 21 – APR 22

Role: Oracle Cloud ERP Techno-Functional Consultant

Responsibilities:

The project involved in design and development of reports and integrations across OM, INV, PO, AP, AR and Shipment which includes work with users, document reporting requirements, evaluate reporting tool across Cloud BIP, OTBI, BICC, FR Studio, develop reports, prepare user test cases and test with users.

Worked on Oracle GTM utilizes Oracle Analytics Publisher to create reports and documents allowing customers to create their own documents or reports with the solution.

Worked on INV with Sensiwatch track to serial and lot control items.

Developing new query in the management studio tool.

Working SSMS tool to build scripts to fulfill user requirements.

Worked on SSMS tool to generate and extract user requested information in files.

Worked on interfaces and conversions in SSMS tools.

Developed UTL files to extract reports in SSMS

Design and Developed Daily sales order shipment, serial, and lot control BIP reports.

Developing Inventory transfer, PO, Receipt transfer, Org and organization details extracts from BICC extract and OCI integrating to downstream applications.

Worked on Oracle cloud and EDW integration and developed end to end integration to create customers in Oracle cloud OM and INV using OCI/ Oracle Cloud AR rest api’s

Created new functional and technical design documents for new customizations on RICEW components.

Implemented Mass Allocation in Oracle General ledger.

Design and Developed Inventory Monthly Transaction report and Inventory Monthly Balances report MD050, MD070 using BI Publisher.

Client: ClubCorp, Dallas, TX Date: JAN 20 – NOV 21

Role: Oracle Cloud ERP Techno-Functional Consultant

Responsibilities:

The project involved in design and development of reports and integrations across GL, AP, AR, FA, CE and PPM, which includes work with users, document reporting requirements, evaluate reporting tool across OTBI, BIP, FR Studio, develop reports, prepare user test cases and test with users

Worked with users on reporting security and understand and custom roles as needed and customize the roles

Developed brand new custom BIP reports across AP, AR, PO, CE as per the user requirements

Part of implementation of ERP analytical processing using BICC/OAC and external EDW databases using Oracle BI cloud Connecter (BICC) and configured external storage using BICC console

Worked on ERP to EPM (PBCS) data flow and developed BIP extracts for external reporting and provided a data feed of GL Journal sub ledger activity s for internal audit process

Created a custom role as per the enterprise security including BI reporting security and external user security

Worked on Oracle cloud and Salesforce integration and developed end to end integration to create customers in Oracle cloud AR TCA using OCI/ Oracle Cloud AR rest api’s

Customized AP check printing using XML/BI publisher and created a custom template for check printing

Developed AR aging buck reports in Oracle Fusion finance and sending files to AWS server.

Worked on fusion AR transaction creations and posting GL process.

Design and Developed Supplier Remittance Email for all Electronic payments in Payable module.

Created new functional and technical design documents for new customizations on RICEW components.

Implemented Mass Allocation in Oracle General ledger.

Design and Developed Supplier Due report which pulls data from PO, AP and GL.

Performed code review and maintain migration issues with multiple instances for the RICEW components developed by PWC team or other vendors.

Client: Poly, San Jose CA. Date: SEP 18 – JAN 2020

Role: Oracle Cloud SCM Techno-Functional Consultant

Responsibilities:

The project involved in migration to Oracle cloud ERP (OM, Shipping, BOM, WIP, PO, AR, Inventory) and (GL, AP, AR, FA, CE PPM) from on-premises legacy ERP and I am responsible for data conversion, which includes understand legacy data, extract data, transform into HDL files, FBDI files and load data to Oracle cloud HCM and Financials modules

Worked with Oracle support to resolve cloud security challenges and created a custom role including job, data roles and user profiles.

Asset Strategy Builder in Import from EAM.

EAS Asset information with EAM action detail report generated.

Worked with HCM and Payroll users and developed reports and integrations using HCM Extracts, HDL Data loading, fast formulas and OCI Oracle HCM Web Services

Part of Oracle Cloud SaaS BI reporting team and explored Oracle BICC Business Intelligence Cloud Connector, OAC and ETL process to load data into external EDW environments

Worked with different OLTP teams and implemented BICC ETL pipeline and extracts to EDW

Extensively worked on user administration and Oracle cloud ERP user security and customized Oracle cloud security by creating custom roles across enterprise

Worked with Kronos team and developed a new hire and time card integration to load data between Kronos and Oracle cloud HCM

Analyzed and fixed Oracle cloud BI performance issues across HCM reports, extracts and worked with Oracle support to resolve some of the complex performance issues

Used OIC as middleware integration tool and developed Oracle cloud instigations including FTP, data transformation XML/XSLT, EDI data transformation

Worked with Oracle HCM Payroll users and developed quick payroll reports to reconcile Kronos time entry and Payroll run results

Client: Veritas, Dallas, TX Date: Aug 15 – SEP 18

Role: Oracle Cloud Techno-Functional Consultant

Responsibilities:

The project involved in production support of Oracle EBS Financials/ SCM (OM, Shipping, PO, AR, Inventory) and migration to Oracle cloud HCM and Financials modules

Worked on development of Oracle Cloud reports, security and integrations using OIC, OTBI, BIP and FBDI, HDL, HCM/Payroll Extracts

Explored ICS/OIC adapters and developed salesforce and Oracle cloud integrations

Design and Developed Invoice Profarma Report and Sale Track Report MD050, MD070 using BI Publisher.

Developed TCA Customer data interface between 3rd party systems to Oracle Applications.

Worked on interface issues between 3rd party system integration and Oracle Application with SOA and TIBCO.

Designed and documented solution, configurations required for implementing Oracle Advanced Collections across all operating units.

Developed custom PLSQL package to update score for the existing customers.

Developed XML Publisher reports to generate Customer Invoice details.

Co-ordinated with customer to plan SIT, UAT test phases. Identified and assigned business users responsible for specific process during test cycles.

Ensured schedule processes such as automated data cleaning routines are running.

Design and Developed Custom Auto invoice interface program to create invoice in Receivables.

Worked on Functional document for Receipt’s interface in Oracle receivables.

Design and Developed Custom Netting program for all the Dealers sales in Oracle Apps.

Worked on custom Workflow and Rules for approving the Loan from Agencies based on custom Rules and Agency Credit Files.

Working on production support for recently implemented Oracle applications in scientific games.

Design and Developed Inventory Monthly Transaction report and Inventory Monthly Balances report MD050, MD070 using BI Publisher.

Customized the existing oracle customer page by extension of View object, Application Module and Controller using OAF.

Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions in OBIEE.

Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Design and developed remittance invoice email program to suppliers using XML Bursting in oracle payables using BI Publisher.

Involved in the Implementation of Projects in Oracle Projects and Developed some interfaces and report in Projects.

Worked on Custom interfaces for Customer, Suppliers and Inventory Items for Scientific Games integration with WMS Application.

Wrote test flows, test cases for business flows and testing the functionality.

Designed document for Source Documents Creation, Sourcing Rules creation and supplier base setups in Procurement. Provided training for business user to use that and coordinated with planning team about the changes.

Client: Seagate, Chennai India. Date: JUN 14 – AUG 15

Role: Oracle EBS Technical Consultant

Work: Worked on production support and development role on Supply chain, Financials and Manufacturing.

Responsibilities:

Responsible for designing, developing, unit testing, implementing and maintaining custom extensions for Oracle EBS Applications R12/11i versions.

Experience in PLSQL Interfaces, PLSQL APIs, Conversions, Customization and Development of Forms, Workflows and Reports.

Worked on Auto lock box implementation and also troubleshoot when we had issues in receivables.

Worked on custom interface which will import the pay items for the order in Service to Procurement.

Worked on RPD incremental merging to support ongoing development with prod RPD repository changes in OBIEE.

Customer UTL extract file process schedule in SSMS tool.

Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports in OBIEE.

Came up with a code to look for invalid item and replace them with ‘EDIINVALID’ and send this back to customers in EDI 855 with ACK Code as ‘IR’.

Worked on custom interface for project transactions in Service to Procurement implementation.

Design customized the GL period end Reconciliation report to show the account alias name to add to the report and parameter for business use in General Ledger.

Worked on GL entries import using WEBADI in General Ledger.

Worked customization and personalization of Webstore interface in iProcurement. Customized PO Workflow to send email or fax through Right Fax (3rd party) and with customized templates for each Operating Unit in iProcurement.

Troubleshoot the inventory transaction costing issues in Day to day.

Customized the PO output communication report using XML Publisher.

Customized PO Workflow to send email or fax through Right Fax (3rd party) and with customized templates for each Operating Unit.

Worked on Service Contract creation program from all Motor orders which have agreement with vendors in CRM.

Worked on Receivables Receipts API interface in Receivables.

Worked on implementation of R12 iProcurement in Oracle Applications.

Design the Item Interface and Item Category interface in Inventory.

Worked on Invoice and Sales order conversion in Recivables.

Design and Developed Item cost conversion in Cost management.

Worked on Finance Reconciliation reports and SLA customization to charge inventory cost based on primary plant.

Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard in OBIEE.

Worked on Item, BOM, Routing, Cost conversions Audit files and process.

Designed custom form for Partial Book out the WIP jobs according to business rules.

Developed Multi Org item where used report, Common Implosion, Common Explosion, Product Structure reports in BOM and Engineering modules.

Worked on Advanced Pricing RICEW objects like Price List conversion program, Mass Price Update from, Custom PLSQL procedure to return Prices for products, Custom Price Book reports based on Client Requirements in Advanced Pricing.

Prepared BR100 configuration documents and requirement traceability matrix.

Prepared MD 50 & MD 70 document for various functional and technical customizations by looking into the specified requirement document keeping in mind the impact analysis.

Design and developed custom Labels for Book out, inter org transfer and some custom process with different design for different plant in Oracle Manufacturing.

Environment: Oracle EBS Applications R12/11i (11.5.10), Advance pricing, Supply Chain (SCM), EDI, WEBADI, OM, INV, PO, AR, AP, WIP, TCA Architecture, Pricing, iSupplier, iProcurement, Service procurement, Service Contracts, Vertex Tax, Discoverer 10g, XML/BI Publisher, PL/SQL, GL, Reports 6i, Toad, Windows XP, AIM, Oracle 10g, OBIEE.

Client: FLSmidth, Chennai India. Date: NOV 09 – JUN 14

Role: Oracle ERP Technical Consultant SCM (OM, Shipping, PO, AR, Inventory)

Work: Worked on production support and development role on Supply chain, Financials and Manufacturing, HRMS.

Responsibilities:

Responsible for designing, developing, unit testing, implementing and maintaining custom extensions for Oracle Applications R12/11i versions.

Worked on HRMS annual performance XML bursting reports.

Worked extensively in Month End and Year End closing issues in General Ledger (GL).

Involved in conversion programs to load all the customer historic data, which includes creation of person/organization, profiles, business/home addresses, relationships, contacts (email, phone, fax) using TCA APIs.

Design and developed Item Interface and Item Category interface in Inventory modules.

Worked on Inventory material transaction interface from 3rd party to Oracle in Inventory.

Customized in Bill of Lading report based on the business requirement for BOM.

Worked on Discrete Job import interface from 3rd party database in WIP.

Developed Component Report, SLEP Report, Material Location Report in WIP Oracle Applications.

Customized the PO output communication report using XML Publisher.

Qualifiers, Modifiers, Price lists etc. for Order Management, pricing and Shipping.

Design the Item Interface and Item Category interface in Inventory.

Involved in developing a custom package for importing Orders from web-based system COPS through Order Import Open Interfaces PLSQL API in Order Management.

Developed Interface program for loading New Employees, Employee Addresses and Updating Existing Employees, Assignments from legacy system into Oracle using HRMS API’s.

Customized some of the Reports like ACH Payments, Positive Pay (NACHA format), Check Format, and Bank Statement in AP, Customer Statement, Invoice Printing and Order/Invoice Detail in OM & RMA Using XML/BI Publisher.

Worked on Pricing API’s to get and update the price in oracle Apps.

Customized the Standard Workflow Items and process such as Order Header, Order Line and Change Order.

Designed on WEBADI for upload GL Journals in oracle Apps through WEBADI.

Worked on some of the Discoverer Reports ASCP, Inventory, order management and WIP modules.

Prepared Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Open Requisitions, Open Purchase Orders, Suppliers, Supplier Sites, and Customers using TCA.

Worked on Creating and Applying Holds on Sales Order during Order Import and Pick Release.

Design and developed the invoice EDI inbound and Out bound interface using EDI Gateway in Payables.

Developed Custom Packages which in turn were used for reporting purposes. .

Customized Invoices Pick and Pack slips to list back ordered items in OM and BOM module.

Development of Discoverer 10g Reports includes creating complex views, folders, joins and item classes.

Implemented form personalization in some forms based on client requirement.

Developed EULs, Business Areas, Custom folders and Ad-hoc reports as per the requirement in Discoverer.

Design and Developed EDI payable invoice interface program.

As a Discoverer Administrator created Business Areas, Folders, and Setup joins between folders, Registered PL/SQL functions, created Item Classes, created date hierarchies and item hierarchies etc.

Provided Periodic backups of EUL and involved in export, import of End User Layers from one instance to another.

Involved in developing Interface programs for Move Order Inbound & Outbound interfaces using MOVE Order PLSQL API between Oracle Apps and a legacy system BOSS for Replenishment Orders.

Worked on Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.

Worked on various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution and related reports, forms, and design document to implement Custom Workflow.

Designed and Developed packages for Journal Import Interface to import journals information into the system.

Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.

Developed Order/Invoice Detail Report, Sales Tracking Report, Back Order Detail Report in Order Management using BI Publisher.

Built custom reports using Report 6i to solve the client’s reporting needs.

Prepared MD070 Technical Design Documents for critical objects using the AIM Methodology.

Used AOL and System Administrator modules for registering the developed and customized reports and conversion programs

Environment: Oracle EBS Apps R12,11i, Supply Chain (SCM), OM, Advanced Pricing, EDI, Warehouse Management, INV, PO, AR, AP, TCA Architecture, Discoverer 10g, XML/BI Publisher, Vertex Tax, PL/SQL, GL, Reports 6i, Toad, Windows XP, AIM, Oracle 10g.

Contact this candidate