Urvashi Varshney
MIS / Data Analyst
About
Results-driven MIS / Data Analyst with 5+ years turning operational data into actionable business insights across manufacturing, education, and events industries. Skilled in Excel, VBA, Macros, and Power BI for building automated trackers and dashboards, along with SQL, MS Access, and Python for data analysis, KPI reporting, and quality assurance. Hands-on experience with Microsoft 365 administration and strong stakeholder communication.
Skills & Expertise (26)
Work Experience
Team Developer (MIS)
Anaptyss
Nov 2025 - Present
Lead MIS operations across multiple business units, ensuring data integrity and accurate reporting for executive decision-making. Built automated Excel trackers using VBA and Macros, integrating outputs into Power BI to process large datasets and improve reporting turnaround time by 35%. Created a team tracker to monitor task allocation, progress, and deadlines across analysts, improving visibility and on-time delivery. Use MS Access for database administration, query development, and access control, cutting manual processing time. Wrote Python scripts to automate data cleaning, merging, and report generation across business units, cutting manual effort by 30% and improving reporting accuracy. Manage and mentor a team of 5 analysts, running QA checks that improved on-time delivery rates. Use AI tools (ChatGPT, Claude) to speed up documentation, report narratives, and ad hoc analysis.
MIS Analyst
M.Tech Equipments
Jan 2024 - Oct 2025
Analyzed production, machine performance, and supply chain data across multiple lines, flagging anomalies for management insights. Developed a VBA- and Macro-automated Excel sheet, later scaled into Power BI to handle 10,000+ rows, reducing manual reporting time by 40%. Wrote complex SQL/Access queries for data extraction and transformation (ETL), supporting dozens of monthly reports. Led data migration from legacy systems to updated Access platforms, maintaining secure, structured transfer. Used Python for basic data extraction and quick performance checks alongside SQL analysis.
MIS Executive
Shivdan Singh Institute of Technology & Management
Mar 2022 - May 2023
Managed institutional MIS for student records and administrative reporting, auditing data for accuracy. Automated Excel trackers with VBA and Macros for academic and attendance data, cutting manual workload and reporting time by 25%. Designed KPI dashboards covering academic performance and resource utilization, reducing report prep time. Maintained relational databases for student and faculty records in MS Access, ensuring data integrity. Used basic Python scripts to assist with data formatting and quick record checks.
MIS Analyst
Reliability Events and Promotion, Aligarh
Aug 2021 - Feb 2022
Designed Power BI dashboards and MIS reports used by stakeholders for business analytics and executive decisions. Used Advanced Excel and Access, with VBA-based automation, for data analysis, forecasting, and business intelligence reporting. Automated ServiceNow workflows for incident tracking and access control, reducing average resolution time. Collaborated with cross-functional teams and clients to gather requirements and deliver customized analytical solutions.
Education
B.Tech, Computer Science and Engineering - Institute of Technology and Management
- 2021 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Open to Relocation
Skills (26)
Click a skill to find developers with the same skill
