Figura professionale: Data Analyst and Engineer

Nome Cognome: G. P.Età: 41
Cellulare/Telefono: Riservato!E-mail: Riservato!
CV Allegato: Riservato!Categoria CV: Business Intelligence / Data Scientist / DWH
Sede preferita: Roma

Accesso Full al database con 29.994 CV a partire da € 5,00    ABBONATI SUBITO!



Sommario

Data Analyst and Engineer

Esperienze

Dates    From 15/02/2016 to today
Occupation or position held    Business Intelligence Analyst and Architect
Main activities and responsibilities    Design and creation of the new Data Warehouse and business data architecture, business intelligence analysis and development, requirement analysis and development of automated reporting for internal and external customers via Sap BO Infoview, data analysis and management via Microsoft SQL Server Management 2012 (using SQL and stored procedure in T-SQL), data analysis and discovery via QlikView and Power BI. Complete management of an external customer about the reporting and data sharing.
Name and address of employer    Italfondiario S.p.A., Via Mario Carucci 131, Roma
Type of business or sector    Finance
    
Dates    From 01/12/2014 to 12/02/2016
Occupation or position held    Business Intelligence Executive
Main activities and responsibilities    Innovation and automation, data architecture, Data Warehouse analysis, Business Intelligence development and analysis. Forecasting algorithms (linear and logistic regression, moving average and weighted moving average, smoothing exponential, Holt’s method, Holt’s Winter method), data management, analysis and quality via Microsoft SQL Server Management 2012 (using SQL and stored procedure in T-SQL), ETL development and management via SSIS and Talend, cubes creation via SSAS (using also MDX) and reporting via SSRS. Creation and management of the Business Intelligence front-end via QlikView, reporting and analysis, macros in Visual Basic.
Name and address of employer    GN Research S.p.A., Via di Priscilla 101, Roma
Type of business or sector    Market Research
    
Dates    From 07/01/2014 to 28/11/2014
Occupation or position held    Data Warehouse and Reporting Specialist
Main activities and responsibilities    IT to business support. Data Warehouse analysis, development and improvement, data architecture analysis and management, KPIs definition and implementation, Business Intelligence engineering and ETL via Microsoft SQL Server Management 2012 (creation of stored procedures using T-SQL), data management, analysis and quality, reporting via mail and files (txt and csv). Gather requirements from internal customers using Agile methodology, preparation of architectural and technical documentation.
Name and address of employer    Neomobile S.p.A., Via della Sierra Nevada 60, Roma
Type of business or sector    Internet / telecommunications.
    
Dates    From 02/05/2012 to 20/12/2013
Occupation or position held    Business Intelligence and Data Warehouse Engineer
Main activities and responsibilities    IT Business and Project Analysis focused on innovation and automation. Data Warehouse analysis, development and improvement, Data Marts creation, database administrator and Business Intelligence Engineering. ETL and creation of stored procedures using T-SQL via Microsoft SQL Server Management 2008, integration via Microsoft SQL Server Integration Services (SSIS), reporting via Microsoft SQL Server Reporting Services (SSRS); data management, analysis and quality (using SQL). Business process analysis and reengineering, preparation of functional and test specifications using also Agile methodology, gather requirements from external and internal customers, project management for internal customers and suppliers via Redmine tool.
Main project: production summary (orders, contract modifications and contract extensions). For every product, amount and ROE are calculated per year, month and day for every area manager about every department (one data flux for each department). 
Name and address of employer    ALD Automotive, Viale A. Gustave Eiffel 15, Roma
Type of business or sector    Automotive
    
Dates    From 30/05/2011 to 27/04/2012
Occupation or position held    Business Intelligence Analyst and Developer
Main activities and responsibilities    Project about management control for MIUR, development of management and resource control system via SAS tools. Used technologies (ETL, BI and DWH): Data Integration Studio, SAS language and SAS Macro language, Management Console, Information Map Studio, Human Capital Management, Financial Management, Strategy Management, BI Dashboard, Information Delivery Portal, SAS Add-In for Microsoft Office, Excel, Sql, MySql.
Name and address of employer    Format Business Solutions, Via C. Colombo 112, Roma
Type of business or sector    Consulting
    
Dates    From 11/10/2010 to 18/05/2011
Occupation or position held    Business Intelligence Analyst and Developer
Main activities and responsibilities    Data management and development of demo and prototypes. Some project: 
•    Manufacturing project: management and analysis of balance sheet, calculating the gap of every component. Used technologies: Enterprise Guide, Management Console, Information Map Studio, stored procedures, report, SQL, SAS language and SAS Macro language, Web Report Studio, Information Delivery Portal, Olap Cube Studio, html, css, jsp.
•    Manufacturing project: economic analysis of some activities with risk and forecast. Used technologies: Enterprise Guide, Management Console, stored procedures, SQL, SAS language and SAS Macro language.
•    Telco project: analysis about satisfaction of customer, via social network, among more competitors. Used technologies: Web Report Studio, Enterprise Guide, Management Console, Information Delivery Portal, BI Dashboard, Information Map Studio, report.
•    Manufacturing project: forecast model on yearly sales to attain on activities degree. Used technologies: Enterprise Guide, Management Console, Information Map Studio, stored procedures, report, SQL, SAS language.
Used instruments: Web Report Studio, Data Integration Studio, Enterprise Guide, Management Console, Information Delivery Portal, Information Map Studio, Add-In for Microsoft Office, BI Dashboard, Data Warehouse via Olap Cube Studio and Viewer, creation of Stored Procedures and report, SAS language and macro language (using SAS 9.2).
Name and address of employer    SAS Institute S.r.l. (Italy), Via S. Giovanni della Croce 3, Roma
Type of business or sector    Business Intelligence
    
Education and training    
    
Dates    From 29/08/2016 to today
Title of qualification awarded    Web Analytics
Name and type of organisation providing education and training    eMarketing Institute
Level in national or international classification    Certification
    
Title of qualification awarded    Scrum Fundamentals Certified
Name and type of organisation providing education and training    SCRUMstudy
Level in national or international classification    Certification
    
Dates    From 04/05/2015 to today
Title of qualification awarded    Automated Visual Software Analytics
Name and type of organisation providing education and training    Hasso-Plattner-Institute
Level in national or international classification    Certification
    
Dates    From 20/12/2013 to today
Title of qualification awarded    Business Process Modelling and Analysis
Name and type of organisation providing education and training    Hasso-Plattner-Institute
Level in national or international classification    Certification
    
Dates    From 23/10/2013 to today
Title of qualification awarded    In-Memory Data Management
Name and type of organisation providing education and training    Hasso-Plattner-Institute
Level in national or international classification    Certification
    
Dates    02/05/2011
Title of qualification awarded    Qualification to practice the profession of Engineer
Name and type of organisation providing education and training    Università degli Studi Roma Tre
    
Dates    From 29/06/2010 to 13/08/2010
Title of qualification awarded    Attendance of English course, intermediate and upper-intermediate
Name and type of organisation providing education and training    Oxford House College, London
Level in national or international classification    Level B1, B2
    
Dates    From 01/10/2007 to 27/05/2010
Title of qualification awarded    Master degree in Management and Automation Engineering, attained on 27/05/2010 (academic year 2008/2009), in 2 academic years, with mark 106/110. Thesis’s title: “Representation of Critical Infrastructures via Coloured Fuzzy Petri Nets”, about the European project MICIE on Critical Infrastructures, building the Java simulator FCPN-SIM.
Principal subjects/occupational skills covered    Project Management, Management of Informative Systems, Quality’s Theory and Technical, Support Methods to Management Decision, Fuzzy Control, Elements of Encryption.
Name and type of organisation providing education and training    Università degli Studi Roma Tre.
    
