PROFESSIONAL SUMMARY:

• A Senior Oracle EBS/Cloud Techno Functional Consultant & Solution Architect with Over 15+ years of experience in Oracle EBS and Oracle Fusion Applications with Implementation, up gradation & Support project experience worked on delivery of various sizes.
• Good Experience Implementing the ERP, Cloud & e - commerce projects in various countries worldwide and working with the consultants & users globally.
• 5+ years of Work experience with IBM Global & 2+ years with Tata Consultancy Service.
• 10+ Years of hands on experience in SCM &MFG Modules like Order Management, Oracle Purchasing, Inventory, Advance pricing, ASCP, BOM, WIP.
• Expertise in SCM, CRM (Install Base, service contract) & Finance Modules of different oracle application releases.
• Work Experience in Latest Releases of Oracle Applications like R12,R11 & Oracle Fusion Cloud release 12 & 13
• Excellent process & Working knowledge of Inventory, Order to Case (O2C), Procure to Pay (P2P), Install base & service contract Modules...
• Good Experience in managing & coordinating various teams in onsite-offshore Model.
• Expert knowledge in RICE components & Latest ERP technologies like ADF & XML Publisher.
• End to End Experience of implementation experience of multiple projects of Oracle Fusion Cloud, EBS R12/R11i.
• Working experience with the technology leaders likes IBM, Confidential, Confidential, Confidential, Motorola, Confidential Batteries, Grameen phones, west coast paper mill, Confidential ’s and bay company & Network Hardware Resale.
• Good Functional knowledge in Core Financial modules covering GL, AP, AR, FA, CM Supply Chain Modules covering OM, INV, PO,TCA and Adv. Pricing and CRM modules covering Service contracts(OKS), Install base(CSI), ASCP & HRMS Modules.
• Good Experience in WMS, MSCA, Depot Repair, Order Management, Inventory, Shipping and Process Manufacturing.
• Extensive experience in SQL, PL/SQL, Forms6i/9i/10g, Reports6i/9i/10g, UNIX Shell Scripts, SQL* Loader, Discoverer, Workflow, XML/BI Publisher and Oracle 8.x/9.x/10g,Quality Center.
• Exposure to all phases of implementation which include design of Business Process Analysis, User Requirement Study, Business Process Mapping, Fit/gap Analysis, Business Process Restructuring, Design, Testing, Production Transition and End User Training.
• Proficient in project implementation using Oracle AIM methodology.
• Extensive experience in new forms development, Form personalization, reports, AOL, System administration, Custom.pll, Performance Tuning etc.
• Participated in business process reviews. Provided solutions and recommendations to process issues related to Oracle Applications
• Worked in various roles as Architect, Process Designer, Technical and Functional Consultant.
• Excellent analytical and de-bugging skills.
• Led onshore/offshore Teams in various projects.
• Modifying and developing Reports (2.5, 6i, 9i), Discoverer (4i, 6i), Forms (4.5, 6i, 9i) and registering them with Application Object Library (AOL).
• Highly organized. Ability to work under pressure in fast-paced environment. Excellent interpersonal skills with an ability to interact with individuals at all levels and to mobilize and lead a team.

TECHNICAL SKILLS:

ERP: Oracle Applications R12 / 11i/10, GL, AP, PO, OM, AR, INV, BOM,WIP, OKS,CRM, TCA, HRMS, Sysadmin & Oracle Fusion Cloud R12,R13

Middleware: TIBCO, E2Open,Oracle SOA Suite 10g/11g (ESB/OSB, BPEL,BAM,B2B), Oracle Fusion Middleware

Cloud: Sales Force.com(SFDC), Oracle Fusion Cloud R12, R13

Application Servers: Web logic Server

Tools: and Utilities:

Toad,SQL* Loader, UTL, Workflow Builder, Discoverer,XML /BI Publisher,JDeveloper10g/11g,ODI,QualityCenter(QC),Service Now, Remedy, PVCS,HPRD,IBM RPM, SharePoint,Markview,AgileWeb ADI.

