Yughandhar

Analyst | Technical Operations

Kovvur, Andhra Pradesh 2+ yrs exp 84 · Excellent

About

Data Analyst professional with hands-on experience in SQL, Python (Pandas, NumPy), and Excel-based analytics, skilled at collecting, cleaning, and validating data and turning it into clear reporting for business stakeholders. Experienced in designing structured, analytics-ready data models (MySQL) and building dashboards that surface trends and KPIs for decision-making. Automated recurring reporting workflows, reducing manual effort by 50%, and collaborated cross-functionally to drive root cause analysis and process improvement. Independently built a SQL data-cleaning project and a full-stack analytics dashboard (Python/Flask/MySQL) with KPI tracking and data visualization. Bachelor's degree in Computer Science with a strong, self-driven foundation in data analysis, data quality, and exploratory analysis, seeking to apply this toolkit to customer intelligence and market research reporting.

Skills & Expertise (35)

Advanced Excel Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Documentation If COUNTIF Conditional Formatting Trend Analysis Root Cause Analysis stakeholder communication Business Reporting Cross-Functional Collaboration IT service management ITSM Incident Management Service Request Management Identity and Access Management IAM VLOOKUP Pivot Tables KPI Dashboard Development Data Quality validation Data Cleaning database design Data Modeling Exploratory data analysis NumPy Pandas Window Functions Aggregations Joins

Work Experience

Analyst – Technical Operations

Microland Limited

Jul 2024 - Present

Collected and analyzed operational data to deliver weekly business reports on ticket volumes, resolution rates, and escalation patterns, using Pivot Tables, VLOOKUP, IF, and COUNTIF to identify trends for management decision-making. Automated recurring reporting workflows with advanced Excel formulas, reducing manual reporting effort by 50% and improving data accuracy and turnaround time. Validated and maintained data quality across 2000+ incidents and service requests, ensuring consistent SLA compliance and reliable reporting inputs. Collaborated with cross-functional IT teams to frame problems, conduct root cause analysis, and translate findings into process improvements that accelerated recurring-incident resolution. Administered Active Directory (AD) and Identity & Access Management (IAM) user lifecycle processes, maintaining accurate, well-governed data records across the enterprise. Documented technical processes and knowledge base articles, supporting clear communication of methodologies and streamlining onboarding for new team members.