SUMMARY:

• Over 7 years of experience in IT industry have experience in Analysis, Design, Development, Conversions, Interfaces and Implementation of business applications using Oracle Applications R 12.1.3/11.5. x R11i, SQL, PL/SQL, Oracle 11g/10g/9i, Developer 2000/6i and Discoverer.
• Extensive experience in Oracle Application Modules which include Order Management (OM), Inventory(INV), Accounts Receivable (AR), Accounts Payable(AP), General Ledger (GL), Purchasing (PO), Application Object Library (AOL), System Administrator, Projects, WIP(Work In Progress), iSupplier, HRMS (Human Resource Management System), iExpense.
• Proficient in developing PL/SQL program units using Procedures, Functions, Packages, Triggers and Public API’s.
• Well versed with client server environment & tools like SQL*LOADER and TOAD.
• Extensive experience in developing Interfaces and Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL File, UNIX and Shell script etc.
• Experience in Form customizations and personalizations.
• Experience in Customizing and developing Oracle reports using XML BI Publisher.
• Experience in OAF Customizations and Personalizations.
• Experience in Concur to Oracle EBS Integration for Expense Invoices.
• Experience in RICE (Reports, Interfaces, Conversions and Extensions) components.
• Experience using DATALOAD for loading external data into Oracle Applications UI.
• Extensive Experience with AOL to develop Flexfields, Reports, Validation sets, Concurrent programs and registered in AOL.
• Proficient in usage of EXPLAIN PLAN and SQL TRACE for Performance Tuning of Code.
• Produced Technical Documents on Reports developed.
• Ability to interact effectively with clients, understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.

TECHNICAL SKILLS:

ERP: Oracle E - Business Suite R12.x / 11.5.x, 11i, 10.7

ERP Modules: OM (Order Management), Inventory (INV), GL (General Ledger), AP (Account Payables), AR (Account Receivables), PO (Purchasing), AOL (Application Object Library), Application Developer and System Administration, Projects, WIP (Work In Progress), HRMS (Human Resource Management System), iExpense.

Oracle Tools: Forms 10g/9i/6i/6.0, SQL*Loader, TOAD, SQL Developer, SQL*PLUS, jDeveloper, Quest Suite of Tools.

RDBMS: Oracle 11g/10g

Languages: SQL, PL/SQL, XML, Java

Operating Systems: UNIX, Windows XP/Windows 7/Windows 8.1 and MS-Office Tools

Reporting Tools: Reports 10g/9i/6i, Discoverer 10g/4i

Version Control: Perforce, SharePoint, PVCS, SVN, GitHub, StarTeam.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Sr. Oracle Application Developer

Responsibilities:

• Produced Functional (MD 50) and Technical design documents (MD70) based on Business requirement.
• Produced Installation Instructions documents (MD120).
• Gathered functional user inputs and produced TE020 document.
• Involved in multiple CRP’s and UAT’s to meet business users requirements.
• Gathered Business requirements, designed and developed custom Forms and Reports.
• Developed inbound interfaces to interface expense invoices data from concur to Oracle EBS.
• Understanding the existing Functional Flow and relate it to the technical aspects.
• Responsible for all deliverables including Data extract programs, Reports and Concurrent Programs.
• Mapping client requirements with Oracle standard functionality, finding gaps and delivering solutions in terms of Customizations, Workarounds, re-engineering and forms personalization.
• Setup multiple quick codes for AP, AR and GL. E.g.: (Discount Amount Basis, AR Transaction Type Categories, Account Types etc. … to meet current business requirements).
• Application Enhancements and Support for AP, AR and GL modules.
• Experience in data mapping external source files with oracle columns in Oracle Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL) and Fixed Assets (FA) modules.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Technical, Performance and Regression testing.
• Gathered Business requirements, designed and developed multiple reports using XML BI Publisher.
• Developed Inbound and Outbound HRMS interfaces to insert employee data from external application system called Avature.
• Extensively leveraged XML Bursting Process to e-mail reports to multiple Business users across different operating units globally.
• Proficient in PL/SQL program units - Procedures, Functions, Packages, Triggers and Public API’s.
• Performed Forms personalization in AP and AR, created special menus to view Invoice Image file, populate voucher number and budget fiscal year for AR invoices.
• Extensively leveraged XML Bursting Process to e-mail reports to multiple Business users across different operating units globally.
• Developed XML publisher reports importing sub templates into the main template
• Worked on OAF personalizations to meet business requirements
• Extended several OAF View Objects, Controllers to develop business validations
• Responsible for status update reports to higher management on weekly as well as monthly basis.
• Responsible for providing solutions to Business using Oracle Applications EBS and thus making them understand the functionality provided by Oracle EBS to accomplish their day to day operations successfully.
• Have extended responsibility to resolve complex defects and deliver solutions to Business.
• Level 2 and 3 Production support for Oracle EBS, Release 12.1.3 (to support Application Services group if they cannot resolve the Production issues).
• Developed various XML publisher reports using Excel templates
• Drive business process reengineering and related lean concepts through Oracle ERP and related information systems best practice deployment towards global process and automation.
• Modified Payables Reverse Disbursement workflow to correct the disbursement amount calculation in AP.
• Modified Asset Scrapping Workflow to calculate the correct scrapping amount.
• Provides in-depth technical consultation to Business Unit and IT management to ensure development of efficient application systems utilizing established standards, procedures, and methodologies.

