Senior SQL Server BI/Data Warehouse Developer

Name: Gebru Mengiye

Email: ********@*****.***

Phone: 571-***-****

Professional Summary

More than 7 years of experience in Database Design, Database Development, Testing, and Implementation of Business Intelligence/Data Warehouse Solutions using Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R2/2008/2005

Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.

Responsible for designing test cases for testing the ETL packages.

Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.

Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).

Performed data cleansing using different transformations within SSIS packages to eliminate redundant data from the pre-staging database.

Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.

Hands on experience with Erwin to forward and reverse engineer data models.

Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices.

Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.

Experienced in all the stages of Software Development Life Cycle and in the migration and upgradation of databases.

Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization.

Monitored and tuned the performance of Complex T-SQL queries and stored procedures by analyzing the execution plan and also using tools like SQL Server Profiler.

Optimized cubes by assigning appropriate storage modes to partitions and created usage-based optimizations for better query performance.

Worked on data import from different file systems including XML, text, and CSV and Excel files.

Created partitions on tables, indexes and index views as well as querying and managing partitions from optimization point-of-view according to the business criteria.

Consumed RESTful Web services.

Experienced Power BI Developer with a strong background in designing, developing, and deploying interactive and insightful business intelligence reports and dashboards.

Proficient in connecting to various data sources, transforming raw data using Power Query and DAX, and creating data models that support effective decision-making.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2016/2012/2008R2/2008/2005, MySQL, Oracle Reporting Tools: SQL Server Reporting Services (SSRS), Excel 2016/2013/2007, Tableau 10/9/8, Power BI

Power BI Desktop & Power BI Service

Report design & data visualization best practices

Languages: T-SQL, PL/SQL, C++, C#

ETL: Server Integration Service (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Data Quality Services, Talend

Data Warehouse/OLAP: SQL Server Analysis Services (SSAS)

Development Platforms: Visual Studio 2015/2010/2008, SharePoint 2013/2010

Project Management: JIRA, Slack, TFS, Microsoft Project, Microsoft Visio

Agile methodology collaboration

Professional Experience

Ban of Texas

July 2022 to Present

Role: SQL/ETL/ Power BI Developer

Responsibilities:

Interact with Business Analysts and Developers in identifying the requirements, designing strategies and implementing a reusable Database Schema.

Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# code as required.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Experienced in slowly changing dimension in SSIS packages.

Performed incremental data load packages in SSIS.

Developed, monitored and deployed SSIS packages.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.

Responsible for fine tuning of the database, troubleshooting, memory management.

Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

Created reports based on database usage and perform capacity planning.

Optimized stored procedures and indexed query using Index Tuning Wizard.

Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

Identified and Defined Fact relationships in SSAS.

Responsible for debugging applications using the tools provided by Visual Studio 2008.

Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Provided technical assistance for all phases and support service of NET projects.

Transformed data using Power BI query editor to meet project requirements.

Migrated reports from SSRS to Power BI.

Developed visually appealing reports in Power BI Desktop and deployed them on Power BI Report Server and Power BI Service.

Implemented Data Analysis Expression Language (DAX) calculations, measures, and report parameters to optimize report performance.

Designed intuitive reports and dashboards with features such as Filters, Drill-down/Drill-through Reports, and Sub-reports.

Utilized Power BI's data modeling capabilities to map filters to Facts and Dimension Tables

Environment: MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, .Net, Visual Studio 2008, Azure

H&E Equipment Services, Inc.

ETL / SQL/ Power BI Developer

May 2019 to June 2022

Responsibilities:

Performed Data Modeling and Developed logical and physical model using Erwin and implementing them to SQL server.

Written custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Developing Stored Procedures and Functions used for inserting, updating, or transforming data.

Developing complex T- SQL queries used for data investigation.

Creating table indexes and constraints to ensure data integrity and enhance query processing.

Sourced data from various types of relational databases, flat files, excel files.

Created story points for different dashboards involving lot of category divisions.

Involved in creating and visualizing dashboards using Tableau Desktop.

Generated Dashboards by joining multiple complex tables.

Exported reports from Tableau desktop to Tableau server.

Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information, and other important data.

Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.

Designed, coded, and implemented ad hoc reports using existing report models in SSRS.

Generated computed tables in Power BI by using Dax.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

parameterized reports using Variables, Expressions and Functions for the reports

Managed Alerts for successful or unsuccessful completion of scheduled Jobs.

Spearheaded the development and successful implementation of a critical Power BI solution.

Design and develop intuitive Power BI dashboards that facilitate clear understanding and informed decision-making for both internal teams and stakeholders

Designed and managed Power BI reports and dashboards to deliver actionable insights to a wide range of business stakeholders, enabling informed decision-making and strategic planning.

Environment: Microsoft SQL Server 2012,2008R2, SSIS, SSRS, Tableau, Cognos, SQL Profiler, SharePoint 2010, JIRA, TFS, XML, XSLT, XSD, Microsoft visual Studio 2010, SSAS, Power Pivot, Power View

SQL/ETL Developer

Safeway

August 2017 – May 2019

Responsibilities:

●Developed Stored Procedures and Functions used for inserting, updating, or transforming data. Also, created scripts for tuning and scheduling.

●Created new tables and wrote stored procedures, triggers for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.

●Creating table indexes and constraints to ensure data integrity and enhance query processing and come up with efficient data retrieval.

●Extensively involved in created SSIS packages to migrate data from different data sources to data warehouse.

●Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas and Snowflake Schemas.

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

●Importing Source/Target tables from the respective databases by using Execute Package Task using Control Flow Tasks in SSIS.

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

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.

●Scheduled the ETL Package, Email, and Stored Procedures.

●Developed different reports and visualization solutions for internal and external reporting purposes.

Environment: MS SQL Server, MS Visual Studio (SSIS/SSRS), Power BI, Microsoft Excel, Outlook, MS SQL Profiler, Windows Server.

Bachelor’s degree in computer science

Master of Business Administration (MBA)

Contact this candidate