Skip to content
View aestevaomoraes's full-sized avatar
πŸ’­
Learning Data Science & AI πŸ€–
πŸ’­
Learning Data Science & AI πŸ€–
  • OI SA
  • Campo Grande , MS , Brasil

Block or report aestevaomoraes

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
aestevaomoraes/README.md

πŸ‘‹ Hello, I'm Antonio EstevΓ£o Moraes

🎯 Telecom Operations Specialist | Data & Analytics | AI & Automation

πŸ“ Brazil


BigQuery Looker Studio SQL Python Power BI Data Science Analytics Engineering AWS QuickSight Power Automate Microsoft Excel GitHub


πŸš€ About Me

Telecom Operations Specialist with strong experience in data analysis, automation, and process optimization, focused on improving operational efficiency through data analysis, automation, and process optimization.

I work at the intersection of operations and analytics, supporting decision-making with data-driven insights and performance monitoring.

πŸ’Ό Professional Background

  • 25+ years of experience in telecom operations
  • Experience in operational management and performance monitoring
  • Strong background in SLA, backlog control, and service operations
  • Experience leading and supporting teams and projects through operational and data-driven initiatives.

πŸ’‘ I focus on:

  • Improving operational performance (SLA, backlog, MTTR)
  • Automating processes and reducing manual workload
  • Turning data into actionable insights for decision-making

🧠 Tech Stack

Operations & Performance

  • SLA Monitoring
  • Backlog Management
  • Operational KPIs

Data Science

  • Python (pandas, numpy, scikit-learn)
  • Machine Learning (Regression, Classification)
  • Statistics & Hypothesis Testing

Data Analytics

  • SQL (Joins, CTEs, Window Functions)
  • Power BI (Dashboards, DAX)
  • Excel

Tools & Engineering

  • Git & GitHub
  • VS Code
  • Docker (basic knowledge)

πŸ† Key Certifications

  • πŸŽ“ DataCamp

    • Associate Data Analyst in SQL
    • Associate Data Scientist in Python (in progress)
  • πŸŽ“ Datab

    • FormaΓ§Γ£o Completa em Power BI
    • Power BI Specialist
  • πŸŽ“ Udemy

    • EstatΓ­stica para AnΓ‘lise de Dados com Python - Data Scientist. Luciano Galdino
    • Álgebra Linear com Python para Machine Learning e Modelagem - Data Scientist. Luciano Galdino
    • Python Data Science: Data Prep & EDA with Python - Data Scientist. Alice Zhao
    • SQL para AnΓ‘lise de Dados - Midori Toyota
    • AWS QuickSight: Dashboards Profissionais - Midori Toyota
  • πŸŽ“ LinkedIn Learning

    • Fundamentos de EstatΓ­stica (1,2,3) Eddie Davila

πŸ“ˆ Operational & Data Projects


πŸ”Ή Repair Operations Dashboard

πŸ“Š Nationwide monitoring of repair operations and service performance

repair-demo

πŸ”§ Tech:

  • Power BI
  • DAX
  • Data Modeling

πŸ“ˆ Key Metrics:

  • Mean Time to Repair (MTTR)
  • Backlog of Open Requests
  • SLA Compliance
  • Performance by Region

πŸ’‘ Highlights:

  • Identification of operational bottlenecks impacting SLA performance
  • Regional performance analysis
  • SLA monitoring enabling faster response to delays

πŸ”Ž View Project Details


πŸ”Ή CPE Operations Dashboard

πŸ“Š Monitoring of telecom equipment lifecycle and service operations

cpe-demo

πŸ”§ Tech:

  • Power BI
  • DAX
  • Data Modeling

πŸ“ˆ Key Metrics:

  • Service Orders (OS)
  • Installations vs Removals
  • Repair Status
  • Scheduling Performance

πŸ’‘ Highlights:

  • CPE lifecycle management
  • Partner performance analysis
  • Repair and scheduling tracking
  • Identification of inefficiencies in equipment lifecycle and operations
    πŸ”Ž View Project Details

πŸ”Ή Circuit Migration Dashboard

πŸ“Š Monitoring the migration of proprietary circuits to partner providers, focusing on SLA, backlog, and operational performance.

migration-demo

πŸ”§ Tech:

  • Power BI
  • DAX
  • Data Modeling
  • Power Automate

πŸ“ˆ Key Metrics:

  • Total Service Orders (OS)
  • Backlog of Open Orders
  • Mean Time to Install (TMI)
  • SLA Compliance

πŸ’‘ Highlights:

  • Migration performance by partner providers
  • Backlog and delay analysis
  • SLA monitoring and execution time tracking
  • Geographic distribution of service orders

βš™οΈ Automation:

  • Automated distribution of backlog OS to partner providers
  • Priority-based email notifications
  • End-to-end workflow automation (analysis β†’ decision β†’ execution)

πŸ’Ό Operational Impact:

  • Reduced manual workload through automation
  • Improved prioritization of service orders
  • Increased operational efficiency and response time

πŸ”Ž View Project Details


πŸ”Ή Telecom Revenue Analysis (T-Test)

πŸ“Š Analyze whether premium customers generate higher average revenue (ARPU) compared to standard customers

ARPU Distribution

πŸ’Ό Business Impact:

  • Supports strategic decisions on upsell and pricing
  • Enables better customer segmentation based on revenue behavior

πŸ”§ Tech:

  • Python, pandas, SciPy, matplotlib

