Sql Server Power Bi

Solomon Getu

Phone: 240-***-**** Email: **********@*****.***

LinkedIn: https://www.linkedin.com/in/sol-assefa-g-a51aaa258/ PROFESSIONAL SUMMARY

Experienced and detail-oriented ETL Developer with over 8 years of expertise in designing, developing, and optimizing ETL processes. Proficient in a wide range of ETL tools and databases such as SQL Server, SSIS, Azure Data Factory, and Power BI. Skilled in data integration, transformation, and loading from multiple data sources into data warehouses and reporting platforms. Adept at identifying and resolving performance bottlenecks and ensuring high-quality data for analytical and reporting purposes. Strong background in data modeling, business intelligence, and agile project environments. CORE COMPETENCIES

ETL Development Data Integration Data Transformation

SQL Server (SSIS) Azure Data Factory Power BI

Data Warehousing Data Modeling Dimensional Modeling

SQL Queries Performance Tuning T-SQL

Data Migration API Integration Report Development (SSRS, Power BI)

Agile/Scrum Data Validation Problem Solving

TECHNICAL SKILLS

ETL Tools: SSIS, Azure Data Factory, SQL Server Data Tools (SSDT), Data Transformation Services (DTS)

Programming Languages: T-SQL, Python, PL/SQL

Database Management Systems: SQL Server (2012/2016/2017), Oracle, PostgreSQL

Business Intelligence: Power BI, SQL Server Reporting Services (SSRS)

Data Modeling: Star Schema, Snowflake Schema, Slowly Changing Dimensions (SCD)

Cloud Platforms: Azure, AWS

Office Tools: MS word, MS Excel, PowerPoint, Outlook and Visio

Other Tools: Visual Studio, SQL Server Management Studio (SSMS), MS Excel, Git, JIRA, Smartsheet

PROFESSIONAL EXPERIENCE

ETL Developer/ Data Engineer

Hines International February 2023 – Present

Designed, developed, and optimized ETL pipelines using SSIS for extracting data from various sources (SQL Server, flat files, APIs) and loading it into the data warehouse.

Designed and developed ETL packages to extract and integrate data using APIs with MySQL and PostgreSQL databases

Troubleshoot and debug API issues and Utilized API documentation and specifications

Utilized Azure Data Factory to automate data workflows and perform data migration from on-premises SQL databases to cloud platforms (Azure Synapse, Data Lake).

Built and maintained data transformation logic using T-SQL and SQL Server functions to ensure data integrity and consistency.

Created dynamic ETL packages for incremental and full data loads, reducing ETL processing time by 30%.

Developed Power BI reports for business stakeholders, providing actionable insights from raw transactional data.

Collaborated with business analysts and data architects to gather requirements and translate them into technical specifications.

Participated in Agile sprints, providing regular updates and collaborating with the development team to meet project milestones.

Environment: SSIS, Azure Data Factory, SQL Server 2016/2019, Power BI, Visual Studio, T-SQL, Agile/Scrum, JIRA, Microsoft Visio, Smartsheet ETL Developer / SQL Developer

Ally Financial October 2019 – January 2023

Developed and maintained SSIS packages for data extraction, transformation, and loading from source systems into a data warehouse environment.

Designed and implemented data pipelines using Azure Data Factory for cloud data integration and transformation.

Developed complex T-SQL Codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.

Wrote complex SQL queries to cleanse, transform, and aggregate data for reporting purposes.

Utilized Power BI to create interactive dashboards and reports for data analysis, including customer trends, sales performance, and operational metrics.

Generated Sub-Reports, Crosstab, Conditional, Drill-Down reports Drill-Through reports and Parameterized reports using SSRS.

Applied performance tuning techniques to optimize ETL processes, significantly reducing load times.

Collaborated with cross-functional teams to ensure data consistency, integrity, and availability.

Environment: SSIS, Azure Data Factory, SQL Server 2016/2017, Power BI, T-SQL, Microsoft Office

SQL Developer / ETL Developer

Kroger September 2016 – October 2019

Developed ETL workflows using SSIS to integrate data from diverse sources, ensuring high-performance data loads into a SQL Server data warehouse.

Created stored procedures, views, and functions using T-SQL to support data transformations and ensure data accuracy.

Optimized ETL jobs and SQL queries to improve overall performance, reducing processing time by 25%.

Created SSRS Summary Reports, Sub Reports, and Drill-down Reports (on demand and periodic) by using Expressions.

Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Email Task and Data Flow Tasks.

Generated SSRS reports and Power BI dashboards to deliver business insights to key stakeholders.

Worked in an Agile environment, collaborating closely with business analysts and project managers to meet deadlines and deliver high-quality data solutions. Environment: SSIS, SQL Server 2012/2014, SSRS, Power BI, T-SQL, Microsoft Excel EDUCATION

Bachelor of Arts in Economics

Addis Ababa University April 2007

Contact this candidate