Looking for a job

Jean Frago

@jeanfrago

Data Analyst at BAC Credomatic who automated reporting across 100 reports and built Power BI dashboards for customer behavior and forecasts.

Costa Rica

Message

At BAC Credomatic, I automated recurring reporting with Python and SQL Server, cutting manual preparation time by 25% across 100 reports. I also built Power BI dashboards using a star-schema model and DAX to track customer behavior, segmentation, and forecasts.

At McKinsey & Company, I designed and maintained Power BI dashboards for executive KPI tracking and analyzed transactional trends with SQL and Python in Databricks. My work reduced query runtime by 7%, and I partnered with stakeholders to translate performance gaps into analytical requirements.

At Emerson, I analyzed operational metrics, identified 10 systematic process gaps, and contributed to improvements that reduced error rate and turnaround time by 15%. I’ve also worked with CRM data at Foundever, and I hold a Systems Engineering degree from Universidad Fidélitas.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst I

Current

BAC Credomatic

Jun 2026 - Present (4 months)

Automated recurring reporting workflows with Python and SQL Server, cutting manual preparation time by 25% across 100 reports. Built Power BI dashboards on a star-schema model with DAX measures to track customer purchase behavior, segmentation, and forecasts for 1.2M business users.

Python Pandas SQL Server T SQL Power BI DAX Star Schemas Data Modeling ETL Data Validation Forecasting Segmentation

Software Licensing & Operational Performance Specialist

Emerson

Nov 2025 - Feb 2026 (3 months)

Audited operational datasets across global compliance-tracking applications, validating 20+ license records against enterprise data repositories. Ran variance and root-cause analyses on internal metrics, identifying 10 systematic process gaps and reducing error rate and turnaround time by 15%.

Data Auditing Variance Analysis Root Cause Analysis Process Improvement Stakeholder Management Documentation

Data Analytics Intern

McKinsey & Company

Nov 2024 - Nov 2025 (1 year)

Designed and maintained Power BI dashboards with complex DAX to track KPIs against targets for executive decision-making. Wrote optimized SQL and Python analyses in Databricks to explain transactional trends, risks, and opportunities, reducing query runtime by 7%.

Power BI DAX SQL Python Databricks KPI Reporting Agile Data Pipelines Stakeholder Management

CRM Systems Analyst

Foundever

Mar 2024 - Nov 2024 (8 months)

Analyzed high-volume transactional, customer, and billing data in enterprise CRM systems to detect behavioral patterns and optimization opportunities. Reconciled inconsistencies between legacy systems and performance reports, resolving 12+ data-integrity cases per week.

CRM Data Analysis Data Reconciliation Data Integrity Pattern Detection Optimization