Naga Chaithanya Rao S.

Data Analyst @Citi

NC, US

Automated financial data cleaning and transformation processes using SQL and SSIS, collaborating with the finance team. This led to a 20% reduction in reporting time and a 30% improvement in data accuracy for financial statements, streamlining the quarterly financial reporting process and reducing errors and manual effort. Utilized AWS infrastructure services (EC2, S3, Lambda, Redshift, QuickSight) to enhance data processing efficiency by 25%, working closely with IT and data engineering teams. This improved cost-effectiveness, and automated processes, and supported accelerated analytics and data-centric decision-making. Led a project to migrate legacy data systems to AWS, resulting in a annual cost savings, and significantly improved the scalability and flexibility of data management. Spearheaded the development and optimization of ETL pipelines using AWS Glue, collaborating with data engineers to process and transform multi-terabyte datasets by leveraging AWS S3 as a data lake solution. This reduced data processing times by 40%, enabling faster access to critical business data, which improved decision-making capabilities for the executive team. Designed data visualizations and reports to analyze financial performance in partnership with the business intelligence team. This identified cost-reduction opportunities that resulted in 10% savings and developed a comprehensive financial dashboard highlighting key metrics and trends for executive stakeholders. Developed data cleaning routines using Python and SQL, collaborating with data scientists to automate the cleaning process for large datasets. This improved data analysis efficiency by 35% and implemented a new data validation framework that boosted data accuracy by 30%. Enhanced the overall quality of data used in strategic planning and reporting.

University of North Carolina at Charlotte

Master's degree, Computer Science