SUMMARY:

• 9 Years of experience in Software Development, which includes Oracle e-Business Suite R12/11i.
• Oracle E-Business Suite expertise in developing RICE components in Financial Modules AP, AR and GL ,SCM Modules INV, OM, PO and Manufacturing Modules BOM, WIP
• Good experience in Designing Reports by using Oracle Reports 10g/9i/6i/4.5, BI/XML Publisher 10.1.3.2.
• Designed user interfaces with Forms 10g/6i/4.5.
• Strong in Applications Object Library Concurrent programs registration, Value Sets, Profiles, form registrations etc , System Admin tasks.
• Experienced in Using Oracle Applications standard API's as wells as writing custom Oracle API's and using it in Oracle Applications Interfaces/Conversions.
• Experience in working with AIM methodologyand is very proficient in working with MD050, MD070.
• Extensive experience in Application Development using Forms 6i and Reports 6i in UNIXand Windows environment.
• Extensively used QUEST Tools TOAD, Navigator , SQL PLUS, SQL Loader, PL/SQLdeveloper utilities such as UTL FILE.
• Experience with Performance Tuning for Oracle RDBMS.
• Production support, bug fixing and enhancement experience
• Expertise in Shell Scripting and debugging.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Oracle Tools : Oracle Forms 10g/9i/6i, OracleReports10g/9i/6i,SQL PLUS,SQL Loader,

SQL Developer, Developer 2000, imp/exp,Discoverer 10g,XML Publisher,

BIPublisher 10.1.3.2

E-Business suite : Oracle E-Business Suite Release: R12 12.1.1, 12.0.6, 12.0.4 and

11i 11.5.10, 11.5.9, 11.5.8

Application Modules : Inventory INV , Purchasing PO , Order Management OM , Accounts

Payables AP , Accounts Receivables AR , General Ledger GL , Bill Of

Material BOM , Work In Process WIP

Programming Languages : C, C , C , JAVA, PL/SQL, XHTML, JavaScript, UNIX Shell Scripting.

Tools and Utilities : Putty, Rational Clear Case, Clear Quest, export/import,Data pump, SQL

Loader, TOAD, SVN, QTP.

Operating systems : Sun Solaris 2.6/2.7,HP-UX 10.20, UNIX, Linux, Windows 2000/2003.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in development of custom Interfaces, reports and forms for AP, AR, GL,OM, INV, Shipping, Advance Pricing, PA, PO and BOMmodules.
• As a technical consultant, responsible for Communicating with the end users, Requirements analysis, Preparing Technical Design documents, Coding, Unit Testing,Change Management and support of the Customizations and application extension.
• Involved in Applications Object Library Concurrent programs registration, Value Sets, Profiles, form registrations etc. and System Admin tasks.
• Worked on SQL Loader to load data into oracle database from flat files.
• Hands on experience in writing code for program units in forms using Oracle Form Builder.
• Developed Customer Conversion, Supplier Conversion and Item Conversion Programs.
• Developed Program to Load Items to Price List using Advance Pricing module.
• Developed Ship confirm delivery program using Shipping API's.
• Developed Program to create budget using Project Accounting API.
• Developed Sales order Report and INV Warehouse Replenishment Report for replenishing their primary pick locations.
• Customized PO output for communication report using BI Publisher.
• Performed Forms Personalization for Subinventory Transfer Personalization Extension.
• Worked on Oracle's FNDLOAD utility for transferring/migrating Concurrent Programs, Request Sets.

Environment:Oracle E-Business Suite R12, Oracle 10g, Oracle Forms 10g and Reports 10g, BI Publisher, SQL Plus, TOAD, XML, SQL Loader, PL/SQL, PVCS, Putty, WinSCP, Windows7.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed and customized interfaces, reports, formsin Financial Modules AP, AR, GL , Interacted with end users to gather requirements and Draft specifications for development Phase.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR.
• Developed the Control file and shell scriptingfor payments/conversion program Loader Program to load external data from flat files.
• Invoked standard API's within custom packages for creating and updating receipts.
• Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
• Extensively worked on Oracle Lockbox Processing AR Lockbox to efficiently process the data received from the bank.
• Written an API for Converting the Invoice Payments AP and was able to convert all the Historical Invoice Payment History into Production.
• Responsible for running the Open Interface to import data from lockbox interface tables into the base tables.
• Developed an interface program to load data from custom tables tointerface tables and then created journals into Oracle General Ledgeras per business requirements.
• Post-production troubleshooting and analysis of GL, TCA, and tax issues with Contracts AR Reports .
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Involved in forms personalization.
• Involved in Creating/registering Concurrent Programs, Request Sets, Value Sets and Lookups.
• Involved in Transmission formats setup for AR lockboxes.
• Extensively worked on Oracle's FNDLOAD utility for transferring/migrating Concurrent Programs, Request Sets and lookups.

