Andrew Magill Email and Phone Number

Skills Used: • Python, Flask, OpenAPI, Postgres, Redis, Solr, Docker, NGINX, Azure, GCP, Jira, ConfluenceResponsibilities:• Engaged directly with clients to determine project requirements• Wrote distributed asynchronous backend applications• Wrote unit tests prior to pull requests to Bitbucket/Github• Created and updated Jira epics and tasks to track progress• Wrote technical project documentation on Confluence• Wrote consumers/producers for data ingestion pipelinesAccomplishments:• Eliminated a manual data ingestion process by reverse engineering a proprietary file format for a client in the transportation industry• Contributed to the creation of a document retrieval system indexing terabytes of reports for a client in the energy industry• Migrated applications and infrastructure from Google Cloud Services to Microsoft Azure

Skills Used:• Python, Django, Flask, NGINX, Linux, Git, Docker, Ansible, Jenkins, SQL, PostgreSQL, MySQL, MongoDB, GraphQL, JavaScript, AngularJS, React, PHP, JavaResponsibilities:• Developing web interfaces for TACC high performance computing resources, consulting with NSF supported Science Gateways Community Institute clients, aiding UCSD in the development of the HUBZero platform, resolving help tickets.Accomplishments:• Contributed to the development of the UT Research Cyberinfrastructure Portal, a UT System funded science gateway allowing researchers to access high performance computing resources through the web.• Collaborated with researchers at George Mason University to develop Geoweaver, a web system to allow geoscientists to compose and execute full-stack DNN workflows, a clearinghouse for those seeking to protect endangered data.• Collaborated with researchers at the University of Michigan to develop the Flavoprotein DB, a graph database and web interface for investigation of structural, thermodynamic, and spectral properties of flavoproteins.• Maintained and contributed to the development of the Digital Rocks Portal, a repository for porous microstructure material imagery used in the fields of Petroleum, Civil and Environmental Engineering as well as Geology.• Developed a research prototype system through an NSF Eager grant to manage the provenance of distributed genomics dataset.• Resolved problem tickets for the HUBZero platform, worked towards redesigning the JupyterHub interactive code execution module.• Presented at academic conferences and contributed to research products, including papers, presentations, workshops, and posters.

Skills Used:• Python, C#, JavaScript, ActionScript, Dojo, AngularJS, HTML/CSS, MVVM, MVC, SQL, PL/SQL, Git, Agile Development (Scrum), ArcMap, ArcGIS Server, ArcGIS Enterprise, GIS, CartographyResponsibilities:• Full stack development, administration of ArcGIS Server, maintenance of legacy code, tier 3 help desk supportAccomplishments:• Developed the primary web application used by the City of Austin to display spatial data to the public.• Created web mapping applications providing public and internal employees access to information related to land development, including: zoning ordinances, jurisdiction, property information, proximity to floodplain, and information on existing development review cases.• Developed client side of the Flood Early Warning System; a real-time updating application which shows predictions and warnings of future flood water inundation based on current conditions and terrain modeling.• Wrote application allowing city departments (Parks Department, Watershed, and Public Works) to collaboratively schedule mowing of city owned green spaces.• Maintained and administered GIS servers which provide mapping, geo-processing, and location services to city web mapping applications.• Produced the first cached tiled map services used by the City of Austin, greatly increasing the speed at which spatial data is delivered to web mapping applications.

Skills Used:• JavaScript, HTML, CSS, VBA, VB, data modeling, GIS, cartography, linear referencingResponsibilities:• Web development, scripting, tool development, administration of spatial server, tier 3 help desk support, staff trainingAccomplishments:• Developed a public facing web mapping application which facilitated the route planning of super heavy loads to ensure safe transportation across the state while avoiding potential hazards such as restricted roads and bridges.• Developed scripts to automate the production of an annually published map book which illustrated state, county, and city roads, natural features, public spaces and facilities, and other points of interest.• Wrote library used by other department analysts to automate aspects of cartographic map production.• Taught classes introducing TxDOT employees to the use of GIS in their job activities.

Skills Used:• ArcMap, VB, VBA, Python, SQL, GIS, cartographyResponsibilities:• Coordination of spatial data collection and editing, automation scripting, desktop developmentAccomplishments:• Created and maintained geospatial database of water utility assets.• Digitized new water lines, valves, and other assets, from as-built construction plans.• Created an interactive map viewer used in planning by the water utility’s field crew.• Developed scripts to automate production of a 1:500 scale physical map book, which was printed on bound 11"x17" sheets, and used by field crews to locate water utility infrastructure.• Developed script to automatically generate indexed supplemental insets of utility assets too closely located to be discernible at 1:500 scale.