SUMMARY:

• Having 10 years of experience as an Oracle Applications Techno Functional Consultant (E - Business Suite 11i & R12) with expertise in Oracle SCM Modules (OM, INV and PO) and knowledge in Financials modules (AP and AR), Manufacturing Modules (BOM and WIP).
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Good exposure on Order to Cash (O2C), Procure to Pay (P2P) business flows.
• Involved in R12 SCM Implementation of the Procure to Pay and Order to Cash.
• Worked on developing and customizing reports as per client requirement using XML/BI Publisher and Reports Builder.
• Worked on Oracle Application Framework (OAF), which includes customization and personalization.
• Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
• Substantial development experience in creating stored procedures, Packages, Functions, Indexes and Views.
• Experienced in Month end closing activities.
• Validate the Back Orders and Replenishment Orders in Oracle Order Management.
• Good experience in creating Unit Test documents.
• Review and sign off on Business Requirements, Functional Design and Testing documents for scheduled releases.
• Provided support for SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Support.
• Ability to support and manage mission critical business applications 24x7
• Extensively worked on Application Implementation Methodology (AIM) documents like MD50, MD70, MD120 and BR100
• Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD.
• Good Knowledge on ALERTS.
• Exposure on R12 New Features and up gradation activities.
• Good experience in Data loader and ETL Tools like Informatica.
• Expertise in SQL, PL/SQL, Reports Design and Development, Form Personalization, FND loader, Alerts, Shell Script, SQL Loader, Stat Tool, BMS remedy tool, SVN, Migration tool (XPatch).
• Proficient in writing SQL*Loader scripts and UTL FILE packages
• Exposure to UNIX shells scripting.
• Expertise in developing and customizing Reports and Forms in Oracle E-Business Suite R12.
• Flexibility and Adaptability in regards with new technologies.
• Good Written, Verbal Communication Skills and Analytical Skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i and R12

Modules: SCM Modules, awareness in AR,AP and CRM Modules

Languages: SQL, PL/SQL

Operating System: Windows and Unix

RDBMS: Oracle 8i, 9i,10g,11g

Reporting Tools: Reports6i/10g, XML Publisher

BI: OBIEE and EIS Reports

ETL: Informatica and ODI

Tools: TOAD, PUTTY, Win SCP, FTP, SVN, SQL * Loader, Data Loader, D2k (Forms, Reports), XML Publisher, Web ADI and discoverer, Oracle Forms and Reports 6i and 10g, OAF and Workflow

PROFESSIONAL EXPERIENCE:

Lemonade, Dallas TX

Apps Technical Consultant

RESPONSIBILITIES:

• Responsible as a primary Technical Lead/owner for Order Management (OM)and Inventory(INV) Modules and developed various customizations in OM and Inventory(INV)
• Expertise in design database model for new RMA custom application.
• Interacting with ADF developers and business user for requirement gathering. contributed technical insights and ideas to ADF developers on new RMA Screens as par of project design
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Developed new packages to meet business requirements.prepared test case documents.
• Interacted with Middleware team to build SOAP/WSLD services to get data from other environment.
• Application Performance Tuning for Sql and PL/SQL code. AWR reports knowledge.
• Creating Design for Pl/sql Packages, Function, Procedure, Views, Triggers, Database Design. Prepare technical specification. Complete the design review.
• Modify existing module Packages, Functions depend on Business Requirement.
• Running execution plan for analysis and improving performance using Hints.

ENVIRONMENT: Oracle Applications R12 SCM Modules (Order Management (O2C) and Inventory), SVN, SQL, PL/SQL,SQL Devloper, TOAD,SOAP,WSDL

Confidential, Orlando, FL

Oracle Apps Technical Consultant

RESPONSIBILITIES:

• Responsible as a primary Technical Lead/owner for Purchasing, Order Management (OM)and Inventory(INV) Modules and developed various customizations in OM and Inventory(INV)
• Order Management(OM) - Price List conversion, Custom Sales Order Import, Packing Slip report, Pick slip reports report using XML/BI Publisher tool and EIS reports
• Customized various workflows like Requisition Approval Workflow, Order Line Workflow as per user requirements
• Achieved custom functionality in OM Sales Order form through Forms personalization
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Trouble shooting Production issues, Testing and migrated to UAT.
• Expertise in Interact with END USER’s in gathering new requirements and Trouble shooting issues.
• Created and customized reports and Bursting using XML Publisher/BI Publisher
• Create and define template and data definitions for Open Purchase Order report
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR)
• Participating in Business Requirement Documents review sessions and approvals
• Providing details of the requirement to DEV team and discussing impact analysis
• Creation of FND objects like Value Sets, Flex fields, Responsibilities, Custom Menus, Request Groups, Profile Option Setups

ENVIRONMENT: Oracle Applications R12 SCM Modules (Purchasing (P2P), Order Management(O2C) and Inventory), XML Reports, EIS Reports, Migration tool (XPatch), SQL, PL/SQL