πŸ“ˆ Results:

  • Statistically significant difference identified between premium and standard customers
  • Premium segment shows higher average revenue (ARPU)

πŸ’‘ Business Impact:

  • Supports data-driven upsell strategies
  • Helps optimize revenue and customer targeting

πŸ‘‰ View Project


πŸ”Ή Telecom Operations Analytics (AI + Automation)

πŸ€– Automate operational analysis, SLA reporting, and email delivery using AI and prompt engineering


πŸ”§ Tech:

  • Python, Pandas
  • Prompt Engineering (AI - Antigravity)
  • Automation workflows
  • Email automation (automated report delivery)

πŸ“ˆ Results:

  • Automated generation of operational reports
  • Automated email delivery of reports πŸ“§
  • Faster SLA analysis and decision support
  • Significant reduction in manual analysis effort

πŸ’‘ Business Impact:

  • Improves operational efficiency
  • Enables real-time and consistent reporting
  • Reduces manual workload in report distribution
  • Supports faster, data-driven decision-making in telecom operations

πŸ‘‰ View Project


πŸ”Ή Google Analytics Revenue & Conversion Analytics with BigQuery

πŸ“Š Business-oriented analytics project transforming nested Google Analytics data into actionable business insights using BigQuery SQL.

Project Architecture

πŸ”§ Tech:

  • Google BigQuery
  • SQL
  • ARRAY
  • STRUCT
  • UNNEST()
  • CTEs

πŸ“ˆ Key Analyses:

  • Revenue Analysis
  • Conversion Analysis
  • Landing Page Performance
  • Acquisition Channel Performance
  • Device Conversion Analysis
  • User Engagement Analysis

πŸ’‘ Highlights:

  • Analysis of nested Google Analytics datasets
  • Practical use of ARRAY, STRUCT and UNNEST
  • Revenue attribution and conversion insights
  • Business-focused analytics and storytelling
  • Professional project documentation and architecture design

πŸ† Business Insights:

  • Referral channels achieved the highest conversion efficiency
  • Homepage was the primary revenue entry point
  • Desktop users generated most purchasing sessions
  • Traffic volume did not necessarily translate into conversions

πŸ‘‰ View Project


πŸ”Ή Looker Studio + BigQuery Dashboard

☁️ Modern cloud-based Business Intelligence solution using Google BigQuery and Looker Studio.

DemonstraΓ§Γ£o do Dashboard

πŸ”§ Tech:

  • Google BigQuery
  • Looker Studio
  • SQL
  • Cloud Analytics

πŸ“ˆ Features:

  • Interactive dashboard
  • KPI cards
  • Cloud-based analytics
  • SQL Views
  • Calculated Fields
  • Dynamic filters

πŸ’‘ Highlights:

  • Fully cloud-native BI solution
  • Professional dashboard design
  • BigQuery + Looker Studio integration
  • Modern alternative to desktop BI tools
  • SQL transformations and business rules implementation

πŸ‘‰ View Project


πŸ”Ή Transportadora Operations Analytics

🚚 Solução analítica completa para monitoramento operacional e financeiro de uma transportadora utilizando PostgreSQL (Neon), SQL Analytics e Looker Studio.

Dashboard Executivo

πŸ”§ Tech:

  • PostgreSQL (Neon)
  • SQL
  • Looker Studio
  • GitHub

πŸ“ˆ Key Analyses:

  • Revenue by Region
  • Operational Profit by Region
  • Top Drivers
  • Top Destinations
  • Time Series Analysis
  • Operational Margin Analysis

πŸ’‘ Highlights:

  • 15 documented SQL analyses
  • SQL Views for analytics
  • Window Functions (LAG, RANK, SUM OVER)
  • KPI development
  • Business-focused dashboard

πŸ† Business Impact:

  • Identification of top-performing regions
  • Operational profitability monitoring
  • Driver performance analysis
  • Strategic decision support

πŸ‘‰ View Project

πŸ“Š GitHub Stats


πŸ“« Contact

πŸ’¬ Feel free to reach out β€” I’m open to opportunities and collaborations.


🎯 Career Goal

To work in data-driven roles, delivering measurable business impact through analytics, automation, and machine learning.

Pinned Loading

  1. google-analytics-revenue-conversion-analysis google-analytics-revenue-conversion-analysis Public

    bigquery sql google-analytics data-analytics business-analytics analytics-engineering marketing-analytics conversion-analysis revenue-analysis customer-journey

  2. bigquery-agregacoes-especiais-ecommerce bigquery-agregacoes-especiais-ecommerce Public

    BigQuery project exploring advanced aggregation functions for business analytics using TheLook E-commerce dataset.

    1

  3. looker-studio-bigquery-dashboard looker-studio-bigquery-dashboard Public

    Modern Business Intelligence project using Google BigQuery and Looker Studio.

    1

  4. aws-quicksight-analytics-dashboard aws-quicksight-analytics-dashboard Public

    Professional analytics dashboard project developed with AWS QuickSight for Data-Driven Decision Making and Exploratory Data Analysis (EDA).

  5. looker-bigquery-sales-lojpremium looker-bigquery-sales-lojpremium Public

    Analytics Engineering project using BigQuery + Looker Studio

    1

  6. Projeto-Data-Science-para-Neg-cios Projeto-Data-Science-para-Neg-cios Public

    Jupyter Notebook