SUMMARY:

• About Eight years of experience in Oracle Applications as Techno - Functional consultant
• Strong technical experience in design, implementation of interfaces, API and customization of Oracle Applications 11i and Rel 12 (GL, AP, AR, TCA, Advanced Collections,PO, SCM, WSH, WMS, OM, INV, BOM, WIP, iStore, iProcurement, iSupplier, ipayments, ireceivables, Costing, Pricing and AOL objects)
• Expert in understanding the business process, Requirement Analysis, module setup, writing the documents and end user support in Purchasing, Accounts Payable Inventory and General Ledger.
• Excellent understanding and implementing the Order-to-Cash (O2C) and Procure-to-Pay (P2P) business process.
• Hands on experience of working on Oracle SOA Suite.
• Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.
• Proficient in writing and tuning complex SQL statements
• Excellent Knowledge of using Oracle AIM methodology for the project Implementation Methodologies
• Excellent understanding of the AOL and System Administration module
• Experienced in Developing Technical Specification and Design Documents
• Experienced in data migrations from legacy systems into Oracle Applications.
• Creation and follow ups of SR and Applications of Patches as and when required
• Excellent in analysis of current business processes, application configuration, managerial reports, and information processing.
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL)
• Involved in 2 complete system development life cycles including the analytical skills necessary to satisfy testing documentation and Change management requirements.
• Experienced in writing parallel queries for optimization.
• Extensive experience in design and implementation of Oracle Alerts
• Experienced in customizing Oracle Workflow.
• Knowledge of SDLC life cycle, concepts and worked on different stages of the life cycle.
• Strong Analytical, Problem solving and communication skills. Strong inter-personal skills at the technical level and end user level
• Extensive experience in developing and designing custom reports using XML/BI publisher.
• Proficient in developing web pages and reports using Application Express (APEX).
• Attended Project Status Meetings, Pipeline Meetings, Code reviews and Inspection reviews
• Excellent analytical, troubleshooting, communication and presentation skills.
• Excellent written and verbal communication skills, ability to perform under strict deadlines and pressure

TECHNICAL SKILLS:

ERP: Oracle Applications 11i e-Business Suite, 11.5.10, Release 12

Business Process: GL, AP, AR, PO, OM, BOM, WIP, INV, FA SYSADMIN, AOL, Order-to-Cash (O2C), Procure-to-Pay(P2P)

Languages: SQL, PL/SQL, C, C++, XML, UML, Java, JSP

Database: Oracle 12c, 11g,10g/9i/8i/7.x, MS Access.

Operating Systems: UNIX (AIX), LINUX, Windows (2000/NT/XP).

Software Tools: Toad, SQL*Loader, SQL Developer, Discoverer 10g, Visio, Oracle Application Framework, Rational Clear Case, Clear Quest, PVCS, Team Track, APEX 4.0/3.2, Oracle Forms 10g/6i, Oracle Reports 10g/6i, FSG, Web ADI, Workflow 3.0, XML/BI Publisher, JDA AP Tool.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Environment: Oracle 12c, SQL, PL/SQL, Reports 10g/6i,SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, JDA, MMS, HPALM (Agile Lifecycle Management), Tortoise SVN.

Responsibilities:

• Involved in the complete design, development and testing phases of AP (Assortment Planning) and EP (Enterprise Planning) projects, part of MPI Planning program at Confidential ’s.
• Prepared detailed technical design documents for the interfaces developed as part of the APand EP projects.
• Designed and developed interfaces, conversions for the items, on-hand and product data defined for JDA AP.
• Designed interfaces to integrate the data communication between different systems like those of JDA and Web Methodsetc. used for Data Warehousing.
• Created test scripts using HP ALM for all of the developed interfaces.
• Created custom database objects for the AP project.
• Responsible for the development and interfacing Assortment Planning (AP) tool from JDA which is on Oracle Staging engine and database with other core systems like MMS, AS400 and other applications including EDW (data warehouse system).
• Understanding of the business requirements around the Retail Merchandising Planning and design the valid data schema’s, ER models, datasets which are required to communicate back and forth with the AP tool and core systems as well as EDW.
• Working on Conversion Rules, Transformation Rules, Stored Procedures, ETL rules and other application logic while interfacing back and forth with Oracle Staging engine of AP with other systems.
• Develop, execute, and manage Oracle PL/SQL as well as T-SQL stored program units such as a procedures, functions, packages and database triggers.
• Participate in various project initiatives as a technical resource, involving Oracle Server and SQL Server; as well as performing duties as documenting requirements, mapping and program logic, designing solutions, testing and implementation.
• Develop and maintain system documentation, including technical specifications, data mapping, program logic and flowcharts.
• Understand and interpret customer requirement and develop solutions to meet requirements
• Design and development of interfacing objects primarily using PL/SQL batch processing.
• Learn and master database schemas (business master and transaction details) of complex third-party enterprise applications
• Created a detailed system design specifications to serve as a guide for system/program development.
• Involved in the process of Code, test, debug, and document more complex programs, and enhance existing programs to ensure that data processing production systems continue to meet user needs through review, analysis, and modifications.
• Collaborate with multiple levels of business and IT management to interpret business requirements and develop technical solutions from internal and external systems.

Confidential

Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications Release 12.1.3 (AP, IBY, AR, PO, SCM, WMS, WSH, INV, OM, TCA, iStore, iProcurement, iExpenses, iPayments,Costing, Pricing, EBTax), Oracle 11g, SQL, PL/SQL,Java, Reports 10g/6i,SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting, Microsoft Team Foundation Server (MS-TFS).

Responsibilities:

• Involved in the implementation of R12 upgrade from the legacy systems.
• Prepared detailedfunctional and technical specifications for various conversions and interfaces objects.
• Involved in the business meetings for gathering the requirements for all the objects assigned.
• Involved in the conversion of Customers and Vendors from legacy system into Oracle EBS.
• Designed and Developed interfaces in SCM modules for various Third Party Logistics (3PL’s) clients based out in Europe, South America and South-East Asia.
• Designed and developed the order, payment and on-hand interfaces for the Stockist (SBC) system based out for the Indonesia market.
• Designed and developed the payment interfaces received from the 3PL clients to iPayments.
• Designed and developed Extensions to automate the lot control in WMS.
• Involved in the data conversion from the legacy system of items, customer accounts and service contracts into Oracle EBS using standard API’s.
• Worked on the development of the integration of Service contracts with the OM module.
• Worked on the development of custom process for Project Costing and Accounting.
• Developed custom PL/SQL packages, procedures to integrate them with the front end of SOA components related to Order Management, Pricing and Shipping.
• Designed and developed extensions for the publishing content for iStore module.
• Involved in the customizing of order submission process in iStore according to the business requirements.
• Involved in the team responsible to integrate the modules of iProcurement, iExpenses and iStore with other EBS modules of SCM like Order Management (OM), Inventory (INV).
• Worked around pricelist and costing of goods into accounting process.
• Designed and developed the drop-ship process to load the ASN’s into EBS.
• Created MD50 functional documents for all the conversion and interfaces objects assigned.
• Created MD70 technical documents for the objects assigned.
• Involved in the unit testing and also conducted the UAT for all the conversion and interface objects.
• Created UNIX shell scripts for the data conversion from the legacy system to Oracle EBS.
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities.
• Created AOL objects for the development work using Oracle Applications System Administration
• Utilized various public API’s for the development of inbound/outbound interfaces in the process of Order-to-Cash business process.
• Involved in the team implementing the Order-to-Cash business process.
• Created various custom objects in the database like those of tables, views, functions, procedures and packages for various business logic needs using PL/SQL.
• Created migration files using FNDLOAD and prepared the migration list of all the objects assigned.

Confidential, Lincoln, NE

Oracle Applications Developer

