Somshubhra Giri

Somshubhra Giri

+•• ••••• •••••••••••@•••••.com

Senior Data Analyst · Arcserve · 5 yrs

  • Open to Bangalore
  • Remote, Hybrid

Ask about Somshubhra

Skills

Claimed

B2C Business Model KnowledgeBusiness AnalysisReport CustomizationProduct Data AnalysisWork Planning and PrioritizationDatabase ManagementQuery WritingTechnical TroubleshootingTeamworkUnstructured Data ProcessingBusiness Growth StrategyB2B Market Understanding

Proof of Experience

Senior Data Analyst

Arcserve · Nov 2024 – Present

  • Designed and optimized complex SQL queries using joins, CTEs, subqueries, and window functions to support operational and financial analysis.
  • Analyzed large-scale enterprise datasets to identify trends, anomalies, and performance gaps across business operations.
  • Built and maintained automated analytical reports by integrating data from multiple enterprise systems.
  • Developed interactive Power BI dashboards to track KPIs, operational performance, and business trends for leadership teams.
  • Performed data validation and quality checks to ensure accuracy and consistency across reports and dashboards.
  • Automated recurring reporting workflows using Excel Power Query and Pivot Tables, reducing manual effort by 30%.
  • Conducted exploratory and trend analysis using Python (Pandas, NumPy) to generate actionable insights.
  • Collaborated closely with cross-functional stakeholders to translate business requirements into analytical solutions.
  • Standardized reporting and documentation to improve transparency, scalability, and audit readiness.
  • Defined and monitored key performance metrics to evaluate business performance, process efficiency, and outcome trends.
  • Delivered insight-driven recommendations through clear data storytelling, enabling leadership to make informed, data-backed decisions.
Infosys

Senior Data Analyst

Infosys · Nov 2023 – Nov 2024

  • Designed and optimized complex SQL queries using joins, CTEs, window functions, and subqueries, reducing report time by 40%.
  • Built end-to-end reporting solutions by integrating data from multiple enterprise source systems.
  • Developed Power BI dashboards with interactive visuals, slicers, and drill-downs for leadership reviews.
  • Automated data transformation and cleansing using Power Query in Excel and Power BI.
  • Performed data validation and reconciliation between SQL outputs, Excel reports, and BI dashboards.
  • Conducted exploratory data analysis using Python to identify trends, anomalies, and seasonality.
Infosys

Data Analyst

Infosys · Feb 2022 – Nov 2023

Infosys

Data Analyst

Infosys · Nov 2021 – Nov 2023

  • Created analytical and operational reports using Excel (Pivot Tables, advanced formulas).
  • Analyzed ServiceNow ticket data to track incident trends, resolution time, backlog, and SLA compliance.
  • Supported operational and product teams with data-driven insights for performance improvement.
  • Collaborated with stakeholders to define KPIs and reporting requirements.
Infosys

System Engineer trainee

Infosys · Nov 2021 – Feb 2022

Proof-of-Work

No completed sessions yet. Anything Somshubhra finishes shows up here with the evidence behind it.

Proof of Education

B.Tech, Electronics and Communications Engineering

MCKV Institute of Engineering · 2017 — 2021

A Proof CV — one profile, kept current, with the proof attached. Back to the portal