Manager Oracle EBS

SUNDEEP DHEER

**** ******** ****** **. ****, TX *7494

920-***-**** ******@*****.***

http://www.linkedin.com/pub/sundeep-dheer/5/95/211

SUMMARY

Extensive experience with Oracle EBS Implementations, Upgrades, Configurations, Development, and Business Analysis in global, multi-org, multi-country, and multi-currency environments.

Over 18 years of high performance experience with Oracle E-Business suite in technical, functional and management roles. Over 9 years in manufacturing and distribution environment.

Excellent gap analysis, project management, resource management, solution architecting and troubleshooting skills repeatedly tested in high-pressure environments. Worked extensively with EBS Setups, Architecture, Development tools, on SCM, OTC, Manufacturing, PTP, Finance and CRM modules.

Designed and delivered rich in-house systems, custom extensions, complex business solutions using Oracle seeded functionality, and driving projects that contributed to company’s efficiency.

Rich business facing experience; building and maintaining key relationships with employees, vendors and customers at all levels.

SKILLS

ERP:

Oracle E-Business Suite versions R12, 11i, 11.0.3, 10.7, and 10.6.

Modules: General Ledger (GL), Account Receivables (AR), Oracle Purchasing (PO), Accounts Payables (AP), Cash Management(CE), Planning, ASCP, Inventory(INV), Order Management (OM), Pricing, Shipping, Configurator, Discrete Manufacturing, iExpenses, Tele-Service(CS), Service Contracts, Install base, System administration, Alerts and AOL

Other Functional Areas:

Lean Six Sigma, Basic Accounting, Cost Accounting, Purchasing, Billing, Sarbanes Oxley, AIM Methodology, Gap Analysis, Feasibility analysis, and Project Management

Technical Skills:

Oracle Forms, Reports, Workflow, Unix shell scripts, Discoverer, Oracle Form Personalization, Oracle APIs, Integration, Configurator, Data Conversion, Java, Bi-Publisher (XML Publisher), XML Gateway, Oracle SOA, SQL tuning, C, Pro*C, Toad, PVCS, Visio, Prevue 5.1.

PROFESSIONAL EXPERIENCE

ZEBRA TECHNOLOGIES, Lincolnshire, IL Sep 2015 to Present

Integration Architect/Functional Consultant- Supply Chain

Environment: Oracle EBS 12.1.3; SCM, OTC, Financials, Manufacturing, Planning, XML Gateway, Oracle Fusion Middleware, Seibel

Responsibilities: 1) Functional consultant for advanced procurement implementation i.e. iSupplier, iProcurement, RFQ, Catalogues, and Negotiations.

2) Techno-functional solution architect for third party and B2B Integrations: design, map, configure, and develop data interfaces to integrate Oracle EBS with trading partners and third party applications using Oracle SOA, XML Gateway, business events, Workflow, and EDI. Demo solutions, Create test cases, coordinate testing, and implementation. Delivered interfaces projects for Create orders, Change Orders, Customer POA, Vendor POA, ASN, INV.

DOVER ARTIFICIAL LIFT, Houston, TX Jun 2014 to April 2015

Oracle Solution Architect and Manager - SCM and Finance

Environment: Oracle EBS 12.1.3; SCM, OTC, WMS, Financials, AGIS, Manufacturing, Planning, Field Services

Enterprise Lead for all aspects of Supply Chain and Finance modules: SME, Solution Architect, Functional, Technical, Requirements gathering, Org structure, Data mapping, Process changes, period-end closing support, including costing, variance and reconciliation. Hands-on Level 3 & 4 helpdesk ticket support.

Successfully completed implementation of Oracle EBS for Mexico operating company as the implementation lead, respecting Mexico statutory requirements. Performed gap analysis, data mapping for conversion, configured Oracle (setups), provided training to users, coordinated testing, GL- SL accounts reconciliation, and acquired business sign-offs.

Identified and implemented numerous solutions for new process implementations and improvements using oracle standard functionality and designing oracle extensions.

CGI (Employed by Mastech), Pittsburgh, PA Jan 2014 to Jun 2014

Functional Support Lead and Service Delivery Manager

Environment: Oracle EBS 12.1.3; SCM, ASCP, forecasting, OTC, Financials, Manufacturing, Installed base, Depot Repair, Field Services

Responsible for Oracle EBS Functional and DBA support for client - Industrial Scientific.

Provided hands-on support for all Supply Chain, OTC, Installbase, and Depot Repair modules as the support lead.

Achieved SLAs successfully. Supported production environments and users on a daily basis, and took care of emergency requests.

