John Lyon Email & Phone Number

United States

Hiring our Heroes Fellow and aspiring Business Analyst with Coastal Cloud.

Austin, Texas Area

Virtual Salesforce Administrator, providing administrative and consultative services to local and national non-profits. I worked with third party apps, including FormAssembly, Declarative Lookup Rollup Summaries, and Duplicate Check. I researched potential solutions and made suggestions to clients, such as potential solutions for text message integration, and relationship mapping. I implemented process changes for a national client that decreased the daily data upload process from an hour and a… Show more Virtual Salesforce Administrator, providing administrative and consultative services to local and national non-profits. I worked with third party apps, including FormAssembly, Declarative Lookup Rollup Summaries, and Duplicate Check. I researched potential solutions and made suggestions to clients, such as potential solutions for text message integration, and relationship mapping. I implemented process changes for a national client that decreased the daily data upload process from an hour and a half to thirty minutes. Show less

Austin, Tx

Meals On Wheels Home Repair Program provides critical life safety repairs and accessibility modifications for low income homeowners, qualified veterans and renters in the Central Texas region, using a mix of federal, state, local and private funding sources. The $3,000,000 program completed 257 projects on 178 homes for Fiscal year 2017/2018.I led the Home Repair Department’s transition from a white board and Excel, to Salesforce, collaborating with our Salesforce consultant on needs… Show more Meals On Wheels Home Repair Program provides critical life safety repairs and accessibility modifications for low income homeowners, qualified veterans and renters in the Central Texas region, using a mix of federal, state, local and private funding sources. The $3,000,000 program completed 257 projects on 178 homes for Fiscal year 2017/2018.I led the Home Repair Department’s transition from a white board and Excel, to Salesforce, collaborating with our Salesforce consultant on needs assessment and business processes for the new org. The processes that we implemented facilitated a 125% increase in number of applications sent to clients (330 - 750 applications per year over four years), a 130% increase in number of projects completed per year (86 - 200 projects) and 100% increase in yearly repair spending ($1.5 million to $3 million.) Through Nintex DocGen, my administrative team saved approximately 20 minutes per application (or about 250 hours a year for 750 applications). Instead of finding, printing and manually filling out applications for clients who required extra assistance, team members could print pre-filled applications in one step.In addition to managing my team of 3, I administered our 10 user Salesforce org, adding users, creating cross object formulas, roll ups and fields. I also created additional Salesforce objects and master/detail relationships to facilitate accurate reporting on contractor invoices against grant funding. I put together Salesforce reports and dashboards to provide home repair managers a 360° view of the home repair pipeline and grant spending, as well as providing data to our grant writers. Show less

Austin, Texas Area

● After completing year of service as Americorps VISTA, hired on full time to stand up brand new Summer Food Program.● Managed all aspects of program, including competitive bid process for meals, hiring and managing team of six, training team members and Summer Food sponsors, tracking data and ensuring program administered in accordance with Texas Department of Agriculture and US Department of Agriculture guidelines.● Created management plan which decreased number of meals ineligible… Show more ● After completing year of service as Americorps VISTA, hired on full time to stand up brand new Summer Food Program.● Managed all aspects of program, including competitive bid process for meals, hiring and managing team of six, training team members and Summer Food sponsors, tracking data and ensuring program administered in accordance with Texas Department of Agriculture and US Department of Agriculture guidelines.● Created management plan which decreased number of meals ineligible for reimbursement from 18% in 2010 to 12% in 2011, resulting in approximately $7,000 increase in reimbursements.● Supported Central Texas Food Rescue Program, assembling data from program requirements, scheduling system and warehouse system to provide details on performance, providing management information needed to begin scheduling/routing pilot.US Department of Agriculture/Texas Department of Agriculture Summer Food Service Program provides summer meals to disadvantaged and under-served children while school is out and school lunches are unavailable. Planned, launched and managed first two years of Capital Area Food Bank (CAFB) Summer Food Program, managing a team of eight, including 4 drivers, 2 compliance monitors, 1 program admin and 1 AmeriCorps member.Central Texas Food Rescue (CTFR) program rescues wholesome, but unsalable food from supermarkets for distribution to CAFB Partner Agencies. For 2011-2012 fiscal year, CTFR brought in 7 million pounds of food from 119 retail stores (Wal-Mart, H-E-B and Target). Show less

Austin, Texas Area

As an intern, I helped ensure the efficient and effective operation of Representative Strama's Capital office, including general administrative duties, data entry, assisting in resolution of constituent issues and casework, researching and drafting fact sheets and background memos.

Austin Tx

● Provided network administration of Quality Assurance Department’s LAN.● Saved the New Media department up to $60,000 yearly by migrating QA testing PCs and Macs to a standard platform and using standard operating system images.

St. Louis Mo

● Provided system administration of law firm’s six-city Wide Area Network and servers.● Upgraded outdated DOS/Windows PCs and NetWare 3.11 servers with Windows 95 and NetWare 4.11,reducing number and duration of help desk calls and eliminating many trips to remote offices.

Greater St. Louis Area

● Network administrator of law school NetWare and Windows NT servers.● Provided technical support for hardware, software, Internet and Local Area Network to faculty, staff and students.

Bloomington, Indiana Area

● Provided technical support for hardware, software, Vax/VMS, Internet and LAN to faculty, staff and students.

Bloomington, Indiana Area

● Wrote training documentation and trained Thomson employees on PC essentials.● Wrote lock-out tag-out procedures for compliance with OSHA safety regulations.

● TS/SCI Clearance.● Using VAX 11/785 mainframe computer, ran reports and produced documentation for disseminating Electronic Intelligence (ELINT) products to 6th Fleet assets in accordance with fleet and national tasking.

Ba, Public Administration

Activities and Societies: Alpha Sigma Lambda Honor Society Graduated summa cum laude

Certified Salesforce Community Cloud Consultant

Successfully completed certification requirements 6/1/2019

Certified Salesforce Administrator

Successfully completed certification requirements 11/15/2018