Enrico Zerilli ... I work on BizTalk from 2000 in all most important Software company in the world. Integration is my passion and I would meet new integration platform with many integration approaches. I'm certified in all BizTalk version. I have strong skills in MS SQL Server with much important work experience like DBA I'm certified on MS SQL Server too. Next, there is my CV.

Curriculum Vitae

Work experience:

01/01/2019 ReleWant SA, Lugano Switzerland

Integration Manager

Activities: Integration Manager. Manage, design, development, manage all Integrations Projects on BizTalk 2016, MS SQL Server and Microsoft Technology in general. Manage a five people's team for all Integration activities on customer Avanade and Accenture. Focal point for FE (Fatturazione Elettronica - Electronic Invoice involved with Italian Government) Integration with public administration

Technology used: BizTalk 2016, ReST Adapter, WCF Adapter, File Adapter, FTP Adapter, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2017.

Customers: Candriam (Bruxelles), AG Insurance (Bruxelles), Avanade, Accenture, Auchan, SMA, Rinascente, Prysmian, Leonardo, Feltrinelli, Ikea,

Unicredit, iCubed, ReteInformatica.

22/03/2018 - 31/12/2018 Advisia Sagl, Mendrisio Switzerland

Integration Specialist

Activities: Integration Architect. Design, development, manage Integration Project on BizTalk 2010,2013, 2013 R2,2016, SQL Server and Microsoft Technology in general. Design and development Advisia IoT architect.

Technology used: BizTalk 2016, Azure Adapter, AS400 Adapter, SQL Adapter, ReST Adapter, WCF Adapter, File Adapter, FTP Adapter, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2017.

Customers: EMD, Assist, Cortis Lentini, Sinervis, Walk2Talk, March Networks.

12/02/2018 - 09/03/2018 BS-Team Sagl, Lausanne Switzerland

Ingènieur BizTalk Senior

Activities: Integration Architect. Design, development, manage Integration Project on BizTalk 2010,2013, 2013 R2,2016, SQL Server and Microsoft Technology in general.

Technology used: BizTalk 2016, Business Rule Engine, WCF Adapter, File Adapter, FTP Adapter, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2012, 2014 and 2016.

Customer: Ferring PHARMACEUTICAL

10-02/2014 - 09/02/2018 Euroconsumers Italy, Altroconsumo Milano

Expert BizTalk

Activities: Integration Architect. Design, development, manage Integration Project on BizTalk 2010,2013, 2013 R2,2016, SQL Server and Microsoft Technology in general.

Technology used: BizTalk 2016, BizTalk 2010, BizTalk 2009, SQL Adapter, Oracle Adapter, WCF Adapter, File Adapter, FTP Adapter, SFTP Adapter, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2012, 2014 and 2016.

Customers: Altroconsumo Edizioni, DECO Proteste, TEST ACHATS, OCU, Proteste!, Euroconsumers.

09/2011 - 10/02/2014 - Microsys Italy, Milano

Senior Consultant BizTalk

Activities: senior consultant in BizTalk, SQL Server and Microsoft Technology.

Technology used: BizTalk 2016, BizTalk 2013, BizTalk 2010, WCF Adapter, File Adapter, FTP Adapter, SFTP Adapter, EDI schema, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2012, 2014 and 2016.

Customers: Sirti, Tamoil, Yoox, Cariparma, Avvenire, CSI Piemonte, Ministero Dell'Interno Albanese.


02/05/2009 MCTS Trainer Microsoft, Milan Italy

Activities: Trainer Microsoft on MS BizTalk, MS SQL Server, and .NET.

08/2004 - 08/2011 TAMOIL Italy, Milano - Italy

ESB EAI Integration Manager

Activities: Management integrations architectures SW and DB centralized databases in cluster. and Management of all technical activities related to EAI Architectures: software selection, cost planning, resources planning, analyze, designs, developments, test, deployment, and maintenance old/new solutions for all kind Integration Problems between SAP, MS AXAPTA, SharePoint and external systems.

