Melissa Gomez

• Project Management Coordination: Track and coordinate of all MPCA IT projects within the Project Portfolio Management software. Coordinate with Project Managers to insure project status information is current, complete and fully documented. Provide updates on MN.IT @ MPCA Intranet for customers to review. • Development of Project Management lifecycle. Creation of Project Readiness timelines utilizing Visio for IT Projects and Quality Assurance projects. • Develop metrics, tools and mechanisms to report the status of all projects and their major activities, including due dates, projects and results. • Use software tools (e.g. Innotas, MS Project, and Visio) to maintain the current status of IT and Quality Assurance Project Plans, Resources and Timelines. • For IT and Quality Assurance projects, I coordinate the planning, development and implementation of mechanisms to track the status of the projects. • Perform Quality Assurance lifecycle tasks and ITIL Foundations to collaborate with project team (BA, Developers, PM, Testers) to run Test Coverage documentation, Test Coordination documentation, Quality Control Summary, Traceability (MS Project), User Acceptance Testing, Test Scenarios and Test Cases on new application functionality and data. • Work directly with project team to develop strategies and gain understanding of Data Management for Data Migration projects as well as run Quality Assurance tasks. • Manage RSA Network Tokens: Coordinate and maintain the distributions of tokens for new employees, current users, and expired tokens. Work with the implementation of software tokens vs. hardware tokens to the agency’s staff. Documented process mapping and analysis (utilizing Visio) for RSA Token Process Improvement for an integration in a new software (BMC Client Manager - Footprints). Knowledge of Change Management, Problem Management, Knowledge Management, and Inventory Management. • Fiscal Procurement and Contracting Administration for @MPCA utilizing Financial Management Software (CPRS): Coordinate, prepare, audit, process, and monitor purchasing for MN.IT @MPCA staff. Review and track purchasing validity and run reporting processes to verify expenditures against budget. Interact with @MPCA fiscal coordination to obtain fiscal data for reporting needs. • CIO Support: Manage CIO calendar, Innotas time approval’s, set leadership agenda’s, maintain meeting minutes, staff notification forms, presentations, space coordination, and agenda development. • Proactively communicate with the Director of Development and Networking, GIS Management, Director of Projects and Services, and @BWSR Supervisor for Information Technology projects, process, standards, and procedures.

• Assist with system enhancements and testing's • Run QA and work with data migrations utilizing ArcGIS MapInfo for conflation • Knowledge of designing in AutoCAD for Engineering Dept (creation of telephony and construction sheets) • Maintain data quality utilizing several applications and systems for data accuracy • Knowledge of Microsoft Azure SQL Database, Configuring Firewalls for Azure SQL Database Server, Microsoft SQL Server Management Studio and Microsoft Visual Studio. • Perform SQL statements utilizing Postgres for application functionality • Knowledge in Python • Perform systems analysis support in the areas of specifications, design, testing and implementing solutions to support customer business solutions. • Proactively identifies and documents needs for changes to requirements. • Provides on call support for systems running 24/7. • Monitoring costs and resource estimates in accordance to the Broadband Service Availability System. • Delivers presentation to peers, customers and management when requested. • Remote desktop sharing tools (such as Lync and Skype for Business) • Creation of web applications utilizing HTML/CSS/Javascipt • Knowledge of System Administration: Windows OS, Microsoft Exchange, Active Directory, Memory Management, Processors, and Host.

• Perform tasks utilizing ESRI ArcGIS software and supporting extensions: Spatial Analysis, Georeferencing, Change Data Source, Data Reviewer, and TA Agent (batch validations). • Perform SQL and Python Scripting. • Perform Data Analysis on multiple projects. • Work with multiple sources for data conflation, migration, conversion and production. • Analyze data in the following softwares: ArcMap, Microstation, & Bentley Viewer. • Review Utility Mapping for Gas, Elec & Telco. • Create process documentation and training documentation. • Utilize Excel to generate reports: VLookup, pivot tables, shared workbook, formatting and calculations. • Quality Control and Quality Assurance. • Assist with production related tasks. • Knowledge of Electric Networks and Telecommunications. • Familiar with Safe Software FME.