Carlos Sanabria

Experience

• 

  Universidad Cooperativa de Colombia

  Apr 2008 - Oct 2010

  Technical Support Manager

  As a professional specializing in computer maintenance, I excel in both preventive and corrective measures for hardware and software. With a keen eye for detail, I ensure the seamless functionality of computer systems, contributing to enhanced reliability and efficiency.

• 

  Analitica Ltda

  Oct 2010 - Sept 2012

  Senior Software and SQL Developer

  • Designed and optimised data models for Panama's accusatory penal system using data integration and reports in SQL Server supporting 500 end clients, Project value $1M dollars.• Desing entity-relation models and flexible data structures using Java to meet specific customer needs.• Executed process modeling with BPM diagrams using PHP, Java, and XML, achieving a 20% increase in workflow efficiency.• Led the development, and implementation of MySQL, Oracle, and SQL Server databases for process management systems and document management software.• Optimised database performance using indexing methods, reducing query response time by 25%. Show less

• 

  Dispapeles

  Sept 2012 - Oct 2015

  Database Management Specialist

  • Built reliable backup and system testing procedures for maintenance on backup servers reducing downtime to 1%.• Tested the integrity of the Document Management System database, achieving data accuracy of 99.5%• Optimized CRM software with ETL processes, reducing data processing time by 30% for improved system performance.

• 

  Ikono Tech S.A.

  Oct 2015 - Apr 2016

  Oracle Implementation Engineer

  • Led the Citrix data migration project for Scotiabank, achieving a 25% reduction in response time.• Developed data governance policies, optimising data management practices for enhanced efficiency and compliance.

• 

  Altipal S.A.

  May 2016 - Oct 2019

  Data Engineer

  • Data design supporting 3 departments: Sales, Finance and HR creating dashboards, migration, data integration supporting 1,500+ internal clients using Visual Studio, optimising ETL scripts.• Built complex data structures for a financial data warehouse using ETL processes and NoSQL to evaluate business profitability, identify risks and opportunities for business lines and creating recommendations to drive the company strategy. • Created a data warehouse defining sales commissions for vendors extracting data from Microsoft Dynamics with SSIS and TSQL increasing sales by 30% and increasing sales for low performance products: chocolates, imported beers, etc. • Optimised HR data workflows standardising and enhancing contracting processes, career development and training tools.• Used Apache Spark and predictive analytics to forecast sales trends to drive marketing campaigns improving sales by 45%.• Led data migration from an HRIS system to Microsoft Dynamics enterprise systems increasing efficiency and data integrity.• Managed a team of 6 data analysts, guiding them in tracking and analysing metrics across diverse areas of the company.• Used Azure Data Factory in Visual Studio for efficient ETL processes, advancing data mart development and contributing to the creation of 20 business reports. Show less

• 

  Oz Labourforce

  Oct 2021 - Jun 2023

  Data Analyst

  • Implemented a Data Warehouse using pipelines and optimising ETL process increasing productivity by 30%.• Re-designed supply chain inbound and outbound processes using data analytics, Python and Power BI reports to reduce container unloading/loading increasing revenue and profit by 25%.

• 

  Quayclean Australia Pty Ltd

  Jan 2023 - May 2024

  Data Analyst and Contract Supervisor

  • Manage business data in cleaning industry through Power BI and Dynamics 365 for informed decision-making on revenue, costs, profit, and client metrics.• As a contract supervisor lead team of 20 people, managing performance and delivering results

• 

  Link4 Cloud

  Jun 2024 - Sept 2024

  Web Development Intern

  • Developed and implemented REST API solutions for seamless integration of electronic invoicing between Link4 and Oracle Fusion, enhancing the efficiency, accuracy, and interoperability of financial transactions and operations.• Created and maintained Test Plans following IEEE 829 standards, ensuring thorough testing processes and high-quality software delivery.• Created and improved user manuals for end users, enhancing user experience and understanding of the systems.• Created software prototypes in Figma. Show less

• 

  Adelaide University

  Sept 2024 - now

  Information Technologist Corporate Administrator and Integration

  • Manage and install SSL certificates, using DigiCert as the certification authority to ensure secure and compliant system communication.• Perform seamless application integrations via RESTful APIs, optimising workflows and enhancing system interoperability.• Design, develop, and integrate automation solutions and applications using PowerShell and Azure services to improve operational efficiency and scalability.• Oversee application deployments through CI/CD pipelines in Azure DevOps, ensuring reliable and efficient software delivery processes.• Configure and manage ETL processes for effective data integration, enabling timely and accurate insights for decision-making. Show less