Venkata Satya Sai Praneeth Pillarisetty

Assistant Data Analyst @Caltrans

Sacramento, CA, US
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Feb 2024 — Present

Assistant Data Analyst @Caltrans

View department →

Sacramento, CA, US

Compiled and processed engineering data into the HPMS database with high accuracy, ensuring alignment with federal requirements.• Validated data integrity and generated statistical and engineering reports, providing insights into roadway and traffic data.• Optimized existing SQL queries to improve data retrieval efficiency by 40%, ensuring faster access to critical information.• Collaborated with cross-functional teams to analyze trends in roadway performance data, contributing to strategic planning.• Automated repetitive data entry tasks using Python scripts, reducing manual efforts by 30%.• Provided actionable insights on roadway infrastructure projects through comprehensive data analysis and reporting.Tech Stack: Python, Excel, MySQL, PLSQL, Power BI.

EDUCATION

2022 — 2024

California State University-Sacramento

Master of Science - MS

2016 — 2020

R.V.R. & J.C. College of Engineering

Bachelor of Technology - BTech

ABOUT VENKATA SATYA SAI PRANEETH PILLARISETTY

I am a data and AI professional with three years of experience in data engineering, machine learning, and analytics. Currently, I work as a student assistant at the California Department of Transportation (Caltrans), and I previously served as a Senior Systems Engineer at Infosys for two years. My expertise lies in data engineering, analysis, and leveraging AI/ML frameworks to drive data-driven insights. At Infosys, I developed AI-powered data migration solutions using AWS services, designed robust ETL processes with tools like DataStage and Snowflake, and implemented predictive models for data validation. I optimized cloud-based pipelines and utilized machine learning algorithms for large-scale data matching, anomaly detection, and forecasting, significantly improving operational efficiency and accuracy. At Caltrans, I enhance data integrity by verifying and compiling engineering data into the FHWA\'s HPMS database while producing statistical and engineering reports. I also use machine learning techniques to analyze traffic and roadway performance data, improving forecasting accuracy and enabling data-driven infrastructure design. My technical expertise includes Python, SQL, PL/SQL, C, C++, and Java, with advanced proficiency in AI/ML frameworks such as PyTorch, TensorFlow, and Scikit-learn. I am skilled in BI platforms like Tableau and Power BI, and my experience spans relational and NoSQL databases. I am also adept at end-to-end data processing pipelines, cloud platforms, and SDLC principles. I am a Master’s Student in Computer Science at California State University, Sacramento, where I have further honed my skills in secure software design, machine learning, and data engineering. I aim to apply my technical expertise to Data Engineering, Machine Learning Engineering, or Data Analytics roles, driving innovative solutions to complex challenges.

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.