PROFESSIONAL SUMMARY:

• A dynamic professional with around 7 years of experience in design development, setup, support, Customization and testing in Oracle Applications E - Business Suite Release (R12, 12.1.3, 11i, 11.0.3) implementation.
• Outstanding Functional/Technical Knowledge in Oracle Applications with Distribution/Supply Chain Modules like (OM-Order Management, INV-Inventory, PO-Purchasing) financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, Manufacturing Modules such as (BOM-Bill of Materials, WIP-Work in Progress).
• Worked on Various Technical and Functional Documents using AIM (Application Implementation and Methodology)
• Expertise in complete Life Cycle Development implementation of Oracle Applications
• Good experience in Oracle Applications Implementation and Upgrade
• Strong knowledge in sub-ledger flows: Order to Cash and Procure to Pay processes
• Very Good Understanding of Multi Org and TCA (Trading Community Architecture) concepts.
• Excellent knowledge of Oracle 8i, 9i, 10g, 11g environments with expertise in SQL, PL/SQL, Developer 6i/2000/10g (Oracle Reports 6i)
• Experience in designing and developing reports using XML/BI Publisher
• Excellent development skills in RICE components (Reports, Interfaces, Conversions and Form Personalization) in the domain of Oracle E-Business Suite Essentials
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL File etc.,
• Strong coding experience in PL/SQL development using Packages, Procedures, Stored Procedures with, Functions, Triggers and UNIX Shell Scripting
• Experience in registering Concurrent Programs, Form Functions, Reports, Applications, Creating Users and Defining Profile values by using Application Object Library (AOL), System Administration
• Strong ability to manage project tasks with changing priorities and tight deadlines
• Good Interpersonal, Reporting, trouble shooting and Communication skill.

TECHNICAL SKILLS:

ERP Versions: Oracle Applications 11i, R12 (12.1.3)

Modules: Order Management (OM), Oracle Shipping (WSH), Bill of Materials (BOM), Oracle Purchasing (PO), Work in Process (WIP), Oracle Inventory (INV), Oracle Payables (AP), Oracle Receivables (AR), General Ledger (GL), Oracle Sub-Ledger Accounting(SLA), Oracle e-business tax

Programming Languages: PL/SQL, SQL, C, Java

Scripting: Shell scripting

Tools: EDI,BI Publisher (XML Publisher) 10 g, Reports Builder 10g, SQL * Loader, SQL * Plus, SVN, TFS, Putty, WINSCP, ETL, Data ware housing, Cognos.

PROFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Sr. Techno-Functional Consultant

Solution environment: Oracle applications R12

Responsibilities:

• Collaborated with Solution Architects in analyzing client requirements and drove significant improvements across the business as a result of IT development. Equipped a US based client with solutions that improved the Oracle ERP application performance by 50%.
• Working on enhancement in oracle application in oracle reports, oracle forms and oracle workflow and XML reports
• Developing code changes necessary for the enhancement.
• Testing the implementation and code changes
• Documentation of the implemented changes
• Also ensures compliance by steering the project for milestone completion within specified time with quality in functionality.
• Involved in Design Reviews, Code Reviews, Coding, and Testing. Involved in the OracleAIMmethodology throughout the project.
• Worked onItem Conversionin theINVModule.
• Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, reconciliation of converted data to deployment of conversion packages onto go-live sites.
• Oracle Apps Technical Consultant forupgradeandsupportproject.
• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management.
• Worked in customization of workflow in service requests in both automatic and manual process.
• Worked in customization of sales order and quote form as per the business requirements and also done forms personalization in the same requirement.
• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Imported Bills and Routings through BOM Interfaces.
• Work on the development activities as part ofissueresolution. Perform Unit
• Testing, migrate to next environments, assistusertestingand closing thetickets.
• Developed variousCustom reports, Customized existing reports according to the functional specifications usingReports 10g and XML publisher.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.

Environment: Oracle Applications R12 (OM, INV, WSH, PO BOM, WIP, Service Requests), TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 10g, BI Publisher (XML Publisher), Workflow, Subversion, UNIX, WINDOWS XP.