Technology used: BizTalk 2010, BizTalk 2009, BizTalk 2006, BizTalk 2004, BizTalk 2000, SAP Adapter, SQL Adapter, WCF Adapter, File Adapter, FTP Adapter, SFTP Adapter, EDI schema, Custom Pipeline, Custom Functoids. Class Library C#, WCF services, Store Procedure on MS SQL Server 2008, 2012.

Customers: Tamoil, Tamoil Logistic, Tamoil Financial Services.

02/2004 - 08/2004 IrisCube Reply Italy, Milan - Italy

Project Leader (Freelance)

Activity: Management of all technical activities related to EAI Architectures (primary target), software selection, cost planning, resources planning, analyze, design and implementation new solutions (typical solution: B2B/P2P/A2A/ERP/CRM/DM architecture).

Technology used: BizTalk 2004, BizTalk 2000, SAP Adapter, SQL Adapter, File Adapter, FTP Adapter, EDI schema, Custom Pipeline, Custom Functoids. Class Library C#, Web Services, Store Procedure on MS SQL Server 2008, 2012.

Customers: BNP Paribas, Banca Intesa, Banca San Paolo, Banca Woolrich.

09/2002 - 02/2004 C.S.C. Italy, Milan - Italy

Project Leader

Activity: Management of all technical activities related to BMW Customer (primary target for BMW ZI, other customers like a secondary target), analyze a design and implementation new solutions for all Business Unit's BMW (typical solution: B2B/P2P/A2A/ERP/CRM/DM architecture). Technology used: BizTalk 2004, BizTalk 2000, SAP Adapter, SQL Adapter, File Adapter, FTP Adapter, EDI schema, Custom Pipeline, Custom Functoids. Class Library C#, Web Services, Store Procedure on MS SQL Server 2000, COM Object, VB6, ASP.

Customers: BMW ZI, BMW Financial Services.

04/2001 - 10/2001 AVANADE S.r.l., Milano - Italy

Solution Developer

Activity: programmer consultants.  

04/2001 - 10/2001 AVANADE S.r.l., Milan Italy

Solution Developer. Activity: programmer consultants.

01/2001 - 04/2001 WOL World On-Line (TISCALI), Milan Italy

Web Application Activity (Freelance Activity) Activity: programmer consultants.

10/1998 - 04/2001 TRENITALIA S.p.A, Milan Italy

Manutention Engineer. Activity: Management and Design of ETR500 Manutention's Processes. These include resources planning, cost analyses and feasibility study of a new Software product.

07/1998 - 10/1998 IBM - Italy, Milan Italy

Chip Designer. Activity: Analyze, Testing, Design, and Developing Electronics Device


From 02/05/2009 EnL Italy, Milano

MCTS Trainer Microsoft. Activities: Trainer Microsoft on next courses:

  • • MOC 2933 Microsoft BizTalk Server Developer Training Kit
  • • MOC 2934 Microsoft BizTalk Server Administrator Training Kit
  • • MOC 2778 Writing Queries Using Microsoft SQL Server Transact-SQL
  • • MOC 10774A- Querying SQL Server
  • • MOC 10775A- Administering SQL Server Databases
  • • MOC 6462A - Windows Workflow Foundation Visual Studio
  • • MOC 10263A - Windows Workflow Foundation Visual Studio
  • • 50430B Administering Team Foundation Server 2010
  • • 20347A Enabling-and-Managing-Office-365
  • • 20486B Developing ASP.NET MVC 4 Web Applications
  • • 10958B Programming Fundamentals of Web Applications
  • • 10953A Trainer Files - HTML5 Programming
  • • 40008A Updating your Database Skills to SQL Server 2012
  • • 2778A Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  • • 20768A Developing SQL Data Models
  • • 20765A Provisioning SQL Databases
  • • 20764A Administering a SQL Database Infrastructure
  • • 20762A Developing SQL Databases
  • • 20761A Querying Data with Transact-SQL
  • • 20465C Designing a Data Solution with Microsoft SQL Server 2014
  • • 10990B Analyzing-Data-with-SQL-Server-Reporting-Services
  • • 10987A Performance Tuning and Optimizing SQL Databases
  • • 10986A Updating Your Skills to SQL Server 2016
  • • 10985A Introduction to SQL Databases
  • • 10977B Updating Your SQL Server Skills to Microsoft SQL Server 2014
  • • 10778A Implementing Data Models and Reports with SQL Server 2012
  • • 10777A Implementing a Data Warehouse with SQL Server 2012
  • • 10776A Developing SQL Server 2012 Databases
  • • 10775A Administering SQL Server 2012 Databases
  • • 10774A Querying SQL Server 2012
  • • 20497A Software Testing with Microsoft Visual Studio 2013
  • • 20483B Programming in C#
  • • 10550A Programming in Visual Basic with Visual Studio 2010
  • • 10267A Introduction to Web Development with Microsoft© Visual Studio 2010
  • • 10266A Programming in C# with Visual Studio 2010
  • • 10264A Developing Web Apps with Visual Studio 2010 (R2)
  • • 10263A Developing Communication Foundation Solutions with Visual Studio • 2010, 8,13,10
  • • 10262A Developing Windows Applications with Visual Studio 2010
  • • D365AX02 Dynamics 365 for Operations Implementation Lifecycle Tooling (2gg)
  • • D365AX01 Dynamics 365 Development (3gg)
  • • MOC80299 What's New - Technical in Microsoft Dynamics AX 2012 for Development (2gg)
  • • MOC80544 Warehouse Management System in Microsoft Dynamics AX 2012 R2 (2gg)
  • • MOC80305 Supply Chain Foundation in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80311 Service Industries in Microsoft Dynamics AX 2012 R2 (2gg)
  • • MOC80421 Sales and Marketing in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80318 Reporting in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80316 Project Essentials in Microsoft Dynamics AX 2012 R2 (2gg)
  • • MOC80308 Procurement in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80541 Payroll in Microsoft Dynamics AX 2012 R2 (2gg)
  • • MOC80338 Microsoft Dynamics AX 2012 Public Sector (2gg)
  • • MOC80309 Microsoft Dynamics AX 2012 Process Manufacturing Production and Logistics (3gg)
  • • 80423 Master Planning in Microsoft Dynamics® AX 2012 (2gg)
  • • MOC80310 Lean Manufacturing in Microsoft Dynamics AX 2012 (4gg)
  • • MOC80300 Introduction to Microsoft Dynamics AX 2012 (1gg)
  • • 80315 Intercompany Setup and Order Processing in Microsoft Dynamics® AX 2012 (2gg)
  • • MOC80422 Intercompany Setup and Order Processing in Microsoft Dynamics • AX 2012 (2gg)
  • • MOC80425 Intelligent Data Management Framework in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80221 Installation and Configuration for Microsoft Dynamics AX 2012 (3gg)
  • • MOC80538 Human Resource Management in Microsoft Dynamics AX 2012 R2 (3gg)
  • • MOC80302 Fixed Assets in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80220 Financials II in Microsoft Dynamics AX 2012 (3gg)
  • • MOC80219 Financials I in Microsoft Dynamics AX 2012 (3gg)
  • • MOC80307 Enterprise Portal Development in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80306 Distribution and Trade in Microsoft Dynamics AX 2012 (3gg)
  • • 80314 Discrete Manufacturing Basics in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80313 Development IV in Microsoft Dynamics AX 2012 (4gg)
  • • MOC80312 Development III in Microsoft Dynamics AX 2012 (3gg)
  • • MOC80304 Development II in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80303 Development I in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80339 Bill of Materials in Microsoft Dynamics AX 2012 (2gg)
  • • MOC80295 Extending Microsoft Dynamics CRM 2011 (3gg)
  • • MOC80436 C/Side Introduction in Microsoft Dynamics NAV 2013 (5gg)

Education:

