Candidates About

 

Sravanthi

Oracle Applications Consultant           

Summary: 

·         Over Nine years of IT experience in System Analysis, Design, Development, Production Support, Customization, Implementation of business applications using ERP, Client/Server and Internet Technologies.

·         Specialized in Oracle Applications Financials, Supply Chain / Distribution, Order Management, Inventory, WIP, BOM, AOL and Sys Admin with sound knowledge of their integration. 

·         Good knowledge with the order 2 cash and procure 2 pay.

·         Good Experience with Oracle Financials.

·         Worked with versions 11i/11.0.x & R12.

·         Worked with versions 9i, 10g and 11g of oracle data base.

·         Experience in Oracle Applications Implementation and Upgrade projects.

·         Experience in Administration, data conversion, interface programming.

·         Experience with Oracle Forms, Oracle Reports, Xml Publisher, Oracle forms, PL/SQL and SQL programming.

·         Experience with Oracle database development, including stored procedures, database triggers and database packages.

·         Expertise with RICE components Reports, Interfaces, Conversions and Extensions.

·         Working knowledge with several oracle interfaces like Order Import, Item import, Journal Import and Vendor Import.

·         Worked on developing many new reports and customization of existing reports.

·         Developed many new reports and also convert many seeded RDF reports in to XML-publisher reports.

·         Experience with PL/SQL and SQL Programming Error handling.

·         Experience in Performance tuning and optimization of Packages, Procedures and SQL queries.

·         Experience in creating and handling SR’s in Oracle Support.

·         Good hands on with TOAD, FTP.

·         Experience in configuration management tools like JIRA, Tortoise, CVS and PVCS.

·         Experience in using service systems like ServiceNow.

 

Technical Skills:

Oracle EBS Modules: Order Management (OM), Inventory (INV), General Ledger (GL), Bill of        Materials (BOM), Work In Progress (WIP), Purchase Order (PO), Oracle Payables (AP), Oracle Receivables (AR).

Operating Systems:   Windows 7/Vista/XP/2000/98/NT, UNIX, LINUX

Languages:                 SQL, PL/SQL

Database:                    Oracle 11g/10g / 9i / 8i

Developer Tools:        TOAD, Oracle Developer Suite 6i/10g, Oracle XML/BI Publisher

Utilities:                       Sql*Loader

 

Education:

Bachelors in Computer Science, Jawaharlal Nehru Technological University, India.

 

Sybron Dental Specialties

Oracle Techno Functional Developer                                                         Nov 17 to Till Date

 

Environment: Oracle Applications R12, Oracle11g, GL, AR, PO, AP, Assets, INV, WIP, OM, Supply chain Planning, BI publisher, Oracle Workflow Builder, SLA Customization

 

Sybron Dental Specialties, a Danaher company, develops innovative technologies. They manufacture and market Medical Devices and products for the dental and medical professions—serving clinicians worldwide and, ultimately, improving the health and beauty of their patients.

 

The project deals with combing existing 2 physical Inventory organizations of different organizations in to one. The project involved customizing Multiple Account Generator work flows, extensions and hooks in Oracle.

• Customized PO Account generator workflow to generate the accrual account as per business needs.
• Customized Standard Costing Account Generator workflow to generate Inventory Valuation account, Purchase Price Variance account, Receiving Inspection account etc. as per business needs.
• Customized the Standard Costing Account Generator workflow to generate accounts like inter org payables, inter org receivables, in-transit inventory accounts for inter org transfers.
• Customized costing hook to generate the resource absorption accounts.
• Worked on SLA customizations to generate the segments based on business rules for various accounts.

 

 

 

 

Dover

Oracle Techno Functional Developer                                                         Sep 16 to Oct 17

 

Environment: Oracle Applications R12, Oracle11g, GL, AR, PO, AP, Assets, INV, Supply chain Planning, BI publisher, CRM, Forms 10g and Reports 10g and UNIX.

 

Dover Corporation is an American conglomerate manufacturer of industrial products. Dover delivers innovative equipment and components, specialty systems and support services in the areas of Energy, Engineered Systems, Fluids, and Refrigeration & Food Equipment. Dover is implementing oracle applications across its 28 operating units worldwide.

The project Deals with post implementation stabilization at Wilden Operating unit in Grand Terrace California and Implementation of Oracle Applications in Two other operating units CPC (Colder Products Company) and Blackmer.

 

• Customizations to current WMS and MSCA Receiving, Pick and Cycle counting processes.
• Customized Account generator workflow as per business needs.
• Converted multiple seeded finance reports in to Oracle XML Publisher reports (BI publisher)
• Customized oracle order line workflow extensively to accommodate clients Make to order needs without configurator. 
• Process improvements to make Pick and Pack process more efficient.
• Resolving performance issues with WMS Hand held Transactions.
• Resolving a wide range of Supply issues by analyzing MRP, ASCP and Providing root cause and resolution.
• Designing and Developing Customer facing Documents as per business needs.
• Integration of oracle Order management with Ship Exec (3 rd party tool for shipping)
• Designing and Developing Various Bartender Labels in the areas of Receiving, Work order processing and Shipping.
• Performance and process Improvements in day to day Administrative and manufacturing processes.

 

 

