Travis Gallegos

About Travis Gallegos

Experienced software engineer with a strong background in application development, database management, and IT operationsThroughout my career, I have consistently demonstrated my ability to collaborate effectively with executive leadership to drive transformative business initiatives. As a trusted member of the IT department, I worked closely with top-level executives, providing strategic guidance and leveraging technology to create and implement impactful business process improvements. My insights and contributions were highly valued, and I was entrusted with the responsibility of shaping the company\'s technological landscape.In addition to my strategic involvement with executive leadership, I have designed and developed customized applications using Node.js, SQL Server, and Python, delivering innovative solutions that align with organizational objectives.Proficient in advanced SQL DML operations, I have utilized a range of techniques such as unions, triggers, joins, stored procedures, cursors, data conversions, data partitioning, and date/mathematical functions to optimize database performance and streamline operations. Managing SQL Server databases and Agent jobs has been an integral part of my responsibilities, ensuring the security, integrity, and availability of critical data.Moreover, I have spearheaded the development of customized automation solutions for e-mail notifications, leveraging my expertise in business logic to enhance communication workflows. Additionally, I have seamlessly integrated programs through the utilization of APIs and implemented efficient ETL processes for SQL Server data, enabling seamless data exchange and analysis.I have excelled in managing IT department staff and implementing effective department policies. I have successfully built and motivated high-performing teams, fostering a collaborative work environment and driving individual and collective success. I have been responsible for overseeing the day-to-day operations of the IT department, ensuring optimal productivity and efficiency.Having also taken charge of IT procurement, I have successfully acquired IT equipment and software for the company, meticulously aligning investments with organizational needs and priorities. Skilled in Project Management, Software Coding, Business Analytics, Node JS, Javascript, Python, SQL Database, Data ETL, SSRS BI reports and Microsoft Excel.

Experience

1. Program Manager - Business Systems

   MasTec Utility Services

   Mar 2023 — Present · Chandler, AZ, US

   Designed and implemented scalable full-stack API applications to integrate programs leveraging SQL Server, Python, SSIS (SQL Server Integration Services), and REST API.• Designed and implemented database schemas, queries, triggers and stored procedures to support application functionalities.• Leveraged Python and SQL Server Agent to create custom functionalities and automate various processes, enhancing overall application performance.• Collaborated with cross-functional teams to understand project requirements and deliver effective software solutions.• Conducted thorough testing and debugging to identify and rectify issues, ensuring a stable and reliable application.• Created SSRS BI reports to present data insights and key performance indicators, aiding decision-making processes for end users.• Executed comprehensive testing and validation procedures to maintain data quality standards and troubleshoot issues within the ETL pipeline.

Education

• The Wharton School

  Certificate, Business Analytics

  2022

• University of Phoenix

  Bachelor of Science (B.S.), Business Administration

  2004 — 2008

• Saint Xavier University

  MBA Credit Courses, Business

  2016

• University of Arizona

  Certificate, Full Stack Software Developer

  2017