Somshubhra Giri
Contact details — on requestProof of Work — on request
Experience
A
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.
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.
Data Analyst
Infosys · Feb 2022 – Nov 2023
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.
System Engineer trainee
Infosys · Nov 2021 – Feb 2022
Skills 0 proven through work
Also works with
B2C Business Model KnowledgeBusiness AnalysisReport CustomizationProduct Data AnalysisWork Planning and PrioritizationDatabase ManagementQuery WritingTechnical TroubleshootingTeamworkUnstructured Data ProcessingBusiness Growth StrategyB2B Market UnderstandingBusiness AcumenSelf-Directed LearningKPI AnalysisData TransformationMicrosoft ExcelWorking with CSV FilesTabular Data Cleaning & Validationpandas UsageNumPyData VisualizationWork EfficiencyMicrosoft 365 UsageRoot Cause AnalysisData ValidationMarket SegmentationRequirements AnalysisData ExtractionDatabase Query OptimizationData ExportAnalytical Report CreationInvoice ProcessingData HandlingSales AnalysisPython DevelopmentPower BIData-Driven RecommendationsExploratory Data Analysis (EDA)
Proof of Work
Proof of Work
Somshubhra shares this with people who ask. You'll hear back either way.
Education
B.Tech, Electronics and Communications Engineering
MCKV Institute of Engineering · 2017 — 2021
Contact details
Contact details
Somshubhra shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal