Luis Patricio Moreno Buitrón, Developer in Quito, Pichincha, Ecuador
Luis is available for hire
Hire Luis

Luis Patricio Moreno Buitrón

Verified Expert  in Engineering

Enterprise Architect and BI Developer

Location
Quito, Pichincha, Ecuador
Toptal Member Since
December 13, 2022

Patricio is an expert with Oracle, Microsoft, Red Hat, and other technologies, with over 20 years of IT management experience and 30+ certifications in different areas related to information and technology. Patricio has worked across domains, such as banking, insurance, retail, and education, and has taught specialized courses. Patricio has consulted in roles such as enterprise architect, multi-platform DBA, data engineer, and Power BI developer.

Portfolio

Universidad de las Américas
Oracle DBA, MySQL DBA, PostgreSQL, SQL Server DBA, NoSQL...
Boat Rocker Media Inc
Python, ETL, SQL, REST APIs, APIs, Linux, SSH, GitHub, Poetry, Containers...
L'Occitane - Main
SQL, Oracle DBA, Database Administration (DBA), Databases, ETL, Microsoft DBA...

Experience

Availability

Part-time

Preferred Environment

Enterprise Architecture, Business Intelligence (BI), IT Governance, Data Management, Data Engineering, Oracle DBA, Amazon Web Services (AWS), Linux, Python, Microsoft Power BI

The most amazing...

...project I've delivered was the creation and startup of the BI area of the largest bank in Ecuador.

Work Experience

Undergraduate Professor

2009 - PRESENT
Universidad de las Américas
  • Held Database Administration subject acting as a professor for the cybersecurity engineering degree.
  • Taught the subject of IT Management to undergraduate students.
  • Instructed students in classes in Data Analysis and Visualization.
Technologies: Oracle DBA, MySQL DBA, PostgreSQL, SQL Server DBA, NoSQL, Amazon Web Services (AWS), MongoDB Atlas, IT Management, IT Strategy, COBIT, ITIL, TOGAF, Information Security, Digital Transformation, Data Warehousing, Data Lakes, Databricks, Microsoft Power BI, Big Data, IT Governance, Microsoft SQL Server, APIs, REST APIs, GitHub, Apache Kafka, Containers

Python Developer

2024 - 2024
Boat Rocker Media Inc
  • Evaluated the architecture and code of the current integration solution that the client had implemented.
  • Developed the SQL statements to extract the data from the source system, based on the integration needs. Analyzed and tested the REST API of the target system.
  • Developed a PoC (using the same technological Stack) as part of the proposal for a new integration solution that is simpler, more efficient, more scalable, and easier to maintain over time, based on the integration needs.
Technologies: Python, ETL, SQL, REST APIs, APIs, Linux, SSH, GitHub, Poetry, Containers, Docker Compose, Microsoft SQL Server

Senior Database Administrator

2023 - 2023
L'Occitane - Main
  • Stabilized the operation of the main database platform, through the implementation of good configuration, operation, and monitoring practices for SQL Server databases.
  • Solved problems related to the execution of SSIS packages, as well as optimized the performance of some of them.
  • Attended to requirements related to the operation, security, and availability of the database platform, including not only SQL Server databases but also Oracle, MariaDB, and MySQL.
  • Responded to the audit requirements made by PwC staff on the administration and operation of the main database platform.
  • Actively participated in the definition and execution of the migration strategy of the first group of databases to the Microsoft cloud, using the Azure SQL services.
Technologies: SQL, Oracle DBA, Database Administration (DBA), Databases, ETL, Microsoft DBA, MySQL DBA, MariaDB, Azure SQL, Data Pipelines, Azure

MS Excel/VBA and Power BI Developer

2023 - 2023
Orlando Aguirre
  • Helped the customer identify the most appropriate analytical requirements for real-estate cost analysis.
  • Identified, analyzed, and understood the Excel sheets based on the analytical requirements previously defined, which will be the source data for real-estate cost analysis.
  • Designed and implemented the data model in MySQL for the new transactional database that will contain real estate cost information.
  • Designed a mockup with the preliminary version of the Power BI dashboard for the real-estate cost analysis.
Technologies: Data Engineering, Microsoft Excel, Reports, Dashboards, Excel VBA, Visual Basic for Applications (VBA), Microsoft Power BI, MySQL, Data Modeling, ETL

Data Engineer

2022 - 2023
Prodigy Education
  • Built and maintained the different data pipelines for extracting, loading, and transforming all the required data for business users and customers.
  • Executed the building and maintenance of different dbt models used by company analytical users.
  • Developed and maintained jobs to synchronize the content of some tables of the Data Lake located in Databricks with their respective tables in Snowflake.
  • Spearheaded the migration of some dbt models between the old Databricks production workspace and the new Databricks E2 workspace.
Technologies: Python, Apache Spark, PySpark, Databricks, Amazon Web Services (AWS), Apache Airflow, Snowflake, Data Build Tool (dbt), Datadog, Fivetran, Data Engineering, Data Lakes, Data Visualization, Reporting, APIs, Linux, ETL, SSH, REST APIs, GitHub, Amazon S3 (AWS S3), Data Pipelines, Spark

