DEEPAK  MANDREKAR

1 Weaver Drive                                                                                      Tel: (856) 335-1000

Marlton, NJ 08053                                                                                  Email: dmandrekar@iiitech.com 

 

 


“Here is an opportunity to work with a core expert who worked with SAP building core applications”

 

PROFILE   

·         Ten years IT experience with design, development, maintenance and support of applications and full-cycle implementations

·         Over 8 years of project & team management experience including product management, resources and also creating and managing project budgets and handling change of scope costs along with T&M development & consulting.

·         Over six years expertise in development of standard & custom SAP applications and business solutions using ABAP Objects, ABAP/4, web technologies and business experience in SAP Financial Services, SAP Insurance, SAP EH&S, MM, SD and WM modules.

·         Core SAP development team member (Newtown Square, US and Walldorf, Germany) implementing new standard SAP solutions and managing OSS notes.

·         Ten years of programming experience using ABAP OO, ABAP/4, Java, PHP, JavaScript, JSP, etc.

·         Experience with development of web applications and deploying/maintaining web server

·         Excellent communication and interpersonal skills

·         Actively managing operations and development projects for iii Technologies

 

 

ACADEMICS

MS in Engineering                                  Purdue University, West Lafayette, IN

BS in Engineering                                  Shivaji University, India

 

AWARDS

·         Recipient of a National and a State Award for research work in engineering (Details will be provided on request).

·          Recipient of a National Award for Technical Papers

 

 

WORK EXPERIENCE

 

Independent Consultant (Core Development)     SAP America/SAP Labs                    03/2005 – till date

Responsible for management and development of SAP Claims Management for Workers Compensation (part of SAP Insurance business unit). Performed all project management activities for Workers Compensation product development cycle including tasks, logistics and time management. Designed, developed and managed claims management tools like benefit calculator for Workers Compensation, benefit catalogs, first notice of loss (FNOL/FROI), third party interface with SAP for benefit rules, Microsoft Office integration with SAP and other claims management features for US Workers Compensation. Part of SAP core development team for SAP Insurance (Financial Services) based in US and Walldorf. Core development was done using ABAP Objects, Business Data Toolset (BDT), ABAP persistent objects, Direct Input, Business Rules Framework (BRF) and other SAP R/3 development tools. Apart from development, responsibilities included writing functional and technical design specifications, write test scripts/plans and managing customer and internal OSS messages. Also developed Adobe Interactive Forms within SAP to display check payment information and also to simulate the benefit catalog data. Implemented BADIs and created new enhancement spots for prior releases. Prepared product documentation including product manuals, application help and release notes. SCRUM project management methodologies were used in the latest project for ERP2005s release. Managed the Workers Compensation downport to enhancement systems using Agile SCRUM project management approach. Created sprint tasks and managed the burndown across each sprint within the SCRUM lifecycle. Supporting SAP presales, sales and demo teams with demo preparation and technical support for prospects in US, Europe and Malaysia.

(Tools: ABAP Objects, BDT, BRF, Direct Input, MS Office Integration, Adobe Interactive Forms, etc

SAP Releases: SAP 4.71/4.72, ERP2005 and ERP2005s Project Mgmt Tool: Agile SCRUM)

See SAP Blog: https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/5781

 

 

 

SAP Product Development

            Developed wrapper APIs to be used within the SAP HR OM implementation to create business partners, organizational units and staff assignments. Assisted the development team to develop reports and interfaces to mass upload jobs, positions and other organizational entities from the legacy system into the SAP production environment. Performed development of SAP Java Connectors in order to build web-interface between customer web site and SAP R/3 system. Developed Java beans for use with vendor site that interfaces with Material Master and cross-components within SAP. Built custom MS Access database as a temporary data storage station between web front-end and SAP R/3 system and developed objects in Java to read/manipulate data from SAP.

(Tools: Java 2, Apache Tomcat 3.3.2, MS Access, SAP R/3 4.6c, ABAP/4 & SAP modules: HR,MM, CRM)

 

 

Additional Charge:

