Senior IT Specialist and SQL Developer with 10+ Years Expertise

Mekonnen Senbeta

Silver Spring, MD

*********@*****.*** 571-***-**** LinkedIn: https://www.linkedin.com/in/mekonnen-senbeta-478a04178/

Professional Summary

Experienced IT Specialist and SQL Developer with over 10 years of hands-on experience in designing, building, and optimizing enterprise data systems. Proven expertise in SQL Server, SAS, Power BI, and ETL pipelines across diverse sectors. Skilled in CRM platforms such as Personify360, Dynamics 365, and NetForum. Strong collaborator and problem solver, delivering scalable database solutions and actionable insights to support business decisions.

Technical Skills

- Databases: SQL Server, MySQL, Oracle

- ETL Tools: SSIS, Informatica PowerCenter, DTS

- BI Tools: Power BI, Tableau, SSRS, Power Pivot, Business Objects

- Languages: SQL, T-SQL, DAX, C++, HTML5, JavaScript, JSP, PHP

- CRM Platforms: Personify360, Dynamics 365 (Protech), NetForum

- Statistical Tools: SAS 9.4, SAS Enterprise Guide

- Other Tools: GitHub, Apache Tomcat, UNIX, JIRA, XRMToolBox

Certifications

- MCSA: SQL Server

- Oracle Database SQL Expert

Professional Experience

AdSTM (Contractor at U.S. Department of Transportation – NHTSA)

Senior SQL Programmer

August 2021 – June 2025

Designed and implemented advanced SQL queries, stored procedures, and CTEs to support multi-state crash data analysis and reporting.

Built and maintained SSIS-based ETL pipelines for large-scale data ingestion, cleansing, and transformation.

Created automated SAS programs and macros for generating standardized reports and statistical summaries.

Migrated SAS datasets into SQL Server environments to support cross-platform analysis and integration.

Performed conversion of various flat file data (CSV, Excel, Access) containing large datasets into SAS datasets using SAS programming for enhanced data analysis and integration.

Conducted data profiling, validation, and transformation tasks to ensure consistency with state specifications.

Authored technical documentation, including data dictionaries and ETL process guides, for internal knowledge sharing.

Collaborated with analysts and state partners to align data workflows with regulatory standards and project timelines.

National Retail Federation (NRF) – SQL Database Developer

June 2020 – June 2021

Designed stored procedures and optimized SQL processes for integrating customer data into NetForum CRM.

Developed SSIS packages to automate ETL processes and modernize legacy DTS workflows.

Delivered Power BI dashboards and SSRS reports for key metrics and executive-level decision support.

Created metadata documentation including data dictionaries and training materials.

Used JIRA for task tracking and ensured deliverables aligned with business requirements.

Society for Neuroscience (SfN) – Database Developer / Report Writer

August 2017 – October 2020 Washington, D.C.

Built reports using SAP Business Objects connected to Personify360 CRM.

Authored T-SQL scripts and database objects to support reporting across finance and membership domains.

Developed dashboards using Power BI and automated data loads using SSIS and Power Pivot.

Created SOPs and documentation covering GDPR, SSO access via OKTA, and CRM workflows.

Led training sessions on CRM operations, renewals, and identity management procedures.

University of the District of Columbia – SQL Database Developer

June 2016 – October 2016

Converted and migrated data from flat files into SQL Server and Microsoft Access using SSIS and macros.

Developed Access-based data entry forms and pivot reports to assist in TANF program data analysis.

Larry’s Cookies

Data Entry Specialist

October 2010 – May 2013 Washington, D.C.October 2010 – May 2013

Maintained and updated daily transaction records for customers and employees.

Scanned and archived documents into a centralized database for improved recordkeeping.

Ministry of Science and Technology, Ethiopia

SQL Developer & Website Admin

February 2004 – June 2009

Developed stored procedures and triggers; managed backup routines and system performance.

Updated government websites using HTML, CSS, and JavaScript.

Collaborated with NEPAD on data projects supporting entrepreneurship and ICT development.

Technical and Vocational Training Institute, Ethiopia

IT Instructor & Deputy Director

September 2001 – January 2004

Taught IT courses in programming, desktop support, and MS Office tools.

Led IT curriculum planning and coordinated external partnerships for infrastructure enhancement.

Education

B.Sc. in Information Technology – University of the District of Columbia, 2016

B.Sc. in Information Science (Major),Computer Science(Minor)– Addis Ababa University, 2001

Project Experience

Restaurant Order Management System

January 2016 – April 2016

Developed a web-based ordering platform using Bootstrap, PHP, and MySQL to streamline restaurant operations.

GitHub: https://github.com/MekonnenSenbeta/Final-Project-2

Contact this candidate