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.
• 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.
• 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.

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.
• 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.
• 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.
• 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.

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.
• 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.
• 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