SUMMARY:

• Twelve years of IT experience in System Analysis, Design, Development, Production Support, Customization, Implementation and up gradation of business applications using ERP, Client/Server and Internet Technologies.
• Specialized in Oracle Applications e - business suite Supply Chain / Distribution, Manufacturing, Warehouse Management, MSCA, Costing, Procure-to-Pay, Order-to-Cash, Financials and HRMS skills with sound knowledge of their integration.
• Extensive exposure in ERP implementation using Oracle Applications comprising functional areas in Order management, Inventory, Warehouse Management, Mobile Warehouse Management, Material Planning, Material Forecast, Oracle Receivables, Oracle Payables, General Ledger, Purchasing, Cash Mgmt, HRMS, Payroll, I payment, core HR,I recruitment, Payroll, Learning Management.
• Worked on versions R12, 11.5.10, 11i/11.0.x of Oracle Applications e - business suite Implementation, Maintenance and Upgrade.
• Expertise in Versions 8i, 9i, 10g and 11g of oracle data base and hands on with database.
• Experience in Collection of Business requirements, GAP analysis, designing of customizations, designing of technical components, Doing Setup’s, Administration, Security and Aim methodology.
• Expertise in working with tools like Oracle Forms and Reports, Discoverer, XML publisher and processes like data conversions, API’s, migrations, interface programming, workflow, customization, System, & BI Discover and concurrent programs.
• Expensive expertise with PL / SQL, SQL coding, performance tuning and Data Quality Management.
• Expertise in using version control and code promotion software’s like Kintana, Clear-case, Clear-quest, Serena version control system.
• Expertise in Designing and developing components for Dataware house systems like OBIEE, Cognos, Neotix and their integration with Oracle Applications.
• Expertise in integrating Sales force and Planning tool Rapid Response with Oracle Applications.
• Experience in creating and resolving Service Requests in Oracle Metalink.

PROFESSIONAL EXPERIENCE:

Senior Consultant Oracle EBS

Confidential, Grand Terrace, CA

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

Responsibilities:

• Customizations to current WMS and MSCA Receiving, Pick and Cycle counting processes.
• Process improvements to make Pick process more efficient.
• Resolving performance issues with WMS Hand held Transactions.
• Designing and Developing Customer facing Documents as per business needs.
• Integration of oracle Order management with Ship Exec (3 rd party tool for shipping)
• Customizations to Auto Invoice.
• Performance and process Improvements in day to day Administrative and manufacturing processes.

Technical Lead Oracle EBS

Confidential, Calabasas, CA

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

Responsibilities:

• 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.
• Modified Existing ship documents like Pick Slip, Pack Slip, Bill of Lading, Shippers Letter of Intent and Shippers Export document to include Barcodes and Improve operational efficiencies.
• Worked on improving performance for various DW views in the areas of Order Management, CRM.
• Automated the Subscription Item sales order and Instance creation as per business rules.
• Automated the field replacement related Depot Repair case creation, sales order creation and shipping.
• Worked on Design, Development and Support for E-Commerce order platform to import orders form internet and distributors.
• Providing production support and Quarter close support for the issues in this area.
• Worked on Designing, Developing, Implementing and training various process efficiencies and error prevention mechanisms with in warehouse and shipping.
• Worked on Various Motorola symbol devices to troubleshoot Device and Network Issues and Resolve performance issues.
• 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.
• Designed and developed Customizations to prevent data inaccuracies like duplication of serial number.
• Supported year-end Audit, External Audit by providing various Look back reports and other data as per auditor’s requirements.
• Executed segregation of duties in the Oracle ERP from IT standpoint to stream line access to system and prevent access conflicting to job roles.
• Worked on improving performance of several DW refresh process in the areas of OM, CRM
• Converted nightly refresh of jobs to 3 hour refresh window.
• Worked on designing and developing various executive dashboards and reports off the DW data.
• Designed and developed Interface to export contract and license information from oracle to Sales force.
• Worked on improving performance for existing items, customer data interfaces from oracle to sales force.

Oracle Applications Techno Functional

Confidential, Aliso Viejo, CA

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

Responsibilities:

