Abhisar Shukla

• Design, create, and maintain Workday reports and dashboards tailored to business needs.
• Develop interactive and visually appealing reports using Power BI or similar BI tools, leveraging features such as calculations, filters, drill-downs, and charts.
• Manage and optimize SQL queries for database analysis, ETL processes, and efficient data management.
• Use SQL Server Management Studio (SSMS) to analyze, troubleshoot, and maintain databases effectively.
• Collaborate with stakeholders to document data models, reporting requirements, and report designs.
• Deliver clear and concise insights to technical and finance teams to support strategic business decisions.
• Stay updated on industry best practices and emerging BI tools to continuously improve reporting processes.

Created and maintained dynamic dashboards and reports in Power BI and Tableau to visualize complex datasets, ensuring actionable insights for decision-making.
Conducted in-depth data analysis using SQL, including writing and optimizing queries for data extraction, transformation, and analysis.

• Development:Designed interactive and user-friendly dashboards leveraging advanced features like DAX calculations, data modeling, drill-throughs, and cross-filtering in Power BI.
  Developed customized Tableau reports, utilizing features like parameters, calculated fields, and data blending for enhanced visualization.
  
• Performed Extract, Transform, Load (ETL) processes to clean and organize raw data, ensuring compatibility with BI tools.
  Integrated data from multiple sources such as databases, APIs, and flat files for seamless reporting and analytics.
  
• Proficient in database design and management, creating and maintaining relational databases using SQL Server, MySQL, or PostgreSQL.
  Optimized SQL queries for performance improvement and ensured efficient database operations.
  
• Partnered with cross-functional teams, including business stakeholders and IT, to gather and translate requirements into meaningful BI solutions.
  Delivered data-driven insights and presented findings using storytelling techniques to non-technical audiences.
  

• Streamline onboarding by managing new hire processes, including approvals, and banking information updates. Update tax forms and employee information, such as W-4s, dependents, and unemployment details, with precision.
• Handle termination procedures and ensure accurate ADP Enterprise batch processing. Ensure prompt and accurate payroll transmission on scheduled paydays. Oversee and update 401(k) documentation and earnings eligibility.
• Implement payroll adjustments, and establish new pay cycles efficiently. Coordinate year-end payroll activities in compliance with U.S. financial schedules.
• Partner with the People and Culture team to conduct thorough annual hour audits.
• Manage and validate compensation changes within payroll systems. Monitor attendance records by correcting discrepancies in unpaired punch reports.
• Maintain accurate employee records by updating the Status of Transfer Form for personnel changes.
• Issue manual checks for employees not included in regular payroll cycles. Produce reconciliation and journal sheets to uphold financial integrity.
• Accurately update manager timecards, ensuring precise timekeeping.

• Processing the monthly India payroll and auditing the additional inputs: Captive allowance, Deputation allowance, Foundation bonus, Special incentive, Value-creation (Ideapreneurship Reward), L2/L3 incentive, Weekend/Holiday Allowance, shift allowance, etc., which can be letter-based, policy-based, or approval-based, after receiving them from the respective HREP/HRBP and LR team by fetching various essential reports from SAP HCM, and I remunerate.
• Auditing BSERV Inputs (Deficit, Holiday-Festive allowance, Extra day payout, Incentive BSERV, Night shift allowance, Overtime BSERV, Weekend allowance BSERV).
• Follow up with the respective RM, HR, PMO, and other stakeholders for necessary inputs, and ensure to resolve it within the given timelines.
• Go through the Compensation Letters and Offer Letters for additional inputs to check the validity, effective dates, and various clauses.
• Responsible for picking duplicate payments, restricted payments, and preparing and maintaining the Master Tracker for recurring payments.
• Review, update, and maintain documentation related to additional payments and guidelines for process improvement.
• I took part in the implementation process and the transitioning process for the new application and payrolls.
• Identify, investigate, analyze, and resolve the issues identified within the process.
• To prepare the workflow, process documents, and BRD for automations.
• Performing UAT testing for the new portal, incorporated with the technical team.