SUMMARY:

• Over Nine years of experience in IT industry with Over 8 Years of technical experience in Oracle Applications with excellent knowledge in SQL, PL/SQL, Financial Modules (AP, AR and GL), Distribution Modules (INV, OM, PO), WEB ADI, Work Flow, XML/BI Publisher, Oracle Forms & Reports.
• Expertise in Application Development and Customization, open Interfaces and Conversions, Development of Reports (Version 10g/9i/6i/2.5), Forms (Version 10g/9i/6i/4.5), XML/BI Publisher reporting tool.
• Worked on different version of Oracle Applications (EBS) 12.1.3/11.5.10/11.5.8/11.5.7/11.0.3
• Experience in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Strong in Applications Object Library (Concurrent programs registration, Value Sets, Profiles, form registrations etc.), System Admin tasks.
• In depth technical knowledge in flow of Oracle Order Management, Inventory and Purchasing.
• Experience in Order - to-Cash and Procure-to-Pay process with full life cycle implementation.
• Very strong programming skills in PL/SQL, Stored Procedures, Database Triggers, Packages, Functions, UNIX Scripts.
• Experienced in Using Oracle Applications standard API’s as wells as writing custom Oracle API’s and using it in Oracle Applications Interfaces/Conversions.
• Good Experience in designing, developing and troubleshooting Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Experience in working with AIM methodology and is very proficient in working with MD050, MD070.
• Experience in designing and executing test cases and test plans based on business requirements.
• Extensively used QUEST Tools (TOAD, Navigator), SQL*PLUS, SQL * Loader, PL/SQL developer & utilities such as UTL FILE..
• Experience with Performance Tuning for Oracle RDBMS. Extensive experience in Optimization (Tuning) of the Applications Confidential the application level
• Expertise in Shell Scripting and debugging.
• Strong analytical, diagnostic and problem solving abilities.
• Production support, bug fixing and enhancement experience
• Interaction with Clients/Business to identify the business practices, future requirements, identifying the gaps and designing alternate solution.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

AREAS OF EXPERTISE:

• Functional and Technical understanding of Oracle Applications including underlying table structures and database procedures and APIs.
• Designed & Developed interfaces for INV, OM, PO Modules.
• Extensively created mappings and conversions in Oracle Apps to import the data after validations in to ERP.
• Created new page and controller and modified existing ones as per business needs.
• Designed and developed the packages for the reports.
• Very good testing knowledge of Oracle Manufacturing(OM,PO,INV) & Financials(AP,AR,GL,CM)
• Experience in Creating Triggers, Packages, Procedures, Functions using PLSQL.
• Extensive experience in Optimization (Tuning) of the Applications Confidential the application level as well as the DBA level.
• Interaction with Clients\Business to identify the business practices, future requirements, identifying the gaps and designing alternate solution.

TECHNICAL SKILLS:

Oracle Applications: Oracle E-Business Suite Release: R12/11 I, AOL, System Admin.

RDBMS: Oracle 8i/9i/10g, MS Access, SQL Server 7.x, 2000.

Application Tools: Forms 9i/10g, Reports 9i/10g, Discover 9i, 10g, TOAD, SQL Navigator, SQL *LoaderSQL*PLUS, XML/BI Publisher

Application Modules: Inventory (INV), Purchasing (PO), Order Management (OM), General Ledger (GL).

Utilities: Putty, Rational Clear Case, Clear Quest, export/import, Winscp, Quality Center, ALMClear Quest, SQL Developer, SQL Loader, Toad, CVS, SVN

Operating Systems: UNIX, Windows NT/XP/2000/98, Linux, MS-DOS

Languages: C, JAVA, SQL, PL/SQL, HTML, XML

Scripting Languages: UNIX shell script

PROFESSIONAL EXPERIENCE:

Confidential, Bothell, WA

Oracle Apps Technical Consultant

Responsibilities:

