SUMMARY

• Over 8 years of experience in Oracle Applications (EBS) Techno functional.
• Oracle apps Techno - Functional Consultant over 8 Years of experience, having good noledge and proven expertise inOracle eBusiness Suite, Financials, Manufacturing, Procure to Pay, Order to Cash, Distributions and in Supply Chain Modules 11i/R12(12.1.3).
• Expertise wif Oracle’s E-Business Suite R12 and 11.5.10.
• Expertise in developing and customizing teh RICE components.
• Expertise in development and customization of Reports, Interfaces, Conversions, Workflows and XML Publisher
• Expertise in Oracle Apps Procure to Pay Cycle.
• Expertise in Oracle Apps Order to Cash Cycle.
• Expertise in using teh public APIs of OM, PO,Inventory,HR, Project Accounting and Project Billing
• Testing experience in Oracle Apps Order to Cash and Procure to pay cycles.
• Expertise in HP ALM.
• Expertise in modules (technically) of Oracle Apps 11i like PO, OM, AR,GL, FS and Install Base.
• Expertise in teh integration of Oracle Projects wif external systems using AMG
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using teh tools such as EXPLAIN PLAN and use hints wherever required.
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• Involved in Oracle database 10g/11g RAC administration on OCFS, GPFS, ASM file systems.
• Expertise in installing, Maintaining and Administering Oracle Applications 11i/R12 Instances
• Knowledge in teh setup of Project Accounting, Project Costing, Project Billing
• Hands on experience on data import and export using SQL*Loader scripts and UTL scripts.
• Experience in raising Severity TAR and conducting OWC sessions wif Oracle support to overcome loss of service to production instance.
• Experience in developing and testing reports by using Oracle reports 6i, BI publisher and Oracle Discoverer.
• Experience in writing database packages, procedure, functions and triggers using PL/SQL.
• Experience in writing technical documents, designing mapping documents and AIM methodology.
• Used development tools Oracle Forms, Oracle Reports, Jdeveloper, TOAD, putty.
• Experience in working wif ITG Kintana/ HP PPM change management and migration tool.
• Experience in creating install scripts and deploying them in UNIX.
• Used revision control tools: PVCS, Microsoft VSS.
• Working experience on ETL tool Informatica9.5.1.
• Strong Informatica development experience and good noledge of various transformations in Informatica.
• Having good noledge on OBIEE 10.1.3.2

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11.5.10, 11.5.9

Databases: Oracle 9i/10g/11g

GUI: D2K (Forms 6i, Reports 6i)

Languages: C, C++, PL/SQL, and SQL

Tools: TOAD, FTP, Mercury Quality center, HPSD, Remedy, Kintana

Operating Systems: Win NT, Win 95, Oracle Enterprise Linux 3/4/5,UNIX

Middleware: XML Publisher, Informatica 8.X

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle Apps Developer

Environment: LINUX, Oracle Applications R12.1.3

Responsibilities:

• Developed PL/SQL stored procedures to process teh data.
• Developed Purchase Orders open Inteterface to create teh PO’s in Oracle.
• Worked on Purchase requisitions open interface.
• Worked on Sales Order API’s to process teh data.
• Worked on Auto Sourcing program to fulfill teh Order.
• Worked on PO Print XML Publisher report.
• Worked on Consolidated Billing Invoice (CBI) XML Publisher report
• Worked on Oracle Projects (Billing and Costing) API’s to Interface teh data.
• Create SQL Queries for executing backend testing of teh database.
• Create update modify database procedures and packages.
• Created tables, views, db-links, PL/SQL packages, functions and procedures as required by teh design.
• Worked on Projects Budgets API’s.
• Worked on new CR’s as per teh business requirements.
• Involving in ME process.
• Participating in Business requirement meetings.
• Closely work wif Analysts and Business teams.
• Involved in UAT testing.
• Developed Interfaces to process teh data.
• Troubleshooting Oracle Application & database problems
• Test scripts are written and tested initially to throw up teh bugs.
• Prepare high level Test Scenarios across all Business Areas, including external systems and tested teh functionalities of modules General Ledger.
• Worked wif applications DBA for patch management and database administration. Strong Patch Management is critical to any R12 Upgrade.
• Developed Sales order Interface using oracle API’s.

