PRANAVI JASTHI
+1-469-***-**** *****************@*****.*** LinkedIn Github
Summary
Data Engineering and Analytics professional with a strong foundation in data pipelines, ETL processes, cloud computing, and
dashboarding. Skilled in SQL, Python, AWS, and Power BI with experience building scalable and automated data workflows. Adept at
transforming raw data into actionable insights through analytical solutions, predictive modeling, and intuitive visualizations.
Passionate about data reliability, reporting automation, and empowering decision-makers through efficient engineering of data
systems.
Technical Skills
Programming: Python, SQL, R, DAX
Data Modeling & ETL: Snowflake, Databricks, BigQuery
Business Intelligence: Power BI, Tableau, Looker, Microsoft Excel
Cloud & Big Data: AWS, Hadoop, Spark, Kafka.
Database Systems: PostgreSQL, MySQL, MongoDB, Redshift, Database Applications
Scripting & Automation: Python (Pandas, NumPy, Matplotlib), JavaScript, Power Automate.
Predictive Modeling: Machine Learning, NLP, Forecasting, Statistics
Experience
Data Analyst July 2024 – Present
Verizon Dallas, TX
•Collaborated with cross-functional teams to ensure timely completion of projects, achieving a 95% on-time delivery rate.
•Engineered machine learning models for customer retention analysis, improving retention rates by 20%.
•Designed SQL-driven data validation, cleansing, and maintenance pipelines, ensuring high data accuracy.
•Developed ETL workflows for structured/unstructured data using Snowflake, PostgreSQL, and Google Cloud BigQuery.
•Automated communication reports using Python, reducing manual reconciliation efforts by 30%.
•Created interactive Microsoft PowerPoint and Power BI dashboards for executive decision-making.
•Built Google Cloud workflows for claims processing automation and implemented best practices for data governance.
•Mentored junior analysts and documented analytical methodologies for knowledge sharing and team development.
Data Analyst Aug 2020 - June 2022
PayPal Hyderabad, India
•Designed SQL-based applications to track discrepancies and ensure data integrity.
•Led cloud migration projects from S3 to GCP BigQuery, enhancing scalability and performance.
•Built dashboards in Power BI and Tableau to support business and academic initiatives.
•Developed automation tools using Python and scripting languages to streamline reporting and data maintenance.
•Designed and optimized ETL pipelines for financial data integration using SQL Server and Power BI semantic models.
•Migrated legacy reporting infrastructure to a modern SQL Server environment, reducing query time by 40%.
•Created paginated reports and interactive dashboards for high-level financial analysis.
•Proposed a unified data model to standardize KPIs across departments, improving reporting consistency.
•Partnered with IT and business teams to resolve data discrepancies and align reporting logic.
•Advocated architectural improvements that enhanced data governance and reporting efficiency.
Projects
Sentiment Analysis and Trend Detection in social media Python, Kafka, NLP, Machine learning, MongoDB
•Built analytical solutions for real-time data streaming with Kafka and MongoDB.
•Conducted complex analysis with Pyplot, detecting trends in stock market predictions.
•Applied NLP techniques (VADER, FinBERT) to extract insights from social media discussions.
Scalable Query System SQL, AWS Lambda, Docker
•Automated Designed a scalable query system for real-time data retrieval, improving response times by 30%.
•Built fault-tolerant architecture using AWS Lambda and Docker for seamless integration with existing systems.
•Streamlined data access processes to support analytical use cases across multiple departments.
Education
•University of North Texas Denton, TX
Master of Science in Computer and Information Sciences
•Vellore Institute of Technology Amaravati, India
Bachelor of Technology in Computer Science and Engineering
Certifications
•Microsoft Certified: Power BI Data Analyst Associate
•AWS Certified Data Analytics – Specialty