Data Engineering
Building Python ETL pipelines that load CSV, Excel and JSON data into relational databases, with data quality checks and reconciliation.
- Python
- SQL
- ETL
- Data Validation
- Data Quality
- Data Integration
hi, I'm
AnanyaCheripally
Data-driven techie building
data pipelines
01About
A little about me
- Data Engineering
- Python
- SQL
- ETL
- Data Analytics
I'm Ananya, a Master of Computer Science (Data Science and AI) student from the University of Sydney, completing my coursework in November 2026. I enjoy turning raw data into something a team can rely on, and explaining it in plain language to the people who use it.
I'm a quick learner who thrives in a team: I ask good questions, pick up new tools fast and care about doing things properly. I'm looking for a graduate or junior role in data engineering or analytics in Australia.
- Based in
- Sydney, NSW
- Studying
- MCS (Data Science & AI) · USYD
- Open to
- Graduate & junior data roles
- Fuelled by
- Coffee ☕
02Skills
My toolkit
Databases & Modelling
Designing relational schemas from ER models and automating business rules with PL/pgSQL functions and triggers.
- PostgreSQL
- MySQL
- PL/pgSQL
- ER Modelling
- Query Optimisation
Data Analysis & ML
Cleaning and exploring datasets, engineering features and comparing classification models.
- Pandas
- NumPy
- scikit-learn
- Seaborn
- Excel
- Machine Learning
Technologies & Tools
- Python
- SQL
- PostgreSQL
- MySQL
- SQLite
- Pandas
- NumPy
- scikit-learn
- Seaborn
- psycopg2
- ETL
- Data Validation
- Data Quality
- Query Optimisation
- Excel
- Tableau
- Git
- GitHub
- VS Code
- Jupyter Notebook
- Postman
- Agile
Python✦SQL✦PostgreSQL✦MySQL✦SQLite✦Pandas✦NumPy✦scikit-learn✦Seaborn✦psycopg2✦ETL✦Data Validation✦Data Quality✦Query Optimisation✦Excel✦Tableau✦Git✦GitHub✦VS Code✦Jupyter Notebook✦Postman✦Agile✦Python✦SQL✦PostgreSQL✦MySQL✦SQLite✦Pandas✦NumPy✦scikit-learn✦Seaborn✦psycopg2✦ETL✦Data Validation✦Data Quality✦Query Optimisation✦Excel✦Tableau✦Git✦GitHub✦VS Code✦Jupyter Notebook✦Postman✦Agile✦
03Experience
Where I've worked
- Feb 2023 — Jan 2025
Software Engineer (Part-time)
SAAC IT Solutions Pvt Ltd · Hyderabad, India
- Developed and maintained Python ETL pipelines to extract, transform and load CSV, Excel and JSON data into PostgreSQL and MySQL databases for business reporting.
- Wrote SQL queries to validate data loads, reconcile record counts and generate business reports.
- Automated recurring data processing and reporting workflows with Python (Pandas), reducing manual spreadsheet preparation.
- Built data quality checks (duplicates, nulls, consistency, reconciliation) and resolved failed loads by tracing root causes through execution logs.
- Worked in Agile sprints with code reviews and Git/GitHub pull requests, and documented ETL workflows and database changes.
✈ Key project
RideThe15 — Rideshare & Carpooling Platform
Built data-processing workflows and operational dashboards and scorecards with daily, weekly and monthly trend analysis.
- Python
- Pandas
- SQL
- PostgreSQL
- MySQL
- ETL
- Git
- Agile
- Jul 2022 — Jan 2023
Business Analyst Intern
SAAC IT Solutions Pvt Ltd · Hyderabad, India
- Gathered, analysed and documented business requirements, translating operational processes into structured functional requirements.
- Developed Python automation scripts to process inventory, sales and customer data from Excel, CSV and other structured sources.
- Created reusable validation scripts (Pandas, NumPy) to detect missing values, duplicates and formatting issues, and validated imported records in SQLite and PostgreSQL databases.
- Prepared functional and UAT test scenarios, performed API testing with Postman, and documented workflows and user guides.
✈ Key project
Wood Management System — Timber Depot Operations & Billing
Supported purchase, sales, stock and pricing requirements for a multi-depot billing system, validating master data and transaction reports.
- Python
- Pandas
- NumPy
- SQLite
- PostgreSQL
- Postman
- UAT
04Projects
Featured projects
University and industry projects in data engineering, databases and machine learning.
Predicting High-Priority Crime Threats in NSW
University of Sydney · Group project · 2025
Transformed 30 years of NSW BOCSAR crime data across 60+ offence subcategories from wide monthly time series into a model-ready dataset, normalising counts to rates per 100,000 population. Engineered trend features (5-year slope, momentum, volatility, peak year) and compared five classifiers (Random Forest, SVM, Logistic Regression, Naive Bayes, Decision Tree), with Random Forest and SVM reaching ~95% accuracy.
- years of data
- 30
- years of data
- offence subcategories
- 60+
- offence subcategories
- accuracy
- ~95%
- accuracy
- Python
- Pandas
- scikit-learn
- Random Forest
- SVM
Car Dealership Database System
University of Sydney · Group project
Built a 12-table PostgreSQL database from ER and relational models, enforcing data integrity with primary/foreign keys, CHECK constraints and cascading rules. Developed PL/pgSQL functions and triggers to automate business rules, including sale price calculation, vehicle status updates, option limits and payment completion tracking. Implemented a Python (psycopg2) feature to update car sale records with input validation and parameterised SQL queries, and performed end-to-end application testing.
- tables
- 12
- tables
- triggers
- PL/pgSQL
- triggers
- SQL
- Parameterised
- SQL
- PostgreSQL
- PL/pgSQL
- Python
- psycopg2
- ER Modelling
Forest Cover Classification & Diabetes Risk Analysis
University of Sydney · Pair project · Mar 2025 — May 2025
Cleaned and explored a health survey dataset using Pandas and Seaborn (deduplication, missing-value imputation, range validation) to analyse diabetes risk factors. Built an SVM (RBF kernel) classifier in scikit-learn to predict forest cover types, applying feature scaling, one-hot encoding, PCA, class weighting and RandomizedSearchCV with stratified cross-validation, achieving 67% test accuracy.
- test accuracy
- 67%
- test accuracy
- RBF kernel
- SVM
- RBF kernel
- cross-validation
- Stratified
- cross-validation
- Python
- Pandas
- Seaborn
- scikit-learn
- SVM
- PCA
RideThe15 — Rideshare & Carpooling Platform
SAAC IT Solutions · Software Engineer (Part-time)
Built data-processing workflows and operational dashboards and scorecards with daily, weekly and monthly trend analysis for a rideshare and carpooling platform.
- trend analysis
- Daily
- trend analysis
- trend analysis
- Weekly
- trend analysis
- trend analysis
- Monthly
- trend analysis
- Python
- SQL
- Pandas
- Dashboards
Wood Management System — Timber Depot Operations & Billing
SAAC IT Solutions · Business Analyst Intern
Supported purchase, sales, stock and pricing requirements for a multi-depot billing system, validating master data and transaction reports.
- billing
- Multi-depot
- billing
- data validation
- Master
- data validation
- reports
- Transaction
- reports
- Requirements Analysis
- Data Validation
- UAT
- Postman
05Education
Where I've learned
- Feb 2025 — Present
Master of Computer Science (Data Science and AI)
University of Sydney · Sydney, Australia
Coursework completion: November 2026 · Degree conferral: 2027
- Mar 2020 — Jun 2024
Bachelor of Technology — Computer Science Engineering
Gokaraju Rangaraju Institute of Engineering and Technology (GRIET) · Hyderabad, India
🏆 Achievements
Sydney Scholars India Scholarship (2025)
Awarded by the University of Sydney for academic performance, leadership and community engagement.
📜 Certifications
psst… click a certificate to see the real thing ✨
06Leadership & Volunteering
Giving back
- May 2025 — Jul 2025
Volunteer — Professor Harry Messel International Science School
University of Sydney
- Supported students and international participants with activities, logistics and day-to-day queries during the academic program.
- Mar 2023 — Apr 2024
Secretary — IEEE Computer Society Student Chapter
GRIET
- Coordinated technical workshops, student and faculty communications, event documentation and engagement activities.
Looking for a Graduate Data Engineer or Analyst?
Take a look at my projects or download my résumé for the full details.
07 — Contact
Let's grab a coffee ☕
Let's chat! Feel free to reach out about graduate or junior opportunities, projects, or just to connect.