Andrew Bergstrom Email & Phone Number

Chicago, Illinois, Us

- Developed reusable UI components for a mobile application using Flutter. - Built a Twilio authentication module and an FAQ section using GraphQL queries. - Tested and integrated REST API endpoints, ensuring smooth data flow between frontend and backend. - Fixed critical bugs to enhance user experience and improve application reliability. - Collaborated with a team of engineers to deliver a mobile application serving over 600 locations, improving the customer experience by providing services from an industry leading plumbing company.-- Previous Projects --- Worked within a small, dynamic team as a Technical Consultant and Business Analyst, collaborating closely with stakeholders across business units to ensure project alignment. - Played a pivotal role in project activities, translating business needs into actionable outcomes. Contributed to crafting stories, epics, and features in JIRA for streamlined project management. - Utilized Snowflake for data modeling, creating intricate SQL queries to meet customer dashboard specifications. Contributed to engineering data models, transformations, and views for an advanced utility dashboard. - Assisted in developing Data Flow Diagrams (DFDs) and Entity Relationship Diagrams (ERDs) to visually represent complex data processes. Supported stakeholder comprehension and collaboration. - Conducted meticulous Quality Assurance (QA) checks, ensuring data accuracy within the utility dashboard. Contributed to maintaining reliability for optimal client performance. - Worked with the data required for ingestion, transformation, and consumption, contributing to the functionality of the dashboard aligned with business needs. - Contributed to transforming client operations, providing real-time insights to optimize energy usage, forecast demand, and manage expenses efficiently. Resulted in significant cost savings and enhanced operational efficacy.

Chicago, Illinois, Us

• Spearheaded development of the HappyApp project using .NET, C#, MongoDB, Docker, XUnit, Razor Pages, and API integrations.• Engineered an employee happiness tracking tool with automated surveys, enhancing workplace culture.• Implemented agile methodologies with 2-week sprints to efficiently deliver features and enhancements.

Redmond, Washington, Us

Mixed Reality - Environment Understanding• Developed integration tests with C# and the NUnit framework that allows for 99.9% up-time in service reliability for Azure Spatial Anchor developers• Configured Yaml file to define and assemble all build artifacts from Anchor Front End and the Endpoint Test Runner into the right folder structure for use in a release pipeline• Created a gated deployment process by calling endpoint tests against the localhost as a Kubernetes startup probe to ensure end-users have successful app deployment and management, potentially saving $1million+/yr. in annual cost • Integrated and managed Geneva Synthetics JSON configuration to send scheduled synthetic traffic metrics every 4 hours by running against deployed endpoints checking on the health of the service• Coordinated with cross-functioning sister team in 2 week sprints gathering input which aided in the development process of creating service test suits

Redmond, Washington, Us

4 week classroom program topics include:• Software Engineering Fundamentals• Agile foundations• Object-oriented design foundations• Git workflows• Test driven development• Azure DevOps (Pipelines, Boards, and Repos) formerly VSTS• Visual Studio Enterprise• Cloud computing and Azure services• Algorithms and data structures• Sprint planning• Daily stand-up meetings• App development• Pair-programming• Code reviews• Group Presentations• Sprint retrospective• App presentation

Denver, Co, Us

• Prepared 20+ lesson specific challenges in HTML/CSS, JavaScript, Java, and SQL to help students gain a deeper understanding of the full web development cycle.• Explain complex software development concepts in a non-technical way.• Initiated collaboration with a small 3 person team to create engaging ways aimed at helping students learn and understand object oriented programming best practices, concepts and patterns• Monitored a class of 60+ students’ progress while assisting students in accomplishing established learning objective with 98% of students completing the program• Coach and guide students to be as employable as possible and support them to develop industry standard portfolios.• Adapted communication style to connect with the diverse experiences of participants.

Seattle, Washington, Us

• Lead hiking and kayaking expeditions in remote wilderness settings with few or no defined trails, utilizing safety standards and route-finding skills.• Develop and deliver educational presentations covering environmental science, history, or other relevant topics to the itinerary as assigned by the EL for up to 90 guests.• Provide in the field, hands-on interpretation, and thematic, formal onboard presentations that I integrated into a week-long interpretive program, and wildlife narration utilizing interactive tools such as maps, charts, guidebooks, powerpoint, microscopes and spotting scopes to involve the guests.• Work within a cohesive and cooperative team led by the Expedition Leader and Lead Guide, with a heavy emphasis on communication and teamwork.• Confidently and competently lead groups of up to 20 guests in the field and on the water, and create an enjoyable experience for guests even when an excursion does not go as planned. Heavy emphasis on customer service, dynamic thinking, and safety.• Demonstrable written and verbal communications including interpretive materials and presentations development. Demonstrable ability to operate Microsoft Word, Excel, Powerpoint, and photo editing software.• Demonstrable ability to utilize a GPS, and read navigational and topographical maps and software.• Cultivate the guest experience by focusing on the observation of the surrounding geology, flora, and fauna by encouraging passengers to spend as much time on deck exploring and experiencing the natural surroundings that may go unnoticed.• Participate in the behind the scenes daily maintenance and programmatic tasks that keep our gear and program running. These tasks included, photo editing, blogging, slideshow creation, gear stowage, repair, cleaning, and organization.• Proactively maintain the cleanliness, order and function of all Expedition tools, including kayaks, paddle-boards, electronics, and snorkeling gear.

• Coordinate with businesses and set up office visits. • Lead social media marketing, and email blasts.We bring rescue puppies to promote employee health & wellness, relieve stress, boost morale, bring smiles to your team and help socialize puppies.

Seattle, Wa, Us

• Provided technical support as a POS help-desk for 48 restaurant systems• Analyzed user requirements and developed functional specifications• Performed system testing, and interpretation• Installed software updates for individual restaurants• Created new system layouts for new restaurant openings• Provided financial reports, company records, and organizational plans