SUMMARY:

• Over 14+ years of extensive experience in designing, configuring,Implementation, Enhancement, Migration, Customization, Up gradation, Rollout and Support of various modules in Oracle Applications with major focus in Supply Chain Modules(SCM) Purchasing (PO), Inventory (INV), Order Management, and Finance Modules Payables (AP), General Ledger (GL), Project Billing, Accounts Receivables(AR), Fixed Assets (FA), Oracle Lease Management (OLM), Application Object Library(AOL) Advance Supply Chain Planning (ASCP), Customer Relationship Management (CRM - Field Service, Install Base, Depot Repair and Service Contracts), iStore, iSupport and Application Object Library (AOL) and Good knowledge in Bill of Materials (BOM), Work in Process (WIP), WMS, MES (Manufacturing Execution System), Cost Management
• Extensive experience in different Oracle E-Business flows in Order to Cash (O2C), Configure to Order (CTO), Quote to Cash (QTC), Return Material Authorization (RMA), Drop shipment, Procure to Pay (PTP), Assemble to Order (ATO), Make to Stock (MTS), Make to Order, Internal Requisition / Internal Sales Order(IR ISO) and Planning to Execution.
• Thorough understanding of As-Is Process, designed To-Be Process, gathered business requirement, performed gap analysis, throughout all phases i.e. CRPs, UAT, SIT Testing, Go Live and Production Support.
• Have worked on End to End R12 implementation, R12 migration/upgrades. Worked on 11.5.10 to R12.1.3, R12.2.3, 12.2.4, 12.2.5, 12.2.6, 12.2.9 Implementation, Upgrade and extension, Support Projects.
• Technically proficient in implementing RICE (Reports, Interfaces, Conversions, Extensions), ITR (Interface Table Reference), BI Reports like XML Publisher Reports, Oracle Discoverer Reports, SQL Reports and PLSQL packages.
• Experience in using Oracle tools like SQL*Loader, SQL* Plus, SQL developer, TOAD, WEBADI, UTL FILE, OAF, Oracle packaged APIs etc.
• Worked with Oracle Support (Metal ink) and logged several oracle service requests (SRs), Having working knowledge on Oracle Forms, Oracle workflows, OAF Frame work, Customized OAF pages.
• Having complete understanding and Experienced in Procure to Pay (P2P), Order to Cash (O2C), Record to Report(R2R) business flows.
• Substantial Oracle PL/SQL Development experience in creating stored Procedures, Packages, Functions, Triggers, Tables, Flex fields, Profiles, Value sets, lookups, Indexes and Views.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, and Object types and usedBULK COLLECTS, BULK BINDSin PL/SQL objects for improving the performance.
• Worked on Version Control software tools to check-in codes and integrated with KINTANA, Serena PVCS management tool, CVS for file migration and well versed with Defect tracking using spread sheet and testing tool such as HP Quality Center (QC) and requirement tracking tool such as Project Portfolio Management (PPM).
• Worked on Onsite-Offshore Software Testing Model, code review/self-review Checklists and Impact Analysis documents to prevent the defects from reoccurring with the learning’s from previous releases.
• Preparing Logical and Physical Data Model Diagrams, code review/self-review Checklists and Impact Analysis documents to prevent the defects from reoccurring with the learning’s from previous releases.
• Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.
• Expertise in requirement Analysis, Data Flow Designs, Support, development, testing UTS, UAT and STS, documentation and design reviews and Performance Tuning.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV040& CV070) and Migration documents (MD0120) using AIM Methodologies, Agile methodology and DevOps methodology.
• Excellent knowledge on project life cycles (i.e.) SIT, CRP/CAT, Go-Live activities and provided on-call and day-to-day Production Support and worked as a part of team in 24x7 production environment especially during month end and year closings.
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL. Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

TECHNICAL SKILLS:

ERP: Oracle E-Business suite EBS R12/11i/ 11.0.3/11.5.10.2 and 12c versions. Oracle Applications Modules worked on Purchasing (PO),General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Inventory (INV), Project Accounting (PA),Shipping, Fixed Assets(FA), Cash Management(CM),Oracle Lease Management (OLM), Work In Process (WIP), Bill Of Materials (BOM), SLA, AOL, System Administrator, Application Developer, RICE (Reports, Interfaces, Conversions, Extensions),Procure to Pay (P2P), Order to Cash (O2C),Record to Report(R2R), Worked on ITR Process, AIM methodology and Agile methodology, Production Support, Performance Tuning, Cloning, Error-Handling, Defect Prevention Anchor, SDLC, Onsite - Offshore Model.

Application Tools: D2k Reports 6i/10g, Oracle Reports 6i/10g, Oracle Forms, Oracle Workflows, Oracle BI Tools like XML Publisher Reports 5.6.3/5.6.2 , Discoverer Reports, Bursting and Oracle OAF.

Databases & Tools: Oracle R12 (12.1.3, 12.2.4, 12.2.5, 12.2.6),11g/10g/9i/8i,12c, Logical Data Model Diagrams, Advance Collections, Defect Prevention, TOAD, SQL Developer, SQL*PLUS, SQL*Loader, UTL FILE, WEB ADI, QC tool, HP Quality Center, WINSCP, Kintana, PVCS, Shell Script, Service now, HPSD.

Operating Systems: Windows NT/XP/2000/98, UNIX/LINUX.

Others: PowerPoint, MS-Word, MS-Excel, MS-PowerPoint, Visio.

Languages: SQL, PL/SQL, C, Core Java.

PROFESSIONAL EXPEREINCE:

Confidential, Portsmouth, NH

Oracle EBS Techno Functional Consultant

Responsibilities:

• Provides an integrated ERP system for the optical Sub-Assemblies that provides streamlined manufacturing processes in a more conventional way.
• Automate demand planning, costing, material control processes.
• Set up the revenue stream at Optical Sub- Assemblies level.
• Program and roll out developed solutions in Oracle /ERP based environment. Provide technical consultation to business units and IT management to ensure development of efficient application systems.
• Define requirements, configure standard applications, and provide gap analysis and design, and end-user support. Design and document Oracle ERP based solutions to meet business requirements.
• Design and build Custom Oracle RICEW components and unit testing. Assist in the design, configuration, and deployment of Oracle SCM/ Finance Planning applications in the e-Business suite. Manage Oracle data conversion activities. Assist in migration from legacy systems to Oracle e-Business Suite.
• Perform conference room pilots, user acceptance and other required activities for Oracle ERPimplementation projects.
• Utilize Oracle Databases11g, Oracle Applications R12.2.5, Oracle Manufacturing Modules - Inventory, Account Receivables, Account Payables, Costing, Work in Process, Bill of Material, Quality, Production Scheduling,Oracle MES, Oracle SCM Modules
• Oracle implementation, Upgrade and Support, Oracle databases, tables, PL/SQL, and SQL Developer, Discoverer Reports

Confidential, Keene, NH

Oracle EBS Developer

Responsibilities:

• Program and roll out developed solutions in Oracle based environment R12.2.5. Provide technical and functional consultation to business units and IT management to ensure development of efficient application systems.
• Perform RCA and other causal analysis techniques to identify the Root-Causes of the process failures.
• Perform dynamic data integration strategies so that business user will retrieve source data from a Customer files, main frame, MDM systems
• Oversees efforts to troubleshoot and performance tune Database objects
• Developed the out bound Interface to bring the CS ITEMS from Oracle Ebusiness suite name called ‘MDM’ to reclamation through ODI.
• Developed the Extensions for reclamation system Inbound stage tables
• Integrating the Angular and webservices with Oracle Reclamation system
• Design and build Custom Oracle RICEW components and unit testing. Assist in the design, configuration, and deployment of Oracle SCM/ Finance Planning applications in the e-Business suite. Manage Oracle data conversion activities. Assist in migration from Main Frame systems to Oracle Reclamation System
• Utilize Oracle Databases 12c, developing the Interface and Extensions and conversions to get the legacy data from Main frame and Customer Items into reclamation.
• Oracle implementation, Upgrade and Support, Oracle databases, tables, PL/SQL, and SQL Developer
• Project migrations across different DB and OS environments and Development to QA, QA to UAT, UAT to Production environments

Confidential, Milford, Connecticut

Sr. Techno Functional SCM & OLM Consultant

Responsibilities:

• Worked on New Enhancements in RMA, drop shipment, Order to Cash process.
• Involved in the customizations of Procure to Pay process in PO and REQ Workflow Approval Process which also consists of Time out feature, Termination policy.
• Handled customer requests for system enhancements, testing and maintenance
• Developed the interface dash report to see the Interface Errors based on the date.
• Worked on Interfaces to get the Legacy data from SAP using ITR Process.
• Updated the BR 100 documentation per the changed process.
• Developed Late Fee reconciliation report.
• Developed Custom reports, interfaces, personalization.
• Developed the custom JTF grid to show the delinquent accounts based on customer account in ERP and developed the JTF grid to show the delinquent account details based on Lease number in OLM.
• Worked on Trade receipts report using SQL
• Worked on Intercompany
• Worked on performance tuning on Lease Detail process, and Lease Detail Program was running for 15 hours to get the lease details and brought down to 5hours.

Confidential

Oracle Apps Sr. Technical OLM Developer

Responsibilities:

• Primarily responsible for all organizational needs that did not fit within one of the primary functions of the organization.
• Monitoring the Job scheduled processes
• Worked on Month end process activities
• Worked on Contract integrate the data between Oracle Contracts and Receivables
• Worked on Contract billing process
• Worked on Functional setups to make the contract in booked status
• Developed Amortization reports for France and Germany Operating Units
• Developed custom pick slip reports and packing slip reports for printing using Oracle developer 2000 report builder.
• Prepared MD 70, MD 120 As per the client requirement
• Worked on Sev1 issues and applied one shots to make contract booked status if any change in the existing contract or if any change in stream element
• Worked on data fix for the asset retirements and rebook contracts
• Worked on applied the stream element templates to contracts from backend
• Sending the Billing details to super trump and receiving xml files from super trump
• Worked on internal bill generation for the invoices
• Worked on Integration between AR and Oracle Contracts
• Monitoring the daily job schedules
• Responsible for Code moves and provided data fixes to Confidential wherever required.
• Involved in outbound activities - Invoices/Customers extraction and validations.
• Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.
• Constantly monitor and report on progress and issues of the project to all stakeholders.
• Conducting Technical Review & Code Walk through for fixing the issues and also Test scripts review like UTS, UAT and STS.
• Involved in outbound activities - Invoices/Customers extraction and validations.
• Analyze and work for the resolution of technical issues related to Financial application modules.
• Training and guidance to Trainee’s in Process and technical Knowledge.

Environment: Oracle Applications EBS11i, R12, TOAD, PO, OM, INV, WIP, BOM, I Supplier Management, Oracle Reports10g, UNIX, PL/SQL Developer, Order to Cash (O2C),Procure to Pay(P2P), Onsite - Offshore model, Enhancements, Support, BI/XML Publisher, Bursting, Forms, OAF, Java Version Control, KINTANA, CVS, QC tool, MD70, Performance Tuning, Test Cases preparation, RCA,HP Quality Center, WINSCP, MS-PowerPoint, Visio, SQL*PLUS, SQL*Loader, UTL FILE, Shell Script, Error-Handling, UNIX.

Confidential

Responsibilities:

• Preparation of Technical specifications MD70 from the functional specifications received from the functional team.
• Worked on BOM splitting functionality to enable user to break down a PTO model at option level to make necessary changes while placing quote
• Worked on Conversions and Enhancements in Procure to Pay and Order to Cash process.
• Developed WIP JOB Kitting reports, Developed Move Order report, Developed the Purchase Orders Report.
• Worked on Revenue Recognition report
• Worked on Planning report(ASCP)
• Worked on receipt generation process
• Worked on Quote analysis report
• Worked on Preparation of TE20 documents
• Worked on Drop shipments, IR/ISO, Back to Back order process
• Worked on Interfaces to get the Legacy data from 3rd party system Supplier using ITR Process.
• Developed Sales Order Conversion code
• Developed the code for GPRS process
• Developed Epack form and customized as per requirements.
• Developed and Customized Reports, Packages, Procedures as per the CR’s.
• Developed AR Invoice Print Report for Various Operating Units
• Conducted Technical Review & Code Walk through for fixing the issues and performed independent unit testing.
• Developed new package for the BCP program for R12 Go live
• Primary point of contact for new Projects like GPRS.
• Developed the new form for Global Parts Repairing System as per client requirements
• Visited Client Location (Milwaukee, WI) for R12 Go - live
• GPRS Status tracking OAF Page and Developed customerdiscount OAF Page.

Environment: Oracle Applications EBS11i, R12, TOAD, OM, INV,WIP,WMS, AR, AP, PO, GL, Shipping, Oracle Reports10g, UNIX, PL/SQL Developer, Order to Cash (O2C),Procure to Pay(P2P), Onsite - Offshore model, Enhancements, Support, BI/XML Publisher, Bursting, Forms, OAF, Java, Version Control, KINTANA, CVS, QC tool, MD70, Performance Tuning, Test Cases preparation, RCA,HP Quality Center, WINSCP, MS-PowerPoint, Visio, SQL*PLUS, SQL*Loader, UTL FILE, Shell Script, Error-Handling, UNIX.

Confidential

Global Applications Maintenance and Support

Responsibilities:

• This role will be the primary support for day-to-day production support requirements, minor enhancements, and ensuring that our Service Level Metrics are met consistently.
• Ability to manage multiple poles simultaneously within Confidential GAMS-Juliet like fusion, gasification, C2C, Germany & Spain.
• Worked on code modifications and project enhancements based on client requests.
• Preparing MD70 Technical documents for the CR’s (change requests) received conferring to Confidential standards.
• Smoke tested multiple RICE items prior to each testing session including the customized mobile forms such as “PO input value copy”, the barcoded custom reports such as BOL report and expected receipt report.
• Performed Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Code migration activities from one database to another database using client specific.
• Coordinated with 3rd Party (WCS) Systems for Integrations.
• Working closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.
• Conducting Technical Review & Code Walk through for fixing the issues and also Test scripts review like UTS, UAT and STS.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle Applications EBS R12, TOAD, PO, OM, INV, AP, AR, BOM, CM, GL Reports10g, UNIX, PL/SQL Developer, Enhancements, Support, BI/XML Publisher, Performance Tuning, Cloning, Version Control, KINTANA, WINSCP, 24/7 Support during Month end, CRC, SLA, Project Creation, MD70, Test Cases preparation, RCA, Quarter end, Yearend closures, Service now, Jeera, HPSD, MS-PowerPoint, Visio, SQL*PLUS, SQL*Loader, UTL FILE, Shell Script, Error-Handling, UNIX.

Confidential

Senior Technical developer

Responsibilities:

• This role will be the primary R12 implementation and worked on OM, PO, INV, Shipping Modules
• Preparation of Technical documents like MD70, CV60 documents and involved in TE20 test script documents
• Worked on Order Management processes like Back 2 Back Order and Assemble to Order and Engineering Change orders.
• Contributed as a key resource for the team.
• UpgradedOracle 11i to R12in different environments for latest features.
• Code migration activities from one database to another database.
• Worked on Epims interface, Worked on Primavera Interface.
• Worked as DP (Defect Prevention) Anchor to find out the possible solutions and action items to prevent those defects from recurring.
• Conducted Technical Review & Code Walk through for fixing the issues and also Test scripts review like UTS, UAT and STS.
• Worked closely with Oracle, Sys-admin & DBA teams for regular Patch Applications, Outages, data fix, code fix, Scheduling of several scheduled requests.
• Involve functional expertise in design reviews and key decisions as well as risk strategies.
• Prepared code review/self-review checklists and impact analysis documents to prevent the defects from reoccurring with the learning’s from previous releases.
• Closely interacting with user in deriving delivery dates of components and driving team in a direction to achieve the same deadlines.

