Ian Rey San Pedro

Workforce Reports Specialist

• Job Details:Lead the development and maintenance of workforce-related reports for 40+ sub-lines of business within a growing healthcare account. Use VBA macros, Excel, and advanced automation techniques to generate and maintain key performance reports, such as shrinkage, attrition, billing, and productivity metrics. Provide real-time monitoring reports and insights for operations and scheduling teams, improving decision-making and adherence to targets. Conduct weekly business reviews with internal teams (MIS, operations) and external clients, delivering insights on performance metrics. Automate intraday reporting via IEX extraction and ensure report accuracy. Conduct Excel training sessions for teams, enhancing their reporting and analytical skills.

Reports Analyst

• Job Details:Created KPI dashboards, incentive reports, and invoicing reports on a daily, weekly, and monthly basis for operations. Collaborated with supervisors, operations managers, and business analytics teams to ensure the accuracy of reports and forecasts. Delivered presentations on business performance metrics to business analysts and senior leadership. Developed strong knowledge of SAP BO, BI, and agent suite tools for data extraction and reporting.

Business Analyst

• Job Details:Created and extracted reports from Tableau, Honeybadger, and Medallia for employee performance and incentive management. Developed an online dashboard to track employee performance in real-time, accessible via mobile devices (iPads/tablets). Used advanced Excel and Google Sheets functions (macros, PowerPivot, Power Query) to manage large data sets and deliver accurate reports.