Home

Mohan Rao - Oracle Apps Technical Consultant

[email protected]

Location: Remote, Remote, USA

Relocation: Open

Visa: H1B

Mohan Rao Oracle Apps Technical Consultant +1-513-764-7897 [email protected] H1B Executive Summary Over 11+ years of extensive experience as Oracle Application (EBS) Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (EBS) R12. This includes system study, design, development, post implementation maintenance and support of Oracle EBS. Functional and Technical Knowledge Extensive experience in implementation, Migration, Customization, Production, and support of various modules in Oracle Applications with major focus on Oracle Process Manufacturing (OPM), Inventory (INV), Order Management (OM), Purchasing (PO), Discrete Manufacturing (BOM, WIP), OLFM and WMS (Warehouse Management System). Worked on SCM Modules (PO, OM, INV) and OPM (Oracle Process Manufacturing) and eAM (Enterprise Asset Management) and Financial Modules (AP, AR, GL), WIP and BOM and Contracts. Extensive technical experience in RICE (Reports, Interfaces, Conversions, Extensions) Components Expertise in SQL, PL/SQL and D2K Reports and XML Publisher Reports. Strong in writing complex SQL queries. Strong in writing PL/SQL packages, functions and procedures and triggers. Having good experience on P2P and O2C cycles Involved in AOL (System Administrator and Application Developer) activities like creation of Concurrent Programs, Request Sets, Value Sets, Lookups, Descriptive Flex Fields, Forms, Functions, Menus, Responsibilities and Users. Having good experience in creation of Periodic and Event Alerts. Having good experience in D2K Forms and Reports. Having good experience in developing BI/OTBI reports Having good experience on new form Developments and New form Customizations and Form Personalization Having knowledge on Workflow Builder Having knowledge on OAF Personalization s Having good experience of Interfaces and Conversions. Proficient in working with Standard API s. Having good experience on SQL*Loader, UTL_FILE Package. Proficient in writing FNDLOAD scripts during migration of objects from one instance to another instance. Hands on experience working with FTP tools like WINSCP and Putty. Expertise in preparing Technical Documents Having good experience in Implementation and Supporting Projects Having good experience in Up gradation and Rollout Project Having good experience in Support Projects. Responsible for understanding the Functional Specifications and preparing the Technical Specification Documents like MD070, MD120, TE20, CWT and UD. Interacted with users, fixed the bugs, developed test plans, and provided daily production support. Worked on Shell Scripting using UNIX during migration of objects. Capable of working independently as well as a part of a team Good Analytical and Strong interpersonal and excellent communication skills Job Title History o Working with Mak Technologies LLC, Cincinnati, Ohio from March-2023 to Till Date. o Working with Nityo Infotech, from Oct-2021 to March-2023. o Worked with TeamLease Digital, Bangalore from Aug-2020 to Sep-2021. o Worked with Indepens Software Technologies Pvt Ltd, Hyderabad from Mar-2018 to Aug-2020. o Worked with NTTDATA, Bangalore from Sep- 2013 to Feb 2018. o Worked with Synova Innovative Technologies Pvt. Ltd, Bangalore from July-2012 to Sep-2013. Educational Summary o M.C.A from SA Engineering College, ANNA University. Technical Skills: ERP Applications : Oracle EBS R12 and Oracle Integration Cloud (OIC), BI/OTBI Modules : Financials (GL, AP, AR), SCM Modules (INV, PO, OM), Discrete Manufacturing (WIP, BOM), WMS, OPM, eAM, Azure. Methodology : Application Implementation Methodology (AIM). Languages : SQL, PL/SQL, UNIX, Core Java Tools : SQL Developer, TOAD Databases : Oracle 10g Reporting Tools : Reports 10g, XML Publisher, BI/OTBI Utilities : Putty, WinSCP Work Experience: Project #7 Project : Integra Lifesciences Client : Integra Organization : Mak Technologies LLC Duration : March 2023 to Till Date Role : Oracle Apps Lead Technical Consultant Environment : Oracle EBS Implementation R12.2.10 Description: Integra LifeSciences is a global medical device manufacturing company headquartered in Princeton, New Jersey. Founded in 1989, the company manufactures products for skin regeneration, neurosurgery, reconstructive and general surgery. Integra artificial skin became the first commercially reproducible skin tissue used to treat severe burns and other skin wounds. Responsibilities: Designed & Developed PL/SQL Validation procedures. Worked on outbound and Inbound data interface with data encryption and decryption. Worked on technical components in WIP and OM module. Developed a few reports like Discrete Job Routing Sheet Report and Work Order Pick Slip Report. Code review before migrating code to production and performed transition activities. Having good knowledge of functional modules like PO, BOM, WIP, WMS. Good experience in Loftware Label Design from scratch development and integration with Kallik application. Good experience in configuration of Label Printers and Mobile scanners. Good experience in trouble shooting Label Printers and scanners. Having good experience in Enterprise Asset Management module (eAM). Worked on eAM module technical development like Activity, Asset number and Preventive Maintenance and Meter reading PM work orders. Developed multiple Custom forms as per the client requirement. Communicated with end users to understand the issues to drive it to resolution as per SLA Standards. Working on P1 and P2 issues as per business priority. Modules Worked: - BOM, WIP, WMS, INV, PO, Labelling Project #6 Project : EQUINIX LLC Client : EQUINIX Organization : Nityo Infotech Duration : Oct-2021 to March 2023 Role : Oracle Apps Lead Technical Consultant Environment : Oracle EBS Implementation R12.1.3 Description: Equinix is the world s digital infrastructure company. We interconnect industry-leading organizations in finance, manufacturing, mobility, transportation, government, healthcare and education across a cloud-first world. Founded in Silicon Valley in 1998 as a vendor-neutral multitenant data center provider where competing networks could securely connect and share data traffic, we chose a name that reflected our company s focus on Equality, Neutrality and Internet eXchange Equinix. And we began building the global platform our customers would need to make digital business happen: Platform Equinix . Today our 220+data centers in 60+ markets on five continents connect enterprises, networks, services and innovators from Mumbai to Dublin, Singapore to Chicago, and Helsinki to San Jos . Digital leaders worldwide harness our trusted platform to bring together and interconnect the foundational infrastructure that powers their success. Responsibilities: Responsible for Source to Pay related bug fixes and enhancements for the existing Interfaces, reports. Designed & Developed PL/SQL Validation procedures. Responsible for developing new custom objects based on business requirements and sync the oracle data with Coupa cloud application. Worked on outbound and Inbound data interface with data encryption and decryption. Having good knowledge of Coupa Cloud application. Developed multiple BI reports as per user requirements. Developed OTBI reports as per client requirement. Worked on technical components in SCM module. Worked on AME (Approval Management Engine). Code review before migrating code to production and performed transition activities. Tracking all issues logged by end user and provided technical solutions in Service Now for the Support Issues. Having good knowledge of functional modules like PO, OM, AR, AP. Developed Custom forms for Commodity and POP to enable the segments across all entities. Developed Multiple Reports like Open Purchase Order Report, pick slip, Pack slip and Bill of Ladding Report. Developed interface between Workdays to Oracle HRMS. Developed a few scripts to extract data from Oracle EBS to Cloud HCM. Having good experience in Enterprise Asset Management module (eAM). Worked on eAM module technical development like Activity, Asset number and Preventive Maintenance and Meter reading PM work orders. Developed multiple Custom forms as per the client requirement. Communicated with end users to understand the issues to drive it to resolution as per SLA Standards. Working on P1 and P2 issues as per business priority. Modules Worked: - SCM Modules (PO, Receiving, OM, Inv), Finance (AP, GL) Project #5 Project : RICOH Services Client : RICOH Organization : Wipro Duration : Aug 2020 Sep 2021 Role : Oracle Apps Techno Functional Consultant Environment : Oracle EBS Support and EBS Enhancements R12.2.4 Description: Ricoh produces electronic products, primarily cameras and office equipment such as printers, photocopiers, fax machines, offers Software as a Service (SaaS) document management applications such as DocumentMall, RicohDocs, GlobalScan, Print&Share and offers Projectors. In the late 1990s through early 2000s, the company grew to become the largest copier manufacturer in the world. During this time, Ricoh acquired Savin, Gestetner, Lanier, Rex-Rotary, Monroe, Nashua Tec, IKON and most recently IBM Printing Systems Division / Infoprint Solutions Company. Although the Monroe brand was discontinued, products continue to be marketed worldwide under the remaining brand names. In 2006, Ricoh acquired the European operations of Danka for $210 million. These operations continue as a stand-alone business unit, under the Infotec brand. Responsibilities: Finance and OLFM related to bug fixes and enhancements for the existing Interfaces, reports. Designed & Developed PL/SQL Validation procedures. Code review before migrating code to production and performed transition activities. Having good knowledge in functional modules like AR,AP,FA,GL and Contracts. Communicated with end users to understand the issues to drive it to resolution as per SLA Standards. Worked on AR Invoice generation part for service contracts and OLFM billing contracts. Involved in AP payment related issues and supported AP invoices. Worked on AR Invoice Month end related issues and helped to fix month end issues. Developed Oracle reports as per business user requirements. Developed custom Work Order form to select resource and technician for specific work order. Developed Esignature form to technicians once they completed the job in Work Order. Developed Oracle Report to show the OLFM account analysis entries. Working on P1 and P2 issues as per business priority. Responsible to involve in Month end and Quarter end Period closures. Troubleshooting the production issues on various applications, replicating the issues in TEST environment, and testing the fix prior to apply in Production instance. Involved in preparation of MD70 and MD120 as per enhancements and Bug fixes. Helping team members to understand the client business/process. Modules Worked: - Finance (AP, AR,GL), OLFM, Install Base Project #4 Project : GE Aviation Client : GE Organization : Indepens Software Technologies Pvt Ltd Duration : Mar 2018 July 2020 Role : Apps Technical Lead Consultant Environment : Oracle EBS Implementation R12.2.6 Description: GE Aviation, a subsidiary of General Electric, is headquartered in Evendale, Ohio outside Cincinnati. GE Aviation is among the top aircraft engine suppliers, and offers engines for the majority of commercial aircrafts. GE Aviation is part of the General Electric conglomerate, which is one of the world s largest corporations. This division operates under the name of General Electric aircraft engines until September 2005. GE Aviation main competitors in the engine market are Rolls-Royce and Pratt & Whitney. GE operates two joint ventures with Safran Aircraft Engines of France, CFM International and CFM materials. Responsibilities: Responsible for reviewing online patching objects as per coding standards Developed archive report to store data in backup tables, Shipment information report. Developed item on hand interface, ship confirm interface program. Responsible for moving the objects from one instance to another instance by using HPPPM tool. Responsible for all custom objects upgrading 12.1.3 to 12.2.6 Responsible for solution design in backlog grooming as architect for 5 PODs. Worked on manufacturing modules WIP and BOM and WSH. Customized reschedule Group Work Order form in WIP as per client requirement. Worked on few reports in BOM and WIP module as per client requirement. Developed conversion for routing and Operation resources in BOM Customized the standard picking form in WMS. Worked on Forecast interface in ASCP module. Followed agile methodology for documents Modules Worked: - SCM Modules (PO, Receiving, OM, Inv), Discrete Manufacturing (BOM, WIP, Quality) Project #3 Project : G&W Implementation and Support Project Client : G&W Labs Organization : NTT DATA Duration : Dec 2012 Feb 2018 Role : Apps Technical Lead Environment : Oracle EBS Implementation R12 and Oracle EBS Support. Description: G & W Laboratories, Inc. is a manufacturing pharmaceuticals company established in 1919 and has been providing quality products and services. Specializing in suppositories, creams and ointments, they can provide a full range of services including formulation development, analytical method research and development. Responsibilities: Involved on designing and developing technical documentations for interfaces/Conversions and reports. Development of Interfaces for business requirements. Development of Form Personalization. Development of data Conversions. Development of reports as per business requirements. Worked on EDI integration interfaces like 850 Sales Order,810 and 812 invoice extracts, 180 RMA Sales orders, ASN-856 extract, and Forecast Interface. Worked on 3PL integration interface like 3PL Inter org receipt extract, 3PL Sales Order Extract and 3PL Inter Org Interface, 3PL Ship Confirm Interface. Worked on AR Invoice, AP Invoice conversions during implementation phase. Worked on Supplier data conversion and AR Cash Receipts. Designed and developed custom label printing from MSCA. Personalization on existing standard MSCA screens like validating the fields, defaulting values, enabling and disabling fields. Developed interface between OPSM to OPM. Worked on LIMS integration. Worked on different OPM conversions like Activities, Generic Resources, Plant Resources, Operations, Formula s, Routings, Recipes and Quality Specifications. Worked on Zoom functionality to call forms and reports. Worked on Account Analysis custom report. Worked on Alerts to send email notifications as per business requirements. Worked on technical components in WMS (Warehouse Management System). Worked on New form development in eAM as per business requirement. Worked as eAM Techno functional consultant in G & W eAM Rollout Project. Uploaded all the concurrent program details into another instance by using FNDLOAD commands. Worked on several customizations in OPM (Oracle Process Manufacturing) and eAM (Enterprise Asset Management). Customized and developed several reports in AR, OM, and PO as per the business requirements. Involved in preparing test cases. Modules Worked: - OM, PO, INV, OPM (GMD, GME, and Quality), eAM, AR, AP, GL, WMS Project #2 Project :Aleris Client :Aleris, US Organization : NTT DATA Duration : Sep 2012 Dec 2012 Role : APPS Technical Consultant Environment : Oracle EBS up gradation 11i to R12 Description: Aleris think aluminum is a miracle metal and they like to think of Aleris as a miracle worker, which is what they strive to be for the people and companies depending on them. What s so special about aluminum Aluminum is strong, lightweight, durable, flexible, extremely versatile, impermeable, corrosion resistant, an excellent conductor of electricity, non magnetic, non combustible, an abundant element in the earth s crust and infinitely recyclable. Aluminum has unlimited potential to be part of the solutions that help society progress. Responsibilities: Development of New Reports as per business requirements. Modified Custom Packages. Development of data conversions. Responsible for moving the objects from one instance to another instance by using FND_LOAD methods. Modified all objects like Forms, Reports and all custom PLSQL packages, Procedures from 11i to R12 environment. Developed Process manufacturing forms like Restock and Coil issue form. Modifying the existing Oracle reports as per the version changes to replace obsolete tables with new tables and columns. Involved in preparation of Migration Document. Modules Worked: - SCM Modules (PO, OM, Inv), OPM Project #1 Project : Open Link Implementation and Support. Client : Open Link Organization : NTT DATA Duration :July 2012 Sep 2012 Role : Oracle Apps Technical Consultant Environment : Oracle EBS Applications R12. Description: Open Link has provided leading-edge technology solutions to an increasingly diverse client base. Building on our pioneering development of cross-asset trading and risk management products for energy and financial services companies, we now offer a suite of solutions designed to meet the specific needs of clients within three broad. Responsibilities: Involved on designing and developing technical documentations for interfaces and reports. Development of Interfaces for business requirements. Development of data Conversions. Worked on Supplier data Conversion Worked on Manufacturing modules WIP and BOM Developed custom for in WIP and BOM modules as per client requirement. Worked on AP Invoice data conversion Uploaded all the concurrent program details into another instance by using FNDLOAD commands. Customized and developed several reports in AP, OM, and PO as per the business requirements. Involved in preparing test cases. Developed Oracle Custom Forms like Define Scheduling Start Dates Reschedule Group Work Orders Shift Assignment Manufacturing Planner View Exception for interfaces Modules Worked: - SCM Modules(PO, OM, WMS, WSH), Manufacturing (WIP, BOM) Keywords: business intelligence information technology purchase order procedural language Arkansas