SUMMARY

• 8+ years of IT experience in design, development and maintenance of Oracle E - Business Applications as a Techno-Functional consultant with expertise in General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Oracle Process Manufacture(OPM), Inventory (INV), Install base, Service Contracts, TCA, Shipping (WSH), Sub Ledger Accounting (SLA), iProc, iExp, iSupplier and AOL objects.
• Extensive Experience on Order to Cash (O2C), Procure to Pay (P2P) and DROPSHIP business flows.
• Hands on experience in 11i & R12 implementation and roll-out of financial modules like GL, AP, and AR.
• Experience in Software Development Life Cycle including Analysis, Design, Development, Implementation, Testing and Post Production Support using Oracle Applications R12 (12.1.3), 11i (11.5.9,11.5.10.2).
• Good Knowledge in Oracle Application Framework (OAF).
• Good Experience in RICEFW Components like Reports, Interfaces, Conversions, Extensions, Forms and Workflow as per client requirements.
• Excellent understanding Of Data Management, Data Validation and Verification, Oracle Forms and Reports
• Expertise in developing Functional Specification (MD-50), Technical Specification (MD-70), Migration (MD-120), Testing (TE-20), BR-100, CV-60 documents using AIM methodology.
• Very good understanding of Trading Community Architecture (TCA).
• Expert skills in Trading Community Architecture on customer installation.
• Strong hands on experience in Oracle Applications 11i, Release 12, Oracle 10g/9i/8i, SQL, PL/SQL and Developer 2000(Forms 6i/10g, and Reports 6i/10g), SQL* Loader, Discoverer, Workflows and XML/BI Publisher and UNIX Shell Scripting.
• Designing, developing, customizing and supporting the Inbound and Outbound Interfaces in Oracle Applications which includes AP, PO, AR, OM, INV, GL modules
• Formulated solution design and implementation strategy based on client requirements
• Trained the client’s super users on the application
• Excellent in analysis of current business processes, application configuration, managerial reports, and information processing
• Worked with User Acceptance Testing teams to validate the data conversions and pre-production validation
• 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
• A self-motivated Team Leader/Member with excellent inter-personal, presentation and technical documentation skills with concern for maintaining quality at all levels

TECHNICAL SKILLS

Oracle Apps Versions: R12 & 11i

Oracle Apps Modules: GL, AP, AR, FA, CM, SLA, PO, OM, INV, BOM, WIP, OPM, iProc, iExp, iSupplier, Project Accounting, eBtax, SCM, APPLICATION DEVELOPER, SYSTEM ADMINISTRATION

Oracle Apps Business Cycles: P2P, O2C and Drop Ship Cycles

