Biruktawit K.

About Biruktawit K.

I am an experienced SQL Database and ETL Developer with over 5 years of expertise in designing, implementing, and optimizing data solutions. My skill set spans SQL Server, data warehousing, and business intelligence tools, including SSMS, SSIS, SSRS, and Power BI. I have a proven track record in building and managing relational databases, enhancing performance through query optimization, and developing complex ETL processes to handle large-scale data migration and transformation. My experience extends to working in Agile environments, collaborating closely with cross-functional teams to deliver data-driven solutions that support business objectives. Let’s connect if you\'re looking for someone with a strong technical foundation, a problem-solving mindset, and a collaborative approach to data development and reporting.

Experience

1. Etl Ssis Developer

   Rsi

   Jan 2023 — Present

   Designed, developed, and optimized ETL workflows using SSIS to integrate data from various sources (CSV, Excel, Oracle, MS SQL), applying transformations that improved processing efficiency. Automated these workflows using SQL Server Agent, reducing manual effort and ensuring timely data updates.• Developed complex T-SQL queries, stored procedures, and views to manipulate large datasets, leveraging indexing and execution plans to enhance performance to support seamless data retrieval for reporting and analytics.• Utilized joins, as well as correlated and non-correlated sub-queries, to develop complex business queries involving multiple tables across different databases, ensuring accurate and efficient data retrieval.• Enhanced reporting and data visualization by designing interactive dashboards in Power BI and SSRS, utilizing drill-down, parameterized, and cross-tab reports to provide actionable insights and improve decision-making.• Updated and maintained stored procedures, views, and functions utilized by the Conversion and Implementation Teams. • Employed file system tasks to archive processed files, executed SQL tasks to insert transaction log data into SQL tables.• Troubleshot and resolved data-related issues by debugging SSIS workflows and optimizing SQL queries, reducing system downtime and improving data accuracy for critical business operations.• Collaborated in Agile/Scrum environments, participating in sprint planning and cross-functional meetings to ensure efficient execution of data solutions that met business objectives.

Education

• George Mason University

  Bachelor of Science - BS