Rick Pierce Email & Phone Number

Danvers, Massachusetts, United States

Senior Software Engineer at ISG

Monroe, Ct

Created product vision for a multi game logistics system and leads development team to define and build infrastructure, data and user interface. • Designed web based gaming logistics system (https://www.larportal.com) including security, event registration, surveys, notifications, character development, inter-game communications and point distribution.• Designed and created MS SQL database including all table structures and all stored procedures for insert, update and delete functionality to ensure standards.• Developed the majority of the system classes in C#.NET to create consistent data retrieval methods and create reusable code modules.• Developed user interfaces for several modules of the system utilizing aspx pages with C# sources. Made heavy use of class based calls to MS SQL backend to segregate front end pages from database.• Served as primary liaison with customers for system design feedback.

Merrimack, Nh

Created and maintained Microsoft Access front end / Oracle SQL backend applications for automating government mandated financial tests in compliance and asset management.• Integrated Microsoft Access with Oracle SQL using pass through queries.• Created user applications that integrated Microsoft Access, Excel, PowerPoint and Outlook using VBA script.• Worked with users for user acceptance testing.• Documented new and existing applications.

Shelton, Ct

Support performance and automation system projects by building and enhancing software for proprietary and licensed business applications and lead projects that improve overall reporting capabilities.• Developed insurance application systems for three large insurance carriers. Processes included creating aspx pages with C#.NET and MS SQL stored procedures for rate and plan validation, agent licensing and appointment confirmation, sftp connection and credentials and application information. Integrated CRM and QuickBase systems, including reporting and automated file uploads to carriers.• Developed an Excel VBA driven solution to convert over 30 carrier commission statements to automated imports which saved the finance department in excess of 200 hours a month.• Enhanced AgentCubed - a web-based sales lead and fulfillment system to integrate multi-channel leads including agent phone calls and business reply cards to improve performance measurement.• Led client onboarding for large multi-program implementation involving custom programing. Created web based fulfillment pages and web services for customer landing page lead collection using aspx, C#, MS SQL.• Maintained OEC application validation and upload systems, adding in new carriers on an on-gong basis. This required regular upgrading of aspx pages with C# code behind integrating MS SQL with Quickbase databases.

Shelton, Ct

Lead a team of developers to create systems that support HPOne’s member acquisition and brokerage units• Designed and built time tracking module in QuickBase to interface with pre-existing ticket tracking. system, improving project tracking and time projecting. Added enhanced functionality by integrating into a MS SQL database and creating stored procedures and automated jobs to produce reporting.• Managed multiple system development projects including defining scope, timelines, and project status reporting as well as managing capacity plans, schedules and budget.• Enhanced departmental quality assurance and documentation protocols that improved feedback and reduced project delays by 20%.• Partnered with clients and project team to improve business requirements collection, validation and user acceptance testing.

Originally hired to move the company from dependence on consultants for internal IT support and software development. I came in as the sole person responsible for everything from internal user support, network administration, software development, CRM administration and support, beta customer liaison. Over the course of twelve years I built up the department from a one person group to a full department of developers, network engineer, tech support and QA.• Developed and patented the first release of the company’s electronic web-based product (ECS), a digital signage / communications system, originally written in Visual Basic and ASP with SQL database back ends (http://ip.com/pat/US7743112).• Managed development and support desk teams, created backup/recovery plans and security policies, developed vendor relationships and sourced and procured all hardware and software.• Managed transition from a consultant-based, mainframe to in-house IT support of a server based Great Plains installation and supported users, troubleshooting, report writing and external system integration.• Developed Microsoft Access database driven reporting and additional functionality integrating the Great Plains SQL databases into external shipping, order entry, tracking and company’s electronic product.• Wrote VBA routines, forms and macros within Great Plains to increase efficiency and productivity.• Developed a management system that tracked ECS installations from completion of order, fulfillment of hardware, third party installation, and technical support.

Trumbull, Ct

- Developed COB Savings database to import data from corporate central processing systems for data analysis and reporting- Designed and developed a COB workflow management system (WOW) to prioritize, assign and track inventory based on parameterized settings per workflow. The system provides interactivity between audit and call teams as well as real time reporting for management.Note: The COB Savings database is still being used in its orginal format today and the WOW database was adopted corporate wide and converted into a multi-million dollar tool by their corporate IT using the design schema of the original Access/SQL database version.

- Managed a team of four in-house developers and one consultant- Directed development of all clients' custom order entry and fulfillment applications- Served as main architect of project specifications- Acted as primary liasion between non-technical clients / account managers and developers to ensure understanding- Directed a group of programmers in developing a warehouse management system- Designed a project management application for tracking and reporting status and costs of all programming projects, resulting in improved project estimates, better project tracking, personnel scheduling, hour tracking, cost management, deferred billing and in-depth management reporting

Nashua, Nh

- Managed a four person IT department- Successfully designed and installed seventy user LAN and built interface of client server system with legacy system (DEC VAX), including working with vendors, management and user training- Developed applications and reports for all departments- Wrote the following modules in their entirety: Bid / Estimate / Quotes Complete order entry system integrated with collections, finance, marketing and production Deferred income / coupon redemption system (specifically for living material / integration with laboratory suppy system) SKU management addition / maintenance / specifications system Engineering bill of materials GL / Budgeting system Returns management system- Designed and delivered curriculum for users in Microsoft Office (Word, Excel, Outlook and PowerPoint) and XENTIS report writing for ad hoc user needs- Speced and led Y2K conversion project for upgrading all legacy systems on the VAX