About Ricardo Alfredo
Spanish
Native or bilingual
Experience
- DistriplacData Architect Client - DistriplacARCHITECTURE AND URBAN PLANNINGFebruary 2025 - Today (1 year and 4 months)Madrid, Spain Migration of SSAS cubes from version 2016 to 2022. Source data comes from SAP and is stored in Snowflake, using Azure Data Factory for integration. From Snowflake, data is modeled following a dimensional schema, composed of fact and dimension tables, implemented in SQL Server. Table processing is performed directly in SQL Server, optimizing their performance and structure. Information visualization is carried out using pivot tables in Excel and interactive dashboards in Qlik Sense.
- YodeymaDBA - BI - Project ManagementAugust 2023 - February 2025 (1 year and 6 months)Madrid, SpainDesign and lead the Business Intelligence strategy aligned with business objectives. Plan, coordinate, and supervise BI projects, ensuring compliance with deadlines.• Establish data governance policies, ensuring the integrity, accuracy, security, and confidentiality of information. Development of ETLs with Data Factory Power BI SQL Azure Instance Transac-SQL Python Plan and track assigned projects. Gather business requirements for project conceptualization. Manage the team responsible for achieving project objectives. Azure / .NET / API Development and Implementation Swagger Yodeyma Logistics Swagger-UI
- CEPSASQL Server DBA - CEPSA ClientMay 2022 - August 2023 (1 year and 3 months)Madrid, SpainSQL Server Performance Optimization:Administration to improve server performance, availability, and efficiency through query analysis, index tuning, and system resource optimization.SQL Server Migration with dbatools:Planning and execution of database migration processes using dbatools, ensuring data integrity, minimal service interruption, and post-migration optimization.PowerShell Task Automation:Development of PowerShell scripts to automate SQL Server administration tasks, including instance migration, backup management, performance monitoring, and security configuration.T-SQL (Transact-SQL) Programming:Design and optimization of stored procedures, functions, triggers, and complex queries in Transact-SQL, focused on improving application performance and data integrity.SSAS Infrastructure Migration Identify SSAS Mode: Multidimensional / Tabular Backup SSAS Database (select a location and save the ".abf" file) Migrate Configuration and Roles Review connections and data sources Verify that cubes/models process correctly. Execute MDX or DAX queries to test performance Ensure reports and tools (Power BI, Excel) are working.
Recommendations
Be the first to recommend Ricardo Alfredo
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Computer EngineeringUNIVERSIDAD "SAN IGNACIO DE LOYOLA"1999Ingeniería Informática
- Technician in Computing and InformaticsINSTITUTO SUPERIOR TECNOLOGICO "SAN IGNACIO DE LOYOLA"1996Técnico en Computación e Informática