Experience

Utrace

• United Kingdom
• Automation Machinery Manufacturing
• 1 - 100 Employee

• Business Intelligence Engineer

  • Aug 2022 - Present

  -Created and automated dashboards and reports using SQL, Python and BI tools; -Led project initiatives with clients, analyzing business requirements and translating them into system specifications, while creating relevant documentation and development tasks.; -Built ETL pipelines for extracting data from S3, transforming it using Python and Airflow, and loading it into a Data Warehouse. -Created and automated dashboards and reports using SQL, Python and BI tools; -Led project initiatives with clients, analyzing business requirements and translating them into system specifications, while creating relevant documentation and development tasks.; -Built ETL pipelines for extracting data from S3, transforming it using Python and Airflow, and loading it into a Data Warehouse.



Glenmark Pharmaceuticals

• India
• Pharmaceutical Manufacturing
• 700 & Above Employee

• BI & Data Analyst

  • Sep 2020 - Aug 2022

  -Created SQL scripts for allocating total budget to specific positions for clients; -Developed over 10 automated reports using Macros and Python; -Analyzed large datasets and created a performance monitoring system for medical representatives; -Develop forecasting models, maintain business logic systems, and provide support to marketing teams; -Consistently provide regular reporting, including weekly and monthly sales and stocks reporting and other ad hoc reports as needed. -Created SQL scripts for allocating total budget to specific positions for clients; -Developed over 10 automated reports using Macros and Python; -Analyzed large datasets and created a performance monitoring system for medical representatives; -Develop forecasting models, maintain business logic systems, and provide support to marketing teams; -Consistently provide regular reporting, including weekly and monthly sales and stocks reporting and other ad hoc reports as needed.



Sanofi

• France
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Business Analyst (Intern)

  • Jul 2019 - Aug 2020

  -Designed and implemented an automated dashboard for forecasting purposes; -Created a template for calculating bonuses for partners under various special conditions; -Data analysis and visualization for multiple business cases. -Designed and implemented an automated dashboard for forecasting purposes; -Created a template for calculating bonuses for partners under various special conditions; -Data analysis and visualization for multiple business cases.



СПАО РЕСО-Гарантия

• 1 - 100 Employee

• Database Analyst

  • Feb 2019 - Jul 2019

  -Created SQL scripts to check the accuracy of data when uploading them to the database; -Analyzed the efficiency of the call center: unloading from the database, dashboard building, metrics' construction and optimization employee shifts. -Created SQL scripts to check the accuracy of data when uploading them to the database; -Analyzed the efficiency of the call center: unloading from the database, dashboard building, metrics' construction and optimization employee shifts.