AMANDEEP SINGH
Mechanical Engineering
durgapur
Summary
Business Analyst applying SolidWorks and ANSYS FEA to model bridge components, test load cases, and evaluate structural integrity. Refines designs through failure analysis, material efficiency checks, and iterative simulation results. Produces 2D drawings and technical documentation in AutoCAD and MS Office.
Overview
3
3
years of professional experience
Work History
Business Analyst
Candex AI
08.2025 - 09.2026
- Build Power BI dashboards from SQL-based datasets to track performance trends and operational KPIs.
- Clean and validate business data in SQL before analysis, strengthening reporting accuracy and consistency.
- Identify process gaps and deliver data-backed recommendations that support 15–20% operational efficiency improvements.
- Prepare recurring performance reports in Power BI to summarize dataset trends for operational review.
- Translate business data into clear findings that support performance reporting and decision-making.
Data Analyst
Clever Bharat
03.2025 - 06.2025
- Tracked [number] reporting requests weekly to support timely data delivery for internal stakeholders.
- Analyzed real-time and historical datasets with Python and SQL to surface trends and support business decisions.
- Automated reporting workflows to reduce manual effort and improve turnaround on recurring analytics deliverables.
- Created Power BI visualizations that translated complex data into clear, actionable insights for decision-making.
- Delivered concise reporting summaries that made recurring analysis easier to review and apply across teams.
- Supported stakeholders by clarifying analysis needs, validating data, and aligning outputs with reporting requirements.
Data Analyst Intern
Orbit Education
10.2024 - 02.2025
- Analyzed datasets in SQL and Excel to extract actionable insights for reporting accuracy and decision support.
- Developed Power BI dashboards for ride analytics, delivery performance, and e-commerce sales tracking.
- Improved reporting consistency by combining SQL outputs with Excel workflows for recurring business updates.
- Validated dashboard inputs and output logic to strengthen data quality across analytics views.
- Streamlined recurring reporting tasks by organizing analysis outputs for faster review and presentation.
Business Analyst Intern
Aadesh Foundation
06.2024 - 08.2024
- Analyzed operational KPI trends in Excel to identify cost-saving and process-efficiency opportunities.
- Developed Power BI dashboards for service-quality data, improving visibility for monitoring and allocation decisions.
- Translated service-quality findings into reporting outputs that supported better resource allocation and operational monitoring.
Design and Failure Analysis of Bridge
IIT Roorkee
08.2023 - 11.2023
- Performed CAD-based structural design and failure analysis using SolidWorks and ANSYS for 3D modeling and FEA simulation.
- Tested structural behaviour under multiple loading conditions to evaluate integrity, response patterns, and material efficiency.
- Refined the bridge design iteratively from FEA findings and engineering judgment to strengthen performance.
- Created detailed 2D drawings in AutoCAD and prepared technical documentation in MS Office.
Education
Bachelor of Technology - Mechanical Engineering
Indian Institute of Technology (IIT) Roorkee
01-2026
Class XII - undefined
Lal Bahadur Shastri Sr. Sec. School
Ranpurkotarj01-2022
Class X - undefined
Manisha International School
Durgapur01-2020
Skills
SolidWorks
AutoCAD
ANSYS
SQL
Power BI
Dashboard development
KPI tracking
Data visualization
Reporting automation
Root cause analysis
Dashboard development
Requirements gathering
Business process mapping
Stakeholder management
Process improvement
Operational analysis
Data validation
Accomplishments
- Secured AIR 7932 in JEE Advanced.
- Participated in Mecholympia cricket tournament at IIT Roorkee.
POSITIONS OF RESPONSIBILITY
- Executive Member (Operations) | NCC – National Cadet Corps, IIT Roorkee | Mar 2023 – Dec 2023
- Coordinator – Bridge-O-Mania | Cognizance, IIT Roorkee | Mar 2024
- Executive Member | Student Technical Council (STC), IIT Roorkee | Jun 2023 – Present
Timeline
Business Analyst
Candex AI
08.2025 - 09.2026
Data Analyst
Clever Bharat
03.2025 - 06.2025
Data Analyst Intern
Orbit Education
10.2024 - 02.2025
Business Analyst Intern
Aadesh Foundation
06.2024 - 08.2024
Design and Failure Analysis of Bridge
IIT Roorkee
08.2023 - 11.2023
Class X - undefined
Manisha International School
Class XII - undefined
Lal Bahadur Shastri Sr. Sec. School
Bachelor of Technology - Mechanical Engineering
Indian Institute of Technology (IIT) Roorkee