Headline

Power BI & Excel Expert | Transformed Nationwide MIS Ops for 246+ Branches | Cut Manual Reporting by 40% | Driving Data-Led Decisions in Banking & GovTech

About

I'm a Data & Business Intelligence professional with 3+ years of experience transforming MIS operations into high-impact reporting engines. At Alankit Ltd., I’ve managed analytics across 246+ branches for clients like YES Bank and IDBI Bank, building automated dashboards and reporting tools that reduce manual work and boost decision-making speed. From automating weekly reports with Excel VBA to building Power BI dashboards for HR, finance, and revenue tracking, I specialize in turning raw, scattered data into clear insights that drive action. My work supports everything from onboarding compliance with UIDAI to strategic planning at the zonal and national levels. Tools I use every day: Power BI, SQL, Excel (advanced), Google Sheets, Power Query, and DAX. I’m also certified in GCP and Business Intelligence and always looking for ways to level up processes, not just report on them. Let’s connect if you're looking for someone who brings both technical depth and business context to your data strategy.

Location

New Delhi

Work experience

Management Information System Executive at Ultra Audio Private Limited, Feb 2026 - Present · 5 mos, ▸ Maintain and update large-scale employee and operational databases using Google Sheets and MS Excel, ensuring 100% data accuracy and integrity across all records. ▸ Design and manage comprehensive HR analytics dashboards tracking headcount, attrition trends, recruitment funnels, and performance metrics — updated on weekly and monthly cycles for senior leadership. ▸ Develop advanced Excel models leveraging VLOOKUP, HLOOKUP, INDEX-MATCH, Pivot Tables, and Array Formulas to automate high-frequency recurring reports, reducing manual effort significantly. ▸ Create high-impact PowerPoint presentations for senior management visualizing workforce KPIs, attrition insights, and operational trends to support strategic planning decisions. ▸ Identify and resolve bottlenecks in data collection and reporting workflows; implement automated solutions to streamline processes, enhance accuracy, and enable near real-time dashboard delivery. ▸ Produce structured weekly and monthly MIS reports consolidating multi-source data into executive-ready summaries, ensuring timely and data-driven management reviews.

Senior Customer Support Executive at Ienergizer IT Services Pvt. Ltd., Jul 2025 - Feb 2026 · 8 mos, ▸ Managed high-volume customer interactions across voice, email, and chat channels, maintaining performance KPIs including CSAT scores, resolution time, and quality benchmarks. ▸ Analyzed recurring customer concerns and leveraged CRM data to recommend process improvements, contributing to measurable reductions in escalation rates. ▸ Trained and mentored junior executives on service protocols and CRM tool usage, improving team efficiency and adherence to service standards. ▸ Coordinated with technical and operations teams to resolve complex queries, ensuring seamless multi-channel service delivery.

Management Information System Analyst at Alankit, Jul 2022 - Jul 2025 · 3 yrs 1 mo, New Delhi, Delhi, India, Directed data operations for 246+ branches across multiple banking clients including Yes Bank, Kotak Mahindra Bank, and IDBI Bank, ensuring compliance and smooth onboarding processes. Designed and implemented Power BI dashboards for sales, operations, and HR KPIs, significantly improving stakeholder visibility and decision-making capabilities. Resolved critical data discrepancies through comprehensive reconciliation with UIDAI servers, achieving 100% data accuracy and compliance. Conducted training sessions on Advanced Excel and BI tools for junior staff, enhancing overall team technical capability and productivity. Engineered Excel-based inventory tracking tools and automated workflows, enhancing operational efficiency and reporting accuracy by 60%. Collaborated with cross-functional teams on UIDAI government initiatives, supporting large-scale policy execution and implementation. Delivered a 25% productivity increase through the introduction of structured one-to-one mentoring programs for supervisor development teams.

Education

Bachelor of Commerce - BCom, Business/Managerial Economics, Delhi University

Data Modeling/Warehousing and Database Administration, SLA Institute - India