Somshubhra Giri

Data Scientist

Bengaluru, Karnataka, India4 yrs 4 mos experience

Highly Stable

Key Highlights

Expert in SQL and Power BI for data visualization.
Automated reporting workflows reducing manual overhead.
Strong background in data storytelling for business insights.

Stackforce AI infers this person is a Data Analyst specializing in SaaS analytics and business intelligence.

Contact

Skills

Core Skills

Data AnalysisSqlPower Bi

Other Skills

ExcelPythonDatabase Management System (DBMS)IT Business AnalysisAdvanced excelRDBMSJavaProduct ManagementPerformance AnalysisProduct AnalysisNumPyPandasMatplotlibSeabornData Cleaning

About

Results-driven Data Analyst with 4.4 years of proven experience in transforming raw data into actionable business insights across finance, sales, and operations domains. Expert in SQL, Excel, and Power BI for building dynamic dashboards, cleaning complex datasets, and monitoring key performance indicators (KPIs). Skilled in automating reporting workflows and reducing manual overhead to support faster, data-backed decision-making. Adept in data storytelling and process improvement, with hands-on exposure to Python (NumPy, Pandas, Seaborn & Matplotlib) and SQL Server for advanced analytics and database management. Passionate about delivering value through clear visualizations and strategic insights that drive business growth.

Experience

Arcserve

Senior Data Analyst

Nov 2024 – Present · 1 yr 4 mos · Bengaluru · Remote

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.
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.

SQLPower BIExcelPythonData AnalysisDatabase Management System (DBMS)

Infosys

3 roles

Senior Data Analyst

Promoted

Nov 2023 – Nov 2024 · 1 yr

Designed and optimized complex SQL queries using joins, CTEs, window functions, and subqueries to support high-volume reporting, reducing report generation time by 40%.
Built end-to-end reporting solutions by extracting data from multiple source systems, performing data cleaning and transformation, and delivering analytics-ready datasets.
Developed Power BI dashboards with interactive visuals, filters, and drill-downs to track KPIs, user behavior, SLA metrics, and operational performance for leadership reviews.
Implemented Power Query transformations in Excel and Power BI to automate data cleaning, deduplication, data type standardization, and business rule application.
Performed data validation and reconciliation between SQL outputs, Excel reports, and Power BI dashboards to ensure accuracy and consistency.
Conducted exploratory data analysis (EDA) using Python (Pandas, NumPy, Matplotlib, Seaborn) to identify trends, anomalies, seasonality, and performance gaps.
Created analytical reports using Excel (Pivot Tables, advanced formulas, VLOOKUP/XLOOKUP) to support operational and product teams.
Analyzed ServiceNow ticket data to track incident trends, resolution times, backlog, and SLA compliance, providing insights to improve operational efficiency.
Collaborated closely with stakeholders, product owners, and operations teams to gather requirements, define KPIs, and translate business questions into analytical solutions.
Documented SQL logic, data models, and reporting workflows, improving knowledge transfer and reducing dependency on manual explanations.