Anudeep Vanjavakam

Irvine, CA ***** 480-***-**** adv9y1@r.postjobfree.com linkedin.com/in/anudeepvanjavakam

Experience

****-******* ******* ****** ***** District Laguna Hills, CA

Senior Data Analyst (2019-Present)

●Created a suite of R shiny apps, dashboards and deployed them on website reducing customer enquiries on bills and rebates by 22% ; https://gram.mnwd.com/etmap/; https://gram.mnwd.com/billcalculator/; https://gram.mnwd.com/naturescaperebatecalculator/ ; https://gram.mnwd.com/ami_usage_trends_for_all_classes/

●Deployed multiple O&M and CIP financial reporting tools to provide insights into budgets, expenses, revenues, and cash flow trends to keep track of overall financial position; assisted with short and long-range financial planning reducing 40% of manual processes contributing to company’s AAA rating (Fitch, S&P) and GFOA award achievements

●Implemented an external party’s python-based anomaly detection model, integrating it with data from redshift and JDE using R scripts to proactively identify meter failures resulting in almost 3 months of early meter testing and replacement efforts

●Built a tool to evaluate program effectiveness of multiple rebate programs by comparing user’s behavior before and after participation helping change program criteria and driving targeted outreach resulting in significant cost savings

●Coordinated with IT to add database indices on SQL Server and managed performance tuning that resulted in 18% reduction in app load times and query processing times creating better user experience for staff (internal reporting) and customers (website apps)

●Contributed to the development of 'Rate Comparison Tool' using R to see implications that a new rate shift or a surcharge would have on overall revenue and analyzed bill impacts on a typical customer facilitating smooth rate structure transition and approval from the Board and public

Data Analyst (2016-2018)

●Developed an excel model to populate comprehensive annual financial report’s statistical section with minimum input reducing preparation time from 3 months to 2 weeks and contributed to achieving ‘Certificate of Achievement for Excellence in Financial Reporting’ GFOA award

●Created ‘Water Use and Efficiency Charts’ to track critical metrics such as water purchases, potable and recycled water use (breakdown by tier), customer efficiency and program participation trends, and funds spent on programs to aid data-driven policy decisions - https://gram.mnwd.com/monthlywaterusechartsautomated/

●Automated rate and bill check processes when executing new annual rates and flagged multiple bill presentation issues to ensure accurate billing in testing and production environments.

●Built a customer balance monitoring system that alerts staff when there is a mismatch between enterprise billing system and a payment processing vendor’s data ensuring accurate and reliable billing process

2013-2015 Wipro Ltd. Hyderabad, India

Project Engineer

●Managed data migration handling millions of business-related data records, enabling timely transition of data across multiple platforms – using SAP ABAP, LSMW, EMIGALL, MS-Excel

Education

2015-2016 Arizona State university – W.P.Carey School of business Tempe, AZ

Master of Science, Business Analytics (GPA 3.97/4.00)

2009-2013 Srm University Chennai, India

Bachelor of Technology, Major in Computer Science and Engineering (GPA 8.02/10.00)

Other

●Technical Skills: R, SQL, Data Analysis, Python, Machine Learning

●Certifications: Machine Learning – Standford University (Coursera), AWS ML Foundations – Udacity, AI Programming with Python Nanodegree - Udacity

Contact this candidate