SURAJ THAKUR
Business Analyst
Mumbai
Summary
I bring over 10 years of professional experience, including 5 years as a Business Analyst and Project Lead specializing in data-driven decision-making. I have a strong track record of converting complex, raw datasets into clear, actionable insights that support organizational growth and strategic planning. My technical expertise spans Tableau, Power BI (DAX), VBA, Looker Studio, and Advanced Excel, through which I create and optimize interactive dashboards, automate reporting systems, and deliver high-impact analytical solutions to stakeholders across all levels.
Overview
13
13
years of professional experience
3
3
Certifications
3
3
Languages
Work History
Project Lead
The DeRisQ Group
10.2023 - 01.2025
- Developed project plans, timelines, and resource allocation strategies.
- Designed and developed interactive dashboards and analytics reports using Power BI and Looker Studio, enabling data-driven decision-making across departments.
- Performed comprehensive data cleaning, transformation, and modeling using Power Query, DAX, and other ETL techniques to ensure high data accuracy and reliability.
- Collaborated with cross-functional teams to gather requirements, define KPIs, and build intuitive visualizations tailored to business objectives.
- Managed project timelines, stakeholder communication, and delivery cycles as part of the Project Lead responsibilities, ensuring the successful deployment of analytics solutions.
- Automated recurring reporting processes, reducing manual effort, and increasing operational efficiency.
- Conducted root-cause analysis, performance tracking, and data validation to support strategic planning and process improvements.
- Provided training and support to teams on dashboard usage, data interpretation, and best practices in BI reporting.
- Presented analytical findings to management with clear storytelling, insights, and actionable recommendations.
Associate MIS Report & Data
Infiniti Retail Ltd ( Croma )
08.2018 - 10.2023
- Developed and maintained automated MIS reports using VBA in Excel, reducing manual report preparation time by creating macros, user forms, and scheduled routines.
- Built robust data-cleaning and ETL routines in VBA to standardize transactional and operational data from multiple sources before analysis.
- Designed dynamic dashboards and interactive reports in Power BI to visualize KPIs, trends, and exceptions for senior management, and operations teams.
- Implemented row-level filtering, bookmarks, and drill-through functionality in Power BI to enable ad-hoc analysis and faster decision-making.
- Wrote optimized SQL queries (joins, window functions, aggregations) to extract and prepare datasets from relational databases for reporting and dashboarding.
- Automated data refresh pipelines by scheduling SQL stored procedures and integrating them with Power BI dataflows to ensure near-real-time reporting.
- Created parameterized reports and templates in Excel/Power BI for monthly, weekly, and daily MIS cycles to ensure consistency and reduce errors.
- Collaborated with stakeholders to translate business requirements into technical specifications, and produced clear documentation for report logic and data sources.
- Improved report performance by optimizing VBA macros, indexing database tables, and minimizing dataset sizes in Power BI through incremental refresh, and query folding.
- Supported ad-hoc analysis requests—combining SQL extracts, Excel modeling, and Power BI visualizations—to deliver actionable insights under tight deadlines.
Team Leader Field Service Coordinator
Hathway Cable & Datacom Pvt Ltd
04.2012 - 08.2018
- Led cross-functional teams to enhance project delivery and service quality.
- Streamlined operational processes, resulting in improved efficiency and reduced turnaround times.
- Mentored junior team members, fostering skill development and collaboration.
- Implemented performance metrics to track team productivity and service excellence.
- Facilitated training sessions to enhance team capabilities in customer service and technical support.
- Drove initiatives to enhance customer experience through effective service delivery strategies.
- Set performance expectations for the team, monitoring progress towards goals and providing constructive feedback as needed.
- Coordinated with stakeholders to align project goals with corporate strategy.
- Mentored junior staff members, helping them develop their leadership potential and advance in their careers.
- Increased customer satisfaction ratings by closely monitoring service quality standards and addressing any issues promptly.
- Established clear communication channels to facilitate timely exchange of information between team members and stakeholders.
- Send quotations for the negotiation part with the vendors (suppliers).
- Outsource material updates from the suppliers.
Education
Bachelor of Commerce - Commerce
Kalinga University Distance Education
Online / Distance 04.2001 -
Higher Secondary Certificate - HSC
Anant Janardan Mhatre Commerce
Mumbai, India 04.2001 -
Skills
Power BI
Certification
Power BI
Timeline
Project Lead
The DeRisQ Group
10.2023 - 01.2025
SQL
06-2023
Tableau
05-2023
Power BI
01-2021
Associate MIS Report & Data
Infiniti Retail Ltd ( Croma )
08.2018 - 10.2023
Team Leader Field Service Coordinator
Hathway Cable & Datacom Pvt Ltd
04.2012 - 08.2018
Bachelor of Commerce - Commerce
Kalinga University Distance Education
04.2001 -
Higher Secondary Certificate - HSC
Anant Janardan Mhatre Commerce
04.2001 -