Kishore S., Developer in Toronto, ON, Canada
Kishore is available for hire
Hire Kishore

Kishore S.

Verified Expert  in Engineering

Business Intelligence Developer

Location
Toronto, ON, Canada
Toptal Member Since
March 1, 2024

Kishore is an experienced BI professional who translates raw data into actionable insights using Power BI, DAX, SQL, and data analytics. He prioritizes his client's unique business needs to deliver intuitive BI solutions—from creating interactive dashboards to optimizing data models and automating reporting processes—helping various clients make confident, data-driven decisions. At Zago, Kishore crafted a near-real-time sales dashboard—growing sales by 15% per product YoY.

Portfolio

Manulife Canada
Microsoft Power BI, Data Analysis, SimCorp, SQL Server Management Studio (SSMS)...
CCI Global Technologies
Power BI Desktop, Microsoft Power BI, Power BI Mobile, Power BI Embedded...
Independent Contracting
Power BI Desktop, Microsoft Power BI, SQL, Google Analytics, Google Ads...

Experience

Availability

Part-time

Preferred Environment

Microsoft Power BI, Azure, SQL Server Management Studio (SSMS), SharePoint, Office 365, Jira, Git, Dashboards, Dashboard Development, Dashboard Design

The most amazing...

...Power BI reports I've crafted were for a prominent client showcased at semashow.com, spotlighting the automotive industry's leading analytics solutions.

Work Experience

Senior Power BI Developer – Exadel

2022 - 2024
Manulife Canada
  • Improved compliance and reporting accuracy by collaborating closely with statutory reporting and US tax teams, providing targeted data and analytics guidance to address their specific needs.
  • Enhanced reporting capabilities across the organization by developing 25 highly complex Power BI solutions for book roll-forward statutory reporting, leveraging data from the data lake.
  • Designed, implemented, and maintained large data models in Power BI, utilizing SQL and Power Query M scripts to load and transform data efficiently, optimizing performance and data accuracy.
  • Conducted comprehensive discovery sessions to understand business requirements and defined the scope of the Power BI environment for various stakeholders, ensuring alignment between technical solutions and business needs.
  • Facilitated data-driven decision-making at the highest levels of the organization by engaging with senior executives, including assistant VPs, directors, and tax managers, showcasing the versatility of Power BI for tailored, on-demand reporting.
  • Increased efficiency and platform adoption by crafting technical blueprints and streamlining power users' transition to Power BI. Maintained detailed project documentation to ensure transparency and facilitate knowledge transfer.
Technologies: Microsoft Power BI, Data Analysis, SimCorp, SQL Server Management Studio (SSMS), SQL, Root Cause Analysis, Regression Testing, Jira, Power BI Report Server, Power BI Desktop, DAX, Data Visualization, Business Intelligence (BI), Business Analysis, Power Query M, Product Owner, Administration

Power BI Developer

2021 - 2022
CCI Global Technologies
  • Led all Power BI report development and deployment efforts at CCI Global Technologies, successfully implementing row-level security and benchmarking capabilities. This resulted in a 35% YTD increase in overall billable connections for prominent clients.
  • Collaborated actively with external business users to formulate BI data, reports, and dashboard requirements in the scope of work document.
  • Translated user requirements into technical requirements to ensure alignment with project objectives and deliverables.
  • Designed, developed, and maintained user-friendly and visually appealing Power Apps solutions for implementing data writeback features.
  • Researched actively and documented industry best practices for BI to stay up to date with development efforts.
Technologies: Power BI Desktop, Microsoft Power BI, Power BI Mobile, Power BI Embedded, Power BI Report Server, SQL, Azure SQL

Power BI Consultant

2020 - 2021
Independent Contracting
  • Built and maintained Power BI dashboards from data such as inventory, production, and yield time to create reports and what-if analysis.
  • Illustrated digital marketing campaign results with the company, dictating future spending and new marketing efforts.
  • Transformed multiple digital marketing campaign data into interactive visuals highlighting the different ad-campaign performances.
Technologies: Power BI Desktop, Microsoft Power BI, SQL, Google Analytics, Google Ads, Facebook Ads, Mailchimp, Dynamics CRM 365, Salesforce

Power BI Developer

2016 - 2020
Zago
  • Utilized a Power BI and ERP platform to transform overall business data into enterprise-grade business intelligence and analytics solutions. Created data models and dashboards for the eCommerce, sales, and marketing teams.
  • Developed a near real-time eCommerce sales dashboard, which enabled up-to-the-hour sales insights into marketing/promotional events. Increased online sales (up to 15% per product) YOY and lowered the cart abandonment rate by 23%.
  • Led efforts to resolve inventory management deficit. Optimized production levels and helped the leadership team forecast better, resulting in an 8.9% revenue growth and 15% reduction in operational overheads.
  • Deployed real-time performance tracking dashboards for marketing campaigns, which enabled the tracking of campaign effectiveness by measuring sales traction and ROI using visually appealing and easy-to-read data visualizations.
  • Increased the market share of the leading brand Body Buddy (RTD Protein drink) from 27% to 55% in two years while competing with brands that were economical by 40%.
Technologies: Power BI Desktop, Microsoft Power BI, Power BI Report Server, Google Ads, Magento, Amazon FBA, Microsoft Excel, SharePoint

