Back to Developers
somesh rawat

somesh rawat

Data Analyst

Noida, Uttar Pradesh, India 9+ yrs exp 90 · Outstanding

About

Results-driven Data Analyst with 8.5 years of experience delivering data-driven solutions across e-Governance and Telecom sectors at Tata Consultancy Services. Proven ability to extract insights from large-scale datasets (1M+ records), automate reporting workflows, and build executive dashboards that support strategic decision-making. Adept at translating complex data problems into clear, actionable outcomes using SQL, Power BI, Python, and Excel VBA.

Skills & Expertise (30)

Power BI Advanced
8.5/10
8
Years Exp
Query Optimization Advanced
8.3/10
8
Years Exp
DB2 Advanced
8.1/10
8
Years Exp
Excel VBA Advanced
7.9/10
8
Years Exp
Python Intermediate
7.6/10
3
Years Exp
Data Extraction Ad-hoc Analysis Transformation Loading Pipeline automation Azure Data Studio Git GitHub Remedy ServiceNow Maximo SLA Reporting Audit Reporting MIS Reporting RCA validation Data Cleaning NumPy Pandas Excel Subqueries Joins Complex queries Postgresql MySql

Work Experience

Data Analyst

Tata Consultancy Services (TCS)

Jul 2017 - Dec 2025

Performed root-cause analysis on DB2 production databases (1M+ records), resolving 100+ operational issues monthly and maintaining 99% data accuracy across critical datasets. Authored and optimized complex SQL queries for data extraction, validation, reconciliation, and audit reporting, reducing average query runtime by identifying and eliminating bottlenecks. Automated 10+ recurring MIS and operational reports using Excel VBA and Pivot Tables, cutting manual effort by 40% and enabling same-day report delivery. Designed and delivered Power BI dashboards and ad-hoc analytical reports for management reviews, audits, and SLA compliance monitoring. Championed data quality initiatives that consistently maintained 99% accuracy across mission-critical government datasets.

Support Engineer

Convergys (now Concentrix)

Jun 2016 - Jun 2017

Provided technical support for Dell customers, diagnosing OS, driver, and hardware issues; analyzed incident trends to recommend process improvements, contributing to higher first-call resolution rates.

Education

Bachelor of Computer Applications (BCA) - Amity University

2013 - 2016 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceMay 2026