IDA MENSAH
Franklin,TN
Overview
3
3
years of professional experience
Work History
Planning Data Analyst
Schneider Electric
01.2025 - Current
- Developed and automated data pipelines in Databricks to streamline the Supply Review process for the Secure Power Business Unit, significantly reducing manual effort and improving data accuracy.
- Designed and deployed interactive dashboards in Tableau to visualize key planning metrics such as Excess Inventory Burn-Off, Backlog Depth, Forecast Accuracy, and Forecast Bias, enhancing visibility for executive and planning teams.
- Extracted and transformed planning and supply chain data from the Kinaxis RapidResponse system to serve as the foundation for Databricks-based analytics and Tableau reporting.
- Built end-to-end business intelligence solutions — from data extraction and transformation to dashboard design — to support strategic planning and operational execution.
- Produced and delivered accurate, visually effective PowerPoint presentations for weekly Demand & Supply Review (DSR) meetings, ensuring timely and data-driven decision-making.
- Ensured data consistency and accuracy across systems through rigorous validation, reconciliation checks, and documentation of data logic and workflows.
- Documented data workflows, business logic, and dashboard functionalities to support knowledge transfer and long-term maintainability.
Data Analyst
Schneider Electric
01.2024 - 12.2024
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Reduced operating costs by automating manual data processes using scripting languages such as Python.
- Implemented robust quality control measures to minimize errors and improve the reliability of analytical outputs.
- Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing the adaptability of solutions provided.
- Resolved complex business challenges by leveraging advanced analytics to build scalable solutions.
Transport Business Analyst
Schneider Electric
02.2023 - 01.2024
- Responsible for collecting and cleaning transport data to be used in analysis.
- Reduced operational costs through thorough data analysis and implementing cost-effective solutions.
- Enhanced company-wide decision-making by developing comprehensive reports on key performance indicators.
- Enabled data-driven decision making with advanced analytics tools, generating valuable insights for the organization.
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Generated business intelligence reports to inform strategic decision-making.
Education
Master of Science - Masters, Information Systems BI And Data Analytics
Middle Tennessee State University
Murfreesboro, TN12.2022
BBA - Bachelors , Accounting And Business Management
Middle Tennessee State University
Murfreesboro, TN05.2020
Skills
- Data Analysis & Interpretation
- Data Visualization (Tableau, PowerPoint)
- Business Intelligence (BI) Tools – Tableau
- Data Extraction & Transformation (SQL, Databricks, Kinaxis, Dbeaver)
- SQL Databases
- Python for Data Manipulation
- Excel (Advanced Functions, Pivot Tables, Lookups)
- Data Cleaning & Validation
- Analytical Problem Solving
- Attention to Detail
- Stakeholder Communication & Presentation
- Strong Work Ethic & Accountability
PROFILE
Results-driven data professional with keen eye for detail and passion for uncovering actionable insights from data. Proven track record of utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented with strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments.
Timeline
Planning Data Analyst
Schneider Electric
01.2025 - Current
Data Analyst
Schneider Electric
01.2024 - 12.2024
Transport Business Analyst
Schneider Electric
02.2023 - 01.2024
Master of Science - Masters, Information Systems BI And Data Analytics
Middle Tennessee State University
BBA - Bachelors , Accounting And Business Management
Middle Tennessee State University
Similar Profiles
Abhishek SinhaAbhishek Sinha
R&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric SoftwareR&D Manager at AVEVA Group PLC, A Schneider Electric, Schneider Electric Software
Süleyman KEYKUBATSüleyman KEYKUBAT
R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)R&D Mold and Project Executive at GÜNSAN ELECTRIC (SCHNEIDER ELECTRIC)
Enrique DiazEnrique Diaz
Logistics Shipping Coordinator at Schneider ElectricLogistics Shipping Coordinator at Schneider Electric
Nichole KellyNichole Kelly
Customer Support Manager at Schneider ElectricCustomer Support Manager at Schneider Electric
Ella Matilda KoeckeElla Matilda Koecke
Marketing and Public Relations Intern at Anna Wink JewelryMarketing and Public Relations Intern at Anna Wink Jewelry