As a PMO Intern, you will support the PMO team in managing workforce operations, including attendance, leave, timesheets, and incentive data. You will help ensure accurate, timely reporting and work closely with the HR team while gaining hands-on experience coordinating these processes across the organization.
1. Attendance Data and Reporting
- Run pre-built Python scripts to process biometric attendance data and generate regular reports for all three sites.
- Use basic SQL queries to pull, verify, and cross-check attendance records.
- Audit attendance data for gaps, mismatches, and anomalies across time zones, and flag issues for review.
- Calculate and maintain employee leave balances and loss-of-pay (LOP) data.
- Prepare accurate summaries for HR to support payroll.
- Keep trackers updated and reconcile discrepancies.
- Compile incentive data using employee performance and productivity metrics.
- Validate inputs, check calculations, and maintain clear records for review.
- Set up timesheets for new projects, teams, and employees, keeping them aligned with project and allocation details.
- Track timesheet submissions, follow up on missing or late entries, and ensure data is complete before deadlines.
- Review timesheet entries for errors or inconsistencies and flag them for correction.
- Build and maintain reports and trackers in Excel and Google Sheets.
- Prepare summaries, simple presentations, and process documents using PowerPoint and Word.
- Coordinate with teams across regions to resolve data queries and meet reporting deadlines.
- Education: Graduate or fresher from any discipline.
- Skills: Strong proficiency in Excel and Google Sheets, including formulas, XLOOKUP, pivot tables, and data cleaning. Comfortable running pre-written scripts. Working knowledge of PowerPoint and Word.
- Communication: Fluent in spoken and written English, with the ability to coordinate across teams and time zones.
- Attributes: Exceptional attention to detail, comfort with accuracy-critical and recurring work, a high standard for data confidentiality, and a proactive approach to problem-solving.
Skills Required
- Graduate or fresher from any discipline
- Strong proficiency in Excel and Google Sheets, including formulas, XLOOKUP, pivot tables, and data cleaning
- Comfortable running pre-written Python scripts
- Working knowledge of PowerPoint and Word
- Fluent spoken and written English
- Ability to coordinate across teams and time zones
- Exceptional attention to detail and comfort with accuracy-critical recurring work
- High standard for data confidentiality
- Proactive problem-solving approach
What We Do
Kavi Global is a data analytics and AI company that helps enterprises make intelligent, data-driven decisions. It provides analytics software, solutions, and services spanning strategy, design, development, implementation, and support. Its capabilities include business intelligence, data warehousing, big data, advanced analytics, machine learning, data management, and AI, serving organizations across multiple industries and supporting digital transformation initiatives.







