SUMMARY:

• Over 12 years of experience as Techno Functional Consultant in Oracle E - Business Suite Applications. Has rich Automotive Industry experience and have worked for leading Automotive companies.
• As a Techno-Functional Consultant, I have been actively involved in developing and implementing Oracle Supply Chain Management solutions and I also have good working knowledge of Financials, CRM and TCA.
• Current responsibilities include performing - Functional and Technical work on Oracle Applications. Functional responsibilities include business process analysis, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation/execution, writing guides, end users and production support. Technical responsibilities include interfacing with users, identifying technical and functional gaps, estimating work, architecting system interactions, designing custom solutions, programming, leading developers, scheduling, producing documentation and providing post production support.

TECHNICAL SKILLS:

Technologies: Oracle Developer Forms/Reports, BI/XML Publisher, SQL, PL/SQL, SQL*LOADER,TOAD, Workflow administration, Alerts, Oracle database 11g/10g/9i/8i,Shell scripting.

Functional: Oracle Apps R12/11i, Inventory, Purchase Orders (P2P), I-procurement, I-sourcing, I-supplier, Order Management (O2C),Warehouse Management, Advanced pricing, Advanced Supply chain planning, GL, AP, AR, Fixed Assets, Cash Management, Tele sales, Marketing, Scripting and AOL.

Industry: Automotive and FMCG.

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional Consultant

Environment: Oracle12.2 & 11.5.10, OM, PO, AP, AR, GL, BOM, INV, WMS,Tele sales, Scripting, Marketing, Oracle11g, PL/SQL, SQL*Plus, UNIX, Shell Scripting, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities:

• Worked as Techno - Functional Consultant and implemented multiple end to end Supply Chain management and CRM based solutions for Automotive (New Vehicles, Used Cars, Spare Parts), Real Estate, Service Equipment and Restaurant businesses and provided post production support and also provided business solutions for changing requirements of the businesses.

Confidential

Project Lead

Environment: Oracle12.2, OM, PO, AP, AR, GL, BOM, INV, WMS,Oracle11g, PL/SQL, SQL*Plus,Shell Scripting, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities:

• Worked on all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared AIMSFunctionaland Technical documents for requirements, design, and implementation steps with data conversions, test plans andfunctionaluser guides for all the phases of the project.
• Responsible for gathering the requirements from Business users and Coordinating with other team members in designing and implementing the process.
• Responsible for doing the map/gap analysis and configuring the system for the SCM business flows OTC and P2P.
• Responsible for configuring the system in the test instance for conducting the Conference Room Pilots.
• Responsible for doing Conference Room Pilots (CRP) to demo the business flows to business users and document the issue logs and rectify the issues and close the issue logs.
• Extensively used TOAD for developingOraclestored packages, functions, procedures.
• Designed, coded, tested custom applications with an integration to Oracle Applications.
• Customized standard Oracle Reports and developed new XML publisher as per business user requirements.
• Developed new Oracle Forms using template form and customized existing forms and custom.pll .
• Created Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Configured Warehouse Management Rules Engine to optimize the Picking rules and Put away rules.
• Configured Advanced Pricing module to enable customer specificpricelists using qualifiers and modifiers.
• Responsible for configuring the production system and preparing the setup document BR100.
• Performed production and non-production support by solving tickets of all severity (P1 to P4).
• Mentoring team members in their assigned tasks and helping them for any issues.
• Trained the end users with the new process using Conference Room Pilots (CRP).
• Worked on System administration, Workflow Administration, Trading Community Architecture (TCA), Multi-Org environment, Alert Manager, AOL Administration (registeringapplications, forms, reports, functions, menus, concurrent programs, value sets, flex fields, alerts, forms personalization)

Confidential

Techno Functional Consultant

Environment: Oracle12.2, OM, PO, AP, AR, GL, BOM, INV, WMS,Tele sales, Oracle11g, PL/SQL, SQL*PlusShell Scripting, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities:

• Worked on all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared AIMSFunctionaland Technical documents for requirements, design, and implementation steps with data conversions, test plans andfunctionaluser guides for all the phases of the project.
• Responsible for gathering the requirements from Business users and Coordinating with other team members in designing and implementing the process.
• Responsible for doing the map/gap analysis and configuring the system for the SCM business flows OTC and P2P.
• Responsible for configuring the system in the test instance for conducting the Conference Room Pilots.
• Responsible for doing Conference Room Pilots (CRP) to demo the business flows to business users and document the issue logs and rectify the issues and close the issue logs.
• Extensively used TOAD for developingOraclestored packages, functions, procedures.
• Designed, coded, tested custom applications with an integration to Oracle Applications.
• Customized standard Oracle Reports and developed new XML publisher as per business user requirements.
• Developed new Oracle Forms using template form and customized existing forms and custom.pll .
• Created Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Configured Warehouse Management Rules Engine to optimize the Picking rules and Put away rules.
• Configured Advanced Pricing module to enable customer specificpricelists using qualifiers and modifiers.
• Responsible for configuring the production system and preparing the setup document BR100.
• Performed production and non-production support by solving tickets of all severity (P1 to P4).
• Mentoring team members in their assigned tasks and helping them for any issues.
• Trained the end users with the new process using Conference Room Pilots (CRP).
• Worked on System administration, Workflow Administration, Trading Community Architecture (TCA), Multi-Org environment, Alert Manager, AOL Administration (registeringapplications, forms, reports, functions, menus, concurrent programs, value sets, flex fields, alerts, forms personalization).

