• Managed the BI group and associated cross-departmental collaborators in the design, development, and implementation of near-real-time data systems for a large brokerage firm. The solution provided the entire data cycle automation being able to aggregate different data sources, perform the ETL process and generate advanced analytics and visualizations.• Designed and implemented a new data platform for big investment company to allow the automation of the entire reporting process and meet… Show more • Managed the BI group and associated cross-departmental collaborators in the design, development, and implementation of near-real-time data systems for a large brokerage firm. The solution provided the entire data cycle automation being able to aggregate different data sources, perform the ETL process and generate advanced analytics and visualizations.• Designed and implemented a new data platform for big investment company to allow the automation of the entire reporting process and meet the needs of various stakeholders. • Identify major tradeoffs in the selection of the appropriate BI toll to be used for visualizations.• Designed, developed, and implemented a budgeting and variance analysis application that provided the forecasting for utility costs for a large city in Ontario. The application generated the entire utilities budget (water , electricity and gas consumption) for more than 300 facilities (parks, buildings, pools. Etc.) that the city has under administration. The application was able to perform 1 to 3 years forecasting under different scenarios and assumptions and also provide the trends and analysis. • Developed a predictive model to forecast major disruptions caused by potential equipment failures for a large telecom company. The solution creates and displays in real time an acceptable corridor, monitoring the active and standby FibeTV boxes. The statistics which define the upper and the lower limit of the corridor were determined using historical data from a predefined period. Visualization completed using MicroStrategy Show less