Name:- Filmon Dessalegn

Phone:- 301-***-****

Email:- ad4awr@r.postjobfree.com

PROFESSIONAL SUMMARY:

●7+ years of experience in Database Design, Development, Implementation, and Tuning of Relational Database Systems using MS-SQL Server 2008R2/2012/2014/2016/2017.

●Experienced in managing SQL Server and writing T-SQL (DDL, DML and TCL) statements; and in creating and maintaining SQL Server database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.

●Experienced in optimization and performance tuning.

●Skilled in using table variables and Common Table Expressions (CTEs).

●Expertise in developing complex SQL queries and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Native tools.

●Experience in Extraction, Transformation and Loading (ETL) tools, including Tableau, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), ETL package design, and RDBM systems.

●Experienced in designing SSIS packages for different Data Flow and Control Flow processes.

●Skilled in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, and Snowflake Schema.

●Well experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

●Generated various Drill-Down Drill-Through reports, Parameterized reports, Tabular reports, and Matrix reports using SQL Server Reporting Services (SSRS).

●Managing and securing reports using SSRS. Created report schedules.

●Experienced in developing Business Intelligence (BI) solutions for Decision Support Systems using SSIS, SSRS, SSAS, and Power BI.

●Expertise in Data Modeling using SSMS, Erwin.

●Worked with stakeholders and end users to meet business requirements and experienced in the proper documentation of records.

●Experienced in developing and maintaining data warehouse’s functionality; and developed multi-dimensional objects and Cubes using SQL Server Analysis Services (SSAS).

●Experienced with working on Agile Projects with multiple Sprints Cycles and Scrum meetings, and on Water Fall projects with full Software (System) Development Life Cycle

●Strong interpersonal and communication skills; competitive analytical, logical, and problem-solving skills; strong management, administrative and leadership skills; and active and self-learning abilities.

●Detail oriented, working under pressure, and meeting short deadlines with exceptional problem solving and decision-making analytical skills and strong teamwork spirit.

EDUCATION

Bachelor’s degree

TECHNICAL SKILLS:

●DBMS/RDBMS: MS-SQL Server (2017/2016/2014/2012/2008

●ETL Tools: SQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), Tableau, Data Transformation Services (DTS) and T-SQL

●Reporting Tools: SQL Server Reporting Services (SSRS

●Programming Languages: T-SQL, PL/SQL

●Tools: Microsoft SQL Server Management Studio, Visual Studio.

●Operating Systems: Windows Server 201/2008/2012R2.

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

PROFESSIONAL EXPERIENCE:

SQL Developer/ETL Developer

Bank of Texas

November 2020 - Present

Responsibilities:

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

●Used Joins, Correlated and Non-Correlated Sub-Queries for complex business queries involving multiple tables & calculations from different databases.

●Use Azure Data Factory to copy data from On Prem Server to Azure Synapse, created Copy Activity

●Experienced with Dynamic SQL and developed procedures utilizing the functionality.

●Used SSIS to create ETL packages to Extract, Transform and Load data to Data Warehouse and Data Mart Databases.

●Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.

●Extracted data from different sources (CSV, Excel, and MSSQL and Oracle database sources) and load to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.

●Provide Data Lake Access to various groups and users using the ACLs in Azure storage explore

●Developed SSIS packages using For Each Loop Container in the Control Flow

elements to process all Excel files within folder; File System Task to move file into Archive after processing; and Execute SQL task to insert transaction log data into the SQL Table.

●Well experienced in using Table Variables and Common Table Expressions (CTEs).

●Scheduled Jobs for executing the stored SSIS packages which were developed to update the database using SQL Server Agent. Also, involved in deployment of SSIS Packages.

●Used advanced features of T-SQL to Design and Tune T-SQL to interface the database and other applications in most efficient manner.

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

●Created customer trend visualization in Power BI from dedicated Synapse server source

●Created reports to retrieve data using Stored Procedures that accept parameters.

●Experience on working in Agile/Scrum environments.

Environment: MS SQL Server 2016/2017, DTS, MS Access, SQL Query Analyzer, MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), TSQL, PL/SQL, SQL Profiler, Windows Server 2008/2012, Microsoft Office.

Database Developer

GEICO

January 2017 - October 2020

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 2012/2014, MS Visual Studio 2012/2014 (SSIS/SSRS), Power BI, Microsoft Excel, Outlook, MS SQL Profiler, Windows Server 2008/2012.

Contact this candidate