Santosh Sharma

Projects:

Managed and enhanced diverse Incentives Dashboards concurrently.

Working on the Attrition Dashboard.

Working on L&D Dashboard.

Created a comprehensive Attendance Analysis Dashboard.

Developed a Recruitment Dashboard

Developed Employees' Demographic Details Dashboard.

Developed organizational structure.

Implemented REST APIs to automatically store employees' documents on a shared drive.

• Developed dashboards in Power BI using DAX functions.
• Developed real-time insights into product and business KPIs by building data and reporting infrastructure using Power BI, DWH, SQL, Python, APIs, Share Point, and Excel.
• Performed data analytics and generated insights in alignment with business requirements.
• Collaborated with diverse users and stakeholders to comprehend their specific data visualization needs and requirements.
• Collected and analyzed data to create a comprehensive Incentive Dashboard.
• Gathered requirements and transformed them into a solution design.
• Analyzed and optimized data, leading to a 20% boost in efficiency and productivity.

• Developed dashboards in Power BI.
• Built out the data and reporting infrastructure from the ground up using Power BI and SQL to provide real-time insights.
• Developed & automated reports using Python, Pandas (Data frame) and file handling
• Managed SQL Database of HRIS System and Biometric.
• Designed and developed the mail template, letter template using HTML, and synchronized with SQL Database for auto-scheduler mails.
• Designed and developed the new reports and extract in Excel using SSIS, SQL Script for auto schedulers via SFTP, FTP, S3 bucket, and task scheduler.
• Robust skills in HR Transformation, HRMS Tool Administration, SQL development, SQL DB Mailers, Report Automation, SSIS, extraction, transformation, SQL Server Integration.
• Trigger auto emailers as per the business requirement.

Project: HRMS Implementation (Cloud HRMS Testing and Implementation using Agile Methodology)

• Experience in developing, extracting, and transforming data using SSIS, Import Export Wizard
• Implement process improvement and HR policy changes design to improve efficiency and user experience with HRIS system
• Weekly reports Attrition reports, Absenteeism & physical presence reports, Weekly Business Review Reports Etc
• Attendance & leave Management, Roster Management, Employee master data management on Kronos
• Was ensuring Accuracy by regular validation and Maintenance for Correctness in HRMS database
• Analyzed and Troubleshoot issues related to databases
• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports.

• Created Adhoc reports and prepared payroll input as per attendance records
• Was maintain all statutory compliance-related reports like PF, ESI, Wages Sheet, Attendance Sheet, etc
• Including maintaining a register for all labor laws such as accident register, deduction register, damage register, advance register, fine register, Muster Roll, Leave Register etc
• Was taking care of all administrators work like purchasing stationary, sanitation, ID card.

• Looked after the operational activities in warehouse
• Conducted Monthly & yearly stock Audit and tracked fast moving items stock on daily basis
• Coordinated with entire supply chain team & sales person
• Data Analyzing, Reconciliation, proper documentation
• Worked on Microsoft Dynamic Navision 2009 for order processing.