Dawit T. Asfaw
addbpi@r.postjobfree.com
EDUCATION and TECHNICAL TRAINING
University of Maryland (UMCP)
Bachelor of Science, Information Systems
Bachelor of Science, Accounting
TOOLS AND TECHNOLOGY
RDBMS: SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014
Database Tools: SSIS, SSAS, SSRS
Reporting: SQL Server Reporting Services (SSRS)
Languages: Transact SQL (T-SQL), My/SQL, PL/SQL,
MS-Office: Microsoft Office Tools.
Operating Systems: Windows Server 2000, 2003, 2008, 2008R2
Tools: Backup Utility, Visio, Jira
Summary of Technical Skills
Excellent hands on experience at Requirement gathering, Design, and Implementation phases of the Software Development Life Cycle (SDLC) via Agile methodology
Proficient in Conceptual, Logical, and Physical Modeling of Databases.
Well versed with design and implementation of OLAP databases using Industry Standard Schemas Namely Star and Snowflake
Fluent in T-SQL programming language and designing and Implementation of Stored Procedures, UDFs, Triggers, Views, Tables, and CTEs
Excellent ability in creation of reports that are of tabular, matrix, chart, and parameterized form using SSRS
Experienced in developing configurable ETL processes from various heterogeneous data sources like Access, Excel, and CSV, flat files using various connectors, Tasks, and Transformations via SSIS
Experience in automation of various Database tasks using SQL Agent.
Excellent interpersonal, communication skills and ability for critical thinking and to work independently interacting with people at levels.
Professional Experience
SQL/ BI Developer Chantilly, VA January 2018 – January 2020
ASM Research
An Accenture federal services company
Responsibility
Participated in data designing architecture, data model and mapping process to load data based on business requirement and provided documentation.
Export and import data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.
Developed easily deployable SSIS Packages using Package variable and Configuration file to load data into Staging and Production.
Developed SSIS packages that employed various Transformation such as Lookup Transformations, Merge Joins, and Derived Columns
Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.
Involved in automating SSIS Packages using SQL Server Agent Jobs.
Configured various event driven e-mail notification process in SSIS packages.
Created audit database to handle SSIS error output and validate data.
Experience designing visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard tools.
Designed, developed, and deployed SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
Deployed SSRS report to Report Server.
Configured report server and report manager for SSRS report deployment and management.
Regular interaction with organization personnel troubleshoot problems arising in generated reports
Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
Wrote complex SQL queries that employ CTEs, Pivot Clause, Window Functions, Subquery (simple as well as correlated) based on business requirements.
Worked with various Aggregate SQL functions
Optimized SQL queries for improved performance and Reports rendering.
Evaluating techniques and technologies to propose an idea which will result in a positive impact on the company.
Wrote complex scripts for DML and DDL.
Scheduling Jobs and Alerting using SQL Server Agent
SQL\ BI Developer Washington, DC March 2012 – December 2017
Western Union Business solutions (WUBS)
Responsibility
Participated in the full Software Development Lifecycle (SDLC) phases including requirements, design, development, testing, and training
Worked in designing and optimizing various T-SQL database objects like tables, views, stored procedures, user defined functions, indexes, and triggers.
Consolidated data from various sources into a common data warehouse for reporting and analysis purpose using ETL (Extraction, Transformation and Loading).
Used various control flow and data flow tasks.
Developed and deployed SSIS packages using proper control and data flow elements with error handling.
Enhanced and deployed SSIS Packages from development server to production server.
Identified and resolved issues related to SSIS package configuration and deployment.
Maintained data integrity by performing data validation checks.
Wrote new complex T-SQL queries, stored procedures, and triggers, also modified existing ones.
Worked on designing reports using SQL Server Reporting Services (SSRS).
Created crucial store procedures and functions to support reporting dataset manipulation.
Wrote queries for drill down reports to get the dataset required.
Experienced in formatting reports, writing costumed codes, and using them in the expressions.
Performed database recovery and backup tasks on daily and weekly basis.