Summary of qualifications

A passionate, highly skilled and experienced professional with 3+ years of experience in data analysis and related fields. Awarded for proven work ethic and excellent communication skill and the ability to work effectively in a fast-paced environment. Some of my proven skills include,

•Solid understanding of relational databases.

•Have a proven experience in working in a fast-paced environment.

•Have proven ability of multitasking and working in variety of departments.

•Experience in working with relational databases in Microsoft SQL and Access.

•Experience in managing projects and working with a team.

•Experience in closely working with finance and human resource department.

•Excellent interpersonal skills.

Technical skills summary

•Microsoft office tools: Microsoft Word, Microsoft PowerPoint, Microsoft Excel

•Reporting Tools: SQL Reporting Service /SSRS/, Crystal Reports.

•Relational DBMS: Microsoft SQL Server 2008/2008R2/2012/2014/2016, DB2 Microsoft Access.

•Server operating systems: Windows Server 2003/2008/2008R2/2012

•Database Programming: T-SQL

•Data ETL tools: MS SQL Server integration services /SSIS/.

•Web Programming languages: CSS3, HTML/HTML5, JavaScript

•Programming Languages: Java, C++, C#, VB.Net

•Data analysis tools: ETL Packages, SPSS, Tableau

PROFESSIONAL EXPERIENCE

Non-stop Delivery

ERP (Business Analyst)/IT Analyst Chantilly, VA March 2019 -Present

Consolidating the logistics service agreement data from multiple business stakeholders and generate standard system configuration data

Streamlining the process for system configuration changes and document & optimize the internal working process

Troubleshooting shipment planning and execution issues and respond to questions from business teams

Communicating with various business teams to solve dependencies and clarify ambiguities.

Drive process optimization and productivity improvement.

Use Microsoft excel and its different functionalities to analyze and sort financial data

Rewriting SQL queries to optimize the performance of the system that is used by the company to handle all business

Writing SQL queries to design SSIS packages to handle data conversion from the legacy systems

Regularly asses current processes and work on new ideas to make things better, and present to team members

Create and activate accounts for new users in active directory

Review existing IT systems and internal processes; collect and analyze data to identify areas for improvement within the company

Use data visualization tools like Tableau and excel to present ideas to team members

Participate in team meetings; provide input on intelligent solutions to improve efficiency

Prepare documentation of processes and the organization of Information Technology systems used in the company

Give training for new employees about how to use our IT system

Howard University Hospital

Data Entry specialist/office administrator Washington, DC Oct 2018 – March 2019

Handled data entry and management using the web system

Generated reports periodically using Excel and crystal reports for payroll/finance department

Rewrote TSQL code in the back end of the web application used for data management in order to customize it for company use

Handled customer relation and technical support via mail and phone call with the outsourced providers of the web application

Provided excellent customer service to employees of the hospital working with our department

Prepared and present different presentations using about my department and help new employees get acquainted with our system

Worked with SPSS to for data analysis

DDC Public Affairs

SQL Server Database Analyst Washington, DC Feb 2018 – Apr 2018

Analyzed different financial and personnel data using Excel and MS SQL

Generated reports of the analyzed data for the finance and human resources department

Prepared Estimates for Database, table size growth.

Created Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Involved in Upgrading the MS SQL Server 2008R2 to MS SQL 2012.

Migrated DTS packages used for an ETL process to SSIS packages of a current SQL version.

Created documentation to install SQL Server, apply service packs, hot fixes and clustering installation.

Optimized queries by rewriting lines of SQL queries to have a better performance.

Redesigned and tested ETL packages.

EBS TV

Master Controller Silver Spring, MD May 2016 – Feb 2018

Responsible for monitoring the quality and accuracy of our on-air signals

Ensuring that the transmission meets government regulations and the station’s high standards

Troubleshot network issues and equipment malfunction

Prepare programs for play out

Performed word processing, spreadsheet, and data base work.

Maintained correspondence, forms, listings, files, reports, and automated personnel records and information.

Generated reports periodically using crystal reports

Assist staff with routine Master Control room related questions; serve as the first point of contact for employees – Assist company staff in solving Master Control issues.

Performed customer service functions by answering employee requests and questions.

Manage, organize and update files, records, correspondence, charts and reports – Perform Master Control office services such as: filing documents, printing reports and documents.

Assist management staff with various research projects and/or special projects.

Prepare new employee files.

Responsible for training and explaining the process of our division to new employees.

Assist with the preparation of the performance review forms

Handle discrete information related to employee relations, changes in the organization, performances, confidential information issues, and other sensitive broadcasting related matters.

Provide analytical support on projects as assigned.

General administrative support to the Master Control Team.

Worked with Windows Server 2008/2012 and work on Active directory managing users and their privileges.

Involved in virtualizing the present environment using VMware.

Education and training

•B.Sc. in Computer Engineering Addis Ababa institute of Technology, Addis Ababa University.

•Web development training, John Hopkins University

•Microsoft SQL Database development and administration, Duna tech training center

Reference

•Available upon request

Contact this candidate