Matt Ramsey Email & Phone Number

Hilliard, Oh, Us

Easton

Hilliard, Oh

• Responsible for enterprise wide database performance and multiple application environments and configurations.• Developed and maintained monthly software release schedule for multiple application development teams.• Responsible for configuration and maintenance of all application environments including environments for development, quality assurance, training, demo and production.• Successfully implemented data archiving strategy reducing the production SQL database by 70%.• Managed team of 6 DBAs and 3 Configuration/Release Specialists.• Streamlined software release activities and automated environment synchronization after successful deployments.• Managed team responsible for implementing encryption at rest for SQL data containing sensitive client information.

Hilliard, Oh

Dublin, Oh

• Manage Enterprise Software Application Portfolio. Application Portfolio includes Self-Insured Group (SIG) policy management application, Ohio state fund group rating application and claims management software for worker's compensation and ALGL (Auto Liability/General Liability).• Manage multiple software development teams on various application development projects.• Perform project management functions for web-based Claim Audit Review software written in C# and SQL 2005.• Plan and coordinate software releases for SIG policy management application and Ohio Group Rating application written in VB and SQL 2005.• Work directly with end-users and business community to define business requirements.• Perform Joint Application Development (JAD) sessions with business process owners and managers.• Effectively communicate technology to business process owners through application demonstrations.• Assist sales staff with software demonstrations for prospective clients.• Plan software development initiatives based on direction from Executive Leadership Team.• Manage software development requests and bug fixes using Microsoft Team Foundation Server.

Dublin, Oh

Performed detailed systems analysis and design for SIG policy management application. (The SIG policy management application is used to calculate premiums and generate policies for SIG participants. The system processes over $100 million in premiums annually)Developed normalized table structures and relationships in SQL 2000 (34 tables in SIG application database).Converted all data from legacy system to new SIG policy management application using SQL DTS and stored procedures.Effectively planned and executed conversions of legacy systems under critical timelines due to corporate merger.Successfully converted complex premium calculations from legacy systems.Effectively communicated development efforts to corporate managers and executives.

Dublin, Oh

Application DevelopmentCreated product development roadmap for all application development initiatives.Managed development team consisting of 15 software developers and 3 systems engineers.Responsible for enforcing SAS-70 compliance throughout Software Development Life Cycle.Responsible for software development strategy and system architecture.Worked directly with executive leadership team to develop strategies for marketing RMIS applications.Presented product development roadmap to all corporate managers at annual managers meeting. Performed as guest speaker at Risk Management Software Summit

Dublin, Oh

Performed all phases of Software Development Life Cycle (SDLC) for Ohio State Fund group rating application. (Group rating application contains modules for all functions of the group rating process including call queues for soliciting group participation, premium projections, complex group modeling and generation of group offers. The system generates over $10 million in revenue annually.)Developed group rating application using VB and SQL. (Application performs BWC calculations for premium projections for over 15,000 employers annually)Increased modeling efficiency from legacy application. Modeling calculation time was reduced from over an hour to less than one minute. Designed SQL table structures and data models for storing Ohio BWC information.Designated Subject Matter Expert (SME) for all Ohio Bureau of Workers' Compensation systems.

Dublin, Oh

Developed Unemployment Compensation (UC) software for tracking unemployment claims using Visual Foxpro.Developed Unemployment Compensation Tax System. (UC Tax System was used to perform complex tax calculations for employers in all 50 states)Engineered Common Rating program to combine employer experience in order to reduce premiums.Performed detailed business analysis of unemployment compensation line of businessDesignated Subject Matter Expert (SME) for all Unemployment Compensation services.Promoted to Lead Software EngineerLogistics Techniques

Dayton, Ohio Area

Developed Funds Allocation System (F.A.S.) for the United States Air Force using Visual Foxpro.Performed bug fixes and software enhancements