Business Intelligence Sql Server
Resume:
HENOK TEREFE
** ******** ** *** ****** MA ***** *****.*********@*****.*** +1-781-***-**** www.linkedin.com/in/hterefe US Citizen
SUMMARY OF QUALIFICATIONS
●Managed all database-related tasks as a Sole DBA at my last position ( Overseeing database design, maintenance, and troubleshooting)
●Exceptional attention to detail, organizational, communication and time-management skills
●Goal oriented individual with the capability of efficiently completing projects within specific deadlines
●Manage multiple tasks at once, with strict adherence to time constraints
EDUCATION
University of Massachusetts Boston, Boston, MA December 2016
Bachelors of Science in Information Technology – Business Intelligence Concentration
Cumulative GPA 3.4
RELEVANT EXPERIENCE
SQL Engineer
PayScale • Full-time
Oct 2020 - Jul 2023 2 yr 10 mos
Burlington, MA
Responsibilities Include :
Manage SQL Server on Azure VM / Azure SQL/
Managed multiple Instances
Implement resilient and performant database processes and solutions
Develop custom stored procedures, views, user defined functions and triggers
Write Adhoc T-SQL Programming / DDL / DML statement
Work on data tickets on JIRA to solve data related issues
Debug and tune/optimize SQL code either directly or indirectly from application
Support development team with database requests as needed (including bug fixes, production data manipulation, and feature testing)
On-call duty responding to critical DB alerts / Handle any Production issues
Deploy SQL Server Patches
Manage databases backup / Restore databases to non-production environments / Production environments
Skills: • Database Administration •Shell Scripting • Performance Tuning • PL/SQL • Azure VM • Extract, Transform, Load (ETL) • Data Integration • JIRA • T-SQL Stored Procedures • Microsoft SQL Server • Backup and Restore Databases • Disaster Recovery With Always-On
Database Administrator
BTS Boston Transportation Service LLC • Part-time
Jun 2018 - Feb 2020 • 1 yr 9 mos
Greater Boston, MA
Responsibilities Include :
- Installing and configuring SQL servers
- Creating automation for recurrent database tasks
- Creating and manage database reports, visualizations and dashboards
- Created different databases and table per users request
- Building Indexes, Triggers and Stored procedures on frequently used DBs and Tables
Skills: Technical Requirements • Communication •Performance Tuning • PL/SQL • Azure DevOps Server • Scripting • Computer Literacy • Extract, Transform, Load (ETL) • Data Integration • SQL Database Administration • Database Maintenance
Business Intelligence Analyst
LogixHealth • Full-time
Mar 2017 - Aug 2018 • 1 Yr 6 mos
Bedford, MA
Responsibilities Include :
-Created and Maintained dashboards tracking KPIs Build various reports, dashboards, data alerts and data subscriptions using Tableau
-Provided development and production support for
SQL Server Integration Services (SSIS) packages
-Worked directly with stakeholders/ business owners in collecting, analyzing and developing reports per their requirements
-Provided operational and production support to developers
-Developed and maintained dashboards per business users
Skills: Data Integration · Tableau · Microsoft SQL Server · Databases · Power BI ·SSIS
BI/Data Analyst
Blue Nile LLC. • Full-Time
Sept 2014 – Feb 2017 2 yr 5 mo
Boston, MA
Responsibilities Include :
●Creating visualization for logistics calculation and department spend analysis
●Collecting, collating and carrying out data analysis in support of management & customer requests
●Working with a variety of tools (ex: SQL, Access, Excel, Tableau, Visio) to access data, write queries, run reports, manipulate, and analyze large datasets to meet management needs
Data Review Supervisor
Granite Telecommunication LLC. • Full Time
Sept 2011 – Aug 2014 2 yr 11 mo
Quincy, MA
Responsibilities Include :
●Maintained payroll for eight employees on Automated Data Processing Software
●Maintained Paid Time Off, Family and Medical Leave and sick time of employees
●Trained Temporary to Permanent employees on different carriers’ policies and procedures
●Improved team performance by 35% in meeting department quarterly goal
●Represented review team on Provisioning and Data Review meeting and solved different recurring problems
TECHNICAL SKILLS
●Data Analytics Skills: Tableau,Power BI, SPSS Modeler, SAS
●Programing Languages: Java, Python, Bash/Linux programming,Powershell
●Database skills:Advanced SQL on MS SQL (2012,2014,2017,2019,2022), Data Warehousing, Data Mining, Data Governance
●Web programming language: HTML5 and CSS3, JavaScript
●Microsoft Excel, Access, Word, PowerPoint, FrontPage, Visio, ADP payroll software, MS Dynamics NAV 2013 R2 Technical Support for: NT/98/2000/XP, UNIX/LINUX, Mac OS
Contact this candidate