Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
SAIPRIYA MORAVANENI

SAIPRIYA MORAVANENI

Celina,TX

Summary

Results-driven Data Analyst with over 5 years of experience in analyzing and interpreting complex data to deliver actionable business insights. Proficient in SQL, Python, Excel, Tableau, and Power BI, with extensive expertise in statistical modeling, data visualization, and predictive analytics. Proven ability to identify trends, optimize operational processes, and support decision-making across cross-functional teams. Skilled in managing large datasets, utilizing advanced Excel functions (VLOOKUP, INDEX MATCH, etc.), and integrating diverse data sources into analytical tools and reporting systems. Experienced in developing and optimizing SQL queries (DDL & DML) for efficient data retrieval and manipulation from large-scale relational databases. Adept at integrating multiple data sources into platforms like Domo to provide strategic recommendations that align with business objectives.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Regions Financial Corporation
11.2023 - Current
  • Automated reporting workflows and optimized SQL scripts, improving reporting efficiency by over 30% and streamlining data processing across teams.
  • Conducted a detailed review of database objects, enhancing schema design and achieving a 20% improvement in query performance.
  • Designed and implemented dashboards in Tableau and Power BI, providing actionable insights to over 50 stakeholders, including senior leadership.
  • Improved data accuracy and retrieval speeds through advanced optimization techniques, including schema refinement and formula optimization.
  • Developed and maintained 100+ SQL queries and CI/CD pipelines, ensuring seamless integration between cloud-based and on-premise systems.
  • Partnered with cross-functional teams to translate business requirements into scalable technical solutions, enhancing data usability and decision-making processes.

Senior Data Analyst

Liberty Mutual
12.2022 - 10.2023
  • Conducted extensive data profiling and quality assessments, standardizing data from multiple sources and improving reliability by 40%.
  • Designed 20+ interactive dashboards in Google Data Studio and Looker to visualize KPIs and improve business insights for various departments.
  • Automated ETL workflows using Python and SSIS, reducing manual intervention by 50% and improving data pipeline efficiency.
  • Analyzed API datasets to identify trends and correlations, enabling a 15% improvement in data-driven business strategies.
  • Delivered 200+ advanced reports using tools like SSRS and PivotTables, providing insights into sales trends, customer behavior, and business performance.
  • Conducted post-migration testing to ensure data integrity and accuracy in new systems, resolving critical discrepancies promptly.

Data Analyst

Sun Pharmaceutical Industries Ltd
05.2021 - 07.2022
  • Designed and deployed ETL pipelines using SSIS, integrating data from over 10 sources to support business reporting needs.
  • Built Power BI models that consolidated CRM, ERP, and third-party data, enhancing forecasting accuracy by 20%.
  • Conducted CRUD analysis and optimized SQL queries to boost database performance for high-volume transactions.
  • Profiled and standardized legacy data, achieving a 99% accuracy rate and ensuring compliance with internal quality standards.
  • Led the creation of 15+ complex ETL workflows, reducing manual data preparation time for global teams.
  • Delivered advanced reporting solutions that enabled faster insights, reducing time-to-decision for executives by 30%.

Programmer Analyst

Jio Mart
03.2020 - 04.2021
  • Designed real-time dashboards in Tableau and Power BI, providing data-driven insights for inventory and sales management across 30+ business units.
  • Automated Excel-based reports using VBA, cutting reporting time by 40% and reducing manual errors.
  • Cleansed and standardized datasets, addressing 95% of data integrity issues within six months and improving data quality.
  • Developed SQL queries and stored procedures to streamline reporting processes and support analytics for high-volume datasets.
  • Created and maintained ETL packages using SSIS, integrating data from diverse sources such as flat files, SQL databases, and APIs.
  • Delivered actionable insights through Domo's scheduling features, supporting timely decision-making for regional managers.

Education

Master of Science - Information Science

The University of Texas At Dallas
Richardson, TX
05-2024

Bachelor of Science - Computer Engineering

Gayatri Vidya Parishad College Of Engineering
Vishakapatnam
07-2022

Skills

    Programming Languages: Python, R, SQL, PL/SQL, HTML, UNIX Shell Scripting, VB Script
    Integrated Development Environments (IDEs): Google Colab, Anaconda, Jupyter Notebook
    Data Analytics & Visualization Tools: Tableau, Power BI, Domo, Excel (Pivot Tables, VLOOKUP, INDEX MATCH, Advanced Functions)
    Libraries & Packages: NumPy, Pandas, Matplotlib, SciPy, Seaborn, Scikit-learn
    ETL Tools: SSIS, Informatica, Azure Data Factory, Data Stage, Talend, Data Profiling, Data Cleaning, Data Warehousing
    Databases: MySQL, SQL Server, Oracle, DB2, Teradata, NoSQL
    Cloud Platforms: AWS (S3, Redshift), Azure (Data Factory, SQL Database, Data Explorer)
    Data Engineering Tools: Snowflake, Apache Airflow, SAP, MS Visio, Erwin, Git, GitHub, Jira
    Machine Learning Techniques: Linear Regression, Logistic Regression, Random Forest, K-Means, XGBoost, Neural Networks
    Methodologies: SDLC, Agile, Scrum, CI/CD
    Big Data Tools: Azure Data Explorer, Power BI, Looker

Certification

  • Microsoft Certified power BI Data Analyst Associate
  • Microsoft Certified: Azure Data Fundamentals

Timeline

Senior Data Analyst

Regions Financial Corporation
11.2023 - Current

Senior Data Analyst

Liberty Mutual
12.2022 - 10.2023

Data Analyst

Sun Pharmaceutical Industries Ltd
05.2021 - 07.2022

Programmer Analyst

Jio Mart
03.2020 - 04.2021
  • Microsoft Certified power BI Data Analyst Associate
  • Microsoft Certified: Azure Data Fundamentals

Master of Science - Information Science

The University of Texas At Dallas

Bachelor of Science - Computer Engineering

Gayatri Vidya Parishad College Of Engineering
SAIPRIYA MORAVANENI