Johnrey R.
Senior Data & Operations Analyst
Open to offersNew to PlatformAbout
Johnrey Y. is a seasoned Data & Operations Analyst with over 14 years of experience driving business impact across sales, marketing, finance, supply chain, and manufacturing domains. Based in Cordova, Cebu, Philippines, Johnrey has contributed to organizations such as Skinlycious and Lexmark Research and Development, specializing in the use of Power BI, Advanced Excel, and SQL to develop unified dashboards, automate reporting, and create data-driven insights for marketing campaigns and inventory planning. Johnrey managed CRM data, financial reporting, and business process improvements, including project management and Lean Six Sigma initiatives in manufacturing and e-commerce settings. His academic background includes a Master’s in Industrial Technology and a Bachelor’s in Industrial Engineering, providing a strong foundation for analytical and operational excellence.
Experience
Loyalty Perks Admin
Lexmark Research and Development · 2019 — 2024Validated reseller claims by confirming serial and part numbers, resolving conflicts, and ensuring data integrity. Executed weekly updates for internal databases (Orion) and files accessed by resellers (Sales on Demand). Managed and produced monthly reports for key accounts, including CDW, DMR, and Insight. Spearheaded the transition to a new Loyalty Perks platform and designed a Power BI dashboard for visualizing data.Operations Data Analyst / Planner
Skinlycious · 2021 — PresentCompiled sales data from various platforms to establish a cohesive and precise reporting source. Developed metrics and dashboards for marketing campaigns, focusing on ROAS, CAC, CLTV, and Retention Rate. Managed inventory levels for finished goods and triggered purchase orders based on production lead times. Oversaw CRM data and produced financial reports to assist with accounting and pricing strategies.Sales & Marketing Support
Lexmark Research and Development · 2015 — 2019Provided Salesforce reporting support to the North America Enterprise Sales team, managing deal desk quote processes and account management while assisting with Anaplan forecasting. Conducted training sessions for new Account Managers in the US to facilitate effective navigation of Salesforce. Sourced and qualified leads by obtaining accurate contact information and managing entries into Salesforce and Eloqua. Handled inbound calls for warranty renewals and identified sales opportunities for the EMEA region. Created monthly warranty mailing lists for small to medium business accounts and prepared quarterly opportunity reports for North American stakeholders.Business Planning & Financial Analyst
Author Solutions Inc. · 2013 — 2015Produced and disseminated daily sales reports across multiple company imprints. Reconciled monthly sales reports and calculated commissions. Analyzed and reported on monthly e-book sales from varied online sources, identifying key sales contributors through evaluation of lead quality and sales team performance.Material Planner
Taiyo Yuden Philippines Inc. · 2012 — 2013Created material plans aligned with production schedules to maintain a continuous supply chain. Monitored material shelf-life and stock levels to avoid expiration and depletion. Optimized inventory management by preventing overstocking and regularly reviewing material usage forecasts.Continuous Improvement / Process Engineer
Metro Wear Inc. · 2011 — 2012Led initiatives aimed at improving manufacturing efficiency, specifically through an embroidery efficiency project. Conducted Lean training for operators while performing root-cause analysis on production challenges. Balanced production lines and provided guidance to operators to achieve output targets.
Skills & Expertise
Education
- Masters in Industrial TechnologyCebu Technological University - Main Campus · — — 2024
- Bachelor of Science in Industrial EngineeringCebu Technological University - Main Campus · — — 2011