Environment: Oracle Applications Release 11.5.10.2 ( AP, AR, PO, SCM,WSH, INV, OM, Sourcing), Oracle 10g, SQL, PL/SQL, Java, Forms 10g/6i, Reports 10g/6i,SQL * Loader, PL/SQL, Workflow Builder, XML/BI Publisher,UNIX Shell Scripting, SBM Teamtrack.

Responsibilities:

• Involved and responsible in the development of custom application CODI, to automate the process of keeping in track of various seeds to be sent to various dealers.
• Providing application development and support for an Oracle forms application.
• Design & Development of custom CODI application using Oracle Forms Builder.
• Defined and Used Cursors wherever applicable to process the data from the query.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Created and checked the order submission process from different customers for different items and groups
• Extensively worked on materialized views, materialized view logs to replicate the data from the master tables.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Created parallel queries for the optimization of the SQL queries.
• Involved in the implementation of Order to Cash modules: SCM, OM, Inventory, Warehouse, Purchasing, Receiving and module integrations withOM, AP, AR, PO, INVinEBSSystem.
• Developed Custom Packages which in turn were used for reporting purposes.
• Responsible for custom program maintenance during the production support.
• Created SQL queries to check the information of Vendors, Customers, and Account payable, Account receivable to different vendors and from different customers using TOAD.
• Attended design reviews, project status meetings, walk-through and inspections for the US/IT CODI Seed Team
• Created AOL objects using Oracle Applications System Administration for migrating objects from one instance to another.
• Responsible for the day-to-day operations and direction of the project planning and status reporting, scope management, documentation and facilitation between the technical and functional team.
• Documented Processes and User Manuals for Maintenance Purposes.

Confidential, Jamesburg, NJ

Oracle Applications Developer

Environment: Oracle Applications Release 11.5.9(GL, AP, AR, Advanced Collections, PO, FA, SCM, OM, TCA, BOM, WIP, Service Contracts, iStore), Oracle 11g, SQL, PL/SQL, Forms 10g/6i, Reports 10g/6i, XML/BI Publisher, Workflow, Discoverer 10g,SQL * Loader, PL/SQL, UNIX Shell Scripting, Sun Solaris, PVCS, HP PPM.

Responsibilities:

• Prepared detailed functional specifications for new/modified extensions, interfaces, reports and conversions
• Used FND LOAD utility to migrate various objects including concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.
• Created UNIX shell scripts to automate the process of loading the external data for each month.
• Attended design reviews, project status meetings, walk-through and inspections for functional specifications.
• Resolved production tickets based on priority and pushed them for testing using HP PPM (ITG).
• Provided production support in the areas of AP, AR, FA, INV, OM, Install Base (IB), Service Contracts (OKS) and customized discoverer reports.
• Involved in the team implementing Procure-to-Pay business process.
• Developed custom business areas for reports in Discoverer using simple, complex folders, security for data access for Workbooks.
• Developed and designed custom reports using XML/BI publisher.
• Involved in the implementation of Discrete Work in Process, Inventory, Advanced Supply Chain Planning and Bill of Material(BOM)
• Involved in customization of 11.5.9 oracle iStore application as per the requirements Created new JSPs and mapped those JSPs to proper templates to add additional functionality which is not provided by the 11.5.9 oracle iStore
• Involved in the process of data migration and data conversion from the database
• Involved in the development of WIP jobs conversion.
• Customized the Move Order Pick slips report.
• Tuned SQL statements using HINTS and appropriate indexing and Re-organizations of tables to improve the performance.
• Customized the standard AR Aging Report and Invoice History Report using Discoverer
• Involved in the conversion of various Discoverer reports into Oracle reports.
• Involved in Forms Customizations. Added Validation Logic in the triggers on custom forms.
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, Profile Options and Custom Responsibilities using Oracle Applications System Administration.
• Created ldts for value sets, Concurrent programs, request groups and request sets.
• Involved in the performance tuning of various objects including procedures and complex SQL statements using parallel queries.
• Maintained the versions of database objects using PVCS.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Responsible for custom program maintenance during the production support.

