Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
SRUTHI BIYYALA

SRUTHI BIYYALA

Coraopolis,PA

Summary

Seasoned Data Analyst with a proven track record at CGI, enhancing data consistency by 40% through advanced ETL, SQL, and Hadoop methodologies. Expert in leveraging Python for data analysis and AWS for scalability. Demonstrates strong analytical skills and a commitment to driving business intelligence through insightful data visualization in Power BI and Tableau.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

CGI
, India
04.2021 - 07.2023
  • Created and put into place comprehensive ETL procedures for master data management and data warehousing, increasing data consistency by 40% with the help of efficient data transportation infrastructures.
  • PL/SQL techniques were used to improve query performance by 30%, while Hadoop on cloud platforms was used to analyze huge datasets.
  • Fifteen percent better patient outcome monitoring was achieved by developing real-time dashboards in Power BI and Tableau, and honing data models in MySQL, PostgreSQL, and MongoDB.
  • Built ETL transformation layers using Spark, and used AWS components like EC2 and S3 for scalability, and used Python for data analysis, migration, and purification.
  • Achieved an 18% decrease in mistake rates with efficient data wrangling and dynamic reporting using DAX and Power Query in Power BI, as well as the integration of CRM data via Salesforce, and sophisticated analysis with SAS.

Data Analyst

Aplus Datalytics
, India
07.2020 - 03.2021
  • Developed and optimized data structures using initial SQL queries, enabling flexible and efficient chart development, predictive analysis, and large-scale data processing.
  • Designed interactive dashboards and KPI scorecards in Power BI, integrating data from SQL Server, Excel, and Analysis Services to create insightful visual reports for business intelligence.
  • Utilized Python for data manipulation, preparation, normalization, and predictive modeling, optimizing model accuracy and efficiency to enhance product performance.
  • Responsible for data services and data movement infrastructures, with good experience in ETL concepts, building ETL solutions, and data modeling.

MDM & Oracle SQL

01.2020 - 06.2020
  • Led Master Data Management (MDM) implementation using Informatica MDM Hub, optimizing customer master solutions, data consolidation, and operational independence across multiple platforms.
  • Developed and optimized SQL scripts and MDM components, including landing tables, staging tables, foreign-key relationships, cleanse functions, and match rules, improving data quality and performance.
  • Automated reporting and data exports, managed user access control, and designed trust rules for seamless data integration, governance, and stakeholder reporting.

Education

MS - Information Systems

Robert Morris University
USA
05.2025

Bachelors - Information Systems

JNTUH College of Engineering
India
06.2020

Skills

  • Python
  • SQL
  • Java
  • Agile
  • SDLC
  • Hadoop
  • Snowflake
  • NumPy
  • Pandas
  • Matplotlib
  • Tableau
  • Power BI
  • DAX
  • Power Query
  • Microsoft Suite
  • Excel
  • Informatica MDM
  • AWS
  • S3
  • Athena
  • Redshift
  • Azure
  • Google Cloud Platform
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • Oracle
  • Exploratory Data Analysis
  • Data Mapping

Certification

  • Programming in Python by NPTEL
  • Microsoft Azure AWS AZ-900

Timeline

Data Analyst

CGI
04.2021 - 07.2023

Data Analyst

Aplus Datalytics
07.2020 - 03.2021

MDM & Oracle SQL

01.2020 - 06.2020

MS - Information Systems

Robert Morris University

Bachelors - Information Systems

JNTUH College of Engineering

Similar Profiles

CREATE PROFILE
SRUTHI BIYYALA