Data Analytics & ML Engineer in Training

Satvika Kolapalli

+1-518-***-**** — ******************@*****.*** — linkedin.com/in/satvika-kolapalli-16 EDUCATION

University at Albany, SUNY Dec 2025

M.S. in Computer Science

Vignan’s Institute of Information & Technology, Visakhapatnam, India May 2023 B.Tech. in Electrical & Electronics Engineering (GPA: 3.46) TECHNICAL SKILLS

Data Analysis & BI: SQL, Excel, Power BI, Tableau, KPI dashboards, reporting, monitoring Python Analytics: Pandas, NumPy, data cleaning, EDA, automation, scripting Databases: Oracle, MySQL, PostgreSQL, MongoDB

ML/Stats: Regression, forecasting; Scikit-Learn, TensorFlow Tools: MS Office, Teams, SharePoint, Zoom, GitHub

PROJECT EXPERIENCE

Solar Power Forecasting Python, Scikit-Learn, Power BI

• Built a forecasting pipeline combining historical generation data with weather features; engineered time-based features.

• Cleaned and validated time-series data (missing values, outliers, alignment) to improve accuracy and reliability.

• Evaluated models using MAE/RMSE and summarized forecast vs. actual performance in Power BI dashboards.

• Presented insights using clear visuals (daily/weekly trends) to support data-driven planning decisions. Academic Data Management & Visualization System PHP, MySQL, REST APIs, Power BI

• Developed a centralized academic portal and standardized reporting views for consistent analytics.

• Implemented role-based access control and data validation checks to ensure data quality and governance.

• Automated recurring SQL-based reports and built dashboards for enrollment and performance tracking. Mask Detection Using IoT (Compliance Reporting) OpenCV, TensorFlow

• Logged detection outcomes and generated compliance summaries and trend counts for monitoring. TECHNICAL EXPERIENCE

Junior Engineer Intern, UVPowerTech Aug 2022 – Mar 2023 — India

• Coordinated documentation, scheduling, and compliance reporting for field projects.

• Automated routine data collection, cleaning, and analysis using Python, reducing manual reporting by 25%.

• Maintained structured Excel trackers for milestones, timelines, and status updates.

• Prepared weekly summaries highlighting risks, delays, and next steps for cross-functional teams. Programmer Analyst Trainee, FusionTech Software Jan 2020 – Feb 2021 — India

• Supported backend workflows for an eCommerce system and improved data handling logic.

• Wrote and optimized SQL queries for reporting and application workflows.

• Collaborated with QA teams on testing, validation, and technical documentation. CERTIFICATIONS

• Data Analytics Job Simulation — Forage (2025)

• Networking Essentials — Cisco (2023)

• Machine Learning — Onestop (2019)

LEADERSHIP EXPERIENCE

Supervisor, National Service Scheme (NSS) 2019 – 2023 — India

• Led a 30+ member team; managed schedules, logistics, and structured activity reporting.

• Organized events (200+ participants) and tracked outcomes for post-event summaries.

Contact this candidate