Statutory Reporting and 3rd-party Auditing with Power BI Implementation

Drove the implementation of Power BI solutions to enhance the efficiency and reliability of data consumption for the US taxation and finance team at Manulife. I leveraged the data from the data lake and developed 25 highly complex book roll-forward statutory reporting solutions in Power BI.

To ensure alignment with stakeholders, I conducted comprehensive discovery sessions to understand business requirements and define the scope. I developed, implemented, and maintained large data models in Power BI, utilizing SQL and Power Query M scripts for efficient data loading and transformation. I also worked closely with statutory reporting and US tax teams to provide targeted data and analytics oversight.

Additionally, I engaged with senior executives to showcase the versatility of Power BI for tailored, on-demand reporting, ensuring transparency by crafting strategic and technical blueprints and maintaining detailed project documentation.

Embedded Reporting Solution for Automobile Sector Clients

Led all Power BI report development and deployment efforts at CCI Global Technologies, focusing on delivering embedded analytics solutions for prominent clients such as BMW, BASF, Subaru, and Rivian. I implemented row-level security and benchmarking capabilities, resulting in a remarkable 35% year-to-date increase in overall billable connections.

I managed the development and maintenance of Power BI reports, embedding them into client applications and portals. Actively collaborating with external business users, I gathered BI data, such as report and dashboard requirements, translating them into technical specifications to align with project objectives.

Additionally, I designed, developed, and maintained user-friendly Power Apps solutions for implementing data write-back features. I also stayed up to date with industry best practices for BI through active research and documentation efforts.

Enterprise-grade BI and Analytics Implementation for Zago

Transformed overall business data into enterprise-grade BI and analytics solutions using Power BI and ERP platforms. I enabled stakeholders to make informed business decisions by providing access to important eCommerce and performance data—achieving significant growth in revenue and market share.

I focused our efforts on creating data models and dashboards for the eCommerce, sales, and marketing teams—covering retail, institutional, and online sales, inventory, and marketing analytics. I developed a near-real-time eCommerce sales dashboard, offering up-to-the-hour insights into marketing and promotional events. We achieved a 23% reduction in cart abandonment—substantially growing online sales by up to 15% per product year over year.

Revenue also increased by 8.9%, and operational overheads decreased by 15% after I led efforts to resolve inventory management deficits by creating and maintaining an in-stock report, optimizing production levels, and improving forecasting accuracy.

Finally, I deployed real-time reports for marketing campaigns and a KPI dashboard to measure campaign metrics—increasing market shares from 27% to 55% for the leading brand, Body Buddy, in two years while competing with more economical brands by 40%.

Power BI Dashboard Designs

https://kishoresambath.wordpress.com/2024/02/29/power-bi-dashboard-designs/
A blog that I developed to serve as my Power BI dashboard playground. Here, I've gathered some of my pet projects crafted with publicly available data. Unlike my usual client work, these projects are more of a casual showcase of my dashboard design style.

Tools

Power BI Desktop, Microsoft Power BI, Power BI Mobile, Power BI Embedded, Power Query, Power BI Report Server, Microsoft Excel, Jira, Confluence, Git, Slack, Adobe Illustrator, Microsoft Power Apps, Google Analytics, Mailchimp

Paradigms

Business Intelligence (BI), Best Practices

Other

DAX, Data Visualization, Data Analysis, Administration, Dashboards, Dashboard Development, Data Modeling, Connectivity, Root Cause Analysis, Product Owner, Business Analysis, Data, Data Analytics, Visualization, Data Transformation, Data Governance, Data Quality, Digital Marketing, eCommerce, Computer Science, Information Technology, Networks, Operating Systems, Software Engineering, IT Project Management, IT Ethics and Legal Issues, Programming Languages, Business Development, New Business Development, Product Leadership, Leadership, Team Leadership, Strategic Planning, Strategy, Financial Analysis, Digital Marketing Strategy, Marketing Strategy, Sales, Operations Management, Entrepreneurship, Negotiation, Product Management, Branding, Advertising, Business Psychology, Organizational Behavior (OB), Business Ethics, Office 365, SimCorp, Regression Testing, Stakeholder Management, Business Requirements, Documentation, Row-Level Security, Benchmarking, Microsoft Dynamics 365, Technical Documentation, Dashboard Design, Inventory Management, Sales Analysis, Data Analytics (Marketing), Design, User Interface (UI), User Experience (UX), Google Ads, Amazon FBA, Facebook Ads, Dynamics CRM 365

Languages

SQL, Power Query M, Excel VBA, Google Apps Script

Platforms

Azure, SharePoint, Salesforce, Magento, Xerox DocuShare

Storage

Data Integration, Database Security, Databases, SQL Server Management Studio (SSMS), Azure SQL

Industry Expertise

Social Media

2014 - 2016

Master's Degree in Business Administration (MBA)

Anna University - Chennai, India

2008 - 2012

Bachelor's Degree in Information Technology

Amrita Vishwa Vidyapeetham - Coimbatore, India

JANUARY 2021 - PRESENT

Microsoft Certified: Azure Data Fundamentals

Microsoft

DECEMBER 2020 - DECEMBER 2023

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

SEPTEMBER 2018 - PRESENT

Fundamentals of Digital Marketing, Social Media, and E-Commerce

Wharton School of the University of Pennsylvania | via edX

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring