Tristan Collins

Application Support Specialist @Larimer County

Larimer County, CO, US

As a dedicated Application Support Specialist within the Larimer County Assessor\'s Office, I specialize in leveraging technical skills to enhance operational efficiency and data integrity in government operations. My expertise encompasses Python scripting for process automation, data analysis using SQL and PowerBI, and utilization of industry-specific tools such as RealWare.Key Responsibilities:Process Automation & Scripting: Employ Python scripting to automate routine tasks, ensuring accuracy and freeing time for strategic analysis. My approach to automation focuses on reliability and scalability, aligning with the office\'s commitment to operational excellence.Data Analysis & Management: Execute complex SQL queries in SSMS to gather, analyze, and interpret large datasets. My analytical capabilities allow for insightful data-driven decisions, enhancing the effectiveness of our property assessment processes.Tool Proficiency: Navigate and utilize government-specific software like RealWare with a deep understanding of its capabilities, ensuring that its full potential is harnessed for our data management needs. Additionally, I am adept at using PowerBI to create compelling visual representations of our data, making complex information accessible and actionable.Innovative Solutions & Reporting: Pioneered the transformation of a substantial SQL database into an automated Python framework using SQLAlchemy. This innovative approach enabled the seamless integration of data into a PowerBI dashboard, which now accurately highlights discrepancies in our database. API Testing & Integration: Utilize Postman and CURL to test API endpoints to our database, ensuring that data is accurately supplied to public users. I also use Python to establish GET requests with Flask and Django libraries, facilitating the efficient retrieval of data from our systems.

The University of Alabama

Bachelor of Science in Commerce & Business Administration, Management Information Systems (MIS)