PROFESSIONAL SUMMARY:

• Having 16+ Years of Experience in Oracle Finance/SCM/Manufacturing Techno - Functional Consultant in Oracle Applications e-Business Suite (11i & R12), Oracle Cloud Finance Fusion Application (R13) & Oracle Integration Cloud (OIC) Pass
• Exposure in the areas of Oracle Applications Modules in General Ledger(GL), Account Payables(AP), Accounts Receivable (AR), Cash Management(CM), Fixed Assets(FA), Purchasing (PO), Order Management (OM), Inventory (INV), Bill of Material (BOM), Work in Progress (WIP),Oracle Transport Management(OTM) and Oracle Learning management(OLM), Oracle Lease management(OLM) & Oracle Clinical Management(OCM)
• Experience in Oracle Application Implementation, Enhancement, Rollout, Upgrade, Integration, Data migration, Customization, Production Support in Oracle Application (11i & R12)
• Exposure in Oracle SaaS Cloud implementation experience with Oracle Fusion Modules of Financial implementation /Support project(R13)
• Experience in Oracle Integration Cloud (OIC) using agent group Integration components Integration Cloud Service (ICS), Process Cloud Service (PCS) and Visual Builder Cloud Service (VBCS).
• Having Experience working on complex integration in OIC/EBS using REST APIs(End Point)/SOAP Services
• Expertise in building complex integration processes, integrating cloud-based and On-Premise Enterprise Applications.
• Hands-on design, development, deployment, and maintenance of integration processes between on premise\cloud system and other 3rd party applications
• Experience OIC adapters, usage of REST, SOA adapters, usage of orchestration integration patters
• Experience in REST APIs/End Point, SOAP Web Services and FBDI Templates in Oracle Cloud.
• Experience in Oracle Cloud reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP)) to develop new reports and enhance standard ERP Cloud reports in Cloud Finance Module.
• Experience in Procure to pay life cycle (P2P) & Ordered to Cash (O2C).
• Experience Gap Analysis for the requirements and the possible work around solutions in Oracle
• Expertise Flow diagrams creation and documentation of business and system processes
• Requirement mapping and translating the requirements into functional specifications
• Experience in Business process study, requirement gathering set up configuration and documentation.
• Task and responsibilities performed include Work around, Development, application setup, documentation, training, testing, and preparation of end user manuals
• Experience in using Oracle AIM of project implementation methodology and preparation of BP040, BR100, MD050, TE040, MD070, TE020, MD120 and Conversion Templates, User Manuals, Training Material Preparation
• Technically proficient in RICEW components (Report, Interface, Conversion, Extension and Workflow)
• Having experience in Oracle Apps Upgrade Project from R12.1.3 to R12.2.9
• Having Good Exposure in Data Migration and worked as a Technical Team Lead with data transformation, data cleansing & data validation team
• Expertise in requirement analysis, System design, Data Flow Designs, supports, development, testing,Documentation and design reviews
• Having Good Experience to Managed the Oracle critical SR’s and Spin SR
• Having Good Team Handling, Project Management and Client Management skills.
• Experiences in Onsite and Offshore Model Team Handling.
• Good communication and presentation skills
• Good Analytical skills and Planning and Co-ordination skills

TECHNICAL SKILLS:

ERP Modules: Expertise Oracle E-biz Suite Financials (GL, AP, AR, FA & CM), SCM (INV, PO)

Manufacturing: (INV, WIP, BOM), Oracle Transport Management (OTM)Oracle Learning Management: (OLM), Oracle Clinical Management in 11i,R12 & R13.

Tools: & Utilities: SQL Developer 19.2.1.247, Oracle Data Base 9i, 11g, 12C, 19C, Data loaderMSVisio, MSOffice: 2003, 07, 08, PUTTY, WinSCP, SQL*Loader, XML 12.0.0, Oracle Report/Form 6i, 10g, Oracle Workflow Builder 2.5, SoapUI 5.6.0, Postman v7.32.0

Operating Systems: Windows 2007 NT/XP, UNIX, MS-Dos.

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional & Technical Lead

Responsibilities:

