Headline

Data Analyst | A/B Testing • SQL • Power BI • Python | Product & Growth Analytics Enthusiast | HCLTech

About

Data Analyst with 2.5+ years of experience at HCLTech, specializing in A/B testing, product analytics, and turning complex operational data into clear business decisions. I work at the intersection of data and strategy — writing advanced SQL, building Power BI dashboards stakeholders actually use, and automating workflows with Python and Power Automate to eliminate inefficiency. 𝗪𝗵𝗮𝘁 𝗜'𝘃𝗲 𝗱𝗲𝗹𝗶𝘃𝗲𝗿𝗲𝗱: ▸ Boosted SLA compliance from 88% → 96% in just 4 months ▸ Eliminated 70% manual reporting effort (10+ hrs/week) through automation ▸ Ran A/B analysis on ServiceNow workflows — reduced ticket backlog & cut vulnerabilities by 15% ▸ Maintained 96%+ compliance across 1,000+ devices, cutting security incidents by 18% ▸ Raised first-contact resolution to 85% by analyzing 200+ monthly support tickets 𝗠𝘆 𝗧𝗲𝗰𝗵 𝗦𝘁𝗮𝗰𝗸: ▸ SQL (CTEs, Window Functions, Joins) ▸ Power BI (DAX, Power Query, Star Schema) ▸ Python (Pandas, NumPy, Matplotlib) ▸ Power Automate | ServiceNow | Excel | Azure 𝗔𝘄𝗮𝗿𝗱𝘀: ▸ 🏆 Employee of the Month — 3 Times ▸ 🌟 Rising Star Award 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀: ▸ Microsoft PL-300 — Power BI Data Analyst ▸ Data Analytics Simulation — Deloitte (Forage) ▸ HackerRank SQL (Intermediate) Outside work, I build end-to-end analytics projects — from a 50K+ record Vendor Performance dashboard to a Blinkit operational KPI tracker — because I genuinely enjoy the craft. Currently open to Product Analyst, Data Analyst, and Growth Analytics roles where data drives real decisions. 📧 arnavsrivastava2001@gmail.com

Location

Kanpur

Work experience

Data Analyst at HCLTech, Jan 2025 - Present · 1 yr 6 mos, Lucknow, •Owned compliance analytics for 1,000+ Mac devices via SQL (CTEs, Window Functions) — maintained 96%+ multi-app compliance and cut critical security incidents by 18%. • Analyzed 200+ monthly ServiceNow tickets with SQL + Python (Pandas, EDA); raised the first-contact resolution to 85% and reduced the average handling time by 12%. • Automated weekly reporting on encryption, OS patches, and vulnerability trends using Python and Power Auto￾mate — eliminated 70% manual effort (10+ hrs/week). • Delivered Power BI dashboards (DAX, Power Query, Star Schema) tracking SLA adherence and productivity for 15+ stakeholders; enabled data-driven resource allocation. • Ran A/B-style analysis on ServiceNow workflows, testing manual ticket handling against an automated email￾trigger + auto-closure mechanism; identified improved resolution efficiency, cutting ticket backlog and reducing critical vulnerabilities by 15%. • Conducted RCA using SQL and Excel on 500+ monthly tickets to investigate higher EMEA SLA breaches; identified 30% higher user response delays and manual workflow gaps, driving automation initiatives that improved SLA adherence and reduced breach rates by 15%.

Graduate engineer trainee at HCLTech, Sep 2023 - Jan 2025 · 1 yr 5 mos, Lucknow, Uttar Pradesh, India

Web Development Intern at TwoWaits, Feb 2022 - Feb 2022 · 1 mo, Remote

Education

Bachelor of Technology, Information Technology, PSIT Kanpur (Pranveer Singh Institute of Technology)

Bachelor of Technology, Information Technology, PSIT Kanpur (Pranveer Singh Institute of Technology)