City of St. Louis

Data & Analytics Manager

•	Worked in collaboration with epidemiologists and IT staff to create the City of St. Louis COVID-19 dashboard including case rate maps, social vulnerability maps, and infographics 
•	Created a citywide analysis of HMDA data to supplement reports to the Treasurer’s office that examined geographic patterns in mortgage lending within the City of St. Louis and lending to various racial groups among single and joint applicants
•	Led the City’s technical partnership programs with the Census Bureau to prepare for the 2020 Census including the Boundary Annexation Survey, Local Update of Census Addresses, New Construction Program, the Participant Statistical Areas Program, and various other appeals processes 
•	Wrote policy briefs, talking points, and discussion papers on issues such as gentrification  and displacement, Census preparedness, state planning law, comprehensive planning, single family zoning, the long-term implications of COVID-19 on cities and urbanism, and other community development issues
•	Created, in consultation with senior planners, a Neighborhood Planning Prioritization Index to identify neighborhoods with the highest planning need in order to support upcoming planning initiatives
•	Created maps of biophysical vulnerability and replicated an index on social vulnerability to climate change for the City of St. Louis Climate Vulnerability Assessment
•	Developed interactive GIS tools to assist in the visualization of data for upcoming neighborhood planning initiatives and for displaying the City of St. Louis 2019 Market Value Analysis  
•	Conducted extensive analysis and visualization of various city datasets such as Citizen Service Bureau requests, crime data, Assessor’s parcel data, real estate transactions, building permits data, and real estate tax data
•	Developed cross-organizational resources and documentation on research methods and city data sources

Community Development Research Analyst - Planning and Urban Design Agency

St. Louis Regional Chamber

•	Utilized BLS data to update the Chamber’s monthly regional employment summary
•	Assisted in primary data collection for the ACCRA cost of living index
•	Created fact sheets detailing minority business development, small business credit availability, and business demographics in the St. Louis region
•	Updated the Chamber’s website and created blog posts using the Sitefinity web content management platform
•	Prepared a report analyzing the organizational structure of local and state venture capital investment organizations
•	Conducted research on the regional crime landscape that involved parsing local and federal crime data 
•	Authored a literature review of crime policies and wrote a report on local organizations involved in crime prevention
•	Prepared GIS data for use in regional employment maps and mapped regional crime patterns using ArcGIS software 
•	Maintained and updated a variety of reports that tracked the region’s largest employers, key industry clusters, and venture capital investments
•	Forecasted venture capital trends in several metropolitan areas
•	Assisted with the creation of a data visualization dashboard utilizing Tableau software
•	Entered, updated, and maintained contacts, organizations, and research projects in Salesforce.com

Economic Development Research Intern

Ronnoco Coffee

•	Created custom SQL queries to extract category and item specific data from Ronnoco’s primary ERP database for our customer service, sales, and operations departments
•	Studied internal operational processes, identified inefficiencies, and implemented process improvements 
•	Collaborated with purchasing director to send out RFPs, evaluated proposals based on key criteria, and made recommendations to management on proposals
•	Managed purchasing transition of acquired companies

Senior Planner & Analyst

•	Improved fill rate from 97.6% average to 99.0% average by implementing a more dynamic fulfillment method and utilizing more detailed forecasts on over 800 bought items
•	Developed reports for monitoring inventory value, supplier performance, and freight spend metrics
•	Prepared detailed product comparisons on acquisition targets and between suppliers to highlight potential synergies and cost savings
•	Developed strong vendor relationships that involved negotiating pricing and managing quality control
•	Performed sales & profitability analyses on products to optimize offerings and eliminate redundant items
•	Analyzed freight data and made recommendations contributing to over $25,000 in cost savings

Purchasing Planner & Analyst

Anheuser-Busch

•	Managed quarterly repack projects: developed and optimized distribution plans to ship 200,000+ cases to wholesalers nationwide, managed multiple deadlines for product and materials procurement, communicated with sales managers to manage inventory risks, and coordinated transportation at repack sites nationwide
•	Worked in conjunction with seven different brewery production and supply teams to meet the complex product demands of more than 15 Caribbean, duty-free, and ship chandler customers and maintain the Import/Export team’s service level agreements
•	Interpreted long-term forecasts of inventory and sales data to order import product from Western Europe
•	Compiled reports and performed maintenance of key performance indicators such as product ship age and customer delivery performance

Logistics Coordinator

Truman State University

•	Created databases of possible donors for use in advancement campaigns.
•	Researched eligibility of alumni for matching gift and charitable gift annuity donor campaigns.
•	Compiled multiple high volume mailings to inform alumni of university events and giving opportunities.

Office Assistant

Data & Analytics Manager - City of St. Louis

Taplio

Jason D. Whiteley's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Jason D. Whiteley's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Jason D. Whiteley's Linkedin Analytics