Varun Dutta

Immediate Joiner
Associate Data Analyst

About Candidate

• Collected and analysed large and complex datasets using SQL, Python, and Power BI to identify trends, patterns, and insights that informed strategic decision-making in the healthcare industry.
• Designed and built interactive dashboards and reports using Power BI to enable real-time monitoring of key performance indicators (KPIs) and provide actionable insights to stakeholders.
• Presented findings to clients and collaborated with them to develop data-driven solutions that improved their business operations and customer experience.
• Coordinated with senior DBAs to develop a physical model to normalize relational databases for local medical shops, improving data integrity and efficiency.
• Created interactive dashboards using Power BI to identify sales trends and determine which medicines were selling in which areas, leading to more effective targeting of marketing efforts.
• Communicated complex data analysis to non-technical stakeholders, ensuring that insights were clearly understood and actionable.
• Worked closely with cross-functional teams, including developers and project managers, to ensure that projects were completed on-time, within budget, and met customer requirements.

Location

Education

M
Mechanical Engineering 2016
Dr. APJ Abdul Kalam Technical University

Graduate with 75.7 Percentage and awarded for excellence in academy in first, second and third year of graduation

Work & Experience

A
Associate Data Analyst May 2022 - Present
In-Web Technologies

• Collected and analysed large and complex datasets using SQL, Python, and Power BI to identify trends, patterns, and insights that informed strategic decision-making in the healthcare industry. • Designed and built interactive dashboards and reports using Power BI to enable real-time monitoring of key performance indicators (KPIs) and provide actionable insights to stakeholders. • Presented findings to clients and collaborated with them to develop data-driven solutions that improved their business operations and customer experience. • Coordinated with senior DBAs to develop a physical model to normalize relational databases for local medical shops, improving data integrity and efficiency. • Created interactive dashboards using Power BI to identify sales trends and determine which medicines were selling in which areas, leading to more effective targeting of marketing efforts. • Communicated complex data analysis to non-technical stakeholders, ensuring that insights were clearly understood and actionable. • Worked closely with cross-functional teams, including developers and project managers, to ensure that projects were completed on-time, within budget, and met customer requirements.

S
Senior Engineer Jun 2017 - Apr 2021
Encotec Energy India Pvt Ltd

Senior Engineer, Site: JSW Energy Ltd (Jul 2020 to Apr 2021) • Planning and Scheduling Preventive Maintenance of Boiler auxiliaries with proper guidelines to follow in each maintenance. • Evaluate and maintain replacement parts that reduce down time by 20% • Communication flows between four departments on a digital basis and reduce the paper burden by 75% and provide details on machine availability on an hourly basis. Engineer, Site: Vidarbha Industries Power Ltd (Feb 2018 to Jun 2020) • Practice Knowledge of attending live steam leakage from valves and tubes. • General Knowledge of condition monitoring by taking vibration readings of different machinery and upload to the client database for analysis and gives 100 % equipment availability. • Issue work to permit (WTP) on SAP, check permit expiry and make an extension on SAP make an indentation for issuing material from the warehouse, and keep a record procurement of new materials.

Skills

My SQL
70%
Python Programming
69%
Manpower Handling
80%
Microsoft (MS-Excel, MS-Word, MS-PowerPoint Power BI)
70%
Operation and Maintenance of Sub-Critical Thermal
70%
Youtube Video Editing
59%