AMAN SINHA

• Data Analysis & Reporting: Managed project tracking using SQL, Excel, Power BI, and cloud-based data pipelines, ensuring data accuracy and actionable insights for the ₹350 Cr DDUGJY Electrification & Substation Project and ₹280 Cr Bengaluru Underground Cabling Project.
• Project Planning & Forecasting: Led data-driven project planning to optimize scheduling, resource allocation, and milestone tracking for EPC electrification, substation, and underground cabling projects.
• Machine Learning for Predictive Analytics: Developed ML models to predict project delays, optimize work scheduling, and enhance operational efficiency.
• Cloud Computing & Data Storage: Utilized Google Cloud, AWS S3, and BigQuery to store and analyze large datasets
• SCADA & PLC Integration: Worked on SCADA & PLC-based automation for power distribution projects, improving monitoring and control efficiency.
• Supply Chain Data Optimization: Analyzed vendor performance, running bill computations, and supply chain efficiency using Python & SQL.
• Cost & Contract Analysis: Built and maintained cost estimation models, ACE reports, and price variation models using SQL queries and Excel macros.
• Process Automation: Automated invoice certification & data validation workflows using Python and Excel VBA, reducing manual efforts by 30%.
• Geospatial Analysis for Electrification & Cabling Planning: Used GIS & Python to analyze grid expansion, optimize substation locations, and improve underground cabling efficiency

key Achievements:

• Successfully implemented a data-driven cost estimation model, reducing budget deviations by 15%.
  Developed an automated project tracking dashboard using Power BI, improving reporting efficiency by 30%.
  Led data analysis for DDUGJY Electrification Project (₹350 Cr) & Bengaluru Underground Cabling Project (₹280 Cr), ensuring optimal planning and execution.

• Performed in-depth evaluations on power distribution data, contract analysis, and technical project execution and suggested efficiency improvements.
• Developed and recommended engineering solutions for custom medium voltage and low voltage switchgear and switchboards
• Utilized my knowledge of power and distribution systems, circuit calculations, and instrumentation

• Performed thorough research and analysis on data and created reports on research activities.
• Conducted data analysis on recruitment trends and built interactive dashboards using Power BI to track hiring patterns.