SUMMARY

• Over 8 years of experience in System Analysis, design, development, Conversions, Interfaces customization, implementation and support of business applications using Oracle Applications.
• Extensive technical and functional expertise in Oracle Applications R12/11i.
• Implementation and technical expertise in Oracle E - Business Suite Financial, Manufacturing & Supply Chain modules like OM, GL, AP, AR, PO, BOM, INV, WMS, WSH and FA modules.
• Knowledge and understanding of Oracle Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Working experience in System Administration activities and Strong knowledge of AOL.
• Experience in designing, developing, implementing and customizing of RICE (Reports, Interfaces, Conversions, and Extensions) components to integrate Oracle Application Modules.
• Experience in development of Concurrent Programs, Customization and Modification of Reports.
• Strong programming experience in creating Packages, Procedures, Functions, Triggers, SQL * Loader scripts and other database objects using SQL and PL/SQL.
• Expertise in TCA (Trading Community Architecture).
• Experience in data conversion from legacy systems to Oracle Applications.
• Expertise in design and development of Interface, Conversion, Migration and Customization programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces, APIs and UTL FILE Packages.
• Excellent skills in designing and developing different types of Reports 10g/6i using Oracle Reports & XML Publisher 5.6.3/5.6.2.
• Extensive experience in developing and customizing Oracle Forms using Oracle Forms 10g/6i/4.5.
• Adept at designing and customizing the oracle application forms using TEMPLATE.fmb and CUSTOM.pll to create new functionality to the application.
• Experience in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf and Indexing. Very proficient in SQL tuning and optimization of queries.
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also Testing documents throughout multiple Projects.
• Excellent working knowledge in UNIX shell scripting.
• Extensive Functional & Technical skills in the area of Business User Interaction, System Requirement gathering, Application Development, Customizations and Implementation of software applications in client-server, database and enterprise software environments.
• Providing post-implementation, application maintenance and enhancement support with regard to the product / software application
• Excellent Team Player with good problem solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

ERP: Oracle R12/11i/10.7 General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchase Order (PO), Order Management (OM),Fixed Assets(FA), Inventory (INV), Sales Online, Application Object Library (AOL), Flex Fields, TCA, CRM, Service Contracts, Service Fields, SysAdmin, Install Base

Languages: SQL, PL/SQL, C, C++, core Java

Web Technologies: HTML, Java-Script

Tools: & Utilities: TOAD, DEVELOPER 6i, Oracle applications 11i

Operating Systems: UNIX (Sun Solaris, AIX, HP-UX),Windows 95/98/2000/XP/7/2003 Server

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Oracle Supply Chain Techno Functional Analyst

Responsibilities:

• Developed Auto Lockbox interface such that the receipt file from the bank is automatically imported into Accounts Receivables (AR)
• Data mapping for Open Invoices, Customer, Supplier in AP and AR with standard Interface.
• Was responsible for resolving the issues in Order-to-Cash (O2C) and (P2P) flow.
• Developed the AOL forms using the TEMPLATE.fmb and built the PL/SQL code as per the AOL coding standards.
• Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
• Extensively worked on Workflow builder in AR.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Designed and developed Order Import Interface to import legacy data into staging tables using SQL*Loader for loading Orders in Order Management (OM) module.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Developed PL/SQL scripts to load order data from external system to Supply Chain Module (OM) interface tables and OE base tables.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Designed and Developed Custom Pick Release process using standard Online Pick Release API.
• Worked with multi-org and multi-currency orders, set up value sets in Order Management (OM).
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Designed and Implemented Order Discount Hold system and developed reports for holds placed and released.
• Designed menus and responsibilities to different level of users in the organization.
• Helping the users test the application and testing from development point of view. Also was responsible for End-to-End Testing.
• Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
• Worked on PO Requisition Interface to load PO Requisitions from the legacy System into Purchasing Interface Tables.
• Developed Open Purchase Orders report using XML/BI Publisher.
• Customized Oracle standard reports like AP and AR Aging Reports, Open PO report and changed the output format to XML/BI Publisher and created new templates for XML/BI Publisher to display in PDF or excel format.
• Generated Order submission summary and Detail reports and Order submission summary by email Report using XML/BI Publisher.
• Developed custom reports such as Cancelled Invoices Report, Inactive Vendors Report, Inactive Vendor Sites Report and Top 10 vendor Report in Oracle Payables and Oracle Purchasing using Reports 10g.
• Responsible for Creating Value Sets In AOL.
• Worked with FND PROGRAM package to Register, Delete the Concurrent Programs from the backend.
• Developed a PL/SQL program that is scheduled to submit concurrent programs in a desired sequence as per the functional document. Used standard FND API’s.
• Defined and created new Flex fields, Segments and Value sets and used Data Loader scripts to load data into Flex fields, segments and Value sets.
• Modified existing RDF reports and created new reports.
• Modified existing reports by creating additional joins. And Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers.
• Created Trigger on AR PAYMENTS INTERFACE ALL to generate receipt number
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Used Form Personalization to zoom out sales order form from AR Transactions screen using Oracle Forms 10g.
• Proficient in generating Forms using Oracle Forms 10g meeting variety of Business needs including custom Reports. Modifying Forms to accommodate new functionality like adding Buttons and Texts.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.

