Manikanta Naidu Dorepalli
Summary
Results-driven Data Analyst with a Master’s degree in Computer Science and extensive experience in data analysis, reporting, and visualization using SQL, Python, and Power BI. Expertise in transforming complex datasets into actionable insights that drive informed business and operational decisions. Skilled in collaborating with cross-functional teams to enhance data-driven strategies and improve overall performance. Committed to leveraging analytical skills to support organizational goals and foster data-centric cultures.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
SiriusXM
08.2023 - Current
- Analyze large-scale customer and operational datasets to support business intelligence and reporting initiatives.
- Develop and maintain Power BI dashboards to track KPIs, subscriber trends, and performance metrics for stakeholders.
- Write optimized SQL queries to extract, join, and transform data from relational databases for analytics and ad-hoc reporting.
- Perform trend analysis and exploratory data analysis (EDA) to identify patterns and actionable insights.
- Collaborate with cross-functional teams to define metrics, reporting requirements, and data logic.
- Conduct data quality checks and reconciliation to ensure accuracy and reliability of reports.
Data Analyst
I-CINERGY Techmatics
07.2021 - 04.2023
- Collected, cleaned, and transformed data from multiple sources using Python (Pandas) and SQL for analytics and reporting.
- Built interactive dashboards and reports using Power BI and Excel to monitor business and operational KPIs.
- Performed data validation, aggregation, and trend analysis to support client and internal analytics requirements.
- Assisted in automating recurring reports and manual data workflows, improving reporting efficiency.
- Worked closely with project teams to translate business requirements into data-driven insights and visualizations.
- Documented data processes, assumptions, and metric definitions for consistency and reusability.
Education
MS - Computer Science
Oklahoma City University
Oklahoma City05.2025
BTECH - Information Technology
Sagi Ramakrishnam Raju Engineering College
India05.2023
Skills
- Programming Languages: Python, SQL
- Machine Learning & Deep Learning: LSTM, Keras, TensorFlow, Predictive Modeling
- Data Analysis & Visualization: Pandas, Matplotlib, Power BI, Excel
- Web & Application Development: Flask, Tkinter, SQLite, REST API Integration
- IoT & Embedded Systems: ESP32 CAM, Real-time Data Collection & Monitoring
- Database & Data Engineering: SQLite, Data Cleaning, Data Aggregation, Caching
- Tools & Technologies: Jupyter Notebook, Git, Visual Studio Code, Tableau
- Soft Skills: Problem Solving, Analytical Thinking, Report Generation, UI/UX Design
- Cloud Technologies: AWS, Azure(basic)
Certification
- Introduction to Data Science by Kaggle Learn
- Power BI for Beginners – Great Learning Academy
- Data Analytics with Python – NPTEL
- Python for Data Science – Cognitive Class (by IBM)
PROJECTS
Stock Price Prediction Using LSTM with Flask Web Interface
- Designed and implemented an LSTM-based deep learning model to predict stock prices of S&P 500 companies using historical market data.
- Developed a responsive Flask web application to provide users with interactive stock prediction and visualization features.
- Utilized Pandas and Matplotlib to handle data preprocessing and generate real-time trend visualizations.
- Integrated caching mechanisms to optimize performance and reduce redundant computations for repeated predictions.
- Enabled real-time fallback predictions using Keras/TensorFlow, ensuring robustness and minimal downtime.
Tools: Flask, Keras/TensorFlow, Pandas, Matplotlib, Python
AI-based Access Control System for COVID Safety
- Developed a real-time data dashboard in Power BI to visualize and monitor student access control data captured via ESP32 CAM IoT devices.
- Aggregated and analyzed facial recognition and temperature data using Python, Pandas, and Excel to identify access patterns and compliance trends.
- Integrated live IoT data streams into Power BI for dynamic updates, enabling real-time monitoring and decision-making.
- Designed an interactive and user-friendly interface to present key access control metrics and actionable insights.
- Streamlined reporting and improved campus safety measures by automating data collection, analysis, and visualization.
Tools: Python, Power BI, Excel, Pandas, ESP32 CAM
A Desktop Application to Track Students' Academic Performance and Attendance
- Designed and developed a Python desktop application with Tkinter GUI and SQLite backend for tracking student grades and attendance.
- Implemented CRUD operations and efficient data storage to ensure smooth academic record management.
- Performed exploratory data analysis (EDA) with Pandas to reveal student performance trends and areas needing attention.
- Generated insightful reports and visualizations to support academic planning and improve learning outcomes.
- Streamlined manual record-keeping by digitizing attendance and grading processes in an intuitive desktop interface.
Tools: Python, SQLite, Pandas, Tkinter
Timeline
Data Analyst
SiriusXM
08.2023 - Current
Data Analyst
I-CINERGY Techmatics
07.2021 - 04.2023
MS - Computer Science
Oklahoma City University
BTECH - Information Technology
Sagi Ramakrishnam Raju Engineering College