Profile:

• Have worked on all phases of data warehouse development lifecycle, from gathering requirements to, implementation, support, coordinating of the team and testing. Excellent technical and analytical skills with clear understanding of designs of the DWH goals.
• A strong leader with experience leading developers and advising technical teams on ETL and DWH best practices. Always identify solutions to decrease the projects? costs applying experience, creativeness and strong background in the following core competencies

Tools: 

• Jira
• Gitlab
• Erwin
• Designer 2000
• Metaedit
• Power Design
• Winscp (FTP Protocol)
• Versioning CVS
• VSS

Methodologies:

• UML
• Entity Relationship
• Data Flow Diagram

SELECT PROJECTS

• Data Migration of a Legacy System Datacom-ERP to a Relational Database: Framework architect for the control of the jobs mapping; conducted unit and integration tests; managed automation of data control. (Calyps SA)
• Build, Development & Modeling of Multi-Site (30 banks) DWH (Banking): Framework architect for the control of the jobs mapping; Database modelling; provided support for production issues; provided support and tutoring for members of other groups on ETL and DB issues. (Calyps SA, Client: Credit Agricole)
• DWH project: Goal: to rebuild the flows that loaded the dimensions and fact tables and re-do the architecture of the ETL flows. Technical Analyst and ETL Developer. (Buongiorno Spa)
• Data Migration project Wrote technical specifications for the ETL?s developers, gathering the requirements from the documents of SME. Technical Analyst. (IBM)
• Build of Entire DWH (Farm Machinery): Build of the entire Datawarehouse of Iveco and New Holland (Farm machinery), the core of the DWH was on sales & marketing and supply chain; involved in every level: Participated at the modelling of the DWH following Star Schema and Snowflake with help of a case tool. Designed the entire architecture of the ETL process, foreseeing an ?intelligent? restarting in case of abort. Created detailed process flow designs and drafts high-level SOPs. Developed an ETL process to automate the generation of ETL loadings. Participated in design sessions where decisions are made involving the transformation from source (SAP and XML files) to target table of RDBMS. Responsible of the developers? team, the developing of the data extracts and loading routine, managing and compiling documentation for all ETL processes. Tuned and improved the loading performance data warehouse to ensure successful completion and speed. This project was to prepare the data for the budget Elica?s Area Manager. Conducted requirement gathering sessions with the business users and generated the functional specs with a team of business analysts. Developed various reusable transformations like (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) using Informatica Designer and processing tasks using Workflow Manager in order to load the data in Dimension and Fact Tables and to allow Cognos planning present the budget data; the project lasted 4 months. (Icteam Spa)
• Internal Business of IBM: This project involved the collection of info about of the machines IBM rented its clients. Gathered the IBM?s requirements, wrote the technical specifications and also developed tasks. Participated in the data modeling sessions to understand the data model and provided inputs based on the existing data to ensure the designed model is technically feasible. Tutor for beginners. (IBM)
• Mediation Project of Vodafone: Conducted the session for collecting CDR tables. Designed the template job for extracting the data and create the dispatcher. Designed the architecture of the workflow of the mediation system. Also, checked the team applied the best practice developing the jobs. (Reply Spa)
• Retail Datawarehouse Project of Coop Italy: Designed the jobs to load data mart to plan sales promotions, improve merchandise assortments by store, improve vendor tracking, streamline budgeting. (Sopra Group)
• Data Mart Requirements: Conducted session to gather requirements for a huge Italian utility company, concerning data mart for the marketing; designed the tables of the DWH for this marketing part, like data-modeler; also developed the jobs loaded the fact and dimension table in the start-schema allowing to the company the strategic data mining about customer satisfaction. (Sopra Group, 2005)
• DWH Design & Development: Design and development of DWH for TNT TRACO (Atos Origin SpA)
• New Production and Delivery System: Design and development of a new production and delivery system for Danone SpA (Atos Origin SpA)
• DWH Design & Development: Design and development of a new financial and logistic DWH for Galbani SpA (Atos Origin SpA)
• New System Design & Development: Design and development of a new system to collect energy data in real time for Dalmine SpA. (Atos Origin SpA)
• Reengineering of a DWH: Reengineering of the DWH for the European Community. (Atos Origin SpA)
• Design & Implementation of a Loading System: Design and implementation of a loading system for invoicing XML formatted for Unilever SpA. (Atos Origin SpA)
• Design & Development of a New Loading System: Design and development of a new loading system for Banca San Paolo IMI. (Atos Origin SpA)
• New Data Collection System (telecom): Design and implementation of a new data collection system (?Mediation?) for Vodafone SpA. (Atos Origin SpA)
• DWH Implementation (A Cruise Ship): Design and implementation of the DWH for Costa Crociere. (Atos Origin SpA)