Jahnavi Angati Email & Phone Number

Frisco, Tx, Us

Florida, United States

- Utilized SQL to extract, transform, and load data from various sources into Redshift-based data warehouses, ensuring optimal storage and retrieval efficiency- Automated data processing tasks using GLUE ETL to streamline workflows, S3 events, and AWS Lambda functions, improving overall data processing speed and accuracy- Optimized SQL queries to enhance database performance and expedite data retrieval processes, contributing to faster decision-making and analysis- Leveraged Spark and Python to perform advanced data analysis, including data cleaning, transformation, and modelling, facilitating deeper insights and actionable recommendations- Executed AWS cloud migration projects, transferring historical data into the cloud environment and establishing automated processes for incoming data, ensuring scalability and accessibility- Conducted data pre-processing tasks to prepare raw data for analysis, including data cleaning, normalization, and transformation, ensuring data accuracy and consistency- Performed custom data extraction using SQL scripts, stored procedures, functions, views, and triggers, enabling tailored data retrieval based on specific project needs- Managed data extraction, transformation, and loading processes on AWS cloud platforms, utilizing AWS Glue, S3, and Lambda to automate data movement and processing tasks efficiently- Utilized Tableau to analyze data and generate insightful reports, enabling stakeholders to make data-driven decisions and identify actionable insights

Rajahmundry, Andhra Pradesh, India

- Content Strategy: Increased followers from 1K to 25K in 3 months by creating targeted, engaging content- Customer Insights: Analyzed engagement patterns to optimize content and boost interaction- Campaign Management: Ran successful campaigns to grow community engagement and drive sales.- Analytics Tools: Used Google Analytics and Instagram Insights to track performance and refine strategies

Austin, Texas, United States

- Examined and forecasted Texas electricity demand using SARIMA and Prophet models with up to 91.3% accuracy- Built XGBoost and CatBoost models to predict energy pricing, developing pricing strategies and risk management- Delivered insights optimizing energy use across $10M–$1B projects, reducing emissions and improving sustainability - Conducted comprehensive scenario analysis of energy pricing and supply strategies, enhancing client risk assessments

Austin, Texas, United States

- Managed university databases to ensure data accuracy, security, and reliability, gaining expertise in SQL Server, data governance, and database management- Boosted operational efficiency by 30% through Python scripts that automated key workflows- Developed and deployed Tableau dashboards for real-time monitoring of academic performance, student engagement, and resource allocation, in collaboration with academic and administrative departments- Created and enforced data governance standards and compliance procedures, promoting ethical data use and consistent data management practices across projects- Updated and maintained department websites, providing reliable and timely information for faculty and students

Hyderabad, Telangana, India

- Orchestrated AWS services for DISH’s 5G transformation, extending service coverage to over 20% of the U.S. population- Engineered a solution with Amazon Kinesis and Dynatrace, proactively reducing system downtime by 40%- Integrated Amazon Kinesis with AWS Lambda for real-time data streaming analytics, reducing data processing latency- Leveraged AWS S3 with Databricks, significantly increasing scalable data storage and ingestion speed by 15%- Improved decision-making by streamlining ETL processes with AWS Glue and Data Pipeline, reducing errors by 25%- Implemented training sessions on AWS data services for over 15 team members, increasing overall team productivity- Established exhaustive data quality checks and validation workflows in AWS Data Pipeline, reducing ETL errors by 15%- Automated data backup and recovery processes using AWS Backup, improving data security and compliance by 20%- Orchestrated complex ETL workflows using AWS Step Functions, reducing data processing time by 30%- Created interactive dashboards and reports using Amazon QuickSight, facilitating real-time data analytics and insights- Integrated Amazon CloudWatch and Logz.io for monitoring, developing custom alerts and dashboards, boosting systemreliability by 35%- Collaborated on the greenfield implementation of a 5G BSS transformation program while maintaining 100% master data accuracy by integrating records from Hansen Catalog into the product lifecycle database and setting up NPI (New Product Introduction) database for 2 new product cycles with the development team- Employed various AWS services such as EC2, S3, and ACM to bolster data infrastructure and strengthen security measures, and implemented Dynatrace for real-time monitoring and optimization of data processing workflows

Hyderabad, Telangana, India

- Utilized AWS tools (EC2, S3, Glue, Redshift, EMR, Spark, Databricks) to process and refine complex datasets, delivering actionable insights that improved organizational decision-making- Applied data science techniques like Logistic Regression, Linear Regression, and Time Series Analysis using Python(Pandas, NumPy) and Spark to solve complex data challenges and enhance data science workflows.- Streamlined database operations with SQL, integrated data seamlessly across platforms via AWS Glue, and maintained high data integrity and quality standards.- Leveraged SQL and NoSQL expertise with Amazon RDS and DynamoDB to optimize data operations and ensure robust data integrity.- Built interactive dashboards and visualizations with AWS QuickSight, Databricks notebooks, Power BI, and Tableau, empowering stakeholders with clear, insightful KPI tracking.- Applied Agile methodologies to manage data engineering projects effectively, including ETL/ELT pipeline creation, Docker container deployments, and CI/CD automation using Azure DevOps.- Improved data reliability and performance by conducting thorough data profiling, quality checks, and migrating enterprise data warehouses.

Gurgaon, India

- Experienced placement coordinator with a passion for connecting job seekers with their dream careers. - Skilled in job placement, career counselling, and program development, with a proven track record of success.- Committed to developing and maintaining relationships with employers and community organizations to create job opportunities for job seekers.

Hyderabad

Worked on a project called “Electronic Voting Machine” by using designing software called Xilinx ISE.It is designed to overcome the problems associated with the erstwhile practice of using ballot papers

Vishakhapatnam Area, India

Project on “Wagon Number Detection,” which includes data collection, data analysis, and data visualisationHelps the Traffic department to continuously monitor inward rakes which are entered in VSP, to achieve the timely production of steel with minimum demurrage.

Master Of Science - Ms, Business Analytics

Coursework: Advanced Machine Learning, Data Science Programming, Optimization(Linear, Non-Linear and Integer Programming), Information.

Bachelor Of Technology - Btech, Electronics And Communications Engineering

Activities and Societies: Member of Hostel and mess committee | Placement Coordination | Student Engagement | Performing arts | Student.

Intermediate, Mpc, 9.8

Highschool, 10