Summary
Overview
Work History
Education
Skills
Timeline
Generic

Maggie Gebre

Cleveland,OH

Summary

Experienced IT professional with 7+ years specializing in Microsoft technologies, including MSSQL Server, Power BI, Tableau, SSIS, and SSRS. Proficient in crafting engaging dashboards, reports, and visualizations using Power BI and Tableau. Skilled in leveraging Python, Pandas, and advanced statistical tools to transform complex data sets into actionable insights. Seasoned in ETL development, data warehousing, and hybrid cloud solutions management for seamless data refresh. Strong aptitude for statistical analysis, predictive modeling, and optimizing data workflows, contributing to informed decision-making through insightful data analysis. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

7
7
years of professional experience

Work History

Data Analyst

KeyBank
06.2020 - Current
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Data extraction, transformation,and loading using Python, SQL, Power BI, and Tableau.
  • Developed data mining algorithms to identify and classify patterns in data.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Deployed predictive analytics models to forecast future trends.
  • Created data models to support decision-making processes.
  • Utilized data visualization tools to effectively communicate business insights.
  • Translate business needs into technical specifications and utilize Agile processes.
  • Design T-SQL queries, optimize ETL processes, and ensure data quality.
  • Collaborated with team members, and other stakeholders to ensure data quality and consistency.

Power BI Developer

L Brands
09.2018 - 05.2020
  • Planned, designed and implemented diverse business intelligence solutions.
  • Monitored assessment software for performance, security and database availability throughout lifecycle.
  • Compiled, maintained and developed database systems for tracking tailored content reports.
  • Oversaw database upgrade, backup, recovery and migration.
  • Designed customized data collection models for specific visualization tasks.
  • Improved data gathering, analysis and visualization procedures with strategic optimizations.
  • Wrote and optimized SQL statements to assist business intelligence practices.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Automated BI reports for secure virtual server environment.
  • Wrote complex DAX queries for data analysis and reporting.
  • Configured data gateway for cloud and on-premises data connections.
  • Created interactive dashboards and reporting tools for tracking key business metrics.
  • Collaborated with cross-functional teams and integrate BI into development.
  • Generated reports, updated spreadsheets and presented results.

SQL Developer

CVS
03.2016 - 07.2018
  • Analyzed and improved existing SQL queries for enhanced performance.
  • Designed and implemented T-SQL queries for reporting and complex solutions.
  • Documented analysis findings and offered performance enhancement feedback.
  • Developed customized ETL applications based on client specifications.
  • Created custom database objects, stored procedures, and provided application support.
  • Designed efficient SQL queries for retrieving data from diverse sources.
  • Optimized database objects, including stored procedures, views, and triggers.
  • Ensured data integrity through normalization and table creation.
  • Built various dashboards for operational, sales, financial, and KPI analysis.
  • Assisted in planning data extraction and processing tasks for deployments.
  • Developed data integration solutions for introducing new datasets.
  • Identified and resolved performance issues using query optimization and indexing.
  • Utilized SSIS for data integration and SSRS for report creation and implementation.
  • Managed database security through roles, permissions, and measures.
  • Collaborated with cross-functional teams for data gathering and analysis.
  • Provided technical support and troubleshooting for SQL Server, SSIS, and SSRS.

Education

Bachelor of Science - Computer Science

Addis Ababa University
07.2015

Skills

  • RDBMS/Databases: MS SQL Server (2019/2017/2016/2014/2012/2008 R2), Oracle, TOAD 75, MS Access
  • BI Tools: Power BI Desktop, Einstein Analytics, Tableau Desktop, Crystal Reports, MS Excel, SSRS, Excel Power View
  • SQL Server Tools: SQL Server Management Studio, BIDS, SQL Server Profiler, FTP, TOAD
  • Programming Languages: Python, R, SQL, HTML, JavaScript, T-SQL, PL/SQL, C/C, XML, CSS,, NET
  • Methodologies: Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/Physical/Dimensional, MS Project
  • Cloud Services: Microsoft Azure, AWS, Snowflake, Oracle Enterprise Manager Cloud

Timeline

Data Analyst

KeyBank
06.2020 - Current

Power BI Developer

L Brands
09.2018 - 05.2020

SQL Developer

CVS
03.2016 - 07.2018

Bachelor of Science - Computer Science

Addis Ababa University

Similar Profiles

CREATE PROFILE
Maggie Gebre