Resume

Sign in

SQl/ ETL/ Report Developer

Location:
Washington, DC
Posted:
May 19, 2020

Contact this candidate

Resume:

Dawit T. Asfaw

addbpi@r.postjobfree.com

703-***-****

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.



Contact this candidate