• Working as a Techno-Functional/Technical Lead and Developer for this Oracle Apps R12.2.9 Upgrade Project
• Involved in understanding the business process requirement& upgrade changed Cemli Objects from R12.1.3 to R12.2.9
• Coordinate with all project Stake holders & Team at Onsite & Offshore.
• Involved in System Integration testing after upgrade the Oracle Apps system in R12.2.9.
• Responsible to Run the ConfigSnapshot tool to find the Customization impact analysis report of Oracle EBS R12.2.9 after upgraded.
• Responsible to identify all the impacted Object after Upgrade the system and provide the solution to customer.
• Responsible for code review, document review, Document/Code versioning and file management control in GitHub & Vitamix Common Share point.
• Worked with FNDLOAD utility to migrate objects from one instance to another instance till Production.
• Run the GSS Program to Improve the performance after upgrade the system performance issue
• Tweak the code and created custom Indexes after upgrade performance issue of custom Interface and XML Publisher Report issue based on Tkprof and Trace File analysis.
• Worked on Oracle Business Event/Alert/Form Personalization/Custom Hook &Custom Pll, XML Reports
• Worked on to Modify the Vitamix Auto Receipt custom concurrent program after upgrade the system due to Oracle system Bug in R12.2.9.
• Worked on to modify the Dr. Address Validation Custom Program after Upgraded data base from 11g to 19C.
• Worked on PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes for modification and retro fitment in upgraded 19C Oracle Data base.
• Developed BR100, TE040, MD070, TE020 and MD120 Documents
• Technical Support, Guidance and Planning for Code migration from Development through Production
• Managed Oracle Critical SR and Spinning SR with Oracle during Oracle Upgrade Time
• Managing the Tickets, resolving the issues on day-to-day basis on priority after Go-Live.
• Interacting with Users for required information about the issues arise.
• Resolving user’s day to day functional issues by understanding and analysing them.
• Raising Service Request with Oracle for resolution of Critical and Transactional issues.
• Responsible for post go live support resolution delivery
• Testing new business requirements in the Test Instance and validating the same in Production.
• Handling situations for run time problems and suggesting the work around.
• Interacting with Project manager on daily and weekly basis and submitting status report’s
• Delivered objects on time for CRP, SIT, UAT, MOCKPRD &PROD in Oracle Application Upgraded Instance R12.2.9

Confidential

Oracle Fusion Techno- Functional

Responsibilities:

• Involved in understanding the business process Requirement.
• Worked as Application Implementation Consultant Roles.
• Worked on GL, AP, AR, CA & FA Tasks for setup in Oracle Cloud Application
• Worked on to Manage Daily Rate using FBDI Templates, Load using Import and Calculate Daily Rates Programs.
• Worked on an integration to import GL Journals into ERP Cloud using Oracle Standard Web Service WSDL.
• Worked on inbound integration for Customer Creation/Update in ERP cloud to Integrate Sales force in Oracle ERP Cloud using Salesforce Adapter
• Worked on tasks for Primary Ledger in Oracle cloud which includes 4C’s (Calendar, Currency, COA, Convection).
• Define the Value sets, segment structure and Values as per the Business requirement in Fusion.
• Worked on Assigning Legal Entity to Ledger.
• Assign Balancing segment Values to the legal entity.
• Define common options for payables and procurement.
• Worked on Define AP Payment Terms and map with RDS.
• Worked on the Invoice creation and Distribution set.
• Worked on invoice creation from spread sheet
• Define on Payment Process Profile in Oracle fusion.
• Worked on creating supplier and supplier site.
• Worked on Standard Invoice Processing, Credit Memo, Debit Memo and Accounting.
• Worked on Supplier Refund Process and Bills Payable setup & process.
• Worked on Pay alone setup and process.
• Worked on cross currency and payment process.
• Worked on Third Party Payment in Oracle Fusion.
• Worked in Multi Org Environment and Configured the system as per client requirement.
• Worked on Sub ledger Accounting.
• Worked on Automatic Reconciliation
• Worked on External cash transaction (manual process & Auto Process)
• Responsible for document review and Unit Test case Preparation.
• Work on to develop new reports and enhance standard ERP Cloud reports using reporting tools (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP))
• Worked on in Account Receivables Tasks(setup) System Options, Transaction Types, Transaction sources, Auto Accounting, Assign AR Job roles to the user, provide data access to the AR job roles, AR Payment Terms, Statement Cycle, Collector Creation, Create Customer, Create Remit to Address, Create Memo Lines, Create Receivables Activities, Create Receipt Class & Method, Create Receipt Source
• Worked on in Fixed Asset Tasks(setup) Category Flex field Value set, Location Flex field Value set, Asset key Flex field Value set, Category structure & structure instance, Location structure & structure instance, Asset key structure & structure instance, Create values for category structure, Create values for Location structure, Create values for Asset key structure, Configure system controls, Define fiscal years, Define asset/deprecation calendar, Define Prorate Convention, Define asset/ Corporate Book
• Handling the Service Now Tickets, resolving the issues on day-to-day basis on priority.
• Interacting with Users for required information about the issues arise.
• Testing new business requirements in the Test Instance and validating the same in Production