• Worked on creating initial setups, training users and production support for San Diego distribution center which handles majority of companies shipping operations.
• Stabilized Ecommerce interface between Amazon.com and oracle by automating existing manual tasks, improving mapping, correcting existing errors and proper error handling.
• Customized the Shipping documents like Pick slip, pack slip and BOL as per business requirements.
• Worked on improving shipping efficiency by creating custom process to handle case pack, inner pack, each in shipping process by scanning respective labels.
• Worked on day to day production issues related to sales orders and helped warehouse and customer service teams to resolve the same.
• Supported business in complete revamp of forecasting.
• Worked on changing the existing forecast planning from monthly to weekly and from multiple forecast sets to Top N customers and others.
• Designed custom reports to fetch forecast snap shots and forecast vs sales these reports are used to calculate MAPE and other business metrics.
• Handled the yearend cost update process for the whole company.
• Designed and developed process to load cost elements, resources and over heads in to system.
• Designed and developed custom WIP Document set to perform various operations in work order. Document set includes discrete job pick list, routing and BOM explosion reports by Job number.
• Designed and developed custom BOM explosion report to extract details of all active BOM’s in system
• Developed a custom process to calculate sales credits based on Customer, Product, Brand and Sale location.
• Designed and developed OBIEE dashboards and XML Reports, MTD sales by customer reports.
• Redesigned all the Executive reports like MTD sales by company, brand.
• Designed OBIEE reports to calculate fill rate summary and details for executives and business users.
• Worked with Oracle Support to resolve various data issues like discrepancy between inventory perpetual and actuals
• Worked with finance team to create and modify various reconciliation reports to help the month end process.

Confidential, San Diego, CA

Environment: Oracle Applications R12, Oracle10g, GL, PO, AP, Assets, Banner 7 with student management, Enrollment, Content Management, Forms 10g and Cognos, SQL*Loader, SQL Navigator and UNIX.

Responsibilities:

• Designed and developed custom process to Move validate and load Journal entries in excel sheets to GL INTERFACE tables.
• Designed Templates for GL upload using WEBADI.
• Worked on modifying Custom GL reports as per changes in R12.
• Developed a report for with the details of AP check runs and check details.
• Modified Wells Fargo ACH process as per business rules.
• Worked on customizing requisition approval process.
• Designed and developed custom Layout for check printing as per vendor requirements
• Designed and developed Bi-weekly and monthly Pay check reports.
• Designed and developed Bi-weekly and monthly Deposit advises.
• Designed and developed custom purchase order.

Confidential

Environment: Oracle Applications R12, Oracle10g, GL, AR, PO, AP, Assets, INV, Warehouse Management, SQL*Loader, SQL Navigator and UNIX.

Responsibilities:

• Worked extensively on Confidential architecture.
• Migrated the customer sites and other data to the newly created organizations.
• Involved in creating the default setups for AR.
• Dealt with the Auto Invoice interface.
• We implemented a state of art ware house management system and mobile ware house management system.
• Customized replenishment process as per business need.
• 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.
• Integrated all the label printers to oracle apps so that apps prints right labels for individual case packs boxes pallets if they are there.
• Designed a report to give the hazard class and other required details for the export shipments.
• 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.
• Designed concurrent programs for generating GL dumps for the Year end Audit.
• Customized reports like Gl account analysis report and Account analysis 180 characters report by converting them in to XML Publisher report and improved their performance.
• Worked on improving performance of some GL reports.
• Worked with oracle support to resolve several service requests.
• Converted many of the oracle seeded reports in to XML Publisher reports.
• Designed many XML publisher reports with features like bar codes, logos etc…
• Created a workflow to handle approval for access to various systems.
• Created workflow to handle the submission, processing of forms.
• Created various notifications as per business requirements.
• Designed and developed a process to clean and migrates the Vendor information in to Confidential tables.
• Involved in making test plans for testing all custom processes and day to day user operations.
• Coordinated and supervised all user testing.
• Prepared list of various custom objects in the existing system.
• Modified all the existing Custom Packages to work according to the new table structure.
• Involved in making setups for SLA.
• Converted a number of existing reports in to XML publisher reports as a part of upgrade.
• Recompiled and migrated all the existing custom forms form existing system to R12.
• Involved in coordinating and planning Migration day schedule for upgrade from 11.5.10 to R12.
• As a part of upgrading to R 12 Implemented the Confidential architecture for customers.
• Designed and developed various XML publisher reports for displaying information like outstanding balances.
• Designed a custom process to award aid from collage trustee, federal financial aid and other loans, applying aid to outstanding student balance based on business logic.
• Developed an interface to populate oracle receivables interface tables based on data sent by payment gateway named cash net.
• Designed and developed an interface to populate oracle receivables interface tables based on Receivables Data in Banner.
• Migrated the custom workflow in requisition work flow from existing version of oracle apps to R12.
• Converted existing reports like Printed purchase order, invoice report from Jet forms in to XML publisher report.
• Converted check printing from jet forms to XML publisher report.
• As a part of R12 upgrade tested all the data that got migrated to Payables.
• Tested sample payment process.
• Made all required Setups for the 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.
• Designed and developed an interface to load the forecast coming from a legacy sql server based system in to oracle apps.
• Designed a custom report to give a forecast for item based on which buyers will buy items it is also given to vendors so that they can have an idea about our consumption and we will be assured of availability.
• Designed a custom supply chain planning detail report to capture all the supply and demand for an item from different sources like Sales orders, Work orders, Planned orders etc…
• Prepared several dumps for analysis of consumption of components.
• Designed and developed a Discoverer report to summarize back orders and lost sales as per business requirements.
• Customized the proforma invoice report and converted in to XML Publisher report.
• Prepared a dump for daily orders by brand, sub-brand and customers for the investors.
• Customized the pick slip report in to a XML publisher report.
• Prepared a report for all open sales orders by customer.
• Prepared a report that checks inventory before release of sales order.
• Designed alerts to give the daily shipped order amount.
• Developed a concurrent program to load data for new cost types and cost elements for the Items.
• Designed and developed a cost comparison report to compare the costs of items using different cost types.
• Designed and developed an inventory evaluation report to evaluate inventory for a selected cost type.

