Data & BI Solutions Architect

Haymanot Getu

Data & Business Intelligence Specialist Profile

*************@*****.*** • 202-***-****

Maryland

Seasoned professional with vast experience in driving impactful data solutions and enhancing business intelligence capabilities. Proven track record of designing scalable ETL pipelines, automating reporting processes, and integrating diverse data sources to support decision-making across cross-functional teams. Skilled in managing efficient data workflows from extracting and transforming data to building dynamic dashboards and interactive visualizations. Committed to delivering high-impact data solutions that enhance operational efficiency and drive measurable business outcomes. Thrive in Agile and Waterfall settings, with collaborative approach to stakeholder engagement and continuous improvement.

Area of Expertise: BI Solution Development ETL & Data Integration Agile Delivery & Process Improvement Automation & Dashboard Creation Performance Tuning & Enhancement SQL Development & Query Optimization Data Modelling & Governance Cloud Data Platforms & Scalability Cross-functional Collaboration

Professional Experience

SQL, Snowflake, Power BI & Power Platform Developer

FedEx Corp — Memphis, TN Jan 2023 – Present

Developed interactive dashboards and enterprise reports using Power BI Desktop & Service, implementing row-level security, scheduled refresh, and workspace governance.

Configured and governed Microsoft Power Platform (Power Apps, Power Automate, Power BI, Power Pages) to enable secure enterprise self-service solutions.

Implemented environment strategy (Dev/Test/Prod), connector governance, and DLP policies to ensure platform security and compliance.

Managed Power BI platform administration including datasets, gateways, workspaces, and access control.

Integrated Power Platform and Power BI with enterprise data sources including SQL Server, Azure, Snowflake, Oracle, and APIs.

Developed and optimized T-SQL database objects, ETL workflows, and Snowflake data pipelines using Snowpipe.

Created SSRS reports and advanced analytics using DAX and MDX.

Supported CI/CD deployments using Azure DevOps and stabilized existing Power Platform applications and automations.

SQL/Power BI Developer/Analyst Acentra, McLean, VA

June 2021 — Jan 2023

Environment: Power BI 2.7, MS Office Suite, Oracle 12c, MySQL 7.1, SQL Server 2017/2019, PowerPoint

Coordinated with business users and stakeholders to comprehend data architecture, business rules, transformation logic, and reporting requirements; documented metrics, features, and UI expectations. Performed SQL performance tuning using SQL Profiler, Index Tuning Wizard, and Query Analyzer in MS SQL Server 2017/2019 to reduce report execution time. Created and optimized complex SQL queries to join and analyze large datasets across multiple source systems. Designed Power BI dashboards using visuals, such as combo/scatter charts, slicers, gauges, cards, map visualizations, matrixes/tables, waterfall and funnel charts, visual hierarchies, and drill-down capabilities. Applied filters, parameters, and custom SQL queries to enhance performance and interactivity. Used Excel for data mapping, comparison, analysis, and ad-hoc reporting; combined with PowerPoint and InfoView for delivering business insights and performance summaries.

Developed complex T-SQL code including Stored Procedures, Functions, Triggers, CTEs, temp tables, and user-defined types to implement business rules and optimize data operations.

Partnered with data modelers to interpret source data models and contributed to Source-to-Target Mapping (STTM) documentation for ETL and reporting processes.

Published Power BI reports to service and implemented data refresh schedules to ensure up-to-date reporting.

Utilized Tableau to create interactive dashboards and multi-source views, leveraging advanced visualizations and calculated fields for dynamic analysis.

Directed diverse functions (string, date, aggregate, conversions) in SQL, Power BI, and Tableau to meet analytical needs.

Designed and developed SSRS reports using complex T-SQL queries, parameters, and advanced expressions, delivering drill-down and drill-through functionality that improved reporting clarity and supported data-driven decision-making.

Database/BI Developer JP Morgan, Jersey City, NJ

Feb 2016 — June 2021

Built interactive Power BI dashboards and reports to track sales trends, customer behaviour, and operational performance. Executed analysis to identify sales trends, seasonal patterns, and customer insights. Created self-service dashboards to empower non-technical users and improve data accessibility across departments. Supported pricing and inventory strategies by developing sales forecasts and evaluating historical demand patterns. Optimized SQL queries, stored procedures, and triggers to enhance database performance. Applied performance tuning techniques, such as indexing, partitioning, and query optimization to improve system responsiveness. Refactored PL/pgSQL and PL/SQL procedures for better performance and maintainability. Administered cloud databases on Azure SQL, AWS RDS, and Oracle Cloud, ensuring secure and scalable deployments.

Led 50% enhancement in decision-making efficiency by launching interactive Power BI dashboard for real-time monitoring of sales, inventory, and customer satisfaction.

Decreased stockouts and boosted inventory turnover by 10% - 25% through supply chain analysis.

Contributed to development of data-driven pricing strategy by monitoring customer behaviour patterns, driving 25% increase in average order value (AOV).

Enhanced operational efficiency by automating critical reports, slashing report generation time by 40 hours weekly and facilitating prompt access to insights for senior management.

Consolidated data from multiple sources (sales, inventory, customer systems) into unified models and visualizations to support data-driven decisions.

Ensured data quality through regular cleaning, transformation, and validation using Power Query and SQL.

Implemented database management tasks using Terraform, Ansible, and Azure DevOps to improve deployment efficiency.

Managed data integration and migration across PostgreSQL and Oracle systems, maintaining consistency and reliability.

Education

B.S. in Management Information Systems, Addis Ababa University (2015)

Certifications

CompTIA Security+ Microsoft Power BI Data Analyst Certification

Technical Proficiency

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL, SQL Server Management, Snowflake

Programming Languages: T-SQL, DAX, PL/SQL, Snow SQL, C#.Net, Python

ETL Tools: SQL Server Integration Services (SSIS), IBM DataStage, Informatica Cloud

Reporting Tools: Power BI, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report Builder

Operating Systems: Windows 7/10, Windows 2016, 2017,2019, Windows Server 2012/2014/2016, Windows XP

Contact this candidate