Skip to content
View Alannoo6's full-sized avatar
πŸ‡¦πŸ‡·
Focusing
πŸ‡¦πŸ‡·
Focusing

Block or report Alannoo6

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Alannoo6/README.md

Hi, I'm AgustΓ­n Lannoo πŸ‘‹ β€” Data Analyst & Business Intelligence Engineer

πŸ“ Buenos Aires, Argentina
πŸ’‘ Turning raw data into decisions that actually matter

LinkedIn Email Resume


πŸ™‹ About Me

I'm a Data Analyst with a background in Business Administration and over 3 years of hands-on experience at Brandteam Group, where I work at the intersection of finance, operations, and technology.

I'm passionate about the full data journey β€” optimizing processes to cut reporting time, automating repetitive tasks so teams can focus on what matters, and finding the patterns hidden in the noise that lead to better decisions.

I've designed and implemented 15+ Power BI dashboards that reduced reporting time by 60% (from 8 hours to 3 hours per week), built SQL-based data pipelines for transactional systems, and developed Python automation scripts for report generation and file processing.

My approach is simple: understand the business problem first, then build the most elegant analytical solution to solve it.

"Without data, you're just another person with an opinion." β€” W. Edwards Deming


πŸ”§ Tools & Technologies

Data & Analytics

Power BI SQL Server DAX Jupyter

Automation & DevOps

Python n8n Git GitHub

Libraries

Pandas NumPy Matplotlib Plotly


πŸ’Ό Professional Experience

Data Analyst & IT Analyst β€” Brandteam Group Β· Buenos Aires Β· June 2023 – Present

As part of the internal IT team, I bridge the gap between business needs and data analytics, delivering solutions that optimize processes and improve decision-making across multiple business units within the group.

Key contributions:

  • Implementation and support of ERP and CRM systems, ensuring operational continuity and improvements in administrative and commercial processes
  • Development of Power BI dashboards and automated reports using SQL and Excel, enabling real-time visualization of financial, sales, and operational KPIs
  • Design of ETL processes and data modeling in a data warehouse, facilitating historical and predictive analysis
  • Coordination and training of end users on management tools, driving digital adoption across different areas
  • Leadership of the support ticket team using FreshDesk, improving incident resolution efficiency

Impact: Reduced report generation times, improved visibility of commercial and operational results, and supported strategic decision-making across multiple business units.


πŸŽ“ Education

Bachelor's Degree in Business Administration
Universidad de Ciencias Empresariales y Sociales (UCES) Β· Buenos Aires

Diploma in Agile Methodologies and Frameworks
Universidad TecnolΓ³gica Nacional (UTN) Β· Buenos Aires


πŸ’Ό Featured Projects

πŸ›’ Olist E-Commerce Analysis Β· πŸ”΄ Live Demo

Python Pandas NumPy Plotly Streamlit Jupyter

End-to-end EDA and interactive dashboard for the Brazilian Olist marketplace (~100K orders, 2016–2018). Six business insights on growth, customer retention (1.03 orders per customer), geographic concentration (62% from top 3 states), delivery impact on CSAT (2.1Γ— rating gap), and seller Pareto (544 of 3,095 sellers generate 80% of GMV).

πŸ”— Live Dashboard Β· πŸ’» Repository Β· πŸ““ Notebook


πŸ’° Business Performance Dashboard

SQL Server Power Query DAX Power BI

Financial and inventory KPIs in a single analytical model: billing, collections, customer debt aging, stock control and inventory valuation. Built on a star schema with 8 fact tables.

πŸ’» Repository


πŸ“Š Sales Management Dashboard

SQL Server DAX Power BI

Power BI dashboard for commercial performance analysis (2021–2025). Interactive analysis of sales by client, salesperson, brand and region, built on real anonymized sales data spanning 5 years.

πŸ’» Repository


βš™οΈ Price Recalculation Pipeline

T-SQL SQL Server ETL Batch Processing

Transaction-safe SQL pipeline for ERP price synchronization. Automated stored procedure that recalculates pricing, taxes and discounts for pending sales orders, preventing billing errors and ensuring financial consistency.

πŸ’» Repository


πŸ“š Recommended Readings

Books that have shaped the way I think about data and analytics:

Data & Analytics

  • πŸ“– Data Science from Scratch β€” Joel Grus β€” A great hands-on introduction to data science fundamentals using Python. Perfect for understanding what's really happening under the hood.
  • πŸ“– Learning Microsoft Power BI β€” A practical guide that takes you from basics to building real-world dashboards. Highly recommended for anyone getting into BI.

On my radar

  • πŸ“– Designing Data-Intensive Applications β€” Martin Kleppmann β€” The bible for understanding how data systems work at scale.
  • πŸ“– The Alignment Problem β€” Brian Christian β€” A fascinating and accessible look at the challenges of building AI systems that do what we actually want.

πŸ“« Contact

Email: lannoowa@gmail.com
LinkedIn: linkedin.com/in/agustin-lannoo


Open to collaboration and opportunities in data analytics, business intelligence and data engineering.

Pinned Loading

  1. price-recalculation-pipeline price-recalculation-pipeline Public

    Batch SQL pipeline to recalculate pricing, taxes and discounts for pending sales orders.

    TSQL 1

  2. business-performance-dashboard business-performance-dashboard Public

    Power BI dashboard consolidating financial and inventory KPIs (billing, collections, debt aging, stock valuation) into a single star-schema analytical model

  3. olist-ecommerce-analysis olist-ecommerce-analysis Public

    End-to-end Python EDA and interactive Streamlit dashboard analyzing ~100K orders from the Olist Brazilian e-commerce marketplace

    Python

  4. sales-management-dashboard sales-management-dashboard Public

    Power BI commercial management dashboard based on real sales data

  5. argentina-dollar-data-pipeline argentina-dollar-data-pipeline Public