Guillem Maya

Business Controller | BI Consultant | Data Analyst


About me

Young, eager to learn and with special devotion for technology and computer science. I am looking forward to develop my professional career in the field of data analytics with a deep understanding of finance and business processes. I aim to advance within a constant learning environment and be able to implement new systems that drive companies toward a greater efficient.



Experience

Business Intelligence Developer
Kingspan Insulation | feb 24 - present

Girona

Description

Working on the IT team alongside Agility ERP software developers, we design a customized solution for many factories around the world. My tasks are focused on data analytics with a deep understanding of all business processes. Managing data pipelines using T-SQL queries and ETL techniques supported by stored procedures and job schedules. Developing advanced analytical models and reporting in SSAS, Power BI, SSRS, and Report Builder. Providing actionable insights to business users in order to facilitate an informed decision-making and driving the company to an organizational efficiency model.

Business Data Analyst
Costa Brava Foods | sep 23 - feb 24

Girona

Description

Defining workflows in Navision with the primary objective of optimizing processes and guarantee our data quality. Proficiently extracting and refining raw data through SQL queries and procedures. Orchestration and managing data flows. Developing advanced analytical models in Power BI and calculating business measures using DAX. Uncovering intricate data patterns and empowering the company to understand better the business. Defining reports and showing insights to enhance decision-making.

Commercial Controller
INOXPA | mar 22 - sep 23

Girona

Description

Report to CCO & CFO, support to the 17 commercial delegations in the world, follow-up of industrial and commercial margins, review of exchange rates and monitoring of discounts, preparation of the company’s budget and strategic plan, review of business procedures in Microsoft Dynamics AX, develop of Power BI as main reporting tool.

Business Controller
Mediamarkt Iberia | mar 20 - jun 20

Barcelona

Description

Management control of the whole network shops, monthly reporting of KPI metrics by store, budgeting and measurement of the company target, performing strategic planning supported by business forecast models, analysis of profitability for promotions and commercial campaigns, carrying out periodically financial audits in order to quality control policies and procedures.

Commercial Controller
Haribo Spain | jun 16 - mar 20

Girona

Description

Calculation of the accrual expenses according to commercial agreements, forecast of the annual budget, development of TM1 solutions in IBM Cognos BI, reporting NNSales to the Holding Group, design consistent business control models for financial accounting, pricing and promotions strategy, analysis of logistics projects, reconciliation of intercompany sales for the Konzernplan.



Education

Universidad Autónoma de Barcelona | Barcelona, Spain
Master’s degree in education and teacher training, Mathematics | Sept 20 - June 21

Tecnológico de Monterrey | Guadalajara, Mexico
Santander Bank Ibero-America Scholarship | jan 17 - jun 17

Universitat de Girona | Girona, Spain
Bachelor’s degree in Business Administration | sep 13 - jun 17



Language

Catalan
Mother tongue

Spanish
Mother tongue

English
Upper Intermediate
B2 (MECR)

Skills

Business Management
MS Office, SAP, SAP BO, AS/400, MS Dynamics AX, Advanced business user knowledge.

Data Analytics
Microsoft SQL Server, SSIS, SSAS, VBA, SPSS Statistics, IBM Cognos , Power BI, SSRS, Tableau, QlickView, SQL, DAX, R and Python.


Download pdf

Back to top