DBA Engineer

2022 - 2022
BanEcuador
  • Served as a database architect to define the deployment roadmap of the new MySQL 8 database platform.
  • Carried out the installation and configuration of its new database platform with MySQL Enterprise 8 as a DBA specialized in MySQL.
  • Migrated all databases from its infrastructure with MariaDB 5.5 to the new infrastructure with MySQL 8.
Technologies: MySQL Server, MySQL DBA, MariaDB, Database Architecture, Oracle Linux, Linux, SSH

IT Management Advisor

2019 - 2022
Pronaca
  • Served as an IT management advisor for the IT strategic planning of 2021 and 2022 and for the realization of a SWOT for the IT infrastructure of the company.
  • Acted as the enterprise architecture advisor focused on adopting this discipline.
  • Oversaw the migration and upgrade of Pronaca's data warehouse and, subsequently, its migration from its on-premise environment to a private cloud at a Century Link data center.
  • Performed health checks of the Oracle database of the company's ERP and acted as an expert DBA for SQL tuning.
  • Assisted with the implementation of standby databases on Cascade using Oracle Data Guard in the new infrastructure of the ERP INFOR LN and for the implementation of Oracle ASM and Oracle RMAN in this new infrastructure.
  • Implemented a local standby database for the second most critical database of the company, using Oracle Data Guard.
Technologies: Oracle DBA, Oracle Database, Oracle Database Architecture, Oracle RAC, Oracle Data Guard, Oracle RMAN, Oracle ASM, AIX, IT Strategy, TOGAF, Business Motivation Model (BMM), Business Model Canvas, COBIT, ITIL, IT Management, Oracle Cloud, IT Governance, Infor

DBA and Data Engineer

2021 - 2021
4Patriots
  • Created, managed, and monitored the databases located in AWS Cloud.
  • Managed the creation of the ETLs to consolidate the data needed for analytics and decision-making.
  • Built data pipelines using AWS services to make the necessary data available to the company's data scientists.
  • Developed a solution to identify and mask PII information stored in the company's databases.
  • Built a solution to collect, process, and visualize the performance data for the company's most critical databases.
Technologies: Amazon Web Services (AWS), Amazon RDS, Amazon Aurora, Document Databases, AWS Well-Architected Framework, Amazon S3 (AWS S3), AWS Glue, AWS Lambda, Python, Pandas, Data Engineering, Data Visualization, Reporting, APIs, Linux, ETL, SSH, REST APIs, GitHub, Amazon Kinesis, Amazon Simple Notification Service (Amazon SNS), Data Pipelines

Data Engineer

2021 - 2021
Pronaca
  • Identified the analytical specifications for the application performance Data Mart for application maintenance.
  • Designed the data repositories and ETL layer for the application performance Data Mart for application maintenance.
  • Implemented the ETL layer for the application performance Data Mart for application maintenance .
  • Documented and released into production the application performance Data Mart for application maintenance.
Technologies: RHEL, PostgreSQL, Python, Pandas, Data Engineering, Server Migration, Linux, ETL, SSH, GitHub

Multi-platform DBA

2021 - 2021
ARCERNNR
  • Performed a health check of the Oracle databases of the agency for the regulation and control of energy and non-renewable natural resources to define the roadmap to improve their architecture, deployment, and operation.
  • Completed a health check of the SQL Server and MySQL databases.
  • Completed a health check of the DB2 and PostgreSQL databases.
Technologies: Oracle Database, Azure SQL Databases, MySQL Server, IBM Db2, PostgreSQL, Linux, AIX, Microsoft SQL Server, SSH

Enterprise Architect

2021 - 2021
SERCOP
  • Assisted a team of business architects in designing the new business architecture of the official state procurement system of the company.
  • Formulated the business architecture of the official state procurement system, which included the roadmap for the systems' improvement.
  • Defined the specifications for the new data architecture of the official state procurement system.
Technologies: TOGAF, ArchiMate, ADOIT, DMBoK, Architecture

DBA Engineer

2020 - 2020
Invitation Homes
  • Executed a health check of the SQL Server databases in their production and UAT environments to establish a baseline for future improvements. Served as the SQL Server DBA on this project.
  • Defined a new and more complete backup and recovery strategy for their SQL Server databases based on best practices and vendor recommendations.
  • Deployed and managed a database monitoring solution for the SQL Server databases with IDERA products.
  • Outlined a new framework for the company's database administration (vision, governance, architecture, deployment, monitoring, and improvement).
  • Provided the necessary support in eventual issues related to the database platform.
Technologies: Azure SQL Databases, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), IDERA SQL Diagnostic Manager, IDERA SQL Safe Backup, IDERA SQL Query Tuner, IDERA SQL Workload Analysis, Windows, Microsoft SQL Server, SSH, GitHub, Azure

Cybersecurity Advisor

2020 - 2020
CPN
  • Strengthened the IT infrastructure of the CPN, focusing on fraud prevention as the cybersecurity advisor.
  • Defined a custom cybersecurity framework for CPN based on the NIST cybersecurity framework, ISO 27000, and COBIT 2019.
  • Assessed the current cybersecurity controls of CPN and defined a roadmap for improving them.
Technologies: NIST, Cybersecurity, ISO 27001, ISO 27002, COBIT

Database Engineer

2020 - 2020
IFTH
  • Served as a PostgreSQL and Db2 DBA for the health check of critical databases.
  • Performed the definition and execution of the improvement roadmap for the critical databases of the institution.
  • Executed the recovery procedures for some critical databases after suffering unavailability events.
Technologies: Platforms, Oracle DBA, PostgreSQL, IBM Db2, Database Architecture, Linux, SSH

Scrum Master and Database Expert

2020 - 2020
Registro Mercantil Quito
  • Improved the institution's data model by serving on the project as a scrum master.
  • Improved the institution's data model serving as their expert SQL Server DBA.
  • Led the technical team in consolidating information stored in MySQL and SQL Server databases into PostgreSQL.
Technologies: Scrum, Scrum Master, SQL Server DBA, PostgreSQL, MySQL Server, Server Migration, Windows

Associate IT Consultant

2019 - 2020
Business IT
  • Performed as a BI architect for a project in Color Republic to define its BI deployment architecture with SQL Server, SSIS, SSAS, SSRS, and DQS. As the data engineer, I designed the ETL layer's architecture for its new Data Warehouse.
  • Acted as an instructor for workshops about COBIT 2019 for customers.
  • Taught enterprise architecture in a TOGAF 9 workshop for the consulting staff of business IT in preparation for a project.
  • Provided performance tuning support for customers as the SQL Server DBA in charge of the project.
  • Developed a course on SQL database infrastructure for the IT staff of Universidad San Francisco de Quito.
Technologies: TOGAF, COBIT, Azure SQL Databases, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Quality, SQL, MDM, Business Intelligence (BI), IT Governance, Data Engineering, Microsoft SQL Server, ETL, SSH

Enterprise Architect

2018 - 2020
Bayteq CIA. LTDA.
  • Validated, for UTPL, the integration model of the new academic ERP with its legacy systems.
  • Assessed and proposed initiatives and projects to improve IT support for business needs as an enterprise architect.
  • Acted as a cloud and application architect to define road maps to improve the application management at UTPL.
Technologies: TOGAF, XML, JSON, REST, Talend ETL, Talend ESB, Talend Cloud Integration, NoSQL, PMBOK, DMBoK, Google Cloud Platform (GCP), Azure, Amazon Web Services (AWS), Oracle Cloud, Architecture, REST APIs

Associate IT Consultant

2018 - 2020
Businessmind Chile
  • Performed, for Empresas Banmedica, the migration of the Oracle databases of six clinics between data centers with minimum downtime and applying Oracle MAA.
  • Assessed the middleware platform of ENTEL SA, composed of Oracle WebLogic Server and Oracle Service Bus. I proposed initiatives and projects to improve it.
  • Instructed the technical team of the Chilean air force in Oracle WebLogic Server 11g administration essentials.
  • Managed a course on the adoption of SOA and architecture fundamentals for SODIMAC.
  • Provided several customers with specialized consulting on architecture and health checks for Oracle databases.
Technologies: Oracle Database, Oracle RAC, Oracle Data Guard, Oracle Cloud, Oracle Fusion Middleware, Oracle WebLogic Application Server, Oracle Service Bus (OSB), Enterprise Service Bus (ESB), Service-oriented Architecture (SOA), Server Migration, Linux, SSH, REST APIs

Associate Oracle Instructor

2017 - 2020
BesTechnology Group
  • Instructed the courses on the Oracle Database learning path taken for the team of developers of IESS.
  • Spearheaded the Oracle Linux 7 advanced administration course and the advanced SQL workshop for Fybeca.
  • Provided a workshop on WebLogic Server basic administration for PetroEcuador and virtual courses on Oracle Database 12c R2 administration for Banco de Machala.
  • Taught the courses Java EE 6 and web application development with JSF for Cancillería, and Oracle Solaris 11 system administration for Cooperativa Jardín Azuayo.
Technologies: Oracle Database, Oracle Solaris, Oracle Linux, Java EE, JSF, Linux

Oracle University Certified Instructor

2007 - 2020
Oracle University
  • Taught courses on all Oracle Database learning paths to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
  • Taught courses on all Oracle Fusion Middleware learning paths to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
  • Taught all courses on the Oracle Linux learning path to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
  • Taught all courses on the Oracle Solaris learning path to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
Technologies: Oracle Database, Oracle Fusion Middleware, Oracle Solaris, Oracle Linux, Linux, REST APIs

Associate IT Consultant

2019 - 2019
Xenturion IT
  • Performed as a certified instructor for Banco del Pacífico for a web application development workshop with Oracle JDeveloper.
  • Served as a certified instructor for Banco del Pacífico for a basic administration workshop of Red Hat Enterprise Linux 7.
  • Collaborated with the sales area of the company as a pre-sales consultant.
Technologies: Oracle WebLogic Application Server, Red Hat Linux, Linux, SSH

Database Engineer