Confidential, Tampa, FL

Oracle Applications Techno-Functional Consultant

Environment: Oracle Applications Release 11.5.10.2 and Release 12 (GL, AP, AR PO, INV, Advanced Colections, iSupplier, iStore Costing), Oracle 10g, SQL, PL/SQL, Java Scripting(JSP), Forms 10g/6i, Discoverer 10g, Workflow,SQL * Loader, PL/SQL, APEX 4.0, UNIX Shell Scripting, Sun Solaris, Rational Clear Case and Rational Clear Quest.

Responsibilities:

• Prepared detailed functional specifications for new/modified extensions, interfaces, reports and conversions.
• Developed conversion program to convert outstanding invoices in Account Payables module
• Designed and developed the invoice interface process in Accounts Payable (AP) using the standard interface program.
• Used FND LOAD utility to migrate concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.
• Designed and developed the PO Conversion process using the Purchasing Document open interface (PDOI) program.
• Designed and developed Receipt conversion process in Purchasing (PO) module using the Receiving Open Interface.
• Development of inbound Purchase Order interface in Purchasing (PO) module using Purchasing Document Open interface.
• Involved in the team implementing and configuring the AP, PO modules in the Procure-to-Pay business process.
• Created UNIX shell scripts to automate the process of loading the external data for each month.
• Attended design reviews, project status meetings, walk-through and inspections for functional specifications.
• Involved in the data migration process while upgrading to R12.
• Developed reports using the XML publisher.
• Worked as Functional Requirements Analyst, gathered information from Business Analysts for setting up General Ledger and Payables Modules.
• Developed custom business areas for reports in Discoverer using simple, complex folders, security for data access for Workbooks.
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, And Custom Responsibilities.
• Created various categories of Forms and Reports using Oracle APEX.
• Designed UI, page navigation with JSP for various pages using APEX.
• Created interactive reports and forms in a page for data entry and register applications using APEX.
• Installed and configured APEX 4.0 in-order to migrate the application from 3.2 to 4.0
• Responsible for the day-to-day operations and direction of the project planning and status reporting, scope management, documentation and facilitation between the technical and functional team.
• Documented Processes and User Manuals for Maintenance Purposes.
• Created SQL queries to check the information of Vendors, Customers, and Account payable, Account receivable to different vendors and from different customers using TOAD.
• Created and checked the order submission process from different customers for different items and groups
• Prepared the documents for Accounts Payable and GL modules and was involved in the of the end users.
• Responsible for the day-to-day operations and direction of the project planning and status reporting, scope management, documentation and facilitation between the technical and functional team.

Confidential ., Charlotte, NC

OracleApps Techno-Functional Consultant

Environment: Oracle Applications Release 11.5.10.2 (AP, AR, PO, SCM, WIP, BOM, OM, Costing), Oracle 10g, SQL, PL/SQL,JSP, Forms 6i, Discoverer 10g, APEX 3.2, TOAD, UNIX Shell Scripting, Work Flow, Rational Clear Case.

Responsibilities:

