Anudeep Vanjavakam
Principal Data Analyst @Moulton Niguel Water District
Signup · Get unlimited contacts
WORK HISTORY
Principal Data Analyst @Moulton Niguel Water District
Laguna Hills, CA, US
Led the District’s 217M+ O&M and CIP budgeting analytics lifecycle, building executive-grade financial models, automating QA/QC tools that cut 3+ hours per iteration, and earning Board recognition in achieving GFOA Triple Crown Award Built end-to-end ETL pipelines ingesting incremental energy usage & billing data (Utility API → AWS Postgres), powering $3M+ energy forecasting, peak/off-peak optimization, and org-wide BI tools. Engineered automated flat-file ETL framework for customer portal (180K+ users) upgrade (v8→v11), delivering daily data syncs from ERP SQL Server and saving $65K in integration consulting. Co-built and launched a Power BI Budget Tracker, integrating real-time ERP data to eliminate manual PDF monitoring and empower 45+ departments with self-service financial insights visibility — enhancing accountability, saving hours of effort, and improving budget management efficiency. Designed and deployed an interactive dashboard (R, SQL, Posit Connect) that automated month-end GL allocation unbilled receivables by pulling live data, calculating fund splits using dynamic parameters, and eliminating 40+ hours of manual accounting effort per close cycle.
EDUCATION
Ratnam High School
High School
Udacity
AI Programming with Python, Artificial Intelligence
Narayana Junior College
Pre-University, Maths, Physics, Chemistry
SRM IST Chennai
Bachelor’s Degree, Computer Science and Engineering
W. P. Carey School of Business – Arizona State University
Master’s Degree, Business Analytics
SKILLS
ABOUT ANUDEEP VANJAVAKAM
I’m a Principal Data Analyst with 10+ years of experience designing and scaling full-stack analytics solutions that drive business impact. My journey has taken me from crunching numbers to building modern data platforms, leading projects that integrate data, ML, and automation to solve high-stakes business problems.Over the years, I\'ve:Built end-to-end ETL pipelines and automated reporting tools using SQL, Python, R, Power BI, dbt and cloud platforms (AWS, GCP).Led analytics modernization for enterprise systems—saving thousands of hours, reducing vendor dependency, and enabling data-driven decision-making.Translated messy, siloed datasets into high-value insights used by executives, finance teams, and operations leaders.Been a key driver of award-winning budgeting, billing, water demand & energy forecasting systems at a major California utility.Languages: Python, R, SQL, BashTools: dbt, Shiny, Git/GitHub, Posit Connect, Streamlit, Flask, ExcelData Engineering: ETL pipelines, data modeling, APIs, Prefect/AirflowCloud & Warehousing: BigQuery, AWS (Redshift/S3, EC2), PostgreSQL, SQL ServerA/B Testing: experimental design (Hypothesis Testing)BI & Visualization: Power BI, Tableau, R ShinyML/AI: Scikit-learn, PyTorch, NLP - Sentiment analysis, Named Entity Recognition, TransformersSoft Skills: Stakeholder Engagement, Communication, Cross-functional Collaboration, Executive PresentationPortfolio Website: https://anudeepvanjavakam1.github.io/Github Profile: https://github.com/anudeepvanjavakam1Blog posts: https://medium.com/@anudeepvanjavakam
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.