Annwen Gammon

I am a results-driven Software / Data Engineer with a strong foundation in full-stack development, data engineering, and cloud technologies. I am skilled in Python, React, TypeScript, SQL, and Docker, with experience designing secure and scalable web applications and automating complex workflows. After 3 years of professional experience, I am adept at problem-solving, I bring a keen eye for detail and a passion for optimizing systems and processes to drive efficiency. I have hands-on expertise in Tableau API, AWS, and building machine learning solutions so I thrive in dynamic, collaborative environments that prioritize innovation and impact. Most importantly, I am committed to delivering high-quality solutions that meet user needs and business objectives.

Data Engineer - DISH Network, Data Warehouse IT Department 

• Designed, developed, and optimized ETL processes to support data pipelines, ensuring seamless data integration across multiple systems using Python and SQL.
• Created complex SQL queries to extract, transform, and load data, improving reporting accuracy and efficiency.
• Enhanced Python programming expertise through the development of robust scripts for automating data workflows and handling large datasets.
• Played a key role in migrating legacy systems to modern data platforms, leveraging SQL and ETL tools to enhance performance and scalability.
• Gained in-depth knowledge of data warehouse architecture, contributing to the design of scalable, maintainable, and efficient data solutions.

Full Stack Engineer - SMI Supply Chain 

• Designed and developed full-stack web applications using React, TypeScript, and SQL, ensuring a seamless and user-friendly experience.
• Led the creation of a maturity model survey application, enabling users to assess business performance and generate actionable insights, hosted securely on AWS.
• Built dynamic front-end interfaces using React and TypeScript, paired with efficient back-end APIs to manage data and handle user interactions.
• Engineered database schemas and wrote optimized SQL queries to support robust data storage and retrieval processes.
• Integrated functionality for users to generate and download custom PDF reports directly from the application.
• Collaborated with stakeholders to identify requirements, implement features, and ensure the application met business objectives.
• Implemented ChatGPT integration to provide users with AI-driven recommendations for improving survey scores.

I have a Bachelors degree from the University of Colorado Boulder - college of engineering in Computer Science.