Summary
Overview
Work History
Education
Skills
Websites
Certification
Soft Skills
Languages
Timeline
Generic

Ansh Tyagi

Hapur

Summary

Data Analyst with over 3 years of experience utilizing Power BI, SQL, and Python to drive strategic insights and enhance business performance. Expertise in data modeling, dashboard creation, geospatial analytics, and database management. Committed to transforming raw data into actionable business solutions through effective visual storytelling and automation.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Analyst

Tata Consultancy Services Pvt. Ltd.
Noida
09.2021 - Current
  • Developed data reports using analytical tools to support decision-making processes.
  • Supported project managers in tracking timelines and deliverables for various projects.
  • Designed interactive dashboards for five departments to monitor KPIs and performance metrics.
  • Used Power Query to clean, transform, and integrate data from Excel, MySQL, and PostgreSQL.
  • Developed custom DAX measures for insights into customer churn, resolution time, and service metrics.
  • Created optimized SQL queries and views for business reporting and analytics.
  • Developed data models and temporary tables to enhance dashboard performance.
  • Maintained data accuracy through validation protocols and collaboration with DB administrators.
  • Supported autonomous navigation systems using Q-GIS, Atlas, and Python for geospatial analysis.
  • Extracted and visualized location-based data to assist IoT mapping projects.

Education

Master of Computer Applications -

Chandigarh University
Mohali, Punjab, India
07.2023

Bachelor of Computer Applications -

Chaudhary Charan Singh University
Meerut, Uttar Pradesh ,India
07.2021

Skills

  • Database management: MySQL and PostgreSQL
  • Business intelligence: Power BI
  • Programming language: Python
  • Libraries and tools: NumPy, Pandas, Matplotlib, and Q-GIS
  • Data visualization and modeling, data integration
  • ETL processes
  • Git
  • MS Excel

Certification

  • Microsoft Certified: Power BI Data Analyst Associate (PL-300)
  • Python programming – Coding Ninjas

Soft Skills

Strategic thinker | Quick learner | Collaborative team player

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Analyst

Tata Consultancy Services Pvt. Ltd.
09.2021 - Current

Master of Computer Applications -

Chandigarh University

Bachelor of Computer Applications -

Chaudhary Charan Singh University

Similar Profiles

CREATE PROFILE
Ansh Tyagi