Summary
Overview
Work History
Education
Skills
Certification
Projects And Academic Competitions
Accomplishments
Timeline
Generic

Venkatachalam Kapuganti

Salt Lake City

Summary

Accomplished Data Analytics and Business Intelligence Professional with 8+ years of experience delivering impactful analytics and intelligent automation in consulting and enterprise settings. Specialized in developing AI-powered solutions, including natural language chatbots using Microsoft Azure and Snowflake Cortex AI, to democratize data access and enhance decision-making. Proven ability to lead and inspire cross-functional teams—successfully managed a team of 12—to architect and implement scalable data platforms, semantic models, and BI strategies. Passionate about transforming traditional analytics into AI-driven insights that drive business outcomes. Certified Power BI Data Analyst and Azure Data Engineer with expertise in Tableau, Snowflake, and delivering data-driven solutions across diverse domains including Finance, Grants, Accounting, Manufacturing, Human Resources, and Supply Chain. Innovative Developer known for high productivity and efficient task completion. Skilled in software development, database management, and user interface design. Excel at problem-solving, teamwork, and adaptability to excel in fast-paced environments. Commitment to continuous learning and improvement drives success in developing scalable solutions.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Sr. Analytics Developer

DiLytics Ltd
San Mateo
12.2023 - Current
  • Team Leadership & Client Engagement: Managing a team of 12 professionals, including Business Analysts, Data Engineers, and Data Analysts. Collaborated closely with 3+ clients to gather requirements, design data architectures, prepare and analyze data, and create interactive dashboards that deliver actionable insights and data-driven recommendations.
  • DART Solution Development: Designed and implemented the Data Analysis Reporting Tool (DART) using Snowflake and Tableau for a California-based client. Integrated data from Salesforce, SharePoint, and Google Forms, utilizing Snowpark for seamless data integration into Snowflake. Delivered interactive Tableau reports for six different programs, showcasing expertise in Snowflake and Tableau.
  • AI Chatbot in Snowflake: Built a natural language chatbot in Snowflake using Cortex Analyst to query the snowflake database and deliver user-friendly, conversational response.
  • AI Chatbot in Microsoft: Developed an intelligent chatbot using Microsoft Azure, leveraging Azure Bot Service, Azure OpenAI, Web Apps, and Langchain to enable natural language interaction and dynamic response generation. Users can directly interact with Database from Microsoft teams and get the responses.
  • Integrated Oracle ADW-Power BI Solution: Created a robust analytics solution on financial analytics (Account Receivables, Account Payables and General Ledger), Grants and procurement using Oracle Autonomous Data Warehouse (ADW), OAC and Power BI for a Los Angeles based Client. Developed pipelines using Oracle Data integrator (ODI) to extract and transform the data from Oracle EBS into ADW and developed insightful Power BI solutions. I acquired in-depth expertise in data modeling, data integration, and report building.
  • Microsoft Fabric Analytics: Developed in-house end-to-end solutions for financial insights, grants analytics, HR analytics and procurement analytics using Microsoft Fabric, covering the complete data pipeline from staging to reporting. All these solutions are integrated with Microsoft Chatbots.

Data Analyst Intern

Intermountain Health
Salt Lake City
01.2023 - 08.2023
  • Created interactive dashboards with key performance indicators (KPIs) in Tableau, driving data-informed decision-making. These dashboards led to a 15% savings in material prices and a 10% increase in vendor performance.
  • Monitored ETL data pipelines, ensuring a 99.9% job success rate and minimizing data processing errors.
  • Conducted data extraction, Exploratory data analysis (EDA), data wrangling, and manipulation using Alteryx, reducing data preparation time by 30% and ensuring high data quality and consistency throughout the process.

Senior BI Developer

BHEL
Trichy
08.2018 - 08.2022
  • Demonstrated proficiency in writing, understanding, and debugging complex SQL statements. Proficient in Python for data analysis, adept at handling and analyzing complex datasets, and generating meaningful visualizations.
  • Carried out data analysis and business intelligence initiatives, extracting, transforming, and loading data from diverse sources, including SQL databases, flat files, and cloud storage. Processed various data types (JSON, XML, CSV, IOT).
  • By analyzing large sales and financial data (SAP-ERP & Sales force data) in Tableau, presented actionable insights and sales growth opportunities that increased sales revenue by 15% and reduced sales costs by 5% (5B to 5.75B INR). Adept in writing LOD functions, parameters and sets.
  • Developed SQL queries and scripts in SQL server to analyze operations data and identified bottle necks and patterns, which led to a 10% increase in productivity.
  • Used SQL and Python to analyze total warehouse inventory of 1200+ varieties of materials, identified $1 million in potential cost savings, and developed data-driven insights in Power BI to improve inventory management by 15%.
  • Drove efficient data analytics and reporting solutions by designing and implementing Dimensional Modeling with Star Schema, resulting in a 30% improvement in data retrieval.
  • Teamed up with data engineers and subject matter experts and produced comprehensive technical documentation for BI solutions, including data dictionaries, data integration guides, and report development.