Confidential, Plainsboro, NJ

Sr. Techno-Functional Consultant

Solution Environment: Oracle Applications R12

Responsibilities:

• Integra recently upgraded its software from Oracle 11.5.10 to Oracle 12.1.3. As a part of the project, they have to migrate existing and few new reports that are related to Cognos. As far as existing Cognos reports, they need few enhancements to the report as the current report are not serving the purpose.
• Leading/guiding an offshore team for technical and functional assistance from client location.
• Trained and led on EBS, Oracle ERP administration and upgrade aspects; directed and monitored technical activities for projects from initiation to delivery.
• As a team leader, presented verbal and written presentation of the project to not only the technical staff but also to the clients; this kept everyone updated on the current status along with the issues causing obstruction.
• Developed queries to meet the requirements as per functional specification and prepared the test cases and made sure we got the sign off for all the reports before SIT.
• Worked on customer conversions. Developed Customer Interface to transfer and validate Customer data from legacy system into AR. Created procedures and SQL*Loader Scripts to populate Customer interface tables with data such as Customer Profiles, Phone Contacts at various levels, Payment Method data & Customer Bank data.
• Defined payment terms, locations, and Invoice approvals and setting up Bank Account information in Oracle Financials AP.
• Developed a move shell program in order to move the developed control file to an outbound/archive directory
• Customized existing reports to add additional functionality (Parameters, sorting, calculations, and conditions) using XML Publisher.
• Proficient in preparation of the functional design documents MD50s and technical design documents MD70s and process maps.
• Worked with Oracle to improve performance of Standard Invoice Validation and also fine-tuned existing Materialized Views either replaced MV’s with normal view logic or tuned the existing queries.
• Modify the configuration and technical components of Oracle EBS modules as applicable with the proposed solution.
• Customized a 4 bucket aging report. Aging reports are usually with respect to the receivables that are not paid.
• Experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL), System Administration.
• Worked in Oracle Back-end PL/SQL Development i.e. Stored Procedures, Packages
• Involved in different phases of System Development Life Cycle (SDLC)
• Created logical and physical database objects - table spaces, tables, views, synonyms, indexes, referential integrity constraints, and triggers to development needs
• Prepared requirement specification document that gives the comprehensive details about the requirements.
• Functions & Triggers using TOAD as development tool
• Created Materialized Views to reduce query run time for the end user. Involved in taking backups and exports, FTP in UNIX environment
• Developed Reports to extract the monthly sales information
• Developed custom reports and added columns in the existing reports according to the requirement
• Coordinated with the business users to collect requirements

Environment: SQL, PL/SQL, TOAD, Oracle Applications 11.5.10.2, OM, INV, WSH, PO, BOM, WIP AR, AP, GL, XML Publisher, Forms Personalization, Reports 6i, AOL, UNIX

Confidential, Tulsa, OK

Oracle Apps Technical Consultant

Solution Environment: Oracle Applications r12

Responsibilities:

• Understanding Williams’s technical requirements for AP and PO modules - P2P cycle -.
• POC for Oracle’s monthly change management process - Technical Migrations’ documentation approvals and audit, testing, approvals from business, and following the correct audit requirements while creation of task for migrations. Role also involved tickets assignment, problem analysis, development and bug fixes, unit testing, User acceptance testing support and deployment.
• Developed and customized Oracle seeded forms and reports as well as created several custom objects including forms, reports, interfaces, custom APIs.
• Worked across modules like General Ledger, Sub Leger Accounting, Account Receivables, Account Payables, Purchasing and Inventory.
• Performed critical pre and post implementation steps like running AP, PO reports, analyzing their data, reporting to business and validating the reports post migration.
• Analyze and provide the gaps between the existing processes of Williams with that of Oracle E-Business Suite
• Extensively worked on Multi Organization structure, MRC (Multiple Reporting Currencies), MOAC (Multi Org Access Control), TCA (Trading Community Architecture).
• Opening Oracle SR's, handling, working with DBA's and testing the suggested action Plan.
• Created Oracle Business Areas and Workbooks using Discoverer.
• Interacted with Business Process Users during the Requirement Specification and Analysis phase. Documented various functional features and specifications using AIM methodology (MD 050, MD 070 and CV 060).