Environment: Oracle Applications EBS R12, TOAD, AR, AP, PO, INV, OM, Shipping, INV, GL, Oracle Reports10g, UNIX, PL/SQL Developer, CVS Implementations, Enhancements, Rollouts, SLA, BI/XML Publisher, Production Support during Month end, Quarter end, Yearend closures,MD70, Test Cases preparation, RCA, Cloning, Version Control, KINTANA, PVCS, WINSCP, Jeera, MS-PowerPoint, Visio, SQL*PLUS, SQL*Loader, UTL FILE, Shell Script, Error-Handling, UNIX.

Confidential

Senior Oracle Technical Consultant

Responsibilities:

• Preparation of Detailed designs, Build, Code walkthrough, resolving technical and design issues and performing independent unit testing.
• Closely worked Users at Confidential Business Park, Dubai
• Prepared of Technical specifications from the functional specifications received from the functional team.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Created scripts to createnew tables, views for new enhancement in the application using TOAD.
• Creating value sets for report parameters and registering them in applications.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging tables into interface tables.
• Worked extensively in tuning SQL statements to optimize the performance by using collections.
• Responsible for Unit Testing and test plans.

Environment: s: Oracle EBS 11i

Modules: Oracle Leasing, PO, AP, GL

Confidential

Technical Developer

Responsibilities:

• Developed Reports and Customized as per the CR’s.
• Preparation of Technical specifications from the functional specifications received from the functional team.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Developed AR Dunning letter report
• Converting the technical specification into technical design documents.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Created value sets and lookups for report parameters and registered them in oracle applications.
• Responsible for Unit Testing and test plans for Normal and XML Reports.
• Develop & debug PL/SQL, Create Execute and Optimize SQL queries while providing an interactive community to support the user experience by using TOAD.

Confidential

Associate Consultant

Responsibilities:

• Prepared of Technical specifications from the functional specifications received from the functional team.
• Converting the technical specification into technical design documents.
• Created value sets for report parameters and registered them in oracle applications.
• Created scripts to createnew tables, views, Synonyms and triggers.
• Developed custom reports and interfaces that are registered as concurrent programs and which are run from SRS form.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Created Concurrent Programs, Executables and AOL objects.
• Developed procedures, functions and cursors.
• Developed XML Reports using XML Publisher.

Confidential

Analyst

Responsibilities:

• Involved in the Implementation and Post-Implementation Support
• Created Technical design and implemented appropriate system setups and security rules.
• Customized PO account generator, Supplier invoice account generator.
• Communicated with Oracle on various bugs and issues seen during the R12.0.5 implementation.
• Developed the Auto Invoice process in AR for importing sales orders.
• Prepared functional design documents for new reports required during the closing process.
• Prepared UAT scripts and work instructions as part of user training, trained user on closing process.
• Worked on forms personalization to personalize several forms as per the client’s needs.
• Used SQL*Loader to import data into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Converted Inventory item on-hand quantity from the legacy system.
• Developed a Custom Forms in Inventory to maintain different projects and accounts handled by the company.
• Worked on the Procure to Pay process including handling the data conversions for Open Purchase Orders, Vendor Conversion, Open Invoices in AP, Payments in AP, Items in Inventory, etc.
• Developed Shell script for Oracle to Saba Outbound Interface, which is scheduled to run daily that extracts transaction details and Sales Order details for all the Customer POs in Saba Application.
• TCA Conversion - Developed a conversion program to load all the Customers from the external legacy system into the TCA Architecture including HZ PARTIES, HZ CUST ACCOUNTS, HZ RELATIONSHIPS, HZ CONTACTS, HZ CONTACT POINTS, etc.
• Worked on the Payments module for defining the wire transfer payment method and to setup the mapping file with the bank to send electronic payments.
• Developed Interface Technical Specification Document for Customs Duty Billing, The scope and
• Developed PL/SQL stored procedure for credit memos containing training unit items, which is scheduled to run daily to generate accounting entries for the credit memos
• Developed new custom reports and also customized standard reports according to business requirements using Oracle Reports Builder
• Designed functional documents MD50s and technical documents MD70s for all the new reports developed.
• Involved in monitoring of the objects developed as part of production support
• Developed migration documents for all the developed components.