John Messimer Email & Phone Number

Pennsylvania Department of Education, Teachers’ Information Management System (TIMS) Design (Carol Shaw, PM)TEK Systems• Validated conceptual data model, developed physical and logical models. Continued to refine conceptual data model as the result of validation and testing.• Researched and wrote all requirements to populate new TIMS database from the existing TCS database. Identified data integrity problems in existing TCS database. Developed auditing procedures to confirm/validate conversion.• Wrote specifications and loaded all “day zero” code and association tables.• Wrote testing procedures to validate all associations and relationships in new TIMS database.• Worked closely with Project Manager to develop schedule (MS Project) and assure that project stayed on schedule and within budget.• Utilized tool sets in SQL 2008, VISIO and Erwin.

Pennsylvania Department of Education, Teachers’ Certification Requirements Gathering ProjectJAG ConsultingSenior Business Analyst• Utilizing elicitation procedures such as Focus Group Sessions and Interviews with Subject Matter Experts, gather information on the current Department of Education Teachers’ Certification System. • Document workflows, business procedures, and of the present certification system. • Identify current interfaces and opportunity for future interfaces. • Gather requirements for the new Teachers’ Certification system to include certification, continuing professional education, teacher employment history, disciplinary action resolution, and appeal processes. • Represent requirements for the new system as UML Use Case diagrams supported by artifacts such as detail work flow narratives and requirement statements.• Current system is a mix of custom software and COTS products.• Maintained working documents in AquaLogic collaboration software.

Workers’ Compensation Requirements Gathering ProjectMindteck (subcontracted through Momentum, Inc.)Senior Business Analyst• Utilizing elicitation procedures such as Focus Group Sessions and Interviews with Subject Matter Experts, gather information on the current Department of Labor & Industry Workers’ Compensation System. Identify stakeholders and external customers.• Prepare written documentation of the current “as-is” Workers’ Compensation System. Documentation artifacts include written Process Description documents and UML Use Case Diagrams to represent current business processes.• Develop requirements for the “to-be” system by creating a Requirements Traceability Matrix. Roll business function requirements up into common system requirements. Identify risks and develop system glossary.• Current system is a mix of custom software, Access applications and COTS products.• Maintained documents in AquaLogic collaboration software.

* PM-managed customer implementations, conversions and upgrades: transition from legacy to client/server. * Senior BA for three large Telco accounts, gathered information and bus reqs, conduct research, kept abreast of business & trends. Coordinated the development of procedures & training. Authored test plans, executed testing, analyzed results. Conducted weekly status meetings. Assure that all SLA’s were met. * Researched & resolved problems with usage records sent from switches and tandems. Resolve issues with SECABS & meet point files. Used SQL to analyze files.* Excellent oral and written communication skills communicated to all levels of Intec management and customers. * Represented Managed Services to Intec corporate management & the global sales force. Utilized a complicated Excel spreadsheet, prepared cost estimates for Managed Services projects. Developed statistical analysis tools and refined standards. Performed gap analysis for system functionality.

Business Analyst & Project Manager – Old Guard Insurance Co.• Project Manager & Business Analyst for implementation of agency upload/download process. Utilized my industry knowledge to identify business requirements and expectations to create a system solution. Interacted with Old Guard management, IVANS, and agencies. Developed test cases. Researched and resolved problems. • Liaison between agency and Old Guard to promote upload/download process.• Researched and resolved compatibility and data formatting/transmission problems between Old Guard, IVANS and agency