Diego Ayala Email & Phone Number

Montreal, QC, CA

Montreal Quebec, Canada

Montreal, Quebec, Canada

• Analyze, design and conception of ETL solutions reliable, efficient, and stable for integration and migration to Data Mart/ Data Warehouse. - Design, develop and test technical solutions looking to reach the.
• Actively participated in the design, development, and implementation of an ETL solution for populating Data Vault 2.0 as part of receiving feedback from marketing campaign for Desjardins clients.
• Actively contributed to the analysis, development, and implementation of an ETL solution for producing targeted person lists for marketing campaigns towards Desjardins clients.
• Provided guidance on the adoption of Agile methodology within the team as a key participant in various ceremonies.
• Contributed to the design, development, and implementation of enhancements to an ETL solution by adding new features to adapt to the client's evolving needs.

Montreal, Quebec, Canada

• Understand technical and functional design requirements, propose avenues for improving applications, and reduce required efforts or technical debt.- Design, develop, and test technical solutions while aiming for.
• Actively participated in the code migration process from IBM Infosphere Warehouse to DataStage 11.5.
• Actively contributed to the continuous improvement process for the data integration and data management between the legacy SGA system database and the web application system CLIC database.
• Contributed to the design and development of a flexible data cleaning process in the web application CLIC database.
• Contributed to the design and development of data management for the continuous update of customer information to the call center based on Oracle's Golden Gate product.

Montreal, Canada Area

• Design and administer Hortonworks Data Flow (HDF) and Hortonworks Data Platform (HDP) platforms.- Analyze, design, and create data flows to receive information in HDF and send it to HDP.- Acquire and administer EC2.
• Actively participated in acquiring and administering EC2 servers on Amazon AWS, including their Docker configuration for deploying HDP and HDF sandboxes.
• Developed a simulation of an IoT device capable of sending real-time messages to the HDF platform using NIF.
• Developed a data flow in accordance with the Lambda architecture for real-time data processing, as well as storing them in HDFS.
• Implemented the Solr component in HDP for receiving and indexing messages to design a real-time dashboard in Banana.

Montreal, Quebec, Canada

• Design and create Data Marts for leveraging data to gain a better understanding of company processes.- Analyze, design, and create reliable, efficient, and stable ETL solutions for data integration and migration to.
• Participated in the design and conception project of the Data Mart for sales analysis and service order generation for Bell Canada. Integrated five different ordering systems into the same data model.
• Participated in the heterogeneous billing systems integration project for customer identification, aiming to provide a 360-degree view of customers.
• Contributed to the migration of inefficient ETL processes, applying best development practices methodology, successfully reducing its execution time from 12 hours to 2 hours.

Laval, Quebec

• Participate in identifying and analyzing the business needs of administrative departments (data sources, processes to model, key performance indicators, reports, and dashboards).- Analyze, design, develop and deliver.
• Participated in the imaging process modeling project by facilitating the identification of performance indicators and developing dashboards for the hospital management.

Montreal Quebec, Canada

• Design, maintain, and monitoring reliable, scalable, and cost-effective ETL solutions.- Create, maintain, and validate the integrity of the data warehouse.- Design, maintain, and monitor analytical cubes.- Be.
• Participated in the project to create cubes with their dimensions for modeling ITIL processes, facilitating the identification of behavior for each group using the IBM MAXIMO ticketing system at Bell.
• Actively collaborated in the administration of the OBIEE 10g server, utilizing data to design report groups and dashboards on modeled processes, enabling the client to analyze their information effectively.

Bogota, Colombia

• Design and development ETL’s and performance reports for the NLC Service (Never Lost Call), which handled more than 90 million messages per month.- Design and development ETL’s dashboard with theirs reports to identify.
• Participated in the project to create cubes with their dimensions for data utilization, facilitating the identification of call service consumption patterns for our client COMCEL in 2010.
• Actively collaborated on the migration and update project of the report server developed using Java technology. Utilized ETL concept to design the new version of reports, providing the client with better control over.
• Implemented and developed ETL solutions and elaborated reports for each requirement of the client COMCEL in a second phase of the migration project, between 2010 and 2012.

Bogota, Colombia

- Design and development to improve performance in the Client Applications - Be responsible for gathering and analyzing requirements to present solution to the client.- Be responsible for the proper execution of the solution in the production environment.- Identify, evaluate, and document operational changes to improve information system.

Master’S Degree, Master Of Science (Msc), Stratégie De L'Intelligence D'Affaires (Bi)

• Saisir, évaluer et critiquer les enjeux stratégiques et technologiques de la mise en œuvre d'une stratégie d'intelligence d'affaires.

Ingeniero De Sistemas, Tecnologia