Luis M. Ortiz Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Oh

I served as an Application Designer integral to multiple key initiatives, with a focus on Global Pricing initiatives, Ingredient Data Analytics (IDG), and data extraction for AI initiatives centered on Machine Learning models:• Exploratory Assessments and Scope Definition: Initiated technical assessments and defined project scope by understanding key user requirements and gathering project information.• Collaboration and Development: Worked closely with an overseas development team to design and develop the IDG application and maintain the Global Pricing application, ensuring alignment with business goals and technical specifications.• User Interface and Experience Design: Contributed to the design of user interfaces, ensuring an intuitive and user-friendly experience in alignment with business needs.• System Architecture and Code Reviews: Played a role in defining the system architecture to ensure scalability and maintainability. Conducted code reviews to enforce best practices and coding standards.• Technical Documentation: Produced and maintained technical documentation, including design specifications, user guides, and technical requirements.• Data Integration and ETL Processes: Designed and executed data imports from various sources and ETL (extract, transform, load) activities into PostgreSQL and Oracle Databases. In addition, I also supported data extraction for AI initiatives focused on Machine Learning models, enhancing decision-making processes for Smart Selection and Smart Creation of Flavors.

Cincinnati, Oh

In my role as the ETL & Data Migration Lead for the Aurora Global Pricing System (a multi-million dollar, multiyear initiative), I played a critical role in the company’s strategic growth by enabling a unified global pricing system. This project, built on an Oracle database and developed in Java, involved integrating master data from diverse systems, including SAP HANA, IBM DB2 (AS400), Oracle databases, and user-provided data.• Analyzed business requirements and designed ETL solutions using Oracle Loader, PL/SQL, DataStage, and IBM DB2 to meet project goals. • Developed comprehensive documentation detailing interface design, program development logic, coding practices, testing strategies. I also optimized code and database objects to significantly reduce processing time. • Mentored an overseas team of developers, assisting them in overcoming challenges related to design, development, optimization, and testing while ensuring strict adherence to project standards. • Led the deployment and implementation efforts, overseeing batch monitoring and handling break-fix activities in the production environment to ensure seamless operations.

I have developed multiple personal and open-source projects centered around electronics, microcontroller programming, and 3D printing, sharing my work across various platforms such element14.com, hackster.io, and oshpark.com, where I have earned accolades for my contributions to these communities:• Designed and implemented automation scripts and web-based applications for IoT electronics projects. Utilized Python for data analysis and automation, and PHP with MySQL for server-side logic. Integrated front-end technologies such as HTML, CSS, and JavaScript for a seamless user experience.• Programmed microcontrollers such as Arduino and ESP8266 using the Arduino IDE (C++) to control hardware devices, sensors, and actuators, enabling real-time data collection and interaction.• Developed web interfaces using HTML, CSS, JavaScript, and AJAX to create dynamic, user-friendly applications. Implemented REST APIs to allow data exchange between devices and web services, enhancing IoT functionality.• Designed and built custom 3D-printed parts to integrate electronics seamlessly into enclosures and machinery for projects, ensuring optimal performance and durability.• Produced instructional videos, tutorials, and published project designs and source code. Shared with the maker community across multiple well-known platforms, fostering collaboration, and contributing to the open-source hardware ecosystem.

Cali, Colombia

In this role, I primarily focused on the Credit and Loan Management System while collaborating on other key company projects. I was responsible for evaluating and improving technical staff performance, ensuring alignment with project goals.• Reviewed project requirements and developed detailed technical specifications, guiding project execution.• Identified opportunities for improvement through redesign and automation of tasks and processes, enhancing system efficiency.• Provided performance reviews to senior managers, assessing the contributions of junior developers and other technical staff.• Identified opportunities for improvement through redesign and/or automation of tasks and processes

Cali Metropolitan Area

I primarily supported a Credit and Loan Management System responsible for managing the loans of every customer. My responsibilities included developing high-quality Oracle PL/SQL subprograms interfacing with multiple platforms, providing 24/7 technical support, and performing continuous database tuning to improve system efficiency.• Developed and maintained high-performance Oracle PL/SQL subprograms and Bash scripts for automation, interfacing with COBOL, Windows Server, and Unix environments.• Provided 24/7 technical support for Oracle databases across multiple branches, managing nightly procedures including interest accrual, date advancement, report generation, and system integration.• Enhanced system efficiency through continuous database and application tuning, improving response times for day-end processes.• Delivered feedback and reports for internal and external audits by regulatory authorities

Cali, Colombia