Working for 5 years in SDG Consulting Group associate to Johnson and Johnson Pharmaceutical Companies: JnJ Corporate, Janssen, Ethicon Medical Devices.
Project: Janssen ITSS Finance Dashboard (2017)
- Description: ITSS Dashboard was designed to analyze regional, market and business needs, and get valuable insights to scale costs and quality.
- Role: Team Lead (2 Consultants)
- Stack: QlikSense + SQL + AngularJs
Project: JnJ Corporate LT Scorecard + Plant Scorecard Enhancements (2017-2018)
- Description: LT Scorecard is a dashboard specifically designed to be used by Supply Chain VPs meetings focus on analyzing KPIs split by JnJ subsidiary companies (Ethicon, Janssen, Depuy Synthes,...)
- Role: Role: Team Lead (2/3 Consultants)
- Stack: Tableau (Migration from Qlik Plant Scorecard Phase I) + SQL
Project: Ethicon Capacity Projects (2018-2020)
- Description: This project encompasses multiple small subprojects (1/2 Consultant 1/2 Months each). Ethicon Sites and SDG renewed this engagement every 6 months (5 times renewed - 30 months in total). Subprojects were requested by demand by Ethicon Georgia Sites BTL
- Role: Role: Team Lead (4 Consultants)
- Stack: Back-End: Cloudera (Hive, Impala, Sqoop)-, Front-End: QlikSense, Power BI, Tableau, D3.JS+ AngularJs
Project: Depuy Synthes ACM Surgeries Dashboard (2020)
- Description: This app was focused on analyzing arthroscopy knee surgeries, and what Depuy Synthes parts were offering better performance by Surgeon and technique.
- Role: Team Lead (2 Consultants)
- Stack: Tableau, Python, PostgreSQL
Project: Ethicon Neuron Project (2020-2021)
- Description: Full end-to-end manufacturing project focus on analyzing Vicryl sutures from Raw Material Sites (Athens & Cornelia sites) to FG sites (Juarez, San Angelo). These analyses were multi-department Manufacturing, Planning, Quality & Finance views.
- Role: Role: Scrum Master (5 Consultants)
- Stack: Cloudera (Hive, Impala, Sqoop, QlikSense + AngularJs