Ixia

Oracle Techno Functional Developer                                                         Mar 15 to May 16

 

Ixia is a hi-tech manufacturing company that provides reliability and security solutions for your development, deployment, and operations.  The Ixia Solution Architectures provide confidence your products, applications, and networks are high performing, reliable, and secure.

 

The project Deals with working on the requirements, Design, Development, Testing, Implementation, and Support of Oracle EBS R12.2.6 The goal of this project will be to design and provide complete end-to-end solution for Finance, Supply Chain and CRM areas of Oracle Applications.

           

Kinaxis Rapid Response Implementation:

 

Ixia Decided to implement Rapid Response as their Supply and demand planning tool, Worked as point of contact to provide Data and Integration form Oracle ERP to Rapid response.

 

• Participated in the design session and contributed information from oracle applications to decide data extract mapping.
• Designed and developed multiple data extracts form Oracle ERP to Rapid Response.
• Automated the process of Extract file flow from Rapid response to Oracle.
• Automated component inventory data transfer from suppliers to Oracle Applications.

 

Order Management:

 

• Worked on Design, Development and Support for E-Commerce order platform to import orders from internet and distributors.
• Customized order header and line workflows to accommodate client needs for capturing distributor, end customer details and service line needs.
• Designed Custom forms to correct shipping transactions interfaced to 3PL Partners.
• Modified existing shipping forms to include 3PL order details.
• Customized existing sales order screen to include Ship to customer end customer details and link same to Service Contract related for the order.
• Automated the Subscription Item sales order and Instance creation as per business rules.
• Modified the sales orders and shipping alerts as per business needs.
• Automated the field replacement related Depot Repair case creation, sales order creation and shipping.
• Providing production support and Quarter close support for the issues in this area.

 

Oracle Finance:

 

• Supported year-end Audit, External Audit by providing various Look back reports and other data as per auditor’s requirements.
• Customized several seeded oracle reports to Oracle XML publisher reports.
• Customized PR Workflow to automate Charge account generation.
• Executed segregation of duties in the Oracle ERP from IT standpoint to stream line access to system and prevent access conflicting to job roles.
• Performed certification of various finance reports as per procedure out laid by Auditors.

 

 

 

Supply Chain:

 

• Customized Multiple Inventory transaction and Shipping Screens as per customer needs.
• Designed Developed and Deployed multiple oracle Alerts and reports to safe guard quality of Data.
• Designed and Developed Shipping alerts as per business requirements.
• Designed and developed multiple enhancements to decrease manual transactions in the system.
• Providing support for issues related to transactions and \ or shipping documents.

 

 

Pacific World Cosmetics

Oracle Techno Functional Developer                                                         May 12 to July 14

 

Environment: Oracle Applications R12, Oracle10g, GL, AR, PO, AP, Assets, Inventory, Order Management, Forms 10g and Reports 10g, SQL*Loader and UNIX.

 

 

 The Project dealt with implementation, post implementation support and stabilization of the

Implementation. The implementation consists of a wide range of custom XML publisher reports,

Discoverer reports and a state-of-art Warehouse Management.

 

Order Management

• Designed a report for MTD sales by customer, region and brand.
• Created custom forms to enter customer agent commissions by region, product and calculate the commission amount.
• Prepared SO Release ATP report that checks inventory before release of sales order.
• Customized the pick slip report in to a XML publisher report included default pick location.
• Designed and developed a report to summarize back orders and lost sales as per business requirements.
• Customized the Proforma invoice report and converted in to XML Publisher report.
• Created Materialized views for daily orders by brand, sub-brand and customers for the investors.
• Involved in determining the reasons for error in Order import interface and fixed them some common errors will be like wrong tax rate , Customer not present in system etc.
• Prepared a report for all open sales orders by customer with Delivery line status for warehouse.

Inventory    

• Developed a concurrent program to load data for new cost types and cost elements for the Items.
• Customized Horizontal supply plan and Supply demand form as per client needs.
• Designed and developed a cost comparison report to compare the costs of items using different cost types.
• Loaded items using Item interface.
• Created a custom program to create item reservations using reservations api.
• Designed and developed an inventory evaluation report to evaluate inventory for a selected cost type.
•  Designed report to check for inventory before pick release of sales orders.
• Modified all the reports like pick slips to have bar code on them so that we can use mobile hand held devices to read the report.
• Designed reports to analyze the shipping trend by number of items and value of items.
• Designed a report to give the hazard class and other required details for the export shipments.

 

WIP&BOM

•  Developed a concurrent program for doing mass update of resources like time used in the BOM or WIP.

• Customized the discrete job pick list report by converting it to XML Publisher report and also converting the things like job number item number in to Bar codes.
• Customized the discrete job pick list report.

 

Account Payables & Purchase Order

