Encouraging Assistant manager and analytical problem-solver with talents for team building, leading and motivating, as well as excellent customer relations aptitude and relationship-building skills. Proficient in using independent decision-making skills and sound judgment to positively impact company success. Dedicated to applying training, monitoring and morale-building abilities to enhance employee engagement and boost performance.
Projects Completed Details :
Project #1
Team Performance Dashboard
Domain : Research
Project Description:
Created an end-to-end Power BI dashboard to show team performance and quality trend for all the teams in the process. This helped the SLT to understand individual and team performance and gave business insights for better decision making.
Technologies used:
Power BI Desktop, Excel & SQL Server.
Project Role : Data Analyst
Key Deliverables
Data Transformation – Clean and create structured data and save it in SQL Server Database.
Process Automation – VBA used to skip the manual process of cleaning the data & storing the data into database.
Visualization – Used Power BI & Schedule refresh option used to update data on daily basis. Development of calculated Measures and Dimensions to support the report requirement using DAX.
Project #2
Employee Attendance dashboard and Status
Domain : Research
Project Descriptions :
Developed an end-to-end employee database in SQL and created a dashboard in Excel which showed the employee attendance and leaves on daily basis. Also showed the total number of employees present in each team, location wise data and attrition report.
Technologies used:
MS Excel, SQL, PowerPoint
Project Role : Data Analytics
Key Deliverables
Data Transformation –clean and create structured data and save it in SQL Database.
Process Automation – VBA Code Development to exclude manual task to clean and convert data into date wise excel file.
Visualization – MS Excel used to create dashboard to show the employee attendance details and employee status for all the teams. VBA code used to automate the process to refresh the dashboard and upload data into the excel used for creating dashboard.
Advanced Excel
undefined