Resume

Sign in

SQL / BI Developer

Location:
Washington, District of Columbia, United States
Posted:
November 28, 2017

Contact this candidate

Dawit Asfaw

ac3imj@r.postjobfree.com

703-***-****

EDUCATION and TECHNICAL TRAINING

University of Maryland(UMCP)

Bachelors of Science, Information Systems

Bachelors of Science, Accounting

TOOLS AND TECHNOLOGY

RDBMS: SQL Server 2000, 2005, 2008, 2008R2 and 2012

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, Lite Speed for SQL Server, Visio

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.

Work Experience

SQL\ BI Developer Washington, DC March 2012 – Present

Western Union Business solutions (WUBS)

SQL Developer (Intern) Takoma, MD March 2011 – February 2012

Montgomery College

PROFESSIONAL EXPERIENCE

Involved with full development cycle of a Data Warehouse, including requirements gathering, analysis, design, evaluating products, implementation, and maintenance.

Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, and other Data Warehouse concepts.

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 Data Warehouse systems.

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.

Responds to Tier 2 production issues, troubleshooting data reporting and ETL by analyzing and developing solutions.

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.

Designed reports using filters, single value parameters, multi value parameters, dependent parameters, and cascading parameters.

Regular interaction with organization personnel to give training and troubleshoot problems arising in generated reports, and SQL server environment

Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.

Used Tools like Visio to design and Implement Data modeling used to construct OLAP and OLTP Databases.

Wrote complex SQL queries that employ CTEs, Pivot Clause, Window Functions, Subquery (simple as well as correlated) based on business requirements.

Excellent in building parameterized Store Procedure that employ Transaction as well as error handle.

Worked with various Aggregate SQL functions

Optimized SQL queries for improved performance and Reports rendering.

Recommends new work methods and training on new developing technologies and solutions.

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.



Contact this candidate