Design Engineer Data

ADONAI O. YOHANNES

**** ***** ****** **., *** # B

Charlotte, NC 28205 • 919-***-****•

adi3xy@r.postjobfree.com

Summary

Highly-motivated SQL/BI Developer with over 6 years of progressive work experience in developing and supporting SQL Server database development, Report design, ETL Development using SSIS, Data analysis and visualization, plus excellent knowledge of Power BI.

EDUCATION

University of North Carolina at Charlotte - Charlotte, NC Sept 2015-May 2018

Bachelor degree in Engineering

Average GPA 3.25/4.00

Wake Technical Community College Jan 2013-June 2015

Transferring class

Average GPA 3.6/4.00

TOOLS AND PROGRAMMING LANGUAGE SKILLS

Relational DBMS:

SQL Server

BI and Data Analytics Tools

SQL Server Reporting Services (SSRS),

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

Power BI

CAD modelling tools

SolidWorks

Creo-Parametric

Visio

WORK EXPERIENCE

BI/SQL Database Developer July 2019- Current

Uni-Systems

Developed SQL queries and stored procedures to generate reports, Dug into database details to ensure appropriate data filters are applied based on business requirements

Tuned SQL Queries for optimizing performance

Created Try - Catch error handling and triggers using Transaction SQL

Created stored procedures for incremental loading using merge statement

Built extract, transform, and load (ETL) process to migrate data from multiple types of data source (SQL Server, Excel, Flat files, email Boxes, XML files, etc) to destination database server and Data Warehouse by using SSIS packages

Used SSIS Control flow items such Execute SQL Task, File System Task, Script Task, Foreach Loop container, and Execute Package Task to create/modify daily ETL processes

Performed transformations in SSIS such as Derived column, Data Conversion, Conditional split, Lookup, Row Count, slowly Changing Dimensions etc to carry out required transformation

Created SSISDB catalog with SQL Server to support SSIS package deployments in SSMS

Responsible for implementation of data viewers, Logging configuration, Error and Event Handling, Precedence Constraints, Break Points, Check Points, and Scheduled jobs to execute tasks periodically

Developed, deployed, and monitored SSIS Packages

Created Sub-reports, Drill down-Reports, Summary Reports, and parameterized Reports in SSRS

Generated tabular reports, charts and graphs using SSRS and deployed to web applications

Design Engineer

Vision Metering York, SC Feb. 2019- July 2019

Carrying out duties of Design Engineering Department, including design, research, prototyping, 3D printing, and engineering documentation

Prepare detailed engineering drawings using SolidWorks for specific element of products, being developed or improved per project plan and schedule consistently with assigned project and product line objective

Created new designs and models mostly safe box cages of electrical utilities, testing fixtures, and equipment

Using SolidWorks modified drawings by analyzing, resolving, and incorporating changes

Created and managed bills of materials, specify quote and procure designed parts to be printed with desired material

Engineering documentation, arranging modified folders in a way easily accessible

SQL Server (SSIS/SSRS) Developer March 2013 - Jan. 2017 (Part Time)

Aug, 2009 - May 2011 (Full time)

Uni-Systems Malta, EU

Gathered business requirements by interacting with the Business Analysts.

Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS)

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction

Designed and implemented Stored Procedures and Triggers for automating tasks

Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill-through features in MS SSRS

Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes)

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc

Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)

Created Star and snowflakes schema cubes, managed OLAP Cubes using SSAS, and worked on OLAP cubes using SSAS

Updated existing and created new reports using Microsoft SQL Server Reporting Services.

Presented excellent work attitude and communication skills with multiple teams/department

Junior Database Developer, Nov. 2008 – Aug, 2009

Mr. Green/ Gutenburg.P. Malta, EU

Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic

Extracting, transforming and loading data into data warehouse with SSIS

Created reports with SQL Server Reporting Services

Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill-through features

Created tables and visualizations in MS Excel which involved frequent use of logical function

Designing and implementing cubes, perspectives, Partitions, dimensions, hierarchies, attribute relationships

Used SSIS data flow such as using Derived column, Data Conversion, Conditional split, Lookup, Row Count, slowly Changing Dimensions for daily/monthly ETL processes

Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using SSIS

Perform data analysis, including data profiling, to obtain a good understanding of data availability and relationships for consideration of BI solution design

Contact this candidate