Summary
Overview
Work History
Education
Skills
Timeline
Generic

Dessa Wirtu

Reston,VA

Summary

  • Over 6 years of experience in transforming raw data into meaningful business insights by leveraging advanced analytics and data visualization techniques, driving strategic decision-making and operational improvements.
  • Strong expertise in Python (Pandas, Nubby, Scikit-learn) for complex data manipulation, predictive modeling, and automating data-driven processes.
  • Advanced proficiency in Power BI, including designing dynamic dashboards and reports that integrate data from sources like CSV, Excel, SharePoint, and external databases to deliver real-time insights.
  • Deep knowledge of the Power BI ecosystem: using Power BI Desktop for reporting, Power BI Service for collaboration, Power BI Mobile for remote access, and Power Query for data transformation.
  • Extensive experience with SQL Server for developing and optimizing complex queries, managing databases, and executing ETL processes using SSIS and Talent.
  • Expertise in building scalable data pipelines and data warehousing solutions using Apache Spark and Azure Data Factory to ensure smooth data flow and timely reporting.
  • Skilled in integrating data from systems like Oracle, Azure SQL Database, and Google Big Query to enable comprehensive analytics and reporting.
  • Proven ability to analyze large datasets, identify trends, deliver actionable insights, and provide recommendations that drive business strategies.
  • Solid understanding of data security and compliance, with experience in implementing role-based access control (RBAC), encryption, and other measures to safeguard sensitive data and adhere to regulatory standards.
  • Proficient in streamlining reporting processes and enhancing efficiency through automation using Python and Power Automate.
  • Experienced in providing end-user training, developing documentation, and supporting optimal use of data tools and solutions.
  • Effective project management and collaboration in agile environments, utilizing JIRA, GitHub, and Confluence for version control, task tracking, and team coordination.

Overview

7
7
years of professional experience

Work History

Data Analyst / Power BI Specialist/Developer

JPMorgan Chase
05.2022 - Current
  • Spearheaded the development and maintenance of dynamic Power BI dashboards and reports, offering actionable insights and real-time visibility into critical performance metrics (KPIs).
  • Engineered intricate data models within Power BI, integrating sources from SQL Server, Oracle, and cloud platforms to deliver a cohesive perspective on business data.
  • Enhanced database performance and optimized SQL queries, significantly improving execution speed and streamlining data retrieval processes.
  • Automated data extraction and transformation workflows using Power Query and Python, minimizing manual efforts while boosting reporting precision.
  • Performed in-depth data analysis utilizing Python libraries like Pandas, Nubby, delivering predictive models and trend analyses to inform strategic initiatives.
  • Partnered closely with stakeholders to gather business needs, translating them into tailored BI solutions that aligned with organizational objectives.
  • Established and enforced data governance policies, ensuring data integrity, security, and compliance through role-based access control (RBAC) and encryption measures.
  • Created and delivered end-user training sessions and detailed documentation, promoting effective utilization of Power BI tools and driving widespread team adoption.
  • Managed and streamlined ETL processes using SSIS , facilitating smooth data integration and ensuring precise reporting.
  • Connected a variety of data sources such as CSV, Excel, SharePoint lists, and external databases, enabling comprehensive analytics and reporting.
  • Implemented scalable data pipelines using Apache Spark and Azure Data Factory, enhancing data processing efficiency and enabling timely insights.
  • Led BI initiatives using agile methodologies, coordinating with cross-functional teams through JIRA and GitHub for project management and version control.
  • Reinforced data security through best practices and compliance measures, safeguarding sensitive information and meeting organizational standards.
  • Delivered actionable insights via thorough data analysis, empowering strategic decision-making and driving operational improvements across the enterprise.
  • Environment: Power BI, SQL Server, Oracle, Power Query, Pandas, SSIS, Apache Spark, Azure Data Factory, Excel, SharePoint lists.

Power BI Developer