Confidential

Techno Functional Consultant

Environment: Oracle12.2, OM, PO, AP, AR, GL, BOM, INV, WMS, Oracle11g, PL/SQL, SQL*PlusShell Scripting, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities:

• Worked on all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared AIMSFunctionaland Technical documents for requirements, design, and implementation steps with data conversions, test plans andfunctionaluser guides for all the phases of the project.
• Responsible for gathering the requirements from Business users and Coordinating with other team members in designing and implementing the process.
• Responsible for doing the map/gap analysis and configuring the system for the SCM business flows OTC and P2P.
• Responsible for configuring the system in the test instance for conducting the Conference Room Pilots.
• Responsible for doing Conference Room Pilots (CRP) to demo the business flows to business users and document the issue logs and rectify the issues and close the issue logs.
• Extensively used TOAD for developingOraclestored packages, functions, procedures.
• Designed, coded, tested custom applications with an integration to Oracle Applications.
• Customized standard Oracle Reports and developed new XML publisher as per business user requirements.
• Developed new Oracle Forms using template form and customized existing forms and custom.pll .
• Created Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Configured Warehouse Management Rules Engine to optimize the Picking rules and Put away rules.
• Configured Advanced Pricing module to enable customer specificpricelists using qualifiers and modifiers.
• Responsible for configuring the production system and preparing the setup document BR100.
• Performed production and non-production support by solving tickets of all severity (P1 to P4).
• Mentoring team members in their assigned tasks and helping them for any issues.
• Trained the end users with the new process using Conference Room Pilots (CRP).
• Worked on System administration, Workflow Administration, Trading Community Architecture (TCA), Multi-Org environment, Alert Manager, AOL Administration (registeringapplications, forms, reports, functions, menus, concurrent programs, value sets, flex fields, alerts, forms personalization).

Confidential

Techno Functional Consultant

Environment: Oracle12.2, OM, PO, AP, AR, GL, BOM, INV, WMS,Tele sales, Oracle11g, PL/SQL, SQL*PlusShell Scripting, Win Scp, TOAD, Putty, Workflow 2.6

Responsibilities:

• Worked on all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Prepared AIMSFunctionaland Technical documents for requirements, design, and implementation steps with data conversions, test plans andfunctionaluser guides for all the phases of the project.
• Responsible for gathering the requirements from Business users and Coordinating with other team members in designing and implementing the process.
• Responsible for doing the map/gap analysis and configuring the system for the SCM business flows OTC and P2P.
• Responsible for configuring the system in the test instance for conducting the Conference Room Pilots.
• Responsible for doing Conference Room Pilots (CRP) to demo the business flows to business users and document the issue logs and rectify the issues and close the issue logs.
• Extensively used TOAD for developingOraclestored packages, functions, procedures.
• Designed, coded, tested custom applications with an integration to Oracle Applications.
• Customized standard Oracle Reports and developed new XML publisher as per business user requirements.
• Developed new Oracle Forms using template form and customized existing forms and custom.pll .
• Created Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Configured Warehouse Management Rules Engine to optimize the Picking rules and Put away rules.
• Configured Advanced Pricing module to enable customer specificpricelists using qualifiers and modifiers.
• Responsible for configuring the production system and preparing the setup document BR100.
• Performed production and non-production support by solving tickets of all severity (P1 to P4).
• Mentoring team members in their assigned tasks and helping them for any issues.
• Trained the end users with the new process using Conference Room Pilots (CRP).
• Worked on System administration, Workflow Administration, Trading Community Architecture (TCA), Multi-Org environment, Alert Manager, AOL Administration (registeringapplications, forms, reports, functions, menus, concurrent programs, value sets, flex fields, alerts, forms personalization).

Confidential

Environment: Oracle 9i, Oracle forms 5.0, Oracle reports 3.0, PL/SQL, SQL

Project Lead

Responsibilities:

• Product Configuration
• Purchase Orders
• Repair Orders
• Transfer Orders
• Sales Orders

Confidential

Environment: Oracle 9i, Oracle forms 5.0, Oracle reports 3.0, PL/SQL, SQL

Project Lead

Responsibilities:

• Available Models With Options & Colors
• Yearly vendor sales Forecast
• Yearly branch sales forecast vendor wise
• Models monthly sales/order forecast
• Branches Detail Monthly Order
• Submit Detail monthly Order
• Review Monthly Order
• Accept Monthly Order
• Financial Approval Of Monthly Order
• Monthly Order Approval
• Monitor Branch Ordering
• Ordering & Planning Reports
• Sales Status Reports
• Monthly Order Report/Division
• Monthly Order Report/Models

Confidential

Environment: Oracle 9i, Oracle forms 5.0, Oracle reports 3.0, PL/SQL, SQL

Project Lead

Responsibilities:

• Automated purchase order generation
• En-route notification
• Distribution of en-route shipment
• Distributed shipment report
• En-route shipment query for branches
• Automation of branch transfer shipments.

Confidential

Environment: Oracle 8i, Oracle forms 5.0, Oracle reports 3.0, PL/SQL, SQL

Analyst Programmer

Responsibilities:

• Designed, developed and Implemented the Migration Project of EMIS “Distribution
• System”. The Migration Project was done from SQL forms 3.0 to Oracle Forms Builder
• 5.0,(RPT) Report Generator 1.0 to Oracle Report Builder 3.0
• This system included the following modules.
• Product configuration
• Inventory control
• Purchase orders
• Sales orders
• Transfer orders
• Physical inventory
• Car reservations