Vice President, Operations                  iii Technologies                                   08/2005 – till date

 

Responsible for operations, development and consulting services at iii Technologies. Manages the student information portal http://www.bigstudent.com. Also, oversees and manages all SAP consulting and development practice for iii Technologies.  Responsible for business development and strategic positioning of services and products for enterprise applications.

 

Senior Developer                                TechniData America                            06/2001 – 03/2005

(TechniData is an exclusive SAP Development Partner headquartered in Markdorf, Germany)     

Responsible for development, implementation and management of SAP R/3 Global Enterprise Solution at several client SAP implementations. Over six full cycle implementations since 2001. Please see below for more details.

 

Client: Eastman Kodak Company                                                                    10/2002- 03/2005

            Manage and review tasks of development team on-site and prepare functional/technical specifications in coordination with the super users. Used ASAP methodology in most part of the implementation. Setup Business Process Master List to manage all activities in the EH&S implementation via IMG. Managed the team and project tasks in the realization phase of the implementation. Design and code complex customer exits and gaps and oversee development of enhancements and gaps done by pool of developers in the team. Implement Product Safety & Dangerous Goods solution of SAP and create a SAP web-interface for users and vendors to see the material safety data sheets and other product regulatory information. MSDS Website project included setup and installation of existing standard SAP web-interface solution followed by customer specific requirements on the website using JavaScript, Java, JSP and ABAP/4. In addition, the MSDS document search and display along with other MM data was developed within SAP R/3 using ABAP. Other development tasks included the creation of HTML files for web-interface on the application, implementation of customer exits of spec management, data migration and upload from flat files into SAP R/3 using ABAP/4. Conducted business user training and created user documentation for tools and solutions developed.

(Tools: ABAP/4, Java 2, JavaScript, JSP1.1, HTML, IMG, BAPIs, Screen Painter & SAP modules: Dang Goods, MM Project Mgmt: Lotus Notes & ASAP Methodology)

 

 

Client: Symrise                                                                                                11/2004 – 3/2005                      

Primary tasks included demo, blue printing and business discussions for implementing the Warehouse

& Inventory Tracking Solution for Federal SARA and New Jersey RTK Reporting. Develop report generation tool to generate statistical reports grouped by plants, states and national geographic regions. Generate reports in MS Excel format for business validations for a certain date range. Being an author of this product, my role was to install the WITS package and then oversee the customer specific development. Provide development support to include user exits to accommodate client requirements within the standard package. Configured WM movements, dual movement handling, filling order exceptions, etc.

(Tools: ABAP/4, IMG & SAP modules: SAP MM, WM)

 

 

Client: Clariant Corporation                                                                 7/2002 – 12/2004

            Designed and developed warehouse and inventory tracking solution for New Jersey CRTK and Federal SARA reporting. Defined the scope of the project and managed the project using  ASAP project management approach. Created BPML after defining the scope of the project, managed IMG activities and lead the team and client resources through the development and integration test phases of the project. Functionality primarily comprised of ABAP/4 development to collect warehouse inventory data on nightly basis followed by data optimization and archiving. Reporting was triggered off a dialog transaction and SAP regulatory & MM data was read using RFC and BAPIs from remote R/3 systems. WM data was initialized by ABAP background job into the collection table after archiving so as to ensure accuracy of current stock levels from the database. Additional tasks for this project included data dictionary setup, IMG configuration, RFC setup, setup of background jobs, project management, functional and technical specification. Worked with the lead business and functional experts to create training manual and user documentation. Created specifications and developed tool in ABAP for initialization of stock quantities from the storage bin stock levels from database tables.

(Tools: ABAP/4, IMG, RFC, BAPIs, Screen Painter & SAP modules: SAP 4.6c WM, EH&S, MM

Project Mgmt Tool: ASAP Methodology)

 

