Gonzalo Troya
Citigroup
Jacksonville,FL
25
years of professional experience
Data analyst professional building Tableau dashboards, KPI reporting, and data-validation workflows that help leaders spot trends and act on findings. Supports cross-functional decisions by structuring large datasets, defining performance measures, and translating results into clear presentations for executives and clients. Uses SQL, Excel, and Access to improve reporting quality and streamline recurring analysis.
Work History
Senior Data Management Analyst
4 Years 5 Months- Processed 5 reporting requests monthly through governance intake to keep priorities, tracking, and delivery on schedule.
- Managed 6 Tableau dashboards weekly to support executive reporting, stakeholder updates, and publishing workflows.
- Developed executive dashboards and scorecards that turned complex data into actionable insight for senior leaders.
- Gathered, validated, and analyzed data from multiple database sources to surface trends, risks, issues, and opportunities.
- Automated daily, weekly, and monthly operational processes to reduce manual effort and improve reporting consistency.
- Built and administered an Audit database using SharePoint, MS Access, and SQL back-end support for Audit & Exams.
- Partnered with business managers and Risk, Compliance, Audit, and Third-Party Risk teams to resolve issues and support project execution.
Senior Data Analyst
11 Months- Tracked 3 executive dashboard updates weekly to support Western Hemisphere leaders with operational improvement discussions.
- Built 2 Tableau dashboards and presentations for internal teams and external clients, supporting account-level reporting needs.
- Collected, structured, and analyzed large datasets to surface business trends and actionable insights.
- Developed KPIs to measure business performance and assess the effectiveness of business decisions.
Data Analyst Consultant
11 Months- Investigated data discrepancies and resolved employee benefits and enrollment issues with third-party clients.
- Developed 2 management reports that supported executive visibility into operational performance and client data trends.
- Presented process recommendations and coordinated analytical work to keep deliverables on schedule.
Senior Strategic Reporting Analyst
7 Years 4 Months- Developed 5 dashboards and executive reporting for Business Unit Management and Enterprise Risk Management committees.
- Built and administered Issues Management and Fraud databases with SQL back ends and MS Access front ends.
- Modernized and consolidated 21 legacy reporting, eliminating redundant reports and improving operational efficiency.
- Developed data-validation routines, system testing processes, data extracts, and user training materials.
- Partnered with ERM, IT, Compliance, Internal Audit, Mortgage Servicing, and development teams to align business and technology requirements.
Senior Business Analyst
11 Years 3 Months- Led Financial Operations analyst teams automating and implementing MS Access databases after multiple acquisitions.
- Managed Bank One merger data conversion for the Claims organization, supporting record and account migration.
- Developed 5 project plans, schedules, and deliverables while tracking risks and issues across cross-functional teams.
Education
Bachelor of Arts - Business Administration and Management
Skills
Tableau
KPI & performance reporting
Business Objects
Reporting automation
SQL
Data governance
Data quality & validation
Oracle
SharePoint administration
Timeline
Senior Data Management Analyst
Citigroup
05.2022 - 10.2026Read More
Senior Data Analyst
CreditSafe
04.2021 - 03.2022Read More
Data Analyst Consultant
Allstate Insurance
04.2020 - 03.2021Read More
Senior Strategic Reporting Analyst
TIAA Bank
10.2012 - 02.2020Read More
Senior Business Analyst
JPMorgan Chase
07.2001 - 10.2012Read More
Universidad Central Del Ecuador
Bachelor of Arts from Business Administration and Management
Read More