• Used standard API programs to migrate Cross Validation Rules and Security Rules from Configbase instance to test instances.
• Implemented Trading Community Architecture (TCA) to support complex trading communities and relationships within a trading community using PL/SQL APIs.
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, And Custom Responsibilities.
• Worked as a Functional Requirements Analyst & Application Tester and gathered information from Users and Business Analysts for setting up General Ledger and Payables Modules.
• Wrote and modified functional documents for converting data from Legacy to Staging tables and Staging tables to base tables according to business rules and validation using Oracle AIM Methodology.
• Analyzed existing system, mapping requirements with Applications and customized system to meet client requirements.
• Design and development of General Ledger configuration for creating set of books.
• Developed Audit extraction SQLs involving GL, AP, AR and PO modules.
• Developed Custom API to invoke the API to load the external data into the corresponding tables at the end of every month
• Worked on Authentication Schemes, Authorization Schemes, Application Computation, Application items, List of Values (LOV), Breadcrumbs, Tabs, and Lists etc.
• Designed the Admin application with new features and functionalities using APEX
• Developed several Admin Screens in which mostly developed Interactive Reports Using APEX and Created editable Form Pages for each Row in that Interactive Reports.
• Worked with graphical query builder and generated reports using SQL workshop provided in APEX.
• Created and executed test cases based on high-level and detailed designs documents for Procure to pay process, Invoice approval process for different customers in AP
• Generated the business Intelligence report based on data requested from different departments like Sales forecast details report, Commission Check stub report, Commission transaction exclusion report, Inventory report by Product line (Policy) and by region and location
• Tracked all client and Oracle Support activity related to Service Request (SR) issues and documented it in the client issue tracking system (Clear Quest) as well as the project implementation logs

Confidential

KS Oracle Applications Technical Consultant

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, PO, FA, OM, INV) Oracle 10g, SQL, PL/SQL, Forms 10g, SQL * Loader, and TOAD.

Responsibilities:

• Involved and responsible in development of Self Service Audit Extract Toolkit to automate the auditing process the client in Unified Financial Management System (UFMS). The Audit toolkit is driven by a package and a set of procedures, functions.
• Developed Audit Toolkit Process Selection Form where the user can select the audit extract/s they have to run when required.
• Developed Supplier Automation Inbound Interface which gets the temporary supplier information onto UFMS.
• Configured Concurrent Executable, Concurrent Programs, Custom Flexfields, Custom Lookups, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities using Oracle Applications System Administration.
• Developed Custom Trial Balance Report by GL accounts, Journal Source and Journal Categories.
• Created reports for generating sales invoices.
• Developed BAM dashboard reports for GL, AP, AR and PO
• Developed Audit extraction SQLs involving GL, AP, AR and PO modules.
• Developed Custom API to invoke the API to load the external data into the corresponding tables at the end of every month.
• Involved in Handling CR’s (Change Requests) for various Audit tasks.
• Involved in creating the UAT scripts.
• Responsible for fixing various UAT bugs.
• Divided various functional areas of the application into various Risk Levels for effective testing of the application, also risk leveled all the test cases accordingly.
• Created user defined functions and used library functions for easier maintenance of script.

Confidential

Oracle Applications Developer

Environment: Oracle Applications 11.5.8, HP-UX, Oracle 9i, Reports 6i, Forms 6i, TOAD, SQL*Loader, PL/SQL, SQL* Plus, OAF, GL, AP, PO, AR, INV, XML Publisher.

Responsibilities:

• Worked extensively on GL, AP, and INV.
• Developed several interface programs like item master interface to lotus notes, open order, open PO interfaces to I2 and promising data interface from I2, AR transactions import from external system(services) using Receipts APIs.
• Introduced into implementation of the Procure-to-Pay business process
• Designed and developed Services and Service Contracts Data Conversion programs.
• Used FSG to schedule reports that show account balances, income statements etc., automatically.
• Dunning Letters were created using XML Publisher.
• Designed and developed the Item Conversion process in Inventory Module.
• Services are still in legacy systems for some divisions. Supported and enhanced the Service Contracts interface between Oracle and Legacy systems.
• Customized Advanced Collection Forms using Forms Custom.pll and developed extensions to Advanced Collection Forms.
• Designed and developed a package for importing invoices from external systems (Used SQL*Loader to load data and performed validations using PL/SQL before inserting into interface table)
• Developed variety of Custom Forms using Oracle Template.fmb to hold additional information about Inventory.
• Wrote test scripts to perform Unit Testing.
• Worked with UAT and provided end user for the Forms and Reports developed.
• Provided production support for AR and INV with constant interaction with the end users.
• Worked with Oracle by raising TAR’s to solve critical issues.
• Documented the work done using AIM methodology.