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 performance and optimal structures according to the customer needs. - Identify and resolve failures in established processes and recommend solutions.- Improve operation efficiency of applications in regular bases.- Perform assigned task and inform the manager about the status of the project (stages, status, issues, risks and dependencies).Achievements: • 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 optimal performance and structures based on client needs.- Identify and resolve failures in established processes and recommend solutions, regularly improve operational efficiency of applications.- Design, develop, and test migrated functionalities in DataStage while striving for optimal performance and structures based on technical requirements.- Analyze and determine code migration strategies within an agile framework to design and achieve continuous deployment.- Execute assigned tasks and report project status to the manager (steps, statuses, issues, risks, dependencies).Achievements: • 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 Instance Servers on Amazon AWS.- Analyze, design, and create Big Data solutions for real-time data processing, as well as data storage in the HDFS system following the Lambda architecture.Achievements: • 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 Data Marts/Data Warehouses.- Analyze, design, create, and maintain Analytical Cubes (SAS OLAP).- Be responsible for the proper execution of ETL processes in the production environment.- Perform production deployments of ETL solutions, schemas, cubes, and data warehouse views.Achievements: • 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 reliable and scalable ETL data warehousing solutions for the needs of administrative departments.- Be responsible for gathering and analyzing requirements.- Analyze, design, and deliver analytical cubes (SSAS).- Develop, analyze, and deliver reports and dashboards for administrative departments (SSRS).- Perform production deployments of ETL solutions, schemas, cubes, dashboards, and reports.Achievements: • 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 responsible for gathering and analyzing requirements.- Analyze, design, and document KPIs and dashboards for the client.- Identify, evaluate, and document operational changes to improve information system processing.- Perform production deployments of ETL solutions, schemas, dashboards, and reports.Achievements: • 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 the behavior and availability of all the machines (servers, switches, routers) that belongs to the cell phone network.- Identify functional patterns on files delivered by the different platforms and use ETL concept to populate the database.- Documenting all the client’s requirements.- Testing and documentation of ETL’s processes.- PENTAHO Reporting Service Administration.- Pentaho Mondrian Implementation.- Creation of dashboards and data reports.Achievements: • 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 its services. For the client COMCEL, between January and June 2010.• 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 processing.Achievements:- Collaborated on the project to correct errors in .Net application development for the Davivienda client in 2008.- Actively participated in the implementation and deployment of modifications required by the Davivienda client in 2008 and 2009.- Contributed to the project integrating changes in production databases to facilitate integration between different banking applications for the Davivienda client in 2009.

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