Kevin Pineda
Analyst III
Salt Lake City,UT
Overview
13
13
years of professional experience
Work History
Analyst III
Zions Bancorporation
Salt Lake City, UT
01.2024 - Current
- Developed and maintained automation scripts using VBA and Python to enhance data validation, error detection, and reconciliation processes across financial systems.
- Leveraged intermediate SQL techniques (Joins, Subqueries, and CTEs) to extract complex datasets from relational databases.
- Utilized Advanced Excel (XLookup, VLookup, Pivot tables, etc.), Power Query, Excel-Python, and AI-assisted suggestions to build rapid analysis tools for quick detection of anomalies and system issues in multiple banking application financial data workflows.
- Developed and maintained automation scripts using VBA and Python to streamline data validation, error detection, and reconciliation processes across financial systems.
- Utilized advanced Excel (XLookup, VLookup, pivot tables, etc.), Power Query, Excel-Python, and AI-assisted suggestions to create rapid analysis tools for timely detection of anomalies and system issues in banking application financial data workflows.
- Performed in-depth data analysis to identify system-level errors and bugs, supporting proactive resolution efforts and continuous improvement of reporting processes.
Analyst II
Zions Bancorporation
Salt Lake City, UT
01.2024 - 01.2025
- Developed and maintained automation scripts using VBA and Python, streamlining data validation, error detection, and reconciliation processes in financial systems.
- Developed and maintained automation scripts using VBA and Python to streamline data validation, error detection, and reconciliation processes across financial systems.
- Leveraged intermediate SQL techniques (Joins, Subqueries, and CTEs) to extract complex datasets from relational databases.
- Utilized Advanced Excel (XLookup, VLookup, Pivot tables, etc.), Power Query, Excel-Python, and AI-assisted suggestions to build rapid analysis tools for quick detection of anomalies and system issues in multiple banking application financial data workflows.
- Utilized advanced Excel functions (XLookup, VLookup, pivot tables), Power Query, Excel-Python, and AI-assisted suggestions to build analysis tools for rapid detection of anomalies in banking application financial data workflows.
- Performed in-depth data analysis to identify system-level errors and bugs, enabling proactive resolution efforts and enhancing accuracy of reporting processes.
Business Technical Support
Verizon
West Valley City, UT
02.2019 - 09.2019
- Streamlined tier 2 support using advanced tools, enhancing resolution speed for varied business inquiries.
- Provided remote tech support for devices and systems, ensuring uninterrupted business operations.
- Took ownership of support tickets, minimizing reassignments and boosting customer satisfaction.
Financial Analyst (Active Duty)
Marine Corps Special Operations Command
Camp Lejeune, NC
02.2013 - 09.2017
- Standardized financial auditing benchmarks and best practices, enhancing consistency and reliability of financial reviews.
- Auditing led to the identification and correction of financial reporting inconsistencies.
- Thoroughly flagged and averted potential financial anomalies in the general ledger and financial statements.
- Delegated auditing tasks, ensuring timely completion of financial reviews despite tight deadlines.
- Supervised 3 junior analysts, mentoring them in daily financial operations and fostering a collaborative team environment.
Education
Master of Science - Data Analytics - Artificial Intelligence & ML
Colorado State University Global
Denver 05.2001 -
Bachelor of Science - Computer Science
University Of Maryland - Global Campus
Adelphi, MD12-2023
Associate of Science - Computer Science Emphasis
Salt Lake Community College
Salt Lake City, UT12-2021
Skills
- Advanced Microsoft Excel, Microsoft Office Apps
- Python (pandas, numpy, selenium)
- Automation & Scripting (VBA, Python)
- Data Visualization
- Data Presentation
- Advanced Microsoft Excel
Microsoft Office Apps
Excel proficiency
Timeline
Analyst III
Zions Bancorporation
01.2024 - Current
Analyst II
Zions Bancorporation
01.2024 - 01.2025
Business Technical Support
Verizon
02.2019 - 09.2019
Financial Analyst (Active Duty)
Marine Corps Special Operations Command
02.2013 - 09.2017
Master of Science - Data Analytics - Artificial Intelligence & ML
Colorado State University Global
05.2001 -
Bachelor of Science - Computer Science
University Of Maryland - Global Campus
Associate of Science - Computer Science Emphasis
Salt Lake Community College