SUMMARY

• 8 years of professional experience as Oracle Apps Technical Developer/Consultant in Oracle E - Business Suite Applications with expertise in Oracle SCM Modules PO, OM, INV, Financials Modules GL, AP, AR, Oracle HRMS, Oracle Incentive Compensation.
• Strong technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components.
• Excellent knowledge of AOL (Application Object Library) and System Administration.
• Strong knowledge and understanding of Order to Cash and Procure to Pay life cycles.
• 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.
• Very Good Knowledge and understanding of Application Object Library (AOL) and Trading Community Architecture (TCA).
• Strong design and development experience on Open Interfaces (inbound and outbound interfaces) and APIs in Oracle Supply Chain, Manufacturing and financial Modules.
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Performed User Acceptance Testing (UAT) as and when required.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Extensive experience in developing and customizing numerous Forms using Oracle Forms 10g/6i/4.5 reports using Reports 10g/9i/6i implementing bind and lexical parameters and also Discoverer 10g/9i/4i and generated various XML/BI Publisher reports, which included working on report development objects like data templates and RTF’s.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents using AIM Methodologies.
• Have strong interpersonal skills along with proficient written and verbal skills. A quick learner with ability to adapt to any environment and finish each task with finesse.

TECHNICAL SKILLS

ERP: Oracle applications 11i/R12 (OIC, SCM like OM,PO & INV-HRMS, Financials like AP, AR, GL & CRM modules), Oracle Application Framework (OAF)

Databases: Oracle RDBMS, Oracle 8i /9i/10g, MS SQL Server 2000

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, PERL

Tools: Oracle Apex 3.2/4.0, Forms 10g/9i/6i, Reports 10g/9i/6i, Toad, SQL Navigator, SQL*Plus, SQL*Load, JDeveloper, Discoverer 10g/9i/6i, Developer 2000, BI Publisher and Kintana

Operating Systems: UNIX, Linux (Red hat enterprise) and WINDOWS family

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Apps Technical Consultant

Responsibilities:

• Developed executive level Forms and reports for Invoice details by customer, by item, by product type using Oracle Forms, Reports, and Business Objects.
• Applied customizations and enhancements on Oracle forms as per the business needs.
• Designed and developed many reports by using lexical parameters in before, after parameters and before report triggers using Reports 6i.
• Created new report Receipt Traveler Report using Reports 6i.
• Developed Budget reports, Variance reports, forecast plans in Reports 6i.
• Customized existing Oracle Reports in Inventory Module (INV) using Reports 6i.
• Created a XML/BI publisher report for Transaction register in Inventory.
• Created a XML/BI publisher report Open Requisitions.
• Created a view and then created XML/BI publisher report for Item Audit.
• Customized the Master/Detail budget report in GL and the Discounts Available Report in AP as required by the client utilizing the Oracle Discoverer.
• Developed a Discoverer Report to capture the sales order line details for a category of items that were exchanged
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL SYSTEM ITEMS table.
• Developed custom interface program to load inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL *Loader.
• Created Descriptive Flex Fields, registered Concurrent Programs,Value Sets, Values, Report parameters, new functions, new menus, new responsibilities, new users and System Administration.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventory modules.
• Extensive use of pl/sql programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures.
• Participated in performance tuning using Explain Plan and Tkprof.
• Involved in checking the validity and accuracy of the legacy data by writing PL/SQL packages.

Environment: Oracle Applications 11i, GL, AP, INV, PO, OM, FA, Oracle 9i, Reports 6i, Forms 6i Discoverer 10g, XML Publisher, PL/SQL, SQL*Loader, TOAD, UNIX.

Confidential, Atlanta, GA

Oracle Apps Technical Consultant

Responsibilities:

• Hands on experience in end-to-end implementation of OIC module as COX standardized its business process across its footprint
• OIC is a global compensation management application module of oracle, which allows organizations to automate the complex task of calculating, allocating and accumulating incentive credits for the sales and field service employees.
• Strong functional and technical knowledge in Oracle application Incentive compensation R12
• Extensively used PL/SQL to develop interfaces, packages, procedures and to create validation scripts
• Created functional specifications (MD 050s) for Custom objects to standardize collections and incentive calculations across COX footprint
• Updated various documents like Systems Requirements document (SRD) by interacting with the business and documenting the requirements and Solution Design Document (SDD), Technical Design document (TDD) to document the design and development details.
• Sound knowledge and understanding of application setups for OIC implementation, setups for calculation, collections and sales credit allocations
• Worked with Oracle HRMS in order to sync employee data from PeopleSoft HR
• Created Compensation plans, formulas, Expressions, plan elements and generated salesreps reports
• Entering new organizations sales force and assigning Groups, Roles, pay groups, creating new compensation plans and updating existing plans
• Created single and two-dimensional rate tables and assigned them to plan elements
• Created Roles, Groups, setup hierarchies and assigned them to plans
• Developed interfaces to automate the synchronization of data from PeopleSoft sources with Oracle HR and developed outbound and inbound interfaces.
• Developed interfaces to automate the process of import resources into Oracle CRM
• Developed PL/SQL packages for different validations, for processing data in order to collect the sales and field service transactions on a daily basis and do the commission calculations
• Developed interfaces to allocate the monthly quotas for salesreps
• Created concurrent programs, executable and assigning them to Responsibility as guided by the Users
• Performed various system administration tasks like creating profiles, Responsibility, lookups, value sets, request sets
• Performed fine-tuning the complex SQL queries using EXPLAN PLAN, TKPROF utilities.
• Well versed with creating Service Requests in Meta link and get the oracle support on severity basis.
• Developed UNIX shell scripts to schedule the nightly jobs and automate other tasks
• Unit tested all the compensation plans and monthly salesrep commission calculations
• Post go live production support

Environment: Oracle Applications EBS - R12, Oracle 10g, Reports 10g, Forms 10g, SQL*Loader, UNIX, PLSQL, SQL Plus, XML Publisher

Confidential, Austin, TX

Oracle Apps Technical Consultant

Responsibilities:

• Involved in developing and Review of AIM (MD050, MD 070) documents for (AP, OM, PO and AR) module implementation/development.
• Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL*Loader and PL/SQL validations.
• Involved in Importing the Orders data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program
• Involved in Item Conversion to import items, and its attributes from legacy system into oracle applications
• Imported BOM and Routings from Legacy system into Oracle Bill of Materials (BOM) using the standard BOM and Routing interface program.
• Involved in attaching new BOM components to the existing BOM structure according to the rules provided by the Business.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Worked with multi-org and multi-currency orders, set up value sets in Order Management (OM).
• Involved in complete Procure to Pay (P2P) and Order to Cash (O2C) life cycle.
• Involved in adding new descriptive flex fields in Order Management (OM) to capture additional information.
• Worked on Inventory (INV) in defining a New Item in inventory and there increasing the On-Hand Quantity.
• Customized the order line level workflow, which will delay the invoicing based on schedule ship date.
• Customized the Printed Purchase order report in Purchasing (PO) to meet the client’s requirements.
• Customized Reports in OE, Inventory, BOM, WIP Modules including various Work-in Process, Discrete job listing Reports, Discrete job routing sheet.
• Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, OM reports like Pack List Main Report, Summary Pack List Report, Sales Acknowledgement Report, Order Holds Report and Inventory Movement from one inventory org from another inventory org in INV
• Developed several customer facing reports using Oracle Report Builder.
• Customized Inactive Item Report in Inventory (INV) using Reports6i to meet the client requirements.
• Customized the Inventory (INV) Item Report using Reports (6i).
• Customized Inactive Item Report in Inventory (INV) using Reports6i to meet the client requirements.
• Customized the Inventory (INV) Item Report using Reports (6i).
• Involved in Discoverer Administration activities like security setup, scheduling workbooks. Also involved in creation of custom folders, joins, conditions, calculations and other readable requirements.
• Developed a PL/SQL package which generates XML data to print a delivery note for shipped orders for various countries using OPTIO.
• Worked on Form Personalization in Oracle Receivables (AR), where the user can’t update the last and first name of customer, bank account number, when that record is validated.
• Customized Purchase Order (PO) Form using Custom.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.

Environment: Oracle 11g, Oracle APPS-12i (OIC), Informatica 9.1, UNIX, Control-M, TOAD

Confidential, Dover, NH

Oracle Apps Technical Consultant

Responsibilities:

• Develop custom forms using Oracle Forms for Invoice Import Validations and corrections.
• Customize the Oracle Applications implementation for different business needs.
• Manage support tickets Queue based on severity/priority/ team-member availability.
• Conducting peer code reviews. Tracking defects and interacting with project managers and business analysts to provide feedback/status.
• Created sales roles, groups, pay groups and assigned them to compensation plans
• Troubleshoot issues with the source billing system (ICOMS)
• Metrics data maintenance and extracting metrics reports.
• Suggesting process improvements to increase productivity, efficiency
• Evaluate and articulate requirements and identify impact, risk, and benefit of alternative solutions.
• Develop new inbound/outbound interfaces between Oracle apps and the third party system.
• PL/SQL programming, UNIX scripting.
• Modify inbound/outbound interfaces between Oracle apps and other legacy systems.
• Modification of existing workflow processes as per business needs.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Migrated the data from the legacy systems into Oracle Applications INV module using Item Import Program
• Developed custom interface program to load Inventory (INV) Adjustment data from external feeder system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables.
• Extensively worked on OM API’s to import the orders from the legacy system and to process the order.
• Developed an interface to load data from third party systems to create PO Requisitions periodically.
• Developed interface to populate WIP move interface tables and to submit concurrent request to perform WIP move transaction.
• Registered concurrent programs & request sets to load BOM data into Oracle 11i tables, with prior validation and error reporting and then run Bill and Routing Interface program to import BOM data into 11i applications tables.
• Reviewed the process flow in OM module with Business users and developed GAP analysis report.
• Customized BOM setup by defining profile options, department classes, and BOM parameters.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Written interface programs for AR customers, AR invoices, AP invoices, PO vendors.
• Developed multiple custom reports in AP, AR, PO, GL and Fixed Assets. Played a major role in the go-live support for the smooth transition of the business activities from the legacy applications into Oracle Financials.
• Worked on QP Price Formula pub API in QP.
• Developed Reports to extract the monthly sales information. Developed custom reports and added columns in the existing reports according to the requirement.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using XML/BI Publisher.
• Modified several Customized Reports using XML/BI Publisher like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.
• Developed a Hold Order Report which displays all the open orders on hold for a particular inside sales representative, customer, hold reason, distribution center and hold level.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Oracle Reports 6i.
• Created new report WIP Component Report using Reports6i.
• Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
• Customized the existing forms with descriptive flex fields.
• Customized the PO Receipts form using custom.pll for dynamic generation of locator while receiving Purchase Orders
• Developed Discoverer reports in OM and INV modules using Discoverer Admin, Discoverer desktop which involved creating business areas, custom folders, and workbooks as per requirement.
• Involved in performance tuning of PL/SQL code and SQL queries using Explain Plan, TKPROF, Events 10046, Hints, ASH Reports, ADDM and TOAD.

Environment: Oracle e-Business Suite 11.5.9, Oracle Database 9i Special Software Oracle Apps 11i, PL/SQL Developer, Toad, Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, Putty.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding technical upgrade process. Compiled and executed number of forms, interfaces, custom reports, customizations/extensions etc
• Involved in technical upgrade like Concurrent custom reports had to be re-compiled and executed using Oracle reports and forms.
• Modified the existing old performance test cases to fit for new upgrade functionality
• Performed a technical upgrade which includes Reports, forms, interfaces and various customizations during upgrade process.
• Involved in Form personalization.
• Tuned the reports to improve performance during upgrade process.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes in upgrade.
• Updating MD70 documents after upgrade based on MD50 documents.

Environment: Operating System Windows Server 2003, Windows XP Special Software Oracle Applications 11.5.10 (INV, OM, AR), Oracle PL/SQL, Forms 6i, Reports 6i, Toad, Oracle 9i

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Used various SQL tools to monitor database activity, bottlenecks and run query statistics
• Expert in RDBMS conceptual/logical and Physical database design and Modeling
• Created Integrity constraints and Database Triggers for data validation
• Created and modified SQL statements for ETL
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Extracted data from various sources for loading to destinations
• Used SQL Loader to read data from flat files and load into staging tables
• Sub-Queries and joins are extensively used in stored procedures
• Extensively used UNIX shell scripting for automating batch programs
• Wrote complex queries to retrieve information from large databases
• Experience in development activities including analysis, design, coding, data migration and testing for production and development environments
• Experience in database design modeling and design experience
• Writing ad-hoc queries
• Strong Trouble-shooting, Problem solving, Analytical & Design skills