Home

Sandeep K - Oracle EBS

[email protected]

Location: Ashland, Massachusetts, USA

Relocation: Yes

Visa: h1b

SUMMARY: IT professional with 15 years of experience as an Oracle EBS Apps Consultant. Strong background in Upgrades, Data Conversions, Interfaces, Workflows and Customizations. Successfully Completed four full life cycle implementations using oracle applications. Extensive experience in using SQL, PL/SQL, Developer 2000/6i/9i, SQL Loader, Discoverer3i/4i/9i, EDI 810/850, Workflow, Oracle R12,11i,9i/8i/8/7.x, Unix, Linux, and Shell Scripts and Oracle Applications (Financials, Manufacturing, Inventory and Sales & Distribution modules, SCM). Worked in Oracle Financials (GL, AP, CE, AR, FA, PA), Advanced Collections, SCM modules like Manufacturing (INV, WIP, BOM), PO (Oracle Purchasing), OTC (Order to Cash), OM (Order Management/Advanced Pricing), HRMS, Payroll, OTL (Oracle Time and labor),FAH( Financial Accounting Hub), OAB (Oracle Advanced Benefits) and AOL (Application Object Library). Extensive experience identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Experience in set-up, configuration, and functionality checks. Experience in building Forms, generating Reports and registering them as concurrent programs in Oracle applications using AOL involving Forms 4.5/6i, Reports 2.5/6i. Extensively worked on AIM documents like Business Requirement Definition [RD], Business Requirement Mapping [BR], Build and Module Design [MD], Documentation [DO], Business System Testing [TE]. Expertise in developing object oriented applications based on Java and C++ along with web development using HTML, XML and JavaScript and UNIX shell scripts. Experience in writing user stories, test scenarios, test cases, etc. Experience in conducting meeting with stakeholders, business user, IT teams. Experience in Conversions, Interfaces and Report Customization in oracle modules GL, AP, AR, FA, PO, INV, BOM, PA, OM, HR, OTL, OAB, Payroll, SCM,Oracle Discoverer. TECHNICAL SKILLS: ERP Applications: Oracle Applications R12, 11i (11.5.10/11.0.3), PA, AR, AP, GL, FA, OM, PO, INV, WIP, BOM, SCM,Payroll,OTL. Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Discoverer 3i/4i/9i, Developer 2000/6i/9i, Oracle 8i/9i, JDeveloper, Workflow Builder Databases: Oracle 11i,9i/8i/8.0/7.3, MS SQL Server 6.5/7.0 Database Tools: SQL*PLUS, PL/SQL, SQL*LOADER, TOAD TE.020 Languages: SQL, PL/SQL, Visual Basic, JAVA, HTML, C, PERL, Shell Scripting, JSP, JDBC, XML, UNIX Shell script Application Servers: Oracle10g Application Server, Websphere Application Server Version Control: PVCS, Subversion Operating Systems: UNIX, Solaris 7/8, Linux, Windows NT/2000, MS Dos EXPERIENCE: Mar 24 Present State of Rhode Island, Providence, RI Oracle Apps Technical Support Work with new requirements and enhancements, bug fixes on the Oracle Projects, Grants, Oracle Time and Labor and other financial modules. Experience with gathering requirements, documenting and technical development as per client requirement. Work with team on the day-to-day production issues. Work with Oracle PL/SQL, Reports, Forms, BI Publisher reports, Unifier reporting components and other AOL objects and setups as required. Jul - 2022 to HCL Americas, Cary, NC Nov -2023 Oracle Applications EBS Lead Work with offshore team in developing, enhancing the existing custom reports, programs for Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Order Management within Oracle EBS. Worked on supporting multiple teams for on-demand reports for Oracle EBS team with AP, AR, GL modules using PL/SQL programming. Work with functional team in assisting for the AOL object setups, invoice creation, build test cases within Oracle Applications system. Develop and create custom reports, PL/SQL, packages and views for the Oracle Financial components. Work with several teams in aligning EBS components involving Magnitude and SAP teams. Co-ordinate with Offshore resources on critical requirements, bug fixes, migrations, customizations and troubleshooting Oracle EBS objects involving various teams. Jul-2018 to American Towers, Woburn, MA Jun 2022 Oracle EBS Consultant Develop, enhance and fix various reports like Summary reports and Detail Reports for Lease Accounting to match the standards of FASB and IFRS using the BI Publisher and XML template for reporting. Fix defects for all Lease accounting issues within PL/SQL package, reports. Work with PL/SQL queries used for OBIEE reporting. Develop and create custom forms, reports, pl/sql functions, packages and views for all the Lease Accounting process involving the data integration with OBIEE and posting data to Oracle GL process. Co-ordinate with Offshore resources on critical requirements and troubleshooting the objects. Work with code fixes and data fixes for the Lease related components including PL/SQL packages, Reports, Forms, BIP reports, views, triggers. Work with development and enhancements of WEBADI components for Oracle modules. Work with business and team for requirements and drafting MD50, BR100 and MD70 technical documents. Work with set ups like Value Sets, Menus, Functions, lookups, concurrent programs, request sets loading data into tables and update GL rates, corporate rates and various AOL components. 02/18 to Sonus Networks (Ribbon Communications), Westford, MA Jun 2018 Oracle Apps (EBS) Consultant Designed, developed and tested the Purchasing programs for Approved Supplier List process, Sourcing Rules and Item Price Update, Remittance advice program etc., using Oracle API s. Developed a trigger on the Ship Confirm form to kick off the freight updates in backend and performed end-to-end testing involving business team. Worked on form personalization for Order to Cash (OTC) management and Purchasing custom forms like Sales order form, Ship Confirm form. Worked on the SLA issues for Invoice to populate correct code combination in the Accounting Field using a PL/SQL package. Worked with business in analyzing and setting up the Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options with respect to the requirement. Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file. Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data. Working on the Bug fixes and enhancements, personalization for Oracle Reports, Forms, OAF pages for modules such as AP, GL, OM, PO, SCM. 05/16 to CDM SMITH INC., Boston, MA 08/17 Oracle Apps Consultant Worked as a lead bridge between the offshore and onsite team on gathering Requirements, to collaborate with development team and test with the User team for Papervision application. Prepared a design document for End-tend flow of Concur to Papervision process and involved in the process end-to-end testing for AP Invoicing. Prepared the Technical Specification MD070 and Migration documents MD120 for the client. Involved with Production support team and Development team for AP, AR, Oracle Projects, PO and OTL and HRMS objects in fixing issues related to Oracle reporting, forms, packages, views, alerts and few data fixes. Developed Outbound Integration for client to generate employee data file and send email notifications to users. Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface Good working knowledge in implementing FAH for integrating various applications with Oracle EBS/GL for client requirements. Worked on multiple lift and shift custom objects involving 11i to R12 re-implementation process for AP, AR and HRMS components. Worked on the OTL Timecards Interface Reconciliation Report and scheduled for weekly run. Involved with a team in setting up Work Structures for defining HRMS User and Responsibility and Key Flex fields for HRMS, HR Self Service. Involved with the customization of custom OAF page for client payroll process using Jdeveloper. Involved with custom Discoverer reports to display required timesheet data for employee. Involved with team on SCM modules like Inventory Management, Demand Forecasting, Distribution Management, Warehouse Management to determine key areas of process optimization and integration in a global supply chain model. Involved with the setup of AOL objects for Concur-Papervision Integration process including the reporting for AP Invoices and Expenses using BI Publisher. Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases in which they are stored. Responsible for production support and administration and configuration of Papervision application. 03/14 to YALE UNIVERSITY, CT 04/16 Oracle Apps Consultant Responsible for Co-ordination activities, prepare requirement documents, Gap analysis. Responsible for writing user stories, testing, data validation, conduct user testing. Prepared user manuals, data flow and business flow documents for custom functionality. Prepared documents using AIM methodology. Assisted development team in data mapping and preparation of test scenarios. Conducted meeting with Business users, development team for clarifications and technical challenges. Involved in configuring Order to Cash (OTC) process including inquiry, quotation, sales order, shipping and billing information system. Resolved issues related to AP, AR, GL, iProc, PO, iExpenses as a part of Production support team. Worked on RICE (Report, Interface, Conversions and Extensions) Components related to Oracle applications. Personalized, extended and fixed OAF pages and issues for iExpenses, Commitments, Procurement, OTL and HRMS modules such as adding new tabs, modifying Payslip and Tax forms. Involved with defining personalization within Self-Service to meet business requirements. Worked with developing an outbound interface in Oracle HRMS for payroll processing. Queried multiple databases to develop reporting to streamline functions, assist in QA, data validation with different teams, ad hoc reports. Involved with System design and development required for business process and worked with technical staff to create, interpret, and implement business requirements into technical specifications for AP Processes involving the Payments, Suppliers and Invoices. Worked with BI Publisher reports in modifying the RTF templates according to Client requirement such as integrating BIP reports with OAF page for Faculty, modifying template to add new fields. Extended View Objects of seeded OAF page to add extra columns on the OTL page. Involved in creating validations at the View Object level for Custom OAF pages in OTL. 09/13 to TJX, Marlborough, MA 03/14 Oracle Apps Consultant Worked with IT Analysts in gathering requirements and in engineering Technical approach for Integrations related to AP, GL and in preparing Functional (MD50), Technical (MD70) design documents. Involved with development of PL/SQL packages for Integrations in AP, AR,GL,PO. Worked on Interfaces for importing Hyperion Planning to Oracle EBS GL. Worked with Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters during development for AP, AR, and GL. Worked with TJX specific MKS source control to track defects for every build. Involved in designing and developing new Project Costing Report in PA reports to suit business requirement. Developed Customer billing Retention on a contract project. Designed Interface/Conversion mapping related documentation by gathering information from business and working along with the Functional team to meet Client requirement. Designed and developed staging tables, conversion routines, custom PL/SQL on AP, GL within Oracle EBS. Explored with the options of RTF and PDF template for the OAF compatible report as per requirement for I9 enhancement process. 01/13 to CISCO SYSTEMS 07/13 EBS Consultant Responsible in handling the offshore development team and coordinating with Analysts and - Technical team in proposing/developing new objects. Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface Worked on the Cisco Custom Payments for Country enablement with different banks. Involved in preparing the Functional (MD50), Technical (MD70) design document and for the Cisco specific Payments-Unified Payments for different Countries. Developed PL/SQL packages for different components in AP, AR, GL, CE, OM, PO, and WIP. Developed PL/SQL scripts for Payment formats for different banks (JPM, BoFA, and CITI) within respective entities. Worked on RICE (Report, Interface, Conversions and Extensions) components for both custom and oracle applications. Involved with the scheduling tool Dollar U for daily/weekly/monthly loads for various Concurrent programs such as Journal Import, Auto Posting, Create Accounting, Invoice Validation, Employee Load, and Supplier Load. Worked with Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters during development. Created project structure to maintain versions on PVCS and used it to track defects for every build. Designed customizations, interface/conversion mapping, reproduction testing, and related documentation. Involved with defining AR Setups, Designing Invoices, and DFF for Invoices, Payment methods and Document Sequences. Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports-developed and executed test cases. Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR. Worked with AP, AR, PO reports like Returns report, Purchase Orders received not invoiced-Product; Purchase Orders received not invoiced-Non-Product, Check Register report, JRC Receipt Balancing report. Developed OA Framework Extensions for creating Expense reports. Used BI publisher to print, email and fax the reports and worked with e-text templates for the Payment format. Worked with RTF templates for custom reports. 01/12 to HARVARD UNIVERSITY, Cambridge, MA 11/12 Technical Consultant Retrofitted and Customized the Invoice workbench in R12 upgrade project reflecting the functionality of 11i with major inclusion of lines and Invoice types in R12 form. Customized and personalized AP, AR forms like HUAP Expense Report Post Audit Report, HUAP Withholding Tax Invoices Exceptions Report, and Heap Invalidated Invoices Report and HU Bottom-line Check format for HU Payments process. Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path. Configured AP, AR, and GL to perform the accounting for third party applications in Oracle EBS R12 module. Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications. Involved in configuring Order to Cash(OTC) process including inquiry, quotation, sales order, shipping and billing information system. 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 of RICE components. Involved with System design and development required for business process and worked with technical staff to create, interpret, and implement business requirements into technical specifications for AP Processes involving the Payments, Suppliers and Invoices. Written PL/SQL script to handle the Supplier data for the Supplier Merge Window in Suppliers (AP), custom process of implementing Purchase Orders (PO) and Invoice Matches (AP), OM, AR. Worked with the Web Reimbursements, Web Vouchers, and Web Advances Credit memo components within AP module. Maintained all the work done using PVCS. Also documented the work by creating various reference manuals for reference by future testers and users. Developed a BI Publisher report to extract the list of Customers and Suppliers for AP AR Netting Report to output in PDF, RDF and EXCEL on RTF using Desktop Client for BI Publisher version 11g. Developed staging tables, conversion routines and PL/SQL API to load the Open Legacy Purchase Orders (PO), Open Sales Order (OM) and Suppliers (AP) from legacy system. Developed a report using XML Publisher of the search results (Order bookable SKU s) from the Order Booking Validation report. Involved with the Functional team to design MD050 specifications and Technical specifications MD070 along with Installation guidelines and Unit testing processes for developed items following the standards of the Harvard University. Involved in customization of several reports to serve important business processes very specific to the client Payment Distribution Report, Payment Batch Control Report, 1042s/1099 Vendors and Invoice Exceptions Report, AP 1099 Post Audit Report, NACHA Report for banks in AR using e-text template. Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports-developed and executed test cases. 07/11 to BIOGEN IDEC, Weston, MA 01/12 Technical Consultant Created staging tables and control files to upload data from the legacy system using the SQL*Loader utility program. Involved and worked with migration team for all admin tasks. Experience in System Administration activities like Managing Concurrent Programs and Responsibilities. Developed and customized Financial Modules (GL, AR, AP, PO, OM, BOM), Interacted with end users to gather requirements and Draft specifications for development Phase. Designed, developed and documented an Inbound interface for AP Invoices. Developed a PL/SQL procedure to submit orders via the new EDI 850 process in place between Wholesalers, a third-party VC and Biogen Idec s Order Management system. Customized revaluation status report and responsibility report in General Ledger (GL). Designed and developed the Reconciliation process for GL module. Involved in Code Development, Unit Testing, Business Testing, Functional, Performance and Regression testing. Created Custom LOV region in iExpense Details Page to replace the existing MessageInputText (Textfield) on the page using JDeveloper (OA Framework). Involved in configuring the RBAC Security Administration in R12 for ASCP requests. Worked with Business Events and Subscriptions to trigger different functions for engineering items in Product Data Hub (PDH). Worked with the development team to research Metalink, log SR/TARs and resolve outstanding software issues related to latest patch set. Designed XML Templates, XML Publisher reports. These are Customized Dunning Letter report to use XML Publisher to mail the letters to customers in AR. Used Bursting technique to email the XML publisher output file. Designed and developed a report to compare the migration details of the order processing flow through a third party on an EDI platform. Designed and developed a BI Publisher 11g Report for End Users to review purchasing related ASCP Action messages fetching data from Oracle ASCP in combination with OPM and discrete Inventory master, AR Dunning Letters Generate report, AR Invoice Receipts. Designed and developed a custom report for printing Selected Delivery notes for Pick Release orders in Order Management system. 11/10 to TOWERS WATSON, Arlington, VA 06/11 Technical Consultant Written an API for Converting the Supplier Banks (AP) and Bank Branches from legacy system into Oracle database. Created staging tables and control files to upload data from the legacy system using the SQL*Loader utility program. Developed PL/SQL package for converting the legacy Suppliers and Projects and tasks based on Project creation API s to R12 database. Developed the setups for customer billing retention. Developed setups needed for inter-project billing Developed PL/SQL procedures for the Supplier Interface in Accounts Payables. Designed the Application Extension Technical Design Specification (MD070), Conversion Mapping (CV040) and Migration Instructions (MD120) documents for RICE items. Developed a SQL report to extract the Applied and On-account receipts in AR. Responsible for designing, developing and documenting an Outbound Interface for AP Suppliers from windows based applications to extract data to Supplier Answer Key. Imported data from legacy system into staging tables using SQL*Loader, perform validations prior to transferring data into OM Open Interface tables. Developed SQL*Loader control file and PL/SQL package (with Validations) for GL conversion. Created SR/TAR in metalink, got fixes from oracle support and applied patches with coordination of Apps DBA for Bug fixing. Involved with creation of background element sets in Core HR, Payroll and Projects and transferred those element sets into OTL. Development of new (Finance and Oracle Time and Labor (OTL)) reports using Reports 10g. Developed outbound interfaces to export Project/Task Lists from Oracle PA to external systems. Experience in extending self-service applications using Oracle Applications Framework (OAF). Involved in production support for Integration, System, and User Acceptance Testing (UAT). Involved in the design document for the RAR120 SWAT Analysis used to verify all db/apps level set up for migration. 07/10 to WRIGHT EXPRESS (WEX), Portland, ME 11/10 Technical Consultant Designed customizations, interface/conversion mapping, pre-production testing, and related documentation. Developed and customized Financial Modules (GL, AR, AP, PO), Interacted with end users to gather requirements and Draft specifications for development Phase. Did Accounts Payable set up and covered Vendor Maintenance, Invoice Processing, Payments, Payment Reconciliation and Period Close Process. Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements. Strong Oracle RICE development experience in all AP, AR, GL, PO and OM Modules. Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Vendors, Vendor Sites and Vendor Contacts. Configured AP, AR, and GL to perform the accounting for third party applications in Oracle EBS R12 module. Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA). Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into the GL interface. Customized forms using CUSTOM.PLL file to meet the specific requirements. Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data. Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements. Involved in the BIP server setup administration on the Unix box. Designed and developed complex BIP reports by working on RTF using Desktop Client for BI Publisher. Designed BI Publisher reports including RTF templates to meet the end user requirement. Developed custom reports Merchant Detail report, Tax Audit report, Opportunities report, Activity List report, Campaign Current Query report etc., by communicating and interpreting end-user business requirements. Registration of concurrent programs, defining value sets and parameters for customer reports specific to Applications. Keywords: cprogramm cplusplus quality analyst business intelligence database active directory information technology container edition purchase order microsoft procedural language Arkansas Colorado Connecticut Maryland Massachusetts North Carolina Pennsylvania Rhode Island Virginia