Confidential, Irving, TX

Oracle Apps Techno Functional Consultant

RESPONSIBILITIES:

• Participated in Post Production hyper-care support
• Developed Interface of Sales Orders Import in OM after actively participating in the preparation of the conversion mapping documents.
• Performed data-validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Developed table scripts for custom tables, synonyms, indices, sequences and other database objects required for the AR conversion.
• Extensively worked on AR interface tables like RA INTERFACE LINES ALL and RA INTERFACE DISTRIBUTIONS ALL to stage the data before the auto-invoice picks the data for loading.
• Have worked on standard Oracle API's like AR INVOICE API PUB and AR RECEIPT API PUB to load the invoices and receipts information respectively.
• Developed PL/SQL Packages, Procedures, and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications.
• Used the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Interaction with users, senior department managers and senior functional consultants to understand the processes and process validations for various modules
• Converting 6i Reports into Oracle 10g Reports and applying MOAC changes.
• Created and customized reports using XML Publisher/BI Publisher
• Understanding existing customization in the system and doing impact analysis of Custom CEMLI objects due to R12 functionality changes.
• Involving on up gradation of various packages, procedures and functions by making the R12 necessity changes like replaced the 11i obsolete tables.
• Working on up gradation of form personalizations.
• Retrofitted Oracle Event Alerts that are based on 11i tables.
• Testing each customization to ensure the desired functionality is fulfilled.
• Preparing test case documents.

ENVIRONMENT: Oracle Applications R12 SCM Modules (Purchasing (P2P), Order Management (O2C) and Inventory), Financials (AR, AP, FA and GL), PA, HRMS and Payroll, SQL, PL/SQL, Forms 6i, Reports 6i, SSH (UNIX), Windows XP, Workflow Builder.

Confidential

Oracle Apps Technical Consultant

RESPONSIBILITIES:

• Involved in gathering of new requirements and to provide estimations for new requirements received
• Trouble shooting the issues related to repository models and report development thus suggesting the feasible design solutions
• Responsible in reviewing the Design Speciation documents for deployments
• Successful in implementing a new process/techniques to generate reports
• Have used several report views like pivot, gauge, ticker and different charts like line, Pie in various reports.
• Have used guided navigation to regional sales data from U.K.
• Followed Oracle templates for documentation in preparation of high-level and detailed level design documentation, accurately mapping requirements for report deliveries
• Developed new XML Reports
• Implemented the caching strategy according to client data load frequency
• Was responsible for performance improvement of the reports by using various strategies in both the database and RPD like Indexes, hints in physical layer, materialized views and caching
• Responsible in migrating web catalog from one server to another server by using catalog manager
• Extensively worked on various transformations like Aggregator, LOOKUP, Sequence, generator, filter, normalizer, Source qualifier, router, joiner and update strategy
• Responsible in doing Unit Testing, Updating bug tracker
• Configured Integration of OBIA with EBS environment using SSO

ENVIRONMENT: Oracle 11i Apps, OBIA 7.9.6.2 (OIBEE 10g),, SQL, PL/SQL, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher, OM,PO,HRMS, SQL Developer, Toad, EBS R12.

Confidential, Detroit, MI

Oracle Apps Technical Consultant

RESPONSIBILITIES:

• Successfully installed OBIEE 10g (10.1.3.4.0 )
• Gathered requirement from client and prepared ‘Report Specification’ logs
• Developed successfully PO & Inventory module reports
• Completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Worked on Repository and Session Variables
• Maintained Specification/Issue Log track sheets to get clarification on the requirements from the client
• Created OBIEE environment for Development, QA and Production environment
• Generated Reports and Dashboards by using Report features like pivot tables, charts and view selector
• Created Dashboards with global prompts, column selectors, navigation and automatic drill down

ENVIRONMENT: Oracle 10g, EBS11i, OBIEE 10.x, Oracle, SQL, TOAD, SQL, PL/SQL, PO, HRMS, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher

Confidential

Software Engineer

RESPONSIBILITIES:

• Supporting the Oracle 11i ERP Solutions
• Handling Several Technical Issues
• Creating Several CSR (Custom Change Request) and processing those till to PROD by several levels of user validations
• Modified several custom reports (RDF, Discoverer and XML) and Form Personalization and Custom.pll with Additional Functionality
• Modified custom components
• Creating Oracle SR’s for Oracle Standard Issues
• Support Related Development for All Modules(INV,PO,OM,AR,AP,WIM,BOM and GL) of Confidential Production Issues
• Supporting technical issues logged in Unisys peregrine and BMC Remedy for Confidential End Users
• Supporting the Month / Quarter / Year end closing activities by generating various reports needed by the users
• Defining Concurrent Programs, Executable, Value Sets and Display Profile values
• Prepared Technical Design Documents (MDO70) and Migration Documents (MD120)