Client: General Mills Company                                                                        12/2002 – 11/2004

      Part of SAP core-development team involved in development, troubleshoot and implement custom enhancements for SAP Recipe Management System (SAP PLM). Developed several custom transactions and programs to create, modify and process RMS documents in the SAP DMS (Document Management System) using BAPIs for SAP DMS. Developed features for SAP RMS in ABAP like status network to use Engineering Change Management, legacy data upload tool, RMS customer exits, web-interface for product and packaging document management and other customer specific enhancements that were later rolled into standard SAP RMS module. Developed technical specifications and managed/overshadowed the customer enhancements done by General Mills ABAP development team. Built VBScripts and NT scripts to migrate documents between the application and web servers. Managed and resolved OSS notes that were submitted by General Mills users. 

(Tools: ABAP/4, JavaScript, VBScript, IMG, BAPIs, SAP DMS, Screen Painter & SAP modules: SAP PLM, SAP RMS 1.0/2.0 Project Mgmt Tool: ASAP Methodology)

 

 

Client: DuPont                                                                                     7/2003 – 3/2005

            Implemented and developed custom SAP EH&S features including MSDS triggering from MM, MSDS distribution from SD, auto-MSDS printing using a data file from application server and several other business specific development projects. Setup logical systems, RFC destinations, setup IDOC segments and distribution model. Maintain IDOC processing profiles and troubleshoot ALE messages using BD87. Develop reports that dispatch IDOCS across the systems via background jobs. Setup and configure ALE process to migrate DG, phrases and other substances data from SAP EH&S system to other business R/3 systems. Manage and support development requirements and provide functional/technical support in the SAP Production environment. Support and troubleshoot issues with generation server, SAP documentum interface, document export jobs, WWI templates and other report generation & shipping issues. Support data migration from the legacy systems and provide development support for data conversion. Conducted training sessions for functional and business users.                              (Tools: ALE, ABAP/4, IMG, BAPIs, BDC, Screen Painter & SAP modules: SAP 4.6c EH&S, SAP MM/SD

Project Mgmt Tool: Lotus Notes, Microsoft Project)

 

 

Client: Invista Corporation (formerly DuPont Textiles)                            1/2004 – 9/2004

            Used SCRUM approach in managing the project of migrating the Invista SAP systes from the original DuPont R/3 network. Analyzed and managed the time and budget for the team and managed the deliverables of the project in time and within budget. Handled change of scope requests and revised the budgets accordingly. Supported with full life cycle SAP R/3 implementation including separation from DuPont R/3 system network. Develop a project plan for all activities including gathering business requirements to implement and integrate SAP business clusters. Provide post-production support for the separation and business implementation. Developed functional and technical specifications for safety datasheet mailing, triggering

and automation of datasheets output via printer/fax/email.

(Tools: ABAP/4, IMG, BAPIs, ALE, Screen Painter & SAP modules: SAP4.6c MM/SD

Project Mgmt: ASAP Methodology)

 

Client: Resolution Performance Products (formerly part of Shell)                   4/2003 – 9/2003

            Implemented and developed DokX tool used for document management for safety datasheets. Performed custom development to fetch documents from SAP R/3 system onto the DokX server. Designed and developed the website for sharing and management of documents on DokX server. Built administrator part of the DokX web front end for controlling the documents and enforcing on-demand datasheet retrieval from the SAP R/3 system. (Tools: ABAP/4, JavaScript, HTML, UNIX & SAP modules: SAP MM)

 

Client: Aventis (Bayer Crop Science)                                                   10/2003 – 2/2004

            Support ERP team with data migration and other enhancements for transitioning from Aventis system to BCS SAP R/3 system. Tasks included ABAP development to support material renumbering, migration of characteristics data and data validation. Automated datasheet printing on a nightly basis that was otherwise triggered manually when sales orders were created. Mapped regulatory characteristics data to new BCS characteristics and created programs to move data from Aventis to BCS system.

(Tools: ABAP/4, IMG, BAPIs, & SAP modules: SAP MM)

 

