Operations & Data Analyst, Workforce Planning

JUAN MARTIN PURIFICACION

Pasig City, Philippines +63-917-***-**** ****************@*****.*** linkedin.com/in/juanpurificacion Operations & Data Analyst Workforce Planning KPI Reporting Cost Optimization PROFESSIONAL SUMMARY

Operations and Data Analyst with 12 years of experience across BPO workforce management, technology project delivery, and multi-brand business operations. Builds forecasting models, KPI dashboards, and cost analyses that leaders use to make staffing, pricing, and purchasing decisions. Track record includes cutting overtime 18% for a 300+ agent operation, lifting gross margin from 28% to 37%, and growing a 5-brand food and beverage company to 80M+ in revenue. Pairs analytical rigor with hands-on P&L ownership and leadership of 30+ staff. KEY ACHIEVEMENTS

• Lifted gross margin from 28% to 37% across 5 food and beverage brands through cost-trend analysis, menu repricing, and purchasing controls.

• Grew LGNDRY Concepts to 5 brands and 80M+ in overall revenue, using daily margin dashboards to steer pricing and staffing.

• Reduced overtime hours by 18% and raised service level from 74% to 82% for a 300+ agent BPO operation.

• Saved about 60,000 per month by identifying 6 cost-saving opportunities in a consumer electronics trading business. CORE COMPETENCIES

Data Analysis Data Visualization KPI Reporting & Dashboards Forecasting & Capacity Planning Workforce Management (WFM) Scheduling & Real-Time Adherence Root Cause Analysis Variance Analysis P&L Management Cost Reduction Process Improvement Inventory Management Project Management Stakeholder Management Team Leadership

TECHNICAL SKILLS

• Microsoft Excel (Advanced): PivotTables, Power Query, XLOOKUP, INDEX-MATCH, SUMIFS, nested IF formulas, dashboards

• Data Visualization & Querying (Basic): Power BI, Tableau, SQL

• Other Tools: Google Sheets, workforce scheduling systems, CRM systems PROFESSIONAL EXPERIENCE

Owner and Chief Executive Officer May 2020 – Present LGNDRY Concepts Inc. Metro Manila, Philippines

Multi-brand food and beverage company operating 5 brands, including Sushi Fix.

• Own P&L and operations for 5 brands and 30+ staff, covering pricing, purchasing, staffing, and customer service.

• Raised gross margin from 28% to 37% by repricing 40+ menu items and renegotiating supplier terms based on sales and cost trends.

• Cut labor cost by 12% by matching staff schedules to hourly sales patterns, with no drop in service.

• Built Excel dashboards tracking daily revenue, food cost, labor cost, and margin by brand, reducing reporting time from 3 days to 4 hours.

• Standardized weekly KPI reports across brands, giving management a single view of performance and problem areas. Project Manager Oct 2018 – Jan 2020

Decenternet Technologies Corporation Manila, Philippines

• Promoted from Junior Project Manager to Project Manager within 8 months (June 2019).

• Managed 5–8 concurrent technology projects for US-based clients, coordinating timelines, resources, and delivery.

• Kept 90% of milestones on schedule using Excel trackers that flagged delays, resource gaps, and risks early.

• Delivered weekly status reports and recommendations to US stakeholders and drove resolution of delivery bottlenecks.

Owner and Operations Manager Oct 2016 – Jun 2018

Eight Effects Enterprise Quezon City, Philippines Multi-product trading business supplying consumer electronics and gadgets.

• Managed daily operations, budget, and a team of 10–15 staff.

• Saved about 60,000 per month by identifying 6 cost-saving opportunities through operating-cost analysis.

• Cut slow-moving inventory by 25% by tracking stock and sales by product line, freeing cash for faster-selling items.

• Analyzed supplier pricing and margins across 100+ SKUs to guide purchasing and set selling prices.

• Built Excel tools and weekly sales reports for expense monitoring, scheduling, and category performance. Real-Time Analyst (RTA) Team Lead Apr 2014 – Oct 2016 WNS Global Solutions Quezon City, Philippines

• Led real-time monitoring and workforce planning for a 300+ agent BPO operation, supervising 7 analysts.

• Reached 95% weekly forecast accuracy with Excel models for call volume and staffing requirements.

• Raised service level from 74% to 82% by analyzing AHT, utilization, and shrinkage to find performance gaps.

• Reduced overtime hours by 18% by flagging staffing inefficiencies and redeploying agents in real time.

• Delivered daily and weekly dashboards with recommendations adopted by operations leaders. Earlier Experience

• Customer Service Representative West Contact Services

• Administrative Technical Officer Department of Justice

• Executive Assistant Office of the Speaker, House of Representatives EDUCATION

Bachelor of Arts in Political Science 2010

Centro Escolar University Manila

Law Coursework 2012 – 2014

Arellano Law School Pasay

Contact this candidate