• Coordinated on shore and off shore teams on regular basis for the project.
• Involved in discussions with cross functional teams in designing and development of Interfaces between systems.
• As a lead, making sure that the issues are assigned, acknowledged and resolved Confidential earliest.
• Involved in preparation of package for UAT and providing UAT support.
• Involved in requirement gathering, design and development and testing of System.
• Preparing project plan for the objects to be developed.
• Preparing functional and technical document for the enhancements assigned as a part of business process re-engineering.
• Done the Personalization and customization for Sales Orders in Order Management.
• Worked on P2P Process and O2C process.
• Analyzed functional Documents and Prepared Technical design documents and Data mapping documents for importing Purchase Orders and Payables interface and loaded data into base Tables.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Customized POARROVAL and Created New Workflow (CUSTCREB1) for Po approval process and hierarchy level for PO approvers for third Party.
• Modified purchase order workflow to implement approvals using AME.
• Analyzed Business requirements, proposed technical solutions designed & developed OAF pages for the Advanced Shipments loading for various purposes and Worked on Controller Extension.
• Assure Quality of Code is maintained by following the Standards of Coding.
• Understand all kinds of issues/enhancement and make sure of the service assurance within the mentioned SLA.
• Managing and coordinating with other teams to carry out day-to-day work, handle critical situations to maintain business continuity.
• Provided User Confidential various company locations.
• Worked on Outbound Interface for Customers, Tax Exemptions and Tax Zones.
• Created the Descriptive Flex fields (DFFs) in AP, AR, INV, BOM, Service Contracts and PO for capturing the Item & Tax information.
• Extensively worked on Cursors, PL/SQL Tables in the interface development and used exceptions wherever necessary to improve the performance.
• Developed Data lake extract packages writing the data to file system using Dynamic sql and sending the files to another system using Data router.
• 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.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Used Desktop Integrator (WEB ADI) to import excels data to lookups table.
• Experienced in using the performance tuning methods like Explain plan, Trace and creating Indexes.
• 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.
• Oracle data loading into oracle database from flat files using SQL loader.
• Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
• Developed new program in PL/SQL and Modified old programs for creating the sales order and adding new lines to order and receiving the lines using receiving transaction processor program. Created new custom tables, Procedures, Value sets, Sequences etc., for this process. Utilized FND REQUEST API to submit concurrent programs from PL/SQL programs.
• Worked on customizing the PDH CA PROP 65 General Report using BI Publisher and report builder.
• Experience in design and develop AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML/BI Publisher.
• Created Views and Materialized views and customized materialized view for item and location search.
• Good working experience in customization of forms using Forms personalization and custom.pll according to the requirement.
• Customized Sales Order form and Sales Order quick entry forms to hide and show fields based on the responsibilities using Forms Personalization.
• Understanding the Report functionality, Analysis and Review of High Level documents mainly MD050 Functional Specification.
• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Developed Customized PL/SQL Packages, Procedures and Triggers to accommodate the Changes to the Existing Manufacturing / Financial Business Application as per client requirements.
• Developed UNIX shell scripts for coping and moving files to and from the Oracle server.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Defects were tracked, reviewed, analyzed and compared using Quality Center.
• Functional / Technical analysis of existing business process flow.

Confidential, Dover, NH

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed JSP pages and Implementation classes to retrieve employee information and presenting it on web based screens.
• Used JDBC to access and modify the data in Oracle database.
• Accessed Oracle stored procedures and functions using JDBC callable statements.
• Implementation of Invoking Forms and Workflows from Custom OAF Pages
• Fixed Bugs in OAF pages and worked on VO and CO Extensions.
• Designed and developed complex SQL’s to insert, update and retrieve data.
• Used global temporary tables for the user session management.
• Involved in the development of RICE components in Oracle Inventory, Purchasing, Order Management, Account Receivables, Account payables.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context using forms personalization.
• Designed and Developed an Item Conversion to Import legacy inventory item data using the MTL SYSTEM ITEMS table.
• Used the performance center for making the performance and stress testing on the application.
• Co-ordinate between the business people and the programmers and worked with programmer to resolve the issues.
• Diagnosed the problems caused in the applications through the log files and rectified the problems and enabled different components of race for problem determination.
• Troubleshoot using logs, Log Analyzer for activity logs, Thread Analyzer for thread dumps, custom shell scripts.
• Worked and solved variety of issues with WebSphere and J2EE applications and provided 24/7 support for critical applications with on-call pager rotation, flexible to work during off hours.

Confidential, Peoria, IL

Applications Developer

Responsibilities:

• Create Stored Procedures, User Defined Functions, Views, Confidential -SQL Scripting for complex business logic.
• Written complex Stored Procedures using temporary tables, table variables, error handling (TRY & CATCH) methodology for data loads.
• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user’s requirements.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, views and other SQL joins and statements for applications
• Optimizing the Confidential -SQL script using the estimated execution plan based on the cost of the steps and indexes.
• Cleaning, fixing the data which is incomplete and identifying the various exceptions in the received data.
• Worked on optimization and tuning of SQL queries and indexes.
• Assisted in the application development, debugging, configuration and optimization from database perspective.
• Performed database design by analyzing business requirements.
• Assisted in troubleshooting and resolution of database issues.
• Designed database/tables and the requisite relationships, designed partition tables and partition views.
• Updated functional specification and technical design documents.

Confidential

Oracle Application Technical Developer

Responsibilities:

• Interacted with end users for gathering requirements.
• Perform database tuning, monitoring, loading and back up.
• Involved in customizations of Interfaces, Reports, forms etc. in various modules like OM, AR, PO, INV etc.
• Used SQL loader to load data from csv files into Oracle tables.
• Creating prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL.
• Created Views and Materialized views depends on the business requirement.
• Developed SQL for loading metadata from Excel spread sheet to the database using SQL Loader.
• Customized forms and worked on forms to hide and show fields based on the responsibilities using Forms Personalization.
• 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.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Designed and developed PO Print Report using Oracle Reports(.rdf) & XML Publisher
• Developed SQL script for loading data from existing MS Access tables to Oracle.
• Create record groups for manipulation of data, Perform unit and system integrated testing.
• Involved in database design, development of database, tables and views.
• Involved in application testing, deployment and production support.
• Experience in working in different environments and with the process flows in AGILE as well as Waterfall methodologies.