Lead Business Intelligence/Process Engineer
Walgreens Boots Alliance Development GmbH
Keywords
Skills
Sales Data Analysis, Go To Market Strategy, Sales Performance Reporting, Marketing KPIs, Demand Gen, Business Intelligence Strategy, Data Harmonization, Data Architecture, Kimball Dimensional Modeling, Process Reengineering, Data Vault, ETL Pipelines, Data Integration, Data Quality, Lean Manufacturing, Process Improvement, Agile, Product Owner, ETL/DW Development, Value Stream Analysis, Business Case Development, Stakeholder Management, Technical Presentations, Dashboard Creation, SQL, DBT, Python, Jupyter Notebooks, Salesforce, Snowflake, Sisense, Periscope, Qliksense, Tableau, Alteryx, Papermill, Airflow, Gitlab, SQL Server, Excel, gSheet, Marketo.
Project history
05/2015
-
11/2017
* Acted as Product Owner for a $300k ETL/DW
development project. Prioritized tasks and facilitated
alignment between stakeholders and development team.
* Manages the Data Analytic team task backlog and
appropriately aligned development priorities.
development project. Prioritized tasks and facilitated
alignment between stakeholders and development team.
* Manages the Data Analytic team task backlog and
appropriately aligned development priorities.
01/2015
-
05/2015
Business Analyst
Lakeside Invest & Consult
Completed market research of online retail stores (FMCG),
establishing basket price benchmark.
* Evaluated and provided recommendations for outbound
logistics options, driving efficiencies in purchased goods
delivery.
establishing basket price benchmark.
* Evaluated and provided recommendations for outbound
logistics options, driving efficiencies in purchased goods
delivery.
02/2012
-
09/2014
Senior Manufacturing Analyst- R & D
Vistaprint Schweiz Gmbh
* Identified equipment design requirements that enabled
cost savings of $300k per machine.
* Created business cases for global projects worth $5
million of total investment, while supporting the Project
Manager in achieving alignment between key
stakeholders (marketing, platform, engineering).
* Developed & documented a print stability KPI data mart
(T-SQL) which enabled generation of reports and
analyses from a diversity of software solutions (Tableau,
JMP, SSRS & Excel).
* Managed a Business Intelligence intern including
technical work, scoping, and priority setting.
* Successfully conducted presentations for the CEO &
leadership team regarding new technologies; including
qualitative and quantitative analyses.
cost savings of $300k per machine.
* Created business cases for global projects worth $5
million of total investment, while supporting the Project
Manager in achieving alignment between key
stakeholders (marketing, platform, engineering).
* Developed & documented a print stability KPI data mart
(T-SQL) which enabled generation of reports and
analyses from a diversity of software solutions (Tableau,
JMP, SSRS & Excel).
* Managed a Business Intelligence intern including
technical work, scoping, and priority setting.
* Successfully conducted presentations for the CEO &
leadership team regarding new technologies; including
qualitative and quantitative analyses.
08/2011
-
02/2012
Supply Chain Analyst
University of St. Gallen
11/2010
-
04/2011
Junior IT Project Manager
Ingenieria y Consultoria Insular, S.L.
References:
Available upon request
* Drove efficiency gains through lean services and process
focused Business Intelligence applications.
* Developed and implemented a tender platform
supporting price negotiations for a $9 billion valued
business. This system serves 2 departments and 30
users with 8,000 clicks per month.
* Systematized and developed the SQL ETL process for 30+
different data sources and 33,000 lines of code between
T-SQL and VBA.
* Analyzed tendering process value stream and identified
opportunities to reduce lead time in 50% with no
automation.
Available upon request
* Drove efficiency gains through lean services and process
focused Business Intelligence applications.
* Developed and implemented a tender platform
supporting price negotiations for a $9 billion valued
business. This system serves 2 departments and 30
users with 8,000 clicks per month.
* Systematized and developed the SQL ETL process for 30+
different data sources and 33,000 lines of code between
T-SQL and VBA.
* Analyzed tendering process value stream and identified
opportunities to reduce lead time in 50% with no
automation.
10/2009
-
01/2010
Lean Research Associate
Universidad Nova
Local Availability
Only available for remote work