Apps Technical: Oracle Forms (6i/9i/10g), Oracle Reports (6i/9i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, Kintana, PVCS, SHH, PuTTY, SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML, C and JAVA

Environment: Windows 98/XP/ 2000/2003/2007 serverUNIX (HP-UX), Linux, MS-DOS

Databases: ORACLE 8i/9i/10g/11g and MS Access

Database Tools: Toad, SQL*PLUS, SQL*LOADER, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Cuyahoga Falls, OH

Oracle Techno-Functional Consultant

Responsibilities:

• Participated in R12 upgrade project - upgrading from 11.5.9 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes.
• Developed Custom Reports related to table changes for R12 functionality.
• Developed OPM components that are used in 11i and made changes to work in R12.
• Developed changes to 11i packages and reports for R12 required functionality and upgrade changes.
• Developed Warehouse Rules and Production Batches interfaces in OPM.
• Developed Transfer Rules and Open Inventory Balances Interfaces in OPM.
• Designed & developed the Inbound and Outbound Interface Programs to do settlements and other business requirements in Oracle ERP from other Database services.
• Customized and developed Oracle Forms and Oracle Reports using OracleForms 9i/10gandReports 9i/10g.
• Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program.
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables.
• This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Developed various technical objects like Tables, Views, SQL*Loader, Data Loader, Packages, Procedures, Functions, Sequences, Synonyms and Materialized View for different processes.
• Implemented TCA Architecture for customers in Accounts Receivable module.
• Designed & developed Database components specific to Services & Product like Tables, Materialized Views, Procedures, Indexes, Grants and PL/SQL Packages.
• Involved in Design, development, testing, implementation and support inbound/outbound interfaces - Pick Release and Ship Confirm Interfaces to and from Clipper Ship, Price List Line Load and GL.
• Imported Invoices from Order Management via Auto Invoice Interface
• Enter Credit Memo and Debit memo related to an original invoice: Credit Memos may be entered manually in Accounts Receivable to adjust a customer’s account balance.
• Customized Order Management Header and Line workflows to meet business requirements.

Environment: Oracle Applications R12.1.3 (AR, OM, AP, OPM, GL, TCA), Oracle 10g, SQL, PL/SQL, Forms 10g, Reports 10g, JDeveloper 10g, Discoverer 10g

Confidential, Webster, NY

Techno-Functional Consultant

Responsibilities:

• The project involved the implementation of data conversions in various modules like AR, CRM, TCA, HR and customization of reports.
• Worked on different tools like JDeveloper, XML/BI Publisher and Discoverer to generate the reports.
• Implementation and upgrade from O2C to CTC (Contract to Cash) R12.
• Developed Sales Order Report, Purchase order report, Purchase Order Arrival using XML Publisher.
• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API’s.
• Developed employees from interface system through calling PL/SQL API’s and create sales person in CTC
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Ordered., from legacy system.
• Developed Vertex O Series for Tax Calculations and Tax reporting within Oracle R12, for E-Business Tax engine to communicate with Vertex Tax Engine.
• Developed Sales Tax for the tax jurisdictions appropriate to the geographic ship to or Install at address
• Developed TAX and Vertex System from legacy system to Oracle.
• Determined Sales Tax Rate and Exceptions based on a Confidential Legacy Geo Code associated to the Customer Record
• Developed Custom translation tables containing vertex and legacy geographic codes.
• Prepared the test data for MCKB, TAX & VERTEX, SLA and Lockbox systems in development and QA environments
• Developed Shipping Report to show data from Install Base and Service Contracts.
• Developed a XSL template for customizing the AR Sales profit reportusing XML/BI Publisher and distribute the offer document generatedfrom XML Publisher.
• Involved in setting up punch out stores in I-Procurement
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in AR, CRM Project Modules, and sub ledger accounting. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications
• Assist business users in their testing and also development team in unit testing Support to Go-Live activities and Burn In support
• Prepared Invoices for Credit memo and Debit memo for Business users and functional specifications. Involved in the User Acceptance testing and Post Production support.
• Created and customized Reports in AP, AR, FA and Credit & Collections & GL using Reports 10g.
• Created credit and rebill invoices for various reasons including goodwill concessions with customers, price changes, billing frequency changes, rejected escalations, cancellations, etc.
• Customized Credit/Rebill approval workflows and configured approvals using Oracle Approvals Management.

Environment: Oracle E-Business Suite Release 12, CRM Foundation, TCA, Service Contracts, Application Lifecycle Management (ALM) tool, Forms 10g/6i and Reports 10g/6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, Unix

Confidential, San Jose, CA

Techno-Functional Consultant

Responsibilities:

• The project involved the implementation Oracle Applications Release 11i (11.5.10.2).
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Handling the tickets which comes into the queue based on the priority level. Ping the users in the chat window and confirm from them if they are able to login.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles.
• Redeveloped various custom components for R12 upgrade which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Solving the issues which users get while working on this production Application server. Also call them and find out the issue they are going on and solve it.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Created UNIX Shell scripts for automating the execution process.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Developed custom forms to maintain custom tables in P2P process
• Designed and Created several Customized Reports using Oracle Reports10g.
• Designed and developed front-end applications using Oracle Forms 10g.
• Developed Procedures and Triggers for Oracle Forms and Reports.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Coordinated with DBA in improving Database Performance.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Developed Customer Conversion in Receivables (AR) Module.
• Performed Oracle Financials Accounting setups and defined new business requirements and assisted with gap analysis
• Documented the complete end-to-end process for GL, AP and PO modules.
• Incorporated all the business scenarios in AR demonstration documents.

Environment: Oracle 11g, Toad, PLSQL Developer Oracle Forms 10g, Oracle Reports 10g, Windows XP, UNIX, Putty

Confidential, Birmingham, AL

Techno-Functional Consultant

Responsibilities:

• Working on the new business requirements and delivering them on time.
• First level support in Always Lights On project.
• Prepared the MD20, MD50, and MD60, MD70 for the custom forms / reports and interface programs.
• Oracle Service Contracts setup steps &Integration of Service Contracts with Install Base modules.
• Responsible to report the project status to business stake holders.
• Responsible to conduct and resolve the technical issues discussions.
• Actively conducted Conference Room Pilots (CRPs) for TDT business groups and Prepared End-User Training Documents.
• Customized and developed Oracle Forms/Reports, workflow and Data conversion in AP, AR, GL Project Modules, and sub ledger accounting. Interacted with the business users and collected the technical requirements and Involved in Development, Customization of the Interface Applications.
• Worked on BR-100 documents for CRP/UAT and PROD for the OM, INV, and AP & GL modules.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Responsible for providing production support for fixed assets (FA) and Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Developed a PL/SQL program, which reconciles the Reply Bank file data (Lockbox) and calls Receipt API to reverse the receipts for which credit card status is declined.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Worked with AP Team to reconcile AP with General Ledger (GL) by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Created a Report using report builder 6i for End Users to get the vendor and its site information.
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer.
• Worked extensively on production support role, supporting end users and provided solutions to the bugs/enhancements.

Environment: Oracle E-business Suite 11.5.10, Environment: Oracle Applications 11i (GL, AR, AP, PO, OM, INV, BOM), BI Enterprise Edition, Reports 6i, workflow, XML Publisher, Discoverer, TOAD, UNIX, TOAD, SQL, PL/SQL

Confidential, New York, NY

Techno-Functional Consultant

Responsibilities:

• Improved the performance of the application by rewriting the SQL queries.
• The project involved in implementing and developing various RICEW components for financial, supply chain management, Order management, inventory, purchasing in R12.
• Wrote PL/SQL subprogramsPackages, Procedure, functions and DB triggers.
• Involved in Conversion of the existing sales transactions in the AR module of legacy system to AR module in the instance.
• Used SQL developer tool for faster and efficient application design and development.
• Train new employees in using the existing system.
• Worked on creating XML Publisher reports.
• Involved in design and development of conversion and Interface program for importing Sales orders from legacy Order Management system.
• Extensively used backend procedures, SQL queries, standard modules and database triggers to view and pay insurance premium and fee invoices.
• Developed SQL*Loader scripts to load data from legacy system into Payables, Receivables and GL interface tables after validating data through a custom built Concurrent Programs.
• Developed supplier invoice interface program Conversion using the Inventory Open Interface program.
• Created and customized Reports in AP, AR, FA and Credit & Collections & GL using Reports 10g.
• Created UNIX shell scripts to automate the process of loading the external data.
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc. Develops cash application procedures and training documentation.

Environment: Environment: Oracle Applications 11i (GL, AR, AP, PO, OM), Forms 10g/6iand Reports 10g/6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Worked with the team to Design, develop, test and implement system
• Creation of database objects like tables, procedures using Oracle tools like PL/SQL, Toad.
• Supported separate logical and physical models using Erwin.
• Used Erwin to easily define and maintain naming standards, attributes and data types.
• Proficient in TuningSQL Queries and Procedures for enhancing the load Performance in various Schemas across databases.
• Developed procedures to map panels and all items in a panel, to see if they have a single source to single target mapping.
• All those that have single source to multiple targets or multiple sources to single target are dropped and logged into the error table. All these mappings are decided by the Business.
• Designed and developed Custom Invoice Reports in Oracle Accounts Receivables using XML/BI publisher.
• Worked on Error Checking procedure which identifies various error checking conditions given by the Business and applied on the data to clean up the data, for the data to be processed in the mart.
• Written Stored Procedures using PL/SQL.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Defined and Used Cursors wherever applicable to process the data from the query.
• Used SQL Loader (Oracle tool for loading data from a file into Oracle database) for the ETL (Extract, transformation and load) process for the data warehouse.
• Documented the design and Testing of developed modules
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance.

Environment: Oracle Applications 11i, OM, AP, AR, GL, Developer 6i, Oracle 9i, SQL, PL/SQL,), TOAD 7.0