Data Analyst • Business Intelligence • SQL • Power BI • Python
Nikshith Reddy Sheelam
I am a Data Analyst with experience in SQL-based automation, data validation, and business intelligence reporting. I work with complex datasets to ensure data accuracy, build dashboards, and deliver insights that support data-driven decision-making for leadership and stakeholders.
Reporting
20–25%
reduced turnaround time
Quality
25%
fewer downstream errors
Compliance
Audit-ready
validation & QA workflows
About Me
I am currently working as an Accountability Data Analyst at Kansas City Public Schools, where I develop SQL-based validation logic, automate data quality checks, and design Power BI and SSRS reports for district and school leadership.
I have hands-on experience working across the full data lifecycle — from data ingestion and validation to analysis, visualization, and reporting. My work supports audit-ready reporting, regulatory compliance, and operational decision-making.
I hold a Master’s degree in Computer Science and have worked with education, nonprofit, and academic datasets. I enjoy transforming raw data into reliable insights and collaborating with cross-functional teams to solve data challenges.
Professional Work Experience
Accountability Data Analyst
Kansas City Public Schools • Nov 2024 – Present
- Develop and maintain SQL Server / Azure SQL triggers and automated actions to validate and correct student data, ensuring accurate, compliant student records.
- Design, build, and optimize Power BI dashboards and SSRS reports for district and school leadership, improving access to key metrics and reducing reporting turnaround time by 20–25%.
- Implement data validation, reconciliation, and QA workflows within SQL and BI systems, ensuring audit-ready, high-quality data for accountability reporting.
- Perform statistical analysis, calculations, and projections as a team contributor for MSIP submissions to MOSIS, supporting 100% on-time, compliant state reporting.
- Execute sandbox testing and production validation of SQL logic, dashboards, and reports, reducing downstream reporting errors by 25%.
- Collaborate with IT, data engineering, and SIS teams to resolve data integration issues, validate data loads, and maintain consistent datasets across development and production environments.
Data Analyst, Volunteer
WeCodeKC • Jul 2024 – Jan 2025
- Implemented logistic regression models to analyze factors influencing student retention, improving at-risk student predictions by 25%.
- Streamlined data integration and ETL using Python (Pandas, NumPy) and SQL, reducing processing time by 50% and ensuring data consistency.
- Built dynamic Tableau dashboards showing real-time student engagement and course effectiveness, improving decision-making speed by 15%.
- Conducted statistical analysis with R and Python (Pandas, NumPy, scikit-learn) to assess program impact, enhancing student retention by 10%.
- Optimized Spark and Hadoop data pipelines, improving processing efficiency by 30% and automating Python-based data cleaning to reduce manual work by 50%.
Student Technical Assistant
University of Missouri–Kansas City • Jun 2023 – May 2024
- Improved SQL queries by implementing indexing and partitioning techniques, significantly reducing data retrieval times by 30% and enhancing overall database efficiency and performance.
- Automated data cleaning tasks using Python with Pandas, cutting down manual processing time by 50%.
- Established a MySQL database to centralize over 1,000 student records, improving data access speed by 40%.
- Created Tableau dashboards and SSRS reports to support data analysis and reporting needs.
- Led a data migration project using SSIS for ETL, finishing two weeks ahead of schedule with no data loss.
- Trained 50+ users on SQL, Excel, and Tableau, leading to a 25% increase in effective use of these tools.
Technical Projects
Movie Ratings Analysis (Apr 2024)
Python (Pandas, NumPy), SQL, Tableau
- Analyzed ~20,000 movie ratings using Python (Pandas, NumPy) and SQL to identify trends in viewer preferences.
- Performed data cleaning, aggregation, and exploratory data analysis (EDA), improving dataset usability by 30%.
- Computed statistical summaries (average ratings, rating distribution, top genres) to highlight key patterns.
- Created interactive dashboards and visualizations using Tableau, showing genre popularity, rating trends, and most-watched movies.
- Built reusable Python-SQL workflow to automate data preprocessing, aggregation, and visualization updates for new ratings data.
Retail Sales Analysis (Oct 2023)
Python (Pandas, scikit-learn, SciPy), Matplotlib, Seaborn
- Cleaned and aggregated a dataset of ~40,000 retail transactions using Python (Pandas, scikit-learn, SciPy).
- Conducted statistical analysis; top 20% of products contributed ~55% of revenue; peak months ~25% higher average sales.
- Built visualizations with Matplotlib and Seaborn to highlight weekly/monthly sales trends, revenue distribution, and top-performing products.
- Developed Python scripts to automate preprocessing and reporting, reducing manual preparation time by ~20%.
Big Data Analytics of Mobile Applications (Jan 2023)
HDFS, Hive, Spark, Power BI
- Processed a dataset of ~1 million mobile app events using HDFS, Hive, and Spark, performing aggregation, filtering, and ETL preprocessing for analysis.
- Built HiveQL queries to extract insights on user activity and location patterns.
- Created Power BI dashboards to visualize daily active users and engagement trends, enabling faster analysis of usage patterns by ~15%.
- Implemented data pipelines to clean and transform incoming datasets, reducing manual preprocessing by ~20%.
Technical Skills
Core Data Analysis & Programming:
SQL, Python (Pandas, NumPy), R, PySpark, C, C++, Java, JavaScript, HTML, CSS
Business Intelligence & Reporting:
Power BI (DAX, Power Query), Tableau, Excel (Advanced), SSRS, SSAS, Seaborn
Database & Data Platform:
SQL Server, Azure SQL, MySQL, Oracle DB, PostgreSQL, MongoDB, NoSQL, Amazon Redshift
Data Engineering & Automation:
SQL-based automation (stored procedures, triggers, scheduled actions), CI/CD, Docker
Cloud Platforms:
Azure, AWS, Google Cloud Platform, Oracle Cloud
Analytics & Development Tools:
Google Colab, Jupyter Notebook, RStudio, Visual Studio, Git, GitHub
Operating Systems:
Windows, macOS, Linux
Contact
Let’s connect
Phone+1 816-726-9353
Location
Kansas City, Missouri