YAN FIKH

Lead the development and implementation of business intelligence strategies, including Azure-based cloud data warehouses and Power BI solutions, to support Sales, Marketing, Call Center, Field, and Back Office operations. Manage a diverse team to deliver actionable insights through advanced data analytics, ensuring alignment with business objectives and enhancing data-driven decision-making.

• Optimized data quality and accuracy by establishing rigorous data management protocols and governance practices.
• Partnered with IT to ensure seamless integration of business intelligence systems with existing enterprise applications for streamlined workflows.
• Established performance benchmarks, using historical data analysis to inform future strategies and initiatives.
• Led business intelligence projects from inception through completion, ensuring successful delivery within scope, budget, and timeline constraints.
• Introduced automation in report generation processes, reducing turnaround time and increasing team productivity.
• Developed customized dashboards and visualizations for senior leadership, enabling timely identification of trends and opportunities.
• Championed a culture of analytics-driven insights, empowering employees to make informed decisions based on real-time data.

Oversee the strategic design and delivery of data and business intelligence architecture and solutions, aligning with BentallGreenOak's enterprise data enablement program, and supporting the Sun Life Investment Management group of companies.

• Developed strategies, roadmaps, and business cases to support the data enablement program and maximize data utilization.
• Evaluated AWS and Azure for data consolidation from three ERP systems, using Power BI or Tableau as the BI tool, and piloted Snowflake for a cloud data warehouse solution.
• Established a framework for data extraction, cleansing, and loading to centralize data from various source systems (JDE, Yardi, MRI, etc.).
• Led the implementation of Qlik Sense to enhance data visualization and user experience, ensuring meaningful and accessible business analytics reports and dashboards.
• Engaged vendors to pilot machine learning and AI capabilities to boost operational excellence and intelligence.
• Fostered relationships with critical verticals, business groups, Finance, Operations, and IT, resulting in improved data quality, reliability, and streamlined processes.

Developed and maintained reporting frameworks, tools, and data marts while working cross-functionally with various business owners to determine and meet their reporting and analytics needs. Managed teams to deliver timely, high-quality reporting and analytics.

• Developed and maintained reporting frameworks and tools.
• Led three teams responsible for development, reporting, and analytics.
• Planned and implemented BI strategy using Microsoft Azure.
• Enhanced analytical capabilities with Tableau and Power BI.
• Provided real-time business reporting for management decisions.
• Implemented SQL Server for data warehousing and defined key metrics.

• Delivered value-added analysis and reporting to provide insights to the senior leadership team in Marketing, Product Development, Loyalty & Retention, and Finance.
• Introduced the new KPI "Monthly Recurring Charges" to better understand client behavior.
• Analyzed and interpreted data from various data warehouses to understand client usage patterns, handset profitability, ARPU trends, current base migration behavior, and the impact of competitive offers.
• Built predictive models using SAS and SQL to optimize inventory demands for key offerings.