Cigna - Bloomfield, CT
05.2019 - 12.2021
  • Designed and developed interactive dashboards and in-depth reports using Power BI, integrating data from various sources such as CSV, Excel, SharePoint lists, and external databases to improve decision-making.
  • Created custom visualizations and reports in Power BI Desktop and Power BI Service, delivering real-time insights and facilitating collaboration across teams.
  • Utilized Power Query for data preparation and transformation, enhancing workflow efficiency and ensuring accurate reporting.
  • Managed and optimized complex SQL Server queries to ensure data integrity, reliability, and improved performance.
  • Executed ETL processes with SSIS and Talend, maintaining consistent data quality across relational databases.
  • Developed and maintained data warehousing solutions using Apache Spark and Azure Data Factory, enabling seamless data integration and high-quality reporting.
  • Applied Python (Pandas, NumPy, Scikit-learn) for advanced data analysis, predictive modeling, and automation, increasing efficiency and generating actionable insights.
  • Leveraged advanced Excel functions, including pivot tables, macros, and complex formulas, to streamline data manipulation and reporting tasks.
  • Implemented scalable data pipelines and integrated data from sources such as Oracle and cloud platforms like Azure SQL Database and Google Big Query to support comprehensive analytics.
  • Automated data integration processes, ensuring timely and accurate availability of critical data for stakeholders.
  • Established data security protocols, including role-based access control (RBAC) and encryption, safeguarding sensitive information and meeting compliance standards.
  • Utilized data governance tools such as Collibra and Talend Data Quality to enforce data integrity and regulatory compliance.
  • Automated reporting processes using Python scripts and Power Automate, reducing manual workloads and enhancing operational efficiency.
  • Streamlined data preparation and visualization workflows through automation, boosting reporting accuracy and saving time.
  • Environment: Power BI, Power Query, SQL Serve , SSIS, Talend, Apache Spark, Azure Data Factory, Oracle, Google Big Query, Azure SQL Database, Excel (pivot tables, macros), SharePoint lists, RBAC, Encryption, Power Automate.

SQL Server Database Administrator (DBA)

Aflac
01.2018 - 04.2019
  • Optimized SQL Server databases by fine-tuning complex queries and enhancing performance while ensuring high levels of data integrity.
  • Built and maintained efficient ETL processes using SSIS and Talend to streamline data integration from multiple sources.
  • Designed and implemented scalable data pipelines and warehouse solutions leveraging Apache Spark and Azure Data Factory for better data flow and reporting.
  • Integrated data from diverse platforms including Oracle, Azure SQL Database, and Google Big Query, enabling comprehensive and cohesive data analysis.
  • Enforced strict data security protocols, applying encryption and role-based access control (RBAC) to protect critical information and maintain compliance.
  • Conducted ongoing monitoring, performance tuning, and capacity planning to keep database operations running smoothly and efficiently.
  • Automated repetitive database management tasks using PowerShell and Python scripts, leading to improved efficiency and reduced manual interventions.
  • Provided hands-on end-user support, offering training, troubleshooting, and detailed documentation to maximize the effectiveness of database systems.
  • Coordinated database projects with cross-functional teams, utilizing agile methodologies and tools such as JIRA, GitHub, and Confluence to ensure successful execution.
  • Performed advanced data analysis with Python (Pandas, Scikit-learn) to uncover insights that supported strategic planning and operational improvements.
  • Implemented regular database health checks and conducted preventive maintenance to minimize downtime and prevent performance issues.
  • Collaborated closely with business stakeholders to align database management strategies with organizational goals and priorities.
  • Led efforts to standardize data management practices, introducing best practices for security, data quality, and system performance.
  • Environment: SQL Server, SSIS, Talend, Apache Spark, Azure Data Factory, Oracle, Google Big Query, Azure SQL Database, Python (Pandas, NumPy, Scikit-learn), PowerShell, JIRA, GitHub, Confluence.

Education

Bachelor of Arts - Management

Management

Skills

  • Data Analysis : Power BI (Desktop, Service, Mobile, Power Query), interactive dashboards, custom visualizations
  • Programming & Scripting: Python (Pandas ,Scikit-learn)
  • Data Integration & Pipelines: Apache Spark, data connections ( Excel, SharePoint, databases)
  • Data Security & Compliance: RBAC, data governance ( Talend Data Quality)
  • Database Technologies: SQL Server, Azure SQL Database, data integration, ETL (SSIS)
  • Automation & Workflow: , Power Automate, reporting automation
  • Project Management & Collaboration: GitHub , agile methodologies
  • SQL
  • Data visualization and presentations
  • Data analysis
  • SQL databases
  • Data cleaning
  • Data modeling
  • ETL processes

Timeline

Data Analyst / Power BI Specialist/Developer

JPMorgan Chase
05.2022 - Current

Power BI Developer

Cigna - Bloomfield, CT
05.2019 - 12.2021

SQL Server Database Administrator (DBA)

Aflac
01.2018 - 04.2019

Bachelor of Arts - Management

Management

Similar Profiles

CREATE PROFILE
Dessa Wirtu