DRIPTO DAS
Kolkata
Summary
Finance MIS and data analytics professional with strong financial acumen and technical proficiency in Excel, SQL, Power BI, and Power Apps. Known for accurate reporting, structured data handling, and automation using Apps Script. Experienced collaborating across teams with disciplined time management and quality control.
Overview
3
3
Languages
1
1
Certification
7
7
years of professional experience
Work History
Data Analyst
VIRTUSA CONSULTING PVT. LTD
Hyderabad
07.2024 - Current
- Developed Looker Studio and Power BI dashboards, eliminating manual data entry across multi-store operations.
- Wrote complex SQL queries to transform high-volume relational data into structured reporting views.
- Managed data and databases in Excel and Google Sheets using SQL, ensuring data accuracy.
- Automated end-to-end daily, weekly, and monthly MIS reporting, reducing turnaround time by over 40%.
- Prepared scorecards and ranking systems to evaluate processes comprehensively.
- Evaluated trade discount schemes and shrinkage rates, providing insights on retail profit impact.
Senior Associate
TATA CONSULTANCY SERVICES
kolkata
02.2023 - 07.2024
- Performed budgeting, forecasting, and trend identification to support strategic initiatives.
- Collaborated with stakeholders to define business requirements and establish reporting needs.
- Executed data gathering, cleaning, processing, analysis, and report generation activities.
- Developed and maintained SQL databases and Excel sheets, enhancing data management for retail sales clients in the US.
- Created and maintained data visualizations and dashboards to enhance data reporting.
- Analyzed data to identify trends and insights, supporting informed decision-making.
- Collaborated with operations team to gather requirements and generate Excel BI reports, driving actionable insights.
Process Assistant
CAPGEMINI TECHNOLOGY SERVICES INDIA PVT. LTD
Kolkata
01.2020 - 02.2023
- Utilized SQL for extraction, transformation, and analysis of large datasets from diverse sources.
- Created and managed Excel dashboards and reports to improve data visibility for stakeholders.
- Monitored unaccounted invoices through aging reports to ensure timely financial oversight.
- Resolved client and vendor queries to support month-end closing and invoice processing.
- Acquired knowledge of P2P and R2R processes to streamline financial transactions. along with Power Query and reporting automation , Excel, Microsoft Power Apps
Education
PG Certification - Data Science
IIT GUWAHATI
09-2026
M.COM - Finance,Stats,Operation Research
CALCUTTA UNIVERSITY
Skills
- SQL database management
- Data visualization expertise
- Business intelligence tools
- Sales analytics and MIS reporting
- Analytical reporting skills
- Data cleaning
- Data integration techniques
- Excel VBA automation
- Oracle ERP expertise
Personal Information
Title: DATA ANALYST
Certification
Master Data Management, Financial KPIs, Advanced Excel For Data Analysis - Ivy Professional School, Microsoft Excel Basic to Advanced - Udemy, SQL for Data analysis - Ivy Professional School, MySQL - Basic and Advanced Certificate - HackerRank, MySQL Intermediate - TCS, Analyzing and visualizing Data with Microsoft Power BI - Coursera, Problem solving techniques - Project management institute, Fostering Critical thinking and curiosity - Project management institute, Business Analysis Foundations - Linkedin Learning (IBA)
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Bengali
Native
Native
Timeline
Data Analyst
VIRTUSA CONSULTING PVT. LTD
07.2024 - Current
Senior Associate
TATA CONSULTANCY SERVICES
02.2023 - 07.2024
Process Assistant
CAPGEMINI TECHNOLOGY SERVICES INDIA PVT. LTD
01.2020 - 02.2023
PG Certification - Data Science
IIT GUWAHATI
M.COM - Finance,Stats,Operation Research
CALCUTTA UNIVERSITY