Oracle Project
Resume:
Rajesh Oracle Applications EBS Techno-Functional
******.**************@*****.***
Linkedin : linkedin.com/in/rajesh-mamidipelly-6a0527112
Professional Summary:
• Having 11+ years of extensive experience as Oracle Application Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Oracle Install base (IB), General Ledger (GL),Sub Ledger Accounting (SLA), Accounts Receivable (AR), Accounts Payables (AP), Fixed Assets (FA), Project Accounting (PA), Purchasing (PO), (CM) Cash Management, MFG(Manufacturing), HRMS.
• Experience in Order to cash (OTC), Procure to Pay (P2P) life cycles and Supply Chain business flows.
• Involved in development of RICE components using SQL, PL/SQL Developer 2000, XML Publisher as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Hands-on Functional and Technical Experience in Oracle Applications with primary focus on Oracle Fusion.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader and UTL.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL), Implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Worked on MDM and TCA implementation Project for loading the customer and supplier in Oracle from legacy system.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Performed User and Administration responsibilities in Discoverer.
• Worked on Discoverer reports.
• Experienced in Forms Personalization
• Experienced in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, Web ADI, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Discoverer and modified the formats using XML publisher for customizations as per client specification.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
• Interacted with users, fixed the bugs, developed test plans and provides daily production support.
• Adroit in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS.
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.
• Experience in all phases of the system development life cycle.
• Worked on Month end Closure activities for order management and Inventory.
• Experienced in advance PL/SQL, IN-BOUND, OUT-BOUD Interface and Conversions.
• Worked on migration of objects like concurrent programs, value sets through find load.
• Worked on Integration Projects by Using SOA with Oracle Application
Employment Summary:
Worked in Nokia Siemens Networks, Atlanta, GA (July-2008 to Dec-2011).
Worked in GE (GENERAL Electric), Hyderabad (Dec-2011 to Dec-2014).
Worked with Google, Sunnyvale, CA (Jan-2015 to Apr 2017).
Worked with DJO Global, Vista, CA (Apr 2017 to Feb 2018).
Worked with Best Buy, Minneapolis, MN (Apr 2018 to Feb 2019).
Worked with Envision, FortLauderdale, FL (Feb 2019 to July 2019).
Worked with Reachlocal, Woodland hills, CA (Aug 2019 to Mar 2020).
Education: B-tech JNTU 2008
Software Proficiency:
Environment
(with skill versions)
Languages:
Sql/Plsql, C, C++, Unix, java
Software’s:
Oracle applications 11.5.10.2,12.1.3,12.2.5
Database :
Oracle 8i, 9i,10g
Tools :
,Workflow builder, SQL*Loader, XML Publisher Reports, BI publisher, Reports6i and 9i, Forms, jDeveloper, Toad, Winsp3, Putty, SQL Developer, SQL * plus, Ubiquity, Kintana, HPPM, HPQC, WebADI, EDI,AME, SOA
Modules:
PO, OM, AP, GL, AR, IEXP, IB, INV, WIP, BOM, HRMS, i-supplier, i-Procurement, CRM
O/S :
Windows NT, Windows 2000, Unix.
Custom Third party Tools
Concur, GCard, PIVT, GHR, Workday, Salesforce, Service Max, WebMethods, Service now, Treasury, Markview, OIC, Dayforce
PROJECT DETAILS:
Project #1:
Project Name:
Oracle EBS R12.1.3 Implementation and Enhancement
Client
Reachlocal
Role
Oracle EBS Techno Functional Consultant
Duration
Aug-2019 to Mar 2020
Location
Los Angeles (CA)
Responsibilities:
Designed and Developed the Xactly commissions interface to Oracle Cloud.
Developed a shell script host program using rsync to transfer the outbound file from oracle to windows.
Developed the host program to fetch the files from third party servers like American express, dayforce.
Developed the Oracle programs which sends ad hoc emails.
Developed the Web Adi interface programs to create AP and AR Invoices.
Worked on the enhancement of various commission plan.
Designed and developed various commission plans for sales reps in Oracle.
Developed GL interface programs for commission adjustments.
Assisted and helped business in the month end issues.
Worked on the HRMS interface programs.
Worked on issues related to Workflows.
Worked on the performance tuning of concurrent programs.
Designed new requests sets as a part of decommissioning.
Developed the XML publisher reports to capture the employees job changes and timecard.
Project #2:
Project Name:
Oracle EBS R12.1.3 Implementation and Enhancement
Client
Envison Health care
Role
Oracle EBS Techno Functional Consultant
Duration
Feb-2019 to July 2019
Location
Fort Lauderdale (FL)
Responsibilities:
Designed and Developed the Employees interface to Kronos for Payroll processing and deductions..
Developed the outbound interface for Dot net Active Directory logins.
Developed a concurrent program to fetch the junk characters in the employee records.
Converted the EIS reports to Concurrent program reports.
Worked on code migration using Manifestation files.
Developed custom packages for Webservices, Dot net and other applications.
Worked on code migration to various instances using rod, batch files.
Worked on EIS Reporting.
Developed the various custom interface from third party systems like Fidelity to Oracle and Oracle to third party systems.
Project #3:
Project Name:
Oracle EBS R12.2.6 HR and Payroll implementation
Client
Best Buy
Role
Oracle EBS Techno Functional Consultant
Duration
Mar-2018 to Feb-2019
Location
Minneapolis (MN)
Responsibilities:
Designed and Developed the Element entry creation and deletion program through API’s.
Developed the EIS reports related to HR and Payroll.
Worked on Element entries and Fast Formulas.
Worked on Salary and Benefits.
Worked on code migration using Manifestation files.
Worked on code migration to various instances using rod, batch files.
Worked on Mastro jobs.
Worked on EIS Reporting.
Worked on the development and customization of leave application workflows.
Developed the various custom interface from third party systems like Fidelity to Oracle and Oracle to third party systems.
Project #4:
Project Name:
Oracle EBS R12.0.6 to Data Works Integration
Client
DJO Global LLC
Role
Oracle EBS Techno Functional Lead
Duration
Oct-2017 to Feb 2018
Location
San Diego (CA)
Project Description:
DJO Global, Inc. is a leading global provider of high-quality, orthopedic devices, with a broad range of products used for rehabilitation, pain management and physical therapy. They also develop, manufacture and distribute a broad range of surgical reconstructive implant products. They are the largest non-surgical orthopedic rehabilitation device company in the United States and among the largest globally, as measured by revenues. Many of their products have leading market positions. They believe that our strong brand names, comprehensive range of products, focus on quality, innovation and customer service, extensive distribution network, and our strong relationships with orthopedic and physical therapy professionals have contributed to our leading market positions. They believe that we are one of only a few orthopedic device companies that offer healthcare professionals and patients a diverse range of orthopedic rehabilitation products addressing the complete spectrum of preventative, pre-operative, post-operative, clinical and home rehabilitation care.Their products are used by orthopedic specialists, spine surgeons, primary care physicians, pain management specialists, physical therapists, podiatrists, chiropractors, athletic trainers and other healthcare professionals to treat patients with musculoskeletal conditions resulting from degenerative diseases, deformities, traumatic events and sports-related injuries. In addition, many of our non-surgical medical devices and related accessories are used by athletes and patients for injury prevention and at-home physical therapy treatment. Some of our trademarks, service marks and brand names include: Encore, Cefar®, Empi®, Ormed®, Chattanooga, Compex®, Aircast®, DonJoy®, OfficeCare®, ProCare®, SpinaLogic®, CMF, OL1000and OL1000 SC.
Responsibilities:
Designed and developed Oracle AP interface from iFlow to Oracle EBS.
Implemented the full life cycle of P2P.
Developed the host (Unix) programs to pull or push the files from third party server.
Developed the Outbound interface program to send the PO and Invoice details to iFlow server.
Developed the PO matching API’s.
Worked on production release cutover plans and activities.
Worked Oracle EBS and SOA integration.
Created the suppliers using API’s.
Designed the Concurrent programs and SQL Loaders which can be submitted from Unix.
Developed the Concurrent program which adjusts the cash in GL.
Designed the xml publisher reports based on customer requirement.
Project #5:
Project Name:
Oracle EBS R12.0.6 to iFlow integration
Client
DJO Global LLC
Role
Oracle EBS Techno Functional Lead
Duration
Apr-2017 to Oct-2017
Location
San Diego (CA)
Responsibilities:
Designed and developed Sales Order interface program from Data Works to Oracle EBS.
Worked on salesforce to Dell Boomi integration
Implemented the full life cycle of OTC by creating a custom request set.
Developed the host (Unix) programs to pull or push the files from third party server.
Developed the Outbound interface program to place the Inventory and accounting extract file in the third party server.
Involved in configuring the setups related to Benefits, Direct deposit, check printing, Payroll run process.
Developed the custom reports related to the elements and other employee compensation details.
Developed and Interface for payroll to Oracle AP invoice.
Worked on customization of workflows.
Developed Office care, Med manager and Billing interface programs.
Developed the AR invoice interface program using the API’s.
Designed the Sales Order Replenishment process to replace the item which is consumed at the customers end.
Designed the Concurrent programs which can be submitted from Unix.
Developed the Concurrent program which adjusts the cash in GL.
Designed the xml publisher reports based on customer requirement.
Project #6:
Project Name:
Procure to Pay (P2P) Google upgradation R12.2.5
Client
Role
Techno Functional Consultant
Duration
Jan-2015 to Apr-2017
Location
Sunnyvale (CA)
Project Description:
Google is an American multinational corporation specializing in Internet-related services and products. These include online advertising technologies, search, cloud computing, and software. Most of its profits are derived from AdWords,an online advertising service that places advertising near the list of search results.
Responsibilities:
Resolved the Bugs related to payment solutions.
Worked Workday to Oracle HRMS Integration.
Worked on Kofax, Markview to Oracle AP integration.
Helped the client in fulfilling the P2P cycle to achieve their business requirements.
Developed the XML methods of payment files for different payments like Domestic and Cross border payments.
Developed the custom oracle program to send the dunning emails to employees who are due to submit their expenses.
Worked on the EDI.
Worked on production release cutover plans and activities.
Modified the shell script host programs meant to receive and send the file from Oracle to various third party tools.
Created the new custom Host to host method of payments for different countries.
Modified the existing payment file generator according to the payments for different countries.
Coordinated with various banks like Citi and WellsFargo to get the payments transfer files according to the Bank formats.
Resolve the Bugs according to the client requirement.
Bugs involve complex code changes in both custom and standard interfaces using API’s.
Worked on the Oracle Concur Standard Accounting Extract (SAE) to oracle AP and GL interface.
Worked on HRMS Payroll.
Worked on third party tools to Oracle integration.
Third party tools include Concur, Gcard, PIVT, Custom payment generator.
Worked on adhoc requirements of the clients in RICE components
Analysis of the existing custom process.
Prepare SDLC and Impact analysis.
Project #7:
Project Name:
Implementation of Oracle Field Services, Service contracts to Install Base and SSP5 R12.1.3 Upgradation
Client
GE (General Electric)
Role
Oracle EBS Techno Functional Consultant
Duration
May-2013 to Dec 2014
Location
Houston (TX)
Project Description:
GE Power and Water, a unit of GE (NYSE: GE), solves the world’s toughest challenges. GE Energy builds equipment that moves the renewable energies and Turbines. GE’s fuel-efficient and lower-emissions help customers grow. GE Energy is headquartered in schenectady employs approximately 12,000 employees worldwide.
Responsibilities:
Developed the Field Services CRM to Install Base Interface.
Designed a custom WebADI tool.
Developed the WEB-ADI Solution for updating Install base DFF and Extended Attributes using the standard API’s.
Designed and developed the CRM to Install base Item hierarchy creation.
Worked on the service contract reports and Interface.
Developed the WEB-ADI Solution for building the relationship with the part out using the standard API’s.
Developed the PO, Receipt, PA, COA Inbound and outbound Interfaces.
Customized the existing Inbound and Outbound Interface after changing the feed from ctl file to Web methods and SFTP’s.
Worked as Onsite coordinator for the customer.
Worked on Requirement gathering for different Business Processes for Configure to Order cycle and Order to cash Cycle of Oracle .
Utilize in-depth knowledge of functional and Technical experience in Oracle ERP and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
Designed a custom WebADI tool
Worked on the Unix shell scripts
Reports:
Developed the IB Turbine configuration hierarchy report.
Project #8:
Project Name:
Implementation of Oracle Financial and Custom Module integrating i-expenses
Client
SREI implementation
Role
Oracle EBS Techno Functional Consultant
Duration
Aug-2012 to Mar-2013
Location
Hyderabad (IN)
Project Description:
Srei Infrastructure Finance Limited has been a pioneer in infrastructure financing in India, steadily contributing towards infrastructural development, and a better tomorrow.It is synonymous with innovative infrastructure financing from customized solutions to marketing programms.
In over 23 years of operation, srei has empowered more than 30,000 entrepreneurs through our bouquet of services in the infrastructure sector: Infrastructure Project Finance, Advisory and Development, Infrastructure Equipment Finance, Venture Capital, Capital Market and Insurance Broking.
Srei has led from the forefront in almost all stages of the infrastructure value chain. It is the first Indian infrastructure NBFC to be listed on the London Stock Exchange; and the first company to lay the ground for passive telecom infrastructure in India.
Responsibilities:
Developed new reports as per the client requirement.
Customized the existing reports.
Defining executables as well as concurrent programs and parameters.
Developed procedures, Functions and Packages.
Worked on Oracle HRMS to fetch employees hierarchy for sending the notifications.
PL/SQL Method of submitting Concurrent Programs like interfaces and reports.
Development of Interface Programs to import the data from Legacy system to Oracle Apps Base tables by using SQL*LOADER.
Development of Interface Programs to export the data from Oracle Apps Base tables to text file.
Involved in the implementation of custom module.
Worked with Functional Team in translating business requirements into Technical Requirements Document and to Detailed Design Documents.
Worked on the custom travel module and developed OAF pages and workflow.
Reports:
Developed the Iexpenses to Invoice REPORTS.
Developed the Travel(custom module) reports.
Invoice interface report.
Interfaces:
Developed the Travel request to AP invoice interface.
Developed the Travel request to AP invoice prepayment interface.
Project #9:
Project Name:
Implementation of Oracle SCM modules
Client
GE Transportation
Role
Oracle EBS Techno Functional Consultant
Duration
Feb-2012 to June-2012
Location
Hyderabad (IN)
Project Description:
GE Transportation, a unit of GE (NYSE: GE), solves the world’s toughest transportation challenges. GE Transportation builds equipment that moves the rail, mining and marine industries. GE’s fuel-efficient and lower-emissions freight and passenger locomotives, diesel engines for rail, marine and stationary power applications, signaling and software solutions, drive systems for mining trucks, and value-added services help customers grow. GE Transportation is headquartered in Erie, Penn., and employs approximately 12,000 employees worldwide.
Responsibilities:
Customized existing reports as per the client requirement.
Developed new reports using pl/sql.
Defining executables as well as concurrent programs and parameters.
Developed procedures, Functions and Packages.
PL/SQL Method of submitting Concurrent Programs like interfaces and reports.
Development of Interface Programs to import the data from Legacy system to Oracle Apps Base tables by using SQL*LOADER.
Development of Interface Programs to export the data from Oracle Apps Base tables to text file.
This Project is of Enhancement and support Project for Different Division of Emerson .
Global Enhancement Project include New Development of Reports, XML publisher Report and Interfaces i.e. All RICE components and Also Enhancement based on Bossiness Requirement.
Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
Actively involved in performance tuning task force team, fine tuning all the affected processes (Reports, Concurrent Programs, and Nightly Jobs etc.) which would have High I/O Cluster waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc.) and modified (or redesigned) the existing programs to drastically increase the performance.
Developing procedures packages, for inbound and outbound interface.
Worked On Inbound Interface for Invoice creation through Custom process .
Worked on OM, AR, PA, INV, AP, PO, GL Modules.
Developed and customized XML publisher reports for different Oracle Modules .
Converted RDF reports to XML publisher report for different Oracle Modules.
Worked on Form Personalization for OM module for Sales order Form.
Worded on Order import interface to enhance the functionality as per the business Requirement.
Used kintana package to migrate the code from once instance to higher instance.
Worked on TCA architecture for loading the customer and supplier data in Oracle from legacy system.
Used fnd load to download and upload the code to higher instance in oracle.
Honoured and Nominated as Employee of the Month for a 2 times for exceptional performance, commendable work quality and customer service attitude.
Environment: Oracle Applications (11i, R12), Oracle10g, Oracle Forms, INV, PO, OM, PA, PO, AP, AR, GL and Reports 6i.
Reports:
Developed the Bills of lading REPORT.
Cost comparison report by operation.
Invoice ageing report.
Interfaces:
Developed the in transit inventory outbound interface to export the data from oracle applications base tables to text file.
Developed the service max to Oracle interface.
Project #10:
Project Name:
Oracle E-Business Suite Implementation
Client
Nokia Siemens Networks
Role
Oracle EBS Techno Functional Consultant
Duration
Jun-2008 to Nov-2011
Location
Hyderabad (IN)
Project Description:
Vodafone is one of the world's largest mobile communications companies by revenue with approximately 358 million customers having equity interests in over 30 countries across five continents and more than 40 partner networks worldwide. Vodafone Essar was awarded ‘Most Respected Company’ in the Telecom Sector for 2010 and the ‘Most Trusted Service Brand’ in India for 2010, by a leading financial daily.
Roles and Responsibilities:
Implemented Oracle Applications and involved in Developing new reports and interfaces, Forms (personalization).
Worked on P2P and OTC cycle implementation.
Involved in to customization of forms (personalization).
Enabled DFF in standard forms.
Creation of value sets, request sets, request groups in various modules.
Developing procedures, Functions and Packages.
Defining executables as well as concurrent programs and parameters.
PL/SQL Method of submitting Concurrent Programs.
Development of Interface Programs to import the data from Legacy system to Oracle Apps Base tables by using SQL*LOADER.
Extracting the LDT files from the development instance.
Worked On Inbound Interface for Receiving transaction processor for Receipts in PO through Custom process .
Worked on AR Auto invoice and Lockbox.
Developed and customized XML publisher reports.
Converted RDF reports to XML publisher report for Shipping Document sets.
Interfaces: Receiving Transaction Processor, Order Import inbound interface.
Includes Testing of the product with various ways and note the errors According to standards given charts of testing on Test Instance.
Received Appreciation mail from client for exceptional performance .
Use of Daily Business Intelligence tool in Oracle and design of reports.
Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements.
Performance tuning, SQL query enhancements, code enhancements to achieve performance targets
Environment: Oracle Applications ERP (Rel 11), Oracle 9i, Purchasing, Vendor Management System.
Reports:
Developed PO summary report using XML publisher.
Developed OM open sales order detail report using XML publisher.
Developed AP invoice payable report.
Interfaces:
Developed the purchase order interface to import the order details data from legacy system to oracle applications base tables.
Developed the General ledger interface to import the GL details data from legacy system to oracle applications base tables.
Contact this candidate