Mekdim Zemene

Wylie, Texas, United States Email: ad02bu@r.postjobfree.com Phone: 903-***-****

Linkedin: linkedin.com/in/mekdim-zemene-3b97b9292

Summary

SUMMARY

● MS SQL Server Developer and ETL Developer with 6+ years of strong experience in various domains like Financial, Retail and insurance with expertise in MS SQL Server 2012/2008R2/2008/2005/2000 and SSIS, SSRS, SSAS.

· Proficient in installing, configuring, managing, monitoring, and troubleshooting MS SQL Server 2022/2019/2016/2012/2008/2008R2.

· Developed Logical and physical data model using ERWIN, ER Studio and mapped the data into database objects.

· Generated sub reports, crosstab, conditional, drill down reports, drill through reports and parameterized reports using SSRS 2012

· Introduced best practices for Data Services and Crystal Reports development.

· Expert Crystal Reports, stored procedures and Share point on SQL Server database

· Strong MS SQL Server 2012/2008/2008R2/2005 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.

· Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).

· In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).

· Strong in ETL, Data warehousing, Operations Data Store concepts, data marts, OLAP and OLTP technologies.

· Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

· Designed and built SQL dashboard for reporting to allow ad hoc reports for management and Intelligence.

· Developed reports & Dashboard by using excel services and business Intelligence.

· Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

· Extensive experience in Enterprise Data Management (MDM, BI/ETL) as a developer, business Intelligence.

· Experienced in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.

· Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

· Mastery in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.

· Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary MS SQL Server database Service packs, hot fixes and Security Patches.

· Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

· Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

SKILLSETS

· RDBMS: MS SQL Server 2019/2016/2012/2008R2/2008/2005, MySQL, Oracle

· Reporting Tools: SQL Server Reporting Services (SSRS), Excel, Tableau, Power BI

· 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 Experience

Business Intelligence Developer / ETL Developer

State Farm Insurance Inc

Nov 2020 - present

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; Collaborate with cross functional team of web and SQL developers, Testers, Product and product managers, client services and IT software development lifecycle to deliver dynamic, high-quality software and reporting and integration solutions.

● Design and develop SQL Server stored procedures, functions, views and triggers to be used during the

ETL process.

● Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems.

● Develop SSIS package and debug and tune SSIS or other ETL processes to ensure accurate and efficient

movement of data.

● Design, implement and maintain database objects (tables, views, indexes, functions, stored procedure,

triggers ) and database security.

● Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations.

● Test and prepare ETL processes for deployment to production and non-production environments. ● Plan, coordinate with stakeholder, develop and support ETL process including architecting table structure, building ETL process by using SSIS, prepare documentation and meet all the defined requirements of the project.

● Design, develop stored procedures and build SSRS reports based on business requirements.

● Extensively working on upgrade process enhancements develop, implement and optimize stored procedures, Triggers and Functions using T-SQL.

● Worked on loan document management (LDM) it enhanced the existing features to make a document and image review easier modifying stored by adding some functionality to stored procedures and triggers.

● Involved in daily DBA activities like (DB review, Merge and prepare script for migrations and debugging

Mekdim Zemene - page 1

errors)

● Analyze existing SQL queries for performance improvements and suggesting and developing new queries.

● Participates in review of potential technical architectures and solutions to improve and enhance existing systems, processes.

● Working experience on Agile and Jira Environment.

● Effectively prioritize and manage concurrent projects, demonstrate initiative. Environment: MS SQL Server 2019/2017/2014/2012, Visual Studio (TFS),Windows Server 2003,2008R2 and 2012, T-SQL

MS SQL Server/SSIS Developer

Expedia Group

Nov 2017 - Oct 2020

Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.

● Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

● Successfully implemented indexes on tables for optimum performance.

● Extensively used Joins and Subqueries for complex queries involving multiple tables from different databases.

● Worked extensively on query optimization and performance Tuning.

● Designed and Developed SSIS packages for performing ETL process using SQL Server Integration Services.

● Worked using integration services for transferring and reviewing data from heterogeneous sources like

(Flat file, Excel, CSV, Oracle, MS Access).

● Worked on Data Mapping extensively.

● Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.

● Strong working experience in Design, Development, Implementation and Testing of Data Warehousing

using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL). ● Developed several detail and summary reports including line and pie charts, trend analysis reports and subreports according to business requirements using SQL Server Reporting Services (SSRS). ● Expertise in Data Analysis, Understanding in Dimensional Data Modeling, Data Extraction, Transformation & Loading

(ETL)

● Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the multi-dimensional data warehouse.

● Developed complex stored procedures for daily, weekly, monthly and yearly finical summary reports.

●

Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and tested the packages for Incremental Data Load & duplications.

● Experience in scheduling SSIS batch jobs using SQL Server Agent

● Create dashboards and interactive visual reports using Power BI desktop.

● Identify key performance indicators (KPIs) with clear objectives and consistently monitor those.

● Analyzing data and present data through reports that aid decision-making

● Convert business requirements into technical specifications and decide timeline to accomplish

● Mekdim Zemene - page 2

Create customize charts and custom calculations as per requirements.

● Work with users and team members at all levels for performance improvement and suggestions Environment: MS SQL Server 2016/2014/2012, Windows Server 2008R2 and 2012, T-SQL, Redgate SQL compare and Multi Script, Visual Studio 2012, Power BI, SSDT, GitHub, Jira

Education

Addis Ababa University, Ethiopia

Bachelor Degree, Computer Science

Skills

Data analysis • data modeling • data transformation service • SQL Server Integration Services (SSIS) • Microsoft SQL Server • SQL Server Reporting Services (SSRS) • Transact-SQL (T-SQL) • SQL Server Management Studio

Mekdim Zemene - page 3

Contact this candidate