Luis Mejía - Resume

Summary

As an experienced data analyst, I have a strong background in working with various data analysis and visualization tools, including Tableau, PowerBi, Python, C#, and different versions of SQL. Since 2014, I have honed my skills in these platforms to gather, analyze, and present complex datasets, providing insights and recommendations to help drive business decisions. My expertise in data analysis and ability to leverage technology to deliver actionable results has made me an asset to organizations in need of comprehensive data analysis and visualization solutions.

Experience

Sr BI Developer/Analyst - ADT

Aug 2022 - Present

  • Responsible for creating and maintaining Tableau dashboards within the residential branch of the company
  • Create higher-quality data models using dbt to enhance code reusability within the CX BI Team
  • Develop, update, and maintain data pipelines
  • Create tables, views, and queries using the Google BigQuery SQL syntax

NA Data Analyst - ADT Commercial

Aug 2020 - Aug 2022

  • Responsible for creating and maintaining Tableau & PowerBi dashboards within the National/Commercial branch of the company
  • Create tables, views, and queries using the Google BigQuery SQL syntax
  • Responsible for gathering data from different vendors for National Accounts and archive in BigQuery

Data Analyst - Signet Jewelers

Jun 2019 - Aug 2020

  • Created and maintained a database to aid with reporting for the Store Technical Support department
  • Created data pipelines to archive data from Avaya and ServiceNow
  • Automated several manual processes; created a bulk email send tool, profitability calculator, real-time call center dashboards

Data Analyst - Brinks Home Security

Mar 2016 - May 2019

  • Provide real-time service jobs reporting in Tableau & Excel for management & field operations members
  • Provide department and agent level call center KPI reporting
  • Responsible for maintaining queries related to the cell cancellation process up-to-date

Education

Dallas College

  • Information Systems (In-Progress)

Tableau

  • Tableau Certified Data Analyst (In-Progress)

Skills

  • SQL (PL-SQL, MSSQL, BigQuery)
  • Python
  • C# .Net
  • VBA | VB
  • Basic HTML | CSS
  • Visual Studio & VS Code
  • SQL Server Management Studio
  • Toad Datapoint
  • dbt
  • Microsoft Office
  • Tableau | Tableau Server
  • PowerBi | Gateways & Spaces
  • Avaya CMS
  • MASterMind
  • Pandas, NumPy, Spark