Loveprit Sidhu
Bi Consultant @Sbi - Data Ai Epm
Signup · Get unlimited contacts
WORK HISTORY
Bi Consultant @Sbi - Data Ai Epm
CA
05/2021-06/2022 - BI Analyst at IVANHOE CAMBRIDGE - Requirements gathering workshop as part of the Tenant Handbook reporting project - Analysis of tenant data (occupied area, rent.) sent by international partners and modeling of this data - Creation of views for Power BI reporting needs 02/2020-05/2021- Lead BI at BIRON As part of the overhaul of the BI platform- Monitor of the workload - Communication on BI best practices - Design and rebuild of around 700 SSIS workflows - Design of the datawarehouse using star schema model (dimension in SCD2 + facts)- Migration of the SSIS packages in SSIS catalog - Creation of CI/CD pipelines on Azure DevOps - Creation SQL Agent tasks to execute master packages on daily basis - Rewrite of slow SQL queries 10/2019-02/2020 - Senior BI Consultant at RTL - Project management and weekly meeting with the client - Team workload management and code review 06/2018-10/2019- BI Consultant at Caisse de Dépôt et Placement du Québec - Implementation of the production analytics area for the treasury (design, development of SSIS workflows, automation under SQL agent)- Development of the internal cash flow remuneration calculator for the treasury (design, development of SSIS loading flows, automation under Autosys, automated deployment on DevOps)- Optimization of the company datawarehouse - Creation of data flow for file extraction to the company data providers (benchmarking)- Maintenance and upgrade of existing applications Technical environment : SQL Server 2016, SSIS, SSAS, SSRS, Azure DevOps, Jira, Teams, Git, Visual Studio 20••••19
EDUCATION
Simone de Beauvoir High School – Garges-les-Gonesse – France
Baccalauréat - French High School Diploma, Sciences general line
Université Paris 13
Master's degree in computer science, Business Intelligence
University of Paris XIII – Technology Institute – France
2 years degree, Electronic Engineering and Industrial IT
Université Paris 13
Bachelor's degree, Computer Science
ABOUT LOVEPRIT SIDHU
Result-oriented professional with 10+ years experience in business intelligence who have worked for several sectors like finance, telecom, industry, public and energy. Highly adaptable, organized, self-motivated, able to deliver BI solution from data integration (ETL) and data modeling until the reporting phase. Occupied several roles such as data engineer, data analyst and tech lead for Canadian and French companies In this complex and challenged IT environment, i believe in \'Keep it simple and smart\' concept. Through many projects i delivered, i value simple understandable solution rather than complicated incomprehensible one which are somehow hard (and so costly) to maintain Over the years, i developed strong expertise in Microsoft BI solutions : • SSIS • SSAS • SSRS • Power BI • SQL Server Seeking to develop expertise on cloud technology such as Microsoft Azure
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.