SURAJ KUMAR MOHAPATRA
Bengaluru,India
Summary
Data Analyst with 4.5+ years of experience in a product-based SaaS environment, specializing in SQL-driven analysis, Python automation, and business intelligence. Team Lead and L3 escalation owner supporting enterprise-scale datasets across banking, insurance, connector platforms, and oil & gas domains. Known for resolving high-impact data issues, improving reporting accuracy, and delivering stakeholder-ready insights under pressure.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work history
Team Lead – Data Analyst & Product Support
CXWAI Tech India Pvt Ltd
Bengaluru, India
06.2024 - 01.2026
- Led a team of analysts/support engineers while owning end-to-end data analysis for 10+ enterprise projects, enabling faster, data-backed business and product decisions.
- Served as L3 escalation owner for P0/P1 analytics and data integrity issues, driving structured root-cause analysis and reducing investigation time by 30-40%.
- Analyzed millions of transactional and campaign records using advanced SQL to identify trends, anomalies, and logic gaps impacting reporting accuracy.
- Strengthened data accuracy and trust by reconciling data across MySQL, Snowflake (analytical warehouse), and MongoDB (NoSQL source systems), significantly reducing repeat escalations.
- Designed and automated Excel-based KPI dashboards, improving operational visibility and eliminating 20+ hours of manual reporting per month.
- Built and enhanced Power BI dashboards for campaign performance, delivery metrics, and anomaly tracking, actively used by cross-functional stakeholders.
- Applied Python (Pandas) to automate recurring data checks and analyze semi-structured datasets, accelerating complex investigations and validations.
- Debugged Python- and PHP-based data processing logic during L3 escalations to trace root causes of data mismatches, pipeline issues, and reporting anomalies across source and analytical systems.
- Mentored team members on SQL analysis, RCA, and dashboarding best practices, improving analytical consistency and quality.
- Collaborated with Product, Engineering, and DevOps teams to translate ambiguous business questions into actionable insights and data-driven recommendations.
- Delivered clear, executive-ready reports and presentations, translating technical findings into measurable business impact.
L2 Engineer – Analytics & Data Support
CXWAI Tech India Pvt Ltd
Bengaluru, India
12.2022 - 06.2024
- Supported 8+ live enterprise projects, ensuring 97% SLA adherence through proactive data analysis and prioritization.
- Automated recurring operational and client reports using SQL and Excel, improving consistency and turnaround time.
- Delivered ad-hoc analytical support during campaigns, releases, and high-traffic periods.
- Standardized data investigation workflows and documentation, improving resolution efficiency and knowledge transfer.
Network Administrator
Flexitech Consultants Pvt Ltd
Thane, India
08.2019 - 11.2021
- Managed and monitored infrastructure supporting 200+ endpoints, ensuring system availability and operational continuity.
- Performed network diagnostics and root-cause analysis using Wireshark and Nmap to identify performance and reliability issues.
- Implemented backup and recovery processes, reducing data loss incidents by 90% and improving system resilience.
- Developed a strong foundation in incident handling, troubleshooting, and operational analytics, later applied to data and product support roles.
Education
Executive PG - Software Development & Cyber Security
International Institute of Information Technology
Bengaluru, India 01.2022 - 03.2023
Bachelor of Technology - Mechanical Engineering (Electronics Minor)
National Institute of Science and Technology
Odisha 06.2015 - 04.2019
Skills
- SQL: Advanced joins, CTEs, window functions, subqueries, aggregations, query optimization, data validation
- Python (Data Analytics): Pandas, NumPy, data cleaning, transformation, automation, exploratory data analysis (EDA)
- Excel (Advanced): Pivot tables, Power Query, advanced formulas (XLOOKUP, INDEX-MATCH), dashboards
- BI & Visualization Tools: Power BI, Tableau – KPI dashboards, trend analysis, drill-down reporting
- Data Analysis Techniques: Root cause analysis (RCA), anomaly detection, funnel analysis, cohort analysis, reconciliation
- Databases & Warehousing: MySQL, Snowflake, MongoDB
- Other Tools: Jira, Git
- Soft Skills: Stakeholder communication, data storytelling, documentation, presentation skills
Websites
Key Analytics Use Cases
- Campaign performance and conversion analysis
- Data reconciliation and mismatch analysis across systems
- Anomaly detection in transactional and engagement data
- Root cause analysis for analytics and reporting issues
- KPI and operational performance reporting
Awards & Recognition
- Most Respectful Employee – FirstHive
- Most Consistent Employee – FirstHive
- Team Excellence Award – FirstHive
Additional information
- Strong experience working with large datasets, complex data models, and production analytics
- Comfortable handling high-pressure, business-critical data scenarios
Timeline
Team Lead – Data Analyst & Product Support
CXWAI Tech India Pvt Ltd
06.2024 - 01.2026
L2 Engineer – Analytics & Data Support
CXWAI Tech India Pvt Ltd
12.2022 - 06.2024
Executive PG - Software Development & Cyber Security
International Institute of Information Technology
01.2022 - 03.2023
Network Administrator
Flexitech Consultants Pvt Ltd
08.2019 - 11.2021
Bachelor of Technology - Mechanical Engineering (Electronics Minor)
National Institute of Science and Technology
06.2015 - 04.2019