Data transformation using Excel, Data visualisation using Tableau.

Deloitte Australia - Data Analytics Job Simulation

Level of English is 77/100 on the EF SET score scale and C2 Proficient.

EF SET Certificate

Data manipulation using Pandas, Data &nbsp;Visualisation using Matplotlip, Machine Learning

Python for Data Science

For being in the top 1% students in the Higher Secondary Exam in the state.

Inspire Award, 2019

Finance Secretary | Manipuri Students' Association Delhi (MSAD) | March 2024 - March 2025

Master of Science

Mathematics

Bachelor of Science

Intermediate (Class XII)

Science

Matriculation (Class X)

Other

University Of Delhi, Delhi

India

 Proficient data analyst with strong expertise in analytical thinking, statistical modeling, and problem solving. Skilled in SQL, Power
 BI and Excel, with a passion for transforming complex data into clear, actionable business insights that support strategic decision
 making.

<ul><li>Conducted CRM analysis on 10,000+ customer records to uncover key factors influencing churn and customer retention.</li><li>Built a MySQL database and executed complex SQL queries to generate KPIs such as avg. credit score (650.53) and active membership rate (51.5%), improving data accuracy by 30%.</li><li>Developed interactive Power BI dashboards visualizing churn patterns, customer segmentation, and profitability insights, enabling faster decision-making for marketing teams.</li><li>Delivered actionable recommendations that helped identify high-risk customers and potentially reduce churn by 15–20% through targeted engagement strategies.</li></ul>

BANK CRM ANALYSIS - Power BI

<ul><li>Analyzed Instagram user data of 100 users, identifying 77 highly active and 13 at-risk inactive users.</li><li>Found food-related hashtags driving 64–65% engagement, followed by visual/aesthetic and emotional themes.</li><li>Highlighted users with over 65% engagement and strong follower counts as brand ambassadors.</li><li>Tech Stack/Tools: MySQL Workbench (CTEs, Window Functions, Aggregation), MS Excel (Charts, engagement visual).</li></ul>

SOCIAL MEADIA (META) ANALYSIS - SQL

<ul><li>Built an Excel dashboard that analyzes 130K+ IT support tickets (2016–2020) to assess resolution efficiency, agent performance, and employee satisfaction.</li><li>The volume of tickets doubled from 13K - 29K; identified 88K+ Normal (routine) issues, with hardware/system tickets taking 2–3x longer to resolve.</li><li>Tracked satisfaction improving 3.98 - 4.16, while flagging underperforming agents and lower-rated age group 41–50.</li><li>Tech Stack/Tools: Microsoft Excel (Formulas, Pivot Tables, Charts, Conditional formatting, Dashboards, etc.), MS Word, MS PowerPoint.</li></ul>

Surchand LaitonjamIndia

Social Accounts

Achievements

Projects

BANK CRM ANALYSIS - Power BI

SOCIAL MEADIA (META) ANALYSIS - SQL

IT TICKET ANALYSIS (2016 - 2020) - Spreadsheet

Education

Department of Mathematics, University of Delhi

Zakir Husain Delhi College, University of Delhi

Herbert School, Imphal

KM Blooming Higher Secondary School

Certificates

Deloitte Australia - Data Analytics Job Simulation

SQL

EF SET Certificate

Python for Data Science

Inspire Award, 2019

Skills