2019 - 2019
Hospital Vozandes de Quito
  • Implemented a standby database with Oracle Data Guard 11g R2 for the current core of the Hospital Vozandes.
  • Installed a database cluster with oracle RAC for the new core of the hospital.
  • Provided a workshop for the DBAs team on the implemented infrastructure.
Technologies: Oracle Database, Oracle RAC, Oracle Data Guard, Server Migration, Linux, SSH

Enterprise Architect

2018 - 2019
RConsulting Group
  • Participated in the project “The Architecture Model of Information Systems and Technology Platforms and the Interoperability of Applications” at Coordinador Eléctrico Nacional of Chile as a business and application architect.
  • Contributed to the definition of the portfolio of initiatives and projects to implement the company's new architecture model of information systems and technology platforms.
  • Contributed to the definition of the new interoperability model for the company's applications.
Technologies: TOGAF, Application Lifecycle Management (ALM), Service-oriented Architecture (SOA), BABOK, Architecture

Enterprise Architect

2018 - 2019
Seguros del Pichincha
  • Defined the operational model and the organizational structure of the new IT department of Seguros del Pichincha.
  • Advised the company on the assessment of information management's current practices.
  • Defined the portfolio of initiatives and projects to improve information management in the company.
Technologies: DMBoK, Information Lifecycle Management (ILM), MDM, Business Intelligence (BI), COBIT, SFIA, IT Governance, Architecture

Associate IT Consultant

2018 - 2019
Conecta
  • Provided a WebLogic Server basic administration workshop for the IT staff of Universidad San Francisco de Quito.
  • Implemented a high-availability solution for Banco Pichincha with SQL Server failover clustering.
  • Acted as a SQL Server DBA for the migration and improvement of the database infrastructure of Seguros Pichincha.
Technologies: Oracle DBA, SQL Server DBA, Oracle Database, Oracle WebLogic Application Server, Oracle Fusion Middleware, Infrastructure, Oracle, Linux, SSH

Associate IT Consultant

2016 - 2019
Businessmind Corp
  • Provided advanced PL/SQL workshops for CNT and building composite applications with Oracle SOA Suite 12c for Banco Bolivariano.
  • Instructed Fybeca's DBAs team in Oracle Enterprise Manager Cloud Control.
  • Supported Banco Bolivariano with Oracle WebLogic and as an Oracle Service Bus architect.
  • Executed preventive maintenance on the Oracle RAC infrastructure installed at INDECOPI in Peru and implemented improvements to their Oracle WebLogic infrastructure.
  • Installed all the environments of the Oracle Service Bus platform at Banco Bolivariano.
  • Taught Java EE 6 web development with JAX-WS and JAX-RS, SOA adoption, and SOA architecture fundamentals at Banco del Pacífico.
  • Installed the quality and production environments for the web, integration, implementation, and reporting layers at La Positiva Perú, using Oracle Web Tier, Oracle WebLogic Server, and Oracle BI Publisher.
Technologies: Oracle Database, SQL, Oracle PL/SQL, Oracle WebLogic Application Server, Oracle Service Bus (OSB), Oracle RAC, Oracle Enterprise Manager (EM), Oracle BI Publisher, Oracle SOA Suite, ESB Architecture, Java EE, JAX-RS, JAX-WS, Service-oriented Architecture (SOA), Server Migration, Linux, ETL, SSH, REST APIs

Data Architecture and Database Management Specialist

2018 - 2018
Agencia Nacional de Tránsito
  • Defined the high-availability architecture of the agency databases and the policies for database security and administration.
  • Defined an action plan for the adoption of best practices for the management of database backups.
  • Diagnosed and defined the roadmap to improve the current situation of the core database.
Technologies: Oracle DBA, Oracle Database, Oracle RAC, Oracle WebLogic Application Server, TOGAF, Oracle Database Tuning, Oracle Database Architecture, Oracle Data Guard, Architecture, Server Migration, Linux, SSH

Enterprise Architect

2018 - 2018
ESOFT
  • Analyzed the management feasibility of the CENACE core systems to identify possible replacements or improvements.
  • Instructed the EMAP business and technical staff in TOGAF 9 fundamentals.
  • Acted as project manager for the project of surveying the processes of Cobiscorp’s Cobis operational model.
Technologies: TOGAF, Business Model Canvas, BABOK, PMBOK, Business Motivation Model (BMM), Architecture

Associate Oracle Consultant

2017 - 2018
IT Cabarique
  • Implemented the Oracle WebLogic 12c new platform at Banco D-Miro and provided them workshops on its deployment and management.
  • Implemented a new middle-layer platform for Almacenes Jaher using Oracle WebLogic 12c, Forms, and Reports.
  • Supported Telefónica Ecuador on the migration project of its billing core which was deployed in Oracle WebLogic, Oracle SOA Suite and Oracle Service Bus.
Technologies: Oracle WebLogic Application Server, WebLogic Diagnostic Framework (WLDF), WLST, Oracle Forms, Oracle Reports, Oracle SOA Suite, Oracle Service Bus (OSB), Linux, SSH

Associate IT Consultant

