Choutali Ghosh – Unlocking Data Insights: How This Analyst Transformed Business Decisions with Powerful Dashboards

CHOUTALI GHOSH

Bangalore, India

SUMMARY

Proficient in Data Visualization, Reporting, Dashboarding, Insight analysis with hands-on experience in SQL, Excel, Power BI, and Tableau. Honing strong analytical skills, decision-making, problem-solving abilities with a learning mindset and a proactive approach.

TECHNICAL SKILLS

• Excel (Pivot Tables, Power Query, Advanced Formulas)
• MYSQL
• Python
• SAP
• Power BI (DAX, Dashboards, Power Query)
• Statistical Analysis
• Tableau
• Stakeholder Reporting

WORK EXPERIENCE

Orange Lab | Intern, Kochi 11/2024 – Present

• Developed interactive Power BI dashboards for analysis, enhancing KPI tracking by 60%.
• Used SQL queries to extract, transform, and analyze large datasets.
• Collaborated with stakeholders to improve data-driven decision-making, boosting client satisfaction by 15%.

Data Analyst Intern | AI Variant, Bengaluru 01/2024 – 10/2024

• Compiled data from the client in raw excel format, increased analysis by 50% by using pivot table & VLOOKUP.
• Designed Power BI dashboard for financial margin of four years to review the KPI; results in around 60% increase operation margin over a span of 4 years and reduction in payer source.
• Utilized SQL queries for data extraction, transformation, and analysis.
• Created visualizations for extracted data in Tableau.

Executive, Torrent Pharmaceuticals Ltd, Sikkim 02/2021 – 11/2023

• Utilized advanced Excel tools to monitor and analyze quality control metrics.
• Applied statistical method (descriptive), to identify trends in pharmaceutical drug data.
• Managed quality control data and compliance tracking using Excel, SAP, and SQL.
• Performs data validation and statistical analysis to ensure regulatory compliance.

Quality Control Analyst, Torrent Pharmaceuticals Ltd, Sikkim 08/2015– 01/2021

• Performed data validation & root cause analysis using HPLC, LC-MS/MS.
• Managed data integrity, compliance, and reporting using SAP and Excel.
• Provided data insights for operational process improvement.

EDUCATION

• Masters of Pharmacy – MAKUAT
• Bachelor of Pharmacy – Pune University

CERTIFICATIONS

• Hacker Rank – SQL Basic Badge
• ExcelR Certification of Data Analyst
• Professional Certificate: Microsoft Power BI analyst by Coursera

KEYWORDS: Data Visualization, Reporting, Dashboarding, SQL, Excel, Power BI, Tableau, Analytical Skills, Problem-solving, Stakeholder Reporting, Statistical Analysis, Python, SAP

“`

Cover Letter:

<[hidden]>