Client: BASF                                                                                        10/2001 – 1/2002

            Managed the development project, pricing (all fixed fee and T&M tasks) and planned and executed the deliverables of the project within time and budget. Developed inventory management (IM) stock tracking solution for New Jersey Community Right to know reporting. Solution included creation of specifications, database design and development of background job to track goods movements at all the storage locations across the state. Custom transactions were built for reporting and customizing the environment parameters.

(Tools: ABAP/4, IMG, & SAP modules: SAP MM, WM)

 

Client: Degussa Construction Chemicals                                                         8/2001 – 11/2003

            Designed and developed a custom solution for processing datasheets for environmentally relevant materials. The user exits performed validations for dangerous goods and the corresponding safety datasheets were further processed in the report shipping background job that was executed on a nightly basis. Built a custom solution using ABAP to upload datasheets automatically from the legacy systems and link them to the environmentally flagged materials in MM. Designed and developed exits to drill down the KIT materials and get the datasheets for the part materials that form the KIT. Similar functionality was also developed for multi-component FERTS. Design lead for other development tasks overseeing the technical design and development

(Tools: ABAP/4, IMG, & SAP modules: SAP MM)

 

Client: Degussa Fruits & Flavors                                                                      2/2002 – 7/2002

Developed custom ABAP programs to populate characteristics data on the Material Master from the Specification Management System.  In addition, created BDC program for functional lead to populate MM data via MM txns. (Tools: ABAP/4, IMG, & SAP modules: SAP MM)

 

Client: New Horizon                                                                             2/2002 – 4/2002

Implemented user exits for generating composition history reports. Created functional and technical specification for these objects within the New Horizon landscape.

 

Client: Petrotrin                                                                                               8/2003 – 9/2003

            Supported our project team with installation of ISI-Step package at Petrotrin and provided remote support with all issues ranging from adjusting the number ranges to troubleshooting package related issues.

 

Developer                                TenFold Corporation                                       7/2000 – 6/2001

            Lead the team and managed TenFold product ‘Transaction Engine (TE)’. Built transaction processing applications using TenFold UA, HTML, Java1.1, JavaScript, Oracle 8.1.5 and PL/SQL. Developed the nightly regression tests by creating UNIX & NT scripts. Oversaw daily activities of TE test team and troubleshoot issues with nightly build and releases. Developed and managed packages for release management.

 

Web Products Developer         Deeps Consulting                                             1 year (8/96-6/97 & 6/98-8/98)

Developed an applications database (using Pro*C, Oracle 8.0.4 and PL\SQL) and web application using HTML4.0, JavaScript and Java 1.1. This web-site is supported by database that has all academic information for customers of Deeps Consulting. Utilized Adobe Photoshop, FrontPage, and other tools to create web graphics and other components of the application.

 

Research Associate     Indian Inst. Of Technology (Mumbai, India)     6/1997 – 6/1998

Involved in development of software for reinforced building design.

Other projects included development of Airline Reservation System using HTML, JavaScript, Pro*C and PL/SQL.

 

 

SAP SKILLS SUMMARY

SAP ABAP Objects

Business Data Toolset(BDT)

Business Rules Framework(BRF)

Agile Scrum Project Mgmt

Adobe Interactive Forms in SAP

SAP MS Office Integration

SAP ABAP/4

Screen painter

SAP IMG customization

SAP Project Management

RFC setup/configuration

Background job setup

Design functional/technical specifications

Programming user/customer exits

SAP Document Management System

Transport Management

Data dictionary design/development

Engineering Change Mgmt

SAP Business Warehouse 3.5

ALE

BDC(Batch Data Comm)

SAP Java Connectors

PHP Development

 

 

TECHNICAL SKILLS SUMMARY

Languages:      Java 2, SAP ABAP/4, JavaScript, JSP1.1, HTML4, Pro*C, Fortran77, PHP

Databases:       Oracle 9i, MS Access, ForPro2.6, MySQL

OS:                              All Windows, NT, UNIX, DOS

Others/Proj Mgmt:        Apache Tomcat, Microsoft Project, Lotus Notes, Cold Fusion, Flash, Front Page

 

 

WORK STATUS:           U.S. Permanent Resident (Green Card)