2017 - 2018
SeventeenMile S.A.
  • Oversaw the technical team in OpenKM deployment projects.
  • Migrated the DMS information stored in PostgreSQL to the OpenKM database in MySQL for the municipal company EMGIRS.
  • Created a Java-XML API to load DINARDAP's database content to the RMDMQ system, consuming a web service from a SQL Server database.
  • Deployed and administered the SQL Server, MySQL, and PostgreSQL databases in the OpenKM projects.
Technologies: Platforms, Oracle DBA, SQL Server 2016, PostgreSQL, MySQL Server, Java, XML, Web Services, OpenKM, Windows, Microsoft SQL Server, Linux

Database Security Specialist

2017 - 2017
Ministerio del Ambiente, Agua y Transición Ecológica
  • Identified the current vulnerabilities of SUIA's project databases.
  • Diagnosed vulnerabilities of SUIA's project databases, comparing them with the best practices and vendor recommendations.
  • Defined the portfolio of initiatives and projects to improve the security level of SUIA's project databases.
Technologies: PostgreSQL, TOGAF, Linux

Data Architecture Specialist

2017 - 2017
SENPLADES
  • Established strategies for the design, operation, monitoring, and platform security for the company's Oracle and PostgreSQL databases, utilizing enterprise architecture.
  • Defined a procedure to address the requirements of direct queries, the updates on the Oracle and PostgreSQL databases, and the policies for capacity management, configuration management, and requirements management for the databases.
  • Defined the Oracle 12c database and CentOS hardening standards for the company and a policy for the databases administration.
  • Formulated a proposal to improve the current design of data replication from SRI to SENPLADES.
  • Diagnosed the current deployment of Oracle Enterprise Manager Cloud Control and proposed recommendations.
  • Designed a periodic mechanism to collect their databases' processor, memory, disk, and network statistics.
  • Created and implemented pre-production environments for the databases.
  • Defined and executed the technical capacity generation plan for the company's database administrators.
  • Diagnosed the current audit status configured in the Oracle databases and proposed recommendations.
  • Developed instructions to enable the auditing of the databases.
Technologies: Platforms, Oracle DBA, PostgreSQL, Oracle Database, Oracle Enterprise Manager (EM), CentOS, TOGAF, Architecture, Linux, SSH

Associate Oracle Consultant

2017 - 2017
Eserv
  • Executed a health check on the Oracle WebLogic infrastructure of the port authority of Puerto Bolívar (APPB) at Machala Ecuador.
  • Provided a workshop on the new features of Oracle database 12c for the DBAs of Hospital Vozandes.
  • Delivered a workshop on the new features of Oracle database 12c for the DBAs of Diners Club.
Technologies: Oracle Database, Oracle WebLogic Application Server, Linux, SSH

Technical Consultant

2016 - 2017
Registro de la Propiedad del Distrito Metropolitano de Quito
  • Participated in the complete modernization of Registro de la Propiedad as the team's technical leader.
  • Prepared the technical deliverables for the modernization program.
  • Assessed the architecture of the real and personal folios registry system.
  • Defined and implemented a methodology for the tests.
  • Managed the team migration of legacy data from MySQL to SQL Server as the expert DBA overseeing the project.
Technologies: MySQL DBA, SQL Server DBA, SQL Server 2016, MySQL Server, Java, XML, TOGAF, Server Migration, Windows

Postgraduate Professor

2015 - 2017
Universidad de las Américas (UDLA)
  • Oversaw the Management of New Technologies course for a master's degree in IT management.
  • Served as director of the master's degree program in IT administration.
  • Assisted in evaluating the degree work of students for their master's degree in IT administration.
Technologies: IT Management, IT Governance, Enterprise Architecture, IT Service Management (ITSM), Data Management, Innovation, IT Project Management

Associate Oracle Consultant

2016 - 2016
Refundation Consulting Group
  • Provided Oracle Forms support to Hospital Metropolitano de Quito.
  • Offered Oracle PL/SQL support to Colegio Americano de Quito.
  • Gave technical and methodological support on Oracle Forms to Agencia de Regulación y Control de Hidrocarburos.
Technologies: Oracle Database, Oracle PL/SQL, Oracle Forms, Linux, SSH

IT Architecture Responsable

2012 - 2016
Banco Pichincha C.A.
  • Served as a product owner and enterprise architect. I was in charge of the information domain for adopting the enterprise architecture system at Banco Pichincha.
  • Formulated the enterprise architecture of Banco Pichincha with tools such as BMM, BABoK, and TOGAF.
  • Acted as a data architect for creating the BI Area of Banco Pichincha and managed one BI architect.
  • Participated in the selection of the provider of the new administrative-financial ERP and participated as an enterprise architect in implementing the ERP Oracle E-Business Suite (EBS).
  • Defined the guidelines for the management and use of information at Banco Pichincha.
  • Redesigned the data architecture for reporting solutions, managed the migration of ETLs and reports, and built them with SQL Server, SSIS, SSAS, and SSRS.
  • Defined the methodology for the selection and purchase of software.
  • Created a plan for using database products included in the first Oracle unlimited license agreement in Ecuador, signed between Banco Pichincha and the Oracle Corporation.
  • Oversaw the new architecture and consolidation of the Oracle and SQL Server databases of Banco Pichincha as an Oracle and SQL Server DBA.
  • Monitored and controlled the impact of the projects planned and executed on the bank's enterprise architecture.
