Bruce Como

Waterford, NY *****

518-***-****

acx1gz@r.postjobfree.com

Provide clients with project analysis, custom programming and database design/management

Design/Manage MS SQL Server

Data Analysis

Report writing

Develop apps for Oracle and MySQL

Skilled at data migration

Help clients define their needs

SKILLS

SQL Server 2000 through 2016

Database Design (normalization, primary keys, relationships, indexes, ERD diagrams)

Created stored procedures, functions, triggers, linked servers and synonyms

Implemented role-based permissions, and both Windows and SQL Server authentication

Implemented SQL Server field-level encryption, and VB.Net functions, on SQL Server 2012

Created single-field pivot tables in SQL

Created/used many-to-many tables when needed

Advanced T-SQL (Examples available)

Completed lots of data migration

Used Entity-Attribute-Value database tables (EAV) and created EAV-to-Table Transformations

IT Support

Windows Server 2000 through 2008 R2

Active Directory, Sharing, Permissions and Ownership

Professional Experience

Consulting Contracts

Project Analysis

March 2015 to October 2015

Philips Medical Systems – Latham, NY

Used SQL Server and Microsoft Access to import MS Project files and ShopVue data, and implemented COM to create Excel workbooks containing pivot tables/charts reports.

Created MS Access GUI for users to import MS Project files and create various Excel workbooks of pivot tables/charts.

Provided read-only queries for users.

Created MS Access routine that was called daily by a Windows scheduled task. The routine imported data from ShopVue’s SQL Server database, and loaded it into local SQL Server “report” database.

DBA of SQL Server database.

FileOne Exporter

January 2014 to October 2014

Excelsior College – Albany, NY

Created an application to transmogrify SQL Server and Oracle data, and export the results to Excel for statistical analysis.

Created GUI for users to choose the exam or exams they would like data for.

Transmogrify data using various statistical functions like standard deviation and point biserial.

Used .Net interop to create pretty Excel spreadsheet of exported data.

Exam Database

June 2012 to October 2014

Excelsior College – Albany, NY

Removed Microsoft Access user security from a 2007 frontend. Instead, Windows authentication was implemented on their SQL Server to accomplish user permissions.

Removed Access user security and the required mdw file from the Access frontend.

Replaced the above Access security with Windows authentication on SQL Server.

Implemented role-based permissions and Windows authentication.

Assigned network users to a role.

Created VB code in Access to automate various tasks including setting permissions on SQL Server objects based on role, and creating database links in the Access frontend application.

Documented all the steps required to accomplish various tasks for my Excelsior replacement.

Updated the GUI, reports and fields used by the users and system.

Migrated SQL Server 2000 to SQL Server 2012.

Created report generators.

Created .Net function inside of SQL Server 2012.

Created .Net application that copied Oracle warehouse data into SQL Server.

Set SQL Server permissions via T-SQL.

Fuel Billing System

July 2011-Present (ongoing client)

J&R Eldredge, Inc. – Lake Pleasant, NY

Upgrade a Microsoft Access 2000 system to version 2010 and SQL Server 2008 R2.

Upgrade MS Access 2000 system to 2010, including the run-time environment

Replaced failing Windows Server with new Dell server running Windows Server 2008

Vendor Score Card

January 2011 to April 2011

Danaher, Inc. – Elizabethtown, NC

Create reports from data imported from AS/400 to analyze Vendors’ delivery record.

Created a MS Access application that ran each morning to read an AS/400 text file, transmogrify it and push it into SQL Server.

Create second MS Access application to act as a Report Generator for users.

Report Generator for Clinical Database

July 2010 to December 2010

General Electric Research & Development via Vaudiosoft, Inc. – Schenectady, NY

Provide statisticians with an easy way to cull specific data from the millions of rows of clinical data.

Import spreadsheet, .csv and tab delimited data into MySQL database.

Convert data from normalized tables to Entity-Attribute-Value tables, and back (70M rows to 2M).

Inventory Reports

November 2009 to February 2010

Danaher, Inc. – Elizabethtown, NC

Created inventory reports from AS/400 data.

Created a MS Access application that ran each morning to read an AS/400 text file, transmogrify it and push it into SQL Server.

Created second MS Access application to act as a Report Generator for users.

RV Park Registration

July 2009-Present (ongoing client)

Lake George RV Park - Lake George, NY

Modify a VB6 backend database from Microsoft Access to SQL Server 2008.

Migrate backend MS Access database to SQL Server 2008.

Change existing DAO code to ADO.

Implement SQL Server field-level encryption for credit card data.

Produced proof-of-concept application using ADO.Net Synchronization Framework.

VB6 Remediation (Getting source code to run on Vista & Win7).

Using a 3rd-party control, created send-email-receipt-from-app feature.

Implement Heartland Credit Card DLL.

Copy Job Database

March 2009 to May 2009

Camelot Copy Center – Albany, NY

Developed an application to track production copy jobs and their status to be used by management and the production staff.

Gathered requirements, coded, tested application.

Designed SQL Server 2005 database.

Used an iterative process to design the interface and reports.

Dam Database

August 2008 to May 2009

Department of Environmental Conservation, Water Division – Albany, NY

Rewrote an Access frontend that was written in-house. Through multiple JAD sessions, determined the data to be collected and the functionality of the version 2 application, including reports. A report generator was designed for an often-used report that allows the users to determine the various criteria, sorting and grouping options on-the-fly. The application used Microsoft Access 2003 for the front-end and Oracle 10g for the data store.

Gathered requirements, coded, tested application.

Designed SQL Server 2005 database.

Managed project.

Parts Certification Database

January 2003 to April 2009

Anderson Instrument Co., Inc. – Fultonville, NY

Developed multi-user application that allows the user to test a finished part to ensure its within tolerance. Using a barcode scanner, the user scans-in the part model, and the program generates the data points used during testing. The program validates the user’s test values and, if the results are within tolerance, saves the data and creates a certification document to be shipped with the part. A separate component of the application uploads this data to the client’s website so customers can recreate the certification documents, as needed.

Gathered requirements, coded, tested application.

Designed SQL Server 2000 database.

Used an iterative process to design the interface and reports.

Return Material Authorization (RMA)

February 2002 to April 2009

Anderson Instrument Co., Inc. – Fultonville, NY

Developed multi-user application used throughout a $20M manufacturing plant. Besides data entry and reporting functions, one component of this application emails automated reminders to customers; a second component uploads data to the client’s MySQL database used by their website. Data was analyzed by 6-Sigma Black belt.

Gathered requirements, coded, tested application.

Designed SQL Server 2000 database.

Created an automated, server-side email reminder system.

Additional Work Experience details available upon request

Credentials

B.S. Electrical Engineering, Union College, Schenectady, NY

A.A.S. Computer Science, Fulton-Montgomery Community College, Johnstown, NY

Adjunct Instructor at Schenectady County Community College, Spring 2001 – Summer 2002

Awarded 2 Keane pins for client satisfaction

Client Letters of appreciation

Contact this candidate