YUKTHA THOTA

Data Analyst

New Jersey, USA.

About

Highly analytical Data Analyst with over 4 years of experience transforming complex datasets into actionable business insights across banking, financial services, hospitality, and consulting. Expertise in ETL optimization, data warehousing, and Power BI dashboard development drives operational efficiency and strategic decision-making. Proven ability to automate reporting, enhance data reliability, and deliver scalable analytics solutions that consistently support critical business objectives.

Work

US Bank

|

Data Analyst, Finance

VA, Virginia, US

→

Summary

Currently serves as a Data Analyst in Finance, leveraging advanced analytics to support enterprise reporting and optimize data-driven decision-making for banking operations.

Highlights

Analyzed and transformed large-scale banking datasets using SQL and Python, supporting enterprise reporting, risk analytics, and operational decision-making.

Optimized complex SQL queries and data extraction processes across multiple source systems, enhancing reporting performance and data accessibility.

Automated recurring reporting processes with Python, SQL, and Excel, significantly reducing manual effort and accelerating report delivery cycles.

Designed and developed interactive Power BI dashboards and KPI scorecards, enabling leadership to monitor portfolio performance, customer trends, and risk indicators.

Leveraged Azure Databricks and cloud-based analytics platforms to deliver scalable data processing, reporting automation, and enterprise visualization solutions.

MGM Resorts International

|

Data Analyst, Finance

MD, Maryland, US

→

Summary

Contributed as a Data Analyst in Finance, consolidating data and building analytical models to support financial reporting and strategic planning for hospitality operations.

Highlights

Engineered automated ETL workflows, reducing reporting latency by 35% and improving data availability and consistency for enterprise reporting and analytics.

Built forecasting models and scenario analyses to evaluate EBITDA movement and revenue performance, supporting budgeting and operational outcomes across business units.

Developed enterprise Power BI dashboards utilizing advanced DAX calculations and drill-through capabilities, providing leadership with actionable financial insights.

Automated manual reporting activities through Excel VBA, Pivot Tables, and advanced lookup functions, improving efficiency and reducing reconciliation effort.

Executed data validation, reconciliation, and root-cause investigations, strengthening confidence in financial metrics and improving overall data quality.

Deloitte

|

Data Analyst

Delhi, India, India

→

Summary

Supported fraud analytics and risk management initiatives by leveraging cloud-based platforms to analyze large-scale transactional datasets.

Highlights

Leveraged AWS S3, Redshift, and Athena to access, transform, and analyze large-scale transactional datasets for fraud analytics and risk management.

Developed analytical workflows using Python and SQL to identify anomalous transaction patterns, reducing false positives by 12% and improving fraud detection effectiveness.

Automated recurring reporting and analysis processes through Python scripting and Excel-based solutions, reducing manual effort and improving operational efficiency.

Built Tableau dashboards and KPI scorecards, enabling leadership to monitor fraud trends, operational performance, and key risk indicators.

Collaborated within Agile delivery teams, utilizing Jira and Confluence, to implement analytics enhancements and reporting solutions.

Education

George Mason University

Virginia, United States of America, United States of America
→
Master of Science Data Analytics Engineering

Languages

English

Skills

Analytics & Reporting

Power BI, Tableau, Looker, Advanced Microsoft Excel, Pivot Tables, VLOOKUP, VBA Macros, KPI Reporting, Executive Reporting, Dashboard Development, Data Visualization, Business Intelligence.

Programming & Querying

SQL, Python, R, SAS, PySpark.

Data Engineering & Databases

Azure Databricks, SQL Server, MySQL, Oracle Database, MongoDB, Cassandra, Data Warehousing.

Cloud & Big Data Technologies

AWS (S3, Redshift, Athena), Azure Databricks, Hadoop, Hive, Apache Spark, Snowflake.

Data Governance & Delivery

Data Governance, Data Lineage, Metadata Management, Data Stewardship, Data Validation, Data Quality Management, Regulatory Compliance, Agile, Scrum, Jira, Confluence, Production Support.

Statistical & Advanced Analytics

Forecasting, Predictive Analytics, Regression Analysis, Classification, Time-Series Analysis, Trend Analysis, Variance Analysis, A/B Testing, Random Forest, Support Vector Machine (SVM), Exploratory Data Analysis (EDA).

Projects

Alzheimer Disease Prediction

→

Summary

Explored and analyzed large-scale patient and genetic datasets to identify key indicators for Alzheimer's disease progression, developing predictive models and generating research-supporting visualizations.

Graphical Insights using Generative AI

→

Summary

Developed a Streamlit-based analytics platform integrating SQL databases and Large Language Models to automate data preparation, visualization, and insight generation.