Henok Abraham
Founder and Managing Director
Experience
Aug 2022 - Present
3 years Essen, Germany
Founder and Managing Director
Afworki GmbH IT-Consulting
- Afworki GmbH IT-Consulting’s goal is to help small and medium-sized companies become more competitive by tackling challenges in digitalization, automation, and data management.
- We offer customized technology, strategy, and specialist consulting tailored to each company’s individual needs and requirements.
- We analyze the company’s current situation and develop the best possible solution together with the customer.
- We use both agile and traditional IT project management methods to ensure projects are completed on time and within budget.
- We view data as the heart of every company.
- That’s why we focus on automating and orchestrating all data flows in a data warehouse.
- We help create a unified and standardized data foundation for sustainable, insightful reports, dashboards, and other solutions.
- We consider the many dependencies between IT and business to leverage lasting positive effects.
- We use modern strategies and tools specifically tailored to the company’s needs.
- We provide support in digitalization, introducing agile working methods, and creating up-to-date reports and analyses.
- Our aim is to streamline management and enable data-driven decision-making.
Sep 2021 - Apr 2022
8 months Remscheid, Germany
Head of Business Intelligence & Data Warehouse
Sander & Doll AG
- As head of the Business Intelligence & Data Warehouse department, my teams and I focused on developing and implementing technology strategies.
- By leading and building the Data Warehouse BI and software development departments, we gained a deep understanding of stakeholder needs and translated them into technical concepts.
- Defining and operationalizing the data engineering roadmap with Jira and BigPicture helped us work proactively and successfully.
- My ability to implement best practices across the entire technology stack contributed to increased efficiency and optimized business processes.
- I also focused on monitoring and advancing agile methods and processes within the departments and conducted code reviews to ensure high quality.
- My focus on new technologies and innovations allowed us to continuously improve and expand our work.
- As a Senior Microsoft Business Intelligence Solution Architect with experience developing ETL processes using MS SQL and SSIS, I ensured data was processed, stored, integrated, and analyzed correctly.
- Overall, as head of Business Intelligence & Data Warehouse, I helped our company become more successful and competitive based on data and technology.
- My skills in IT management, change management, agile project management, databases, and Microsoft Power BI helped me do this successfully.
Sep 2019 - Aug 2021
2 years Essen, Germany
Senior IT Consultant
Interaction Room GmbH
- As a consultant, my responsibilities spanned the development of business intelligence architectures, data and digitalization topics, and business transformation.
- I helped introduce agile infrastructures and DevOps methods and supported agile transformation workshops.
- One of my most challenging tasks alongside client projects was designing and delivering training and coaching.
- This included training on Power BI, data warehouse best practices, and agile project management methods.
- I also led a certification training for the Interaction Room method aimed at IT consulting firms.
- I converted the training from an in-person format to online to meet the challenges of lockdowns.
- The goal was to build a common understanding and effective collaboration among all stakeholders, highlight complex project elements, focus on feasible MVPs, and enable early risk management through intuitive visual methods.
- We also aimed to improve collaboration and anchor shared project responsibility between the business and IT.
- Additionally, I supported building the competence area, participated in internal projects and proposal processes, and kept up with the latest market trends to offer my clients up-to-date know-how.
Mar 2019 - Jun 2019
4 months Düsseldorf, Germany
Business Intelligence Manager
L'Oréal (via Hays AG)
- My role was to help the company turn data into valuable information.
- I used my skills and experience in data analysis, Microsoft Power BI, Power BI Desktop, dashboards, reports, and Microsoft Analysis Services to ensure the company could make data-driven decisions.
- I worked closely with other teams to ensure collected data was correct and meaningful.
- I also developed various dashboards to give decision-makers a quick overview of key metrics.
- I ensured all relevant information was displayed so decisions could be made on solid data.
- As a Business Intelligence Manager, I helped the company make data-based decisions and optimize business processes.
- My skills in data analysis, Power BI Portal, Power BI Desktop, dashboards, reports, and Analysis Services made the company more successful and efficient.
Dec 2018 - Mar 2019
4 monthsProfessional Training
Ruhr Campus Academy GmbH
- PRINCE2 Foundation
- PRINCE2 Practitioner
- Scrum Master
- Scrum Product Owner
- Six Sigma Green Belt
- Six Sigma Black Belt
Apr 2017 - Mar 2018
1 year Düsseldorf, Germany
IT Project Manager
Daimler AG (via Hays AG Essen)
- I was tasked with managing an international quality management logistics project for a major automotive manufacturer of Sprinters—an enormous challenge.
- The project had been running for three years with no positive results.
- My job was to bring the project to a successful close.
- I analyzed the situation, identified the crisis causes, and led a workshop with all stakeholders to create a roadmap with milestones and deadlines to get the project back on track.
- Based on the crisis causes, I developed measures for agile project management and introduced Scrum and Kanban.
- I implemented standardized alignment and collaboration concepts for stakeholders, the development team, and IT operations and trained the development team in standardized working methods (Scrum and Kanban).
- I designed and implemented quality management and test management processes.
- Leading departments, software development teams, and service providers was also part of my role.
- My experience as a project manager helped restore the integrity of business units in Düsseldorf, Spain, China, Russia, Argentina, Charleston, and Algeria.
- I also restored the integrity of the development team in Ulm, the product, project management, and communication.
- This led to a dramatic reduction in delivery costs, downsizing business units, and automating supply chain management.
Jul 2016 - Dec 2016
6 months Düsseldorf, Germany
Software Developer Analytics/BI
ElectronicPartner Handel SE
- My main responsibilities in analytics and business intelligence were quality assurance and test management.
- I handled communication and alignment with stakeholders and evaluated BI solutions and tools.
- I also planned and implemented IT systems, including analytics/BI, Microsoft SQL Server 2014, SAP BW, and SAP ERP.
- I created BI concepts and developed database models.
- Successful SQL tuning improved performance.
- I played a key role in embedding a measurable, end-to-end test process into quality management.
- My skills and experience increased stakeholder satisfaction and improved IT system quality.
- My work as a software developer in analytics/BI showed that careful planning, effective implementation, and consistent quality assurance can make IT projects successful.
Mar 2016 - Jun 2016
4 months Cologne, Germany
IT Project Manager and Software Developer
IBM Client Innovation Center Germany GmbH
- I led and supported national and international teams of up to six members.
- As team lead, I managed and supported up to six staff members locally and internationally.
- I handled complex client projects in the insurance industry and coordinated closely with clients.
- One of my strengths was creating a reliable project plan and progress control, continuously updated by proactive risk management.
- This allowed me to effectively manage scope, contract, and financial aspects.
- I also handled the technical implementation of Informatica PowerCenter ETL processes and developed and executed functional concepts.
- My experience in data quality analysis ensured our delivered IT systems were always top quality.
- My project controlling and risk management were very successful, allowing us to complete our Informatica PowerCenter projects.
- My strong skills in IT project management and software development helped our clients improve the efficiency and quality of their IT systems.
Oct 2013 - Dec 2015
2 years 3 months Düsseldorf, Germany
Senior Business Intelligence / Data Warehouse Analyst
VivaKi GmbH
- My task was to create a single point of truth for all relevant IT systems in controlling.
- I integrated various solutions—ERP system DAP Medialine, IBM Cognos TM1 planning, and Oracle Hyperion Financial Management consolidation—into a data warehouse.
- This enabled finance and the CFO to forensically track deviations in monthly and annual reports and generate compliance reports for the parent company.
- I was also responsible for leading projects and subprojects of different sizes and complexity.
- I used agile methods like Scrum and implemented innovative Microsoft BI and data warehouse solutions.
- Implementation of data integration processes (ETL), Microsoft Analysis Services, and SQL Server Reporting Services was part of my role.
- My experience in requirements and reverse engineering allowed me to accurately capture and implement business needs.
- I built and expanded reporting tools in IBM Cognos TM1, Excel, Hyperion, and database systems, and created analysis tools and financial reports.
- My work led to a successful migration of finance to an innovative Microsoft BI and data warehouse system, a single point of truth, and a decision template for contract management solutions.
- I proved my skills as an IT project manager and senior Microsoft BI solution architect and contributed to the company’s success.
Jul 2012 - Jun 2013
1 year Düsseldorf, Germany
Assistant Consultant
avantum consult AG
- I was responsible for implementing IBM Cognos TM1 in business intelligence projects for international clients.
- My main tasks included data modeling and creating TurboIntegrator processes.
- I also customized TM1 via the API in C# and developed automation applications for backup and archiving.
- I successfully designed and implemented a global network infrastructure on Windows Server 2008 to automate installation and configuration of IBM Cognos TM1 and tailor all TM1 reports to each location.
- I used agile methods like Scrum and focused on quality assurance through software and system testing, as well as system documentation.
- As a result, I implemented automation apps for IBM Cognos TM1, migrated an Oracle database to MS SQL Server, and modified ETL processes.
- I also created automated reports for global sites and implemented backup and archiving processes.
- My skills allowed me to quickly capture client requirements and streamline project processes.
- With my knowledge of IBM Cognos TM1 and Microsoft SQL Server, I met customer expectations and optimized their business processes.
Feb 2012 - Apr 2012
3 months Düsseldorf, Germany
IT Consultant and Business Analyst
Prodyna AG
- I focused on implementing Talend Master Data Management and Signavio for clients.
- I designed processes and organigrams with BPMN 2.0 and supported the analysis and optimization of business processes.
- I also conducted training in data management and process design.
- I continuously aimed to develop innovative solutions for complex challenges and stay up to date with the latest trends and developments.
Summary
I have extensive experience in setting up and implementing efficient project management in both traditional and agile environments. I have analyzed, optimized processes, and implemented appropriate methods and tools. My solid project experience includes managing business intelligence solutions as well as goal-oriented management, execution, and consulting of complex development projects across the entire product lifecycle. My industry experience ranges from insurance, automotive, and pharmaceutical to logistics and media.
I am passionate about technological innovations that simplify complex processes and boost productivity. I am equally fascinated by the many opportunities that come with changes in projects—whether on a human or technological level. My strengths lie in solution-driven, analytical thinking and structured action with strong execution skills and dedication. I have a strong sense for building relationships in projects and can put myself in the customer’s shoes and understand their challenges. This allows me to successfully guide complex change processes and contribute to process optimization.
I have extensive knowledge of classic and agile project management methods, as well as leading business intelligence tools such as Microsoft BI, Microsoft Power BI, SAP Business Intelligence BW/BO, and IBM Cognos TM1. My expertise also covers the analysis, optimization, and implementation of quality management processes and methods to ensure projects are carried out effectively and efficiently. Throughout, I focus on keeping the needs and requirements of the customer at the center and delivering successful results.
Languages
German
Native
Tigrinya
Native
English
Advanced
French
Elementary
Education
Sep 2007 - Sep 2011
Bochum University of Applied Sciences
Bachelor of Science, Software/Hardware Engineering, Embedded Systems, Microcontrollers, Databases, Web Technology · Computer Science · Bochum, Germany
Certifications & licenses
Enterprise Resource Planning with SAP S/4HANA (TS410)
SAP
Microsoft Certified Technology Specialist - Windows Server 2008
Microsoft
PRINCE2® Foundation Certificate in Project Management
PRINCE2® Practitioner Certificate in Project Management
Professional Scrum Master I
Scrum.org
Professional Scrum Product Owner I
Scrum.org
SAP BI – Advanced Business Intelligence
SAP University Alliances
SAP BI – Introduction
SAP University Alliances
SAP BI – Integrated Business Planning
SAP University Alliances
SAP BW on HANA – Dataflow and BusinessObjects Analysis (BW305H and BW310H)
SAP
SAP BW on HANA – Data Acquisition and BusinessObjects Reporting (BW350H and TBI30)
SAP
SAP BW on HANA – Data Modeling and BusinessObjects Applications (BW330H)
SAP
Six Sigma Black Belt Certification
CSSC
Six Sigma Green Belt Certification
CSSC
Similar Freelancers
Discover other experts with similar qualifications and experience