Confidential

Environment: Oracle Applications 11.5.10 \ R12, Oracle9i, GL, AR, PO, AP, Assets, CE, CRM, HRMS, Forms 6i and Reports 6i, Workflow 2.6, SQL*Loader, SQL Navigator and UNIX

Responsibilities:

• Worked Extensively on Multi-org.
• Developed scripts to create setups for operating units across 18 modules.
• Dealt with Identifying of duplicate customers based on methods of DQM (Data Quality Management).
• Implemented various business rules while identifying duplicate customers and customer related information.
• Created several levels of Confidential information using HZ API’s
• Involved in De-customization and implementation of Multi-org Structure in various work flows and other custom objects.
• Worked in creation of new operating unit.
• Worked extensively on form customizations, form personalizations and custom.pll in the order related screens to create custom order types as per business requirements.
• Worked on creating all the setups’ like set-of-books, currency, roles, responsibilities and many other things required for an operating unit.
• Identified and analyzed different Schemas having dependency of organization and wrote interfaces to insert data in to various tables based on business requirements.
• Migrated customer related data across instances by disabling the triggers and copying them via db link to increase performance.
• Participated in several test cycles and Deployment cycles.
• Developed different kinds of Audit scripts and verification scripts.
• Worked on all the setups and customizations done in Order management.
• Dealt with various sources of orders and stream lined them in to the oracle apps.
• Dealt with very high volumes of data and implemented many business requirements for in order management like several types of order holds.
• Worked on deciding routing of orders along with business and configuring the customized tables to provide defaults for things like shipping preferences…
• Developed scripts for creating the setups in order management for the new operating unit.
• Worked on deciding all the defaulting rules.
• Worked on formulating shipping preferences and other order related preferences of the client.
• De customized the existing electronic order import and order work flows.
• Worked on integrating several legacy order tools with oracle applications.

Confidential

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

Responsibilities:

• Dealt with daily AR invoices interface between legacy different sales systems to Oracle AR. Usually issues will be with data with invalid characters, FTP issues.
• Good experience in dealing with functional and technical issues in financials.
• Supported daily issues with PO and Pos.
• Supported AR, AP and GL month end close issues like un-posted items in AP and AR.
• Supported end users with their issues like applying the cash in AR and generating the Payments in AP.
• Supported the Auditors with pulling the financial data with ad-hoc queries for the auditing purpose.
• As part of support, worked on form personalizations.
• Supported the issues with invalid GL account combinations, invalid values in value set etc.
• Worked with Oracle using Metalink to create SRs (TARS) for data fixing scripts whenever there is some data corruption due to bugs with Oracle standard code.
• Worked on Form customizations and report customizations.
• Designed and Developed Customer conversion and interface from Main-frames and other marketing systems into Oracle AR
• Setup Accounts Receivables that includes System and Profile Options, Customer’s Information.
• Designed and Developed Open items conversion from Legacy AR to Oracle AR, including unapplied cash
• Involved in setups which are required for Customer Interface
• Involved in setups which are related to Auto Invoice
• Modified GL reports and designed, developed and tested custom reports as per users’ requirements
• Developed several Reports, used open Interface to Import Journals by GL-Interface and Budget Transfer to GL by using GL-Budget-Interface.
• Wrote scripts to migrate the data from the text files and populated the intermediate tables like GL INTERFACE and GL BUDGET INTERFACE.
• Used Confidential to build statements as per business requirements.
• Worked on stream lining orders from existing sales channels and legacy systems.
• Worked in implementing business requirements with order holds like discounts.
• Worked on interface related to shipping details.
• Worked on creating the pricelists, pricing attributes and modifiers.
• Customized the order header work flow as per business requirements.
• Developed 6i and Discoverer9i reports for the new implementation
• Worked on creating objects like business layers defining security layers in the discoverer administrator.
• Worked on creating work sheets and work books based as per the business requirements.
• Developed many new repots across modules as per requirement.
• Customized the seeded reports in apps.