Environment: Oracle E-Business Suite R12, Oracle 10g, Oracle Forms 6i/10g and Reports 6i/10g, XML Publisher, SQL Plus, TOAD, SQL Loader, PL/SQL, Putty, WinSCP, SVN, Windows XP/2000.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed Load items to Price List and Assign the price list to the customer Interfaces for INBC-HCLL Inland Northwest Blood Center oracle billing Process.
• Responsible for gathering technical requirementswith the end users, Requirements analysis, Design MD070 , Coding, Testing,Change Management and support of the Customizations and application extension.
• Created Stored Procedures, functions, Data base triggers, Packages, Views and SQL Scripts based on business requirements.
• Developed concurrent programsand Value setsforLoading items to price List and Assign the price list to the customer.
• Created several Business Areas in Discoverer Administratorand based on the Business Areas, created many number of discoverer workbooks Ship items report, BSI AP Supplier Report and BSL Report card/ARINVGL report etc.
• Developed new reports and customized existing reports using Oracle Report Builderas per requirements formatting, addition/deletion of columns, formulas etc in OM, INV, AP, AR, GL,PO andAdvance Pricing.
• Worked on SQL Loader to load data into oracle database from flat files.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Developed AR Invoicing Report using XML Publisher. Created Data definitions and Templates in the XML Publisher Administrator.
• Modified custom Forms using Oracle Forms Builder.

Environment:Oracle E-Business Suite 11i/R12, Oracle 10g, Oracle Forms 6i/10g and Reports 6i/10g, Discoverer 10g, XML Publisher, SQL Plus, TOAD, SQL Loader, PL/SQL,Putty, WinSCP, Windows XP/2000.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed Event/Exhibition reports and also customized standard oracle reports according to business requirements, using Oracle Report Builder.
• Developed Event Payment Report,Event Detail report and Event Summary report using XML Publisher. Created Data definitions and Templates in the XML Publisher Administrator.
• Involved in the design, developmentof Event/Exhibition Setup Form using Oracle Forms 6i
• Developed concurrent programsand involved in setups.
• Created Value sets for the event setup show codes and used as parameters in the concurrent programs.
• Responsible for implementation of RICE Reports, Interfaces, Conversions, Extensions elements in Oracle EBS 11i environment.
• As a technical consultant, responsible for Communicating to the end users, Requirements analysis, designing Specifications, Coding, Testing, Change Management and support of the Customizations and application extension.
• Involved in design of AIM Application Implementation Methodology document MD070.
• Oracle data loading into oracle database from flat files using SQL loader.
• Worked in Data Conversions between Legacy systems and Oracle Applications in the areas of AP, AR and GL.

Environment:Oracle E-Business Suite 11i, Oracle 10g, Oracle Forms 6i and Reports 6i, XML Publisher, SQL Plus, TOAD, XML, SQL Loader, PL/SQL, Putty, Ipswitch WS FTP Professional, SVN, Windows XP.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in development of custom reports and forms for AP, AR, GL,PA, Property Manager, OM, INV, BOM and WIP modules.
• As a technical consultant, responsible for Communicating with the end users, Requirements analysis, Design MD070 , Coding, Testing,Change Management and support of the Customizations and application extension.
• Involved in Applications Object Library Concurrent programs registration, Value Sets, Profiles, form registrations etc. and System Admin tasks.
• Designed and Developed Interface 'Job Dispatch to Project Accounting' to import Employee OT/DT numbers based on State and region.A custom API is developed to calculate OT/DT based on State Location.
• Developed a New Formto display the imported calculation and provided user the ability to add missing Locations and perform OT/DT calculations.
• Enhanced the 'Folio Grouping' process to utilize Govt mandatory billing numbers for countries Chile, Peru and Colombia. Modified the Billing calculations to group the each country's transactions based on Folio numbers.
• Modified Folio Grouping Rules and calculations in 'Folio' Form. Implemented this form in the three new Operating Units.
• Enhanced 'Lease Abstraction' Oracle Form to add new fields.
• Hands on experience in writing code for program units in forms using Oracle Form Builder.
• Developed a new Report to provide 'Lease Abstraction' details by Country
• Worked on SQL Loader to load data into oracle database from flat files.
• Involved in production support to fix the bugs for the various Applications.

Environment:Oracle E-Business Suite R12, Oracle 10g, Oracle Forms 10g and Reports 10g, BI Publisher, SQL Plus, TOAD, XML, SQL Loader, PL/SQL,Quality Center, Putty, WinSCP, Windows XP/2000.

Confidential

Oracle Apps Techno FunctionalConsultant

Responsibilities:

• Developed reports from scratch and also customized standard oracle reports according to business requirements, using Oracle Reports Builder.
• Supply Chain reports for Order Management Inventory MRP Purchasing and Cost based on business requirements.
• Worked as team member for designing the data migration plan from the legacy system to Oracle Applications, and coordinated with the other developers for preparing test plans, Reconciliation reports and detailed design.
• As a technical consultant, responsible for Communicating to the end users, Requirements analysis, Designing Specifications, Coding, Testing, Change Management and support of the Customizations and application extension.
• Developed various reports XML/BI Publisher using Project Accounting.
• Involved in design of AIM Application Implementation Methodology document MD070.
• Involved in developing/migrating existing/new reports in Oracle Apps.
• Worked in Data Conversions between Legacy systems and Oracle Applications in the areas of Inventory, Order Management, Bills of Material.
• Involved in postproduction support and enhancements of RICE objects in all phases of the project.

Environment:Oracle E-Business Suite 11i/R12, Oracle 10g, Oracle Forms 6i/10g and Reports 6i/10g, BI Publisher, SQL Plus, TOAD, XML, SQL Loader, PL/SQL,Quality Center, Putty, WinSCP, VSS, Windows XP/2000.

Confidential

Oracle Technical Consultant

Responsibilities:

• Configured and built the database objects, packages, storedprocedures, and functions and extensively worked on exception handling for the business scenarios for the huge implementation of tracking the Product and Sales information for the client.
• Developed the conversion programs by creating packages, reconciliation programs, staging programs, scripts for Item, Item costs for data conversion from one entity to another entity.
• Developed Conversion Programs to load all the Sales Orders data using the OM APIs.
• Developed PL/SQL packages to load data into interface tables for Item Assignment, Item Cost Update, on hand Conversion, AR Invoice Conversions.
• Setting up an Event Alert when an employee is terminated to send email notification to his immediate manager.
• Developed Open Purchase Orders report using XML Publisher.
• Performed Performance Tuning of the AP Invoice Extract Program.
• Worked with Oracle's proprietary Application Object Library AOL/FND and Custom Libraries in conjunction with Oracle version 11i applications. Understand and know how to apply workflow.
• Developed various reports for different modules with and without XML templates Commercial Invoice, AR Aging, Purchase VAT Register, Sales VAT Register etc
• Performed the performance tuning, optimization of SQL queries, normalization and De-normalization, indexing of tables for the speed and the execution of reports.
• Highly experienced in writing the Control files and shell scripting for conversion program and loading external data from flat files using SQL Loader.
• Extensively worked on Cursors, PL/SQL Tables on TOAD in the interface development and used exceptions wherever necessary to improve the performance.
• Worked on FTP in the UNIX environment to import and export the data files and place the scripts in the appropriate locations so that they could be executed with Shell scripts.
• Developed reports using Oracle Reports 10g/6i.
• Hands on experience in writing code for the triggers in the forms by using Oracle Form Builder. And Created master detail block in Oracle Applications.
• Hands on experience in registering new forms in Oracle Applications
• Involved in creating MD070 design documents for Interfaces, Forms and Reports
• Defects were tracked, reviewed, analyzed and compared using Quality Center.

Environment: Oracle E-Business Suite 11i, Accounts Payables, Accounts Receivables, Order Management, Purchasing, Inventory, Oracle 10g, Oracle Reports 6i/10g, SQL developer, PL/SQL and UNIX, TOAD, XML Publisher, SQL Loader, Putty,Quality Center, Clear Quest.

Confidential

Oracle Developer

Responsibilities:

• Migrated the existing reports and developed new reports as per business requirements using Oracle Reports.
• Actively involved in ongoing day to day Production Support activities / issues and providing problem resolving solutions to Tickets.
• Responsible for implementation of RICE Reports, Interfaces, Conversions, Extensions elements in Oracle EBS 11i environment.
• Developed interfaces like Inventory interface, Items interface, Bill of materials interface, Categories interface, OM interface, Receiving Open interface and using OM, Shipping, Inventory, Installed Base APIs.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Created programming code using advanced concepts of Records, Collections and dynamic SQL.
• Enhanced the existing packages of the application by adding new procedures and new business logic accordance with the prevailing standards of the application.
• Developed Database Triggers for audit and validation purpose.
• Imported data from flat files located in legacy system into database table using SQL Loader. Designed temporary interfaces to view the loaded data. This data existed in the form of spreadsheets and access database.
• Involved in GUI designing using Oracle Developer 10g Forms 10g and Report 10g .
• Used pipelined functions for faster data accessibility.
• Used PL/SQL to validate data and to populate billing tables.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD 9.5.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database.
• Involved in developing screens and generating reports.
• Performed functional testing for different Oracle Forms application functionalities.
• Developed Forms and Reports using Oracle Forms and Reports 6i and Crystal Reports.
• Used Discoverer to support querying, reporting, and the graphical multidimensional analysis of the central Repository. Mainly performed graphical representation and drill-down features.

Environment: Oracle E-Business Suite 11i, Oracle 9i/10g, PL/SQL Developer, UNIX, Windows 2008, Forms builder 6i, Reports Builder 6i, Workflow Builder, HTML, SQL Loader, SQL Navigator, Oracle Discoverer, QTP, Toad 9.5.