Vaibhav Dhiman

• Handled client coordination to understand business needs, and ensure smooth communication.
• Involved in client requirement development, translating needs into actionable reporting formats.
• Prepared and maintained weekly and monthly reports for performance and operations tracking.
• Managed warehouse stock updates, and created daily stock summary reports.
• Supported and contributed to the development of new reports and system improvements.
• Conducted CRM testing to ensure accurate data flow and system functionality.
• Worked extensively on CRM systems, including Sales Force Automation (SFA) and Distributor Management System (DMS).
• Responsible for daily email data updates and validation to ensure accurate reporting.

advanced Excel and Power BI for creating dynamic dashboards, data models, and reports that support data-driven decision-making. Proficient in CRM systems, including SFA (Sales Force Automation) and DMS (Distributor Management System), for managing customer and distributor data, ensuring smooth sales and distribution operations.

Key Responsibilities and Skills:

• Expertise in advanced Excel functions, including Pivot Tables, XLOOKUP, VLOOKUP, HLOOKUP, Index-Match, Conditional Formatting, Data Validation, and basic Macros for automating tasks.
• Skilled in designing and publishing Power BI reports and dashboards, with drill-downs and real-time insights.
• Hands-on experience in CRM testing, identifying bugs, and supporting end-user functionality enhancements.
• Strong coordination with clients and internal teams to gather requirements, resolve data/report issues, and ensure timely delivery.
• Leading and supporting teams in day-to-day tasks, ensuring task delegation, follow-ups, and collaboration.
• Preparing and analyzing weekly and monthly MIS reports, performance tracking, and trend analysis to assist senior management in business decisions.
• Preparing professional presentations using Microsoft PowerPoint for internal reviews and client meetings.
• Contributed to the development of client-specific requirements, including data mapping, and reporting structures.

• Team Support & Report Work

• Preparing daily, weekly, and monthly reports.
• Automating reports using Excel functions (VLOOKUP, HLOOKUP, Pivot Tables).