Juan Ariel Rodriguez

Advanced Data Visualization

• Designed and delivered 50+ interactive dashboards using Tableau Desktop and Tableau Servertailored for Operations, Legal, and Executive teams to enhance understanding of retirement system metrics.
• Used Level of Detail (LOD) expressions, parameter controls, and custom calculations to build dynamic, drillable dashboards that reduced manual reporting by over 40%.
• Standardized dashboard layouts and KPIs across departments encourage daily traffic, usability, and executive reporting consistency.

Data Prep and Integration

• Used Tableau Prep and Power Query to clean, shape, and blend data from diverse sources, including various platform APIs, Web Data Connectors, SQL, JSON, OLAP cubes, and Excel-based legacy systems.
• Automated ETL processes and data model refreshes, eliminating redundant manual uploads and reducing error rates.
• Built reusable data schemas to accelerate dashboard development across multiple business units.
• Partnered with stakeholders and data consumers to define key metrics and provide ad hoc reporting solutions that supported policy decisions.

SQL & Analytical Problem Solving

• Wrote SQL queries to join and filter large datasets, supporting time-sensitive operations, internal controls, and pension analysis workflows.

Server Administration & Governance

• Acted as business-side liaison during Tableau Server upgrade, assisting in content migration, user testing, and performance tuning of key dashboards by improving data extract efficiency.
• Managed site and user permissions, content governance, and coordinated with IT for environment syncing.
• Scheduled and maintained subscriptions, and automated data refreshes on Tableau Server to ensure data reliability across departments.

Stakeholder Collaboration & Communication

• Helped shift the organization’s reporting mindset by developing tailored Tableau dashboards, providing user training, and partnering with teams to embed data visualization into daily operations.
• Acted as a liasion between IT and business with facilitated training sessions, workshops, and walkthroughs, empowering teams to use Tableau self-service tools and reduce dependence on static reporting.

Project Ownership & Mentorship

• Engaged in full SDLC for multiple dashboard initiatives, from gathering business requirements to delivery and maintenance.
• Mentored junior analysts on dashboard standards, documentation, and storytelling techniques.