Confidential

Techno-Functional & Technical Lead

Job Responsibilities

• Worked as a Techno-Functional, Technical Lead and developer for this project.
• Interacted with end users to understand the business requirements from offshore.
• Coordinate with all projects Stake holders (SAP, Oracle EBS & Webvan Team) at Offshore and Onshore.
• Managed Senior Management Review (SMR) Meeting and Customer with weekly.
• Worked on to prepare the mapping documents for inbound/Outbound interface Programs
• Worked on to prepare the High-Level Design document for Outbound/Inbound interface parallel processing Program from Oracle Apps to SAP Integration
• Developed a common PL/SQL Package Code Block Engine to generate the SAP code block string, this value is held in a DFF on the Accounting segment, the engine translation mapping values/data between Oracle & SAP and used for AP, AR & GL Interface programs
• Worked on to developed the web service all the parallel processing program using SOAP(WDAL to WSDL) format
• Involved in technical design and development of the Interfaces “Marvel - FI001 AP Invoice Parallel Program”
• Involved in technical design and development of the Interfaces “Marvel - FI095 AR Invoice Parallel Program”
• Involved in technical design and development of the XML Report “Marvel - FI001 AP Invoice Interface Error Report”
• Involved in technical design and development of the XML Report “Marvel - FI095 AR Invoice Interface Error Report”
• Involved in technical design and development of the XML Report “Marvel - Code Block Engine Error Report”
• Responsible for code review, document review, Document versioning and file management in SVN & PVCS.
• Worked with FNDLOAD utility to migrate objects from one instance to another instance
• Writing PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes
• Technical Support, Guidance and Planning for Code migration from Development through Production
• Responsible for post go live support resolution delivery
• Development of packages & procedures as per client coding standards.
• Registrations of AOL objects
• Based on Marvel process design MD50, TE040, MD070, TE020, MD0120 Documents
• Involved in Development Integration testing for all the Integration objects.
• Maintain common package to create common objects Preparation of SQL loader scripts.
• Delivered objects on time and successfully completed this integration Implementation project

Confidential

Techno-Functional & Technical Lead

Job Responsibilities

• Contributed as a Technical Lead for this project and worked as a developer in times of need basis.
• Involved in understanding the business process Requirement and provided solution for this integration
• Coordinate with all Project Stake holders at Onsite & Offshore
• Responsible for code review, document review, Document versioning and file management in SVN & PVCS.
• Worked with FNDLOAD utility to migrate objects from one instance to another instance
• Writing PL/SQL procedures, packages, Data base triggers and Functions, tables, sequence synonyms, views and indexes
• Technical Support, Guidance and Planning for Code migration from Development through Production

Confidential Oracle

Techno-Functional & Technical Lead

Job Responsibilities

• Worked on with customer to understanding the business process Requirement
• Coordinate with all project Stake holders at Onsite & Offshore
• Involved in technical design and development of the Interfaces for the Integration
• Developed Confidential PROS Product Dimension Interface Program.
• Developed Confidential PROS Customer Dimension Interface Program
• Developed Confidential PROS Sales Org Dimension Interface Program
• Developed Confidential PROS Currency Dimension Interface Program
• Developed Confidential PROS Date Dimension Interface Program
• Developed Confidential PROS List Price Lookup Interface Program
• Developed Confidential PROS Sales Cube Interface Program
• Developed Confidential PROS Ready to Process Interface Program
• XML File generation Process and FTP Process Quality checks
• Worked on APEX to Developed Custom Forms for all the above interfaces
• Responsible for code review, document review, Document versioning and file management in SVN
• Worked on SQL Loader Programs Development
• Worked with FNDLOAD utility to migrate objects from one instance to another instance
• Writing PL/SQL procedures, packages, Data base triggers and Functions, Tables, Sequence Synonyms, Views and Indexes
• Developed MD70, TE20 and MD120, Documents for all components.
• Technical Support, Guidance and Planning for Code migration from Development through Production

Confidential

Data Migration Development Technical Lead/Developer

Job Responsibilities