Environment: OM,AR,PA,PO,AP, INV, BOM, WIP, HR, OTL,GL, Oracle 10g, Oracle R12 and Windows NT. Tools Used: SQL,PL/SQL, Toad, Forms 9i, Reports 9i, XML Publisher, OA Framework

Confidential, Washington DC

Techno Functional Analyst

Responsibilities:

• Prepared SQL queries to identify transactions from the transactions posted to General Ledger using GL JE HEADERS, GL JE LINES, and GL JE BATCHES tables.
• Traced the linked Sales Order and Customer Information by using the Invoice Number in Account Receivables (AR).
• Customers are maintained using the Trading Community Architecture (TCA).
• Created flat files using UTL FILE, DBMS utility package which displays federal GL entries grouped by code combinations.
• Developed the UNIX shell scripting programs to upload flat files to FSS GL System.
• Created Staging tables and inserted the GL entries for OBIEE reporting purpose.
• Developed custom interfaces for each system i.e., AR, COGS.
• For these systems, developed a process which loads general entries to the custom table and then created flat files. Created custom package which validates the data before loading.
• Debugged Issues related to flat file formats for different systems to be successfully received by GL system.
• Debugged production issues related to profit and loss matches.
• Loaded data using SQL*Loader.
• Developed FL Entries Custom report using Reports 10g.
• Involved in Analysis of Requirements document.
• Designed Technical Design documents and specifications.
• Created PL/SQL Packages, Functions, Anonymous Scripts, PL/SQL tables with bulk collections to trace back the source orders responsible for Federal GL Transactions.
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to existing Request Sets.
• Worked on documentation using Application Implementation Methodology (AIM) Standards.
• Created Design, Test Plan and Unit Test documentation.
• Worked on performance tuning for queries using Explain plan and analyzing indexes for standard oracle tables by running gather index statistics
• Worked closely with third party users while sending the files to GL system.
• Responsible for Unit and Integrating testing.
• Used the tool Kintana to move the above developed procedures to the other environments.
• Supporting the User Acceptance testing and Post Production support.

Environment: Oracle EBS R12 Financials (GL, AP, AR, FA).

Confidential, Irvine, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Major work involved in the development of RICE components as a part of large scale Oracle Implementation for this Manufacturing Company.
• Experience in adding and maintaining NLS languages, running Translation Synchronization Patch utility and applying Translation Synchronization Patches provided by Oracle.
• Authored, implemented and developed the functional, technical and test design for several interfaces between the legacy systems, I2 Planning System, Prochannel Customer Interface System and Oracle 11i as per the Oracle implementation standards.
• Developed an outbound interface to replicate the Customer data from Oracle 11i to Prochannel. This interface is a scheduled job which will replicate the any changes done on Customer in Oracle to Prochannel.
• Developed an Outbound and Inbound interface between I2 Planning System and Oracle 11i OM. The Oracle Scheduling is suppressed by a third party supply chain planning system called I2. So, all the current newly booked and change orders are made eligible for I2 to schedule through this outbound interface. The inbound interface will write back the schedule details from the I2 and will schedule the Orders in Oracle.
• There were 3 different planning jobs which were scheduled-Demand Fulfillment, Demand Planning and Master Planning.
• Customized (Extension) an Order type conversion program which would convert all backlog Disti Stocking Orders to Disti POP Orders (Non Cancellable Non returnable) when the Business decides to prune some items in Oracle and sells to Customers in a special price program.
• Developed an interface to import Debit Claims from Prochannel and created RMA Credit only Orders for these and then generate a Credit memo and update back to the Prochannel through EDI849.
• Developed a large scale complex OM-PLM-Pricing Interface which would be run for quarterly pricing program and daily pricing program. This interface would end date the old quarter pricelist, create a new quarter pricelist and import the old quarter pricelist items and manipulate according from the PLM actions-update, delete or insert. The daily pricing program would reprice the items based on the PLM action codes-update, insert, delete.
• Developed a Custom Concurrent Program (Extension) which would reprice all back log orders with the new price whenever a price change happens in the Pricelist for an item from PLM.
• Created a custom XML Publisher PDF report for Commercial Invoice Report and Invoice Report using XML BI Publisher to include the sales order, pricing data from OM, QP and customer details from TCA and include company logos and Terms and Conditions.
• Setup custom processing constraints (Extension) for several business scenarios using API and validation templates.
• Involved in the complete Pricelist data migration from the legacy system into the Oracle 11i (Conversion).
• Developed a custom interface between Oracle Pricelist and Prochannel.
• Was completely involved in business requirements gathering for development of customizations, reports and interface and helped in enhancements of these objects too based on user’s feedbacks and reviews.
• Supported production environments and users on a daily basis by responding to emergency requests (24x7)

