Shubham Dwivedi

• Parent Company: Brahmaputra Infrastructure Ltd
  Child Companies: Socristo Enterprises, City Center Mall Guwahati, HeavyHire, Heavymatics
  Roles: Business Analyst | MIS Analyst | Product Analyst
• Government Tender Scouting and Acquisition:
  Utilized eProcurement portals, Python, BeautifulSoup, and Selenium to automate tender data extraction and analysis across multiple sectors, resulting in a 20% increase in tender acquisitions. Streamlined tender identification by building smart filters and improving data classification methods.
• Dashboard Development and Maintenance:
  Designed and maintained high-impact dashboards across departments—Execution, Finance, Accounts, Legal, HR, Purchase, and Store—analyzing 1000+ tenders annually. Provided real-time strategic insights to leadership, improving data transparency and decision-making.
• Project Monitoring Dashboards – Brahmaputra Infrastructure Ltd:
  Developed comprehensive project management dashboards covering :
• 1) Physical Progress vs. Planned Targets
• 2)Financial Progress (Actual vs. Planned)
• 3)Planned Cost vs. Actual Cost Analysis
  

Applied these KPIs across three different project types: Self-Executed Projects, B2B Collaborations, and Joint Ventures (JV). Enabled real-time tracking and comparative analysis to ensure budget adherence and execution efficiency.

• Business Intelligence for City Center Mall (Retail & Leasing Operations):
  Spearheaded data-driven analysis of mall performance, including sales, leasing, and rental collections. Delivered monthly dashboards, conducted food court audits, monitored brand performance (revenue share vs. fixed rent), and improved revenue realization by 15%.
• Lease Strategy Development:
  Evaluated tenant performance, market trends, and lease agreements to optimize renewals and new deals—contributing directly to profitability and space utilization strategy at City Center Mall.
• MIS Framework for Socristo Enterprises:
  Built a robust MIS framework covering segments like HeavyHire, Orange Formworks, and Quad Cabins. Automated reporting pipelines and introduced Google Meet-based daily review systems, reducing manual reporting effort by 40% and improving reporting turnaround by 30%.
• Performance Monitoring and Digital Transformation:
  Designed employee performance monitoring systems based on meeting attendance, task assignment, and follow-ups. Developed structured daily MIS reviews, enabling better accountability and workload tracking across all divisions of Socristo.
• Product Development & Business Analyst – Heavymatics (Telematics Division):
  Currently leading the development of a high-end telematics application for Heavymatics, focused on GPS tracking, fuel monitoring, and fleet utilization. Involved in product requirement gathering, user flow design, and cross-functional collaboration with tech teams to bridge business needs with technical execution.
• Cross-Company Strategic Analytics – HeavyHire & Orange Formworks:
  Conducted pricing analysis, asset utilization studies, and business forecasting to support equipment rental optimization. Created reporting templates and led training for junior analysts on tools like Power BI and Excel-based automation.

• Led a data integration project, improving overall data accessibility and reliability by consolidating datasets from multiple departments.
• Trained over 50 employees in data visualization and analytics tools, significantly enhancing the company's analytical capabilities.
• Developed automated dashboards and reports using Power BI, SQL, and Excel, improving the reporting process and data accuracy.

• Orchestrated the development of a data mining solution, leading to a 25% improvement in client targeting strategies by enhancing the client data collection process.
• Created detailed data models and predictive analyses that improved business outcomes.