Paresh Kokate
(Mobile: 91-865*******)
Summary
More than 20 years of overall IT experience
More than 13 years of integration solutions designing, development and management experience with Microsoft BizTalk Server, Mule ESB and Dell BOOMI
Experienced in designing and developing Cloud based, On-Premise and Hybrid integration solutions
Having sound knowledge of Continues Development (DevOps) and Micro Services
Experienced in designing and developing various integration solutions likeB2B, EAI, ESB, BPM and Gateway
Experienced in working with various document standards like SAP IDoc, HL7, X12 and RosettaNet
Sound knowledge of integrating ERP systems like SAP, JD Edwards, Navision, BPCS
Global IT experience with overseas working assignments in US, the Netherlands, UK and Indonesia with On-site/Offshore model of work environment
More than 6 years of business application development experience using .Net, Java and MS Office Automation platforms with Oracle and SQL Server database systems
Experience in functional areas like Manufacturing, Infrastructure Service Delivery, Insurance, Retail, Banking and Logistics with corporate clients such as:
oK12 (US)
oHershey (US)
oCovidien (North America and Latin America)
oCommonwealth Bank (Indonesia)
oCompuCom (US)
oKPN/Getronics (the Netherlands)
oPHS (UK)
oAXA Insurance (UK)
Excellent technical, interpersonal, communication and Client handling skills. Team oriented and can work effectively in a demanding time schedule
Skillsets
Integration Middleware
BizTalk Server
Mule ESB
Dell Boomi
API Management Tools
CA API Management Suite
Cloud (SaaS)
SalesForce (SFDC)
Message Queue
AMQP RabbitMQ
MSMQ
Integration (ETL)
Mule Services
SSIS
Reporting Tool
SSRS
Databases
SQL Server and Oracle
Languages & Tools
C#, Java, Visual Basic 6.0, FoxPro, C, C++
Operating Systems
MS-DOS 6.22, Windows 3.x, Win 95, Win NT 4.0, Win 2003, Win 2008, Unix, Linux
Hardware
PC, Server (Intel Xeon), Solaris
Other Tools
Visio, TFS, MS Project
Key Achievements:
Successfully delivered following key Integration Solutions
Automation of “QuoteToCash” process by integrating Salesforce, LMS and Oracle EBS
ESB implementation for enabling agile flow of messages between student information system, ERP system and various learning management systems for an online educational content provider company
Integration solution for M-Commerce platform that could be used for selling anything from groceries to mobile devices and accessories to clothing and fashion accessories to both B2B and B2C customers
SalesForce (SFDC) integration with Data Warehouse (Teradata), Compliance database (SQL Server) and Distributor Interface (SFTP)
Oracle Agile (PLM) integration with Oracle (MDM) and BPCS (ERP)
B2B integration integrating NAVISION (ERP) and partner system Innovation. Secure messaging using DES3 encrypted messages with public key certification validation.
Integrating various NAVISION (ERP) systems across Latin America with the central reporting system to get consolidated business view for Latin America region
US FDA integration with Complain Tracking System. Secure AS2 messaging with SSL and public key certification was used to integration US FDA ESG gateway. HL7 messages flow over this integration.
Integrating BPCS (ERP) with Label Printing System for label printing work order messages flow
Integrating Navision (ERP) with Oracle Retail and WMS (Warehouse Management System)
Successfully implemented the gateway to core banking system (Thaler) and also implemented an ESB solution for core banking gateway and customer on boarding system gateway
Multiple SAP (ERP) systems integration with single SAP (Treasury)for PO and Payment updates.
Successfully played a role of an integration BSA and delivered business use cases pertaining to integrations and documented functional and system requirements for multiple projects
BPM solution that manages the IT initiative work flow, sends alerts to various users involved in the initiative and populates data on the SharePoint (CMS) dash board
Integration of Insurance system with Online Portal and Claims Management System to utilize real-time information flow for insurance policies and claims
Project Experience
AI Analytics Engine Integration (Mule ESB)
Designed and developed an integration solution for an AI based analytics engine. Integration solution is expected to interface with various online data sources (and data formats) and populate datasets for AI engine consumption. AI engine, in turn, identifies trends and patterns and produces intelligent analytic reports.
Project Details
Duration: Jul 2017 – On going
Project: AI based Analytics Solution
Role: Integration Lead
Location Mumbai, India
Environment: Cloud deployment
Project Scope & Responsibilities
Design and document integration solution
Helping development teams understand the design and use correct message formats and structures, data validation, transformation logic, integration patterns/approach, exception handling, alert notification and analytics
Regular checkups on quality of output generated by development teams
Helping technical team during solution deployment and go-live
OTM and JD Edwards Integration (Dell Boomi)
Designed and helped develop a hybrid integration solution for integrating Oracle OTM Cloud (Logistic Cloud) with On Premise JD Edwards ERP. Integration solution enabled flow of sales orders transaction from On Premise JD Edwards ERP to OTM Cloud for planning itineraries and updating On Premise JD Edwards ERP orders with delivery dates and other details.
Project Details
Duration: Feb 2017 – Apr 2017
Project: OTM Cloud and JDE Integration
Role: Integration Lead
Location Mumbai, India
Environment: UNIX (On Premise) and BoomiAtomSphere
Project Scope & Responsibilities
Work with OTM and JDE teams to understand how best OTM and JDE instances can be configured for the integration solution. Design and document the integration solution
Helping development team understand integration requirements and integration solution design for example correct integration patterns/approach, message formats and structures, data validation, transformation logic, exception handling, alert notification and analytics (business activity monitoring)
Regular checkups on quality of output generated by development teams
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
GST Connector for Oracle EBS (Mule ESB)
Designed and helped develop an integration component as part of a larger connector solution product for connecting Oracle EBS ERPs with Indian government’s tax portal. Connector uses Mule ESB as a messaging backbone for interfacing with the tax portal interface. Mule flows are designed and developed in a generic way so that the flows can be seamlessly plugged to any Oracle EBS systems for different customers using Oracle EBS as their ERP.
Project Details
Duration: Nov 2016 – Jan 2017
Project: GST Connector (Messaging Backbone using Mule ESB)
Role: Integration Tech Lead
Location Mumbai, India
Environment: UNIX and Windows Servers
Project Scope & Responsibilities
Work with product team to understand how best Mule ESB can be used as a messaging backbone and embed the runtime and flows seamlessly in the main product pack
Design and document integration solution
Helping development teams understand integration requirements and integration solution design
Regular checkups on quality of output generated by development teams
Helping product team during solution deployment
Helping client’s business and technical team during deployment
Helping support team, post production, trouble-shoot integration issues
Quote to Cash –Salesforce, LMS and Oracle EBS integration (Mule ESB)
Designed and helped develop an integration solution for automating “Quote to Cash” process and integrated Salesforce with Learning Management System (LMS) and Oracle EBS. As part of this integration flow of business messages critical for Q2C process like account propagation, order provisioning, product usage, invoicing and billing is automated.
Project Details
Duration: May 2016 – Sep 2016
Project: Quote to Cash Process Automation
Role: Integration Specialist
Location Virginia, USA
Environment: UNIX
Project Scope & Responsibilities
Understand overall and integration requirements from BA team
Work with existing technical teams to understand how best Salesforce can be integrated with different LMS and EBS
Design and document integration solution
Helping development teams understand integration requirements and integration solution design
Helping development teams understand and use correct message formats and structures, data validation, transformation logic, integration patterns/approach, exception handling, alert notification and analytics (business activity monitoring)
Regular checkups on quality of output generated by development teams
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
Service bus for Student Information Systems (SIS) and Learning Management Systems (LMS) business data exchange (Mule ESB)
Designed and help develop an integration solution for integrating Student Information System and Learning Management Systems with Mule service bus. Bus solution facilitate easy on boarding of new LMS.
Project Details
Duration: Mar 2016 – May2016
Project: Service bus for SIS and LMS integration
Role: Integration Specialist
Location Virginia, USA
Environment: UNIX
Project Scope & Responsibilities
Understand overall and integration requirements from BA team
Work with existing technical teams to understand various backend SIS systems and how best they can be integrated with different LMS
Design and document integration solution
Helping development teams understand integration requirements and integration solution design
Helping development teams understand and use correct message formats and structures, data validation, transformation logic, integration patterns/approach, exception handling, alert notification and analytics (business activity monitoring)
Regular checkups on quality of output generated by development teams
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
Integration Solution for M-Commerce Platform (CA API Management)
The purpose of this project is to design integration solution for M-Commerce platform that could be used for selling anything from groceries to mobile devices and accessories to clothing and fashion accessories to both B2B and B2C customers. This integration solution integrates backend systems like order management system, warehouse management system, delivery management system, promotion engine and ERP with mobile app via APIs hosted in API management middleware.
Project Details
Duration: May 2015 – Nov2015
Project: Integration Solution for M-Commerce Platform
Role: Integration Specialist
Location Mumbai, India
Environment: Platform: UNIX and Windows
Project Scope & Responsibilities
Understand overall and integration requirements from BA team
Work with existing technical teams to understand various backend systems and how best they can be integrated
Design and document integration solution
Helping development teams understand integration requirements and integration solution design
Helping development teams understand and use correct message formats and structures, data validation, transformation logic, integration patterns/approach, exception handling, alert notification and analytics (business activity monitoring)
Regular checkups on quality of output generated by development teams
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
BizTalk AD Account Procurement Interface (BizTalk)
The purpose of this project is to design and develop an interface for handling Active Directory operation requests like Create user, Add User to group, Add Group to Domain etc. For interfacing with AD, existing web service is used that interfaces with AD using .Net classes. This integration solution also updates SQL Server tables upon successful completion of AD operations. SQL Server updates help users generate report on AD operations.
Project Details
Duration: Dec 2014 – Feb 2015
Project: BizTalk AD Account Procurement Interface
Role: Integration Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in requirement discussions with client’s business team
Participate in design discussions with client’s technical
Documenting integration solution design
Helping development team understand integration requirements and integration solution design
Regular checkups on quality of output generated by development team
Participating in review discussion with client technical team
Working closely with project managers for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
SalesForceOrder Management Integration (Mule ESB)
Developed Mule integration service for integrating SalesForce with the Hershey Distributors interface (sFTP) and enabled transfer of PO Acknowledgements EDI (855) messages from Distributors to SalesForce.
Successfully replaced the manual upload process of importing PO Acknowledgments in SalesForce with the automated integration service that:
Receives PO Acknowledgement EDI (855) messages from the distributors
Validates the PO Acknowledgement messages with the EDI schema (855)
Email invalid PO Acknowledgements for follow up with the distributors
Updates SalesForce with the valid PO Acknowledgements
Developed Mule integration service for sending Hershey compliance data to the partner MSA so that MSA can help Hershey analyze in-store buying decisions, design better packaging and products, and better organize stores in ways that maximize profit and improve the shopping experience
Project Details
Duration: July 2014 – Sep 2014
Project: SalesForce Integration Services
Role: Integration Technical Lead
Location Pennsylvania, USA
Environment: Platform: Windows and UNIX
Project Scope & Responsibilities
Participate in requirement discussions with client’s business team
Participate in design discussions with client’s technical team
Documenting integration solution design
Helping development team understand integration requirements and integration solution design
Regular checkups on quality of the output generated by development team
Participating in review discussion with client’s technical team
Working closely with project managers for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s testing and business team during testing and go-live
OneAgile (PLM, MDM and ERP Integration) (BizTalk)
The purpose of this project is to design and develop integration solution to integrate Covidien Product Lifecycle Management System (PLM) with Master Data Management (MDM) and ERP system. Product update messages are sent from Oracle Agile (PLM) to Oracle MDM database and BPCS (ERP).
Project Details
Duration: Dec 2013 – May 2014
Project: One Agile
Role: Integration Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in requirement discussions with client’s business team
Participate in design discussions with client’s technical
Documenting integration solution design
Helping development team understand integration requirements and integration solution design
Regular checkups on quality of output generated by development team
Participating in review discussion with client technical team
Working closely with project managers for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
Brazil T&E (B2B Integration) (BizTalk)
The purpose of this project is to develop integration solution using BizTalk Server 2010 to integrate Covidien Brazil ERP (Microsiga) with the business partner INNOVATION for transmitting employee T&E messages. Solution encrypts every message before transmitting to the business partner and decrypts the incoming (encrypted) message from business partner before submitting the same to the ERP.
Project Details
Duration: Oct 2013 – Nov 2013
Project: Brazil T&E Integration
Role: Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in the requirement discussions with client’s (Covidien LATAM) business team
Participate in the design discussions with client’s (Covidien LATAM) technical team and technical team of Covidien’s business partner INNOVATION.
Documenting solution design
Helping development team understand the requirement and solution design
Regular checkups on quality of the output generated by the development team
Participating in the review discussion with client’s (Covidien LATAM) technical team
Working closely with project manager for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
Master Data Management Integration (BizTalk)
The purpose of this project is to develop integration solution using BizTalk Server 2010 to integrate Oracle Agile system (Product Lifecycle Management System) with the Oracle master data management database. Master data created or changed in Oracle Agile, once this integration solution is in place, would be transmitted to Oracle master data management database so that the master data would become available, in real-time, to other systems.
Project Details
Duration: Apr 2013 – Oct 2013
Project: Master Data Management Integration
Role: Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in the requirement discussions with client’s (Covidien) business team
Participate in the design discussions with client’s (Covidien) technical team
Documenting solution design
Helping development team understand the requirement and solution design
Regular checkups on quality of the output generated by the development team
Participating in the review discussion with client’s (Covidien) technical team
Working closely with project manager for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
eMDR (FDA ESG AS2 Integration) (BizTalk)
The purpose of this project is to develop an integration solution using BizTalk Server 2010 to integrate Covidien Complaint Tracking System with US FDA (Food and Drug Administration) ESG System to send eMDR (Medical Device Report), in HL7 format, automatically and receive acknowledgments from US FDA that denotes the report is successfully received and processed by US FDA. BizTalk AS2 EDI Adapter is used to transmit electronic eMDR messages and BizTalk TPM is used to configure EDI and Partner (FDA) profile.
Project Details
Duration: Dec 2012 – Mar 2013
Project: eMDR
Role: Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in the requirement discussions with client’s (Covidien) business team
Participate in the design discussions with client’s (Covidien) technical team
Documenting solution design
Helping development team understand the requirement and solution design
Regular checkups on quality of the output generated by the development team
Participating in the review discussion with client’s (Covidien) technical team
Working closely with project manager for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing
QAD – PRISYM Web Medica (ERP and Label Printing System integration) (BizTalk)
The purpose of the system is to alter existing BizTalk integration solution called GLIS (Global labeling Integration Solution) to integrate new ERP system called QAD so that Work Orders (for label printing) from QAD can flow to GLIS and in turn the destination system called PRISYM Web Medica.
Project Details
Duration: Sep 2012 – Nov 2012
Project: QAD – PRISYM Web Medica integration
Role: Technical Lead
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in the requirement discussions with client’s (Covidien) business team
Participate in the design discussions with client’s (Covidien) technical team
Documenting solution design
Helping development team understand the requirement and solution design
Regular checkups on quality of the output generated by the development team
Participating in the review discussion with client’s (Covidien) technical team
Working closely with project manager for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
DistriVision (ERP and Business Report System Integration) (BizTalk)
The purpose of this project is to provide integration solution, using BizTalk Server that integrates various NAVISION ERP systems across Latin America with the reporting system called DistriVision. Periodically, required (for reports) ERP data is published to country wise MSMQ queues and BizTalk integration solution picks up ERP messages and stores the messages to database of DistriVision reporting system.
Project Details
Duration: May 2012 – Aug 2012
Project: DistriVision
Role: Technical Manager
Location Mumbai, India
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Participate in the requirement discussions with client’s (Covidien) business team
Participate in the design discussions with client’s (Covidien) technical team
Documenting solution design
Helping development team understand the requirement and solution design
Regular checkups on quality of the output generated by the development team
Participating in the review discussion with client’s (Covidien) technical team
Working closely with project manager for effective project tracking
Helping client’s technical team during solution deployment
Helping client’s business team during testing and go-live
Managing EAI Integration Solutions (BizTalk)
I was responsible for supporting existing EAI interfaces built using BizTalk Server 2006 and also changing them as per business needs. I was also responsible for redesigning interfaces incapable of withstanding the ever growing message volumes.
Project Details
Duration: March 2011 – April 2012
Project: Managing BizTalk EAI Solution
Role: Technical Manager
Location Mumbai, India
Environment: Platform: Windows 2008, 2003
Project Scope & Responsibilities
Redesigned BizTalk solutions incapable of withstanding the ever growing message volumes
Managing CRs life-cycle
Managing support and infra issues
Managing development and support teams
Coordinating with business and other teams participating in the EAI
ESB and Integration Gateway (BizTalk)
I was responsible for designing and development of Gateway to the core banking system (Thaler),ESB Solution using ESB Toolkit, Customer On-boarding System (SharePoint) Integration for Commonwealth Bank Jakarta.
Project Details
Duration: May 2010 – Feb 2011
Project: BizTalk 2009 Development
Role: Technology Architect and Developer
Location Jakarta, Indonesia
Environment: Platform: Windows 2008
Project Scope & Responsibilities
Designed and developed a BizTalk web service and solution that acts as a gateway to the core banking system (Thaler)
Designed an ESB solution that would be used by various systems within the bank for supporting business processes
SharePoint Integration using SharePoint Web Services
MoneyCubePlus (.Net)
Money Cube Plus is a personal finance management product. The software processes various transactions (bank account statement, credit card statement, stock broker statement) received in individual’s emails in a PDF format and generates charts which shows individual’s net worth. Solution was developed in C# (Framework 3.5) and SQL CE.
Project Details
Duration: March 2009 – May 2010
Project: Personal finance management product development
Role: Solution Architect, Team Lead, Developer
Location Mumbai, India
Environment: Platform: Windows XP, Windows Vista, Windows 7
Project Scope & Responsibilities
Designing the overall solution
Management of overall development
Development of core component
Partner Bridge Web Services Integration (BizTalk)
After CompuCom’s acquisition of Getronics’s US business, it was decided that same BizTalk integration solutions present in Europe would be replicated in US CompuCom for supporting US customers and a Partner Bridge, using BizTalk, was developed.
Project Details
Duration: Nov 2008 – Feb 2009
Project: Partner Bridge using BizTalk 2004
Role: Project Leader
Location Mumbai, India
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Understanding the design and ensuring that the development is done accordingly
Managing BizTalk development team
Coordinating with the customer
Insurance Illustration Generating System Migration (for AXA Winterthur) (.Net)
The solution in scope is to migrate a VB6 Activexdll to .Net(C#) dll. Component in scope produces insurance illustrations PDFs.
Project Details
Duration: Aug 2008 – Nov 2008
Project: VB6 to .Net(C#) Migration
Role: Project Lead
Location Mumbai, India
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Managing the migration development activities
Ensuring correct .Net features are mapped to VB6 concepts
Ensuring no functionality is omitted during migration
Coordinating with the customer
Service Activity Manager (for PHS UK) (SSIS and .Net)
System helps PHS in accurate recording, monitoring and reporting of employee vaccination, recurring events in depots like fire alarm inspection, vehicle maintenance, license renewal etc. Solution was developed in ASP.Net, SQL Server 2005.
Project Details
Duration: Feb 2008 – July 2008
Project: Service Activity Manager (using ASP.Net)
Role: Team Lead, On-site coordinating
Location Wales, UK
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Managing development team and development activities
On-site coordinating
EAI (SAP Integration) (BizTalk)
Solution is provided that helped ERP systems update Treasury with the PO and Payment updates.
Project Details
Duration: January 2008 – July 2008
Project: EAI using BizTalk 2006 (SAP Adapter)
Role: Project Leader
Location Mumbai, India
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Understanding the design and ensuring that the development is done accordingly
Managing BizTalk development team
Coordinating with the customer
Castor (for PHS UK) (.Net)
Castor is a product maintenance system that allows PHS to import product from core system, change product attributes and validate the changes Solution was developed in ASP.Net, SQL Server 2005.
Project Details
Duration: October 2007 – December 2007
Project: Castor (ASP.Net Application)
Role: On-site coordinating
Location Wales, UK
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Understanding the solution design, project functionality
On-site coordinating
Assisting On-site UAT
Offshore Integration BSA Practice for Getronics (BizTalk)
BSA Practice implementation for Getronics Integrations (BizTalk) projects from India.
Project Details
Duration: May 2007 – September 2007
Project: BSA Practice for Integration (offshore)
Role: BSA Practice for Integration
Location Mumbai, India
Environment: Platform: NA
Project Scope & Responsibilities
Delivered business use cases functional and system requirement documents from offshore.
Integration BSA at Getronics (BizTalk)
Delivered business use cases, functional and system requirement documents based on a workshop attended in the Getronics.
Project Details
Duration: December 2006 – April 2007
Project: BSA Practice for Integration (on site)
Role: BSA Practice for Integration
Location Utrecht, The Netherlands
Environment: Platform: NA
Project Scope & Responsibilities
Played a role of Integration BSA
Delivered business use cases functional and system requirement documents
Administration Module Enhancements (VB6 and Classic ASP)
Added maintenance module for master entities which was missing in the earlier version. Development was done in ASP, VB6 and SQL Server 2000.
Project Details
Duration: October 2006 – November 2006
Project: ODS Administration Module Enhancements
Role: Team Lead
Location Mumbai, India
Environment: Platform: Windows 2003
Project Scope & Responsibilities
Managing development team and ensuring development progress as per design
Tax Wizard Application (.Net)
This application replaces the existing manual tax calculation and report generating process with the automated one.
Project Details
Duration: January 2006 – September 2006
Project: Tax Wizard Application
Role: Team Member
Location Mumbai, India
Environment: Platform: Windows 2003
Project Scope & Responsibilities
System analysis and documentation.
SAP integration(BizTalk)
Prototype was developed for Microsoft customer Bajaj Auto to exhibit the SAP connectivity.
Project