Engineer Software

MAHESH V

Phone# 944******* aboh2q@r.postjobfree.com

Over 6+ years of experience in the ERP Industry

(Oracle Apps SCM, Demantra, Oracle PL/SQL, Warehouse management Systems eBizNET and MARC

WMS Systems)

Objective: Seeking a position of Oracle Apps SCM, MFG, Demantra/Oracle PL SQL Consultant

• Good Functional Knowledge on Supply Chain Management Domain( Inventory, Purchasing, Order Management, Demand

Management, Sales and Operations Planning, Warehouse Management, After Market Service and Spares Distribution)

• Hand on experience on Development, Configuration, Support and Testing activities of SDLC. Worked on Software product

development and consulting services divisions.

• Good Experience on Oracle Inventory, Purchasing Functional Configurations. MARC & eBizNET warehouse management

systems and its Integration of with BAAN and SAP, NetSuite systems.

• Hands on experience on Demantra DM solution and its Integration with Oracle ERP.

• Expertise on site co ordination and client communication for development and Support activities.

• Strong consulting, product development skills and good domain Knowledge on Supply Chain Execution and Planning.

• Review, prioritize and work on support tickets in SCM domain – Oracle Apps and MARC systems

• Work with Oracle Meta link support in finding patches/solutions to bugs that are encountered in Oracle ERP

• Work on enhancements to Oracle ERP as requested by business users

• To Conduct the solution confirmation activities and the fit/gap analysis, identify key gaps and ensure that the foot print and

design meets the local requirements

Job Profile

• Good Understanding of Oracle Application modules procure to Pay and Order to Cash cycles.

• Expertise in developing of Demantra Demand Management solution and its integration

• Preparation Business requirement document, Fit/Gap Analysis for Oracle SCM Modules.

• Good Knowledge of SQL and Demantra Applications data model/Tables/Collection process,Strong PL/SQL debug

knowledge/Business Modeler and performance Tuning

• Expert level functional knowledge of Demantra application with ability to create and modify complex series and level using

the Business Modeler

• Developed customized collections using PL/SQL procedures and Demantra Workflows

• Development of Series (Server/Client Expression), Worksheets, Integration Interfaces, Demantra Workflow

• Daily on site co ordination and client communication where as needed

• Hands on experience in RDBMS Oracle 9i/10g /11g systems, D2K Reports 6i, Toad, SQL Developer and SQL*PLUS, SQL

Loader, Oracle analytical functions, OEM SQL Tuning Adviser, Win CVS, HP Quality Center, Linux, Windows, Shell Scripts,

HP Quality Center.

• Actively involved design and development of SCM product eBizNET and MARC enhancements

• Co ordination of system integration and Integration testing (RedPrairie MARC with Web Methods /SAP/ Siperian, Manu

logistics, eBizNET with NetSuite, MARC with BANN).

• Experience in Offshore development, system Support(24/7), Enhancements, bug fixing, report development and Testing

Flextronics/Solectron(Hi Tech), Johnson and Johnson(Pharmacy), NOKIA (Handsets Distribution & Repair)

• Proficient in well tuned complex SQL queries, sound in writing complex PL/SQL code using advanced features

(procedures, functions & packages, Exception Handling, Bulk Collect, LOB, Collections, Sound knowledge on the various

performance tuning technics like Statistics, Explain Plan, Hints, Partitioning, Indexing, Set Operators, analytical functions,

pipelined functions, autonomous transactions, oracle supplied packages, Function, Procedures, Packages, Triggers,

Indexes, Tables, Views, synonyms, TKPROF utility, dynamic SQL, Schedulers etc.)

MAHESH V

• Knowledge of Data Warehousing Concepts, and interface development activities and Functional Experience in Supply

Chain Planning and Execution

Professional Experience

• Senior Implementation Engineer, Steelwedge Technologies (April 2012 to Till Date), Hyderabad

• PL/SQL Developer Senior Software Engineer, eBizNET Solutions (May 2006 March 2012), Hyderabad

• Senior Research Fellow NSTL (Oct 2001 to Oct 2004) on Contract Basis, Visakhapatnam

Functional / Technical Skills

• Functional Knowledge on Inventory Management, Manufacturing, Sales and Operations Planning(S&OP), Demand

Planning, Procurement, Warehouse Management, Order Processing, BOM

• Technical Experience in Oracle Inventory, Purchasing, Demantra 7.3.0.1, Oracle 9i,10g,11g, D2K Reports, Windows, Linux,

SQL Developer, TOAD, CVS, SVN, HP Quality Center, Oracle SQL, PL/SQL, SQL Loader, Oracle Enterprise Manager, MS

SQL Server, Linux, Windows.

• Worked on Pharmaceutical, Electronics, Crop Seeds, Chemical, 3PL warehouse and material distributions.

Professional Experience

Sr Implementation Engineer, Steelwedge Technologies, Hyderabad

Oracle Application Implementation and Support for Newark Electronics Corporation

(Inventory, Purchasing modules)

• Co ordination with onsite team to get the requirements

• Updating Functional documentation for Technical Team for developing Reports

• Mapping their business requirements providing functional expertise in Oracle Distribution modules and performing

functionality testing on various modules of Oracle application.

