Monica Orth

Word 2002/XP Version

Summary of Qualifications:
Seasoned web developer with 10 years of programming experience. Specializing in application design and development for database centered web applications such as large volume content sites, personalized content sites, and commerce sites. Known for relationship and consensus building as well as strong technical and problem solving skills.

Professional Experience:
Shared Technology Services Group, Inc. (Plymouth Rock Assurance Company)

Software Engineer III, Applications Development Team	Oct 2004 - Feb 2008
Software Developer charged with the maintenance legacy VB/ASP websites and taking over projects in crisis status and delivering them in a reasonable amount of time. Shared Technology Services Group, Inc. provides IT services to six companies who provide Personal Auto, Commercial Auto, and Homeowners Insurance in four states.

	Acquired Audit, Balance, and Control (ABC) project from contractors and worked with another team member to not only deliver 32 new Control Points in 8 weeks but re-architect the solution to eliminate deployment issues that had been the norm for the previous 6 months. Refined and rolled out these control points to 5 additional insurance companies. Worked with Control-M team to get all control points automated and validated that they worked as expected. ABC has saved countless hours of work by identifying potential problems before they happen.
	Support, maintenance and enhancement of Enterprise ChoicePoint (ECP) WebSphere Web Service. ECP provides the primary interface to ChoicePoint. It requests reports from ChoicePoint and caches the results using Hibernate. Supporting this application also includes continued support of iSolutions VB Components, and interfacing with a third party vendor to report and get resolution to development and production issues.
	Delivered code and automation solution to interface with the MA Merit Rating Board. MRB is a java application, scheduled to run in Control-M. It connects to DB2 database to obtain data to create MRB Inquiry files and it calls Fiserv PolStar web services to update policies with the Responses from MRB that include accident and violation information. file reading/writing, database integration, XML parsing and updating, calls to web services.
	Implemented WebSite for Agent entry of NH Passenger Auto Policies in VB and ASP. This website was an extended one-off of an existing CT application that included minor re-architecting and customization of iSolutions components for connectivity to ChoicePoint through VB applications.
	First line support for NH, MA, and CT passenger auto new business and inquiry applications as well as general go to person for VB and ASP questions.
	Rescued crisis project that Integrated VB 6.0 Call Center application with GoldMine contact management system. Optimized performance reducing time to sync data between applications from 2 minutes to 5 seconds by replacing DDE calls with SQL Statements.

Staples, Inc.

Principal Programmer Analyst	June 2001 - February 2004
Software Developer tasked with various development projects often building stronger relationships with other teams or partnering with them to deliver their requirements. Bridged the gap between development and the DBA Team guaranteeing that the design needs of both groups were met simultaneously.

	Partnered with merchandising and usability teams to select a Web Analytics vendor and define detailed implementation requirements. Defined and documented architecture strategy for implementation.
	Attended 7 week Java/J2EE boot camp program taught using IBM WSAD. Mentored co-workers on final project which involved building a front to back end J2EE architecture using standard design patterns.
	Joined forces with SCRM Team to implement a proof of concept Application Deployment using CenterRun. Project involved full and upgrade deployments of Staples.com website code, MQ Series configurations, and database scripts.
	Reduced production membership database size from 60 Gigs to 6 Gigs with a new StaplesUser database architecture in SQL Server 7.0. New schema reduced profile updating errors by eliminating timeouts. New architecture made troubleshooting profile data issues much simpler. Developed all database tables and procedures for new architecture.
	Implemented VB 6.0 COM Component using COM+ Transaction Management to retrieve and update customer profiles in new Database. User profile data was passed to ASP front end in XML format using DTD Validation.
	Lead team to enhance performance of new membership ASP implementation rapidly exceeding QA’s testing requirements.
	Implemented migration of 2,000,000+ users profile data from Site Server LDAP to new database.
	Resolved production functional and performance issues using tools such as SQL Query Analyzer, Trace, SQL Profiler to isolate specific procedure, index, table and data issues.
	Reduced time to build a clean development environment and test production issues by automating all database build scripts as well as daily catalog data imports from production.
	Served as DBA for Development Team performing all Database Maintenance & Administration Tasks.

BabyZone.com

