August J. Passafiume

St. Louis, Mo

Phone #: 314-***-****

Email: acxhta@r.postjobfree.com

Professional Experience: Many years with Geospatial analysis (GIS) working in:

GIS/Geospatial: Primary tools are ESRI ArcMap, ArcGis Portal, Model Builder, Business Analyst, SQL, Teradata, Agile training

Planning: Experience with city engineers, Aldermen, budgests, estimating, construction drawings

Agriculture: Remote sensing using Ssurgo, NED, GBI

Medical/demographics: Spatial analysis based on medical data, building statistical data maps. Used Business Analyst to compute drive time polygons depicting pharmacy/physician location compared to member roof tops(addresses)

Personal Attributes:

Know how to work with all levels of management, political entities, engineers, and inspectors

Willingness to travel or work overtime to accomplish the mission

Experience writing technical documentation and reports

EXPERIENCE

Consulting (Monsanto) September 2015 – Present

Supply Chain, Supervisor: Alec Sheridan

Primary focus is on geospatial data collection and dissemination.

Consulting (Express Scripts) November 2014 – June 2015

Nextgen Consulting: GIS Business Analyst at Express Scripts Inc. in Health Information, creating statistical data maps using Teradata, SQL and ESRI ArcMap.

Creating statistical maps from pharmacological and medical data

Maps: Disease: Hep-C, Diabetes, MS; Pharmacy/members; Predictive score based on adherence

Spatial Analysis – heat maps, drive times analysis using ESRI Business Analyst

Used SQL to extract data from Teradata, which was the data source that contained thousands of tables

Create Web applications through ArcGIS Portal

Support Knowledge Solutions which is a data science division, marketing, HR applications

Also responsible for all system upgrades through ESRI, most recently ArcGIS online/Portal 10.3

Utilimap Corporation July 2011 –October 2014

Engineering/Asset Management.

Creating maps for electrical utilities in various areas of the county using ESRI/GIS mapping software.

Utilimap KSA’s: Understanding of how the GIS data is imported into the SDE data base. This requires daily extraction of data through a ‘Check In’ process and results in building a new data base, at least daily. After data is extracted, then one must communicated with user via email/phone, gathering requirements for the creation of custom built maps and reports. Skills required are organizing data, by date or object id (OID), setting up the mapping templates, using scripting languages to automate layers in the map and finally, cartographically producing a readable map with an associated Crystal reports.

Other skills include creating geo-databases, developing maps from survey coordinates and building maps from cadastral, as well as special request, which could be from foresters working with communities, like Rockville, MD.

Analyst

January 2010 – June 20100

SLUCare

Epic Certified in Bridges Interface, April 2009, NVT 2010 & 2012

Orders / results testing to various ancillary systems

Diagnose and repair HL7 messaging errors

Trouble tickets using Remedy

Data Courier, record management

Data mapping of incoming and outgoing translation tables

Monitoring Cloverleaf Interface engine

GIS Analyst/Graphic Design

July 2007 – December 2009

City of St. Louis, Board of Public Service

Design maps using ESRI ArcView 9.2, Arc Objects and AutoCAD 2006.

Use Access to link SQL database to GIS database. Pull data out of SQL Server using Access/ Excel queries. The data is then put into the Geodatabase for mapping purposes.

Develop and design integrated mapping systems with Google Earth. Types of Maps: Transportation Maps (roads, bridges, pavement analysis), aerial maps, statistical maps with reports attached to map, book maps.

Create geo-databases (GDB).

Senior Data Control Coordinator

Washington University, School of Medicine, Internal Medicine/Metabolism/Core Laboratory for Clinical Studies

February 2005 – June 2007

Supported Laboratory Information System (CLAS, Core Lab Application System) and (DRTC, Diabetes Research and Training Center).

Developed object oriented applications in MS-FoxPro.

Maintained CLCS web site with LOTUS Notes.

Used MS-Visio for laboratory layouts.

Provided Monthly data review and analysis of research subjects.

Worked various error messages in Allscripts/Touchworks using HL7.

Programmer/Analyst

March 1997 – June 2004

St. Louis Metropolitan Police Department

Provided reports for all facets of Police Department business, such as Personnel, Duty Roster, Crime Statistics and Pinpoint Crime Mapping. Reports were developed in Crystal Reports using Access.

Use Access and Excel to run reports on data residing in the mainframe system. Took crime statistic information from the database and moved into the GIS system. Created maps which could be viewed by neighborhood, by district or other geographical features.

Provided specific information to Police Officers, Detectives

Maintained crime statistics and reporting statistics.

Developed detailed Crime maps using ArcView 3.0.

Environment: Oracle, Crystal Reports, IBM Mainframe, OS-390/COBOL/Easytrieve/JCL, Arc View Mapping System (GIS

Education

BS Computer Science, Saint Louis University

Contact this candidate