Sam Arias
Edinburgh
Summary
A highly skilled Business Intelligence (BI) and Reporting Technologies Specialist with extensive experience, specializing in SAP Analytics Cloud (SAC), Power BI, Analysis for Office (AFO), and SAP HANA. Proven expertise in developing and delivering advanced reporting solutions, automating data transformation processes, and implementing AI-driven reporting solutions that enhance business decision-making. Adept at working cross-functionally with Azure teams and data scientists to understand and fulfill complex reporting requirements. Highly proficient in training and supporting business users, ensuring the effective adoption and utilization of BI tools. Strong background in data modeling, creating interactive dashboards, and optimizing large datasets for scalable analytics. Demonstrated ability to leverage a combination of technical and interpersonal skills to deliver impactful reporting solutions in a fast-paced, global environment.
Overview
5
5
years of professional experience
Work History
BI & Reporting Technologist
Heineken UK
Edinburgh
2022.09 - Current
- Spearhead the development and optimization of advanced analytics solutions using tools such as SAP Analytics Cloud (SAC), Power BI, and Analysis for Office (AFO) to deliver actionable insights for decision-making.
- Build and optimize SAP HANA models to enable efficient and scalable analytics capabilities.
- Lead the creation of customized, interactive dashboards and advanced reports tailored to business requirements, driving strategic and operational improvements.
- Collaborate with Azure teams and data scientists to understand and fulfill complex reporting requirements, ensuring alignment with business goals.
- Implement AI-powered reporting solutions to enhance insights and predictive analytics, driving innovation in reporting processes.
- Create interactive, dynamic dashboards and customized advanced reports to address diverse business needs.
- Provide training and technical support to business users, enabling them to utilize reporting tools effectively and independently.
- Act as a key liaison between technical teams and business stakeholders, translating complex data challenges into practical solutions.
Data Engineer
Heineken UK
Edinburgh
2022.06 - 2022.08
- Designed and implemented an automated data transformation solution to streamline reporting processes and improve data accessibility.
- Developed and deployed ETL pipelines using Python, enabling efficient extraction, transformation, and loading of data from various sources.
- Automated data workflows to ensure accuracy and timeliness of reporting outputs, reducing manual intervention and increasing operational efficiency.
- Collaborated with stakeholders to define data requirements and deliver scalable solutions tailored to business needs.
- Ensured the reliability and performance of the system by implementing best practices for data pipeline optimization and error handling.
IT Technician (laptops Refurbishment)
Pure IT
Edinburgh
2021.05 - 2021.09
- Testing laptops; which includes visual inspections, functionality testing and stress testing
- Quality grading laptops against our pre-defined quality standards
- Identifying and fixing units with problems
- Replacing minor and major components in laptops
- Testing components including SSDs, hard drives and RAM
- Updating and mounting Windows images to our units
- Building units to specification for customer orders
- Maintain and repair technological equipment
- Manage software in computers and networks
- Ensure privacy and data protection
- Install well-functioning LAN/WAN and other networks
IT Technician (Software & Hardware Engineering)
ASC Technology
Manchester
2019.10 - 2021.05
- Oversee the installation of computer hardware equipment
- Test and re-test parts to ensure they work properly by identifying the issues and fixing those, or changing equipment if necessary
- Deep understanding of basic security concepts and protocols - authentication, authorization of the operating environment, Operating System, Files Systems and all Network Protocols
- Analyze information and recommend appropriate hardware to users
- Retrieve data for analysis of system capabilities
- Test work and refine processes
- Supervise technicians and other engineers during the installation phase
Education
MSc Degree - Data Science and Engineering
University of Dundee
Dundee 2021.09 - 11 2022
Bachelor of Science - Geographic Information Applied Systems (GIS)
University College of Applied Sciences
PSE 2014.09 - 2 2018
Skills
SAP Analytics Cloud (SAC): Expertise in building and deploying dashboards, reports, and predictive models
Power BI: Proficient in creating interactive dashboards, visualizing complex datasets, and delivering actionable insights
Analysis for Office (AFO): Advanced skills in integrating AFO with SAP systems for streamlined data reporting and analysis
SAP HANA: Proficient in working with SAP HANA for data modeling, reporting, and optimization of large datasets
ETL Processes: Experience in automating data extraction, transformation, and loading (ETL) processes to ensure seamless data integration
AI and Machine Learning: Implementing AI-driven reporting solutions to enhance data analysis and prediction accuracy
Azure: Familiarity with Azure services for data storage, processing, and integration with BI tools
Data Pipeline Development: Creating and managing automated data pipelines to support reporting and analytics processes
SQL & Database Management: Strong ability to query and manage relational databases, particularly in SAP and Azure environments
Data Modeling: Expertise in designing and optimizing data models for efficient querying and reporting
DAX and M Query (Power BI): Proficient in advanced data calculations and data transformation techniques using DAX and M Query
Training & Support: Strong experience in delivering training and providing ongoing support to business users, ensuring they effectively utilize BI tools
Collaboration: Proven ability to work closely with cross-functional teams (including Azure teams and data scientists) to understand reporting requirements and deliver solutions
Problem Solving: Strong analytical and problem-solving skills to address data challenges and optimize reporting processes
Communication: Ability to explain complex data concepts in a clear and concise manner to both technical and non-technical stakeholders
Project Management: Experience managing end-to-end BI projects, from requirement gathering to implementation and user adoption
Stakeholder Management: Skilled in understanding business needs and translating them into effective BI solutions
Agile Methodology: Experience working in Agile environments for iterative BI project development
Data Visualization: Expertise in presenting data insights through compelling visualizations to support strategic decision-making
Reporting Automation: Ability to streamline and automate report generation and distribution, reducing manual efforts
Timeline
BI & Reporting Technologist
Heineken UK
2022.09 - Current
Data Engineer
Heineken UK
2022.06 - 2022.08
MSc Degree - Data Science and Engineering
University of Dundee
2021.09 - 11 2022
IT Technician (laptops Refurbishment)
Pure IT
2021.05 - 2021.09
IT Technician (Software & Hardware Engineering)
ASC Technology
2019.10 - 2021.05
Bachelor of Science - Geographic Information Applied Systems (GIS)
University College of Applied Sciences
2014.09 - 2 2018