Lisa Hoover

Experience

• 

  Aerotek

  Aug 1997 - Jan 2002

  Technical Analyst (@ General Motors)

  Contracted to General Motors Developed relational databases in MS Access for various purposes (single and multi user environments). Created many databases to interface with other software programs. Developed MS Access interface to manipulate data held in Oracle. Created an automated Access application that imported, processed and analyzed data from various Excel spreadsheets, transferred the data back into an Excel file and generated charts and graphs in Excel. Also coordinated migration from the existing MS Access based database to a combination Oracle/Access based database in our satellite facility. Designed databases from concept to implementation. Responsible for distributing, installing and training users for various database applications. - Created MS Access Application to pull data from five separate data management applications. - Provided Technical Support for hardware, software and network. - Desktop Publishing - Event Coordinator - Program Timing (Tracking) - Die Implementation Lead (Tracking)Environment: MS Access, Visual Basic 6.0, MS Excel, Visual Basic for Applications, SQL Show less

• 

  Hub Group

  Jan 2002 - Jul 2003

  Data Systems Manager

  Developed relational databases using MS Access 2000 for various purposes (single and multiuser secure environments). Databases interfaced with other applications. On site server administration. Administration of both Toshiba and Avaya multi line phone systems, including basic and intermediate programming. Responsible for physical maintenance and repair of all computer and phone systems. Coordinated all IT and phone related tasks during office relocation. - Network Administration - Phone System Administration - Hardware Technical Support/Troubleshooting/Repair - Software Technical Support/Installation/Troubleshooting/Instruction - Database Development and Administration - Data Warehouse Analyst - Team Leader of ISO 9000 Process Development Team - ISO Internal AuditorEnvironment: MS Access 2000, Visual Basic 6.0, SQL, Visual Basic for Applications, Win NT Administration, Windows 2000 Administration, Avaya Administration, Lotus Notes 5.0.8 Show less

• 

  Adecco Group

  Sept 2003 - May 2004

  Electronic Catalogue Coordinator (@ BASF-ART)

  Contracted to BASF-ART Developed relational databases using MS Access 2000 for various purposes (single and multi-user environments). Databases interfaced with other applications. Managed product catalogue of over 60,000 parts including annual batched price increases. - Database Development/Administration - Project ManagementEnvironment: MS Access 2000, Visual Basic 6.0, SQL, Visual Basic for Applications, Lotus Notes 5.0.8

• 

  MSX International

  May 2004 - Nov 2017

  Lead Developer (@ Ford Motor Company)

  Contracted to Ford Motor Company – Purchasing Information Management & SystemsDeveloped relational databases using MS Access 2000/2003/2010/2013/2016 for various purposes (single and multi-user environments). Databases interfaced with other applications. Developed and conducted custom training session for new MS Access users (Course Title: Using MS Access for Data Analysis). Analyzed purchasing data and processes for potential cost savings and procedure streamlining.- Team Lead for an 8 person team of MS Access/MS Excel VBA/Web Developers- Database Development/Administration- Data table development and administration in SQL Server 2008 and 2012- Developed Custom MS Access Training Materials- Software Instruction (Using MS Access For Data Analysis – Custom Training Course)- Process Efficiency Analyst- Data Analyst- Project Management- Web Administration (SharePoint Designer 2010 and 2013 and Dreamweaver CS6)- Provided Technical Support for hardware, software and network.Environment: MS Access 2000, MS Access 2003, MA Access 2010, MS Access 2013, MS Access 2016, Windows 2000, Windows XP, Windows 7, SQL Server 2008 and 2012, Visual Basic for Applications, MS Excel, MS Outlook, Dreamweaver CS6, SharePoint Designer 2010 and 2013, Adobe Acrobat 9 Pro, VCI, CPARS, eRoom Show less

• 

  Strategic Staffing Solutions

  Oct 2017 - Jun 2019

  Support DTE & BCBSM Contract – Developed metrics reporting solutions in various applications.- Managed a 4-person team of developers and analysts- Database Development/Administration- Web Administration (SharePoint Designer 2013)- Project ManagementEnvironment: MS Access 2016, Windows 7, SQL Server 2012, Visual Basic for Applications, MS Excel, SharePoint Designer 2013, MS Project Server, Business Objects InfoView, PeopleFluent, Power BI

  • Manager, Solutions Practice Shared Services

    Sept 2018 - Jun 2019

  • Business Analyst

    Oct 2017 - Sept 2018
• 

  MOTOR Information Systems

  Aug 2019 - Nov 2021

  Senior Technical Support Analyst

  Provide level 2 product support of multiple MOTOR data products. Developed relational databases using MS Access/SQL (single user and multi user environments) to research and manage high volume of customer cases. Analyzed case data for potential quality and productivity improvements.• Level 2 Product Support to National Account Customers (Multiple Products, Bulk Data and DaaS)- Manage support cases submitted through SalesForce, email and phone- Research customer concerns and provide findings to content for review and/or resolutions to customers- Monthly reporting of case load metrics to upper management• Database Development/Administration- Developed database application to automate the validation process of case completion to manage a large backlog of customer cases- Received 5 Star Productivity Improvement Achievement for 4th Quarter 2019- Received 4 Star Quality Improvement Achievement for 4th Quarter 2019• Project Management- Managed all levels of application development for database application projecto Initial proposal for approval of upper managemento Systems requirementso Developmento Testingo Supervised data entry from team of (4) analysts• Data AnalystEnvironment: MS Access (Office 365 Pro Plus), MS SQL Server Management Studio 2016, SharePoint Online 365, SharePoint Designer 2013, Power Automate, Salesforce Classic & Lightning, Power BI, Visual Basic for Applications, XML Show less

• 

  Robert Half

  Nov 2021 - Mar 2022

  Database Administrator

  Contracted to JOANN Inc.Project based assignment to repair and update an Access 2003 database that has not been maintained since 2019.- MS Access Database Administration- Repair/Update Custom User Defined Modules (SQL Code in VBA)- Advise business regarding updates and conversion to MS Access Office 365Environment: MS Access 2003, MS Office 365, SQL, VBA

• 

  Centric Consulting

  Mar 2022 - Oct 2022

  Business Analyst

  Contracted to Spinrite YarnsProject based assignment to complete analysis of multiple MS Access databases, SQL databases, ASC X12 EDI and business processes to provide recommendations and develop applications for improvement.- MS Access Database Development and Administration- EDI Analyst- Data Analyst- Process Streamlining and Automation- Technical Documentation Writing- Paired ProgrammingEnvironment: MS Access 2003/O365, MS Office 365, SQL, VBA, VBScript, JIRA, Sterling Gentran Director, RF Pathways WMS, Batch Scripting Show less

• 

  NuTechs

  Oct 2022 - now

  Business System Analyst

  Contracted to Pathward• Technical Team Liason - Responsible for communicating and tracking tasks for both internal and external IT groups• Testing Coordinator - Writing and administering test scripts, coordinating users and generating metrics for multiple projects (UAT)• Provided post deployment support to end users• Identify and mitigate project risks and issues to ensure successful project outcomes• Provide mentoring to junior business analystsEnvironment: MS Access 365, MS Office 365, SharePoint, VBA Show less