John Biju Varghese

• Built interactive dashboards in IBM Cognos and Power BI, improving KPI visibility.
• Optimized SQL queries, reducing reporting errors by 15%.
• Created detailed workflow documentation to support analytics processes and decision-making.

• Designed and deployed automated HubSpot workflows, improving data integrity and reducing manual reporting efforts by 30%.
• Engineered real-time SaaS analytics pipelines in BigQuery processing 500K+ records daily, consolidating 20+ KPIs (MRR, churn rate,
CAC) into executive dashboards that reduced reporting time from 4 hours to 15 minutes.
• Developed Python scripts to normalize and clean datasets, improving data consistency by 25%.
• Automated recurring reporting processes, saving 15+ hours/month for stakeholders.

• Built SQL-based ETL pipelines in BigQuery for 10+ datasets, improving reporting efficiency by 20%.
• Developed semantic models and Looker dashboards, reducing report generation time by 40%.
• Led an enterprise-wide API migration of 50K+ records, reducing inconsistencies by 25% and saving 20+ hours/week.
• Delivered end-user training and documentation to improve dashboard adoption.