Confidential, San jose

Oracle Apps Techno-functional Consultant

Responsibilities:

• Developed Interface programs to load teh Purchase requisitions and Purchase Orders data from Oracle ERP to EDW system using PL/SQL packages.
• Developed Interface programs to load teh Bookings and revenue data from Oracle ERP to EDW system using PL/SQL packages
• Worked towards Future business flows, Identification of Gaps, Workarounds in order to provide an Integrated Procure to Pay (P2P) business flow
• Supporting various custom developed jobs which are loading data from Oracle applications database to NCR database tables.
• Customized Packslip, Packlist, PO Print report, AP Invoice Print Report, AR Aging Report and transformed teh output to custom design using XML/BI publisher.
• Worked towards developing and troubleshooting XML publisher reports.

Confidential, Houston, TX

Oracle Apps Techno-functional Consultant

Responsibilities:

• Involved in requirements gathering/process mapping
• Prepared MD070, MD200 documents
• Defining teh project types
• Defining teh project templates
• Defining teh project expenditure categories, Events.
• Defining DFFs at PO header level
• Involved in teh project setup
• Involved in teh Oracle Projects integration wif external system Interfaces
• Developed on hand in bound interface/wrappers to create projects, tasks, agreements, events, budgets from external system FSP using AMG
• Developed on hand in bound interface to create Project based POs from external system FSP using Standard interface
• Developed on hand interface to create Project based Requisitions from FSP application.
• Developed on hand out bound interface/wrappers to oracle projects, oracle field services, Oracle Purchasing and Requisitions
• Developed interface to create Service Requests in Field service module from FSP Application
• Developed on hand PO receiving interface.
• Developed out bound interface to send teh Requisition and Purchase order details under teh Project.
• Worked in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters which are extensively used in teh process of development

Confidential, Atlanta, GA

Oracle Apps techno-functional and ETL Developer

Responsibilities:

• Requirements gathering.
• Customized teh existing wrapper wif additional features and functionality as per teh business requirements.
• Developed on hand in bound interface/wrappers to create projects, tasks, agreements, events, budgets from external system using AMG.
• Developed on hand in bound interface to create Project based POs from external system using Standard interface.
• Developed on hand out bound interface/wrappers to oracle projects, oracle field services, Oracle Purchasing.
• Developed Project expenditures interface which loads data from kronos (Legacy system) system to Oracle System.
• Developed Sales order Interface using oracle API’s.
• ETL Load
• All Project templates, Customer infromation, Turbine Information etc will be extracted from ERP using ETL to teh GOET. Assuming all data in GOET will match dat in ERP.
• Developed Informatica Mappings, Mapplets and Transformations for extraction of data from existing systems (Oracle ERP) to teh new system GOET (oracle).
• Developed informatica Mappings to load teh incremental from Source system to BDW system.
• Used Transformations like Source qualifier, Aggregator, Expression, Rank, Router, Filter, Update Strategy, Joiner and Lookups.

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Developed Concurrent programs for updating Promise Date and Schedule ship dates based on business requirements using OM APIs.
• Designed MD070 and MD200 for OM Enhancements.
• Prepared Test cases.
• Developed Short Cycled SO Lines Notification Alert.
• Developed Alert for Request Date Blank records.
• Create SQL Queries for executing backend testing of teh database.
• Create update modify database procedures and packages.
• Created tables, views, db-links, PL/SQL packages, functions and procedures as required by teh design.
• Create location information using TCA API for existing parties.

Confidential

Technical Consultant

Responsibilities:

• Development of New Reports
• Registration of Reports wif Oracle Applications.
• Move teh Concurrent programs from one instance to different instances using FND LOAD.
• Upload employees in to oracle apps instances.
• Create customers in oracle apps instances.
• Goods Received Inward notes.
• Developed on hand quantity XML Publisher report.
• Developed pick slip report.
• Developed out bound interfaces
• Developed Item conversion to load flat file data in to oracle tables
• Developed PO Conversion to load flat file data in to oracle tables
• Prepared test cases
• Upload items in to Oracle apps instance using Data loader