Ayush Gupta

Operations Associate

Bengaluru, Karnataka, India6 yrs experience

Key Highlights

6 years of experience in IT operations and data analytics.
Expert in incident management and SLA compliance.
Proficient in SQL, Power BI, and data visualization.

Stackforce AI infers this person is a Data Analyst with strong IT operations expertise in enterprise environments.

Contact

Skills

Core Skills

Data VisualizationData AnalysisIncident ManagementApplication DevelopmentData Management

Other Skills

Microsoft Power BIMicrosoft ExcelExcel AutomationAnalytical SkillsPower BIHTMLJavaSQLPHPEscalation ResolutionCustomer callRoot Cause AnalysisEscalations ManagementCustomer Escalation ManagementCommunication

About

• Data Analyst & IT Operations Professional with 6 years of experience in Incident Management, ITSM operations, and data-driven reporting within large enterprise environments. • Managed critical incidents and major incident bridges, ensuring quick resolution, SLA compliance, and minimal business impact across global IT infrastructure. • Worked extensively with ITSM tools and operational dashboards, supporting service monitoring, incident tracking, and performance reporting. • Developed workflows using SSIS, improving reporting automation and enabling better operational insights for business teams. • Built analytical dashboards and reports using SQL, Excel, and Power BI, helping teams monitor KPIs, identify trends, and improve decision-making. • Collaborated with cross-functional teams including engineering, operations, and support teams to resolve high-priority incidents and improve operational efficiency. • Completed a Masters in Data Science & Artificial Intelligence from IIIT Bangalore, strengthening expertise in: • Data Analytics • SQL & Python • Data Visualization • Machine Learning fundamentals • Bachelor of Technology in Computer Science from VIT University, Vellore. • Passionate about using data analytics to improve operational efficiency, business decision-making, and process optimization through: • Data analysis • SQL & Python • Dashboard development • Process automation

Experience

6 yrs

Total Experience

2 yrs 6 mos

Average Tenure

11 mos

Current Experience

Schneider electric

Planning Data Analyst

Jul 2025 – Present · 11 mos · Bengaluru, Karnataka, India · On-site

1.Built Power BI dashboards to monitor workload distribution, service performance, and operational metrics, enhancing visibility for leadership review.
2.Streamlined weekly capacity planning reports using Excel automation and Power Apps, ensuring timely data availability for operational planning.
3.Analyzed KPI trends and provided performance insights to support continuous process improvement and operational stability.

Microsoft Power BIMicrosoft ExcelData VisualizationData Analysis

Ericsson

Associate Engineer

Aug 2022 – May 2025 · 2 yrs 9 mos · Bengaluru, Karnataka, India · On-site

1. Managed end-to-end L2 Incident Management under ITIL framework using BMC Remedy, improving SLA compliance by 20%.
2. Coordinated Major Incident Management (MIM) calls with cross-functional teams to ensure timely resolution of high-priority tickets.
3. Performed Root Cause Analysis (RCA) and collaborated with Network Operations to reduce recurring critical incidents by 40%.
4. Communicated escalation updates to stakeholders and management, ensuring transparency and faster resolution.
5. Prepared SLA and performance dashboards using Excel and Power BI for management review.

Microsoft ExcelAnalytical SkillsIncident ManagementData Analysis

Fujitsu

Application Developer

Oct 2015 – Feb 2018 · 2 yrs 4 mos · Pune, Maharashtra, India · On-site

1.Provided L2 support and production issue resolution using ServiceNow in a retail enterprise project.
2.Designed and maintained SQL queries for reporting and data validation.
3.Built and optimized SSIS ETL packages processing large datasets.
4.Improved data accuracy and reporting efficiency through SQL enhancements.

HTMLMicrosoft ExcelApplication DevelopmentData Management

Siemens

Internship

Nov 2012 – Dec 2012 · 1 mo · Gurugram, Haryana, India · On-site

1. Developed an attendance management system using Java and SQL, creating user-friendly interfaces for efficient attendance tracking.
2. Managed and secured 10K+ attendance records in databases, ensuring 99.9% data accuracy and strengthening data security protocols.
3.Conducted testing and debugging, delivering progress updates and refining the application based on team feedback.

HTMLPHP