Mayuri Lohote

Data Analyst with 3+ years of experience collecting, manipulating, and presenting data to senior stakeholders, with hands-on experience in real estate occupancy analysis, procurement spend data, and CapEx/Savings tracking. Skilled in Power BI for real-time reporting and dashboards, advanced Excel for financial analysis and tracker maintenance, and automating data collection processes to reduce manual effort. Experienced delivering clear, concise, data-driven insights that influence cost-saving strategies and business decisions, and collaborating with Market, Legal, IT, and Finance teams across global operations.

Delivered a 92% reduction in report turnaround time and managed 17 production dashboards with zero post-production escalations.

Data Analyst - Cognizant

(2025-12)

• Collecting, manipulating, and processing procurement spend data and occupancy data for global operations, presenting clear, concise overviews to senior stakeholders to influence cost-saving strategies and vendor decisions.
• Leading occupancy analysis programs, automating monthly data collection workflows and delivering insights into office utilisation and real estate portfolio performance using Power BI for real-time reporting.
• Maintaining and updating Savings & CapEx trackers and lease portfolio data, ensuring records are accurate, insightful, and presented on time for 3 business units.
• Supporting financial analysis for real estate and operational projects, including business case documentation and presentation preparation for senior leadership.
• Automating reporting workflows and data collection processes to minimize manual effort, saving 6 hours of manual effort weekly, cutting query time by 37% and dashboard load times by 43%.
• Collaborating with Market, Finance, Legal, and IT teams; coordinating with external vendors and suppliers to support contract negotiations and process improvement initiatives.

Associate Software Engineer – Data Analyst - Tech Mahindra Limited

(2023-01 - 2025-11)

• Managed and analyzed occupancy and procurement spend data for global markets, building Power BI dashboards to track real estate portfolio metrics and deliver insights to senior stakeholders.
• Built and maintained CapEx/Savings trackers and financial analysis models in Excel, supporting cost-saving initiatives and real estate leasing and renovation project decisions.
• Automated data collection and lease tracker updates, reducing manual reporting turnaround time from 2 hours to 9.5 minutes.
• Managed 17 production dashboards and reporting solutions across multiple business domains with zero post-production escalations, maintaining data accuracy and consistency.
• Developed optimized SQL queries using CTEs, window functions, and stored procedures; collaborated with cross-functional stakeholders during requirement gathering, UAT, and production support.
• Prepared business case narratives, financial summaries, and stakeholder presentations; mentored junior analysts in data analysis and reporting best practices.

Bachelor of Engineering - Computer Science - Savitribai Phule Pune University (2020-06 - 2023-05)