003**-***-***-*** acd5ey@r.postjobfree.com

Mattia Rosa Dublin, Ireland http://ie.linkedin.com/in/mattiarosa01

IN BRIEF

Data Magician with 10 years long experience in software development and data-related roles, working in

different countries and industries.

Experienced working with all levels, managing peer engineers and taking the lead “where angels fear to tread”.

Reliable and inventive, I always find a shortcut and resolve the challenge.

WORK EXPERIENCE

Senior Data Integration Engineer

Role

Smartbox, Dublin From 2012-10-08

Where, When

ETL, T-SQL, Agile, SSIS, .NET, Jira

Keywords

Reduced the number of incidents by 99% in 12 months.

Achievements

Removed unnecessary processes by 10% and speeded up 50%+ of the data flows.

Responsible for the key back-office SQL warehouse serving the websites, ERP and stock

systems. Took over an infrastructure developed in 5+ years with practically no

documentation, carrying over a datacentre migration from 2005/2008 to 2012, fixing and

improving 30+ data flows in SSIS and T-SQL connecting all platforms to the main core of

Description the business (customer service, CRM, partners and retailers, stock & orders, finance).

I’ve been able to analyse and re-engineered most of the company’s workflows, reducing

sales impacting events to virtually none in less than a year.

Liaising with the business to automate manual processes and integrated with 3rd party

applications. Managing 2 junior engineers.

Data Analyst

Role

AON, Dublin From 2011-10-10 To 2012-09-28

Where, When

Implemented two new streams.

Automated time-consuming operational tasks.

Achievements

Implemented KPI report on monthly data

Data Mining, ETL, T-SQL, PL-SQL, Tableau, KPIs

Keywords

Responsible for the design, development and monitoring of ETL data streams from 30

different countries across the globe into our centralized DWH, liaising with local and

Description central offices to report on key business functions to both internal and external

stakeholders. Analysis of the collected data and KPIs targeting potential improvements

area.

Sales Support Coordinator

Role

Service Source, Dublin From 2010-04-10 To 2011-09-29

Where, When

BO, Data Mining, VBA Automation, ETL, Excel, Access, VBA, SQL

Keywords

Revolutionized all data flows, improving quality and frequency of reports and KPIs.

Achievements

Automated 80% of the team’s operational work-time.

Responsible for data analysis and ETL on external clients’ warehouse, reporting to

Management, Sales and Operations. Creation and analysis of individuals and global KPIs,

Description reporting to the Sales Manager. I have been able to centralize and automate the

processing and data cleansing, reducing the team’s core ETL operational cost by 99%.

Organized and lead Excel workshops, won the Employee of the Month award.

Curriculum Vitae Mattia Rosa Page 1 of 2

Management Information Developer

Role

Barclays GRB, Dublin From 2007-09-04 To 2010-04-09

Where, When

Excel, Access, VBA, SQL, ADO, RDBMS, Stats, KPIs, Workloads

Keywords

Developed (with full life-cycle) 3 new tools for data collection and management.

Achievements

Automated 40% of the team’s operational work-time.

Liaising with fellow Analysts and Management to create and improve existing reports,

working on ETL processes from a number of different data sources. Successfully

Description automating the team’s tools reducing the manual workload to 50%. Designed and

developed Excel macros to organize and centralize data flows, replacing paper records

decreasing time-consuming mistakes and administration costs.

IT Developer

Role

Winit srl, Trento From 2004-08-04 To 2007-08-31

Where, When

VB6, VBA, .Net 2.0, Excel, Access, C, SQL, RDBMS

Keywords

Developed a mobile version of the core application (on Windows Mobile 6).

Achievements

Developed a firmware for an embedded RFID reader.

Develop, customize and support existing applications written in VB6, VBA and VB.NET

(ETL, databases and client’s customized programs). Developed from scratches firmware

Description

for embedded RFID reader devices in pure C. Porting of an ETL application into a mobile

version, using Visual Studio 2005 with .Net 2.0 and mySQL.

EDUCATION

Engineering Diploma as IT Developer

Qualification

“Guglielmo Marconi” College (Rovereto, Italy) From 1998 To 2004

Where, When

Hardware and Software engineering (electronic, networks, OSI, office automation, DB,

Subjects

Object-oriented programming), Math, Statistics, Electronics, Physics, Chemistry

SKILLSET and OTHERS

MS Office Package VB6 (COM, ADO) VBA

MS Visual Studio .Net 2.0 .Net VB, C#

IDEs MS SQL Server Languages C++ C

Borland C++ Builder Object Pascal Assembler

Visual Basic 6 T-SQL, PL-SQL SAS

Trainings Languages Hobbies Sports

SAS (Macro & Advanced) Italian (Native) IT & Computer games table tennis

Intensive Java English (Fluent) Sci-Fi and Fantasy badminton

Intensive .Net 2.0 German (Learner) Motorbike pool

ECDL Spanish (Learner) Violin golf & tennis

Curriculum Vitae Mattia Rosa Page 2 of 2

Contact this candidate