Sr. Oracle Consultant

Role and Responsibilities:

• Prepared numerous Technical specification documents (MD70) for Reports, Interfaces (CV) and forms customized.
• Built Functional spec (MD50) documents on reports developed in Purchasing (PO), Accounts Payable (AP), Order Management (OM) and Accounts Receivables (AR) while interacting with the end users.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to load Applicants data from external Applicant Tracking systems into Oracle HRMS
• Designed and Developed outbound interfaces to provide data to external systems.
• Built numerous custom value sets and defined values for value sets.
• Registered concurrent programs, scheduled requests and defined request sets.
• Proficient in PL/SQL program units - Procedures, Functions, Packages, Triggers and Public API’s.
• Understanding the existing Functional Flow and relate it to the technical aspects.
• Worked closely with functional team and business to resolve bugs and defects and UAT.
• Prepared Test case documents on all components developed.
• Designed and Developed Payment Inbound interfaces using Payables Interface programs to import data from external systems like Concur.
• Involved in Functional document (MD50) review and preparation of Technical document (MD70) based on the business requirement.
• Prepared Installation document MD120 and Involved with the functional user in preparing TE020.
• Prepared Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Developed Outbound Interfaces to pass the information from Oracle Applications to the third party system by making use of Integrated SOA Gateway functionality to invoke an external web service using Service Invocation Framework.
• Unit tested these web service using SOAPUI
• Exposed Interfaces as web services by generating WSDL and provided security authentication for the web services in EBS using integrated repository responsibility.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API (Interfaces) to import the data from legacy system into OM using Order Import Concurrent Program.
• Performance tuning of the queries in consolidated billing invoice report.
• Developed a custom PL/SQL procedure to suit the Pick Release Requirements of the Client.
• Created PL/SQL procedures, packages and functions used to load and verify data from vendor feeder system into an Oracle Database.
• Designed, documented and developed an Interface between Mainframe based application and Accounts Payable (AP) for Invoices. Developed staging tables, conversion routines, PL/SQL API’s, shell script for this Interface. Used SQL loader to load data from legacy system (Mainframe) and developed PL/SQL programs to dump the data from staging tables to the Interface Tables and concurrent programs to get data into Oracle Base tables.
• Registration of Concurrent Programs and Request Sets in AOL and System Administration.
• Involved in writing the technical specification document and code development for Order Import and line level validation.
• Designed, documented and developed in an interface from payroll system to General Ledger for importing journals every month.
• Designed and developed an interface between third party billing system and Accounts Receivables (AR) for Invoices using Auto Invoice.
• Responsible for Functional testing and Process setup.
• Customized several standard Oracle reports as per business requirements.
• Developed several PLSQL packages to implement the business processes.
• Worked on several OAF customizations for Buyers Work Center page.
• Created indexes to enhance the performance of the applications.
• Knowledge on Oracle hints to improve the performance.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Involved in bug fixing reported from QA and End users.