IGLOO PRODUCTS, Katy, TX Feb 2013 to Jan 2014

Sr. Manager Enterprise Applications

Environment: Oracle EBS 11i and R12: Manufacturing, SCM, Financials, WMS, OM, ASCP, SOA, OTM

Besides being hands on, I managed team leads for Development, BI, and Administrators.

Lead for Oracle EBS Upgrade project from 11.5.9 to 12.1.3. Delivered upgraded instances, custom objects (RICEW, OAF) based on changed oracle entities and processes including interfaces, AP payment processes and reports, setup role based responsibility accesses for R12; project reporting, coordination with BAs.

Implemented B2B2C and Third Party Logistics (3PL) project for partners ebags.com and costco.com. Designed Process and Dataflow across multiple modules. Implemented and utilized SOA for the same.

Developed test plans and tested ASCP functionality for ASCP upgrade project.

Functionally designed and delivered Work Order completion process (Mfg.) for quick assembly completion and synchronizing it with ASCP database.

HAP HEALTH INSURANCE, Southfield, MI Oct 2012 to Feb 2013

Oracle Financials R12 Consultant

Completed a short project to replace client's legacy check printing software with Oracle R12's check printing functionality. Helped with month-end and year-end closing issues, and provided functional support.

MASCO INC., Ann Arbor, Michigan Jun 2011 to Sep 2012

Manager - Oracle Development and Solution Architect

Environment: Oracle Applications 12.0.4, Financials, Manufacturing, Order Management, Tele-Services, HR (shared), MSCA, ASCP, WMS, Oracle SOA & BPEL 10G, onsite and offshore team, Informatica.

Managed and guided an EBS development team of 11 developers, responsible for all aspects of development work, troubleshooting, and support. Managed technical projects and technical side of business projects. Involved in requirements gathering from the business users and BAs, and presenting solutions to them.

•Architected and Implemented master data hub;

•Designed and developed MSCA customizations;

•Enabled interfacing data between production and non-production instances using Informatica to respect SOX requirements.

•Provided guidance on technical architecture and tools to be used including: data archiving, and performance management/tuning.

THE MANITOWOC COMPANY INC., Manitowoc, Wisconsin Jun 2005 to Jun 2011

Manager - IS Applications

Environment: Oracle Applications 11.5.9, 11.5.10: Financials, Manufacturing, OTC, PTP, CRM, Tele-Services, Service Contracts, Depot repair, Install-base, HR (shared), Oracle OnDemand hosted servers, Optio.

Managed 5 to 10 techno-functional analysts including employees, on-shore and near-shore consultants. Responsible for support and metrics of all development activities for all modules, supporting over 800 users. Responsible for research, providing solutions, delivery, implementation, training, and data integrity related to enterprise-wide software. My team was also responsible for level 3 and 4 production support besides projects.

•Directed IS side of projects for Oracle EBS roll-outs to new business units. Successfully completed seven roll-outs to new business units.

Served as CRM Implementation Lead in one of the Oracle EBS roll outs as an additional responsibility. Worked on gap analysis, BP80, BR100, and led Conference Room Pilot.

•Completed database 10G upgrade, and ‘Change of Hosting Partner’ projects successfully.

•Served as Subject Matter Expert leading multiple re-engineering projects e.g., procurement card automation, Engineering item creation and ECO processes, Services (CRM) re-engineering to reduce data entry time and process efficiency; customized service request form and contact center to process warranties and integrate it to AP and AR; XML data interchange with customers, shop floor labels, moving production to China, EFT through third party, intercompany transactions, Multi-channel dunning letters, ACH payment and confirmation letters to employees and vendors, Installbase interface with a third party registering agency.

•Order to Cash (OTC) Hands-on work: Setting up Intercompany shipping in a multi-country and multi-SOB environment. Setting up document sets for printing at pick and pack; Provided invoicing solution by setting up fulfillment sets; Customizing OM workflows and assigning to OM Transaction types; Interfacing Oracle shipping with UPS software; Interfacing Sales Order from Pepsi to Manitowoc using XML gateway; Column Mapping and design (MD50) for shipping related interfaces with Concentrek (a transport solutions company); Sales reporting to corporate based on complex regions assigned to area managers; Troubleshooting issues with advanced pricing calculations; Configurator changes in EBS 11.5.8; Customized internal order workflows.

•MFG (DTB) Hands-on work: Org Structure setups, Designed a custom module for Shop Floor labels printing for discrete jobs; Items, Categories, BOMs and Routing conversions for each implementation at Manitowoc; New Item Creation workflow and ECO workflow technical design; Uploading Pending costs; Custom serial number generation program; Custom component shortage report.

