Hello, my name is
Venkata Sai Rishitha
And I'm a
LinkedIn →

About me

I'm Rishitha and I'm a

A dedicated Data Engineer and Data Analyst with 2.5 years of experience and a Master's degree in Data Science, skilled in designing and optimizing scalable data systems and pipelines. Proficient in tools and technologies like Python, SQL, AWS, Power BI, Tableau, Spark, and cloud computing, with expertise in ETL, data modeling, and business intelligence.

Adept at managing large-scale datasets and delivering actionable insights that drive data-driven decision-making. Successfully executed projects across industries such as healthcare, finance, and technology, improving operational efficiency and aligning data strategies with business goals. A collaborative professional with a proven ability to solve complex data challenges and deliver impactful results.

Download Resume

My Skills

Data Analytics and Visualization

Click to view details

Data Engineering Tools

Click to view details

Data Science and Machine Learning

Click to view details

Cloud Platforms

Click to view details

Programming Languages & Tools

Click to view details

Soft Skills

Click to view details

My Experience

AWS Cloud Data Engineer - Cognizant Technology Solutions

Chennai, India | Jul 2023 - Dec 2024

  • Enhanced data integration and governance for over 5 million records by designing and optimizing scalable data pipelines and ETL processes using AWS services (Lambda, Glue, S3, Athena, RDS).
  • Engineered robust data solutions using AWS Lambda functions to extract data from 4 diverse sources, transforming and loading it into AWS S3 for enhanced data availability and accessibility.
  • Implemented custom ETL processes using AWS GLUE, ensuring data integrity, consistency, and transformation, and optimizing data warehousing solutions using AWS Redshift.
  • Improved decision-making speed by 30% through actionable insights and visualizations provided via AWS Athena to analyze and query data.
  • Handled data volumes of up to 3TB by developing and maintaining data warehouses with AWS RDS and S3, ensuring scalable data storage and retrieval for analysis.

Data Engineer | Data Analyst - Cognizant Technology Solutions

Chennai, India | May 2021 - Jun 2022

  • Created 20+ interactive dashboards and reporting tools using Tableau and Power BI, reducing reporting lead time by 50%.
  • Spearheaded the migration of Python-based workflows to PySpark, cutting data processing time by 95% (from 20 hrs to 1 hr) for handling 120GB datasets.
  • Conducted in-depth data analysis and statistical modeling to provide insights into customer behavior, improving strategic decision-making by 25%.
  • Automated reporting processes with Power BI Paginated Reports, driving a 50% reduction in manual effort.
  • Built Python scripts to automate the report generation process, which reduced the report creation time by 80%.
  • Engineered scalable ETL jobs using Informatica and AWS Glue, streamlining data integration across multiple sources.
  • Defined and implemented data privacy and protection measures, ensuring compliance with data security regulations.
  • Applied machine learning techniques, including segmentation and lift modeling, to optimize reporting metrics and improve outcomes for customers and the business.
  • Proposed and implemented data-driven solutions to operational challenges, aligning with senior business and technology leadership goals.
  • Redesigned reporting metrics to enhance accuracy and scalability, contributing to a 30% improvement in business performance.
  • Presented data-driven findings to stakeholders in clear, actionable insights, facilitating informed decision-making and boosting strategic planning effectiveness by 25%.

My Projects

HR EXECUTIVE DASHBOARD

A comprehensive HR analytics dashboard built in Power BI, designed to streamline employee data analysis and enhance strategic HR decision-making. It offers a centralized view for both executive decision-making and individual-level analysis.


Features:

  • The report is organized into two primary views, tailored to meet both executive-level needs and detailed employee analysis:
  • ✅ HR Executive Overview Dashboard- A high-level view for HR leadership to monitor workforce health, hiring trends, and organizational structure.
  • ✅ Employee 360 View- A detailed, interactive profile for each employee, combining performance, engagement, and skill development insights

Tools/Language: Power BI, DAX, SQL, Excel, HR Data, Data Modeling, ETL

View Project →

COFFEE SALES DASHBOARD

Designed an interactive Coffee Sales Dashboard in Power BI to analyze US sales performance (2023-2024) across multiple dimensions, including time trends, customer demographics, and product performance.


Features:

  • Created interactive personal based visualizations for Executive team to give highlevel overview and deep dive into Customer and produsct purchasing behavior
  • ✅ Executive Dashboard- High-level KPIs, time-based sales trends, coffee type insights, and top-performing states
  • ✅ Product View- Sales by product category, daily patterns, city-level analysis, seasonal trends, and hourly performance
  • ✅ Customer View- Insights by gender, age, profession, payment method, and average order value

Tools/Language: Power BI, DAX, SQL, Excel, Sales Data, Data Modeling, ETL

View Project →

SUPER STORES SALES ANALYSIS DASHBOARD

Designed an interactive super store sales analysis dashboard that delivers actionable insights into sales performance, customer behavior, product trends, and regional sales patterns. The dashboard empowers businesses to make data-driven decisions and identify opportunities for growth.


Features:

  • Created interactive personal based visualizations for Executive team to give highlevel overview and deep dive into Customer and produsct purchasing behavior
  • ✅ Executive Dashboard- Offers a snapshot of overall business performance through key KPIs and high-level sales trends.
  • ✅ Customer View- Explores customer purchasing behavior, segmentation, and high-value customer identification.
  • ✅ Region View- Analyzes sales by region, highlighting top-performing areas and potential growth opportunities.
  • ✅ Product View- Sales by product category, daily patterns, city-level analysis, seasonal trends, and hourly performance

Tools/Language: Power BI, DAX, SQL, Excel, Sales Data, Data Modeling, ETL

View Project →

CAR SALES DASHBOARD

Designed an interactive Car Sales Dashboard in Power BI. This dashboard transforms complex datasets into clear, interactive insights, empowering businesses to refine their sales strategy, identify trends, and drive growth.


Features:

  • This Power BI dashboard is designed with multiple user personas in mind—from executives seeking high-level KPIs to analysts needing deep-dive insights.
  • ✅ Executive Dashboard- A strategic overview of key sales metrics, trends, and performance indicators
  • ✅ Sales Breakdown View- Detailed analytics by car model, manufacturer, color, and dealer.
  • ✅ Trend Analysis View- Time-based trends and seasonal patterns to support forecasting.
  • ✅ Geographical View- Sales performance across states and regions with interactive filters.

Tools/Language: Power BI, DAX, SQL, Excel, Sales Data, Data Modeling, ETL

View Project →

US HOUSEHOLD ENERGY PREDICTION

Developed and deployed an Ml Model to predict household energy consupmtion.This model provides valuable insights into energy consumption patterns, helping households and utilities optimize energy usage and reduce costs.


Features:

  • Developed a predictive model for U.S. household energy consumption trends, leveraging time series and regression techniques to enhance forecasting accuracy.
  • Built and deployed an interactive application with user-friendly visualization tools for energy usage insights.
  • Optimized model performance for real-world deployment, achieving robust results across multiple datasets.

Tools/Language: Python, Pandas, Regression Models, XGBoost, converters, Agents, LSTMs, streamlit, data processing

View Project →
AI Stock Adviser Project

GENE SEQUENCE CLASSIFICATION

Developed a machine learning-based system for Splice Junction gene sequence classification. This model helps in accelerate research in gene expression, mutation analysis, and drug development.


Features:

  • Contributed to the advancement of Splice Junction gene sequence classification through machine learning techniques.
  • Preprocessed gene sequence data to prepare it for machine learning algorithms.
  • Utilized Python, NumPy, Pandas, and Scikit-Learn for data preprocessing and model development.
  • Applied various machine learning algorithms to classify gene sequences.
  • Evaluated model performance using metrics such as accuracy, precision, recall, F1-score, and AUC-ROC.

Tools/Language: Python, NumPy, Pandas, Scikit-Learn, Biopython, Regex, TensorFlow, Matplotlib, Seaborn, Jupyter Notebooks,

View Project →
Custom Project

Contact me

Get in Touch

Thank you for taking the time to explore my portfolio. If you'd like to discuss opportunities, collaborate on projects, or simply connect, please feel free to reach out. I look forward to hearing from you!

Name
Venkata Sai Rishitha
Address
Baltimore, Maryland(US)
Email
mailtosairishitha@gmail.com
Message me