Ayax Saraintaris Analytics Engineer

Analytics Engineer

Magic

Jan 2023 - Current (3 years 6 months)

As an Analytics Engineer, I specialize in data visualization and dashboard creation using Looker Studio and PowerBI. I create SQL queries on BigQuery and Snowflake, and perform ELT data shaping through DBT. My role involves KPI analysis for the sales department and customer success team, along with the daily update of sales reports and customer success metrics. I am responsible for creating sales projections and conducting quota analysis, as well as consolidating workflows on Hubspot. Additionally, I create prompts to streamline processes and improve repetitive tasks in Chat GPT, aiming to increase efficiency and productivity within the company. While my primary tools at Magic are BigQuery, DBT, and Looker, I frequently utilize Microsoft Ex

Planning and BI Consultant

Universal Assistance

May 2021 - Jan 2023 (1 year 9 months)

- Data visualization and dashboard creation on Tableau. - Creating SQL queries on Dbeaver. - ETL data shaping through Tableau Prep Builder. - KPI analysis for the direct sales department. - Daily update of sales reports. - Creating sales projections and commissions. - Updating and consolidating databases. - Achieved a 75% reduction in time spent recovering information from one database to another by making more efficient key processes and databases. - Utilized Microsoft Excel as a core tool for building dashboards, managing KPIs, and preparing operational reports for senior management, ensuring comprehensive data analysis. - Applied data validation techniques to maintain data accuracy when consolidating inputs from multipl

I

Bussiness Lead Consultant

Intergarantias S.G.R.

Jul 2019 - Mar 2021 (1 year 9 months)

- Conducted comprehensive business and data analysis to drive strategic decision-making and enhance client portfolio management, including forecasting and financial planning. - Utilized PowerBI for effective data visualization, which contributed to a clearer understanding of financial metrics and trends. - Increased the annual profit of the company by 5% through meticulous analysis of financial statements for each client, evaluating their creditworthiness and potential for credit acquisition. - Implemented data validation practices to ensure the accuracy and consistency of financial and client data, which was essential for assessing credit risk and supporting informed business decisions.

A

Lead Business Analyst

Atento en Argentina

Aug 2016 - Apr 2019 (2 years 9 months)

- Led and successfully trained a team of 4 direct reports and 15 indirect reports, fostering a collaborative and high-performance environment. - Conducted annual financial forecasting and KPI creation, reporting directly to C-Level executives to inform strategic decisions. - Performed comprehensive data analysis, including income, COF, COB, and revenue, ensuring meticulous control and analysis. - Created SQL queries using Toad Edge for MySQL, enhancing data retrieval and reporting efficiency. - Maintained Microsoft SQL Server 2012, ensuring optimal performance and data integrity. - Shaped and programmed dashboards using Power BI and MicroStrategy, providing actionable insights for stakeholders. - Managed workforce data analysis

Voluntariado, Ayudante de Catedra, Direccion General

Universidad de Buenos Aires

Jul 2014 - Dec 2017 (3 years 6 months)

- Ayudante de Cátedra Schvartstein Leonardo de la materia Dirección General, bajo el Profesor Catalino Nuñez, en la Facultad de Ciencias Económicas de la Universidad de Buenos Aires. - Utilicé Microsoft Excel para gestionar registros de estudiantes, realizar un seguimiento de la asistencia y organizar datos de calificaciones, lo que facilitó la administración académica y mejoró la eficiencia en el manejo de información estructurada.

A

Tech and Data Analyst

Atento en Argentina

Jul 2014 - May 2016 (1 year 11 months)

- Created dashboards using Excel and Power BI to visualize key performance metrics. - Developed KPIs for clients tailored to their specific business requirements, ensuring alignment with strategic goals. - Maintained Microsoft SQL Server 2008 to support data integrity and accessibility. - Utilized macro programming with VisualBasic to enhance reporting efficiency. - Managed CRM reporting and automation processes using Avaya and Genesys, contributing to a streamlined workflow. - Achieved a 20% improvement in NPS (net promotion score) across the team by leveraging data insights. - Conducted data entry to update internal databases and generate reports, ensuring that operational data was accurate and up-to-date. - Applied data val

Reporting Analyst

Claro Argentina

Apr 2010 - Jun 2014 (4 years 3 months)

- Creating the commission’s scheme for the team. - Sales and Finance Data Visualisation with Microestrategy - Query creation with PL/SQL Developer Building, updating, and consolidating databases. - Creating reports on Excel based on requirements.

Technical Support

Teletech

Sep 2007 - Feb 2009 (1 year 6 months)

Ayax Saraintaris

About

Detail

Timeline

Résumé