• Worked on configuring and Loading Forecasts.
• Good idea on MRP and planning.
• Loaded vendors from acquired companies using vendor import interface.
• Created a report to get open purchase order with filters like vendor, date range, items.
• Customized expected receipts report to include item and brand.
• Converted supply chain planning detail report using XML publisher to work in excel and also added filters as per business requirements.
• Created a custom form to see supply demand and forecast for an item.
• Provided data dumps and reports for purchasing team and forecasting team to facilitate data analysis.
• Customized print purchase order report as per the format requested by business.
• Good idea on Requisition Workflow, creating and importing requisitions.
• Worked on PO approval limits and PO approval hierarchy.
• Designed and developed XML Publisher Report for check printing.

 

Account Receivables

• Designed and rolled out a custom form for entering sales credits for sales persons against each customer. 
• Designed a custom report to calculate the sales commissions to be paid for the sales persons as per the business requirement.
• Prepared a month to date sales report that represents the Actual sales, Targeted sales, bookings, shipments in each operating unit.
• Designed and developed an interface to make a sales dump on daily basis for the investors of the company.
• Prepared separate reports for monthly sales by brand, monthly sales by brand and sub-brand, monthly sales by customer.

 

Xml Publisher

• Converted many of the oracle seeded reports in to XML Publisher reports.
• Designed many XML publisher reports with features like bar codes, logos etc…

 

 

 

United Health Group

Oracle Techno Functional Developer                                                           Oct 09 to April 12

 

 

The project dealt with day to day maintenance issues and extensions to existing system.

   The project also dealt with converting huge number of existing reports into xml publisher reports. 

 

   Environment: Oracle Applications 11.5.10, Oracle9i, GL, AR, PO, AP, Assets, HRMS, SYSAdmin & AOL, Forms 6i and Reports 6i, SQL, SQL*Plus, PL/SQL, SQL*Loader, XML Publisher, Win NT and UNIX.

  

·   Dealt with writing PL\SQL code for different interfaces, validations and error handling.

·   Dealt with customizing reports with things like adding more parameters and filtering the data as per the parameters given by user. Customizing the sort order as per the parameters given or as per the business requirement.

·   Designed and developed a purchase price variance report to provide YTD totals of variance by buyer, vendor, and brand.

·   Dealt with improving performance of several custom reports.

·   Dealt with form customizations and custom .pll as per business requirements.

·   Designed MTD Reports like Dealer sales by region, market.

·   Created several value sets for using in KFF’s, DFF’s and Concurrent program parameters.

·   Registered several concurrent programs and attached them to required responsibilities.

·   Involved in determining the reasons for error records in various interfaces.

·   Loaded new items in to oracle application by using item interface.

·   Defined payment terms, locations, periods, tolerances etc. Integrated Payment reconciliation information and Purchase Order information with AP.

·   Converted existing reports like Printed purchase order, invoice report in to XML publisher report.

·   Converted several reports like GL 180 characters report, ageing report in to XML publisher report.

·   Created several Data Definitions and Templates for creating XML Publisher reports.

·   Loaded payment terms in AP.

·   Supported the users with things like attaching responsibilities to user, attaching concurrent programs to responsibilities.

·   Created several data base objects like Procedures, functions, sequences, constraints etc for using in custom code.

 

PRAGMA SOFTWARE SOLUTIONS

Oracle Technical Developer                                                                        June 06 to June 08

 

Environment: Oracle Applications Release 11.5.9/11.5.10, Oracle 8i, GL, AR, AP, PO, OM, SYS Admin & AOL, Inventory, Reports, SQL, SQL*PLUS, SQL*Loader, TOAD, PL/SQL, WinNT and UNIX.     

 

·      Designed a custom interface to load employees in to oracle apps using Employee API.

·      Converted a Discrete Job Pick List report in to XML Publisher report and made the item number in to Barcode to enable reading by hand held devices.

·      Designed a report for Daily Sales by Customer.

·      Dealt with improving performance of custom reports and PL \ SQL procedures.

·      Designed a report to project the Different bill to and ship to information like shipping address contact information etc taking customer as parameter.

·      Good exposure in inventory defining master item template creation and assignment of sub inventories.

·      Worked in Customer conversion and interface from Main-frames and other marketing systems into Oracle AR by writing a PL\SQL package for validating a customer, customer site and customer site use and decide if they need to be should have at least one exported to new system or not, some criteria considered are customer transaction to one of his billing sites in last 180 days. A set of almost 40 such business rules are considered.

·      Worked on daily interface of Purchase Orders from external system to Oracle.

·      Developed custom reports (Duplicate invoice, invoice aging rep, stopped payment rep, payment registered, invoice audit rep, matched and modified rep).

·      Designed and Developed PL/SQL process with validations to convert all legacy suppliers into AP/PO.

·      Involved in developing and testing a PL/SQL process to convert all legacy customer master (with validation) using TCA API’s

·      Good Experience on process Quotes (RFQ’S), Requisitions, Standard POs, Sales orders and releasing orders.

·      Defined the Dependent value sets by reading the information from previous parameter value and using $FLEX$.

·      Configured the DFF’S like Additional personal details as per the client’s requirement.