Data Engineer

BHEL
01.2017 - 08.2018
  • Proficient in debugging complex T-SQL/MySQL statements. Have an experience in integrating and pulling data via REST and third-party API’s.
  • Proficient in designing, creating, validating, and constructing ETL pipelines within SSIS and Azure Data Factory.
  • Worked with SAP developers to ingest data (sales, production, and financial transaction data) from SAP HANA, SDR, PLM into ADLS on a daily basis and orchestrate the data movement to Snowflake using ADF pipelines.
  • Expertise in the Microsoft Business Intelligence stack, including SSRS, SSIS, SSAS, query analyzer and profiler.
  • Experience in Azure stack (Azure Data factory, Synapse analytics, Azure Data Studio, Storage Accounts, Key Vault, Logic Apps, Dedicated SQL Pools, Spark Pools).
  • Expertise in Git, CI/CD tools and practices for automating the development and deployment of data pipelines.
  • Supported implementation of data governance policies and procedures to ensure the quality and security of the data.

Education

Master of Science - Business Analytics

University of Utah, David Eccles School of Business
Salt Lake City, UT, USA

Bachelor of Engineering - Electrical & Electronics

Andhra University
Visakhapatnam, India

Skills

  • Tableau
  • PowerBI
  • Domo
  • SSRS
  • OAC
  • Snowpark
  • Azure Data factory
  • Advance Excel
  • VBA
  • SSIS
  • Python
  • SQL
  • R
  • Pyspark
  • Git
  • RDBMS
  • Azure SQL
  • PostgreSQL
  • MySQL
  • Oracle
  • Snowflake
  • Azure
  • Oracle cloud
  • Scrum
  • Agile methodologies
  • Jira
  • Inferential Statistics
  • Descriptive Statistics
  • Regression
  • Correlation
  • Hypothesis
  • A/B Testing
  • Time Series analysis

Certification

  • Microsoft PL-300 Power BI Data Analyst Associate
  • Data camp R
  • Microsoft Azure Data Engineer (DP-203) Associate certification
  • Tableau
  • Hacker SQL Intermediate certification

Projects And Academic Competitions

  • Game Day Analytics Challenge, Conducted in-depth analysis of Super Bowl Twitter ad data and displayed insights including ad sentiment analysis.
  • Kaggle Project Home Credit Default Risk, Built a machine learning model to predict default risk using data preprocessing, EDA, feature engineering, and various classification algorithms.
  • DomoLayton Hackathon challenge, Utilized interactive dashboard creation and applied data cleaning, transformation, and analysis techniques on Layton's construction data.

Accomplishments

  • Winner in GameDay Analytics

Timeline

Sr. Analytics Developer

DiLytics Ltd
12.2023 - Current

Data Analyst Intern

Intermountain Health
01.2023 - 08.2023

Senior BI Developer

BHEL
08.2018 - 08.2022

Data Engineer

BHEL
01.2017 - 08.2018

Master of Science - Business Analytics

University of Utah, David Eccles School of Business

Bachelor of Engineering - Electrical & Electronics

Andhra University

Similar Profiles

  • Issac Montoya

    Issac MontoyaIssac Montoya

    Kaysville Utah at centerline developmentKaysville Utah at centerline development

  • Jayden Due

    Jayden DueJayden Due

    Office Administrative Assistant at On Track Mortgage SolutionsOffice Administrative Assistant at On Track Mortgage Solutions

  • Perla Vega

    Perla VegaPerla Vega

    Lead Cleaning Specialist at Magic Lady Proffesional CleaningLead Cleaning Specialist at Magic Lady Proffesional Cleaning

  • MARILEE FREW

    MARILEE FREWMARILEE FREW

    OFFICE ADMIN LEAD/TRAINER at WESTERN BIG CITY/ATLAS DISPOSALOFFICE ADMIN LEAD/TRAINER at WESTERN BIG CITY/ATLAS DISPOSAL

  • Kapil Kumar

    Kapil KumarKapil Kumar

    Sr. Adobe Analytics + Web Developer at cventSr. Adobe Analytics + Web Developer at cvent

CREATE PROFILE
Venkatachalam Kapuganti