Andrea Cappelli Email & Phone Number

Bioggio, Ch

Build a team of data passionate professionals in order to extract value from our mountains of data, giving voice to data to influence corporate strategy in order to reduce costs, complexity and risks.Define the vision, roadmap, and end to end solution leveraging on best in class technologies to provide a single version of truth, to guarantee timeless data availability,a global view of company data, an easy access to data and ensure users have reliable data speaking the same data language, through effective data management and data governance practice.

Bioggio, Ch

I’m managing a team of 5 people and coordinating external consultants for BACK END and FRONT END activities.I’m accountable for EMEA DWH and all Microstrategy Reports.I work closely with business divisions like Finance, Marketing and CRM, Ecommerce, Buying Planning and Allocation, Logistic, Supply Chain to ensure a complete structure of company reports, scrutinize, evaluate and solve business requests ensuring data quality and accuracy.Directly on indirectly involved on all strategic company projects

Bioggio, Ch

• Acquire Business Requirement (Wholesales and Retail)• Information sourcing and gap analysis for new implementation• Address Business Objects developer to produce right and performing universe.• Managing DWH load process and procedure • Migration of Corporate Retail reports from Business Objects to Microstrategy

San Diego, California, Us

Working in the Commercial Data warehouse project for an Airline company as Data warehouse architect. I’ve followed the following phases:• Business requirement analysis• Information sourcing • Data model: Logical and physical implementation using ER-Win tool.• Data mapping and Gap analysis • ETL procedures analysis• Creation and application case test• To coordinate the off shore Pakistan Java team• To coordinate ETL team• To coordinate the BI team• Client Interface• Project Manager support for the valuation and planning activity During this experience I have acquired a good knowledge about Ascential Data Stage and Business Object XI r2 Tools.Integrate heterogeneous data coming from various RDBMS like Oracle, SQL Server and DB2I have understood the business requirements and coordinate the realization of adequate reports

San Diego, California, Us

Consultancy experiences and problem solving in Teradata environment in Finance, Retail and Telco

San Diego, California, Us

Analytic CRM implementation, my role was ETL developer using SQL shell script on mainframe enviroment

San Diego, California, Us

Analyse and developing ETL processes with Hummingbird Genio software in a Teradata datawarehouse

San Diego, California, Us

I worked with Teradata and the Utilities in an enterprise datawarehouse environment.I have acquired very good knowledge in Database Administration:• Database Monitoring• Capacity planning• Security policies• Physical implementation• Archive and Restore • Performance tuning