Daniel Peña Reyes
About
Detail
Cundinamarca, Colombia
Contact Daniel regarding:
work
Full-time jobs
Starting at
USD1.6k/month
Résumé
Jobs
verified_user
0% verified
- AData AnalystAssociated Medical CareJun 2024 - Current (2 years 1 month)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
Junior Data AnalystPipecare GroupNov 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- PTopographic EngineerPRISIGMay 2022 - Oct 2022 (6 months)• Conduct in-depth data analysis, utilizing advanced analytical tools and techniques to extract valuable insights from geographic data • Collaborate with cross-functional teams to ensure data accuracy and consistency in various topographic projects • Demonstrate a high level of attention to detail and accuracy in processing and interpreting topographic data • Deliver presentations and reports summarizing data findings to both technical and non-technical stakeholders • Achieved successful project outcomes by maintaining accurate documentation and meeting strict deadlines. • Wrote, reviewed and edited technical document in accordance with template requirements.