Summary
Overview
Work History
Skills
Accomplishments
Tools
Languages
Timeline
Generic

HENOKE TEKLEMARIAM

Accokeek,MD

Summary

Results-driven Business Intelligence Engineer with [8+] years of experience designing, developing, and implementing data solutions to drive strategic decision-making. Expertise in data modeling, ETL processes, dashboard development, and analytics with a strong command of SQL, BI tools, and cloud platforms. Adept at translating complex data into actionable insights and collaborating with cross-functional teams to optimize business processes.


Overview

11
11
years of professional experience

Work History

BI Engineer/ETL Developer

MedeAnalytics
04.2021 - 07.2025
  • Built comprehensive reports from scratch utilizing configuration documents, aligning with business requirements and ensuring accuracy and performance.
  • Managed data loading processes, including historical data ingestion and automation of daily data updates to ensure real-time reporting capabilities.
  • Developed custom metrics, hierarchical and dynamic dimensions (e.g., time, organizational hierarchy), and calculated fields tailored to business needs.
  • Configured and maintained Mondrian OLAP servers, schemas, and SQL Server instances, ensuring high availability, security, and performance.
  • Supported SaaS platform lifecycle using tools like AWS, Spark, and Hoop, enabling scalable and secure deployment of analytics solutions.
  • Led migration initiatives from legacy systems to SQL Server, ensuring data integrity and minimal downtime.
  • Designed and implemented a data retention solution to automatically archive or delete data older than three years, while preserving month-end and year-end snapshots for historical analysis.
  • Managed user roles, permissions, and security provisioning through dedicated security tools, ensuring appropriate access control to objects and reports.
  • Developed interactive and custom reports, providing actionable insights to stakeholders and enhancing decision-making processes.
  • Supported platform updates, bug fixes, and enhancements by accurately implementing new objects and configurations.
  • Managed data warehouse architecture on [cloud platform],optimizing query performance and storage costs
  • Implemented data governance best practices, ensuring compliance with data security standards and policies
  • Conducted data quality audits and developed automation scripts to streamline data validation processes
  • Built interactive dashboards and reports in Power BI/Tableau to provide real-time insights for sales, marketing, and operations teams, increasing decision-making efficiency
  • Collaborated with stakeholders to gather requirements and translate business needs into technical solutions, improving data accuracy and consistency
  • Developed custom reports and dashboards to track KPIs, resulting in improved visibility into business performance
  • Participated in data migration projects, ensuring data integrity and minimal downtime
  • Supported end-user training and created documentation for BI tools and reports
  • Developed data models to enhance reporting capabilities and improve decision-making processes.
  • Collaborated with cross-functional teams to gather requirements and translate them into BI solutions.
  • Designed and implemented ETL processes using SQL and Python, optimizing data flow efficiency.
  • Conducted data analysis to identify trends, support strategic initiatives, and inform stakeholders.

ETL / POWER BI DEVELOPER

Deutsche Bank
11.2017 - 04.2021
  • Collaborated with senior management, subject matter experts, and IT teams to define business requirements. Transformed business requirements into functional and nonfunctional requirements.
  • Created complex stored procedures to perform various tasks including, but not limited to index maintenance, profiling, metadata searches, and loading of the data.
  • Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
  • Created incremental loads to populate the data model using checksum and timestamp techniques.
  • Created master-child packages to consolidate data from data sources into SQL server with execute package task enabling modular programming.
  • Implemented package configurations on development, test, and production environments utilizing parameters.
  • Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • Designed Power BI graphical and visualization solutions in conjunction with business requirement documents and plans for developing interactive dashboards.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers.

MS SQL SERVER / SSIS DEVELOPER