Database: Oracle 8i /9i/10g/11g

GUI: Forms 10g, Reports 10g, Developer 9i/6i

Operating System: Windows/98/NT/2000/XP, Solaris, Linux, UNIX

Languages: SQL, PL/SQL, C, C++, Basic, JAVA, XML, XSLT

EMail: MS Office Outlook, IBM Lotus Notes & Confidential Mails

PROFESSIONAL EXPERIENCE:

Confidential

Senior Manager

Responsibilities:

• Working on a Global Oracle ERP roll out in Multiple countries.
• Conduct the CRP to map the different user requirements of various countries into oracle ERP.
• Developing & supporting on-premises oracle e-Business Suite-R12.2.4, Oracle Function HCM & SCM application, Salesforce and Dot net in-house applications, also building Oracle Fusion Application data import processes (FBL, HDL, Spreadsheet Loaders, REST API)
• Worked on integration of new acquired companies, Data Center Migration & 3rd party (3PL) Integration to Oracle on premises R12.2.4 and Fusion Cloud Version R12 using B2B integrations, middleware or Web service rest APIs.
• Provided offshore and onsite project management on various projects in Service Maintenance domains.
• Modifying the purchasing, invoice & contract approval workflow through AME Rules
• Providing effective support of Oracle ERP (R12.2.4), Oracle Fusion Application release 12, Salesforce, Taxware and Custom Dot net Application Suites.
• Plan, staff and manage the resources, KT, transitions during the lifecycle of the project.
• Handle the contracts, cost cases, reporting, and project governance communications.
• Actively track and monitor the work loads and client needs and suggest optimal staffing solutions.
• Accountable for quality, schedule, functionality, and cost objectives of client's needs.
• Ensured milestone commitments are met on time raised timely change requests.
• Saved operating costs marginally with global delivery on the fixed price contracts
• Worked on Oracle Advanced Pricing functionality using custom functions and pricing formula for specific pricing logic and qualifications
• Leading & Managing the Global Teams
• Providing and designing the solutions on Oracle R12 frame work for in house oracle e business suite.
• Involved in design & solution of technical objects, Implementation of new business processes.
• Integration of B2B solutions to CTO/PTO/ATO and Make/Deliver Process of Order Management to purchasing and inventory modules.
• Providing various business solutions on Oracle Advance pricing using QP custom & different modifiers & qualifier.
• Working on project management, SLA & proposal documents as a part of PMO activity.
• Responsible for the testing, design & development of new sub projects & enhancements.
• Involved in Managing client’s escalations, handling the onsite & offshore Team.
• Involved in preparation of different project status, SLA reports for Management.
• Involved in collecting the business requirement and successful delivery of technical objects/new projects in Live instance.
• Identify issues arising during testing and analyze the issue and coordinate with the team to fix the same.
• Working on design of different Projects to meet the business requirement in Modules like (BOM, WIP, INV,QA & ECO) and Deliver (Shipping, Picking ) of Oracle R12 & Fusion SCM Cloud.
• Implementation of modules like Oracle Quality & SEPA for oracle Payable.
• Design of new custom workflow process for Order Management.
• Helping team in understanding of business requirements and modifications to be done.
• Solution & Implementation of new projects based on business requirements.
• Working on Production support Issues of Order management and other SCM modules.

Confidential, Sunnyvale

Senior Business System Analyst

Responsibilities:

