Adrian Guerra

Adaminds

On a mission to help agency owners grow 💜⚡️

🚀 Book a discovery call → 📆 https://calendly.com/adaminds/discovery-call

Founder

Swisscom

Business Analyst

Capgemini

Senior Data Analyst

Cebedia

Koch Supply & Trading

Data Scientist

AI & Business Intelligence Consultant

Marketing Scientist helping agency founders grow 💜⚡️

DM me GROW for a FREE Linkedin outreach strategy you can plug into your business today 🎁

Adamax is a full-service software development and technology consulting company, specializing in data science and analytics solutions. Our services include product development, digital transformation and IT operations for businesses.

Open Web Technology

2016 - 2022 : Nestlé : This is a multiple project scope for different department, Mailing / HR / IT / Restaurant .. with different technologies and requirements.
• Role: Scrum Master / Business Analyst / BI Consultant
• Responsible for integrating the Application Sustain team to support hundreds of applications and manage different kinds of requests: Incident Management / Evolutionary Maintenance / Project Management and assisting the business users. Collaborated with our offshore team in Vietnam
2021 : Freemont Management SA: Development of Dashboard for regulatory and for finance
2022 : Medgate : Setup a DWH for Patient call statistics, for invoicing application. Responsible for putting in place a DWH based on SQL server with SSIS ETL
2023 : FIBA : Security Dashboard
Develop an application tool for security assessment and Reporting. Role as Developper and Solution architect / Responsible for putting in place a Sharepoint PowerApps / PowerAutomate and Power BI based application
2023 : Unilab : In the context of COVID, there was a financial gap in the reporting tool. Role as Senior Data Analyst and responsible to analyse the origin of the gap and explain it to the CxO
2023 : BGS - Bürgschafts-Support : Setup a DWH and different Dashboards to get an insight and analysis on business activities  / Responsible for the setup of DWH and development of financial reports with Power BI / Power BI Server on-premise.
2024 : CEESV : Development of invoices pages and analytical reports based on custom invoicing tool. •	Responsible for the development of invoicing reports
2024 : OWT : DevOps Dashboards : Within the strategy of CI/CD and quality excellence delivery, the project consist the development of different internal Dashboards related to Operational Delivery. Responsible for the development of DevOps quality and security reports and Dashboards related to Azure DevOps / Sonar / Snyk application

Senior Business Intelligence Consultant

insentia

2014 : Intuitive Surgical : leader in the robotic surgery market and has a significant global presence. For the regulatory department, the enhancement of the tool and data model was necessary.
Responsible for upgrading the Regulatory Authorization application based on Access. Rebuild the User Interface / Implement the versioning of the Devices and registration / Create new Access Forms and Reports
2014 : Veltigroup : Participate to the annual Veltigroup Expert’Day Forum : In the context of the IoT (Internet of Things), we demonstrate our knowledge in term of Big Data. The project is focused on the SmartBottles device which generates millions of records. Implemented a Big Data solution based on the Cloudera distribution (create the Clusters on our partner cloud Exoscale, configure the Master NameNode and Data Node) / Feed the Big Data HDFS with the million of records coming from the SmartBottle log / Feed the DWH using the Talend ETL / Create the Frontend reports (Microsoft PowerMap and QlikView)
2015 : Merck : Within the life cycle of Business Object tool, the project is to migrate the BO universe to the new SAP BO IDT.  Responsible for migrating of the universe from Designer to IDT and updating existing reports and creating a new set of reports.
2015 : Viollier : Create Financial / Logistics set of report SAP BO / Responsible for the development of BO reports and BEX Query
2015 : Swatch : Develop SSIS ETL based on SAP BW connector. Responsible for the development of SSIS ETL using Theobald IS BAPI connector

Senior BI Consultant

Veltigroup Consulting Ltd

2013 : MerckSerono : worked on RIMS3: The main objective of this project is to provide missing reports and add a reporting capabilities to the RIMS system (Regulatory Information Management System).
•	Creation of the DB Model using Sybase Power Designer, development of Informatica functionalities (mappings, session, workflows), creation of SAP BO universe and SAP BO reports. Application support and SAP BO training.
Challenge: Create an end to end DWH and Reporting solution in short time. Doing the reverse engineering of the Insight tool and understanding the Business Process of Regulatory Affairs.

Business & Decision (Suisse) SA (formerly : Integrated Solutions SA)

As Senior BI Consultant worked mainly for :
2008 - 2012 : MerckSerono 
2013 : DHL : Aim activities is to support and develop the Cognos reports and ODI workflow and Database tuning
Challenge: discover the ODI tool in a short time, reduce the database size using compressed index and data.
2013 : MerckSerono : Data migration from RIMS legacy Application source to Parexel Liquent Insight which is a tool for Authorities submission. Responsible for the developement of Informatica functionalities (mappings, session, workflows), creation of Cognos reports.
Challenge: Applying complex Business rules within Informatica, performance issue with Cognos to generate Excel files -> DB tuning and using tables instead of views for Cognos.

Business Intelligence Consultant

MerckSerono

Integrated the BI Support team to manage different kind of request: User Management / Incident Management / Evolutionary Maintenance, assist the business users / involved in several projects for different departments : HR / Financial / Supply Chain / IT Service Management / Sales Marketing / RIMS ...
Challenge: Manage several issues and development on the same time, to be connected with many kind of people, which drives to be organized,

BI Consultant

Worked for several customer in different industries:
2005 : Hewlett Packard	: - Development of Informatica mappings and workflows, Metrics results will be reported through an integrated dashboard architecture using a common worldwide database. 
- Application support
Challenge: Understand the process and work with a world wide team
2006 : Gaz De France : - Development of Informatica functionalities (mappings, sessions, workflows) 
Participate to the technical specification / DB tunning / Application support
Challenge: Short delay of implementation and Involve the Web team to the backend part
2006 : Hewlett Packard : - Responsible of the Delivery / Application Support / Monitoring of the applications in the Integration environment under Tidal and Maestro Scheduler for a data Hub between the Supply Chain systems and BI systems.
Challenge: Development under unix and take over the scheduling tool
2007 : Alcatel-Lucent : Migration project of the CRM application under Siebel, from version 6.3 to version 7.8 . Worked on the Functional Design / Technical Design / GUI Design / Data Model Design 
Challenge: Rebuild the functionalities on a major release. Working with off shore team.
2007 : Neuf Cegetel
Migration Project of Customer data from ICSS CRM, Billing from ARBOR V9 and securing loyal customers system Sesame towards Siebel 7.8 CRM and ARBOR v11 (Kenan FX) Billing system: 
Worked on Technical Design / Development of Informatica functionalities (mappings, sessions, workflows) / Delivery and Support (Billing part)
Challenge: Beyond the technical side, applying the business rules to merge a customer offer to another.

taplio

The Battle

Adrian Guerra

Dhafer Sefsafi

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?