Sergio A.
Business Intelligence Analyst
Compare at US rates $33,000/mo?
Notable Highlight
Built an enterprise HR Data Warehouse that reduced compensation reporting from 4 days to 8 hours. Now owns analytics for Meta's global supply chain partner onboarding at EPAM.
Experience Summary
Business Intelligence Analyst with 8+ years designing analytics solutions for logistics, supply chain, and HR operations. Expert in SQL, Power BI, Python, and data warehouse design. Automated reporting processes, built executive dashboards, and translated complex datasets into actionable insights across a previous company, a previous company, and EPAM/Meta.
Key Achievements
Reduced compensation reporting time from four business days to eight working hours through automation and analytical optimization at a previous company. Cut report preparation time by 50% at a previous company and reduced campaign reporting execution time by 50% at a previous company through process automation. Applied Six Sigma DMAIC methodology at a previous company to improve key customer experience KPIs-including AHT, ATT, NPS, and CSAT-by 20%. Delivered enterprise-scale analytics for global brands including Meta Platforms, Black & Decker USA, and Liberty Latin America.
Skills
Work Experience
Business Intelligence Analyst
ESCMP · Remote - Medellin, Colombia · Mar 2025 - Present
- Own and enhance analytics solutions supporting global supply chain partner onboarding and operational reporting.
- Develop KPI dashboards and executive reports to monitor vendor onboarding performance, operational efficiency, and integration progress.
- Collaborate with Product Managers, Engineering, Operations, and external vendors to gather business requirements and translate them into scalable analytical solutions.
- Define business requirements, process workflows, milestones, dependencies, and integration strategies for API, EDI, and manual data exchange solutions.
- Support executive business reviews through data-driven storytelling, performance summaries, and actionable insights.
- Ensure reporting accuracy by validating operational data and maintaining reporting governance standards.
- Produce technical documentation, process documentation, and user guidance supporting analytics adoption and continuous improvement initiatives.
- Manage integrations involving Purchase Orders, Forecasts, Inventory-on-Hand, Advanced Shipping Notices, and supplier operational data.
Sales Strategy & Field Ops Specialist
CS · Remote - United Kingdom · Nov 2024 - Jan 2025
- Design analytical solutions supporting sales pipeline optimization and forecast accuracy.
- Create Salesforce reports with customized filters to analyze sales performance and business trends.
- Extract Salesforce data to develop Power BI and Tableau dashboards for executive reporting.
- Automate recurring reporting processes, improving reporting consistency and operational visibility.
- Collaborate with Sales Operations and Revenue teams to identify reporting opportunities and improve business decision-making.
Data & Analytics Leader / HR Data Analyst
a previous company · Hybrid - Medellin, Colombia · Jan 2023 - Nov 2024
- Design and implement an enterprise HR Data Warehouse integrating multiple operational data sources.
- Reduce report preparation time by 50% by automating reporting processes and improving data accessibility.
- Reduce compensation reporting time from 4 business days to 8 working hours through automation and analytical optimization.
- Develop executive dashboards for the CEO, HR Vice President, Finance, and Operations covering workforce analytics, compensation, commissions, salary bands, turnover, organizational KPIs, and business performance.
- Analyze shipment information and Track & Trace pricing data to calculate operational commissions and validate logistics transactions.
- Build SQL-based analytical models supporting operational performance measurement and executive decision-making.
- Gather stakeholder requirements and document business needs through Business Requirements Documents (BRDs), including functional and non-functional requirements.
- Maintain reporting governance by validating operational data, improving data quality, and standardizing reporting definitions.
- Produce user documentation and reporting standards to improve dashboard adoption and reporting consistency.
Reporting Analyst / Reporting Specialist
a previous company · Remote - Medellin, Colombia · Jan 2018 - Jan 2023
- Progress from Reporting Analyst to Reporting Specialist while supporting international clients including Black & Decker USA, Liberty Latin America, Hospital San Ignacio, FLOW Guyana, and +Movil.
- Develop and maintain SQL-based data storage and reporting processes, ensuring database management best practices and reliable data availability.
- Create and automate daily and weekly reports in Excel, Power BI, and PowerPoint for executives, account leaders, and external clients.
- Optimize reporting for major campaigns, reducing execution time by 50% and improving visibility into operational and customer experience performance.
- Apply statistical analysis and Six Sigma DMAIC methodology to improve KPIs including AHT, ATT, NPS, and CSAT by 20%.
- Develop RLS-enabled Power BI reports to strengthen data security and restricted access for executives and high-level clients.