• Worked on Support of B2B business flow in sales order flow.
• Good Knowledge of Industry standard messages 3A6,3A4,3B2,3B13 etc..
• Good Experience in WMS, Order Management, Inventory, Shipping and Process Manufacturing.
• Interact with the business for the functional requirements and map it to a functionality in oracle EBS.
• Support of MFG & OM modules for Oracle EBS 12 & Release 11i from functional & technical Aspects.
• Worked on different issues of service contracts & Install base modules.
• Worked on different CSI TXN errors & Issues on service contracts.
• Worked on the Month End/Year End & Quarter End related support Activities.
• Worked on service contract inbound & outbound interface.
• Worked on ERP validation after the production release.
• Worked on creation of various oracle reports in service contract & install base module.
• Created several oracle reports for oracle install base.
• Involved in different functional setups of Order Management, Inventory & Oracle Receivables.
• Involved in setups of pricelist, qualifier, modifier, defaulting rules, processing constraints & different sales order holds.
• Worked on different sales order scenarios like Drop shipment, back to back orders, internal sales order & return sales order (RMA)
• Involved in different business setups like Lookups, DFF, Zoom Form.
• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications (EBS).
• Working on the Application’s Transaction related Issues
• Meetings with clients and client’s business partners providing project status and resolving the concern addressing management inquiries enhancing client’s business process
• Worked on Support tickets and involve in Business critical Issues.
• 3rd party data integration co-ordination between onshore and offshore team etc.
• Worked on Month/year end Business closure process.
• Design, document and develop new technical requirements.
• Discoverer & XML Publisher reports, interfaces, concurrent programs, and form personalization Modify and troubleshooting, existing technical components
• Created and Managed Oracle Service Requests (SRs) through resolution
• Worked on Discoverer reports and Standard Oracle APIs.
• Worked on modifying and troubleshooting the existing code.
• Worked on creation of reports, custom programs, interfaces and conversions
• Worked on logging bug using Quality Center tool, preparation of UAT test cases.
• Involved in Resolution of different Support Issues related to Oracle SCM Modules.
• Worked on resolution of different interface related Issues for sales order, Customers, Purchase orders, install base & service contracts.
• Worked on Design, documentation and development of staging tables, conversion routines, Custom PL/SQL API’s for converting sales order, items, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Orders, Open Requisitions from legacy system (Mainframe) to Oracle Applications (EBS).
• Implemented Order Returns with and without credits, which involved setting up transaction type, loading order using SQL Loader, creating receipts to close the order.
• Involved in the development of TCA Customer Conversion program which includes data validation and API calls.
• Created new inventory organization, which allows Internal Transfers to handle returns from fulfillment (FF) centers. Internal Requisition receipts from FF’s where handled using RCV interface tables.
• Worked on different customization to support B2B message flow with sales order cycle.
• Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.

Environment: Oracle Applications 11.5.9, Oracle Applications 12.1, Oracle 10g/11g, INV, OM, PO, Install base, service contract, I procurement Application. Reports 10g, Forms 10g, Work flow, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential, Mountain View

Business Analyst

Responsibilities:

• System Analysis & Testing to upgrade the Order Management Application & Technical objects from Oracle EBS release 11.5.9 to 11.5.10.
• Functional and Technical object & process flow Testing.
• Understanding the functional & technical behavior of application in existing 11.5.9 version and make it compatible for new version 11.5.10.
• Involved in technical changes to objects in order to make it compatible with new version.
• Perform the end to end testing for different business processes related to order management in new version of Application and make sure it is working fine.
• Involved in technical changes like Forms, reports
• Shell scripts, functional set up related to new application version.
• Regular meetings with Client in order to get and understand business requirements.
• Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Present and defend product designs and architecture to clients
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: Oracle Applications 11.5.10/11.5.9 , Oracle 10g, Order Management, PO, Reports 10g, Forms 10g, Work flow, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential

Offshore Lead & SME

Responsibilities:

• Actively involved in Production Support and Enhancement Of Oracle Applications.
• Responsible for enhancements as per client requirements.
• Taking calls with onsite team in understanding the requirement for the new development or Issues in the production.
• Analyzing the issues creating and modifying the logics as per the business requirement.
• Preparing the Technical document for the new Trackers based on the Function requirement.
• Review the code to be delivered.
• Working on application modules like Advance supply chain Planning (ASCP),Order Management, Oracle Pricing etc.
• Meeting the client requirements, guiding & assisting the team, reviewing the code to be delivered.
• Log TARs for the standard issues with Oracle and follow up with them till the issue is resolved.
• Development & Supporting of Oracle Reports, Forms and PL/SQL Packages.
• Responsible to resolve technical and Functional issues.
• Development of backend procedures, packages and functions using PL/SQL.
• Gather the specifications from the Business user and proceed with the development of the objects.
• Monitoring of SOA interfaces from OM to Other External Systems on a daily basis and analyze the errors and send across the explanation and corrective measures to the business.

