Wendy Douglass

Experience

• 

  Eckerd Connects

  Apr 1995 - Jun 2007

  • Managed the agency wide expansion of the client data system project to allow creation of client treatment plans on-line.• Designed and developed an expansion of the client system database to accommodate changes and new definitions of outcome measures and data analysis.• Programmed minor modifications to software utilizing Delphi and Microsoft SQL 2000.• Completed system implementation and on site clinician training for over 450 users in nine states on time and in budget. • Hired and managed report writers to upgrade and convert all client, clinical and billing reports for the new system. Developed database functions, data views and queries for reporting. Supervised their development efforts, accuracy of report data and development of data views. • Responsible for developing and managing the maintenance for a portfolio of reports from the client database.• Developed detailed training guides and implemented a plan to sustain training at no extra cost to the organization.• Supervised and trained technical support staff on the new application. Provided on-going training to the Totally Integrated Electronic Record(TIER) regional support staff • Developed plan to ensure continuing system data integrity in collaboration with Quality and Evaluation Department.• Provided project status reporting and briefing to Senior Management and the CEO. Show less • Gathered user requirements, analyzed business processes and developed technical and functional requirements for a new client database. Utilized logical data modeling and data flow modeling techniques. Microsoft Visio was used to document and model business work flow processes.• Analyzed reporting requirements and utilized Crystal Reports extensively to develop a wide spectrum of reports for daily operating, C level and management decisions, grants and external funding, client referral, accreditation bodies and billing for the organization.• Utilized Microsoft SQL Server 2000 and SPSS to pull various statistical data for statisticians.• Conducted business software training utilizing classroom presentation and one-on-one training styles for adult learners. Conducted train–the-trainer sessions for regional support staff. Develop customized training materials.• Wrote and updated user application manuals, training curriculum, internal policies, procedures and system documentation.• Provided technical and operational support to system users in over forty-three program offices via telephone, e-mail and on-site visits. Primary administrator in the analysis of problems, developing solutions, troubleshooting data and accounting strategies. Show less

  • Client Data Systems Manager

    Nov 2004 - Jun 2007

  • Client Database Administrator/Report Developer

    Apr 1995 - Nov 2004
• 

  Hillsborough County Sheriff's Office

  Jul 2007 - now

  • Researched, configured and implemented Smartsheet as the first consistently used portfolio management and project planning software in the agency’s history. Developed senior management and executive management portfolio and project level dashboards and reporting. • Led the initiative to implemented project intake and project management processes for more effective project and portfolio management. • Mentored IT Managers and less experienced project managers in project plan creation and use in managing projects. • Mentored project managers in use of Smartsheet, creation of reporting and application administration.• Provided regular project updates to senior level and executive management. Show less • Managed the Workday Enterprise Resource Planning (ERP) software project implementation. Investments in large enterprise scale projects traditionally take years, but this project was accomplished in twelve (12) months. This was a massive undertaking requiring full and participatory executive level support and strict project management with hard deadlines.• Responsible for all phases of project management alongside an Implementation Manager and consulting partners from the end of the RFI phase until after initial deployment.• Implemented Recruiting and Talent Management, Human Capital Management, Learning, Timekeeping and Payroll, Budgeting, Finance, Purchasing and Contract Management as well as Asset and Inventory Management.• Managed the Fleet Management system implementation. This was a major implementation in the agency and required coordination with several departments and later integration with Workday. I remained a technical support lead after the project was completed to assist the supporting department.• Managed project to deploy NAPA Auto Parts as an in-house vendor replacing the Fleet parts department. The successful completion of this project saved a projected annual reduction in the cost of auto parts at close to $200,000.• Managed the implementation of Samsara GPS/telematics cloud-based system for 50 vehicles in the agency as a pilot for future expansion. • Managed the reorganization and restructure of the Orient Road Warehouse. The project increased storage capacity resolved issues with storage of overflow of items from fleet and allowed for future growth. This saved the agency the price of constructing a new warehouse or the need to purchase additional buildings.• Served as business analyst as well as project manager for the Uniform Ordering Project changing existing manual processes for the entire agency. Show less • Led the BI team in the data warehouse project from inception to completion. • Documented the design, metadata and business rules for the system. • The project grew to span multiple years and included 90% of the Records Management System data, Computer Aid Dispatch (CAD) system data and incorporated data from three other agency data systems. • It became the main source for all crime analyst reporting. • Utilized Informatica for ETL development. • Architected, designed and developed BI solutions and dashboards utilizing MicroStrategy.• Acted as MicroStrategy Administrator and lead architect for over six years. Performed software upgrades as needed. • Worked as the SAP BusinessObjects Administrator. • Upgraded and maintained system for agency wide use, established and documented security groups, tested and published reports. • Reviewed all crime analyst’s reporting and mentored on correcting report performance and design issues prior to publishing. • Performed complex analysis on enterprise information systems using SQL, MicroStrategy and Excel. • Gathered user requirements, developed technical and functional requirements and produced reporting solutions from a variety of data sources for various departments across the agency using Crystal Reports. • Provided multiple classroom style trainings on Crystal Reports and the Data Warehouse data for agency Crime Analysts. • Mentored Crime Analysts and other ISD co-workers and provided direct support for Crystal Reports and the Data Warehouse. • Troubleshooting and supporting all BI related reporting and production processing.• Served as mentor to the new staff members of the BI team. Show less • Developed data views, database structure modifications and updates and data transformation packages utilizing Transact-SQL.• Developed reports for the help desk tracking system utilizing Crystal Reports.• Developed SQL process and workflow analysis/design for the employee Central Data Repository. The repository provides a central point for developers to access employee and other data allowing more efficient access management and maintenance.• Provided administration of Heat help desk tracking system and software modifications.• Completed the implementation of SAP BusinessObjects Enterprise reporting system. Responsible for system administration.• Completed Microsoft Certified Technology Specialist Certification (MCTS) Show less • Completed a detailed and comprehensive analysis of the agency’s paper-based fingerprint system. • Expanded the analysis to include a review of other agencies procedures and practices based upon on site interviews and observations as well as a review of available technology to automate processes and submit fingerprints electronically. • Wrote the RFI for the fingerprint project which resulted in the implementation of the Cogent fingerprint and facial recognition system. • Assisted with managing the project, scheduling vendor demonstrations, integrating with the FDLE Falcon system, benchmark and performance testing and user training.• Performed a needs analysis for the personnel Central Data Repository and developed the DTS package to load and update the data. Show less

  • Information Technology System Administrator

    Mar 2023 - now

  • Information Technology Portfolio Manager

    Mar 2022 - Mar 2023

  • IT Project Manager

    Jul 2019 - Mar 2022

  • Business Intelligence Report Developer

    Nov 2010 - Jul 2019

  • Crystal Report Developer

    Sept 2009 - Jun 2011

  • Business Analyst

    Jul 2007 - Sept 2009