Lisa Gard
Polk City,IA
Summary
Technology Analyst with well-rounded background implementing new technological solutions and improvements. Dedicated to achieving ideal results by identifying project goals, troubleshooting problems, and recommending solutions.
Overview
33
33
years of professional experience
Work History
Education Program Consultant
Iowa Department of Education
04.2014 - Current
- Develop ETL queries and processes for loading files into SQL Server and Adult Literacy software
- Create and edit tables, stored procedures, functions and views in SQL Server for Adult Literacy and community college data
- Use Visual Basic and SQL to run stored procedures directly into Excel files
- Created Tableau Dashboards for Community College annual and fall data
- Improve Community College WebMIS application, which validates and loads community college data, with rule modifications and additions
- Deliver training and support for Adult Education and Literacy (AEL) federal accountability system, Tops Pro Enterprise
- Perform quality testing on National Reporting System for Adult Literacy
- Responsible for annual federal and state reporting for Adult Literacy
- Matched data with external entities including National Student Clearing House, Diploma Sender, and Iowa Workforce Development to evaluate program success
- Provide monthly technical assistance trainings via Zoom Cloud Meetings for approximately 50 people
- Spoke at the National Association for Career & Technical Education Information (NACTEI) Conference and National Reporting System trainings
- Coordinate training events for data specialists
- Created webinars & federal requirement training videos
- Initiated and created google site for Adult Literacy team with appropriate internal and external roles and access; site includes forms to submit documents stored in corresponding folders
Technology Analyst
Iowa Department for the Blind
10.1996 - 04.2014
- Initiated, developed, and maintained accessible web-based case management system
- Studied business functions and evaluated requirements to establish operational objectives.
- Provided training and initial documentation
- Awarded “Team of the Year” for project by department
- Implemented and used as model at Nebraska Commission for the Blind
- Demonstrated features for Iowa Vocational Rehabilitation
- Added automated authorization system which reduced approval process from an average of 7 business days to hours
- Updated to ASP.net 4.5, SQL 2012 and Reporting Services
- Administer SQL and Access databases including importing and exporting of data, record deletions, stored procedures, functions, views, and job scheduling
- Provided various statistics and reports used for federal, state and department reporting
- Merged data from multiple databases to create centralized customer database
- Generate data files for mailings based on various criteria to target customers.
Assistive Technology Analyst
- Installed standard computer applications and screen reader software and hardware
- Developed windows tutorials for the blind including MS Windows, MS Word, MS Excel, and MS Access using two screen readers with project team
- Presented solutions for screen reader and application conflicts to small groups
- Documented first drafts and training material for tutorials
- Tested tutorials for accuracy, feasibility and user-friendliness
- Determined configurations for standard computer applications and screen readers to resolve conflicts and work efficiently.
Report Writer and SharePoint Administrator
WesleyLife
04.2011 - 11.2011
- Created and maintained Crystal Reports; extracted data from Pervasive database
- Administered corporate SharePoint 2007 site
- Updated content on public site
- Coordinated implementation of multiple online and point of sale merchant accounts
- Supported and resolved issues with clinical and financial software.
Help Desk Supervisor
AmerUs Life
05.1990 - 10.1996
- Supervised six employees who provided support 7 days a week
- Created and analyzed reports in Crystal for staff and management
- Reviewed and reported status of $300,000 annual budget
- Designed structure of department on-line documentation utilized to trouble-shoot daily problems
- Developed standards and procedures for the department.
Help Desk Technician
- Provided technical hardware and software support to approximately 1,200 internal employees at 50 remote locations and 4 local buildings
- Solved and interpreted customer questions on wide variety of applications in LAN/WAN and mainframe environment
- Created and determined screen and field requirements for call tracking software.
Communications Specialist/Systems Liaison
Midland Savings Bank
- Provided first-level support for staff
- Produced procedures for offices that promoted self-reliance
- Supported operations for ensuring bank offices would be on-line during “Floods of 1993”
Education
Bachelor of Business Administration Degree - Management Operations, Sociology
Iowa State University
Ames, IA1990
Skills
- Technical Knowledge
- SQL, Visual Basic, Visual Studio, ASPnet, Java Script, Visual Source Safe, SQL Server Reporting Services, Araxis Merge, Internet Information Services, MS Office, Visio, InfoPath, Crystal Reports, Tableau
Affiliations
Includes SharePoint site administration, Security Awareness, ASP. NET development, SQL transactions, project management, SSRS, SSIS, SSAS, Tableau, Crucial Conversations, and the Influencer
Timeline
Education Program Consultant
Iowa Department of Education
04.2014 - Current
Report Writer and SharePoint Administrator
WesleyLife
04.2011 - 11.2011
Technology Analyst
Iowa Department for the Blind
10.1996 - 04.2014
Help Desk Supervisor
AmerUs Life
05.1990 - 10.1996
Assistive Technology Analyst
Help Desk Technician
Communications Specialist/Systems Liaison
Midland Savings Bank
Bachelor of Business Administration Degree - Management Operations, Sociology
Iowa State University
Similar Profiles
KATE SMALLKATE SMALL
Program Consultant and Data Manager at Iowa Department of EducationProgram Consultant and Data Manager at Iowa Department of Education
Gabrielle McIlvanieGabrielle McIlvanie
General Merchandise Manager at Iowa Hawk Shop (Follett Higher Education)General Merchandise Manager at Iowa Hawk Shop (Follett Higher Education)
Stacey MeddStacey Medd
Reading Practicum Supervisor at University of Iowa College of EducationReading Practicum Supervisor at University of Iowa College of Education
Patricia PotichaPatricia Poticha
Barista at Scooters Coffee ShopBarista at Scooters Coffee Shop
Stacy StephensStacy Stephens
Paraeducator, Special Education at North Polk SchoolsParaeducator, Special Education at North Polk Schools