Environment: Oracle Applications 11.5.10, Oracle 11g, INV, OM, PO, Install base, service contract, ASCP & I procurement Application. Reports 10g, Forms 10g, Work flow, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential

Technical Lead

Responsibilities:

• Worked on different interfaces of GL,PA,AP,AR,INV,OM & Costing modules.
• Wrote Technical specifications, Conversion-mapping documents for Item, sales order, customer, item cost, purchase order, requisition open Interface.
• Designed and Developed Conversion routines, custom PL SQL API’s Item, sales order, customer, item cost, purchase order, requisition, auto invoice open Interface.
• Worked OA frame work Application Design & Customizations.
• Designed and developed custom PL SQL program to assign categories, cross references, sourcing rules and locations to items.
• Designed and Developed various reports to meet the client’s requirement.
• Developed a custom report to daily list all the rejected invoices based on the interface table.
• Customized Journal Batch Summary Report, Aging 4-bucket report and past due invoice report.
• Customized Packing slips report, MRP Detail Planning Report.
• Did Security Profile Setups, created new Responsibility, New Menus, New Functions, New Users and Supported User community interacting daily.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, Invoice and Expense reports etc. using Reports 6i/9i.
• Designed and developed workflow email alerts for Item and BOM updating.
• Designed and developed Custom Purchase Returns Form.
• Did daily support for Finance, Purchasing, Manufacturing and Planning Departments interacting daily with end users.
• Added new menus, responsibilities, functions, concurrent program etc.
• Developed Conversions which include the following
• Sales order Conversion
• Customer Conversion
• Auto Invoice Conversion
• Purchase order
• Developed various interfaces, both inbound and outbound, which are run on periodic basis. The modules worked on includes PO, AR, INV, OM.
• Developing forms for custom modules which include the following
• New Customer Registrations
• Customer Resignation
• Duplicate Price List Creation and Maintenance
• Develop OM//PO/INV reports using discoverer which include the following.
• Discover Report On Hand Quantity.
• Excess on Shop floor Discoverer Report.
• Development of OM Header /OM Line workflow Process customization.
• Personalized custom self services forms using OA Framework.
• Development of XML reports.
• Used SQL*Loader and PL/SQL to import the data to an intermediate table, to perform validations, and to relate customers with addresses, contacts, banks and profiles.
• Preparation of technical specifications from the functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
• Developing PL/SQL code to obtain the required functionality.
• Development of outbound interfaces.

Environment: Oracle Applications 11.5.10, Oracle 9i, INV,OM,PO,GL,AP,AR. Reports 10g, Forms 10g, Work flow, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential

Offshore Team Lead

Responsibilities:

• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications (EBS).
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA, OM,INV,PO & OPM modules.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Documented (PCM) entire migration process of projects, tasks, expenditures.
• Analyzed, developed, configured and tested the customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR which is not provided by standard API’s.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Prepared Technical Specification (MD70) documents.
• Was actively involved in designing and developing new Project Costing Report in PA reports using Reports 6i to suit business requirement.
• Exported the report output onto Microsoft Excel on Client’s request.
• Created project structure to maintain versions on PVCS and used it to track defects for every build.
• 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.
• Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.
• Used Bursting technique to email the XML publisher output file
• Created a TAR/SR (severity 2) for an error in PO requisition change workflow (PORPOCHA) and resolved by recreating the issue after the patch is applied.
• Converted several SQL scripts into concurrent requests, tested them in test instance and then moved them into production instance.
• Analyzed an SR on Interface Trip Stop program and modified and executed the script for different internal requisitions and SO’s. Converted the same script into a concurrent request.
• Analyzed and executed the Encumbrance fix for Planned PO and Blanket PO for different PO’s.
• Customized Purchase Order Approval workflow for adding email notification workflow function for changed PO’s.
• Designed, documented and developed new workflow to send email notifications to group of people when updating items, supplier address and bill of material

