Sql Server Azure Data

Degefa Ergcho

678-***-**** ****************@*****.*** Linkedin Atlanta, GA

Summary

• Over 9 years of IT experience in Database Design, Development, Implementation, and Support using various database technologies (SQL Server 2008/2012/2015/2016/2019, 2022 T-SQL, Azure Big Data) in OLTP, OLAP, and data warehousing environments.

• Expertise in SQL Server and T-SQL (DDL, DML, DCL) for constructing tables, joins, indexed views, indexes, complex stored procedures, triggers, and functions to facilitate efficient data manipulation and consistent data storage.

• Strong technical knowledge in SQL Server BI Suite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS, and third-party tools.

• Proficient in Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, and Azure Storage Explorer for managing Big Data platforms in Azure Cloud.

• In-depth knowledge of Snowflake Database, schema, and table structures, including data sharing.

• Skilled in SQL Server Performance Monitoring and Tuning.

• Experienced in Data Modeling, Database Design, and normalization techniques using tools like Erwin and database diagrams.

• Expertise in creating, debugging, configuring, and deploying ETL packages using MS SQL Server Integration Services (SSIS).

• Proficient in configuring SQL Server Reporting Services (SSRS) for job scheduling, user permissions, and report management.

• Experienced in developing OLAP data marts and cubes using SQL Server Analysis Services

(SSAS), including partitions, KPIs, perspectives, and slow-moving dimensions.

• Experience with a public cloud, including AWS, Microsoft Azure, or Google Cloud

• Skilled in creating OLAP cubes, calculating measures, and dimension members using MDX and user-defined functions.

• Adept at creating Requirements Documentation for various projects.

• PowerPoint Proficiency: Skilled in creating engaging presentations using advanced features such as tables, charts, and multimedia elements.

Experience

Analyst Sr, Data Analytics

Southern Company Jun 2022 – Present

• Collaborated with business stakeholders to define project scope and requirements, resulting in the successful implementation of workflow automation solutions that enhanced data processing efficiency

• Developed, tested, and optimized ETL processes using SSIS.

• Led SSIS package migrations from legacy systems to newer SQL Server versions with minimal downtime.

• Proficient in Remedy ITSM for incident, problem, and change management.

• Engaged in automating SSIS Packages using SQL Server Agent Jobs.

• Developed shared dimension tables, measures, hierarchies, levels, cubes, and aggregations using Microsoft OLAP, OLTP, and Analysis Server (SSAS) within the Tabular Model framework.

• Executed Copy activities and customized Azure Data Factory pipeline activities to enhance data processing workflows.

• Led data migration efforts utilizing SQL, SQL Azure, Azure Storage, Azure Data Factory, SSIS, and PowerShell to ensure seamless data transitions.

• Specialized in troubleshooting and fixing overnight ETL job failures to ensure data availability.

• Designed ad-hoc reports and dashboards for data-driven insights.

• Collaborated with offshore teams for project deployments and production troubleshooting.

• Ensured smooth deployment of projects into production with minimal disruption.

• Identified and resolved performance bottlenecks in ETL workflows and SSIS packages.

• Implemented and managed Apache Kafka for real-time data streaming and processing, ensuring high availability and fault tolerance in data pipelines.

• Designed and deployed Cloudera-based solutions for big data analytics, leveraging Hadoop ecosystem tools to optimize data storage and processing workflows.

• Configured and maintained Kafka clusters, focusing on performance tuning and monitoring to support high-volume data ingestion and microservices architectures.

• Collaborated with cross-functional teams to integrate Kafka with existing systems, enhancing data flow and enabling real-time analytics capabilities.

• Analyzed Requirements and created business requirement document (BRD), current business process flow, future business process flow, use case diagrams, and activity diagrams using Microsoft Visio.

BI/SQL Developer

Bank of America Apr 2019 – June 2022

• Involved in creating complex ad-hoc reports, sub-reports, linked reports, charts, and drilling through report models and drill reports.

• Worked as ETL Lead/Developer on a time-constraint and obvious project.

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple information sources.

• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler, and third-party tools

• Involved in overnight job fail fixes and monitoring daily job runs.

• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.

• Worked on creating DAX Expressions and implementing Partitions in Tabular models.

• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.

• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS, PowerShell.

• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces and apps, and get quick insights about datasets

• Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers

• Created notifications and alerts, subscriptions to reports in the Power BI service

• Utilized Dataflow with multiple transformations for Incremental loads and truncate reloads

• Provided orientation to new developers for ETL, Data model and sourcing framework.

• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning. Modified

existing SQL queries using Views, Indexes, Triggers, Roles, Stored procedures.

• Developed and delivered presentations for quarterly business reviews, utilizing PowerPoint to effectively communicate complex data and insights, which contributed to a 20% increase in stakeholder engagement

SQL/Power BI Developer/Analysis

Equifax Apr 2018 to March 2019

• Created T-SQL scripts for tables, views, functions, triggers, and indexes. Worked with Microsoft Power BI desktop to create reports and Dashboards based on business requirements. Created Power BI Templates that are currently being used for daily report generation.

• Optimized queries and database performance using graphical tools SQL Profiler, Query Execution Plan, Index Tuning Wizard, etc.

• Performed database troubleshooting, management, backup, restore, and Point time recovery.

• Performed database routine maintenance Re-indexing, Query tuning, and performance tuning.

• Imported/exported (Migrated) data between different sources like SQL/ Oracle/ Access/ Excel/ Flat Files using DTS, SSIS & BCP, and Import/Export wizard.

• Created and maintained SSIS Package SQL Agent Jobs. Created complex SSAS/Mondrian cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.

• Performed Installation and configuration of SQL Server 2008 R2 and DB migrations from SQL 2005 to SQL server 2008R2.

• Scheduled maintenance activities to vacuum and analyze to improve the query response time.

• Maintained custom vacuum strategies at table and database levels. Tuning auto vacuum parameters to ensure up-to-date table stats and reclaim space consumed by dead tuples. Loaded data using SQL Loader and DB link tool.

• Generated parameterized reports, ad-hoc reports, sub-reports, and tabular reports using SSRS. Created functional technical specifications.

• Managed and Assign tickets queue using BMC Remedy. Assigned, prioritized, suspended, escalated, and closed tickets. Reply to users.

• Advised team members on the most efficient database designs and helped in writing complex queries.

• Provided 24/7 Production Support for the maintenance & scheduling of reports.

• Created and configured applications in multiple environments DEV/TEST/PROD.

• Created, maintained & scheduled reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports

• Led Tableau to Power BI migration, optimizing reporting and improving data accessibility.

• Managed end-to-end migration, ensuring smooth transitions and minimal disruption.

• Developed data models and interactive dashboards in Power BI for better decision-making. SQL/BI Developer

Verizon May 2015 to Apr 2018

• Worked closely with the business to analyze and consolidate request requirements to improve the decision-planning process and meet project deadlines.

• Defined data requirements and report layouts for the business to review. Created user stories and scripts based on requirements.

• Generated parameterized reports, ad-hoc reports, sub-reports, and tabular reports using SSRS

• Utilized Dataflow with multiple transformations for Incremental loads and truncated reloads

• Provided orientation to new developers for ETL, Data model, and sourcing framework.

• Used Query Analyzer, Index Wizard, DB Engine Tuning, and SQL Profiler for performance tuning. Modified existing SQL queries using Views, Indexes, Triggers, Roles, and Stored procedures.

• Worked as ETL Lead/Developer on a time-constraint and highly visible project.

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple information sources.

• Introduced SSRS to help the existing reporting process and designed and developed SSRS. Created parameterized reports and linked reports and thorough knowledge of report server architecture using SSRS.

• Designed ad-hoc reports and dashboards using OBIEE Oracle Business Intelligence Enterprise Edition. Performed minor administrative duties creating folders, monitoring jobs, and security- related tasks.

• Leverage enterprise business intelligence tools, SQL queries, and other tools to develop complex models and reports. Create functional/technical specifications to document the design approach.

• Perform analysis for new BI reporting requests, including working directly with end-users across teams within their transactional and operational environment Education

• Bachelor of Accounting Atlas University

• Associate Degree in Applied Science, Database Specialist Georgia Piedmont Technical College

• Bachelor’s Degree in Software Development and Security University of Maryland Global Campus

Certifications

• Big Data Certified

• Six Sigma Green Belt

• AZ-900 Microsoft Azure Fundamentals certified

Skills

• Tools & Platforms: MS Office Suite, SharePoint, SharePoint Designer, MS Visio, MS Project, Subversion, Git GUI, Bitbucket, TFS, Jira, Power BI Server, RapidMiner, Python, Access Database.

• Databases: SQL Server, MySQL, Azure SQL Database.

• Languages & Technologies: HTML/XML, WSDL/SOAPUI.

• BI & Analytics Tools: Power BI, SSIS, SSRS, SSAS.

Contact this candidate