Sql Server Data

Ashenafi Taffa

Bowie, MD ***** • 240-***-****

*********@*****.*** • www.linkedin.com/in/ashenafi-taffa

SQL Server DBA/Developer

In-depth knowledge of data warehousing, business intelligence, SSIS, and ETL solutions and best practices.

Accomplished and results-focused professional with expertise in designing, installing, configuring, securing, and managing sophisticated SQL Server databases to maintain highly critical data. Utilize Microsoft BI stack to build data warehouses, clean and normalize data, perform data modeling, and develop complex queries for analyzing and reporting on key information. Ensure adherence to stakeholder requirements, contractual agreements, and quality standards.

Core Competencies:

Database Design & Management

Data Warehousing & Data Mart Concepts

Business Intelligence Reporting Solutions

Data Modeling / ER Model Design

Microsoft Excel / power point / Outlook

Database Performance Tuning

ETL Process Development & Execution

Data Standardization / Normalization

SSIS, SSMS & Enterprise Manager

Technical Proficiencies

Certifications:

Microsoft Certificate Solution Associate (MCSA) – SQL Server 2012/2014, Microsoft Technology Associate (MTA) – Database Fundamentals

Databases:

Microsoft SQL Server 2008, 2012, 2014, 2016

Process:

Extract, Transform, Load (ETL)

Tools:

SQL Server Integration Studio (SSIS), SQL Server Enterprise Manager, SQL Server Management Studio (SSMS), Visual Studio

Languages:

T-SQL, Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL)

Professional Experience

DDC Public Affairs, Washington, DC

Database Developer, 6/2017 – Present

Key achievements:

Create numerous simple to complex queries involving self joins, correlated sub queries, and CTE’s techniques for diverse business requirements. Tuned and designed database design, analyzing different query options, and indexing strategies.

Analyzed the business requirements and systematically designed a database working as a team. Employed best practices in creating a complete schema including tables, relationships, store procedure, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data suing CSV and SSIS.

Created ETL solution that reads Product, Vendor, and Order date from CSV files on a network share into a SQL server database.

Office of Refugee Resettlement, Washington, DC

Database Specialist, 5/2014 – 4/2017

Technical Scope: Microsoft SQL Server, SSIS, ETL, SQL Server Agent, DML, DDL, and DCL, SSIS Control Flow Tasks (For Loop / Foreach Loop / Sequential Containers, File System, Data Flow, Bulk Insert, FTP, SMTP, Execute SQL, Execute Process, Execute Package), Data Flow Transformations (Aggregate, Character Map, Condition Split, Data Conversion, Derived Column, Lookup, Fuzzy Lookup, Merge, Merge Join, Multicast, OLEDB Command, Slowly Changing Dimension, Sort, Union All, Row Count)

Designed, developed, and supported large and complex SQL Server databases in production and development environments. Worked closely with data management team, programmers, QA specialists, and security staff to plan and execute database-related projects, including data migrations and transfers using SSIS and ETL, ensuring a high level of efficiency. Performed data verification to ensure accuracy, authenticity, and relevance based on requirements stipulated by contractor agreements. Wrote intricate queries involving multiple table joins and advanced concepts (group by, having clause, union); optimized queries by creating clustered / non-clustered indexes and index views. Created database instances, tables, triggers, stored procedures, user defined functions, indexes, and other T-SQL statements for various applications. Normalized database tables.

Key Achievements:

Streamlined workflows and eliminated manual processes by deploying SSIS packages and scheduling jobs using SQL Server Agent to automatically run packages.

Spearheaded development and maintained data extraction, transformation, and loading (ETL) process.

Successfully managed and resolved database design issues during development phase in collaboration with development team.

Played key role in identifying Office’s IT requirements, worked with IT contractor to determine best practices for data storage and retrieval on new server, and assisted in maintaining legacy equipment.

Implemented business logic using triggers, indexes, views, and stored procedures.

United States Army, South Korea & Germany

Signal Intelligence Analyst, 11/2010 – 4/2014

Led research and analysis of communication signals intelligence to produce detailed reports of potential threats to national security, unusual activities, or other developments. Presented updates directly to senior leadership regarding critical situations and issues requiring immediate attention. Prepared weekly reports distributed to 40+ teams and key decision makers.

Key Achievements:

Maintained database of signal types and activities, ensuring metadata, queries, data restructuring, and signals development adhered to Department of Defense standards.

Expertly evaluated and interpreted 50+ records, operator logs, formats, technical reports, and graphic reproductions weekly to determine technical characteristics, structure, and usage of various signals.

Education

Bachelor of Science in Business Management

Kansas State University, Manhattan, KS

Contact this candidate