Environment: - Oracle Applications 11.5.10.2, PL/SQL, SQL*Loader, TOAD, Forms 9i, Reports 9iSQL*Plus, Oracle 10g, OM, INV, AR, GL, CRM, TCA.

Confidential, Atlanta, GA

Oracle Techno Functional Analyst

Responsibilities:

• Impact analysis, design, development, implementation, testing, user training, management reporting, and Process improvement
• Solve application issues, fix application bugs, production support, and job monitoring, enhancements.
• Process improvement using Six Sigma methodology to reduce cycle time and quality of the IT processes for supporting day to day and month-end processes.
• User requirements gathering, design solution, development and testing.
• Performed all of the setups for Order Management (OM), Inventory and Process Manufacturing Org’s
• Reporting the project status to responsible managers on a daily and weekly basis.
• Daily tasks included attending meeting with other team managers.
• Supported production environments and users on a daily basis by responding to emergency requests (24x7)
• Developed Forms, Reports, Triggers, Stored Procedures, Packages, Scripts, Menus, Responsibilities, Profiles, Concurrent Programs, etc. to customize the application based on the requirements.
• Prepared System / Integration Test cases and carrying out Integration testing
• Supporting the users with the User Acceptance Testing (UAT)
• End-user training
• Trained and Assisted users during Rollouts
• Production Support for other plants which have been on Oracle already.
• Wrote data conversion procedure to convert existing legacy data into Oracle. Wrote both inbound and outbound interfaces

Environment: Oracle EBS 11.5.10 (Modules - OM, Shipping, Advance Pricing, Inventory, OPM, Purchasing, Costing (Average and Lot Costing) AR, AP and GL, SQL, PL/SQL Developer

Confidential

Techno Functional Analyst

Responsibilities:

• Enter and Process Requisition, For Items without Item Number, For recurring item or for an item after receiving the quotation, Enter and Process Requisition Using Templates.
• Using Requisition Template to create requisition, Management of Buyers Work load, Enter and Process Request for Quotations, Creating RFQ using Auto create, Print RFQ to Send to Suppliers.
• Enter and Process Quotations, Copying a Quotation from RFQ, Quote Analysis, Enter and Process Standard Purchase Order, Purchase Order without Item Number, Enter Blanket Purchase Agreement, Creating a Release against a Blanket
• Enter Contract Purchase Agreement, Manually Creating Contract Purchase Agreement, Referencing a Standard Purchase Order to Contract Purchase Agreement, Enter Planned Purchase Order, Manually creating Planned Purchase Order, creating Schedule Release against Planned Purchase order
• Define Supplier and Item Combination, Auto Create Purchase Orders, Standard Purchase Order
• Planned Purchase Order, Auto create Blanket Release
• Test modules (unit and integration tests) and perform User Acceptance Tests (UAT).
• Log, view, access, monitor, follow-up and close Technical Assistance Requests (TARs) online - Oracle MetaLink.
• Development of custom Reports in XML format for Excel (spreadsheets with format) directly from Oracle Applications
• Analyze current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs to meet the business needs of the company.
• Provided end user training, conducted user practice and additional business requirements sessions.
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.

Environment: Oracle 11i EBS (Modules - Inventory, BOM, General Ledger, OM and Shipping), Oracle 9i. Tools Used: SQL, PL/SQL, SQL Plus, PL/SQL developer.

Confidential

Techno Functional consultant

Responsibilities:

• Implemented Order Management, Advanced Pricing, Shipping Execution,
• Warehouse Management, Cost Management, Bills of Material, and Work in process, Purchasing and Manufacturing execution system.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.
• Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers; also trained users understand different application modules
• A new custom form that can be launched from Sales Order window has been designed and developed for entering various Pricing attributes at the time of order entry.
• Formulae creation for Freight calculator
• Setting up the MES for Ottawa Inventory organization
• Involved in configuration and implementation of order to cash and Procure to pay processes of 11.5.10 as per business requirements
• Setting up the Order Management, Warehouse management, Shipping, Inventory and Cost Management
• Preparing the BP40, BP80, BR100, MD50 and CV40 Documents (AIM Methodology)
• Setting up the cycle count using the applications and Mobile
• Exception cycle counting tasks generation using the material transaction reasons
• Automatic replenishment using the Min-Max program
• Two step replenishment for move order transfers between sub inventories
• Task type assignment based on the equipment and resource combinations
• Kanban replenishment using mobile applications
• Put away rules based on item categories configuration

Environment: Oracle 11i EBS (Modules - Inventory, BOM, General Ledger, OM and Shipping), Oracle 9i. Tools Used: SQL, PL/SQL, SQL Plus, PL/SQL developer.