• Coordinate with stakeholders to understand the requirements.
• Worked on to Support data transformation team
• Worked on to Support data validation team
• Worked on to design and development of Item, Locator, Stock Level, Routings and Bill of Material, Purchase Order, Skip Lot & Sourcing Rule, Payable Invoices, GL Interface Data Migration Programs.
• Worked on the bug fixes during the testing and support phase. (UAT & PROD).
• Worked on development of new XML reports, Form customization & personalization, XML BI Publisher Reports.
• Developed Receiving Process Auto Delivery Transaction interface e program in Oracle Purchasing
• Developed GL Daily Rates Conversion program by using Interface
• Responsible for code review, document review, code versioning and maintaining the same in SVN.
• Worked with FNDLOAD utility to migrate objects from one instance to another instance
• Writing PL/SQL procedures, Packages, Data base triggers and Functions, Tables, Sequence Synonyms, Views and Indexes
• Developed MD50, MD70, CV60, TE20, and MD120 Documents.
• Worked on Support post go live activities
• Developed Confidential Tax Credit Extract to Payroll Concurrent Program.
• Developed Confidential Transfer (FTP) Tax Credit files to Payroll.
• Confidential Payroll to Tax Credit tables -FTP and Upload.
• Confidential Payroll to Tax Credit tables - FTP
• Developed Confidential Tax Credit Extract to Payroll Concurrent Program.
• Developed Confidential Transfer (FTP) Tax Credit files to Payroll.
• Confidential Payroll to Tax Credit tables -FTP and Upload.
• Confidential Payroll to Tax Credit tables - FTP
• Developed 7 XML Publisher Reports for Confidential Ohio Tax Credit Reporting in Oracle HRMS and Payroll.
• Developed Active and Retired Asset XML Reports in Oracle Fixed Assets.
• Developed Oracle Standard 23 database PL/SQL custom procedures (for flex-builder to use) for the new book (MEXICO TAX BOOK) to run depreciation program successfully through flex-builder to generate accounts in Oracle Fixed Assets
• Responsible for post go live support resolution delivery

Confidential

Technical Developer

Job Responsibilities

• Developed Joining Instruction Notification workflow using API User Hooks in Oracle Learning Management to send the email notification to the learners.
• Developed Financial Payment Run Extension using custom Hook to validate invoice during invoice validation time in Oracle Payables.
• Developed Payroll Cut-off Extension using API User Hooks in Oracle HRMS for creates/updates/deletes” the absence from self-service and for creates/updates the bank payment method from self-service.
• Developed MD070, TE020 and MD120 Documents for all the development components
• Duties include interaction with onsite for Requirement gathering, modification of
• Components as per client requirement, implementation & documentation.

Confidential

Technical Developer

Job Responsibilities

• Developed FLS CN SHG Sales Order BOM Report in Oracle Order Management.
• Developed FLS CN SHG Printed Purchase Order Report in Oracle Purchase Order.
• Developed FLS Receivable AR Receipt voucher Printing Report in Oracle Receivable.
• Developed FLS Prepayment Status Report in Oracle Payables.
• Developed FLS CN Bank Accounting Book Report in Oracle Payables.
• Developed FLS Invoice Aging Report in Oracle Payables.
• Developed FLS CN SHG WSH Packing Slip Report in Oracle Order Management.
• Developed FLS CN SHG PO Receipt to Inventory Report in Oracle Purchase Order.
• Developed FLS Receivable AR Transaction Voucher Printing in Oracle Receivable.
• Developed MD70, TE20 and MD120 Documents for all components.

Confidential

Technical Developer

Job Responsibilities

• Worked as Technical Developer, using Oracle Applications R121.3.
• Developed Oracle Custom Oracle Reports using Reports10g.
• Worked on development of Oracle XML/RDF reports.
• Worked on Item, On hand, Item Locator Conversion Programs
• Developed MD70, TE20 and MD120 Documents for all components.
• Developed Test Cases for Reports, Alerts, Interfaces and Conversions
• Developed system Test Cases & System Test Plan documents
• Converted/Upload Test cases into Quality Center format
• Worked on to mapped Test Cases to requirements in Quality Center
• Involved in Development Oracle Custom Integration Testing
• Involved in System Integration testing
• Developed Common PL/SQL Package to used objects where applicable
• Preparation of SQL loader scripts to load the data into Staging Table to process in Oracle Apps System.
• Developed Understanding documents and corresponding Technical documents.
• Worked on to creation of Data group, Request group and custom menu.
• Writing PL/SQL procedures, packages, Data base triggers and Functions. Creating custom objects like tables, sequence synonyms, views and indexes

Confidential

Technical Consultant

Job Responsibilities

