SUMMARY

• Having 9+ Years of total Information Technology Industry experience in Oracle Applications (11i /R12), using Business Intelligence Applications like OBIEE 10g & 11g, EIS Reports with excellent written and oral communication skills
• Expertise in System Designing, planning, writing source code, Testing and Implementation of developing application. Energetic self - starter with excellent analytical and organizational skills. Excellent problem solving, organization and leadership skill.
• Extensive Technical and Functional expertise in Oracle Applications R12/11i Financial modules GL, AP, AR, SLA, CM, FA, OM, INV,, Purchasing, HRMS and Payroll modules in Multi-Org environment. Hands-on experience implementing processes like P2P (Procure to pay), OTC (Order to Cash) and Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle General Ledger, Accounts Payables, Accounts Receivable, Fixed Assets, Purchasing, Order Management, Inventory modules.
• Experienced in Design and Develop OBIEE Metadata (.rpd) and Dashboards/Reports using 10.x and 11.x
• Having Good of experience in Design and Develop EIS Reports
• Good Knowledge of Data Warehousing concepts and Dimensional modeling like Star and Snowflake schema
• Sound knowledge of Database design, Data Modeling. Data warehousing- ETL process and familiarity with AIM methodology in creating MD-50, MD-70, MD-120, BR100 and TE-20 documents throughout multiple Projects.
• Proficiency with tools used to support Oracle Applications development includingPL/SQL, Forms, Reports, Workflow Builder, Oracle Alerts, and XML Publisher which includes working on report development objects like Data templates and RTFs
• 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).

TECHNICAL SKILLS

Application Technology: Oracle Applications R12 and 11i

Modules: GL, AP, AR, CM, FA, INV, OM, PO, iExpenses and iProcurement

Languages: SQL / PLSQL

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

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, Workflow and GL Wand

Operating Systems: MS Windows 2000,Windows server 2003, Unix, Linux and Solaris

Document tools: MS Office

ETL: Informatica and ODI

BI: OBIA,OBIEE,EIS Reports

PROFESSIONAL EXPERIENCE

Confidential - Winston Salem,NC

Oracle 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.
• Preparing Technical and Functional Design documents (MD 70s and MD 50s)
• Developed new packages to meet business requirements.prepared testcase documents.
• Interacting with ADF developers and business user for requirement gathering.
• 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

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 reportsreport 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)
• Created and customized reports 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 inAccount 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), EIS Reports, Migration tool (XPatch), SQL, PL/SQL

Confidential, Irving, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Post Production hyper-care support
• DevelopedInterface of Sales Orders Import in OMafter actively participating in the preparation of the conversion mapping documents.
• Performed data-validations by writing PL-SQL package into theOrder Import (OE) headersandline interface tablesand then toOEbase 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.
• 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 personalization’s.
• 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),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
• 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.