I am a skilled Business Intelligence/Data Warehousing Technical Architect with competencies covering the justification; design; development;
delivery and exploitation of Business Intelligence and Data Warehousing.
I have solid experience in data warehouse design in particular the supporting architecture; managing the build of the main components, delivery of effective working solutions,
and assisting end users in making the most of their assets.
Although my primary discipline is technical, I am equally at ease explaining technical concepts to the business management
as I am explaining business requirement to the technical staff.
Experience gained in a number of industries including, Energy, Telecoms, Finance and Medical.
I had the opportunity to face these technologies with a critical approach, as tester and as a test manager,
moving to the implementation phase and production, and then managing the functional aspects.
I have been following the life cycle of the software, from the abstract idea to final inspection.
Currently my role is a hybrid of these activities. I am responsible for the requirements while ensuring the implementation is effective efficient and meets the requirements.
Senior Data Engineer @ From April 2015 to Present (9 months) United KingdomData Consultant @ Data Consultant working closely on the client delivery and big projects with leading organisation.
Mainly with B2B firms, from global business to regional market specialists, across a number of verticals including Professional Services, Financial Services, Technology & Telecoms, Healthcare and the Public Sector.
One of the main activity is gathering requirement from heads of the finance and marketing department and drive them to the best solution for their data with dashboards or dynamics reports. From December 2014 to April 2015 (5 months) London, United KingdomSenior BI Consultant @ From May 2014 to November 2014 (7 months) London, United KingdomProduct Expert @ BI Product Expert for SAP BO XI 3.X, SAP BI Platform (SAP BI 4.X),
DWH Projects mainly for Finance Customer (Banking, Financial Services providers) From April 2013 to May 2014 (1 year 2 months) Milan Area, ItalyBusiness Intelligence Expert @ • Functional and technical analisys in BI area.
• Development with ETL and datamining SAP products.
• SAP Business Objects Integrator / SAP Business Objects DataServices XI 3.2
• Universes and reports architect and designer Business Object XI 3.2
• Dashboards designer and developer in Xcelsius 2008
• Architect and maintenance responsible for Glassfish portal From August 2010 to April 2013 (2 years 9 months) Designer Senior @ April 2010 – August 2010
Information technology consultant – Oracle
Eni customer (Exploration & Production) - System analysis and development – Energy area
• PL /SQL development of scripts and stored procedures in Oracle loading data and process automation Performance test and tuning in oracle 11g
Data Management Department of the Exploration & Production division.
My role was to ensure IT support in the management of technical scientific data useful to the upstream operations in oil&gas industry.
Projects in the scope of Facilities Engineering and Production Operations.
The IT system I was involved in are:
- Plant Information Management System
- Production Data Management System
- OPEX Forecasting System (with Monte Carlo Simulation)
- Production Budget Planning System (with Monte Carlo Simulation)
February 2010 – March 2010
Information technology consultant - Report specialist
Eni customer (Exploration & Production) – ICT – Energy area
- Monitoring Operations Retail: development of a system of state control of the alignment of the data and the behavior of information flows exchanged between them
- Business Intelligence Credit: development of a new model of analysis (BI) specific to the context, the use of which allows the units of competence to define new strategies and the Credit Policy.
• Universes and reports designer Business Object XI 3.1 for datawarehouse on oracle 10G platform
December 2009 – January 2010
Information technology consultant – Oracle specialist
Banca Intesa customer (System analysis and development – Banking area)
• PL /SQL developer and script and stored procedure optimization in Oracle for data loading and creation of a new datawarehouse. From November 2004 to August 2010 (5 years 10 months) Information technology consultant @ October 2009 – December 2009
Information technology consultant – Oracle specialist
Eni customer (Exploration & Production) - System analysis and development – Energy area
• PL /SQL developer and script and stored procedure optimization in Oracle
• Systems migration from Visual Basic (Access application) to Oracle
May 2009 – October 2009
Information technology consultant - test manager and process revisor
COOP Voce customer - System analysis and development – Telco area
• Designer and creator of functional and process test case on AMDOCS platform for MVNO (COOP Voce client) on all systems involved (Dealer Station, CRM, IVR, DWH).
• Test e check inferfaces vs external systems (SSB, Dealer station, Telecom italia) by SS7,USSD,XML on http protocols
• Process and billing test, query analysis and creations for investigation on db (SQL Server).
• Functional requirement revisor for MVNO according to the demand of business and customer.
November 2007 – May 2009
IBM/ Vodafone customer (System analysis and development – Telco area)
• Functional testing in Oracle 10G environment and migration to 11G(IBM/ Vodafone customer DWH Solution), review scripts,packages/procedure installation, integration and acceptance test( Test and PreProduction systems) in datawarehouse CKM area(Customer Knowledge Management), for back end (PL/SQL – Oracle, Oracle warehouse builder), and front end (Microstrategy)
• Post-deploy activites(Functional and dimensional checks)
June 2006 – November 2007
Information technology consultant
Value Team S.P.A (ex ETNOTEAM S.P.A.) - Vodafone customer (System analysis and development – Telco area)
• Test integration and functionals activities on all Vodafone systems (Validation & Delivery environment).
• Designer and planner test of web/java based products and marketing promotions on 3° generation mobiles.
• Data flow test on application platforms used (Dealer Station, CRM, IVR, DWH).
• Documents and specifications creation. From November 2004 to August 2010 (5 years 10 months) Information technology consultant @ March 2005 – June 2006
Information technology consultant
Vodafone customer (System analysis and development – Telco area)
• Functional testing and PL/SQL architectural analysis on Oracle 9i e 10G environment ( Vodafone customer DWH Solution), review scripts ,packages/procedure installations, integration test and acceptance test designer and planner (Test and Preproduction systems) in datawarehouse area
• Post-deploy activities(Functional processes controls, dimensional and performance checks)
November 2004 - March 2005
Information technology consultant
System analysis and development
• JAVA application development based on GAIA and DB2 application server (customer Inet)
• PL / SQL functional and architectural development and testing in Oracle ambient (customer Vodafone)
• Functional testing and architectural analysis, review scripts, package/procedure installation, integration and acceptance development test (test and pre-production systems) in datawarehouse system.
• Post-deploy activities (functional, dimensional, performance tests)
• Integration and functional activity tests on all Vodafone systems in Validation&Delivery ambient.
• Planning/writing up/execution of tests on web/java products and commercial promotion on third generation and other mobiles.
• Data flow control on relevant application platforms.
• Creation of documents relevant to the performed activities.
• Tools: MercuryTestDirector, MercuryQualityCenter OCA, Toad, Vodafone Mobile Connect
• Languages: PL/SQL, scripts Unix ksh in Oracle 9i ambient (customer Vodafone From November 2004 to June 2006 (1 year 8 months) Analyst programmer DATAWAREHOUSE-CRM @ • Transfer and management TSO – UNIX data
• DataBase analysis and project From November 2003 to November 2004 (1 year 1 month) Junior consultant @ • Activity on project SAP Enterprise Portal (customer Pirelli)
Type of business or sector System analysis and development – Industry area From June 2003 to November 2003 (6 months)
Computer Engineering and Systems Science, Università degli Studi di Pavia @ Università degli Studi di Pavia From 1997 to 2003 Diploma di maturità classica, Liceo Classico Pietro Verri @ Liceo Classico Pietro Verri Ottavio Vicini is skilled in: Business Intelligence, Data Warehousing, Oracle, Microsoft SQL Server, PL/SQL, Databases, SAP BI, ETL, Business Objects, Testing, XML, Integration, Data Migration, SAP ERP, Data Mining