Alexander Castillo

Sr. Business Intelligence Developer at Independent Purchasing Cooperative
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
US
Languages
  • English -
  • Spanish Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Marta Gilarranz

Alexander is a very talented professional with a high capacity to identify relevant data, see trends, investigate and suggest improvements. I could always count on him to meet deadlines and exceed expectations. His solid technical skills and willingness to take on any challenge together with his respect for colleags and ability to coach others made him a valuable team member.

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Bot Developer
    Automation Anywhere
    Oct, 2019
    - Nov, 2024

Experience

    • United States
    • Food and Beverage Services
    • 100 - 200 Employee
    • Sr. Business Intelligence Developer
      • Aug 2022 - Present

    • Israel
    • Pharmaceutical Manufacturing
    • 700 & Above Employee
    • Business Analytics III
      • Oct 2018 - Aug 2022

      • Perform installation, migration and upgrade of Tableau Servers and Desktops - Tableau Admin. • Monitor server activity/usage statistics to identify possible performance issues/enhancements • Maintain high Tableau reliability, advance analytics capabilities and improve internal customer experience • Change Management including software, patches etc. • Support migrating MicroStrategy reports to Tableau. • Perform day to day administration of Tableau Servers: o Manage sites and projects o Configure and manage project permissions o Provide reports on Tableau Server usage o Create/Manage workbooks, views, data sources and data connections o Manage backups and disaster recovery exercise • Works with the Analytic team to constantly monitor, tune and optimize performance (SQL Query & Dashboards) • Create a PowerShell scripts(Tableau API) to monitor the Daily and sensitive extracts refresh, execute triggers based on the result to Enable/Disable Tableau schedules and send alerts through email • Support to install Tableau Server Globally(Israel, North America) • Gathered user requirements, analyzed and designed software solution based on the requirements. • Involved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, structure and to maintain data efficiently. • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. • Developed Tableau workbooks from multiple data sources using Data Blending • Create scripts interacting with Tableau API to export subscriptions and send through email (csv and excel format) • Provide training and support to business users to create their own analysis (Tableau server and Desktop) • Build Pentaho scripts to automate process Show less

    • United States
    • Oil and Gas
    • 1 - 100 Employee
    • Sales System Manager
      • Nov 2016 - Nov 2018

      •Develop and analyze business objectives, producing reports from a variety of different data sources, and creating alternative solutions or proposing a course of action to process improvement measures. •Collaborate with key stakeholders through all locations to gather, analyze, design and streamline new processes, allowing objectives to be met within the parameters of the project schedule. •Integrate call centers in one platform, migrating 9 locations successfully and timely managing the rollout of each location and providing support with reporting, raw data files, developing dashboards and training agents and team leaders. •Produce various analytical reports writing SQL queries and creating tableau dashboards to support the executive team. •Gather, validate and analyze operational information using different data sources to improve business performance. •Support QA and integrated business processes through identifying call center and CallMiner strategy and system improvements, developing new metrics and in depth reporting to combine sales, call center and CallMiner data to measure campaign and agent performance for business analysis, decision making and training. •Support system integrations and process transitions through checks and data validation to maintain data integrity. •Configure and manage Oracle Contact Center Anywhere – CCA - 250 users •Create Standard Operating Procedures (SOP) for department and generate training documents for enterprise wide user reference. •Design, implement and streamline new and current processes respectively for multiple departments, creating flowcharts to document and communicate processes to project team. •Track system performance and measure against performance indicators. •Lead project teams, providing system and process training to on site and remote team members. Show less

    • Business Systems Analyst
      • Oct 2012 - Nov 2018

      • Generate Sales and Collections campaigns and evaluate their effectiveness in order to measure the performance and impact of marketing strategies. • Track sales performance and KPI's on a daily, weekly, and monthly basis by team, markets, etc, in order to analyze sales trends. • Gather, validate and analyze operational information using different data sources in order to improve business performance. • Design Sales Dashboard using the KPIs defined for team leaders • Identify training opportunities and propose actions to improve sales performance. • Develop queries and design reports using different data sources as CCA, NRA and FootPrints for Sales Team Leaders, Finance, Quality Assurance, Customer Service and Compliance departments in order to analyze and measure sales penetration, quality of service etc. • Produce various analytical reports using Excel, Tableau and SSRS. • Callminer(Voice Analytic tool) - Metadata creation to be used and build searches to identify potential compliance and/or sales coaching opportunities. • Provide support and training to users and team leaders. • Create sales and collections scripts. • Identify training opportunities to improve agent’s performance. • Prepare Policy and Standard Operating System SOPs • Configure and manage Oracle Contact Center Anywhere – CCA • Working Knowledge of Microsoft Office Suite, Visio, FootPrints, Bettermark Show less

    • United States
    • Business Consulting and Services
    • 1 - 100 Employee
    • Network Administrator
      • Sep 2011 - Oct 2012

    • United States
    • Pharmaceutical Manufacturing
    • 400 - 500 Employee
    • Business Analyst - Project Coordinator
      • Dec 2000 - Aug 2010

Education

  • Universidad Nueva Esparta

Community

You need to have a working account to view this content. Click here to join now