Leopold Arie Blau

Business Consultant turned Web Designer

Formal education will make you a living; self-education will make you a fortune.
-
Jim Rohn

Work Experience

Consultant

Computerline

April 2012 - June 2015

 Carved out the CRM strategy for the organizational unit (Org Unit) of a leading German tech conglomerate responsible for advanced training courses for all the organization’s employees || # of employees ~ 350.000 / project horizon ~ 30 months / # of stakeholder ~ 20
- implemented a CRM tool within the organization’s SharePoint environment for all 150 employees of the Org Unit
- developed an Excel-VBA BI application to gather meaningful insights – through analysis of various evaluations and KPI’s – regarding action-related dependencies for employees–, training course graduates–, graduates’ feedback, and overall expenses data
- created an Excel tool in order to manage and supervise internal cost allocation by time and cost center
- was in charge of subprojects and kept management and stakeholders informed through weekly status reports
 Developed a sales optimization strategy for the German subsidiary of a multinational conglomerate operating in the technology sector || project horizon ~ 6 months / # of stakeholder ~ 20
- conducted research about the overall German grocery market (meat and dairy market), petrochemistry market and the wider environmental situation to assess the potential development of core markets for sales opportunities
- gathered data on clients and prospects from all sales representatives ( # ~ 15) and consolidated this data through master data management to effectively enhance the data situation and the coordination between contracting and service
- was responsible for keeping the project on budget and on time
 Launched a document management system (DMS) for the membership administration office of a German Industry Association || project horizon ~ 6 months / # of stakeholder ~ 5
- examined and recorded business processes in order to transform them into a DMS-related workflow
- selected the DMS software based on business processes analysis, client’s software requirements and by analyzing the market
- conducted training workshops for all stakeholders to correctly employ the DMS

Consultant & Web Designer

Self-Employed

July 2015 - Today

 Built a website for a small real estate company based in Frankfurt/Main and operating in the Rhine-Main area || project horizon < 1 months / # of stakeholder: 2
- designed and coded the website with respect to responsive web design standards using frameworks and libraries like Bootstrap and jQuery
- implemented Google Analytics script to oversee important audience–specific KPI’s (Avg. Session Duration, PageViews, Bounce Rate etc.), used Google Maps API to create a custom map and Google Search Console to apply search engine optimization
- enhanced site performance by following best practices like minification and concatenation using Grunt to automate them as tasks
 Developed a strategy to value the entire client portfolio based on available data for a German auditing company || project horizon: 6 months / # of stakeholder ~ 5
- modeled the compilation of an assessment logic for ranking clients with respect to financial–, industry– and location–specific data
- created an Excel-VBA application based on previously structured data, and the assessment logic, following the fundamental idea of the BCG-matrix in order to allocate remaining resources to high-value clients
 Continued various projects with the Computerline e. K. with focus on the main project in order to improve the Customer Relationship Management (CRM) strategy for the organizational unit (Org Unit) of a leading German tech conglomerate (s. first bullet from Computerline e.K.) || project horizon: 22 months and ongoing / # of stakeholder ~ 20
- developed a CRM Top Report to oversee all relevant CRM-related data to management
- continued the maintenance and enhancement of a SharePoint–based CRM tool
- continued the maintenance of an Excel-VBA Business Intelligence (BI) application and extended it by creating further analysis