Juan Ignacio Orozco Zamora

Delivers end-to-end data solutions across data delivery, analytics engineering, and data engineering functions, leveraging dbt, Snowflake, Oracle, Hightouch, and Fivetran. Develops and maintains complex cross-product data models to empower business users in analyzing finance, revenue, operations, costs, and performance.

Migrated analytical capabilities to Python using Spark and Databricks, delivering cost savings and efficiency gains. Built and deployed multiple data processing pipelines that improved accuracy, reliability, and performance over legacy systems.

Built a unified data source infrastructure to power a predictive model on client data consumption using Oracle SQL and Apache NiFi. Designed and implemented a data ingestion pipeline with Apache NiFi for near real-time ETL/ELT streams.

Developed a full-stack digital record management application for a local educational institution. Built the core API using C# and .NET with PostgreSQL, and created a front-end using JavaScript and Vue.js.

Developed a full-stack digital record management application for a local educational institution. Built the core API architecture using C# and .NET with PostgreSQL, and created a front-end application using JavaScript and Vue.js.

Instructed fundamental database administration topics using Oracle XE, including access management, security, and database design. Emphasized complex SQL query development and DBMS programmability features such as triggers, functions, stored procedures, and cursors.

Pursued a Bachelor of Science degree in Computer Science.

Completed the Advanced SQL certification.

Completed the Postman API Expert certification.

Completed the Database Design certification.

Completed coursework in Data Warehousing and Business Intelligence.

Completed the Process Mining Fundamentals certification.

Completed the Snowflake SnowPro Core certification.

Completed courses in Advanced SQL, Joining Data in SQL, Advanced Python, Relational Databases in SQL, and Database Design.

Completed the Joining Data in SQL certification.

Completed the Relational Databases in SQL certification.

Completed the Advanced Python certification.

Earned the Postman API Expert certification.

Completed a certification in Data Warehousing and Business Intelligence.

Completed the Process Mining Fundamentals certification.