•Point person to senior management on business priorities; provided project status updates to stakeholders, and monthly team reports with metrics.

JOHNSON CONTROLS, INC. Milwaukee, Wisconsin Jan 2001 to Jun 2005

Module Lead (Fujitsu Consultant)

Environment: Oracle Applications 11.5.8- modules: PA, AR, GL, AP, PO, CE; HP 9000, HP UX 10.20, Oracle 8i, Novell, Toad.

Projects: Oracle Applications Upgrade to Release 11i; Integration with European Countries; and production support.

•Responsible for requirements gathering and setups for General Ledger, Cash Management and A.P. like chart of accounts, set of books, key flexfields, payables system options etc. Areas and branches setup in HR organizations, HR locations, HR Hierarchies, GL Hierarchies.

•Performed requirements gathering, project planning, functional and technical analysis, and development for customizations, interfaces, extensions and provided user support including month end closing. Designed credit cards interface to AR.

•Played key role in European integration projects aspiring for a global database and global code base. Implemented statutory set of books for European countries using consolidation facility in Oracle GL. Provided Oracle EBS training to European IT personnel.

•Worked extensively on 10.7 to 11i upgrade project. Reviewed business processes, modified existing customizations and interfaces for 11i compatibility, and got users’ sign off. Utilized TCA relationships in customers, which was a new feature of 11i.

•Re-engineered business processes for minimum IT involvement, and worked on Sarbanes Oxley issues.

GEMPLUS, Montgomeryville, Pennsylvania Jul 2000 to Dec 2000

Conversion Lead (Consultant)

Environment: Oracle Applications 10.7 and 11.0.3, HP 9000, HP UX 10.20, Oracle 8.0.5.

Project: Oracle Financials Chart of Accounts change and Data Migration to Release 11: The new database also had new setups and new business rules.

•Converted Vendors, Customers, Items, Categories, Purchase Orders, AR invoices, Sales Persons, and AP invoices, year-end accounts balances, key flexfield values and GL code combinations, item-category assignments, and brought on-hand inventory balances.

ACCOR ECONOMY LODGING (Motel 6, Red Roof Inn) Dallas, Texas Apr 2000 to Jul 2000

Technical Lead, Programmer/ Analyst (Consultant) for Oracle Financials Implementation.

Environment: Oracle Financials 10.7NCA, SUN Enterprise 6500, Sun OS 5.6, PVCS.

•Led technical design, data mapping and setups for conversion of customers and invoices from Legacy system to Oracle Receivables. Prepared Technical Design Documents (CV70 & MD70)

•Customized Forms and Reports for AR, OE, PO and GL including graphical postscript reports. Developed Drop Ship Confirm interface between OE and PO.

•Performed AOL & System administration jobs like registering programs, setting up printer drivers etc.

LUCENT TECHNOLOGIES, Allentown, Pennsylvania July 1998 to July 1999

Developer and Performance Testing Lead (Consultant)

Transition from IBM mainframes to Oracle Financials.

•Developed and ran scripts using 'Prevue' and Unix shell scripts for performance testing. Trained and led a team of four developers to use Prevue and develop Prevue scripts for stress testing, and planned the testing.

•Developed scripts in WinRunner for automated conversions of data to Oracle.

•Developed OE interface, custom forms for vendors and historical invoices and reports for AP, AR and PO.

ORACLE SOFTWARE India Ltd. Jan 1998 to Apr 1998

Senior Applications Analyst (Employed by Sunflower Information Technologies Pvt. Ltd. India)

Project: Oracle Financials ver10.7 India Localization Product Development.

Developed localization of Oracle Applications for India, necessitated expanding the functionality of the existing core products to meet local legal and core market needs of the Indian industry with specific focus on the tax structures - Excise and Customs Duty and Sales Tax plus the addition of a letter of credit module.

•Developed Extensions to Oracle Financials by customizing forms, reports, and packages adhering to Oracle Applications coding and interface standards. Developed Libraries and functions that were re-used for different development units.

•Worked on the following modules: Oracle Purchasing, Oracle Payables, Oracle Receivables, Oracle Order entry, Tax and duties registers.

BIRLA-AT&T COMMUNICATIONS LTD., Pune, India (joint venture cellular services) 1996-1997

Programmer Analyst

EDUCATION & TRAININGS

M.S., Computer Information Systems, University of Phoenix (Milwaukee, Wisconsin campus)

B. S., Mechanical Engineering (BE), State Engineering College (Gwalior, M.P., India)

Trainings: Leadership Development, Lean Six Sigma, Oracle WMS R12, Oracle ASCP R12

Contact this candidate