Sr. Oracle Apps Technical Consultant

Responsibilities:

• Involved in the system study, Requirements and Gap analysis and design documentation.
• Involved in Functional Document review and Prepared Technical Requirement (MD 70) Specifications based on the Business Requirement.
• Involved in Building Customizations and Enhancements using Reports and Forms.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
• Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM.
• Imported data from legacy system into staging tables using SQL*LOADER, perform validations prior to transferring data into OM Open Interface tables.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Designed and Developed Customer and Invoice conversion program through Standard (AR) Oracle Receivables Interfaces. Imported data from legacy systems to Oracle Receivables tables using SQL*Loader. Used Auto invoice to import regular, debit memo, credit memo invoices from legacy systems into (AR) Oracle Receivables.
• Uploaded Transactional data such as Item cost and Price list in Oracle Applications using DATALOAD, The business requires that the Item Cost and the Price List be updated every 3 months. DATALOAD captures Keystrokes and loads the data into Oracle Applications.
• Create custom Data entry Screen to view serial number information, Inventory Manifest Information, Inventory Availability Form using Forms 6i.
• Customized reports in AR such as: Customers Profile Report, Aging Report.
• Customized reports in OM and Inventory (INV) such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report.
• Registration of concurrent programs, defining value sets and parameters for customer reports specific to Applications.
• Performed system administration functions such as creation of users, Responsibilities and Menus and Functions.
• Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test).
• Involved in bug fixing reported from QA and End users.
• Involved in Post production Support, work involved supporting Apps, support in reporting & tickets.
• Involved in Functional Design Review and preparing the Detail Design Document.
• Involved in Customization of Standard Oracle Reports as per client requirement.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology,
• Analyzed and designed customer specific forms, reports and meet Business Users requirement. Reports such as Item where used Report, Weekly Inventory Report, Inventory Aging Report Etc and Data entry screens like Quick Customer lookup using BI Publisher.
• Developed Interface Program for loading Items information from legacy system to Inventory (INV) interface tables using SQL*Loader and PL/SQL and subsequently ran Item Import to populate the Inventory Base tables.
• Developed a custom conversion program to validate customer information before loading them into AR Base Tables.
• Involved in importing BOM and Costing Data from legacy system.
• Used Order Management API to populate the data into various base tables.
• Registered concurrent programs, request groups for reports and concurrent requests.
• Involved in Unit testing and Bug Fixes, Involved in UAT Process (work involved helping Test Team to come up with test cases and Bug Fixes)
• Involved in Cut over Planning and execution, Involved in Post Production Support (work involved Supporting Apps, supporting in triaging.)

Oracle Apps Consultant

Responsibilities:

• Produce Technical design documents (MD70) based on business requirement.
• Involved in Customization of Standard Oracle Reports as per client requirements.
• Analyzed, designed, implemented and documented customer specific forms and reports. Worked on reports such as Aging report, AR receipt history report, Revenue reports etc .. and Data entry forms like Quick Customer lookup screen.
• Designed and developed Staging tables, Custom PL/SQL API’s, used Oracle Public API’s to import
• Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Open Sales Orders etc., from legacy system to Oracle 11i.
• Developed Customer conversion for one time process to import from the legacy system.
• Designed, documented Functional (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents and developed conversion routines, Created Staging tables, and custom PL/SQL API’s to convert
• Employees, Employee Addresses, Employee Assignments, Jobs, Salary, Assignment set, Element Set, Element Link, Element, Earnings, Deductions, Benefit Contributions, Absence Types, etc from legacy system to HR.
• Performed Administrative tasks like adding security, granting privileges, and scheduling and sharing of reports.
• Create Gross Sales Report. Report displays Order Information, AP and AR Invoices, Customer/Supplier Information, Invoice amount details, Trips and Shipment information.
• Documented Business requirements and designed interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for importing INTUIT invoices into Staging tables, and developed PL/SQL API’s for complete validation of data and inserting into AR Interface tables.
• Developed Direct Debit interface processes to send payment files to Banks.
• Converted standard report to Discoverer reports for more user-friendly access to the data.
• Developed PL/SQL programs and scripts. Registered concurrent programs, request groups for reports.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled descriptive flex fields to facilitate additional information.
• Developed Reports using Discoverer4i, Created business areas, Created joins, Create calculated items, Created conditions, Created new folders based on user requirements.
• Create Users and Responsibilities for Security.
• Created value sets and value set values.
• Performed tuning on the SQL and PL/SQL packages to improve processing time and efficiency.
• Monitoring financial status/health for major corporate clients using Oracle Reports.
• Auditing Gain/Loss reports.
• Worked on Forms Personalization to meet business requirements.
• Production Support for the client and provide solutions, bug fixes to Tickets.
• Worked on incompatibility option and conflict domain of Oracle concurrent programs.
• Defined customer profiles, customers, payment terms, payment methods.
• Developed many new reports like Customer Order status Report, Aging Report, Purchase Price Variance Report.
• Interfaced legacy system GL data using Journal Import. Ran Journal Import to load data into GL base tables.
• Wrote custom program to import data from temporary table directly into vendor base tables (AP). Uploaded data into the staging tables using Direct Path SQL Loader. Migrated close to 5000 suppliers using the steps described.
• Developed detailed design documents for the customizations.
• Involved in code review process.
• Worked on creating application mode End User Layer, building business areas, and building discoverer workbooks, ad-hoc reports, parameterized reports using Discoverer 4i.Created parameterized reports using Discoverer Plus.
• Worked on various backend Procedures and Functions using PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created numerous forms and reports using Forms and oracle Reports.
• Created various Database triggers using PL/SQL.
• Generated a number of reports for management to review for system functionality as against the old legacy system.
• Tuned SQL using EXPLAIN PLAN and SQL TRACE and used appropriate Indexing and Collections to make sure performance is optimum.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Performed System Administrator functions like registering of new reports, forms, functions, validation sets, request sets and concurrent programs.
• Involved in Unit testing and preparing test cases for QA, Involved in User Acceptance Testing.
• Fixed bugs as reported by QA and End Users.
• Involved in Cut Over plan and Execution.

Oracle Developer

Responsibilities:

• Map business process against Oracle Financials and prepare gap analysis report.
• Designed, documented and implemented Accounts Payables (AP) Interface. Produced Technical Spec (MD70), Installation Instructions document (MD120).
• Implementation and re-engineering of Order to Cash (O2C) and Procure to Pay (P2P) business processes.
• Designed and developed staging tables, Custom PL/SQL API’s and use Oracle Public API’s to loadOpen Payable Invoices (AP), Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts etc … from legacy system to Accounts Payables (AP).
• Produced Technical Specification (MD070), Installation Instructions document (MD120) and developed Staging tables, custom PL/SQL API’s and used Oracle Public API’s.
• 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, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and also customer, receipts, invoice, and adjustment reports in AR.
• Designed, documented and developed Customer Interface using TCA (Parties, Party Sites, Party Site Accounts and Party Account Uses) between Web Based Application and Oracle AR Module.
• Involved in Legacy Accounts Receivable (AR) Invoice Conversion and loading Receipts. Information from POS (Point of Sale) system using Lockbox Transmission.
• Customized Pick and Pack slips to list back ordered items and print discount information in Oracle Order Management (OM) module.
• Execute Public API to load pick released orders in (OM) into external system (shop floor system).
• Involved in various activities like reviewing functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing (UAT).
• Identify delinquent customers and send dunning letters as per corporate policies.
• Involved in setup and customization of Oracle Receivables (AR) & Oracle Payables (AP). Data conversion from legacy system into Oracle Applications.
• Importing vendor and invoice information into Oracle Payables (AP) using stored procedures and SQL*Loader.
• Uploaded assets information into Fixed Assets (FA) module.
• Giving Buy and Sell option reports to customers.
• Generate Trade reports, Trial Balances and alerting clients about markets volatilities.
• Customization of AR Aging Reports as per business requirement.
• Used Oracle's optimizer and monitored how it chooses the execution path/plan for the procedures.