Andrea B.

About Andrea B.

Highly analytical, logical, and detail-oriented problem solver with professional experience in ArcGIS spatial database management, data organization, customer service, time and project management, producing reports, working on several projects with deadlines, and maintaining and updating geodatabase data.I enjoy solving problems, helping people, working with a team, learning, and having plenty of work to do.Experience with the following: • GIS: Esri ArcGIS Pro 3.x and Enterprise 11.x (with Portal), 3D Analyst & Spatial Analyst Extensions, ModelBuilder, ArcGIS Online (AGOL), ArcGIS Desktop (ArcMap/ArcCatalog), Esri Community, QGIS, Global Mapper, Google Earth • Web Maps/Apps: ArcGIS Online (AGOL): Experience Builder, Instant Apps, Map Viewer, Field Maps App and Forms, Survey123, Dashboards, Web AppBuilder• RDBMS/Database management: Microsoft SQL Server Management Studio (SSMS)• Project and Client management: Asana, Monday.com• Scripting: Arcade, Python, ModelBuilder, ArcGIS Pro Notebooks, Python script tools in ArcGIS Pro toolbox, VBA• BI/Reporting: Tableau, ArcGIS Pro reports, Esri ArcGIS Online (AGOL) Dashboards, Crystal Reports• Virtual Work Environments: VPN with Remote Desktop Connection• GNSS (GPS) data collection: Trimble, Carlson with RTK networks• CAD: Autodesk AutoCAD Map 3D• Graphics: Adobe Illustrator and Photoshop• Microsoft 365: Teams, Power Automate, OneDrive, Excel, Word, Outlook, Access, PowerPoint, Publisher, and SharePointCan integrate data between systems including converting GIS data to and from AutoCAD, PLS-CADD, Google Earth (kmz), and GPS outputs. And ETL from SQL database to SQL geodatabase to file geodatabase (.gdb) etc.Cartographer with the experience to create maps that communicate.Practical experience in problem solving, time management, mentoring, teamwork, interviewing/hiring qualified GIS staff; technical proposals; data management and organizational skills; self-motivated, curious, independent learner; flexible and adaptable; excellent written and verbal communication skills; conversant in Spanish.

Experience

1. Sr Geospatial Solutions Developer

   Wisconsin Historical Society

   Oct 2023 — Present · Madison, WI, US

   Administer, manage, and upgrade ArcGIS Enterprise - including security updates and best practices• Developed and implemented roadmap and change management documentation to install latest version of ArcGIS Enterprise• Provided consultation, implementation services, and transitioned existing Esri ArcGIS Server infrastructure to a new hosting environment and provider• Evaluate, design, and implement GIS software releases, system upgrades, and manage desktop and server-based software related infrastructure• Digital accessibility updates to GIS maps and apps• Administer SQL geodatabase, maintenance, and management• Upgraded SQL geodatabase version and schema and implemented schema best practices• Test SQL geodatabase data Quality Control (QC)• Created and scheduled ModelBuilder models to run in task scheduler including ETL processes from SQL database to SQL geodatabase to File geodatabase (.gdb) to truncate and append AGOL (cloud data stores) and Portal hosted feature layers. Data sharing model and SQL enterprise geodatabase maintenance model• Implemented Single Sign-On (SSO) for ArcGIS Online (AGOL) for organizational users• Publish, maintain, and administer Portal and AGOL map/feature services (API map/data services) for external clients• ArcGIS Pro Notebooks, Python script tools in toolbox, Arcade• Experience Builder and Instant app creation, including the public Historic Markers app• Advised on capabilities of ESRI Mobile applications and solutions (Trimble, ArcGIS Field Maps app)• Supported staff in the transition from ArcMap to ArcGIS Pro and provided systems education to technical staff. Identified necessary changes in workflows and data structures - change management• Update staff on new ArcGIS Pro and ArcGIS Online features. Answer all Esri software suite questions.• Communicate effectively and translate complicated technical topics with a non-IT audience including but not limited to historians, archeologists, and cultural resource specialists

Education

• University of Wisconsin-Madison

  Bachelor of Science - BS, Geography (Human/Environmental Interactions), and a certificate in Environmental Studies

  2001 — 2004

• Mid-State Technical College

  Coursework toward an Associate in Applied Science, Accounting

  2018 — 2020

• University of Wisconsin-Eau Claire

  --, Geography

  2000 — 2001

• Kishwaukee College, Malta, IL

  --, C++ Programming

  2006 — 2006

• University of Wisconsin-Madison

  Graduate Certificate, Geographic Information Systems

  2004 — 2005

Skills

• Arcmap
• Gps
• Milsoft Windmil Map
• Nisc
• Data Management
• Autocad
• Arcview
• Spatial Analysis
• Geography
• Project Management
• Arcgis
• Gis
• Global Positioning System (Gps)
• Organizational & Writing Skills
• Spatial Databases
• Cartography
• Geographic Information Systems (Gis)
• Databases
• Google Earth
• Arccatalog
• Arcgis Server
• Futura Systems
• Esri