Chamandeep Bedi

• A highly analytical, forward-thinking, and resourceful BI Manager with 10 years of solid experience successfully delivering cross functional agile BI projects worth $10M+.
• People leader adept @ building strong culture, performing activities that led to 80%+ engagement score on the team.
• 6+ years of experience leading and delivering data visualization projects using tools such as SQL, Tableau and Power BI. 
• An authentic communicator leading lunch and learn sessions to socialize insights through tools and dashboards.
• Skilled at managing multiple stakeholders both internal and external and effectively collaborates and unites cross functional teams to work together to achieve desired outcomes. 
• Adept at facilitating compelling presentations, technical documentation that conveys clear and relevant requirements and drive the decision-making process. 

Areas of Expertise: 

• Leadership & Support
• Stakeholder Management
• Coaching & Mentoring
• Project Management
• Business Casing
• Change Management
• Data Analytics & Reporting
• Strategy Projects
• JIRA
• Agile methodologies
• SQL, SAS
• Tableau, Power BI, Domo

SELECTED HIGHLIGHTS

Leadership: Supported the team as a thought leader for innumerous analyses that resolved call center operation bottleneck through digital self-serve initiatives that improved SLA by 10% and saved $1M in call center costs. (Bell)
Project Management: Led the change management and training for data analysts across departments for the brand-new Revenue data warehouse ensuring minimal business interruptions and building confidence in the new BI product. (StarTech)
Strategy: Defined scope of the regression testing for Synapse migration, created test strategy, test cases, entry and exit criteria, RAID analysis and other project dossiers for a successful data migration. (The Co-operators)

WORK EXPERIENCE

StarTech                                                                                                                                         2022 Aug – 2023 Jan

BI Manager

Overseeing business intelligence and data integration initiatives across the organization. The primary objectives were to lead a team to design, deliver and support business intelligence solutions that are aligned to the business strategy and goals of the organization; maintain and improve data quality; and implement a culture of data governance.

• Created project plan and user stories with well-defined milestones, accurate translation of data requirements into technical specifications and data management SOPs to get client signoffs for Revenue data warehouse development.
• Providing BI support for the CRM migration from Sage to Dynamics 365 through recalibration of PowerBI reports and dashboards, updating the finance and inventory models with the changing attributes and requirements.

The Co-operators                                                                                                                          2021 Jun – 2022 Aug

Team Lead – DAE Data and Analytics Environment

Led a team of up to 10 regression testers on DAE project by coaching, mentoring and hiring on a highly critical project with changing priorities. Ensured leadership alignment, business user’s involvement, identified organizational risks and developed interventions that minimized business interruptions.

• Led the strategy and planning for migration of BI and analytical inventory on SAS, RStudio and SQL from On-premises IBM Netezza databases to Azure synapse cloud. 
• Responsible for the overall quality of the regression testing through SMEs sign offs and ensuring accurate and timely stakeholder and leadership communications. 
• Identified and eliminated redundant processes, minimizing technical and experience debt realizing 15% savings.
• Created a detailed project plan for regression testing across UAT, Test and production environment. Conducted daily scrum calls and managed test priorities in alignment with the broader project teams.
• Assisted in design, requirements gathering and testing of the Regression Testing Tool that improved the testing efficiency by almost 75%.

BELL                                                                                                                                                 2018 Jun – 2021 May

Data Analytics Manager 

Led a team of data analysts for reporting automation and performance management projects for call center operations with a focus to promote self-service analytics that helped improve customer stickiness, reduce churn, and save operational costs.

• Provided BI leadership for the implementation of “Move Valet” program, a dedicated back-office team serving Bell customers moving households; improved churn for movers by 15bps and annual revenue savings of $5M.
• Led the migration of legacy reports to self-serve tools for all Loyalty & Retention executive reporting using SQL and Tableau saving more than 75%-man hours weekly.
• Conducted business casing and led the end to end set up of Tableau dashboard that unearthed actionable campaign insights to reduce reactivation of duplicate accounts by 35% saving $4M annually.

TELUS                                                                                                                                             2015 Sep – 2018 Jun

Sr Business Intelligence Analyst 

Collaborated with the enterprise analytics team and led the implementation of Tableau and Power BI for National Business Solution’s Campaign analytics, Pricing, Competitive Analysis and Product Launches. 

• Led the migration of legacy reports to automated Tableau dashboards for real time reporting that significantly improved the data usability by 20% through use of web and mobile BI applications across the enterprise.
• Gathered data, analyzed, and saw opportunity to automate marketing lists that shaped marketing campaign strategies; improved multicultural marketing campaign performance by 25%.
• Executed business case to avoid customer migration from Telus consumer to lower value Koodo rate plans representing 25% in ARPU savings; led monthly insights call with business unit leaders for feedback on campaign improvements.

Davis and Henderson                                                                                                                   2014 Nov – 2015 Jun

Project Manager, Data Migration

Managed the end-to-end customer activity data migration project for MyIdentityAssist and CreditDefend applications that protect customers against online identity theft and provides real time credit reports.

• Acted as a Cross-functional Liaison for Product, data engineering and QA teams to resolve project planning conflicts by cross training and reallocate resources to meet important deadlines and cost saving of 20%.
• Collaborated with data management team to validate designed functionality and develop framework of data services and data governance program.

Accenture                                                                                                                                      2008 Jul – 2012 Jun

Database Programmer

Collaborated with business users to understand and document business cases into technical requirements, data flow diagrams and test cases for integration of dispersed CRM, ERP, and customer data into a single source of truth.

Master of Business Administration (MBA), Schulich School of Business (2012 Sep – 2014Jun)

Bachelor of Technology (B. Tech), Thapar University (2004 Aug - 2008 Jun)