2012 MCP Microsoft SQL Server 

70-461 Microsoft Certified Querying Microsoft SQL Server 2012  Microsoft Querying SQL Server 2012

70-432 Microsoft SQL Server 2008, Implementation and Maintenance 

2012 MCTS in BizTalk 2010

70-595 TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2010

2006 MCTS in BizTalk 2006 R2

70-235 Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 R2

2005 MCTS in BizTalk 2004

70-135 Developing EBiz Solutions Using Microsoft BizTalk Server 2004

2010 MCT 

Activity: Microsoft trainer for next's Microsoft Official Course (MOC)

2933 - Developing Business Process and Integration Solutions Using Microsoft BizTalk Server

2010;

2933A - Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006;

2934A - Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006;

2954C - First Look: Microsoft BizTalk Server 2006 for Developers;

2955C - First Look: Microsoft BizTalk Server 2006 for IT Professional;

50075A - BizTalk Hands-on Labs;

2010 MCP 2.0 in MS.NET

70-536 TS: Microsoft .NET Framework - Application Development Foundation

2009 MCP

70-316 Developing and Implementing Windows®-based Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET

70-315 Developing and Implementing Web Applications with Microsoft® Visual C#™ .NET and Microsoft® Visual Studio® .NET

2007 Project Management Informatics Systems Project Management course in SDA Bocconi

1988 - 1998 Master Degree, Milan- Italy

MASTER IN INFORMATION TECHNOLOGY

X Master in Information Technology inside Polytechnic of Milan (CEFRIEL-COGEFO).

Duration: 12 months.

1988 - 1997 University Degree, Palermo- Italy

GRADUATED in ELECTRONIC ENGINEERING

Vote: 106/110

Thesis Project: Analysis and development of a Control System for Automatic Brake in Logic Fuzzy using MATLAB and SIMULINK.

Technical Skills:

  • Programming Language: MS C#, MS J#, VB.NET, VC++.NET, VB 6, Borland C++, MS VB/VB.NET, MS ASP/ASP.NET, Web Services, MS COM/DCOM, JavaScript, VBScript, EcmaScript, HTML, DHTML, XML/XSL/XSD;
  • Framework .NET: 1.0, 1.1, 2.0, 3.0, 3.5, 4.0 and 4.5;
  • Database: MS SQL 7.0, MS SQL 2000, MS SQL 2005, MS SQL 2012, MS SQL 2014, MS SQL 2016, Oracle, MS Access, Relational Database;
  • Development Tools: Visual Studio 2010, 2008, 2005, 2003, 6.0;
  • Operative System: SUN Solaris, AIX, X-Windows, MS-DOS, WIN95/98/ME/CE, WIN NT

4.0/2000/XP/Vista/Windows 7, Linux, Windows 2000 Advanced Sever, Windows 2000 DataCenter Server, Windows. NET, Windows XP, Windows Vista, Windows Server 2003 Enterprise Edition, Windows 7, Windows 8.

  • Application Server: MS BizTalk 2000/2002/2004/2006 R2/2009/2010 (Expert level), RightFax 7.2/8.5 (Captaris), Commerce Server 2000/2002, MTS/COM+, MS SharePoint

2003/2007, Windows SharePoint Services 3.0 (Custom Action development), CleverPath Portal (CA Computer Associates), Rational Rose, XDE;

  • Management Tools: WinProject98/2000, GANTT and Pert Diagram;
  • EAI/ESB: BTS 2002, BTS 2004, BizTalk 2006, BizTalk 2006 R2, BizTalk 2009, BizTalk 2010, XI SAP, API Reuters;
  • Expert in communications between SAP and Microsoft environment;
  • Others: WCF, WWF, Windows Azure Platform; 

Languages:

  • Italian: native language;
  • Portuguese: good in reading and understanding, elementary on writing and speaking;
  • English: good in reading, speaking, and writing (spent 2 months in England for English course and in the USA for working)
  • French: good in reading, speaking, and writing (from 09/04/2019 in Bruxelles)