Advanced Excel
Pivot Tables, VLOOKUP/HLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, dashboards, validation and conditional formatting.
I’m LC Rohith, an MIS Analyst focused on business reporting, dashboard development, data accuracy and actionable insights using Advanced Excel, SQL and Power BI.
01 / ABOUT
I work across MIS reporting and data analysis—extracting data, cleaning and validating it, building recurring reports, and creating dashboards that make business performance easier to understand.
My approach combines technical execution with practical business context: accurate reporting, useful KPIs and communication that works for technical and non-technical stakeholders.
02 / CAPABILITIES
Built for reporting, analysis and decision support.
Pivot Tables, VLOOKUP/HLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, dashboards, validation and conditional formatting.
SELECT, joins, subqueries, filtering, grouping, data manipulation and foundational query optimisation.
Interactive reports, visualisation, Excel/SQL connectivity, Power Query and foundational data modelling.
Daily, weekly and monthly reporting, data audits, KPI tracking, operational analysis and stakeholder communication.
03 / EXPERIENCE
Selected responsibilities and outcomes.
E-commerce · Shop Sphere Online Marketplace
04 / EDUCATION
Commerce foundation with analytics specialisation.
St Joseph’s
Ai Variant
Institute of Cost Accountants of India
05 / VIEW PERSON
A face behind the data, reporting and decisions.
06 / CONTACT
I’m open to MIS, reporting and data analyst opportunities.