SUMMARY:

• Having 9+ Years of total Information Technology Industry experience in Oracle Applications (11i /R12), using Business Intelligence Applications like OBIA 7.6.9.2, OBIEE 10g & 11g, EIS Reports with excellent written and oral communication skills
• Extensive Technical and Functional expertise in Oracle Applications R12/11i Financial modules GL, AP, AR, SLA, CM, FA, OM, INV, and Purchasing modules in Multi - Org environment.
• Hands-on experience implementing processes like P2P (Procure to pay) and OTC (Order to Cash)
• 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
• Having Good knowledge on Architecture of Oracle Business Intelligence Enterprise edition 10g/11g.
• Having good exposure in data warehousing administrator Console (DAC)
• Expertise in developing reports with drill-down & drill-across capabilities using global Data Warehousing & local Filters where and in which applicable
• Good Knowledge of Data Warehousing concepts and Dimensional modeling like Star and Snowflake schema
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Strong familiarity with AIM methodology in creating MD-50, MD-70, MD-120 and TE-20 documents throughout multiple Projects.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Suite.
• Worked with the business functional areas to research and identify the best technical solution to support business processes.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder, Oracle Alerts, and XML Publisher.
• Good experience in XML/BI Publisher, which includes working on report development objects like Data templates and RTFs
• Expertise in SQL, PL/SQL, Reports Design and Development, Form Personalization, Alerts, Shell Script, SQL Loader, Stat Tool BMS remedy tool.

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 : ODI

BI : OBIA,OBIEE,EIS Reports

PROFESSIONAL EXPERIENCE:

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)
• 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 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, Order Management and Inventory), EIS Reports, Migration tool (XPatch).

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 APIs 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 upgradation 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, Order Management and Inventory), Financials (AR, AP, FA and GL), PLSQL, 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 Developer, Toad, EBS R12

Confidential - Detroit, MI

Oracle Apps Technical Consultantz

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, Oracle 9i, Oracle Forms, reports and Oracle XML Publisher

Confidential

Oracle Apps Technical Consultant

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)