João Cruz

Data Warehouse for Zarco STC (Banco de Portugal Reporting):

• Responsible for Data requirements analysis
• Responsible for Data Design
• Responsible for Data modeling (following Kimball's Approach)
• Responsible for ETL (Extraction, Transformation, and Loading)
• Responsible for Data Quality
• Responsible for Data testing
• Responsible for Data delivery

Data Warehouse for DoValue Portugal:

• Responsible for data requirements gathering
• Responsible for business analysis
• Responsible for data warehouse design
• Responsible for data warehouse modeling (following Kimball's Approach)
• Responsible for ETL (Extraction, Transformation, and Loading)
• Responsible for data testing
• Responsible for data delivery
• Responsible for documentation

Reporting Solution:

• Responsible for data requirements analysis.
• Responsible for data design.
• Responsible for data modeling.
• Responsible for ETL (Extraction, Transformation, and Loading).
• Responsible for data testing.
• Responsible for data delivery.
• Handling reporting tasks.

• Data and model analysis and evolutionary implementation solutions of business models
• Extraction and integration of data from data warehouse and current core operational system into new core operational system.

• Participated in requirements meetings to understand business needs.
• Gathered information on operational reporting needs from local stakeholders and group stakeholders.
• Identified operational reports in use and those to be migrated.
• Presented findings to group stakeholders.
• Determined the root cause of data quality errors and recommended long-term solutions.
• Promoted workaround solutions for addressing data quality issues in the Data Warehouse.

• Responsible for data requirements gathering.
• Conducted data requirements analysis.
• Designed data warehouse
• Modeled data warehouse, following the Kimball's Approach.
• Managed the ETL (Extraction, Transformation, and Loading) process.
• Conducted data testing.
• Oversaw data delivery.
• Provided documentation for the project.

• Responsible for data requirements gathering.
• Conducted data requirements analysis.
• Designed the data warehouse.
• Modeled the data warehouse, following the Kimball's Approach.
• Managed the ETL (Extraction, Transformation, and Loading) process.
• Provided documentation for the project.

• Conducted data requirements analysis.
• Modeled the data warehouse, following the Kimball's Approach.
• Managed the ETL (Extraction, Transformation, and Loading) process.
• Conducted data testing.

• Team Management
• Data Requirements Analysis
• Data Design
• Data Modeling (Kimball's Approach)
• ETL (Extraction, Transformation, and Loading)
• Data Testing
• Data Delivery

• Team Management
• Data Requirements Analysis
• Data Design
• Data Modeling (Kimball's Approach)
• ETL (Extraction, Transformation, and Loading)
• Data Testing
• Data Delivery
• Reporting
• Reporting User Training