Matthew "Rez" Resner

Experience

• 

  City of Bloomington, IN

  Aug 2012 - May 2015

  Advocate for Community Engagement

  • Evaluated agency priorities and needs to develop mutually beneficial partnerships with Indiana University Service-Learning Classes, ex. Partnered with Kelley MBA students to deliver consulting services on Return on Investment of a potential Compressed Natural Gas (CNG) Bus filling station• Presented on DESD’s mission and specific Service-Learning project goals to classes of over one hundred students, and lead post service reflections for classes of up to thirty students• Constructed outreach, marketing, and data collection strategies to populate a database for Rentrocket, a green rental project funded by the Urban Sustainability Directors Network to address the split incentive problem between landlord energy efficiency investment and renter energy consumption• Assisted community members in drafting a single use bag ban ordinance by researching the legal language of ordinances in other cities• Entered and tracked energy use data on various city properties using the Energy Star Portfolio Manager (ESPM) for future analysis Show less

• 

  AIESEC en México

  May 2013 - Jul 2013

  English Language Instructor

  • Instructed adult students in basic, intermediate, and advanced concepts in the English language for a six week intensive program• Created daily lesson plans designed to immerse students in grammatical concepts while illustrating the regional diversity of American culture. • Shared American culture, customs, and ideology with students• Provided English instruction for children ages 5-18 with SOS Children's Villages (a family based housing program for orphans)

• 

  Office of First Year Experience Programs

  Apr 2014 - Aug 2014

  New Student Orientation: Program Assistant

  • Developed and implemented marketing and informational materials for display during New Student Orientation seen by up to 18,000 guests and new students • Familiarized myself with IU resources and provided accurate responses to questions from parents, students, and members of the IU community• Provided excellent customer service to parents, students, and members of the IU community• Facilitated a five day IUBeginnings trip for ten students called IUBCultured which focused on orienting students to the diverse cultural heritage of Bloomington while leading them to foster new friendships with students who shared similar passions. Show less

• 

  Bell Trace Senior Living

  Aug 2015 - May 2016

  Advocate for Community Engagement

  • Co-facilitated the “Roll and Stroll”, a Service-Learning program to improve the wellness of elders by engaging them in conversations with Indiana University students• Developed “Generations Speak: Being Mortal,” a community film screening followed by a reflection on Right to Die laws• Wrote a successful city grant for MLK Day to fund above film showing, and lead a subsequent panel discussion on aging and the healthcare system for eighty-five people

• 

  Federal Reserve Bank of St. Louis

  May 2016 - Aug 2016

  Sustainability Intern

  • Performed trend analysis of bank owned buildings’ energy consumption and Scope One greenhouse gas emissions to further reduce the bank’s contribution to climate change.• Generated Sustainability Database to ease the creation of a future bank sustainability dashboard, and to identify cost and waste reduction opportunities as a contributor to the Zero Waste employee taskforce, a management backed employee group that were the recent winners of a bank wide innovation grant.• Carried out point analysis (checklist) of necessary building projects to obtain a LEED Operation and Management (O+M) certification.• Calculated the Return on Investment (ROI) of installing new LED lights in a bank owned facility.• Evaluated potential costs and environmental benefit of switching bathroom hand dryers by measuring the impact of behavior modifying signage, calculating the savings between brands/methods, and performing a count of bathroom dispensers as a precursor to an ROI study.• Wrote and submitted innovation proposals to integrate telematics hardware into bank fleet vehicles to drive fuel savings, and to implement a carpooling program to reduce need for additional parking infrastructure and employee parking subsidy costs.• Conducted a point of sale packaging audit in bank café to determine use rates of reusable and disposable items with the long run objective of reducing the overall trash generated by café.• Collaborated with a team of interns during case competition to create a bank wide cybersecurity awareness and data supported incentive plan to address personnel vulnerabilities by creating a positive rather than negative culture surrounding federal compliance. Show less

• 

  Indiana Housing and Community Development Authority (IHCDA)

  Aug 2016 - Nov 2017

  AmeriCorps Vista and Rental Housing Tax Credit Researcher

  • Wrote Excel VBA script to iterate through applicant scoring spreadsheets from the 2011-2016 Low Income Housing Tax Credit (LIHTC) competitive award rounds, analyzed the data to determine the relative competitiveness of individual scoring criteria, and made policy recommendations resulting in the removal of multiple uncompetitive scoring criteria from the 2018-2019 Qualified Allocation Plan for the State of Indiana.• Reviewed tax credit applications for threshold qualifications and scoring based on objective Qualified Allocation Plan (QAP) criteria, and worked as part of the analyst team to identify final 2017 LIHTC recipients.• Researched and compiled a report on other state’s use of federal Tax Credit Assistance Program (TCAP) funds to determine precedent or stipulations for allocating funds that had returned from revolving loan programs.• Analyzed market studies for the 2016 competitive 9% tax credit award round to determine if sufficient project demand existed in each area to warrant a project.• Performed a Pearson’s Chi-Squared Test on Set-Aside choice and funding to determine relative advantage of applicants in each funding category (ex. Elderly vs. Rural), and discover if the current scoring system was over privileging the Elderly funding category.• Interpreted population, migration, and housing statistics from the American Communities Survey to create the Housing Needs Index, a new scoring category in the 2018-2019 QAP designed to advantage developments in high need areas.• Identified a list of potential counties for the new Workforce Housing Set Aside, using statistics drawn from the Innovation Index 2.0 from StatsAmerica in order to advantage developments with employment opportunities.• Learned MS. Excel Virtual Basic (VBA) and wrote macros to automatically enter data on scoring from each application round, save files, and lock and unlock files with multiple protected sheets. Show less

