Ramya Sai

Summary

Experienced in data analysis, reporting, and governance.
Skilled in data cleaning, preprocessing and analytical techniques.
Proficient in SQL, Python, Pyspark and Power BI with a strong understanding of various data structures and governance principles.
Proficient in metadata management and data lineage tracking ensuring compliance with industry best practices.
Hands-on experience with Azure Cloud, Databricks, and advanced data structures, optimizing data storage and processing efficiency.
Experienced in managing intermediate-to-advanced analytical projects with minimal supervision while maintaining a strong focus on data quality, automation and process improvements.
Expertise in developing automated reporting solutions, reducing manual effort and improving reporting efficiency.
Skilled in conducting root cause analysis to troubleshoot data inconsistencies and optimize business processes.
Led cross-functional data stewardship initiatives to develop data dictionaries, metadata repositories, enhancing consistency across the organization.

Overview

years of professional experience

Work History

Data Analyst

IB Technologies LLC

08.2023 - Current

Collected, cleaned and analyzed large datasets to identify trends and patterns.
Assisted in creating reports and dashboards using Excel, Power BI and Tableau to present data insights.
Utilized Excel (Pivot Tables, VLOOKUP, Macros) for data cleaning and trend analysis.
Curated and analyzed customer and invoice data from multiple sources using Azure Data Factory and Azure Databricks, providing insights into customer orders and recommending optimized material pricing to the business.
Used SQL queries to retrieve, filter and manipulate data for ad-hoc analysis.
Implemented ETL processes to automate data pipeline workflows.
Cleaned and transformed raw data using Pandas and NumPy in Python to improve data accuracy.
Wrote basic to intermediate SQL queries to extract data from relational databases.
Performed data joins, aggregations, and filtering to generate reports.
Created interactive dashboards in Power BI/Tableau to visualize key business insights.
Translated complex datasets into easy-to-understand charts, graphs and tables.
Developed custom reports and KPIs to track business performance and improve operations.
Designed data driven presentations to support decision making.
Automated repetitive data entry and reporting tasks using Python scripts or Excel macros.
Effectively communicated data findings to non-technical stakeholders.
Collaborated with teams across marketing, finance and operations to provide analytical support.

Data Engineer

IBM

12.2018 - 05.2021

Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
.Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
Evaluated various tools, technologies, and best practices for potential adoption in the company''s data engineering processes.
Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
Established and secured enterprise-wide data analytics structures.
Utilized data visualization tools to effectively communicate business insights.
Improved decision-making processes with accurate data analysis and visualization techniques.
Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.
Facilitated cross-departmental data integration, enhancing overall data coherence and utility.
Increased efficiency in data storage and retrieval by implementing robust database management systems.
Improved data governance practices, ensuring compliance with regulatory standards and internal policies.
Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
Analyzed data to identify root causes of problems and recommend corrective actions.
Updated and developed scripts and queries to extract and analyze data from multiple sources.
Designed and developed data pipelines to acquire, clean and process data.
Developed and implemented data governance policies and procedures.

Education

Master of Science - Computer Informations Systems And Information Tech

University of Central Missouri

Warrensburg, MO

12-2023

Skills

Programming Languages: Python (NumPy, Pandas, Scikit-learn), SQL (MySQL, Oracle), Unix Shell Scripting
Big Data: Spark, PySpark, Spark SQL, Databricks, MySQL, MS-SQL SERVER

Reporting Tools/ ETL Tools: Informatica, Tableau, Power BI

Cloud Services: Azure (Event Hubs, Synapse, Data Factory)

Timeline

Data Analyst

IB Technologies LLC

08.2023 - Current

Data Engineer

IBM

12.2018 - 05.2021

Master of Science - Computer Informations Systems And Information Tech

University of Central Missouri

Ramya Sai

Summary

Overview

Work History

Data Analyst

Data Engineer

Education

Master of Science - Computer Informations Systems And Information Tech

Skills

Timeline

Data Analyst

Data Engineer

Master of Science - Computer Informations Systems And Information Tech

Similar Profiles

Vineeth GandhamuneniVineeth Gandhamuneni

Moliehi MafusingMoliehi Mafusing

LAUREN CAROLAUREN CARO

Manoj Singh RawatManoj Singh Rawat

Lenina MirzaLenina Mirza