vasantghegde

BUSINESS EXPERIENCE SUMMARY Result oriented and highly experienced at leading the techno-functional team. Particularly talented in architecting the software solutions for productivity and business process improvement. Qualified professional in supply chain management, finance, and accounting. Over 10 years of techno-functional experience in Oracle ERP Application Rel. 11i, 11, and 10.x implementation. Total experience in software industry is about 17 years with about 14 years of experience in ERP implementation. Demonstrated the ability to establish and maintain effective communication with good interpersonal skills and leadership. Project Management tools: AIM 3.0, MS-Project 2003/98, MS-Office, Visio 2003, CMM, Oracle Designer 2000 Database & technical tools: Oracle 8i, 9i, 10g database, Oracle Application Express (APEX/HTMLDB), SQL*Plus, PL/SQL, SQL*Loader, Explain Plan, Oracle Forms, Oracle Reports, Pro*C, Toad, ERWIN, Discoverer, Crystal Reports, MySQL Computer Languages: C, Java, Perl, JSP, PHP, XML, HTML, Fortran, Pascal, COBOL Operating Systems: Unix OS (Sun Solaris), Microsoft Windows: XP, NT, 2000 WorkBench Software Williamsville, NY Custom workbench forms and reports for Oracle Apps November 2008 - Present Modules worked on: Oracle Inventory and Order Management (11.5.10) Worked on Item and Order workbench Oracle forms and related forms to modify and add additional windows. Upgraded from 11.5.6 to 11.5.10 version. Also created reports on these modules based on customization required by the client. Alluminium Manufacturing Company India RFID Implementation – Contract given to Kalpa Technologies Inc. October 2007 – Oct 2008 Modules worked on: Oracle Inventory (11.5.10) • Project Lead for RFID Implementation Developed interfaces to integrate data read from RFID reader to Oracle Physical Inventory application. Once read the data need to be sorted and filtered in a mesh networking environment and update the Oracle database to integrate with Oracle Inventory module. Developed the interface between RFID reader and Oracle apps to identify the right product to help shipping process. The custom forms and reports needed to present the physical inventory report/data in a customer required format. Real Estate Agency Doha, Qatar Oracle Financial Application Implementation – Contract given to Kalpa Technologies Inc. June 2007 – October 2007 Modules worked on: GL, AR, AP (11.5.10) • Project Lead for Oracle Financial Application Implementation Implemented the GL, AP, and AR modules. Task included Setting up the application modules and analyzing the customer requirement and develop custom forms, reports, and concurrent programs where required. Application Development Company Newyork, USA Intelligent Supply Chain Application Jan 2007 – May 2007 • Technical lead for forms developement Required PHP forms developed to interactive supply chain application using MySQL database. The application developed to check the available inventory or substitutes by the customer directly using company website. Velox Technology Oakland, California ERP Implementation – Contract given to Kalpa Technologies Inc. June 2006 – May 2007 Modules worked on: Internal Control Manager (AMW) (11.5.10) • Techno- Functional Lead for IT Governance software product development Developed a product in IT Governance for IT auditing and Segregation of Duties process using JSP and Oracle Application Express (formerly known as HTMLDB). Designed and developed forms, reports, and various charts. • Techno- Functional Lead for Customization of AMW Customized the Setup Group, Setup Parameters, and Report Groups to include other database tables, which are not included in the seeded data by Oracle. The application can be run as a concurrent program to seed new tables and columns in Setup Group and Parameters functions any time. This enables the end user to run the audit report to enhance security and compliance with Sarbane-Oxley Act. Taxi Regulation Authority, Irish Government Ireland • Management Consultant for restructuring IT infrastructure Directed Taxi Regulation Authority managed by Irish Government to restructure the information technology infrastructure. Prepared a detailed report on various technology options with cost/benefit analysis and implementation efforts required. Xerox Corporation Webster, New York ERP Implementation April 1997 – May 2006 Modules Worked On: Order To Cash/Order Management (11i), Shipping Execution (11i), Pricing (11i), Inventory (11i), AP (11i), GL (11i), AR (11i), BOM (11i), and WIP (11i), and Work flow (11i). Oracle Enterprise Manger (EM10g), Service Contracts (11i), Install Base (11i) • Technical Lead for eMax sustain base project a. Analyzed the new business requirement and change control and oversaw the implementation b. Estimated business impact of Oracle Application upgrade and resource requirement c. Analyzed the technology upgrade and estimated the resource requirement for the upgrade d. Coordinated the implementation activity and production support • Technical Lead for Direct Customer Ship (DCS) project a. Requirement Analysis and Project Planning Required an application to retrieve the order data that are ready to be shipped from Oracle Shipping module, generate carrier specific labels (UPS, Airborne, BAX etc), generate the manifest and interface with carrier company server to communicate the shipment information, retrieve the customer delivery information from carrier server and interface with the legacy system for revenue recognition. Estimated the resource required for the project like hardware, software, staff, time, and cost. Analyzed the risk and created the mitigation plan. Created the project plan, and schedule. Negotiated the software procurement, licensing and service agreements. Oversaw the development, testing, implementation, and support activities. b. Solution design Installed Conectship, third party software designed to generate the label and interface with carrier company servers, on a Windows 2000 server. Designed the programs to retrieve the shipping information and generate the XML request. Designed a Java program to send the XML request from Oracle Application (Sun Solaris server) to Connectship application (Windows 2000 server) and receive the XML response. Designed a program to initiate the manifest creation and shipment data transfer to carrier company server using XML request/response documents. Designed programs to retrieve the delivery information from each carrier company server. Designed an interface program to send the delivery information to legacy for revenue recognition. c. Benefits from the Project: Over $2 million savings per year in fright charges because Xerox can use the mass carriers like UPS/Airborne/BAX for spares and lower end product shipment. • Knowledge Transition Leader for the outsourcing of Oracle ERP application support a. Identified the potential application modules that could be outsourced and the customization involved b. Coordinated the effort to collect documentation like requirement, technical solution, and design documents c. Coordinated software & hardware resources including system, application and database access to the vendor team d. Created Knowledge Transition document template to cover the information that are not covered in the above documents and create knowledge bank on issues & solutions for the existing application & customization e. Arranged the Knowledge Transition sessions between technical/functional team and vendor team f. Oversaw that vendor team creates knowledge transition documents and updates for the changes (change control) g. Audited & oversaw the vendor compliance to the statement of work (SOW) and Service Level Agreement (SLA) • Technical Lead for the Oracle ERP implementation project for the Mexican branch of Xerox a. Requirement Analysis and Project Planning: Required to replace the legacy systems with Oracle Inventory and Oracle Order Entry & Shipping. Replacement requirement involved creating interfaces with several other legacy systems. Estimated the resource required, like staff, time and cost. Prepared the detailed project plan to do design, development, testing, implementation activities. Oversaw the process of implementing these activities. b. Solution design: i. Designed inbound interfaces to get the existing subinventory and create it in Oracle Inventory. ii. Designed inbound interfaces to get the existing items and create it in Oracle Inventory using standard API. iii. Designed inbound interface to get inventory transaction by field service technicians from service system (legacy) and interface it with Oracle Inventory. iv. Designed outbound interface to send cost data of inventory items to legacy system. v. Designed outbound interface to send order information to service contract system (legacy). vi. Designed error reports, forms, and programs to store & transact Xerox specific data for the above interfaces. vii. Designed item chain form to display all the chain items of an item with the available quantity in subinventory • Chief Analyst to implement the Oracle Enterprise Manager 10g a. Analyzed the features of OEM 10g and concluded on the immediate applications and long term applications. b. Designed a custom report for the system, database and concurrent manager availability. Designed is done using web reporting tools like HTMLDB (APEX) HTML, Perl and JSP. • Worked as Lead Developer for the following Oracle ERP customization and/or implementation projects: a. Determined that that shipping solution provided by Oracle ERP Application (Rel. 11i) is operationally inefficient, because there is no mechanism to optimally cube the vehicle unless do it in iterative way and to make sure entire order or ship set are ready to ship, delivery lines are reserved or not on hold. Created a simple screen (oracle forms) to resolve above concerns and to list the orders that are ready to ship with fill percentage it may occupy a chosen vehicle. This helped the user to reduce the manual time and work to create trip, training needed, and possible process errors resulting in a 30% improvement in operation efficiency and labor cost. The screen created using a complex custom view and several standard API. b. Worked with business analysts to design and develop various custom Order Entry and Inventory solutions to replace Xerox Shipping System (legacy system) with Oracle ERP Application using CMM project methodology. c. Participated in developing project plans to upgrade Oracle ERP Application releases 10.7, 11.0 and 11i, data migration and scalability. Upgraded customized solution for compatibility and conducted user training. d. Identified the system anomalies and provided the solutions to improve software performance and quality. e. Designed a system to build & ship multiple orders of large customer solutions together, to avoid inventory constraints and delayed revenue recognition. Xerox imports the orders from legacy before reserve, configure (for ATO) and ship. High end products from Xerox need multiple ATO configurations (in the same order), which is not supported by legacy system. So legacy creates multiple orders (one for each ATO configuration). Created a system to identify the orders those are related and ship them together. Oxford Health Plans Norwalk, Connecticut Financial Application Implementation June 1996 – April 1997 Modules Worked On: Oracle Accounts Payable (10.x) and General Ledger (10.x) • Led technical team to design solution for claim processing of health insurance using Oracle Financials. a. Requirement Analysis: Required an inbound interface to insurance claim from a legacy application to Oracle Payable to pay the claims. b. Solution design: Used the custom program to populate the insurance claim data to pre-interface tables. Used Invoice Import program to upload the data to Accounts Payable. Designed error reports & forms, and additional programs to store & transact Oxford specific data. • Implemented set-up activity for Oracle General Ledger and Oracle Accounts payables modules, and planned implementation activity of Oracle Financial Application release 10.4 as a member of the solution team. Hayes Microcomputer Products Norcross, Georgia Software Engineer (As a consultant) – ERP Implementation October 1994 – May 1996 • Designed and coordinated development of sales and inventory management applications to match the actual and forecasted demand for computer modems with available to promise inventory. • Development activity included preparing of system requirement, solution design and technical design documents and development of applications in Oracle database. Mysore Kirloskar Limited Harihar, Karnataka, India Software Engineer – ERP Implementation March 1992 – February 1994 • Led project team to provide a solution to monitor and control the cost of manufacturing of machine tools using activity based costing method and a solution to determine the product cost using historical cost method. • Developed programs using Oracle database and its tools to report the LIFO, FIFO, and weighted average cost of purchased materials, lead time calculation of the parts for MRP and Bill of Material explosion and implosion. EDUCATION Master of Business Administration June 2003 William E. Simon Graduate School of Business Administration University of Rochester, Rochester, New York Concentrations: Finance, Corporate Accounting Operation Management Courses: Operation Management, Project Management, and Service Management Certified in Production and Inventory Management (CPIM) February 1999 American Production and Inventory Control Society (APICS) Concentrations: Supply Chain Management, MRP, JIT, and Inventory Management Bachelor of Engineering August 1990 SDM College of Engineering and Technology, Karnataka University Dharwad, Karnataka, India Concentrations: Computer Science & Engineering