• 

  Peace Corps

  Dec 2017 - Nov 2019

  Agroforestry Volunteer

  • Designed and implemented a head of household questionnaire for forty-four families to identify community issues in health and farming, and to record demographic data such as number of children in the household, and major family revenue sources.• Instructed a six-month agriculture training program for ten adults covering topics such as permagardening, and maintaining soil fertility to address deteriorating soils and economic problems jointly. • Created a tree nursery enterprise with three other members to raise over five thousand cash crop trees for sale (Coffee, Cacao, and Oil Palm), and trained group members on various marketing and management practices to ensure business sustainability. The enterprise has generated over three million Guinean Francs in profit so far (~300 USD) and represents at least a two-hundred percent rise in income relative to working as a field hand. • Studied and became proficient in both Kissi; the local language spoken at my site, and French; the professional and working language of Guinea.• Advised farmers on coffee and cacao plantation design using techniques such as intercropping with banana trees to increase per-hectare productivity, and contour planting to reduce erosion and create terraces on hillside farms.• Co-developed pre-service training materials for incoming Agroforestry Trainees alongside program staff • Mentored newly arrived Peace Corps Trainees during their Pre-service and In-service trainings• Co-facilitated the introduction of Orange Flesh Sweet Potato (OSFP) with the Faindou health agent and a women’s health group and co-created an OSFP agricultural business in Yende, a nearby city with two-thousand inhabitants, in partnership with a local agricultural school graduate and the director of the sub prefectural health center. Show less

• 

  Northeastern University

  Jan 2020 - Jun 2020

  Program Assistant

  • Designed marketing and programming materials (postcards, email) consistent with university branding• Managed logistics (spaces, catering, and programming) for Peer Groups, and Family Business Seminar Series. Developed transitional online events during COVID-19 Outbreak • Kept electronic budget (QuickBooks), managed billing, tracked monthly expenses, and maintained physical records of contracts and invoices

• 

  City of Indianapolis - Department of Metropolitan Development

  Jun 2020 - Feb 2022

  Grants Analyst and Researcher

  • Tracked, managed, and reconciled internal accounting of Federal CDBG funding; Resolved longstanding cash-balance deficit and identified unrecorded program income from prior years• Reviewed and approved invoices for payment following federal eligibility regulations, managed drawdown of federal dollars, monitored expenditure deadlines and created forecasts to insure timeliness of funding allocation• Prepared data for regular fiscal and outcome indicator reports such as the SF425 Cash on Hand Report, Federal Funding Accountability and Transparency Act (FFATA), PR-26/Consolidated Annual Performance and Evaluation Report (CAPER), and other research on an ad-hoc basis• Was awarded 2021 Efficiency Award for being the most innovative and proactive in streamlining departmental processes and procedures. Show less

• 

  Keter Environmental Services

  Feb 2022 - Mar 2024

  • Developed custom Power BI dashboards (backed by T-SQL, Power BI Dataflows and REST APIs) to inform board, executive, and upper management decision making; reports included topics related to Fleet, Procurement, Inside Operations, as well as KPIs for the board/C-Suite. • Provided production support for end users and stakeholders (user support) such as troubleshooting bugs, fixing broken data connections, and identifying the origin(s) of anomalous data.• Authored complex T-SQL queries and M syntax for Power BI reports and dataflows using methods such as temp tables, calculated table expressions (CTE) and data quality checking case expressions. In two instances queries lead to the identification of major bugs within existing stored procedures. • Envisioned and conducted an exploratory linear regression of equipment repairs on plausible independent variables (measures of frequency, content type, age, manufacturer etc.) to explore the viability of a repair vs replacement cost avoidance model.• Authored a Power BI sensor allocation model and reallocation workflow that preference ranked potential sensor assignments based on likely opportunities for service cost reduction. Show less

  • Business Intelligence Developer

    Nov 2023 - Mar 2024

  • Operations Analyst (Functionally BI Developer)

    Feb 2022 - Dec 2023
• 

  Insight Global

  Mar 2024 - Dec 2024

  Senior Systems Analyst (Data Engineer) @ Group 1001

  • Mapped Data Lineage on Stored Procedures and SSIS Packages for refactoring project into PySpark/Spark SQL on Azure Databricks.• Developed custom Power Automate flow and Power BI report to track manual file ingress receipt and completion against the team 48-hour SLA. Increased exposure and visibility created clarity of file arrival and required actions between business partners and operations staff.• Lead audit of sensitive user information in our bronze layer tables; wrote python User Defined Function (UDF) to query all bronze layer objects and return sample data, record counts, and PI/SPI/PHI classification to assist in calculating our required data breach insurance. • Lead in team revision of Scrum/Agile practices to improve increment delivery and burn down estimations.• Wrote various T-SQL Stored Procedures to transform data, performed black box, and regression testing of newly developed functions. Show less

• 

  Group 1001

  Dec 2024 - now

  Associate Director of Data Analytics