MobilityWorks
02.2015 - 10.2017
  • The Company serve thousands of individuals and businesses within the disability community with wheelchair accessible minivans, full-size vans with lifts, commercial fleet vehicles Works Closely with the Veterans Association, where the government has set up a system to fund and connect veterans with the dealers toward a purchase of a Vehicle and Maintenance, service The Dealership is currently within a major technology modernization initiative and has contracted our Firm to manage this effort and sustain existing applications.
  • Our Team is Providing the back -end services, Database development, Data migration, Data warehouse implementation and Cloud migration to support these efforts.
  • Created new data controls with store procedures, table partitions, views, constraints, indexes.
  • Created and managed schema objects such as tables, views, indexes, store procedures, triggers and maintaining Referential Integrity.
  • Created table partitions to improve database performance on some critical data tables.
  • Created SSIS packages to transform data from daily feed file systems to staging database server and then to development database.
  • Implemented business rules depending on the financial plan that involves running rules engines, commission calculations.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.
  • Extensively used Derived Column, Lookup, Conditional Split, Merge Join, Sort, execute SQL Task as part of SSIS packages to load data from one system to another.
  • Designed and build the OLAP cubes using Star schema and Snowflake Schema using native OLAP Service Manager.
  • Developed SSRS 2012 reports for SOX compliance, audit, operational controls on data marts and transactional data.
  • Helped in developing Tableau reports as part of the compliance project requirement.
  • Designed and created Report templates, bar graphs, pie charts based on the financial data.
  • Actively involved in change management process to deploy database objects to QA/UAT/Production servers.
  • Troubleshooting, on call production support once every two weeks.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Created and maintained daily SQL jobs to monitor the health of SSIS packages.
  • Environment: SQL Server 2012, Windows Server 2008, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, MS Visual Studio, Tableau, Team Foundation Server (TFS).

Junior SQL Developer

Bank of America
04.2014 - 01.2015
  • The project involved building a data repository to organize mortgage loan documents that are received from customers, submitted through various branches and different sales teams.
  • Prior to the development of the system the data existed in various RDBMS and post development the system is made as single stop for various needs.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies.
  • Managed SQL Servers in 32/64bit Clustered environments.
  • Implemented Database Mirroring on SQL Server 2008 environments.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Web Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Troubleshoot database performance issues and tune database objects.
  • Set up traces and Profiler to troubleshoot performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
  • Assist Design and develop the ETL data flow to populate the CER Cube Analysis Database using the SSIS packages (SQL Server Integration Services).
  • Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
  • Identified the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the SSIS packages.
  • Used Notification services to generate error messages and send them to the user through e-mails.
  • Environment: SQL Server 2014/2012/2008R2, T- SQL, Microsoft Access, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio, Star Team Version Control tool, TFS, Tableau 8.1., MS Azure, Erwin 8.0/MS Visio 2010.

Skills

  • Teamwork
  • Teamwork and collaboration
  • Problem-solving
  • Time management
  • Attention to detail
  • Problem-solving abilities
  • Multitasking
  • Multitasking Abilities
  • Reliability
  • Excellent communication
  • End user support
  • Organizational skills
  • Team collaboration
  • Active listening

Accomplishments

    Developed a robust solution to automatically remove data older than three years, maintaining critical month-end and year-end snapshots for compliance and reporting.

    Legacy Migration: Successfully migrated complex reporting systems from legacy platforms to SQL Server, improving performance and scalability.

Tools

  • SQL Server 2005/ 2008/2008R2/ 2012/2014/2016/2017/2018
  • Database/ETL Tools: SSIS, SSAS, SSRS, Business Intelligence Development Studio (BIDS)
  • Reporting: Excel, Server Reporting Services (SSRS), Report Builder, Power BI,AWS
  • Languages: T-SQL, XML, HTML
  • MS-Office: Microsoft Office Tools
  • Operating Systems: Windows Server 2000, 2003, 2008, 2008R2, 2012,2012R2

Tools: Backup Utility, Database Tuning Advisor, DTS, BCP, SQL Profiler, LiteSpeed for SQL Server, Visio, Erwin Data Modeler, Microsoft Visual Studio 2019/2017/2014/2012/2008/2010/2012/2018


Languages

English
Full Professional

Timeline

BI Engineer/ETL Developer

MedeAnalytics
04.2021 - 07.2025

ETL / POWER BI DEVELOPER

Deutsche Bank
11.2017 - 04.2021

MS SQL SERVER / SSIS DEVELOPER

MobilityWorks
02.2015 - 10.2017

Junior SQL Developer

Bank of America
04.2014 - 01.2015

Similar Profiles

CREATE PROFILE