Principle Consultant
Oracle India Pvt. Ltd
Total years of experience :18 years, 11 Months
Functional and Technical Subject Matter Expert for iStore and Quoting Modules.
•Proficient in Procure to Pay (P2P), Order to Cash (O2C), CRM and Supply Chain Modules.
•Good understanding of data flow in the different modules of Oracle Applications.
•Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
•Technically proficient in RICE (Reports, Interfaces, Conversions, and Extensions) methodologies including Implementation, Interfacing, Conversion and Data Migration experience in Oracle Apps R12.
•Experience in using Oracle Discoverer and XML publisher for reports generation.
•Expert in SQL, PL/SQL, Java, SQL* Loader, Shell Scripting etc.
•Expert in troubleshooting and fixing the bugs, creation of SR/TAR with metalink, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
It is 24/7 product support across the Globe in Areas of Order management, Shipping and Oracle Pricing Modules.
Here we deal with multiple issues like
•Setup and execution of constrained and unconstrained plans.
•Debugging and troubleshooting the problem with the SQL code written by inserting debug messages in customer environment to find out the Root Cause.
•Working on performance problems of various programs.
•Need to analyze the trace and TKPROF files for performance related issues
•Analyzing the debug files and technical assistance provided
•Worked on the Form Personalization’s, OAF, Workflow, PL/SQL, Forms on CRM Applications.
•Worked on modifying the dependencies of seeded defaulting rules through OE_DEPENDECIES_EXTN
•Worked on Conversion of Order Import, Resource Import and many other conversion’s.
•Worked on PL/SQL Procedures and Packages
•Providing functional assistance in understand functionality of iStore, Quoting, Trade Management, Sales and Common Application modules.
•Worked and resolved on several Sev1’s which have higher priority and crucial business effecting scenarios
•Prepared some documents in knowledge database which can be accessed by users and customers of Oracle
•Directly interact with customer to solve the issue
•Conducted Product related training to different customers.
Responsibilities:
•Responsible for providing technical support assistance for customer facing issues in the following areas: API, System set-up, configuration management, integration issues, performance tuning, upgrades and function/feature support, Code fixes.
•Handled Severity 1 Critical SR's
•Have been a part of the client handling team to handle GOLD customers of Oracle during the Project Implementation to ensure that the timelines are met.
•Mentoring team on need basis
Responsibilities Other than Support activities:
•Participated in root cause and corrective action activities defined within one’s cluster for the service request raised.
•Maintaining the internal server by installing 12.2.5 Apps version and applying latest patches
•Worked 1:1 with premier customers to address Development / Bug related issues.
•Assisted management team in the recruitment process.
•Involved in Product Release Testing discussions with PRR team have been a part of testing team for R12, R12.2.3, 12.2.4, 12.2.5, 12.2.6 and 12.2.7 version for Quoting and iStore applications
•Content Lead to review and publish Knowledge Management and Support articles for customers on Interfaces and API, EDI and CRM Setups which releases bimonthly.
Client All CRM implemented Companies
Oracle Applications R12 (12.1.3)
Skills Used SQLLDR, SQL, PL/SQL, AR, QP, OAF, XML Reports, Workflow
Oracle Applications R12 (12.1.3)
Skills Used SQLLDR, SQL, PL/SQL, AR
Oracle Applications R12 (12.1.3)
Skills Used SQLLDR, SQL, PL/SQL, XMLP, OM, AR, OKC, OKS, IB and QA
Oracle Applications R12
Skills Used SQL, PL/SQL, Alerts, Oracle Receivable, WIP
Oracle Applications R12
Skills Used SQL, PL/SQL, XML
GSE is a world leader in real-time, high-fidelity simulation, providing a wide range of simulation, training and engineering solutions to the energy industry. This project is the implementation of R12 Oracle finance, Projects and HR.
Role:
•Developed Payroll reconciliation report using XML
Oracle Applications R12
Skills Used SQL, PL/SQL, XML
Oracle Applications R12
Skills Used SQL, PL/SQL, Reports6i, Install scripts, AR, PO
Client Step2 Direct
Oracle Applications R12
Skills Used SQL, PL/SQL, INV, PO, OM, QA, QP
Oracle Applications r12 (12.1.1)
Skills Used SQL, PL/SQL, Reports and Forms, INV, OM, QP, AR, PO, WSH
Oracle Applications 11i (11.5.10.2)
Skills Used SQL, PL/SQL, Reports and Forms, XMLP, OM, AP, INV
Oracle Applications R12 (12.0.6)
Skills Used SQL, PL/SQL, HR, Payroll, OAB, OTL
Oracle Applications 11i
Skills Used SQL, PL/SQL, Reports, SQLLDR, Shell Scripts
Harsco Metals & Minerals provides logistics and environmental services for industry. By working onsite under long term service contracts at 160 customer locations across 30 countries. Harsco began life last century by offering steelmakers a metal recovery service for slag, and expanded into other business areas to meet the growing need for recycling in the metals industry, and beyond.
Role:
Developed Staging tables, Conversion routines, and Custom PL/SQL API for Creating Price lists from a Custom ADF Page.
Translated concurrent programs and request sets to Brazilian Language as a part of Brazil Rollout.
Developed several custom reports using XML publisher.
Develop the OA Frame work page in SSHR, PO, INV
Worked on OAF personalization to make supplier filed mandatory in Buyers Work Center Orders Page.
Performed Unit testing and Prepared Technical instructions Documents
CCHS) is dedicated to making home management easy by offering a full selection of hassle-free, cost-effective home solutions, including warranty products and maintenance plans. Since 1978, the company has built a reputation for excellence and today is one of the nation's leading providers of these products and services. This project is an upgradation from existing R11 (11.5.10.2) to R12 (12.1.3).
Role:
Customized proforma Invoice report using XMLP.
Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for converting Service Contracts.
Developed several PL/SQL routines to be consumed by web services to update contract bill to, ship to addresses and renewal rule based on the role.
Performed Unit testing and Integration testing.
Prepared the Technical instructions Documents
SCI is a leader in direct marketing and currently markets diverse products around the world. From jewelry, collectible coins and household products to health supplements, SCI continues to lead the way through product innovation and multi-channel marketing. With sales of over 100 million dollars annually. This project is implementation of r12 (12.1.3)
Role:
•Developed PL/SQL routine for creating the discrete job for an assembly item and their sub-assembly if exists based on the project.
•Created Alert that sends email to a user group as soon as the WIP Job is created or Completed.
•Developed PL/SQL package which reads the payment information from a Siebel view and creates receipt, un-identified receipts, Applying receipt to invoices and reversing the receipt.
•Performed Unit testing and Integration testing.
•Prepared the Technical and migration instructions Documents
Liggett Vector Brands is the exclusive sales, marketing and distribution agent for Liggett Group and Vector Tobacco offering an extensive line of quality tobacco products proudly made in the USA, including Liggett Select, Eve, Grand Prix, and Pyramid. This project is implementation of R12. I have involved in development of XML Report and form personalization.
Role:
•Customized shipped delivery lines report using XML publisher.
•Worked on personalizing the WIP discrete jobs form. Added a new menu item (generate lot). Will generate the lot number as per the lot number generation logic provided by the client when the item type is “Finished Goods” and Work Order Status is Unreleased”.
LiDestri Food & Beverage is the premier manufacturer of sauces, dips and salsas in the United States. Coast to coast, we have multiple manufacturing locations where we produce more than two million jars of sauces and dips per day and offer the lowest landed cost available. This project is the implementation of R12.
Role:
•Developed several Operational report using XML
Caris Life Sciences has been a leader in diagnostic, prognostic and theranostic medicine, transform healthcare through development of innovative technologies. This project is the implementation of R12
Role:
•Customized seeded AR Print Statement Report Using XML publisher.
•Customized the Printed PO Report and implemented Bursting to communicate to suppliers.
•Customized the Standard Printed PO Report, Blanket Agreement, Blanket Release and Purchase Contracts to print directly from the menu as well as from the concurrent program.
•Customized seeded Print selected invoice report and new invoices report. Developed XML Bursting Control file is developed to send the invoices to customer when the concurrent program is submitted.
•Prepared Technical design document and Migration instruction document
Step2 Direct began in 1999 as an online website for the fulfillment of daycare orders. Realized that everyday Moms and Dads are tech savvy, ahead of the curve, and interested in ordering Step2 products and having them delivered directly to their home. Because of this realization, Step2 Direct has now morphed into a direct to consumer ecommerce website.
Role:
•Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for converting Items, Customer item cross-references, item category, pricelist and Open sales orders.
•Customized seeded Printed PO report, Sales Order Acknowledgement and Payment Enquiries Report
•Worked on defaulting rules customization. To default demand class based on the Ship to address on the sales Order.
•Developed report Roto Repair Report (Quality Module), Sales Journal by Customer.
•Creation of Concurrent programs, value sets, Procedures and Functions.
•Preparation of Test case, Installation documents.
Elkay is a supplier of high value residential kitchen, bath, cabinetry and wood products, commercial plumbing products and related services that meet the needs of a variety of market segments. This project is implementation of R12
Role:
•Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for converting Open Sales Order, Open RMA, Open AP Transactions and Open AR transactions.
•Customized Seeded reports (Bill of Lading and Wave pick slip) using XML Publisher.
•Development Several Oracle Reports that are used internally like Collector credit Hold Report, Commission Vouchers, Invoice on hold report, Missing W9s (Vendor on payment Hold) and Payment Register
•Creation of Concurrent programs, value sets, Procedures and Functions
Jack in the Box Inc. is a restaurant company that operates and franchises Jack in the Box® restaurants, one of the nation’s largest hamburger chains, with more than 2, 200. Additionally, through a wholly owned subsidiary, the company operates and franchises Qdoba Mexican Grill®, a leader in fast-casual dining, with more than 550 restaurants. The project includes implementation of complete Oracle supply chain system there by replacing the legacy mainframe system.
Role:
•Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for converting Suppliers, Supplier Sites and Supplier Contacts
•Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for converting Parties, Party Sites, Customer Accounts and Customer Account uses and Ensured that TCA (Trading Community Architecture) was implemented properly and all the customers are loaded in HZ Tables.
•Wrote MD70, CV40, CV60 documents, conversion routines, created staging tables and Custom PL/SQL API’s for Converting Items, Item Categories, Item pending statuses and Inventory On hand Quantity.
•Wrote MD70, CV40, CV60 documents, conversion routines, created staging tables and Custom PL/SQL API’s for Converting Standard PO’s and Blanket Purchase Agreements
•Developed a conversion routine, staging tables and custom PL/SQL API to insert data into
•Pricing Interface tables and called QP: Bulk import of Price List Program to load pricelist lines and attributes into oracle
•Defined various lookups/quick codes which can be used in different data conversions from legacy systems to oracle system.
•Worked on inbound interface from WMS to oracle it includes processing of purchasing transactions (PO receipts using RTP); Order Management transactions (Booked sales orders, Invoice transactions and RMA’s) and inventory transactions (Inventory adjustments, sub-inventory transfer and pallet transfer).
•Developed validation programs to validate the data before loading into interface tables from staging tables.
•Designed and developed custom interface error correction form (using template.fmb) for Viewing and correcting the records that failed validation while processing WMS transactions to oracle.
•Designed and developed a custom form to maintain the fuel surcharge rate based on the region and carrier and a custom form to maintain Equipment limits based on the client’s requirements.
•Worked on Outbound interface this extracts the warehouse and location information (XML file) and syncs with the XML location database. Used XMLFOREST and XMLELEMENT to generate XML directly from PL/SQL.
•Worked on OAF customization to extend the existing VO based on the client requirement.
•Worked on OAF Personalization as well
•Responsible for downloading and maintaining LDT’s which includes ( Concurrent Programs definitions, Executable, Request groups, value sets, lookups, profile options, printer styles, printer drivers, form functions and form personalization’s).
•Worked on several SR’s and coordinated with DBA’s
Herbalife offer nutrition, weight-management and personal care products exclusively through a network of approximately 1.9 million Distributors in 72 countries. This project is a global rollout.
Role:
•Involved in functional document review and prepared technical requirement specification based on the business requirement.
•Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
•Designed and developed extract program for several countries (Ecuador, Venezuela and Peru) to accomplish Electronic funds transfer (EFT) which replaces the seeded format payment program in Accounts payables.
•Modified and fixed several packages to resolve the production issues
•Designed and developed wrapper procedure, which calls the procedure which fetches all Orders for given period and then call the custom report.
•Designed and developed Venezuela Payables Invoice Tax Detail Report. Created data definition and data template.
•Designed and developed Russia VAT/DUTY Calculation report which includes Invoice Details, Packing List Details, Shipment Summary, and Shipment Totals for each order created in HMS.
•Developed report (HL AP Ecuador REOC Report) that can be run in Summary or Detail mode by the users for any period by passing the date range as input parameter to the report
•Developed outbound interface which extracts the Italy Orders created in HMS (Herbalife management system and send the extract to Pap (Porta a Porta a third party shipping/picking system).
•Developed inbound interface from PaP (Porta a Porta a third party shipping/picking system) system to HMS (Herbalife management system).
•Modified the custom Production Schedule Report to calculate the results for 52 weeks instead of 26 weeks.
•Worked closely with DBA’s to execute the scripts related to OATM (oracle applications tablespace management)
•Customized the report HL Item Export Extract to display the additional column material status control.
•Worked on calculation issues related to HL Intransit Value Report.
•Developed several DEC (Distributor Ethics and Compliance) reports using XML publisher Open case file report, Case file status report, Case activity status report and Case resolution report.
•Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
•Developed a script for Bangladesh, Bermuda, Bulgaria and Myanmar to standardize the usage of country code in HMS to the ISO country code.
•Modified the custom AR Warehouse Manager form as per the client requirement.
•Involved in Building Customizations and Enhancements using Reports and Forms.
•Created Data Definitions and Data Templates for XML Publisher reports.
•Customized reports in OM and INV such as pick Slip Report, Warehouse Performance Report, and Open Orders with deliveries and Inventory Reserve Report.
•Used FNDLOAD to download and upload AOL data (data request groups, menus, forms, functions; responsibilities; flex field value sets; users) from one instance to another instance.
•Worked on performance issues, created indexes and used hints to optimize the sql queries
The most customers focused, cost efficient vehicle and equipment/rental leasing company in the market. Strengthen the worldwide positions through a shared value culture of Employee and partners. The present project includes conversion from legacy data to existing system.
Role:
•Designed and developed Outbound Interfaces using PL/SQL and SQL*Loader to extract the data from Oracle tables.
•Involved in requirement gathering of Interfaces Outbound and integration with 3rd Party talent management system.
•Developed New Hire out bound Interface. This Interface program creates a data file using the UTL_FILE package.
•Designed and developed conversion routines, custom PL/SQL API’s to convert from Legacy system Jobs, Work Locations, Positions, Grades, Employees, Employee Addresses, Salary, Element Entries.
•Designed and developed conversion routines, custom PL/SQL API’s to convert from Legacy system Life event reasons, Programs, Plans, and Options.
•Developed Employee Conversion programs to populate the legacy employee data into Oracle HRMS tables using API’s in HR module and Registered as concurrent programs.
•Developed PL/SQL packages as per business requirements for transformation and loading of data from flat files.
•Customized Reports like Employee Benefit Eligibility Listing, Employee Benefit Enrollment Register.
•Developed several views and reports as per requirements in HR and Advance Benefits.
•Developed new reports, customized the standard reports like Employee Salary Report, View Employee PO Approval limit report, Audit Assignment Count Report, Applicant Applied for Vacancy Report, Job listing etc., using Reports 9i/10g
•Creation Of Various Reports like Employee Increment Results Report, Employee Governing Report, Employee Summary Report, Full Personal Details Report Set, Full Work Details Report
•Involved in the various levels of testing
Role:
•Designing and developing Proto Type Data Migration Process to test load legacy sample data.
•Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
•Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
•Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging
from