Alexander Castillo

About Alexander Castillo

Teva Pharmaceuticals relies on our expertise in Tableau Server administration and business intelligence to deliver actionable insights across Finance, Sales, Marketing, and Supply Chain. With over six years in this role, we ensure seamless server operations for 250+ users, manage deployments and upgrades, and implement disaster recovery systems. Our work enhances decision-making through optimized SQL queries, advanced dashboards, and automated reporting solutions tailored to key metrics like P&L by Customer and Promotions ROI. Previously, we facilitated a smooth transition from MicroStrategy to Tableau at Independent Purchasing Cooperative, ensuring data accuracy and operational readiness. By leveraging our proficiency in data visualization, ETL processes, and automation, we empower organizations to unlock the full potential of their data ecosystems, enabling strategic growth and operational excellence.

Experience

1. Senior Business Analytics - Tableau Administrator

   Teva Pharmaceuticals

   Oct 2018 — Present · Weston, FL, US

   Lead Tableau Server administration for 250+ users, managing deployments, upgrades, project permissions, backups, and disaster recovery.• Build advanced dashboards and automate reporting for Finance, Sales, Marketing, Supply Chain, and Logistics.• Developed Tableau workbooks from multiple data sources using Data Blending.• Created solutions for key metrics such as P&L by Customer, Promotions ROI, Rep Performance, Operations Volumes Metrics and Pricing Impact.• Developed PowerShell scripts to automate extract refreshes and trigger email alerts.• Optimized SQL queries and Tableau dashboards to enhance analytics performance and usability.• Supported cross-departmental reporting needs, ensuring consistency and clarity across KPIs.• Built Python scripts to transform raw data into structured datasets optimized for BI dashboards.• Designed and automated ETL workflows using Pentaho, integrated with Tableau through the Tableau REST API to publish and refresh dashboards programmatically.• Integrated Salesforce data for combined sales analytics.• Provide training and support to business users to create their own analysis (Tableau server and Desktop).• Global Tableau Support.

Skills

• Teamwork
• Team Management
• Tableau
• Cca
• Html
• Databases
• Crm
• Software Documentation
• Process Improvement
• Powerpoint
• Microsoft Excel
• Marketing
• Microsoft Office
• Sales
• Cross-Functional Team Leadership
• Leadership
• Callminer
• Networking
• Project Planning
• Vendor Management
• Research
• Access
• Numara Footprints
• Kpi Dashboards
• Training
• Scrum
• Information Technology
• Business Analysis
• Presentations
• Analytical Skills
• Data Analysis
• Contact Centers
• Business Intelligence
• Project Management
• Call Center
• Agile Methodologies
• Sql
• Visio
• Management
• Team Building