Kriti Mehrotra

Navi Mumbai

Summary

Business Analyst with a broad-based background in highly competitive and dynamic organizations, leveraging advanced Excel and data analysis skills to enhance operational efficiency. Successfully identified improvement opportunities, driving strategic initiatives that align with business goals. Passionate about delivering impactful solutions and optimizing stakeholder engagement.

Overview

years of professional experience

Certification

Work History

Business Analyst

Sciative Solutions

Navi Mumbai

04.2025 - Current

Conducted onboarding analysis for new clients, evaluating ridership data to identify high-demand routes configured new routes into the company's AI model.
Conducted pricing analysis utilizing Excel and internal tools to ascertain competitive bus fares influenced by demand, ratings, time of travel, and market competition.
Collaborated with cross-functional teams to align data insights with strategic goals and business requirements.
Analyzed business processes to identify improvement opportunities through automation or streamlining.
Facilitated brainstorming sessions with cross-functional teams for problem solving activities.
Identified gaps between thecurrent state and desired future state operations.

Software Engineer

LTIMindtree

Mumbai

09.2021 - 07.2023

Developed automation scripts based on business needs, reducing website downtime by 3%.
Created technical specifications and optimized routing, cutting website deployment time by 4%.
Improved stakeholder communication by 3% through effective collaboration and detailed documentation, reducing search time by 3.5%.
Designed and executed efficient workflows in Power BI and Excel, enabling accurate data-driven decisions and cutting reporting time by 3%.

Education

Master of Science - Management Information Systems

University of Manchester

Manchester, United Kingdom

12-2024

Bachelor of Technology - Computer Engineering

Bharati Vidhyapeeth University

Pune, India

08-2021

Skills

Wireframing
SQL queries
Advanced Excel
Data analysis
Power BI

Stakeholder communication and engagement
Cross-functional collaboration
Pivot tables
Strategic planning

Certification

PRINCE2 Agile Certification (In progress)
Business Analyst Professional Certificate
Business Analysis and Process Management

Projects

Tata Data Visualisation: Empowering Business with Effective Insights Job Simulation on Forage

· Completed a simulation involving creating data visualizations for Tata Consultancy Services.

· Prepared questions for a meeting with client senior leadership

· Created visuals for data analysis to help executives with effective decision-making

Operation and Metrics Analysis

Analyzed key operational metrics to identify inefficiencies, track performance trends, and optimize resource allocation.

Timeline