Jordy Ruiz
Charlotte,NC
Summary
Innovative Data Expert skilled in building and optimizing enterprise data solutions. Proficient in creating automated workflows, designing ETL pipelines, and developing dashboards that drive data-driven decision-making. Strong ability to partner with stakeholders to map processes and implement effective automation strategies.
Overview
1
1
Certification
8
8
years of professional experience
Work History
BI Developer II
Coca-Cola Consolidated
Charlotte, USA
08.2024 - Current
- Build enterprise data pipelines using Snowflake, optimizing SQL transformations for high-volume operational datasets.
- Developed automated reporting workflows using Python, delivering push-reporting scripts and scheduled delivery systems to enhance data accessibility.
- Create dashboards and data products in Tableau and Power BI to support Sales Operations, Delivery and Customer Connection Hub.
- Created an ETL Process for the In Market Execution Team in Python getting decisive data to support decision-making and streamline processes
- Partnered with business users to map processes and gather requirements, translating needs into scalable BI and automation solutions that support decision-making.
- Optimized existing SQL queries for better performance when running against large datasets.
- Analyzed large datasets to identify trends and support business decision-making.
- Implement validation rules, monitoring frameworks, and exception reporting to improve data quality and reliability.
Business Application Analyst
International Finance Bank
08.2022 - 08.2024
- Achieved $100K cost reduction by designing, testing, and deploying 15 automated business processes using JHA Enterprise Workflow.
- Created, maintained, and troubleshot over 50 automated SSRS reports, enhancing data accessibility for enterprise users.
- Developed Power BI dashboards that tracked productivity, software adoption, and ROI, supporting informed decision-making for workflow automation.
- Built ETL pipelines using SSIS, transforming and extracting large datasets for DevOps and business teams.
- Created complex SQL-based collateral tracking and budget reporting tools, integrating multiple data sources for automated insights.
- Executed SOAP API mass-maintenance updates using XML and JSON scripts for core banking systems.
- Conducted cross-department process analysis, identifying inefficiencies and proposing targeted automation solutions to improve operational effectiveness.
Investment Advisor
IFB Wealth Management
02.2022 - 08.2022
- Managed $50MM investment portfolio, optimizing returns for international clients.
- Provided retirement planning and asset allocation guidance, aligning client goals with investment strategies.
- Increased client acquisition by 5% in one quarter through strategic partnerships, enhancing business growth.
Relationship Banker
Wells Fargo
10.2018 - 02.2022
- Increased branch production and revenue by 2% through consistently meeting sales goals.
- Received the Wells Fargo Golden Spoke Award (2020) for exceptional customer service.
- Enhanced credit performance for three consecutive quarters by creating an Excel-based credit analysis model.
Education
Career Track Certification - Data Analysis
Springboard
02-2022
Bachelor of Science - Computer Information Technology
Florida International University
Miami, FL12-2020
Skills
- Data Engineering & BI
- Snowflake
- SQL
- ETL pipelines
- SSIS
- SSRS
- Python
- Tableau
- Power BI
- Workflow Automation
- JSON
- REST APIs
- Analytics & Reporting
- UiPath
- Stakeholder communication
Certification
- FINRA Series 7
- FINRA Series 66
- Security Industry Essentials
- FL-214 Insurance License
Community Leadership
- National Society of Leadership and Success — Inducted Member
- American Association of Notaries
- Full-Time Missionary, Church of Jesus Christ of Latter-Day Saints (Barranquilla, Colombia)
- Bishop – Church of Jesus Christ of Latter day saints (Park Crossing Ward - Charlotte South Area)
Timeline
BI Developer II
Coca-Cola Consolidated
08.2024 - Current
Business Application Analyst
International Finance Bank
08.2022 - 08.2024
Investment Advisor
IFB Wealth Management
02.2022 - 08.2022
Relationship Banker
Wells Fargo
10.2018 - 02.2022
Career Track Certification - Data Analysis
Springboard
Bachelor of Science - Computer Information Technology
Florida International University