Environment: Oracle Applications R12 (PO, AR, AP, GL and SLA), TOAD, Oracle 10g, SQL*Plus, PL/SQL, Reports 6i, XML Publisher, Workflow Builder, SVN, WINDOWS XP.

Confidential, St. Louis, MO

Oracle Apps Techno-Functional Consultant

Solution Environment: ORACLE Applications r12, Oracle Reports 6i, PL/SQL.

Responsibilities:

• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management.
• Played a key role in EDI transactions like Inbound and outbound purchase orders with the transaction codes like 850,855 and 865.
• Worked extensively on Oracle SR's, handled, worked with DBA's and testing the suggested action Plan.
• Worked on reports like item cross reports and sales order acknowledge report and various reports in OM, INV, and PO modules
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, AR, WIP and INV modules.
• Customizing & enhancements on Forms.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.

Environment: Oracle Apps Implementation Release (12.1.3), Oracle 10g, PL/SQL, SQL, Reports, Workflow Builder 2.6.3.5, SQL*Loader, PVCS, Kintana and UNIX.Modules: SCM (PO, INV, OM), Manufacturing (WIP, BOM), EB-tax, Vertex, SQL, PL-SQL, Reports 10g, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential, Houston, TX

Oracle Apps Techno-Functional Developer

Solution Environment: ORACLE Applications 11i, Oracle 8x, Reports 6i, PL/SQL.

Responsibilities:

• Involved in implementation of the complete life cycle of Order to Cash.
• Daniel Mexican Cooperation (DMC) was purely 11i implementation based. DMC was on an initiative to enhance Business. The project mainly dealt with debugging of components & then enhance the same to meet the requirement.
• Some Reports (XML Layouts) for OM have been leveraged from ally teams & implementation was done to meet business and prepared some of the technical documents.
• Involving in converting the legacy system data into Oracle Applications e business suite target modules like OM, PO, INV as per the customer requirements.
• Documented functional features and behavior of required customizations using AIM methodology.
• Prepared conversion documents CV 040 and CV 060.
• Customized standard reports and created new reports as per the business requirements, using Oracle Reports.
• Trained end users on the functionality of Order to Cash modules.

Environment: Oracle Applications r12 (PO, OM, INV, WIP and BOM), TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Reports 6i, Discoverer 6i, Workflow Builder, UNIX

Confidential, Houston, TX

Oracle Apps Technical Consultant

Solution Environment: Oracle Applications R12

Responsibilities:

• Actively involved in retro fitment of the PL/SQL packages, Discoverer Reports, Oracle Reports, Forms, XML/BI Publisher Reports as well as the associated PL/SQL programs, Shell scripts and DB objects.
• Development of XML/BI Publisher Reports as well as the associated PL/SQL programs and Oracle reports.
• Conversion of Discoverer Reports to BI/XML reports.
• Development of Outbound Interface Programs and Mailer Programs in Order Management.
• Development of Reports in Different Modules like Account Payable/ Account Receivable / Oracle Projects/ Order Management/Oracle Sales/ Oracle HRMS.
• Created the technical design documents for the components developed.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Involved in the Personalization of the custom international budget form so as to fit the US requirements.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Coordinated with the offshore team to get the requests done.
• Daily Development Interaction with Technical leads for status and any other outstanding issues.
• Worked as a Member of the Production support system to address day to day issues.

Environment: Oracle Applications 11.5.10.2, Oracle 11.1.0.7.0 , PL/SQL, SQL, Reports, Workflow Builder 2.6.3.5, PVCS, Kintana, DB2, Sybase and UNIX.Modules: SCM (PO, INV, OM), Financials (AP, AR, GL), XML Publisher Administrator, iSupplier, Application Developer, OM and PA; SQL, PL-SQL, Discoverer, Reports 6i, Putty, Winscp 3, FTP, Windows XP and UNIX