Rahul Aggarwal

• Developed and maintained Power BI dashboards for executive leadership to track key performance indicators (KPI) and operational metrics.
• Manage and prioritize the product backlog.
• Articulating the product vision and user stories in a way that is clearly understandable to DevOps teams, to take ownership, define the work, and prioritize the user requirements with the product features to be implemented.
• Partnered with cross-functional teams, capturing business requirements and implementing scalable BI solutions
• Facilitates Agile ceremonies and assists teams with Estimation, utilizing various techniques.
• Facilitates Program Increment Planning in collaboration with team to strategize for the upcoming quarter
• Enhanced team knowledge by providing education on Power BI features and best practices, enforcing adherence to Agile processes through thorough understanding of SAFe.

• Assists multinational companies with employee benefits and saving programs.
• Conducted external bench marking and trend analysis
• Mapped statutory requirements of the country with clients to conduct gap analysis
• Provided support to clients in benchmarking, governance structure, benefits review and optimization, as well as claims analytics.
• Reviewed company's wellness program for identifying improvement opportunities
• Identified vendors in field of EAP, Wellness program etc. for collaboration.

• Effectively managed Project Team by assigning tasks to Associates and keeping all involved parties updated in order to enhance business flow.
• Led the coordination of discussions, decision making, and conflict resolution within 3 cross functional teams
• Maintained comprehensive documentation of Scrum activities to ensure accurate tracking and reporting
• Collaborated with clients to create effective marketing plans for increased market dominance.
• Established connections with management teams in various consumer LOS areas.
• Developed analytical capabilities using Power BI to forecast, monitor, and review program performance from sales, profit, and CLV perspectives.
• Utilized visual elements like workflow diagrams and Gantt charts to enhance understanding of process flow and timelines in a clear manner.
• Designed and implemented analytical tools using Power BI for reports (e.g., resource management, pricing mix, competitor analysis, Trade Spend strategy etc.)
• Utilized in-depth analysis to identify and address business challenges.

• Assumed role of Project Economist, analyzing the economics of projects for the Capital Projects and Energy sub-SBU under Advisory LOS.
• Delivered actionable insights to senior project management for improving financial status of projects by analyzing current financial results, monitoring variances, and identifying trends using Power BI.
• Gathers relevant operational data for cost analysis
• Ensured accurate evaluation of current financial status by analyzing actual vs planned & forecasted revenue
• Maintained communication and collaboration amongst team members to track progress and meet project objectives.
• Oversaw financial operations including budgeting, reporting, planning, and auditing
• Assisted in the planning of project resources by monitoring availability, allocating current headcount to the project, and collecting revenue.

Key Achievements:

Collaborated with diverse clientele from both private and public sectors on multiple projects showcasing expertise in areas like MIS, Business Operations, and Project Analytics.

• MIS reporting by using Excel & VBA (Macro) at Operational & Client Level
• Timely and accurate reports were consistently generated for analysis.
• Handled individual responsibility for MIS across Indian and American teams.
• Implemented the roll-out of multiple reports such as the Consolidated Revenue Report and Lead Generation.
• Managed and analyzed monthly, weekly, and daily reports using Excel and Access to generate actionable insights.
• Demonstrated thorough understanding and utilization of Salesforce as a CRM system.

• Utilized quantitative analysis to identify and explain discrepancies.
• Collected and analyzed data from multiple departments for business planning purposes, utilizing Excel pivots, V-lookups, charts, and macros.
• Performed quantitative analysis to support management decision making by providing high-quality and insightful trend reports.
• Suggested corrective measures and new means to enhance system.
• Managed various ad-hoc analysis requests from senior management.
• Provided MIS support for new initiatives

Key Achievement:

Developed VBA Excel tool for Australian client to track request status and measure TAT positions.