Gagan Bansal Email & Phone Number

Memphis, TN, US

Minneapolis, MN, US

Solon, OH, US

Solon, OH, US

• Building Power BI reports providing data and insights to the Retail team to monitor sales, analyze performance, and communicate progress against objectives
• Automating Excel dashboards using VBA macros to reduce the report generation time, resulting in increased productivity

Cleveland, Ohio, US

• Maintain a database of students with documented disabilities and manage appointments for management.
• Create reports using Microsoft Excel to provide notetaking program status to management.

Marlborough, MA, US

• Improved the visibility of division-wide KPIs by 20%, through analyzing the procedural areas of improvement from old dashboards
• Boosted complaint handling process completion by 30% through the design of root cause reports in Power BI
• Collaborated with cross-division managers to perform cohort analysis, resulting in a 40% increase in Work In Progress productivity

Bengaluru, Karnataka, IN

• Reduced time spent on report generation by saving ~90 hours of monthly labor costs and improved the accuracy of reporting by 30% through the development and automation of reports and dashboards
• Successfully led a team of 2 analysts and streamlined the onboarding process by creating a training SOP, resulting in a 50% reduction in training time
• Aggregated data from over 20 sources to build the foundation of a new product led to an 80% increase in accuracy
• Optimized over 10 SQL queries runtime resulting in 20% improved performance in report load time

San Jose, California, US

• Increased the visibility of process completion by 70% through incorporating the email reminder in the newly migrated system
• Completed end-to-end analysis including data gathering, analysis & presentations resulting in a 30% increase in stakeholder satisfaction by leading collaboration across cross-functional partners
• Led the development team to ensure all the requirements were met, organized, and assessed by gathering, and analysis activities via collaborating with over 10 stakeholders
• Identified over 5 business process issues through document analysis, and collated transactional data using MS SQL Server
• Designed and developed wireframes, dashboards, and ad-hoc reports for customer data and drove decision-making using HTML, CSS, and Bootstrap

Noida, Uttar Pradesh, IN

• Aided with course planning and supervision of 50 + freshmen by acting as a mentor.
• Helped with the implementation and assessment of assigned projects and programs.

• Developed and tested user-friendly websites using HTML, CSS, Bootstrap, PHP, MySQL.
• Worked closely with Project Manager and Team Lead on Change request functions.

Master'S Degree, Management Information Systems, General

Btech - Bachelor Of Technology, Computer Science