Arijit Guchhait
Kolkata
Summary
Experienced data analyst with 6+ years of expertise in data analysis, ETL, and visualization. Proficient in Python and SQL for comprehensive data analysis, utilizing Power BI to derive valuable business insights. Motivated professional with a strong ambition to advance and excel in the field of data analysis.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Analyst
J&J MedTech
05.2022 - 03.2025
- Carried out data transformation and cleansing using SQL queries,views to maintain data warehouse.
- Involved in porting existing on-premises SQL Server migration to Azure for scalable querying using integration service.
- Created visually compelling, user-friendly Power BI dashboards using DAX measures and calculated columns for KPI tracking and trend analysis for stakeholders.
- Defined user profiles and roles aligned with the organizational hierarchy and implemented Row-Level Security (RLS) in Power BI Service to ensure secure data access.
- Integrated customer segmentation analyses of Important KPIs into Power BI using ML Models like regression, K-means clustering using Python (Scikit-learn) to uncover actionable insights, enhancing targeted sales.
Portfolio Analyst
Abbott
11.2020 - 05.2022
- Reconcile ERP status using advanced Excel and SQL for bulk load to SQL database with data cleaning and normalizations.
- Performed ETL in Power Query for update into Tableau based dashboard and validate visualizations using SQL.
- Evaluated sales data leveraging Python (Pandas, Matplotlib) to identify pain points in customer feedbacks for actionable insights that improved user retention.
- Collaborated with data engineers to identify data quality issues for seamless visualizations.
Industrial Engineer
Levram Lifesciences
12.2016 - 12.2018
- Supervised production workers to determine problematic areas and implement solutions for optimized production.
- Build optimization model in Excel for supporting inventory planning and forecasting resulting reduction in production costs.
- Provided analytical solution to Procurements with Power BI dashboard for insights on KPIs.
Education
Master of Science - Industrial Engineering
University of South Florida
Tampa, USA06-2020
Bachelor of Science - Industrial Engineering
Haldia Institute of Technology
06-2016
Skills
- Programming & Query Languages: SQL, Python
- Data Visualization: Power BI, Tableau, Matplotlib, Seaborn
- Cloud & ETL Tools: Microsoft SQL Server, Azure Data Factory (ADF), Medallion Architecture, Star Schema, Advanced Excel
- Statistical analysis: Azure ML, Pandas, Scikit-learn
Certification
- Python Basics for Data Science: Authorized by IBM
- Databases and SQL for Data Science: Authorized by IBM
- Neural Networks and Deep Learning: Authorized by IBM
- Microsoft Certified: Azure Data Fundamentals
- Data Visualizations and Communication with Tableau: By Duke University
Timeline
Data Analyst
J&J MedTech
05.2022 - 03.2025
Portfolio Analyst
Abbott
11.2020 - 05.2022
Industrial Engineer
Levram Lifesciences
12.2016 - 12.2018
Master of Science - Industrial Engineering
University of South Florida
Bachelor of Science - Industrial Engineering
Haldia Institute of Technology
Similar Profiles
Sampreeta BhatSampreeta Bhat
Internship at J&J MedTechInternship at J&J MedTech
Gopinath Reddy SomaVenkata (Gopi)Gopinath Reddy SomaVenkata (Gopi)
Director at J&J MedTechDirector at J&J MedTech
Samita SakshiSamita Sakshi
Executive Assistant to MD& CEO at Andhra Pradesh MedTech ZoneExecutive Assistant to MD& CEO at Andhra Pradesh MedTech Zone
Soumyadeep NagSoumyadeep Nag
Intern at AI Institute of South Carolina (AI @ USC)Intern at AI Institute of South Carolina (AI @ USC)
INDRAJIT MAJUMDARINDRAJIT MAJUMDAR
Management Trainee at Gitanjali Finance Private LimitedManagement Trainee at Gitanjali Finance Private Limited