
Brian Castano Rendon
Verified Expert in Engineering
Power BI Developer
Medellín - Antioquia, Colombia
Toptal member since October 17, 2023
Brian is a Power BI professional with over seven years of experience in data analytics and business intelligence. He has worked for US companies and startups in the real estate, logistics, consulting, wholesale, retail, and manufacturing sectors. Brian specializes in improving teams' analytical capabilities and creating tools that streamline operations, reduce costs, and enhance company performance and profitability.
Portfolio
Experience
- Data Modeling - 7 years
- Power Query M - 7 years
- DAX - 7 years
- Microsoft Power BI - 7 years
- Power Query - 7 years
- SQL - 5 years
- Azure SQL - 5 years
- SQL Server Reporting Services (SSRS) - 5 years
Availability
Preferred Environment
Microsoft Power BI, SQL, Azure SQL, SQL Server Reporting Services (SSRS), Tableau, Qlik Sense, Git
The most amazing...
...thing I've developed was an analytical product that helped companies save millions by tracking inefficiencies across teams.
Work Experience
Senior Business Intelligence Analyst
J.S. Held
- Rebuilt several legacy reports into Power BI by adding extra layers of analysis and filtering capabilities, allowing the senior management to access different finance and business development areas in one place.
- Developed reports to track key business development metrics, such as customer acquisition cost, loan-to-value rates, retention rates, churn rates, and customer latency, directing the development of several marketing and business development efforts.
- Created several operational reports to monitor the most relevant performance metrics. The reports served as a management tool for directors and practice leaders, assisting them in making informed decisions on a daily basis.
Senior Data Analyst
Source Alliance Network
- Prepared expense reports for the central procurement department to track the expenses of various private equity portfolio companies. It gave the team a clear view of consolidation opportunities and unnecessary expenses.
- Developed savings reports to monitor savings achieved by the central procurement department for private equity portfolio companies.
- Created a main vendor report, allowing the central procurement department to view the vendors associated with the portfolio companies and assess their bids. It helped in evaluating potential consolidation opportunities.
Senior Business Intelligence Analyst
Accelate360
- Developed financial reports and a dashboard for senior management, providing them with a clear overview of the most pertinent financial data for their vast network of over 56,000 retail locations.
- Prepared a logistical report detailing the company's transactional information with 3rd-party logistical providers like UPS and FedEx. It identified inefficiencies in these partnerships and equipped operational teams with a tool to benchmark results.
- Created an operational report on merchandising activities across various locations within the retail network, allowing the operations manager to report on these activities and track the achieved results.
Head Data Analyst
Cargobot
- Established a new analytical team and built the main analytical architecture, integrating the work of data engineers, data analysts, and machine learning specialists.
- Developed all major reports and dashboards for every department within the company, including finance, operations, human resources, marketing, and sales. This equipped the department leaders with the necessary analytical tools for daily work.
- Created external company reports for senior management, the board, and potential investors. The reports covered metrics relevant to the company's strategic goals and internal operations.
Experience
Client Dashboard for Consulting Firm
https://drive.google.com/file/d/11sW-NLJqBB_2ZyI4hLRA9TSRLaoYJE0s/view?usp=sharing• Projects and revenue by client, country, region, practice, and contact in the current year compared to the previous year.
• Client interactions by contacts and agents.
• Geographical elements relevant to the client, agents, and projects.
• Retention rates and churn rates.
The data sources in this report originate from SQL databases in Azure, and the model used is a snowflake schema. Other metrics, such as time intelligence, financial, and relevant marketing indicators, can also be found.
Merchandising KPIs for Magazine Distribution Company
https://drive.google.com/file/d/11E2WSDcnUWDQQvppiqHU_XkSLBg58QOz/view?usp=sharing• Revenue and draw by store.
• Store efficiency, compliance, and visit metrics.
• Store-specific unit sales and associated timelines.
• Geographical elements pertinent to clients, agents, and visits.
The data sources referenced in this report are from an Excel file located in Azure Data Lake, and the model used is a traditional star schema. The measures developed for the report are primarily operational metrics and relevant marketing measurements.
Missed Visit Tracker for Distribution Company
https://drive.google.com/file/d/1vkPoiwxM8AJ-ItOSYUiiZIkOwvlAIJXW/view?usp=sharing• Scheduled and impulse visits categorized by chain, region, and country.
• Sales behavior in relation to visits.
• Geographical factors and timelines pertinent to these visits.
The data sources referenced in this report come from SQL databases hosted in Azure Synapse, and the model used is based on a snowflake schema. The report offers numerous user-friendly navigation items, including bookmark and drillthrough buttons, to enhance the user experience and facilitate the search for insights.
Revenue Analysis for Distribution Company
https://drive.google.com/file/d/1HybBubS9uCjWm5GuKVQ7cv3dk9gkmyu1/view?usp=sharing• Revenue for the current year compared to the previous year, broken down by week.
• Revenue for the current year compared to the previous year, categorized by retailer and chain.
• Actuals for the current year versus the budget, broken down by week.
• Actuals for the current year versus the budget, categorized by retailer and chain.
The data sources for this report are SQL databases in Azure Synapse, and the model in use employs a star schema. To enhance user experience, the report includes numerous navigation items, such as bookmarks and drillthrough buttons. These features allow users to independently search for the necessary information and draw their own conclusions.
Education
Bachelor's Degree in Humanities
University of Salamanca - Salamanca, Spain
Certifications
Mastering DAX Calculations in Power BI
Udemy
SQL - MySQL for Data Analytics and Business Intelligence
Udemy
MS Excel Exam Guide: Analyzing and Visualizing Data
Udemy
Qlik Sense for Data Science and BI
Udemy
Microsoft Certified: Data Analyst Associate with Power BI
Udemy
ZoomInfo Certification in Sales
ZoomInfo University
Creating Dashboards and Storytelling with Tableau
Coursera
Visual Analytics with Tableau
Coursera
Essential Design Principles for Tableau
Coursera
Fundamentals of Visualization with Tableau
Coursera
Skills
Tools
Microsoft Power BI, Power Query, Tableau, Qlik Sense, Git, Zoom, Power Pivot, Google Analytics, Google Sheets
Languages
Power Query M, SQL
Paradigms
Business Intelligence (BI), Database Design
Storage
SQL Server Reporting Services (SSRS), Databases, Azure SQL, Data Pipelines, MySQL, Microsoft SQL Server
Platforms
Azure Synapse
Other
Critical Analysis, DAX, Data Modeling, Data Visualization, Data Analysis, Descriptive Analysis, Statistical Data Analysis, Statistics, ETL Tools, Data Mining, Excel 365, Office 365, Data Analytics, Azure Data Lake, NetSuite, Dynamics CRM 365
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring