Abhisheik Kalia - Business Intelligence Professional
Masters in Business Data Science & Analytics from Michigan State University, transforming complex data into actionable business insights.
Contact Me
Professional Summary
With a deep commitment to leveraging data for business solutions, I served as a Business Intelligence Analyst at TWO MEN AND A TRUCK®, where I transformed complex data sets into actionable business insights. My role encompassed collaborating with stakeholders to optimize product development and marketing strategies, a testament to my expertise in data-driven decision making.
As I recently completed my MS in Business Data Science and Analytics at Michigan State University, I integrate academic knowledge with real-world applications, enhancing customer experiences and business outcomes through predictive modeling. My analytical acumen, honed through rigorous education and hands-on experience, drives my pursuit of excellence in data optimization and business strategy.
Apart from professional life, I am also an avid Football (Soccer) follower and love gaming as well.
Technical Expertise
Programming & Analytics
SQL, R, Python, Microsoft Excel, C++ (OOP concepts), Visual Studio, Microsoft Fabric, SAP MDG
Business Intelligence Tools
Tableau, Power BI, DAX, Power Query, M Query, Data Modeling, Statistical Modeling, Data Warehousing, ETL, KPI Dashboards, Data Visualization, Alteryx
Data & Reporting
Report writing, Data Mining, Predictive Modeling, Google Analytics, Linear regression, Agile methodology, Cloud Data warehousing, Azure, GCP (Google Cloud Platform)
Soft Skills
Strategic Thinking, Client Needs Analysis, Communication, Time Management, Collaboration
Certifications/Courses
  • Advanced SQL: MySQL for Ecommerce Data Analysis
Professional Experience
TWO MEN AND A TRUCK® | Business Intelligence Analyst
June 2024 - August 2025 | Lansing, Michigan, United States
Dashboard Development
· Drove revenue analytics by integrating and analyzing multi-source transactional data; designed dynamic Power BI dashboards that uncovered margin gaps and growth opportunities, helping leadership improve revenue plans and pricing strategies by an estimated 8–10 %.
· Delivered KPI-driven dashboards and paginated reports on schedule, providing actionable insights into sales, profitability, and customer trends to internal and external stakeholders and shortening decision cycles by 30 %.
Data Optimization
Optimized complex SQL queries and ETL pipelines, reducing run times by 20 %, improving daily revenue and operational reporting accuracy, and enabling near real-time monitoring of key financial metrics.
Reporting Accuracy
Created new Power BI dashboards while implementing Row Level Security (RLS) for franchises across the country and overseas to replace old SharePoint reports, improving reporting speeds by 40%
Built ETL pipelines to extract, transform, and load data from multiple sources, ensuring data integrity. Developed data models to support business intelligence initiatives, enhancing reporting accuracy and usability. Collaborated with teams from finance, operations and branch managers to implement data-driven solutions, fostering a company-wide focus on performance metrics.
Previous Experience
Infosys | Business Analyst/Systems Engineer
India
1
Leadership
Led a data-driven final training project, managing a team of four, to deliver a student registration portal
2
Process Improvement
· Automated master-data workflows and streamlined validation/reconciliation testing, cutting approval cycles by ~85 % and accelerating the release of new product and packaging records across North and Latin America.
· Analyzed and standardized material-master and packaging data for 10,000+ SKUs, reducing data defects and rework while ensuring compliance with global quality and regulatory standards.
Conducted data validation, analysis, and unit testing, ensuring reliable business processes. Prepared detailed technical specification documentation for client reference and internal use
3
· Configured and enhanced enterprise data systems to support new product launches and market expansions, increasing data accuracy and downstream supply-chain efficiency.
· Performed end-to-end testing, root-cause analysis, and code reviews to safeguard data integrity and cut incident resolution time by 20 %.
· Delivered actionable data insights and KPI reports to business and IT leadership, supporting pricing, procurement, and inventory optimization decisions.
Partnered with cross-functional teams to gather and document business requirements, translating them into data models and process improvements that improved reporting speed by 30 %.
Internship Experience
1
UNO MINDA Group Production Intern
April 2019 - July 2019 | Gurgaon, India
  • Reduced rejection of the YCA red lens by 59.8%
  • Visualization of the Moulding department using the 5S method
2
Mahindra & Mahindra Ltd., FES, Swaraj Division
January 2019 - April 2019 | Mohali district, Punjab, India
  • Quality check for various parts exported to Srilanka
  • Created rack for parts transported to Nabha to reduce damage
  • Visited different suppliers for personal Audit and evaluations
3
Gulf Consult Trainee
June 2018 - July 2018 | Kuwait
  • Learned to interpret drawings and plans
  • Gained knowledge of HVAC, plumbing and Fire fighting plans
Projects
Capstone Project (MSU) Automotive Industry Sponsor
September – December 2023
  • Utilized DAX and data modeling in Power BI to create reusable measures and dimensions, empowering end-users with self-service data exploration capabilities.
  • Collaborated with cross-functional teams to gather requirements and deliver tailored dashboards addressing specific analytical needs.
  • Developed a robust and integrated analytics program to evaluate impact and support strategic decision-making.
Purchase to Pay Optimization for Deloitte
February – May 2024
  • Conducted R-based analysis of SAP data to identify inefficiencies in early payments and goods receipt processes.
  • Performed in-depth research and analysis, providing valuable insights and recommendations to optimize the Purchase to Pay (P2P) process, enhancing workflow efficiency and data management.
Adventure Works & Maven Market (Power BI Desktop)
June – July 2023
  • Developed interactive dashboards using Power BI to analyze key performance indicators (KPIs), sales trends, and regional performance.
  • Extracted actionable insights from CSV data files to identify high-value customers and assess product profitability.
Education
1
Michigan State University - Eli Broad College of Business
Master of Science - MS, Business Data Science and Analytics - GPA: 3.95/4.0
January 2024 - December 2024
2
Thapar Institute of Engineering and Technology
Bachelor's degree, Mechanical Engineering
2016 - 2020
Made with