Bruce A. Bednarski

Freelance Database Designer & Software Designer

Location:Laconia, New Hampshire, United States
2 Skills
PO Box 116
Center Barnstead, NH 03225
978-758-7547 cell

· Debian Linux Web Servers / Ubuntu Linux Client
· PostgreSQL databases – Ruby on Rails, RESTful Web Services, Subversion code management / Capistrano / Redmine bug tracking and project management with wiki pages
· Windows 2000/2003 Web Servers / Windows NT/XP
· SQL Server 2000/2005/2008 - .NET C#, SOAP/XML
· Visual Studio Team Edition, Visual Source Safe, PVCS Tracker, MS Access
· ClearCase, ClearQuest, Control-M
· IBM AS 400 (iSeries), VIP Database extraction


03/08 - Present Cornerstone Software, Inc., Nashua, NH
Database Software Engineer
· Installed, configured and evaluated open source bug tracking software on a Debian Linux / Apache virtual server
· Ported license ************** software in MS Access to Ruby on Rails / PostgreSQL / Subversion / Capistrano
· Developed Common Login Validation RESTful Web Server using Ruby on Rails / PostgreSQL / Subversion / Capistrano lead a team of 3-5 developers
· Developed a Heath Saving Account Web Page using Ruby on Rails / PostgreSQL / Subversion / Capistrano
· Prototyped a Web Calendar application using Stripes help convert it to Ruby on Rails / PostgreSQL / Capistrano
· Maintained the EaglePro Asset based leasing software SQL Server 2005/2008 databases with 258 tables, 146 explicit relationships, many more implicit relationships, and over 480 stored procedures
· Improved performance of EaglePro UI C# .NET and SQL Server databases VSS / PVS Tracker
· Developed search down boxes for the EaglePro UI VSS / PVS Tracker
· Prepared a 111 page Transfer of Information EaglePro Data Model Document and 128 page power point slide show for 2 parts of a 10 session web-ex customer training class

2006 - 2007 Fidelity Brokerage Company Technology, Merrimack, NH
Senior Web Software Engineer worked remotely with a group in Dallas TX.
· Developed .NET/C# SOAP/XML Web Services and Control-M Batch jobs for the Bulk Order System/Material Management and Distribution System to be used by the Fidelity Branch Offices using ClearCase and ClearQuest and Control-M Batch
· Pro-actively worked with eDB group to develop and maintain the data model in Oracle PL/SQL code
· Added Standardized SOAP Headers to the Pre-Filled Forms Assistant Web Service
· Reversed Engineered the Sybase Data Model to port it to Oracle for the Sybase Elimination Project

2004 – 2006 CaLLogix (formally CallAbacus) Call Center, Manchester, NH
Senior Software Developer
· Improved the performance of a daily SQL Server 2000 daily batch job from over 4 hours to under 5 minutes
· Developed .NET/C#/SQL Server web application to allow clients to self register thus saving time and money
· Developed .NET/C#/SQL Server on-line billing system with the ability to see call reports saving billing and reporting time
· Developed .NET/C#/SQL Server application to collect information on company assets
· Developed .NET/C#/SQL Server outbound calling application for replacement workers using union rules
· Ported SQL Server Databases .NET web services and web applications from VA to NH
· Enhanced existing .NET web applications and SQL Server data models to help operator and administrators to better utilize the information

2003 - 2004 BVJ Company, Inc.
Software Consultant/Developer
· Using BVJ Web View developed and hosted an on-line .NET/C# SQL Server database web application to allow beverage distributor customers to see at a glance the age and accumulated balance of their accounts
· Moved open and closed invoices from the IBM AS 400 (iSeries) VIP database to MS Access staging database for movement to the SQL Server on line database
· Demoed BVJ hosted NET/C# SQL Server database web applications customizing them for potential customers and quoted hosting and enhancement costs

2002 Family Education Network, Boston MA
Software Consultant/Developer
FEN is responsible for a number of web-based products in use by teachers world-wide.
· Quiz Lab I to Quiz Lab II flat file .csv data migration to SQL Server 2000 database using Microsoft DTS tools
· Migrated 287, 108 teachers, 339, 248 classes, 1, 056, 310 students, 1, 079, 151 quizzers with 16, 645, 848 questions and 40, 440, 105 selectable answers, 9, 036, 252 student answers to SQL Server 2000 data tables
· Enhanced the data migration process to run it in under 10 hours
· Designed, layout and implemented data files, transaction logs, and index files that spanned six SCSI drives
· Installed Windows 2000, IIS 5.0, SQL Server 2000, Cold Fusion 5.0
· Generated and installed SSL Certificates on four HP LC2000 server machines, three web servers and one database server
· Installed extra disk drives on two Compaq P4 development systems

1998 - 2002 BVJ Company, Inc.
Software Consultant/Developer
· Developed PDM to Baan ERP XML bi-directional gateway program
· Added FDA regulation 21CFR11 (Part 11) Enhancements to a SmarTeam PDM system
· Developed Release Level Authorizations object based security for the PDM system
· Developed Engineering Change Order enhancements to the PDM system
· Developed database and Java Servlet web service portion of a web based Subscription Management System using MS Access and eRights/Oracle
· Extracted customer data from an old Burroughs desktop PC

Additional Experience with FTP, Help Desk Application, Data Warehouse, ASP, CORBA


University of Massachusetts, Lowell, MA
· Bachelor of Science, Mathematics

Worcester Polytechnic Institute, Worcester, MA
· Post Graduate courses in computer science
Skills (2) Rating
Database Design
Software Design