Daniel Peña Reyes

Daniel Peña Reyes

About

Detail

Data Analyst | Python, SQL & Automation | Cutting manual work up to 80% for US remote teams
Bogotá, Bogota, Colombia

Contact Daniel regarding: 
work
Full-time jobs
Starting at USD4k/month
groups
Networking

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • Blossom
    Data Analyst
    Blossom
    Feb 2026 - Jul 2026 (6 months)
    • Flawless Core Digital Banking Migrations: Spearheaded complex database migrations between legacy systems and digital banking platforms. By executing rigorous QA checks and meticulous data reconciliation workflows, we achieved a 100% successful migration rate for critical financial databases with zero data loss. • Innovation in ETL Pre-Validation: To catch transformation errors before they hit production, I engineered a local interactive simulation environment using a JavaScript backend and frontend API. This proactive validation tool optimized execution and preparation time by 40%. • Cross-Functional Collaboration: Collaborated closely with technical teams to translate complex migration logic into reliable, scalable workflows. I also
  • NPHub
    Data Analyst public Remote experience
    NPHub
    Jul 2025 - Feb 2026 (8 months)
    • Custom AI Auditing (Saving 5h/week per analyst): I designed and iterated "Gemma"—an internal AI assistant powered by Gemini—to automatically audit and categorize lost deal reasons. This successfully replaced a highly tedious, manual review process and freed up significant time for our analytics team to focus on strategic insights. • Automated Email-to-Data RPA: I built a robotic process automation (RPA) tool using Google Apps Script that parses operational emails and writes structured records directly into Google Sheets. This completely removed manual copy-pasting, establishing a clean, standardized data stream for all downstream analysis. • API-Driven BI (Saving 30 mins/day per analyst): Instead of relying on manual exports, I develo
  • A
    Data Analyst
    Associated Medical Care
    Jun 2024 - Jul 2025 (1 year 2 months)
    Payment Automation: payment reconciliation and reducing processing Zoho Dashboard Management: data pipeline maintenance and dashboard development in Zoho Analytics, ensuring up-to-date, accurate reporting for business insights, which enhanced operational decision-making. End-to-End Database & ETL Implementation: Designed and implemented an Azure SQL Database from scratch, including: Extracting and transforming data from multiple Excel sources using Power Query. Creating and managing the SQL Server instance, defining constraints, and optimizing table structures. Configuring network access (IP whitelisting), logins, and user permissions to ensure secure collaboration. Managing the entire data lifecycle with SSMS and Visual Studio Code , signi
  • Pipecare Group
    Junior Data Analyst
    Pipecare Group
    Nov 2023 - Jun 2024 (8 months)
    •Utilize ArcGIS to create and maintain spatial data visualizations,effectively presenting key geospatial metrics that support strategicdecision-making across various departments•Proficient in using advanced PipeLab functions to organize, analyze,and interpret large datasets, improving geoprocessing efficiency•Develop and automate data processes using Excel macros, significantlyreducing manual data entry and enhancing report accuracy•Collaborate closely with cross-functional teams to identify data-drivenopportunities, ensuring alignment with business objectives throughinsightful analytics•Conduct regular data validation and cleanup procedures, ensuring theintegrity and accuracy of analytics outputs in Power BI and Excel