Dates    From 10/02/2009 to 27/05/2009
Title of qualification awarded    Spanish course.
Name and type of organisation providing education and training    Universidad Politecnica de Valencia.
Level in national or international classification    Level A2
    
Dates    From 01/02/2009 to 21/07/2009
Title of qualification awarded    Erasmus programme
Name and type of organisation providing education and training    Universidad Politecnica de Valencia, faculty of Industrial Engineering.
    
Dates    13/06/2008
Title of qualification awarded    Certificate of English language Cambridge, level Ket.
Name and type of organisation providing education and training    British School with centre at Seraphicum school in Rome.
Level in national or international classification    Level A2
    
Dates    From 01/10/2002 to 23/05/2007
Title of qualification awarded    Bachelor's degree in Computer Science Engineering, attained on 23/05/2007 (academic year 2005/2006), in 4 years, with mark 93/110. Thesis’s title: “Re-routing techniques for the problem of urban traffic”. Selected curriculum: Automation Systems.
Principal subjects/occupational skills covered    Project Management, Data Base, Java and Object Oriented Programming, Operational Research, Network and Automation’s System, Computers’ Network and Industrial Automation.
Name and type of organisation providing education and training    Università degli Studi Roma Tre, School of Computer Science Engineering
    
Dates    From 1997 to 2002 (in 5 years)
Title of qualification awarded    Diploma of Liceo Scientifico P.N.I. (Information National Plan), with mark 80/100.
Name and type of organisation providing education and training    Liceo Scientifico Statale Aristotele (public school) in Rome, Italy.
    
Personal skills and competences    
    
Mother tongue    Italian
    
Other language    English, Spanish, Portuguese
Self-assessment        Understanding    Speaking    Writing
European level (*)        Listening    Reading    Spoken interaction    Spoken production    
Language English        B1    intermediate    B2    intermediate    B2    intermediate    B1    intermediate    B2    intermediate
Language Spanish        B2    intermediate    C1    high    C1    high    C1    high    B2    intermediate
Language Portuguese        A1    base    A2    base    A1    base    A1    base    A1    base
    (*) Common European Framework of Reference for Languages
    
Social skills and competences    Admirable capacity of interrelationship with the audience and other people, work in group and adaptableness.
    
Organisational skills and competences    Good decisional capacity and to organize and manage groups of work. Admirable capacity to plan personal time. Determined, hard worker and precise, with an great intellectual curiosity.
    
Technical skills and competences    Informatics large scale skills, competence of management, check and optimization.
    
Computer skills and competences    •    Operative Systems: DOS, Windows’ ambient (98 SE, 2000, Xp, Vista, 7), a basic knowledge of Linux (Ubuntu and Kubuntu)
•    Software/tools: Microsoft Office (2000, Xp, 2003, 2007, 2010), with Microsoft Word, Excel, Power Point, Access, Outlook, Front Page and Visio, Redmine.
•    Programming languages: Java, JavaScript (basic), Python (basic), T-SQL, SQL, SAS, MDX, HTML, CSS, VBA 
•    Platforms: Eclipse (IDE), Borland and TextPad, SAS platform, Microsoft SQL Server 2008 and 2012 (Management, SSIS, SSAS and SSRS, Power BI), QlikView, Sap BO, MySQL, Talend Open Studio.
•    Business process analysis and reengineering
•    Business Intelligence (analysis and development) and ETL
•    Data Warehousing
•    Reporting and Data Visualization
•    Forecasting
•    Data management, quality and analysis, KPIs
•    Agile methodology
    
Artistic skills and competences    Photography at amateur level, amateur computer graphics.
    
Other skills and competences    •    Practice sport, in particular football and fitness (grade of black swifter first dan in the martial art Shorinji Kempo).
•    Travelling and knowing foreign cultures.
•    Internet and innovation
•    Attractiveness in the manual creation and making.
    
Driving licence    Driving license class B, attained on 22/12/2001.
    

124 total views, 1 today