Debra Gerrish Email & Phone Number

Responsible for managing customer relationships with current and potential customers for our IWorks Premium Billing system. Developed and maintained all test cases for each client’s SQL or Oracle environment. Preformed user acceptance testing, unit testing and functional testing in a .NET environment. Managed and supported production and test environments. Coordinated and prepared code releases for development team. Analyzed and resolved configuration or system failures when necessary. • Client database creation and management (Sql2005 or Oracle10g), configuration of billing code and rule tables , application product installation, regression, parallel and error testing, include WebUI, Web Service and Web based application testing.• Reviewing XML for data integrity• Testing new releases o Developed and executed test matrices and test cases (use cases)o Responsible for testing Web UI, Web Services, Web Methods written in C# and Crystal Reportso Wrote DOS scripts to automate the testing procedure used for Parallel testingo Wrote SQL scripts to maintain data in tables and create reportso Prepared release notes for system upgradeso Troubleshooting o Documented and tracking of all issues found. Reported issues to developmental team.• Prepared user documentation for the IWorks Premium Billing System and conducted product training using WebEx.

Responsible for strategic product development and project management of Concord’s Billing and Agency applications. • Tracked and monitored activities and results, providing information to the senior management team that was vital to the organizational decision-making.• Member of 11 person team responsible for all phases of systems project life cycle of integrating the Web based Policy Management System to Billing, reporting, printing and ACORD download. Also integrated the Billing system to reporting, printing, and payment systems utilizing SQL, C#, Biztalk and IIS. • Responsible for data mapping and integrating an existing legacy system (Unisys Mainframe Cobol) to a new web-based Policy Management System (.NET).• Developed and executed test cases for user acceptance testing, functional testing, unit testing, load and stress testing in a .NET environment.• Worked closely with the organization’s business team to define project requirements.• Analyzed and resolved a variety of issues between the policy, billing, reporting, printing and payment systems, determining the root causes of problems to develop sound solutions.• Re-evaluated the auto XSD and made changes to tightening up the controls. • Billing system: Install, train, maintain, and troubleshoot in the test, QA and production environments. Includes: SQL Database, Web Services, Rule Tables• ACORD download: o setting up new clientso trouble shooting and investigating Management System rejections in AMS/AFW, Sagitta, Prime 2000, Applied Tam, Vision and Doris.o maintain the Ivan’s script and production schedule• Mainframe Unisys platform: support and maintenance of existing homeowners and auto insurance, billing and deposit systems