Kishore S.
Verified Expert in Engineering
Business Intelligence Developer
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
Experience
- Dashboards - 8 years
- Power BI Desktop - 8 years
- Microsoft Power BI - 8 years
- DAX - 8 years
- Data Visualization - 8 years
- Data Analysis - 8 years
- Business Intelligence (BI) - 7 years
- SQL - 6 years
Availability
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
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.
Power BI Developer
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.
Power BI Consultant
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.
Power BI Developer
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%.
Software Developer
Atlas Healthcare
- Provided object-oriented analysis, coding, and testing for a proprietary hospital management software application. Defined, documented, and managed requirements for a major section of this application.
- Introduced a reproducible software development methodology, leading to higher-quality product releases and a 27% reduction in errors.
- Championed the implementation of coding reviews that detected programming errors early in the development process, accelerating product go-to-market time by more than 15%.
- Championed the implementation of coding reviews that detected programming errors early in the development process, accelerating product go-to-market time by more than 15%.
Experience
Statutory Reporting and 3rd-party Auditing with Power BI Implementation
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
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
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/Education
Master's Degree in Business Administration (MBA)
Anna University - Chennai, India
Bachelor's Degree in Information Technology
Amrita Vishwa Vidyapeetham - Coimbatore, India
Certifications
Microsoft Certified: Azure Data Fundamentals
Microsoft
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
Fundamentals of Digital Marketing, Social Media, and E-Commerce
Wharton School of the University of Pennsylvania | via edX
Skills
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, BigQuery
Paradigms
Business Intelligence (BI), Best Practices
Languages
SQL, Power Query M, Excel VBA, Google Apps Script, Snowflake, C, C++
Platforms
Azure, SharePoint, Salesforce, Microsoft Dynamics 365, Google Ads, Magento, Xerox DocuShare, Microsoft Power Automate
Storage
Data Integration, Database Security, Databases, SQL Server Management Studio (SSMS), Azure SQL
Industry Expertise
Social Media
Other
DAX, Data Visualization, Data Analysis, Administration, Dashboards, Dashboard Development, Data Analytics, Data Modeling, Connectivity, Root Cause Analysis, Product Owner, Business Analysis, Data, 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 (RLS), Benchmarking, Technical Documentation, Dashboard Design, Inventory Management, Sales Analysis, Data Analytics (Marketing), Design, User Interface (UI), User Experience (UX), Amazon FBA, Facebook Ads, Dynamics CRM 365, Service Blueprints, Data Warehousing
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring