Keywords
SQL
GIS
Documentation
Excel
Database
Map Production
Geocoding
Data Analysis
database analyst
Database Management MS SQL
Quality Control
Quality Assurance
Software Testing
Report generation
Microsoft word
Microsoft Office
Microsoft SharePoint Portal
Microsoft Access
PDF Editing
Data Entry
minutes
Test documentation
Test data
Cityworks
ArcMap
Pivot Tables
Internet Research
data research
Skills
PROFESSIONAL SKILLS
* Map Production
* Address Matching & Geocoding
* Database Management
* Data Analysis
* Documentation
* Project Management
* Quality Assurance & Quality Control
* Software Testing & Troubleshooting
* Quality Improvement Process
TECHNICAL SKILLS
* SOFTWARE: ArcGIS 10 (ArcEditor, ArcMap), ArcGIS Pro, ArcGIS Online, Cityworks, Microsoft Office (Excel, PowerPoint, Teams, Visio, Word), Microsoft SharePoint 2016, SQL
* DATABASE: Microsoft Access 2016, Microsoft SQL Server 2016, ArcCatalog 10, PDF Locator
* OPERATING SYSTEMS: Microsoft Windows 7, Vista, and XP
* Map Production
* Address Matching & Geocoding
* Database Management
* Data Analysis
* Documentation
* Project Management
* Quality Assurance & Quality Control
* Software Testing & Troubleshooting
* Quality Improvement Process
TECHNICAL SKILLS
* SOFTWARE: ArcGIS 10 (ArcEditor, ArcMap), ArcGIS Pro, ArcGIS Online, Cityworks, Microsoft Office (Excel, PowerPoint, Teams, Visio, Word), Microsoft SharePoint 2016, SQL
* DATABASE: Microsoft Access 2016, Microsoft SQL Server 2016, ArcCatalog 10, PDF Locator
* OPERATING SYSTEMS: Microsoft Windows 7, Vista, and XP
Project history
04/2009
-
Present
Database Manager
Capitol Hill Pregnancy Center
(10-50 employees)
Public service
Mastered CISWIN and CoolFocus computer software and streamlined, updated, and managed 3600 records in center’s database of clients (single parents and couples in need). Efforts resulted in center being able to generate detailed program reports for material support, client information, and social services referrals.
⦁ Database Management. Continue to eliminate 90 percent of the pregnancy center’s monthly backlog of 300 paper files by converting them into database records, resulting in ongoing cost savings for the center.
⦁ Customer Service. Schedule via telephone client appointments with counselors at the pregnancy center.
⦁ Database Management. Continue to eliminate 90 percent of the pregnancy center’s monthly backlog of 300 paper files by converting them into database records, resulting in ongoing cost savings for the center.
⦁ Customer Service. Schedule via telephone client appointments with counselors at the pregnancy center.
09/2022
-
03/2023
Senior GIS Specialist
ALEX
(250-500 employees)
Internet and Information Technology
Supported Spatial Data Standards for Facilities, Infrastructure, and Environment through the collection, production, analysis, dissemination, and maintenance of consistent and accurate, installation geospatial data and products that included GIS and CADD (Computer Aided Design and Drafting).
⦁ SQL Query Development. Used SQL Query on each ArcGIS Pro floor shapefile to identify offices with missing numbers. Referred to the CADD basefile for each floor to enter the updated office numbers.
⦁ Map Design. Designed a map of proposed locations for bird boxes near the Pentagon. Added buffer to highlight underground utilities in the vicinity of the boxes that would be impacted by installation.
⦁ SQL Query Development. Used SQL Query on each ArcGIS Pro floor shapefile to identify offices with missing numbers. Referred to the CADD basefile for each floor to enter the updated office numbers.
⦁ Map Design. Designed a map of proposed locations for bird boxes near the Pentagon. Added buffer to highlight underground utilities in the vicinity of the boxes that would be impacted by installation.
03/2021
-
09/2022
Field Support Assistant
Rangam Consulants, Inc.
(250-500 employees)
Internet and Information Technology
Mastered Asset Suite computer software to process incoming electric and gas inspection certifications into approved work orders. Searched database to find matching work orders. Created new orders when none was on record. Presented certifications as ready for authorization by posting them to the proper work orders.
10/2011
-
09/2017
GIS Specialist 2
CACI
(1000-5000 employees)
Internet and Information Technology
Employed ArcGIS and demographic data (Census TIGER, Census PL, and American Community Survey) to create maps and reports for attorneys on various cases such as voting rights, disability access, and school zones. Designed pivot tables to analyze demographic data for use in investigations and court trials. Tested new versions of Justice Mapper and Justice Mapper Lite (JML) software.
⦁ Project Management. Identified technical issues in the Voting Rights database that reduced its PDF upload speed and devised a solution. Led a team of GIS analysts to implement this solution that increased upload speed by 20 percent.
⦁ Map Design. Collaborated to create 102 Limited English Proficiency (LEP) state population maps for a White House presentation.
⦁ Technical Writing. Created 51 written descriptions of LEP maps and pie charts so the documents were accessible to visually impaired audiences and 508 compliant.
⦁ GIS Training. Designed 20 training manuals for GIS Team to improve quality and consistency of procedures.
⦁ Quality Assurance Team Coordination. Reviewed Department of Justice’s testing guide and determined its noncompliance with current GIS software functions. Produced a new guide that enabled GIS testers to perform their work 30 percent faster.
⦁ Project Management. Identified technical issues in the Voting Rights database that reduced its PDF upload speed and devised a solution. Led a team of GIS analysts to implement this solution that increased upload speed by 20 percent.
⦁ Map Design. Collaborated to create 102 Limited English Proficiency (LEP) state population maps for a White House presentation.
⦁ Technical Writing. Created 51 written descriptions of LEP maps and pie charts so the documents were accessible to visually impaired audiences and 508 compliant.
⦁ GIS Training. Designed 20 training manuals for GIS Team to improve quality and consistency of procedures.
⦁ Quality Assurance Team Coordination. Reviewed Department of Justice’s testing guide and determined its noncompliance with current GIS software functions. Produced a new guide that enabled GIS testers to perform their work 30 percent faster.
Certifications
Local Availability
Only available for the countries
USA
I am open to travel 15% of the time.
