Data Analyst - SQL, ETL, BI, Python Expert

MAHATHI MANDELLI DATA ANALYST

971-***-**** ********.*******@*****.*** https://www.linkedin.com/in/mahathi-mandelli PROFESSIONAL SUMMARY

Data Analyst with 5+ years of experience developing analytics solutions, optimizing data workflows, and building automated dashboards using SQL, Python, ETL tools, and BI platforms. Skilled in CTE-based SQL modeling, Alteryx automation, Power BI & Tableau dashboards, and Python analytics. Experience includes forecasting, business reporting, stakeholder insights, and ML- ready data preparation. Strong background in curriculum development, inventory management, and web analytics. TECHNICAL SKILLS

Databases & SQL : Advanced SQL (CTEs, window functions, query optimization), PostgreSQL, Oracle DB, MySQL, Azure SQL

Programming & Analytics : Python (Pandas, NumPy, SciPy, StatsModels, scikit-learn), R, JavaScript, HTML, CSS Data Engineering & ETL : Alteryx Designer, Apache Airflow, Azure Data Factory, dbt, Power Query, Google Apps Script, Python Automation

Data Visualization & BI : Power BI (DAX, data modeling, RLS), Tableau, Looker Studio, Excel Dashboards Machine Learning & AI : k-Means Clustering, Logistic Regression, Time-Series Forecasting, Recommendation Systems Web & Analytics Tools : Shopify, Google Analytics, Google Tag Manager, Git/GitHub, Jupyter Notebook Business & Operational Tools : Advanced Excel (Pivot Tables, Macros, Power Query), Google Suite (Sheets, Forms, Slides, Docs), Inventory Management Systems

Certifications : Google Data Analytics, AWS Cloud Practitioner PROFESSIONAL EXPERIENCE:

Oregon MESA Data Analyst & Coding Specialist Portland, OR Jul 2024 – Present

• Built automated data pipelines using CTEs, window functions, and optimized SQL in PostgreSQL & Oracle DB to transform attendance, mentor, and school data into clean reporting models.

• Designed end-to-end ETL workflows in Alteryx, Python, and Power Query, standardizing messy Sheets/Forms data and cutting manual processing by 50%.

• Created interactive Power BI dashboards using DAX, star schema modeling, and RLS to deliver engagement and performance insights to district leaders.

• Developed forecasting models (StatsModels, scikit-learn) to predict student participation cycles and guide outreach planning.

• Built student-facing HTML/CSS/JavaScript websites and used Google Analytics to analyze google site usage and optimize curriculum navigation.

• Automated weekly reports and data-quality checks using Python scripts, reducing repetitive tasks for staff. Oregon MESA Curriculum & Coding Specialist Portland, OR Oct 2022 – Jun 2024

• Used Advanced Excel (Power Query, pivot tables, macros) to automate attendance and reporting for 30+ schools.

• Built Tableau dashboards by shaping CSV/Excel data into analysis-ready structures for district-level insights.

• Developed curriculum content and teaching modules on microprocessors for middle & high school students.

• Managed equipment inventory using Excel automation and Google Sheets-based tracking with validation rules. Spicen Data Analyst Intern San Francisco, CA Mar 2021 – Jun 2022

• Managed Shopify website, transactions, and inventory data to optimize customer flow and product visibility.

• Analyzed customer behavior using Python + SQL to generate retention and performance insights.

• Built ML models (k-Means clustering, Logistic Regression, simple recommender) for customer segmentation and purchase prediction.

• Automated backend operations using AI tools for cold emailing, lead follow-ups, copywriting, and workflow streamlining. Manbrosys Pvt Ltd Data Analyst Intern VZM, India Aug 2019 – Jan 2021

• Used MySQL CTEs to analyze onboarding funnels and identify drop-off points, improving completion by 12%.

• Built automated Python cleaning pipelines (Pandas, regex) to standardize logs and reduce data errors.

• Developed Google Data Studio dashboards connected to SQL for real-time usage and retention tracking.

• Managed inventory using Excel + SQL tracking systems with validation rules and automated alerts. EDUCATION

Master of Science, Computer Science Sep 2022 – Jun 2024 Portland State University, Oregon, USA GPA : 3.7/4.0 B.Tech., Information Technology Jul 2018 – Jun 2022 Maharaj Vijayaram Gajapathi Raj College of Engineering, Andhra Pradesh, India GPA : 4.0/4.0

Contact this candidate