Greater Minneapolis-St. Paul Area
Worked within Enterprise Research & Analytics to build an internal web application to visualize
customer data
•Wrote SQL code to group 19 million U.S. Bank customers by address into 215,000 census block
groups to create block group aggregates of customer data account summaries.
•Developed python scripts that automate data collection and maintenance by updating data in web
app server with customer records in database on a weekly basis.
•Built geoprocessing models using arcpy, an imported python module, to allow for the user to
select multiple block groups in the web app environment, in order to see aggregate customer
account summaries in the selected regions.
