Power Bi Sql Server
Resume:
DESSA WIRTU
• ********@*****.***
• Linked In URL: https://www.linkedin.com/in/dessalegn-wirtu-1828b6279 POFESSIONAL SUMMARY
Over 7 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) 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. Skills
Data Analysis: Power BI (Desktop, Service,
Mobile, Power Query), interactive dashboards,
custom visualizations.
Data modeling
Data cleaning
SQL databases
Data analysis
Data visualization and presentations
Project Management & Collaboration: GitHub,
agile methodologies.
Automation & Workflow: Power Automate,
reporting automation.
Database Technologies: SQL Server, Azure SQL
Database, data integration, ETL (SSIS).
Data Security & Compliance: RBAC, data
governance (Data Quality).
Data Integration & Pipelines: Apache Spark,
data connections (Excel, SharePoint, databases).
Programming & Scripting: Python (Pandas,)
Data Analysis: Power BI (Desktop, Service,
Mobile, Power Query), interactive dashboards,
custom visualizations.
WORK HISTORY
Data Analyst / Power BI Specialist/Developer, 05/2022 to Current JPMorgan Chase – New York, NY
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, 05/2019 to 12/2021
Cigna - Bloomfield, CT – Bloomfield, CT
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 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, 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 Server, 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), 01/2018 to 04/2019 Aflac – Columbus, GA
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 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) 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, Apache Spark, Azure Data Factory, Oracle, Google Big Query, Azure SQL Database, Python (Pandas, learn), PowerShell, JIRA, GitHub, Confluence. Education
- Bachelor of Arts: Management Information System
Contact this candidate