Andy Stepas, Developer in Barcelona, Spain
Andy is available for hire
Hire Andy

Andy Stepas

Verified Expert  in Engineering

Analytics Developer

Location
Barcelona, Spain
Toptal Member Since
February 1, 2021

Andy is a business intelligence consultant helping businesses transform into data-driven organizations, leveraging the most up-to-date technology and engineering practices. He possesses expertise in modeling, visualization, and reporting. Additionally, Andy has comprehensive technical and work-related experience that extends beyond business intelligence, professional training, and technical support for customers seeking to advance their technological goals.

Portfolio

Agos
Microsoft Power BI, DAX, Modeling
Publicis Groupe
Birst, SQL Server Integration Services (SSIS), MDS, Snowflake, Azure Databricks
Practia Global
Microsoft Power BI

Experience

Availability

Full-time

Preferred Environment

Microsoft Power BI, DAX, Power Query M, SQL

The most amazing...

...thing I've developed was automated report development for engineering production at YPF, Argentina's biggest oil and gas company, using Power BI.

Work Experience

Business Intelligence Consultant

2022 - PRESENT
Agos
  • Developed "Bad Debt and Credit Memos" reports, streamlining Guardian Glass’s financial reconciliation and risk assessment processes.
  • Executed a comprehensive reengineering of the SGA report at Guardian Glass, updating the data sources and optimizing the model to enhance readability, facilitate future modifications, and ensure scalability.
  • Maintained and conducted quality control on Guardian Glass's primary financial report, optimizing the incremental refresh of tables, providing support for bug issues, and proactively identifying data refresh problems before they impact users.
Technologies: Microsoft Power BI, DAX, Modeling

BI Architect

2021 - 2022
Publicis Groupe
  • Modeled and administered the Samsung Global Reporting Platform.
  • Designed, developed, and supported data models, reports, dashboards, and administration of the Global Reporting Platform.
  • Performed requirement gathering and designed and built the models and reports.
Technologies: Birst, SQL Server Integration Services (SSIS), MDS, Snowflake, Azure Databricks

Data Analyst

2019 - 2021
Practia Global
  • Automated report development for engineering production at YPF, Argentina's biggest oil and gas company, using Power BI.
  • Created and led the development of basic and advanced Power BI e-learning courses for the YPF company.
  • Reengineered and automated critical control management systems of oil and gas wells for YPF. Converted the control system from R and Python languages to Microsoft Power BI.
Technologies: Microsoft Power BI

Service Engineer

2008 - 2016
ABB
  • Designed the reporting system for the delivery and tracking of sales and service reports from customer inquiry to delivery.
  • Oversaw service processes, with the focus of optimized customer experience.
  • Specialized in technical support, enhancing customer relations and satisfaction with company service.
Technologies: Technical Support, Customer Support, Data Analysis, BI Reports, Analytics

Production Engineering Report

A completely automated report development for engineering production at YPF, Argentina's biggest oil and gas company, using Power BI. The report contains four sections in order to optimize oil and gas production. The report gets the data from five different Oracle databases and has many complex engineering calculations to show the main indicators.

Power BI Courses

I created and led the Development of Basic and Advanced Power BI e-learning courses for the YPF company. The courses have a duration of one day for every level and it consists of theory and exercises to be developed by the participants. I trained more than 150 users.
2001 - 2005

Bachelor's Degree in Electronic Engineer

UNEFA - Venezuela

MARCH 2021 - MARCH 2023

Microsoft Certified Data Analyst Associate

Microsoft

FEBRUARY 2020 - NOVEMBER 2022

Power BI Dashboard Design Course

sqlbi

OCTOBER 2019 - MAY 2022

Mastering DAX

sqlbi

DECEMBER 2018 - PRESENT

Data Analytics

Digital House

Tools

Microsoft Power BI, Tableau

Other

Data, Data Visualization, BI Reports, DAX, Analytics, Modeling, Electronics, Dashboard Design, Data Analytics, Data Analysis, Data Warehouse Design, Customer Support, Technical Support, Data Modeling, Birst, MDS, Azure Databricks

Languages

SQL, Python, Power Query M, Snowflake

Paradigms

Automation, ETL, Scrum

Storage

SQL Server Integration Services (SSIS)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring