Business Intelligence Data Engineer

Getahun Amede

Senior Business Intelligence Analyst Profile

************@*****.*** • 703-***-****

LinkedIn • Arlington, TX

Highly skilled Senior Business Intelligence Analyst with hands-on experience in data modeling, database design, and BI solution architecture. Expert in SQL Server management, Microsoft BI tools (SSIS, SSAS, SSRS, Power BI), and developing ETL processes. Proficient in T-SQL, C#, and PL/SQL. Experienced in leading cloud-based data warehouse migrations, optimizing costs, and enhancing data accuracy and accessibility. Skilled in using advanced analytics for strategic decision-making, with a strong focus on performance tuning, security, and compliance to support complex business needs. Experienced in Azure Synapse and SSRS reporting, with strong familiarity with Dataverse and Dynamics 365 applications. Served as a liaison between stakeholders and technical teams to gather requirements, design solutions, and ensure successful project delivery.

Areas of Expertise

● Data Modeling & Database Design

● Software Development Life Cycle (SDLC)

● Team Leadership & Quality Assurance

● Business Intelligence & Data Warehousing

● System Architecture & Cloud Migration

● Risk Management & Operational Efficiency

● ETL Processes & Project Management

● Performance Optimization

● Data Analysis & Process Improvement

Technical Proficiencies

Database & Data Management: SQL Server 2019/2016/2014, Oracle, DB2, Data Warehousing

BI Tools & Reporting: SSIS, SSAS, SSRS, Power BI, Cognos, Tableau, Crystal Reports, Qlik, Erwin, Excel

Programming Languages: C#, T-SQL, PL/SQL, VB.NET, ADO.NET, ASP.NET, HTML, XML

Cloud Technologies: AWS (Glue, Redshift, S3), Cloud Data Management

Software Development: SDLC, CI/CD, Agile Methodologies, Visual Studio, SQL Server BIDS, TFS, GitHub, JIRA

Performance Optimization: SQL Profiler, Azure SQL, Database Tuning Advisor, Windows Performance Monitor

Professional Experience

VITAS Healthcare, Miramar, FL

Senior BI Architect

April 2024 — September 2024

Analyze BI analyst data to understand business needs and design optimized data structures and databases aligned with business goals. Troubleshoot and optimize BI programs and systems to enhance performance and ensure seamless operations. Direct client support, deliver technical guidance, and resolve data-related issues. Design and implement data models in Power BI, transforming raw data into actionable insights through interactive dashboards and detailed reports.

●Converted business requirements into technical specifications and executed detailed Power BI script analyses, including DAX queries.

●Led data warehouse projects from concept to deployment, developing systems and creating comprehensive documentation for data models and algorithms.

●Deployed dynamic reports in Power BI, utilizing Drill mode, and integrated MDX and DMX queries for enhanced data processing.

●Architected scalable BI solutions that reduced reporting time by 35% and improved data accuracy across the organization.

●Managed a cross-functional team to migrate a legacy data warehouse to a cloud-based platform, reducing infrastructure costs by 30%.

●Implemented a self-service BI platform that significantly reduced IT dependency by enabling business users to generate reports and dashboards independently.

Data Group USA, Alexandria, VA

SQL/ETL/BI Developer

May 2022 — April 2024

Executed database migrations from SQL Server 2012 and 2014 to SQL Server 2017 using SSIS and developed complex database code objects to improve report generation and query performance. Conducted logical and physical data modeling to refine data warehousing strategies and deployed SSIS packages to facilitate data transfers from OLTP systems to data warehouses. Supported the Association Management System through function development and rigorous user acceptance testing. Managed AWS components like ELB, EC2, S3, RDS, and SNS, optimizing cloud operations and automating processes for streamlined deployment.

●Spearheaded the development of a comprehensive BI solution that integrates multiple data sources for real-time insights, enhancing decision-making efficiency by 17%.

●Led daily Agile scrums and standups, coordinating project progress and team deliverables, and engaged extensively with stakeholders to align system functionalities with business requirements.

●Conducted detailed performance tuning and optimizations, increasing query responsiveness by 25% and database efficiency for statistical reporting by 25%.

●Designed and implemented ETL workflows that reduced data processing times by 35% and developed a suite of BI dashboards and reports that improved operational efficiency by 15%.

DELTA Resources, Washington DC

SQL/SSIS/SSRS Developer

August 2019 — April 2022

Developed complex T-SQL stored procedures, triggers, functions, indexes, tables, views, and joins to enforce business rules, significantly enhancing database functionality. Led the design and implementation of Data Warehouse projects, from requirements gathering through deployment, utilizing extensive SSIS functionalities like For Loop, Execute package/SQL tasks, and advanced data transformation items such as Pivot, Fuzzy lookup, and Conditional Split. Managed Disaster Recovery strategies, including Log Shipping and Database Mirroring, to ensure data integrity and availability. Implemented data transformation tasks using BCP and BULK INSERT for efficient data importing/exporting, and tailored SSRS reports to meet specific end-user requirements. Designed and optimized SQL SSIS packages in Business Intelligence Development Studio (BIDS) for data extraction and transformation from diverse sources, including Access databases, Excel spreadsheets, and flat files.

●Supported application development teams in resolving database issues, enhancing SQL performance, and facilitating new releases, including debugging and addressing deadlock issues.

●Maintained and scheduled a variety of SSRS reports for stakeholders ranging from executives to customer representatives, significantly improving data accessibility and report accuracy.

●Supported Agile processes and Team Foundation Server (TFS) operations, contributing to streamlined project management and team collaboration.

●Engineered a data warehousing solution that integrated data from multiple systems, reducing reporting time by 60% and enhancing data accuracy.

●Optimized complex SSIS packages, improving the ETL process and cutting data processing time by 40%, while developing SSRS reports that increased organizational transparency and supported data-driven decision-making.

SunTrust Bank, Richmond, VA

ETL/ SSIS Developer

February 2016 — July 2019

Developed comprehensive data security requirements for all stages of data processing and constructed high-performance ETL processes using SSIS for data warehousing. Designed and implemented efficient ETL workflows in SSIS to populate data warehouses, and optimized T-SQL query performance by refining queries, joins, and indexes. Created, maintained, and optimized SSIS packages, including configuring SQL Server for package execution, scheduling jobs, and setting alerts and SQL Mail Agent. Developed a variety of T-SQL objects like functions, tables, views, triggers, indexes, and constraints to support data operations and validation.

●Designed and deployed enterprise-level reports using SQL Server Reporting Services (SSRS), incorporating features such as drill-down, parameterized, and linked reports, as well as dynamic matrices and charts.

●Demonstrated expertise in ETL processes using KingswaySoft Data Integration tools.

●Achieved a 40% reduction in data load times through ETL process optimization, enhancing the timeliness and accuracy of reports.

●Led the migration of ETL operations from legacy systems to a modern SQL Server-based platform, increasing data processing efficiency by 25%.

●Implemented a data validation framework within SSIS, improving data accuracy and reducing error rates by 20%.

●Scheduled and maintained automated report refreshes on daily, weekly, and monthly intervals to ensure continuous data accessibility and support decision-making.

●Conducted performance tuning across multiple databases, involving index adjustments, table partitioning, schema redesign, and the use of temporary tables and CTEs to enhance database operations. Delivered exceptional customer service and retention by surpassing expectations and proactively addressing any API, Single Sign-On, and data extract/report-related issues.

Education

Postgraduate in Computer Science, Grace College of Business and Computer Science, Addis Ababa, Ethiopia

Bachelor of Science in Mathematics, Addis Ababa University, Addis Ababa, Ethiopia

Associate Degree in General Studies, NVCC- Annandale, Virginia

Contact this candidate