Microsoft Office Information Technology

BISRAT ZERIHUN (US CITIZEN)

*************@*****.*** - 206-***-****

PROFESSIONAL

HIGHLIGHTS

EDUCATION

Strongly knowledgeable with relational and dimensional data model designs. Experienced on using Microsoft SQL Server packages and tools. Skilled in creating SQL queries along with database code. Sound communication and interpersonal skills.

Bachelor of Science in Information Technology

University of Washington Tacoma GPA 3.85/4.0

Associate Degree in computer science

South Seattle College GPA 3.7/4.0

EXPERIENCES

TECHNICAL

SKILLS/TOOLS

USED

SQL

• Normalizing, and created a database

• Wrote queries, and modify data by select, insert, update, delete, join, group by, and triggers, store procedures, functions

BI /Database Developer

• Wrote DDL and DML Queries.

• Created SSIS packages to data Execution, Transformation and Loading using SSIS ETL packages.

• Create, process and deploy packages.

• Created multidimensional cubes (OLAP cubes) using SSAS for data analysis.

• Create reports using SSRS.

System Development Life Cycle

• Managed and created a site for selling refurbished electronics and making system request, feasibility study, use cases, process model.

• Developed an architectural design and interface structure diagram, data models, data flow diagrams, storyboard and prototype, structure chart to implement and test plans. C-Sharp programming

• Wrote codes for virtual keyboard that mimics the actual keyboard, highlight when typing and counts the character, and a code for virtual calculator

• Wrote a code for airline reservation system

• Basic knowledge of lists, stacks, queues, trees, hashtables

• Wrote a code that eliminate duplication, calculating savings by car-pool, guess the number that is randomly generated game, and tic-tac-toe game

• Developed GUI that sorts an array of any number then searches for a single number.

• ASP.Net - Created web application for online schedule appointment by adding model, view and controllers, using CRUD operations, creating conection string and working with SQL server Local DB

King County sheriff office, Intern at Computer Resource Unit (Mar 2018 – May 2018)

• Creating, updating online training for sheriffs and other employees and posting it on their server using visual studio, PowerShell, and html

University of Washington Tacoma, Teaching Assistance (Mar 2018 – June 2018)

• Helping students with their SQL questions

• Making up assignments and exams also grading

Seattle university, Second assistance (Jun 2013 – Aug 2013)

• Converted hard copy files into electronic files

• Maintained and audited confidential student information, process and delivered interoffice mails

Software Applications and Languages:

• Microsoft .NET Technologies - Visual Studio for Business Intelligence.

• Database: Microsoft SQL Server 2012, SSIS, SSAS, SSRS.

• UI Technologies: HTML 5, CSS

• Others: XML, Microsoft Office Suite, Microsoft Visio, Microsoft Project, Unit test automation, Functional testing, Test execution,

• Modeling Software: Microsoft Visio.

• C-Sharp, GitHub, Agile Methodology

Contact this candidate