• Interacting with user, super user and functional owners to understanding the issues. Participation in status review meetings

and timely update.

• To run functional, integration and solution acceptance testing

• Co ordinate with developers, other business analysts, support managers and DBAs over support issues Act as a lead in

driving issues to resolution

• Finalization of Set Up parameters and profiles

• Created Responsibilities and User menus

Sr Software Engineer, eBizNET Solutions, Hyderabad

Sales & Operational Planning for Syngenta Seeds and CP Keclo, Metro PCs

• Configuration of Product and Sold to Hierarchies, Series Using Service Delivery platform

• Preparation of Templates/Worksheets for Marketing, Sales, Commercial Unit divisions

• Generation of Client Specific code, Compile & Deploy and Integrations.

Senior Software Engineer, eBizNET Solutions, Hyderabad

Demantra for Solectron /Flextronics

• Involved in Daily on site co ordination for the Design of Demantra Demand Planning Solution

• Worked on development of Series, Series Groups, Workflows based on Business requirements

• Prepared data mapping documents, interface development for Sales Data and Sales Forecast Output data based on host

BAAN system

• Development of Worksheets for demand planning review process.

• Price Imports using integration Interface

Senior Software Engineer, eBizNET Solutions, Hyderabad

eBizNET After Market Repair Solution for Nokia India

• Developed Cycle Times Report.

• Design and Development of Consolidation of Shipments Based on destination and consignee.

• Tuning of Reports and its enhancements

• Developed light swap process

MAHESH V

• Query tuning and Oracle objects creation for the enhancements.

• Warranty validation and Warranty swap process was designed and developed.

• Design/Implementation of Purchase order creation based on Item re order levels and available inventory.

• Archive process was implemented for L2L3 Repair Distribution

System Analyst, 7Hills Business solutions, Hyderabad

RedPrairie MARC 9.2 Application for Solectron/Flextronics

• Enhancement of packing process to store Country of Origin

• Development of Pick List, PO Details Report

• Involved in Inventory reconciliation process between MARC and BANN systems.

• Co ordination of system integration issues with IBM BANN Team and Web methods teams

• Interacted with Client for process and system improvements and developed customized reports.

• Design/Implementation of Purchase order creation based on reorder levels and available inventory

• Operational Support to Singapore, Austin, Louisville and Toronto site MARC operations. Involved in development and

testing of reports, screens and Workflow scripts.

• Resolution of Tickets based on priority basis.

System Analyst, 7Hills Business solutions

RedPrairie MARC 9.2 Application for Johnson & Johnson Health Care

• Involved in interaction testing between different heterogeneous systems such as Marc, Web Methods and SAP, Siperian,

JDE and Manu Logistics.

• Development inventory sync interface between Marc and SAP systems.

• Development and testing of Codman manual put away Enhancement in Satellite Distribution center.

• Configuration changes to receive Purchase Order’s with Trailer information

• Development and testing of Depuy Codman manual put away Enhancement in Satellite Distribution center.

• Functional Test Script Writing and Execution using HP QC.

• Configuration of Inventory adjustment types, PO types based on Cross Road project changes.

• Implementation of Security feature to lot data entry screen.

• Extensively involved in Day In a Life (DILT) testing between SAP and Marc

• Testing IDD36 Inventory Sync for MLC and SDC

• Involved in Implementation Marc application for NMEM, Raritan (R001), Rochester (R003), Deputy Codman (D010), EL

Paso(NELP) companies/sites.

• Involved in Datasheet preparation for UAT

• Configuration of Inbound and Outbound Schedulers in Marc data sheet preparation for UAT.

• Preparation of Ad hoc queries

System Analyst, 7Hills Business Solutions

RedPrairie MARC 9.2 Application for Logiwiz (3PL)

• Operational Support to Logiwiz

• Development of SKU movement report

• Enhancement of Unloading Report, Goods Deliver Note, Pallet put away report, Bulk Pick report

• Trouble shooting problems associated with extraction of billable activities (Billing Module)

• Adding Functionality of Partial Shipment receiving process

Senior Software Engineer, 7Hills Business Solutions

eBizNET and NetSuite Integration

• Development and enhancements of inbound and outbound interfaces like SKU, SKU categories, Purchase Orders,

Customers, Vendors and Sales Orders. Design and development of in Inventory, Purchase and Sales Order confirmation

interfaces between eBizNET and NetSuite systems.

Senior Research Fellow, NSTL, Visakhapatnam

Scientific Data Management and Interpretation of Data for NSTL – Contract Basis

• Interpretation of Test data to the prototype (full scale) model using PL/SQL

• Associated in Comparison of NSTL text data with the Naval Vessels (sea trail) data

• Management of Scientific text data pertaining to marine vehicles (ADS, FPB, AUV, P15 etc)

Trainings attended

MAHESH V

• Attended Training on Oracle E Business Suite, Demantra Demand Management, RedPrairie MARC, Informatica, Oracle 9i

SQL, PL/SQL, Oracle DBA, HP Quality Center.

Education

• M.Tech from IIT Madras (January, 2001) and B.Tech from Nagarjuna University (April, 1999).

Personal Particulars

Address : Plot# 43, Abdhirama Apartment, G1/101, Ground Floor, Rajeev Nagar, Hyderabad 45

Contact this candidate