Sanket Rawat

Key Responsibilities:

• Developed automation tools using Excel VBA to streamline internal business operations and reduce manual workload.
• Collaborated with cross-functional teams (Finance, HR, IT) to understand requirements and deliver custom solutions.
• Ensured secure, user-friendly tool development with built-in validations, access controls, and documentation.
• Maintained and enhanced existing tools based on user feedback and evolving business needs.

Key Projects:

▶ Employee Information Tool

• Designed and built a dynamic Excel-based VBA tool to manage employee data and reporting processes.
• Created a user-friendly dashboard with interactive buttons for retrieving employee details using unique IDs.
• Automated import file creation for systems like Maconomy, reducing manual errors and effort.
• Implemented user access rights management through automated access file generation.
• Impact: Boosted efficiency and accuracy in employee data handling.

▶ Compensation Sheet Automation (Rydoo Integration)

• Developed a VBA-powered Excel tool to automate compensation and expense file generation for Denmark employees.
• Integrated dropdowns, guided data entry, PDF output, and password-protected access.
• Linked the tool with Rydoo’s platform for seamless data exchange.
• Impact: Cut manual effort by ~80%, improved claim accuracy, and streamlined the expense process.

Key Responsibilities:

• Provided daily support for financial and operational systems, primarily Maconomy, via ServiceNow ticketing.
• Owned critical processes like month-end revenue recognition and biannual user access audits for financial systems.
• Conducted UAT and regression testing for multiple enterprise applications, ensuring stable deployments and upgrades.
• Designed automation tools and dashboards to improve process efficiency and support decision-making.

Key Projects & Contributions:

▶ Power BI Dashboard – ServiceNow Ticket Analytics

• Designed and developed an interactive dashboard to track and analyze ServiceNow ticket data for the support team.
• Enabled leadership to identify workload bottlenecks and optimize resource allocation through visual insights.
• Impact: Improved visibility into team performance and reduced issue resolution time.

▶ User Access Rights Audit Dashboard (Maconomy)

• Built a Power BI dashboard to monitor user access across the Maconomy system, supporting semi-annual access reviews.
• Utilized SQL for data extraction, Power Query for transformation, and DAX to build dynamic KPIs and role-based metrics.
• Impact: Strengthened security oversight and audit readiness with real-time access reporting.

▶ VBA Tools for Process Automation

• Developed Excel-based automation tools using VBA to simplify recurring data tasks and reporting routines.
• Improved operational efficiency and reduced manual effort across multiple support and finance processes.

Key Responsibilities

• Managed employee benefits files and maintained group benefits databases, ensuring accurate payroll and eligibility records.
• Updated and maintained SOPs, plan design documents, claims rules, reports, and issue logs.
• Delivered 100% SLA compliance across all client deliverables; supported APAC-level event organization.
• Generated and analyzed internal/external reports; validated system setups per client specifications.
• Identified process inefficiencies and led improvements to optimize workflows.
• Served as a process trainer, mentoring new hires and delivering domain-specific and tool-based training.

Key Projects & Automation Initiatives:

• Claims Report Automation: Developed macros to streamline claim data by TAT and category.
• HRIS File Automation: Automated employee data processing by comparing current vs. previous datasets.
• Processing Calendar Macro: Created automated calendar ensuring timely file delivery (TAT-compliant).