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,WIP 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.
• 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.
• Experience in Onsite and Offshore model.
• 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, Accounts Receivable, Accounts Payable, Purchasing, Order Management, Fixed Assets, Inventory, Sales Online, Application Object Library, Flex Fields, TCA, CRM, Service Contracts, Service Fields, SysAdmin, Install Base.

Languages: SQL, PL/SQL, C, C++, core Java, Unix Shell Scripting.

Web Technologies: HTML, Java-Script

Tools: & Utilities: TOAD, DEVELOPER 6i, SQL LOADER

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

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Oracle Techno Functional Analyst

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked on various modules (AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables).
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Developed AP,AR,GL,PO reports using discoverer which includes PO requisition reports, AR sales profit report with cost of goods, GL Summary Report.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator (FSG).
• Involved in writing interface program to load the data from external systems into Oracle purchasing (PO) interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Developing PL/SQL code to obtain the required functionality.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry forms.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Worked on items in Inventory.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.
• Good Experience in Onsite and Offshore model.

Environment: AR, AP, GL, PO, Oracle 11i, Oracle R12 and Windows NT.

Tools: Used: SQL, PL/SQL, Toad, Forms 9i, Reports 9i, UNIX, Shell scripts.

Confidential, Washington DC

Techno Functional Analyst

Responsibilities:

• Prepared SQL queries to identify transactions from the transactions posted to General Ledger.
• 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.
• Supporting the User Acceptance testing and Post Production support.
• Experience in Onsite and Offshore model.

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

Tools: Used: Reports 10g, SQL, PL/SQL, SQL Loader, TOAD, UNIX and Windows.

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) and had experience in Onsite and Offshore model.

Environment: - Oracle Applications 11.5.10.2, PL/SQL, SQL*Loader, TOAD, Forms 9i, Reports 9i, SQL*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.