Technologies: Oracle DBA, SQL Server DBA, SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL, Data Quality, Data Management, T-SQL (Transact-SQL), Oracle Database, Oracle EBS, XML, REST, Azure, SAS, IBM WebSphere, IBM InfoSphere, TOGAF, COBIT, ITIL, Scrum, PMBOK, DMBoK, BABOK, Business Motivation Model (BMM), Business Model Canvas, Business Intelligence (BI), Service-oriented Architecture (SOA), Oracle PL/SQL, IT Governance, Architecture, Server Migration, Windows, Microsoft SQL Server, Linux

Consulting Services Manager

2007 - 2012
BusinessMind S.A.
  • Managed the consulting services area and supervised almost 50 consultants.
  • Provided SOA, ESB, CEP, BPM, BI, and IT architecture expertise as a project manager, IT auditor, and enterprise architect.
  • Acted as a certified Oracle technologies expert, consultant, and instructor.
  • Developed and implemented the workflow of the QMS for an electricity distribution company.
  • Created and implemented the POC of the integration of databases via Oracle Enterprise Service Bus for a telecommunications company.
  • Implemented analytical solutions with SQL Server, SSIS, SSAS, SSRS, and DQS for several customers.
  • Acted as the principal consultant for SQL Server and MySQL database administration services.
Technologies: Oracle DBA, SQL, Oracle, Oracle Internet Directory (OID), Oracle Database, Oracle ADF, Oracle WebLogic Application Server, Oracle Enterprise Manager (EM), Oracle Fusion Middleware, Oracle Business Process Management (BPM), Oracle Designer, Oracle Discoverer, Oracle BI, Oracle EBS, Oracle JDeveloper 12c, Oracle Application Express (APEX), Oracle Data Integrator (ODI), Oracle Workflow, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Quality, T-SQL (Transact-SQL), MySQL, Java, XML, Quality Management Systems (QMS), Service-oriented Architecture (SOA), BPM, Complex Event Processing (CEP), Business Intelligence (BI), TOGAF, PMBOK, Cloud Computing, Oracle RAC, Oracle Data Guard, Oracle Database Tuning, Oracle Database Architecture, Oracle PL/SQL, Oracle Forms, Oracle Reports, Server Migration, BizTalk Server

Technical Trainer

2005 - 2010
Centro de Estudios para la Comunidad
  • Oversaw the learning path of Oracle databases.
  • Managed the learning path of applications development with Java.
  • Ran the learning path of Linux Fundamentals and Administration course.
Technologies: Oracle DBA, Java, Oracle PL/SQL, Linux, Linux Administration, SQL

Undergraduate Professor

2001 - 2008
Escuela Politécnica Nacional
  • Taught courses on databases.
  • Taught courses on database administration.
  • Taught courses on distributed databases.
Technologies: Databases

Oracle Consultant

2006 - 2006
Banco Interamericano de Desarrollo
  • Developed the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
  • Installed all the infrastructure required to implement the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
  • Implemented the requested improvements to the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
Technologies: Oracle Database, Oracle ADF, Oracle JDeveloper 12c, Oracle PL/SQL, Java

Oracle Consultant

1999 - 2006
Kruger Corporation
  • Served as an Oracle engineer and DBA on more than 30 projects.
  • Developed the purchasing workflow for a TV company.
  • Managed the tax management workflow for a customer.
  • Acted as an IT auditor, solutions architect, and project manager.
  • Created the data warehouse for the taxpayer information collection.
  • Customized and implemented one of the first management information data marts in Ecuador.
  • Developed and implemented the payroll, asset management, accounting, and bank systems for several clients.
Technologies: Oracle Database, Oracle ADF, Oracle Forms, Oracle Reports, Oracle Designer, Oracle Discoverer, Oracle Workflow, Oracle Application Server, SQL, Oracle PL/SQL, Business Intelligence (BI), Oracle DBA, Server Migration

Oracle Consultant

1997 - 1999
Gestor Inc.
  • Implemented the following modules to the company's trust management system general accounting system: Contract management for trusts, property management for trusts, and management of guarantees for trusts.
  • Provided Oracle engineering, Oracle DBA, and project leadership services.
  • Supervised five consultants in projects for the most important banks in Ecuador.
Technologies: SQL, Oracle PL/SQL, Oracle Database, Oracle Forms, Oracle Reports, Oracle Designer, Oracle DBA

Oracle Instructor

1997 - 1998
Oracle Ecuador
  • Performed as an Oracle instructor for Oracle SQL courses.
  • Acted as an Oracle instructor for Oracle PL/SQL courses.
  • Served as an Oracle instructor for Oracle Database courses.
Technologies: Oracle PL/SQL, Oracle Database, SQL

Oracle Engineer

1996 - 1997
ISSFA
  • Analyzed the process modeling and database design of an air force hospital's admission and billing system.
  • Developed and implemented ISSFA's reserve fund, integrated payroll, human resources, and health insurance systems.
  • Served as an Oracle engineer, Oracle DBA, data analyst, and intranet administrator.
Technologies: SQL, Oracle Database, Oracle Forms, Oracle Reports, Oracle Designer, Oracle DBA, Oracle PL/SQL

Implementation of BI for a Bank

I was the data architect for a large bank and acted as the counterpart of the international consultant for the creation and startup of the BI unit in that financial institution. I was in charge of the implementation of the IBM data model for financial data warehouses, the definition of the bank's BI architecture, the establishment of the operating model of the BI unit, and the definition of the catalog of BI services that would be offered to the business areas of the bank.

Design of Enterprise Architecture of a Large Public Procurement System

I was part of the team of enterprise architects who generated a model that conceptually and technically supports the implementation of the client's transformation strategy in terms of business and technology.

The project's specific objectives were to:
-Identify improvements at the level of business processes, governance, information systems, procedures, and current regulations, which must be considered for a new implementation of the applications that support the company.
-Define the new data architecture with which information management can be improved.
-Identify the new architectural plan of the applications that support the company and from which the transition strategies of the current applications can be defined.
-Define a new deployment architecture for applications in accordance with the technological infrastructure of the client.
-Identify the current and future situation of the architecture, determine the gap, and establish the respective roadmap.

Data Mart APM

A Data Mart and ETL solution for the consolidation of data about application monitoring taken from the APM tool database of a company. The solution encompasses four components: Extraction, transformation, load, and utility components.

Data Masking Solution

An application to mask the data of the databases of a USA company according to the PII regulation. The application has two components: A programmatic component to execute a PII scanning of the databases to detect PII data and a programmatic component to complete the masking of the PII data detected.

Database Performance Monitor Framework

A solution framework to obtain metrics about the performance of the AWS Autora database instances and generate performance reports. The framework has the following component: A repository for the collected metrics, a component to connect to the database instances to collect the metrics defined, a component to generate the diagnostics based on the variations of the metrics collected, and a component that will generate performance reports.

Migration with Minimal Downtime of Critical Databases

Oracle database migration between data centers and six clinics that are part of a healthcare and insurance company. The databases in question are classified as critical, so the defined migration strategy was based on Oracle MAA. It was oriented to minimize downtime, with which it was possible to migrate each database in an average time of 15 minutes.
2011 - 2014

Master’s Degree in Systems Management and Information Technologies in Information Technologies

Universidad de las Américas - Quito, Ecuador

1991 - 1999

Bachelor’s Degree in Systems Engineering in Systems Engineering

Escuela Politécnica Nacional - Quito, Ecuador

SEPTEMBER 2022 - PRESENT

The Data Bootcamp: Transform your Data using dbt™

Udemy

AUGUST 2022 - PRESENT

Data Engineering using Databricks on AWS and Azure

Udemy

AUGUST 2022 - PRESENT

Learn DBT from Scratch

Udemy

AUGUST 2022 - PRESENT

Data Warehouse: The Ultimate Guide

Udemy

JULY 2022 - PRESENT

Apache Airflow: A Real-time & Hands-on Course on Airflow

Udemy

JULY 2022 - PRESENT

Snowflake Cloud Data Warehousing Basics to Advanced Concepts

Udemy

JULY 2022 - PRESENT

Databricks and Apache Spark for Big Data: From Zero to Expert

Udemy

JUNE 2022 - PRESENT

Big Data for Managers

Udemy

JUNE 2022 - PRESENT

Executive Briefing: Big Data and the Hadoop Ecosystem

Udemy

JUNE 2022 - PRESENT

The Complete SQL Bootcamp 2022: Go from Zero to Hero

Udemy

JUNE 2022 - PRESENT

Big Data with Apache Spark 3 and Python: From Zero to Expert

Udemy

JUNE 2022 - PRESENT

Agile Fundamentals Including Scrum and Kanban

Udemy

MAY 2022 - PRESENT

Git for Geeks: Quick Git Training for Developers

Udemy

MAY 2022 - PRESENT

Power BI & Business Intelligence 2022

Udemy

APRIL 2022 - PRESENT

Linux for Cloud & DevOps Engineers

Udemy

MARCH 2022 - PRESENT

The Data Analyst Course: Complete Data Analyst Bootcamp 2022

Udemy

MARCH 2022 - PRESENT

Docker Crash Course for Busy DevOps and Developers

Udemy

FEBRUARY 2022 - PRESENT

AWS Cloud Practitioner Training

Amazon Web Services

FEBRUARY 2022 - PRESENT

DevOps and CI/CD (Continuous Integration and Delivery) for Beginners

Udemy

FEBRUARY 2022 - PRESENT

The DevOps Essentials: The Handbook

Udemy

JANUARY 2022 - PRESENT

Google Cloud Platform (GCP) Fundamentals for Beginners

Udemy

APRIL 2020 - PRESENT

Oracle Certified Associate

Oracle

SEPTEMBER 2019 - PRESENT

Certified Scrum Master

Asociación Iberoamericana de Scrum

FEBRUARY 2017 - PRESENT

Microsoft Certified Professional

Microsoft

NOVEMBER 2015 - PRESENT

COBIT Foundation

APMG International

JULY 2015 - PRESENT

Oracle Certified Professional

Oracle

MARCH 2015 - PRESENT

Oracle Certified Associate

Oracle

DECEMBER 2014 - PRESENT

ITIL Foundation

Axelos

JULY 2013 - PRESENT

TOGAF 9 Certified

The Open Group

APRIL 2010 - PRESENT

Oracle PL/SQL Developer Certified Associate

Oracle

Libraries/APIs

Pandas, REST APIs, JAX-RS, JAX-WS, PySpark, Spark ML, Spark Streaming, NumPy

Tools

Oracle Forms, Oracle Reports, Oracle Designer, Oracle Workflow, Oracle JDeveloper 12c, Oracle RAC, Oracle Business Process Management (BPM), Oracle BI Publisher, Oracle SOA Suite, WLST, ArchiMate, GitHub, Oracle Internet Directory (OID), Oracle Application Express (APEX), MongoDB Atlas, Microsoft Power BI, Talend ETL, AWS Glue, Apache Airflow, Docker Swarm, Docker Compose, Docker Hub, Git, Bitbucket, Spark SQL, Microsoft Excel, Amazon Simple Notification Service (Amazon SNS)

Frameworks

TOGAF, COBIT, COBIT 5, Oracle ADF, JSF, AWS Well-Architected Framework, Apache Spark, Jinja, Spark Structured Streaming, Spark

Paradigms

Oracle Database Architecture, ETL, Scrum, Business Intelligence (BI), Service-oriented Architecture (SOA), ITIL, REST, Application Lifecycle Management (ALM), PMBOK, DevOps, Agile, Kanban, Dimensional Modeling, Continuous Integration (CI), Continuous Delivery (CD)

Languages

Python, SQL, T-SQL (Transact-SQL), Java, XML, SAS, Snowflake, Excel VBA, Visual Basic for Applications (VBA)

Platforms

Oracle, Linux, Oracle Database, Oracle Enterprise Manager (EM), Oracle Linux, CentOS, Red Hat Linux, Amazon Web Services (AWS), Oracle Data Integrator (ODI), Windows, Oracle Application Server, Databricks, Azure, IBM WebSphere, Java EE, Google Cloud Platform (GCP), AIX, AWS Lambda, Docker, Apache Kafka, Azure Synapse

Storage

Databases, Oracle DBA, Oracle PL/SQL, SQL Server DBA, MySQL, PostgreSQL, MySQL Server, Oracle Database Tuning, Azure SQL Databases, Database Architecture, MariaDB, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), NoSQL, Data Lakes, SQL Server 2014, SQL Server 2016, JSON, Amazon Aurora, Amazon S3 (AWS S3), Database Security, Database Performance, Oracle Cloud, IBM Db2, Datadog, Document Databases, Microsoft SQL Server, Database Administration (DBA), Microsoft DBA, Azure SQL, Data Pipelines

Industry Expertise

Cybersecurity

Other

IT Governance, Enterprise Architecture, Platforms, IT Projects, Information Technology, IT Management, Oracle Discoverer, Oracle WebLogic Application Server, Linux Administration, MySQL DBA, IT Strategy, Data Warehousing, Oracle Data Guard, Oracle RMAN, Oracle ASM, RHEL, Data Warehouse Design, Architecture, Server Migration, SSH, Data Management, Data Engineering, Software Engineering, IT Project Management, Cloud Computing, DMBoK, Oracle Fusion Middleware, Oracle BI, BPM, Oracle Solaris, IT Service Management (ITSM), Innovation, Containerization, Information Security, Digital Transformation, BABOK, Business Motivation Model (BMM), Business Model Canvas, Oracle Service Bus (OSB), ESB Architecture, Web Services, WebLogic Diagnostic Framework (WLDF), Information Lifecycle Management (ILM), SFIA, Scrum Master, Enterprise Service Bus (ESB), NIST, ISO 27001, ISO 27002, ITIL 4, Amazon RDS, ITIL V3 Foundation Certified, Data Transformation, Reporting, APIs, Infrastructure, Containers, Oracle EBS, Quality Management Systems (QMS), Complex Event Processing (CEP), Big Data, IBM InfoSphere, OpenKM, MDM, Talend ESB, Talend Cloud Integration, ADOIT, IDERA SQL Diagnostic Manager, IDERA SQL Safe Backup, IDERA SQL Query Tuner, IDERA SQL Workload Analysis, Data Build Tool (dbt), Fivetran, Scrumban, ELT, Slowly Changing Dimensions (SCD), Azure Databricks, Data Visualization, Dashboards, Data Cleansing, Data Cleaning, Data Analysis, Big Data Architecture, Data Profiling, Directed Acrylic Graphs (DAG), Data Marts, Data Quality, IBM Banking Data Warehouse (BDW), ETL Tools, Cloud, Tools, Reports, Data Modeling, Amazon Kinesis, Poetry, Infor, BizTalk Server

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring