Adam Luna

Data Analyst @Goldman Sachs Ayco

Dallas-Fort Worth, TX, US

Built a scalable data aggregation platform in Power Query to standardize datasets from multiple external banks, ensuring consistent schema across 15+ financial sources. Streamlined downstream analysis in Power Pivot, reducing manual processing time by 45% for 15 analysts. Automated complex data pipelines using Power Query and Excel, enabling fast-turnaround reporting and reducing formula-related inconsistencies in financial summaries. Created technical documentation for 10+ Power BI dashboards and workflows, cutting onboarding time by 40% and improving team knowledge transfer. Cleaned and validated large datasets using Python, SQL, and Excel; resolved 15+ critical data integrity issues and increased reporting accuracy by 30%. Collaborated with risk and finance teams to identify reporting bottlenecks, leveraging SQL-based insights to drive KPI improvement and operational efficiency. Led ongoing process optimization efforts by building reusable data models and dashboards, reducing redundant reporting tasks and improving decision support capabilities.

Navarro College

Associate's Degree, Applied Science

University of North Texas at Dallas

Bachelor's degree, Finance