Senior Web Developer / SQL Server DBA & Architect	May 2000 – June 2001
Senior Developer at a very small .COM serving multiple roles including Architect, Developer, Mentor, DBA, Business Analyst and Project Manager.

	Converted website from FrontPage 98 to 100% ASP / SQL Server 7.0 site.
	Architected and developed personalization & paid membership model including data model, stored procedures and ASP code.
	Architected and developed pregnancy calendar which presented personalized content for women in their various stages of pregnancy from Conception, through Pregnancy then through Childhood. Content included regional events, chat schedule, baby book and journal entries and content relevant to their stage of pregnancy.
	Architected and developed system to send personalized newsletters to end users. Included user subscribe/unsubscribe, mechanism to physically send personalized emails, web presentation of newsletters, and link click tracking.
	Architected and developed logging and reporting mechanism for tracking site usage, specific site events (ex registrations and newsletter subscriptions), and errors (ex 404 and 500).
	Resolved production functional and performance issues using tools such as SQL Query Analyzer, Trace, SQL Profiler to isolate specific procedure, index, table and data issues.
	Served as Development and Production DBA. Developed and maintained all database maintenance procedures including backups and consistency checks.

MyWay.com (formerly PlanetDirect)

Hired on as a Web Developer, quickly adapted to new role as primary database architect and developer for a .COM Portal start up.
Software Engineer – Advanced Development Group	January 2000 – April 2000

Key contributor in Advanced Development Group responsible for version 3.0 Architecture. Wrote several architectural documents about data replication methodology and implementation, application partitioning and architecting the service for upgrades requiring zero downtime and no redundant hardware.

Software Engineer – Development Group

July 1998 – January 2000

	Architected data structures for the 2nd Generation Platform for MS SQL Server 6.5. Adding referential integrity, keys, and indexes to previously disorganized schema. Introduced concept of Design tools to staff.
	Managed the conversion of the 2nd Generation Platform database from MS SQL Server 6.5 to Oracle 8.0.5 including table and procedure and data conversions.
	Managed and participated in the conversion of the 2nd Generation Platform from MS SQL Server 6.5 to Oracle 8.0.5 including table and procedure conversions. Also was responsible for data migration from old Oracle schema to new schema, which entailed much data cleanup and script writing.
	Provided analysis of product group requirements and development of table structures and procedures for interim releases.
	Was involved in the hiring of several Oracle database developers.
	Resolved production functional and performance issues using tools such as Toad and SQL Plus to isolate specific procedure, index, table and data issues.
	Served as Development DBA in both Oracle 8.0.5 and SQL Server 6.5 Environments performing all configuration and maintenance required.
	Developed Opinion Feature using ASP for 2nd Generation Platform.

Powersoft Corporation / Sybase, Inc.

Systems Architect – On-line Community Project

January 1997 – July 1998

	Implemented and moderated On-Line community using NNTP News as a replacement for CompuServe and MSN Forums. The newsgroups served to allow end users to ask and answer questions about use of the products supported.
	Architected and developed client/server and distributed web based applications to maintain Newsgroup, Moderator, Team Powersoft / Sybase information in a Sybase SQL Server OLTP Database.
	Developed processes to aggregate and report on news server usage as well as archive messages.
	Designed, implemented & maintained the Powersoft Forum on MSN.

Electronic Services Specialist

July 1995 – January 1997

	Wrote the Web.PB Class Library that shipped with the Internet Developers Toolkit for PowerBuilder.
	Served as primary contact for a design partnership with a startup internet based technology company who’s application involved 3-D On-line User Training.

Technical Support Engineer

November 1994 - July 1995

	Isolated customer issues and where possible provided direct answer, education or sample code to meet customer’s needs.
	Specialized in troubleshooting issues between PowerBuilder and various back end databases tracing and interpreting internal calls made before, during, and after SQL Query/Procedure execution.
	Packaged and sent clear and concise examples of bugs to CIR team. Documented enhancement requests to submit to Product Management Team.
	Met or exceeded 10 call requirements daily with availability time often reaching 90%.

Associate Technical Support Engineer

April 1994 – November 1994

	As one of the original four frontline engineers was involved in the implementation of the frontline support engineer role and the establishment of guidelines for moving calls from the frontline to the backline.
	Role consisted of validating users as appropriate support contacts, entering in problem descriptions, attempting to solve the issue in a set period of time and promotion of Automated Technical Services such as CompuServe, MSN, www/ftp, FactsLine and our InfoBase CD ROM.

New Horizons Computer Learning Center

Instructor

January 1994 - March 1994

Taught PC Software courses to corporate clients. Applications include: MS Access 1.1, MS Word for Windows 6.0, PowerPoint 3.0 and Excel 4.0. Developed exercises and training methods for the classes taught. Also installed and acted as technical support to our in house Novell 3.11 network.