M
Mateusz Rek
About
Detail
Senior Consultant
Masovian Voivodeship, Poland
Résumé
Jobs
verified_user
0% verified
Full Stack Analyst, Revenue IntelligenceAffirmMay 2024 - Current (2 years 6 months)• Partnering with Revenue, Sales, Engineering, and Data teams to turn complex business questions into scalable analytical solutions.
• Designing and maintaining trusted data products, semantic models, and dashboards that support strategic decision-making across the Revenue organization.
• Building and optimizing dbt models, SQL transformations, and reporting pipelines on Snowflake to improve data quality, accessibility, and operational efficiency.
• Analyzing merchant, checkout, payment, and transaction data across products to uncover growth opportunities and improve business performance.
• Driving data quality initiatives by identifying inconsistencies, improving data governance, and collaborating with Operations to enh- Senior ConsultantMicroStrategyFeb 2023 - May 2024 (1 year 4 months)Schwarz IT/Lidl – MSTR & Snowflake Developer (Germany - Retail)
• End-to-end product development in MicroStrategy and Snowflake
• Data Mart development in Snowflake
• ETL from DWH to Data Mart.
• Schema, report and dashboard development. Fixes in already existing BI applications.
• DEV/QA/PROD development life-cycle, both in backend and frontend
• Adapting schema to data model to enhance report performance and to ensure data correctness
• Work in Azure DevOps and git - ConsultantMicroStrategyMay 2021 - Feb 2023 (1 year 10 months)Lamborghini – BI Applications Development (Italy - Automotive)
• Development from scratch of two BI Applications.
• Brand-new dashboard development for Lamborghini Heroes launch. Highly interactive with complex statistical calculations, rankings and security filters.
• Commercial Dashboard development with over 30 KPIs.
Optum Insight – Product Development (USA - Healthcare)
• Developing new analytics platform releases.
• Designing ETL jobs in Scala via Intellij
• Introducing map-based dashboards from scratch up to production
• Adjusting reports’ SQLs to enhance performance and ensure data correctness
• Work in DEV/QA/PROD Development life cycle.
• Performance optimization on Amazon Red - Associate ConsultantMicroStrategyDec 2020 - Apr 2021 (5 months)Carrefour – On-premise to Big Query Migration (Italy - Retail)
• Work on MicroStrategy with Google Big Query integration
• Enabled High Throughput API to GBQ in ODBC driver
MD – Predictive Analytics (Italy - Retail)
• Deployed brand new data science application to production
• Building basket association analysis in python with hypercard development
Dimar – Analytics Advisory (Italy - Retail)
• Building basket association analysis in python, API connection to Netezza
• POC development for interactive BI App. Zero-click intelligence development
SPS Commerce – Platform Analytics Setup (USA - eCommerce )
• Platform Analytics deployment on MSTR 2019
• Apache Kafka and Apac - MicroStrategy AssociateMicroStrategyJan 2020 - Nov 2020 (11 months)OpenTable – BI App Advisory (USA)
• Best practices of dossiers’ maintenance, development, and naming convention
Bristol Myers Squibb – MTDI & MSTR for Office Advisory (USA)
• Presenting the best practices for making incremental refreshes in MTDI Cubes
• Manipulating metrics in MTDIs, recommending workflows using Office plugin
Internal project – Live Connection BI Application
• Development of brand new application from scratch, including simple data model
• Data refresh automatization and live connection - IT System SpecialistIKEA GroupJul 2018 - Dec 2019 (1 year 6 months)• Providing end users(IKEA’s co-workers) with the IT Support and education
• Daily work in English and Spanish. Answering/dialing phone calls, writing emails. Daily communication in these both languages in the office.
• Data analyses in Ms Excel/SQL/Python/SAP on incident inflow/support flow/resolution. Looking for weaknesses and figuring out how to improve them
• Local Monitoring. Managing the IT incidents’ inflow in area, adjusting the co-workers’ timetables to meet daily business’ needs. Looking for critical issues registered as ones with low priority.
• Project group membership. Responsible for education carried out for newcomers in all Ikea Service Desks worldwide. Creating manuals, e-guides, knowledge presentations - Real Estate Sales RepresentativePlaceYouOct 2017 - Jun 2018 (9 months)• Acquiring the properties for exclusive sale
• Presentation the acquired flats to potential buyers
• Advising on the real estate market - Sales Team LeaderSouvreApr 2016 - Sep 2017 (1 year 6 months)• Leadership of 15-members team
• Recruitment
• Organization and providing the training courses
• Public speaking
• Direct Sale of FMCG products - Sales RepresentativeProgram Partnerski Lou Pre InternationalOct 2015 - Mar 2016 (6 months)• Direct Sale of FMCG products
Education
verified_user
0% verified
- Master's degree, Big Data AnalysisSGH Warsaw School of EconomicsJan 2018 - Jan 2020 (2 years 1 month)Python
• R Studio
• SAS Enterprise Guide
• SAS Enterprise Miner
• Oracle SQL
• Oracle Data Modeler
• Big Data
• Business Intelligence
• Data Science
• Data Analysis
• Amazon Web Services
• Cloud Computing
• Machine Learning
• Artificial Intelligence
• - Bachelor's degree, ManagementSGH Warsaw School of EconomicsJan 2015 - Jan 2018 (3 years 1 month)• Marketing
• Negotiation
• Business Plan
• Project & Quality Management
• Finance
• Recruitment