Ai Variant
|MIS Intern
Bengaluru, Karnataka, India
Summary
Managed comprehensive MIS reporting and data analytics across key projects, including Industrial Combustion Energy Use and Salesforce CRM, to drive operational efficiency and data-driven decision-making.
Highlights
Automated daily, weekly, and monthly MIS reports using Excel, SQL, and Power BI, reducing manual efforts by 40%.
Developed and maintained comprehensive daily, weekly, and quarterly MIS reports and dashboards for sales and non-sales teams, enhancing data accessibility and strategic decision support.
Designed and implemented advanced Power BI dashboards with complex visualizations (Bar-in-Bar, Bullet Graphs, Box Plots) to enhance data interpretation and stakeholder insights.
Wrote, optimized, and executed complex SQL queries, including Joins and schema alterations, to facilitate efficient data import/export and backend operations.
Streamlined data integrity by cleaning and transforming raw data, addressing missing values, standardizing formats, and eliminating inconsistencies using advanced Excel, SQL, and Power Query.
Delivered actionable insights and ad-hoc reports to operations, sales, and claims teams, driving informed decision-making and contributing to cost-saving initiatives and system enhancements.