Portfolio - Mohd Sofiyan

About Me

Welcome to my portfolio! I'm passionate about turning raw data into useful insights. With a bachelors degree in commerce with computers, I discovered my knack for analyzing data and decided to dive deeper into it.

I've taught myself Excel, PowerBI, and SQL, which help me analyze tricky datasets and draw valuable conclusions.

While I haven't worked professionally yet, I've tackled many projects that have strengthened my skills and showcased what I can do, all detailed in my portfolio.

I love learning and thrive in fast-paced environments where I can use my analytical skills to solve real problems. I'm always eager to grow and excited about making decisions based on data.

Thanks for checking out my portfolio! I'm looking forward to connecting with recruiters who value the power of data.

Key Skills

My SQL

SQL

Python

Tableau

Google Tools

Microsoft SQL Server

My Projects

Sales Analytics (FMCG) Excel

AtliQ Hardware BI Dashboard for Finance, Sales, Marketing, and Supply chain.

Personal Expenses Report

AtliQ Mart Supply Chain

Hospitality Analysis - Chain of Hotels

Forecast Accuracy 21 vs 20

My Experience

Associate Dec 2025 – Aug 2026. Zomato Hyderabad, India

Efficiently managed and resolved high volumes of customer support tickets regarding order discrepancies, delivery
delays, payment failures, and refunds to ensure a seamless user experience.
Executed rigorous performance analysis leveraging advanced Excel and SQL architectures, tracking personal and
team core metrics including AHT, CSAT, and FCR to uncover underlying trends.
Extracted actionable data-driven insights to identify recurring order failure points and engineer structural process
improvements, fueling a 15-20% increase in aggregate operational efficiency and minimizing executive escalations.
Collaborated hand-in-hand with logistics partners and restaurant vendors to accelerate incident resolution loops,
ensuring strict adherence to defined corporate SLA thresholds.

Assistant Team Lead Nov 2024 – Mar 2025. Tech Mahindra (Contracted) Hyderabad, India

Managed a dedicated unit of 30 customer support associates, ensuring continuous alignment with corporate SLA
thresholds, aggressive production volumes, and quality control metrics.
Monitored granular key performance metrics (AHT, CSAT, FCR), driving a sustainable 15-20% enhancement in
overall team performance targets through systematic performance coaching and workflow optimizations.
Arbitrated high-priority corporate escalations and resolved complex technical bottlenecks, generating higher
customer satisfaction scores and a corresponding drop in overall escalation rates.
Conducted structured daily huddles, 1:1 developmental check-ins, and quarterly performance reviews; worked hand-
in-hand with QA and Training squads to maximize operational accuracy.

Data Analyst Intern Apr 2024 – May 2024 AtliQ Technologies Hyderabad, India

Preprocessed and cleansed large-scale corporate datasets to optimize data hygiene, improving computational data
accuracy by 20% and compressing production anomalies by 15%.
Drafted granular business intelligence reports to illuminate primary operational findings, improving stakeholder
business comprehension by 30%.
Furnished high-impact strategic insights to executive management, driving a 25% improvement in long-term decision-
making efficiency.

Associate Customer Support June 2021 – Dec 2022. Tech Mahindra Hyderabad, India

Scrutinized over 10,000 distinct instances of Natural Language Understanding (NLU) structured test data, achieving
an elite 98% accuracy baseline in sentiment analysis parsing.
Deployed robust automated data validation protocols, driving a 20% rise in raw database reliability to streamline
internal corporate reporting structures and downstream choice metrics.
Collaborated with cross-functional technical teams to fully overhaul enterprise Power BI reporting dashboards,
compressing legacy report generation latency by 30% and elevating overall analytical throughput by 15%.