• Developed Customer Conversion Program in Oracle Receivable
• Developed Account Payables Open Interface for Prepayment in Oracle Payables
• Developed Customer Extract Out Bound Interface in Account Receivables.
• Developed New Report Hyatt AR Invoice Report in Xml Publisher in Account Receivables.
• Developed New Report Credit with Suppler Report in Account Payables.
• Customized Oracle standard Report “Customer Listing Details” in Account Receivables.
• Customized Oracle standard Report “Customer Listing Summary” in Account Receivables.
• Customized the Oracle Standard Report “Cash in Transit Report” in Cash Management.
• Customized the Oracle Standard Report “Bank statement Detail Report” in Cash Management.
• Customized the Oracle Standard Report “Invoice Aging Report” in Account Payables
• Customized the Oracle Standard Report “Aging - 7 Buckets - By Account Report”
• Customized the Oracle Standard Report “General Ledger - (180 Char)”
• Customized the Oracle Standard Report “Transaction Available for Reconciliation”
• Customized the Oracle Standard Report “Unapplied Receipt Register”
• Writing PL/SQL procedures, packages, Data base triggers and Functions. Creating custom objects like tables, sequence synonyms, views and indexes.
• Duties include interaction with daily basis onsite for Requirement gathering, modification of Components as per client business requirement, implementation & documentation.
• Developed MD070, TE020 and MD120 Documents based on Oracle Application Implementation Methodology (AIM).
• Follow the coding standard during developed the code based on customer coding standard document.
• After Go-Live provided the production support to resolved simple/complex issue based on priority in tickets.

Confidential

Technical Consultant

Job Responsibilities

• Developed Custom Concurrent Program Using PL/SQL Package for Advance /progress Funding Interest Billing
• Developed Custom Concurrent Program Using Pl/SQL Package for Uncollected Advance /progress Funding Interest Billing
• Create 3P for advance booking Interest Billing Custom Concurrent Program. This 3P will be support various Interest treatment option while the contract is booked in 3P
• Customized the Oracle Standard report Cancellation reason Report
• Design MD070, TE040 and MD120 document based on Oracle Application Implementation Methodology (AIM).
• Developed all the Interface/report based on the DLL Coding Standard documents.
• Writing PL/SQL procedures, packages, Data base triggers and Functions. Creating custom objects like tables, sequence synonyms, views and indexes.
• Duties include interaction with client for Requirement collection, modification of modules as per requirement, implementation & documentation.
• Worked on to generate LDT files for Concurrent Programs, Value Sets and Request Groups.

Confidential

Technical Consultant

Job Responsibilities

• Developed Custom Reports to display the Grower Name, Village Name, Center Name, and Date of Delivery of Can by Grower to help Management take decisions.
• Create one custom Form to enter the subscriber details and the subscriber details, system will auto generation of a unique subscriber’s number.
• Developed a custom Report to display the details of the tariff of crop which tariff is decide by Government
• Developed Proof of Delivery Slip Report, there will be a concept of POD (Proof of Delivery) according to which the subscriber on receiving the product will confirm so to the organization by signing a Proof of Delivery slip.
• Generate Grower Payment Invoice Report based on the Grower Details.
• Create Master Form to keeps details of the tariff of crop which tariff is decide by Government
• Master Forms will be created which are generated predefined masters maintaining unique data to avoid redundancy
• Data security is maintained to relatively high level by implementing it at Database level, to ensure that only authorized users have access to confidential client information
• Attached custom Form and Custom Reports in Custom Menus of Can Management Custom Application
• Given Support to Production Unit in shift Basis and resolved the production issue as high priority
• Design the Technical, Test Case documents using Confidential Standard word doc Template
• Responsible to send all the report which Management is required on daily basis.
• Coordinate with system Users and Can Manager, Finance Business Manger to Understand and resolved the any Production Issue.

Confidential

Technical Consultant

Job Responsibilities

• Create Master custom table to keeps the details information of adds such as add type, add description, and add categories that used in Oracle Form to enter the transaction by business user.
• Developed custom corporate client details report to display the details information of adds such as add type, add description, and add categories.
• Create Custom Form and Report to keep track the add booking and along with Date of advertisement, Zone, Country or upcountry, Rate, colour type, Size.
• Developed invoice generated report based on payment mode, total Adds, customer code R.O Number from the booking and docket no
• Submission of Weekly reports to the Client and Internal Management Service Now Ticket Statuses
• Managing the Tickets, resolving the issues on day-to-day basis on priority.
• Design the Technical, Test Case documents using Confidential Standard word doc Template
• Writing PL/SQL procedures, packages, Data base triggers and Functions. Creating custom objects like tables, sequence synonyms, views and indexes
• Given Support to Production Unit in shift Basis and resolved the production issue as high priority
• Coordinate with system Users and Can Manager, Finance Business Manger to Understand and resolved the any Production Issue.