Environment: Oracle Applications 11.5.10, PO, INV, OM, Oracle 8i/9i, Developer 6i (Forms 6i, Reports 6i), work flow, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential

Oracle Technical Developer

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• General Ledger: Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements. Used, Multi Company accounting in single SOB: Set up intercompany Due to and Due from accounts for accounting transactions.
• GCS for consolidating group companies financials.
• Accounts Payable: Invoice entry: Captured expenses incurred for a particular customer job through a DFF. Captured expenses incurred for asset maintenance asset number wise.
• Accounts Receivable: Collections: Tele calling features for sales personnel captured through collections workbench. Receipts: Used Notes receivable for processing postdated checks.
• Memo Lines: Created Memo Lines for transactions.
• Project Costing & Billing: Used Project accounting to Track costs and Revenues of internal and external projects. Set up Projects, Tasks, Budgets, Agreements and Project Billing Cycles.
• Fixed Asset: Implemented the security by book feature.
• Cash Management: Cash forecasting & Cash positioning with bank wise details., Define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping
• System Administration: Defined user responsibility matrix. Used Menu exclusions to restrict access of certain menus.
• Involved in defining the necessary setup for GL, AP, AR as per the business flow requirements of MRF
• Involved in data validation and build designing to upload data from existing systems.
• Defining various parameters required for implementation of Oracle Applications (EBS)
• Involved in testing of the Implemented modules.
• Involved in Post Implementation support and Production Support of GL AP AR.
• Routine tasks included monitoring the various interfaces,
• Providing helpdesk support to production user for issues with GL, AP, AR.
• Involved in year-end and period end close process.
• Conducted User training for educating the production user to the new enhancements made to the existing System.

Environment: Oracle Applications 11.5.10,Oracle Module GL, AR, AP, PO, INV, OM, Custom Modules; Developer 6i (Forms 6i, Reports 6i), Work flow, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell Scripts.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Developed various interfaces, both inbound and outbound, which are run on periodic basis. The modules worked on include GL, AP, PO and INV,OM.
• Worked on Conversion activities to import data from legacy system includes Items Conversion, Customer Conversion, and BOM Conversion.
• Worked in getting the requirements from the users and involved in functional setups in financial modules.
• Preparation of technical specifications from the functional specifications Received from functional team like CV60, MD70 using AIM 3.0.
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
• Developed an interface to upload the legacy GL data into the Oracle Application System, Developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validations.
• Worked on development of new Custom forms and integrated with Oracle Applications and customized various forms as per the requirements.
• Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.
• Customized standard Oracle reports like Account Status Report, Bank Account Listing, and Employee Listing Reports as per the business requirements.
• Customized various reports in PO: Purchasing Invoice Price Variance, Purchase Price Variance, and Open Purchase Orders reports.
• Adherence to Coding standards, Naming conventions and Quality Procedures as per the desired Quality Norms and AIM’S Methodology for documentation.
• Developing Reports Conversions & Interface programs
• Customization of forms to get zoom functionality.
• Developing PL/SQL code to obtain the required functionality.
• Development of outbound interfaces.
• Involved in preparation of Test Scripts and User Trainings.

Environment: Oracle EBS 11.5.9,Oracle 8i/9i, Developer 6i (Forms 6i, Reports 6i), Windows NT

Confidential

Software Developer

Responsibilities:

• Preparation of Technical specification.
• Developing PL/SQL, SQL programs using Oracle 8i as back end and Developer 6i as front end.
• Developing forms and reports as per the requirements.
• Developing triggers, procedures, and functions for common usage of the development team.
• User Training.
• Preparation of Technical specification.
• Developing PL/SQL, SQL programs using Oracle 8i as back end and Developer 6i as front end.
• Developing forms and reports as per the requirements.
• Developing triggers, procedures, and functions for common usage of the development team.
• User Training.

Environment: Oracle 9i, Developer 2000 (Forms, Reports), Windows NT