John J. Brancaleon

**** ********* **** ? Naperville, IL 60540 ? acgf42@r.postjobfree.com ? Cell:

630-***-****

SUMMARY

30+ years of experience within the Information Technology industry.

20+ years of Visual Basic development experience (prior to .NET).

10+ years of VB.NET experience (Visual Studio 2003/ 2005/2010/2012)

7+ years of C#.NET experience (Visual Studio 2003/ 2005/2010/2012)

7+ years of ASP.NET experience (Visual Studio 2003/ 2005/2010)

12+ years of overall .NET experience

18+ years of SQL Server experience, 7+ years of Oracle database experience.

2+ years of Sybase database experience.

14+ years of experience using Access and Excel as analysis tools.

12 years of experience creating reports in Access and Crystal Reports.

26+ years of working on teams to successfully implement business solutions

performing the roles of developer, team lead, and team technical lead.

21+ years of consulting experience.

TECHNICAL SKILLS

Software: .NET Framework 1.0/1.1/2.0/3.0/3.5/4.0, Microsoft SQL Server

(2000/2005/2008), Microsoft Windows Server 2003/2008, Microsoft Windows 7,

Microsoft Windows 2000, Microsoft Windows NT, Microsoft Windows 98,

Microsoft Windows 95, Microsoft Office 1998 - 2012, Frontpage 2003, Oracle

8/9/10/11/13 Database, Microsoft Internet Information Server(IIS)

5.0/6.0/7.0

Languages: Microsoft ASP.NET, Microsoft C#.NET, Microsoft Visual Basic

.NET, Microsoft Visual Studio 2012/2010/2005/2003, Microsoft Visual Basic

6.0, Microsoft Visual C++ 6.0,

asp.net vb.net c#.net Visual Studio 2010 Visual studio sql server CSLAopen

access Jquery Nhibernate Oracle 11g consultant, fluent nHibernate Crystal

Reportswinforms refactoring ORM entity framework

EMPLOYMENT HISTORY

Sterling Engineering

Consultant - Township High School District 214 - June 2014 - Present

Responsibilities include helping to manage data for the conversion

from SchoolLogic to Infinite Campus applications by collecting data from

SchoolLogic's SQL Server database (SQL Server 2008) and formatting it for

the conversion website to go into Infinite Campus' SQL Server database (SQL

Server 2012). Rebuilt ASP.NET, C#.NET web-based applications that were

going against the SchoolLogic database to work with the Infinite Campus

database using Visual Studio 2010. Designing and building stored

procedures to collect data that will be exported to external systems (Sirsi

and Versatrans). Help with data validation between SchoolLogic and

Infinite Campus applications.

Consultant - OAS Software Corp Nov 2013 - June 2014

Responsibilities include adding new features to the client's existing

web-based, rPay.net application using Visual Studio 2010, VB.NET, ASP.NET,

CSLA and SQL Server 2012 ; debugging existing features based on issues

logged by QA; designing new tables and stored procedures in SQL Server and

debugging existing stored procedures.

Platinum Consulting

Consultant July 2013 - Nov 2013

Responsibilities include porting the 4D application to C#.NET

(Winforms) with limited refactoring. Working with OpenAccess ORM, working

with a team of developers to build the exact functionality as the existing

4D application.

Unite HERE Health

Senior Developer Jan 2012 - July 2013

Responsibilities include modifying and enhancing VB6 applications,

rewriting VB6 applications to ASP.NET using VB.NET (.NET 3.5), using JQuery

for validation and UI consistency, designing and building Crystal Reports

(v8.5), Building new ASP.NET applications (.NET 4.0) using Fluent

Nhibernate ORM, Working with Oracle 11g and SQL Server 2008 databases, and

building ASP.NET applications that use both Oracle and SQL databases,

designing and building SQL Server to Oracle applications in SQL Server.

Robert Half Technology

Consultant Aug 2011 - December 2011

Responsibilities include working on a diverse team (US, Canada and

Argentina) ; using an Agile methodology, adding features and functionality

to the Intelligence Portal using MVC 3, ASP.NET, C#.NET, Entity Framework,

using JQuery for validation and UI consistency, maintaining code versions

in Subversion; meeting deadlines within each 2 week sprint; designing and

building NUnit tests with NMock objects.

.

JSY Solutions, Inc

Senior Solution Consultant May 2010 - Aug 2011

Responsibilities include designing and building a membership-based

questionnaire web application for a professional association using ASP.NET

(4.0), C#.NET, and SQL Server 2008/2005; building a quoting system that

integrates with Great Plaines accounting using VB.NET, SQL Server 2005 and

SSRS; enhancing and modifying a Windows-based application for another

client using C#.NET, SSRS and SQL Server 2005; assisting a client to bring

a website back up after 3 years of being dormant, including migrating it to

another server, setting up the database, and rebuilding some of the code;

designing and developing web services and .NET code libraries to integrate

ADP's Sales and Use Tax API into other software packages including QAD and

Tigerpaw.

RCM Technologies, Inc.

Consultant (Aramark) Sept 2009 - Feb 2010

Responsibilities include adding functionality to the K12 projection

and budget applications, designing and implementing new processes the

enhancements, designing new reports using VB6, Crystal Reports, for the

application, building new Oracle stored procedures and updating existing

Oracle stored procedures.

MedVision, Inc.

Senior Developer Mar 2009 - July 2009

Responsibilities include adding functionality, correcting bugs,

and researching fundamental design flaws for their QuickCap application

using VB6 and SQL Server 2000/2005, designing new processes, resolving bugs

with Crystal Reports and mentoring peers.

Aptify

Lead Consultant Dec 2007 - Feb 2009

Responsibilities include designing and developing

customizations for their clients including WinForms-based wizards, SQL

Scripts, ASP.NET WebForms and event triggers on their custom framework for

Association Management based on the Entity Framework; Writing SQL and SSIS

packages to transfer the customer's existing data from their old system to

Aptify; designing and building customizations using VB.NET, SQL Server

2005/2008 and VB6.

Independent Contractor

Hubbard One

Consultant Oct 2007 - Dec 2007

Responsibilities include designing and developing

customizations to legal websites through their custom API set using C#.NET

behind ASP.NET 2.0, built upon SQL Server 2005 database

RAM Consulting

Consultant Apr 2007 - Oct 2007

Responsibilities include designing and developing an offline, web-

based application to be used by auditors on their laptops. The application

securely downloaded data from a SQL Server 2005 database (and into a SQL

Express 2005 database), allowed the auditors to perform the audit, and

securely upload the results back to the server. The laptop application was

built using ASP.NET and VB.NET with Visual Studio 2005 (.NET 2.0). Designed

and implemented an encrypted data transmission object to and from the

databases.

The Joint Commission

Consultant Aug 2006 - Mar 2007

Responsibilities include redesigning and coding classic ASP pages,

VB6 COM objects, doing Data Analysis on the SQL Server 2000 database,

building classic ASP web pages, QA testing and writing QA test scripts,

adding enhancements to an ASP.NET application with VB.NET code behind.

Omega Companies

VB.NET Developer Aug. 2005 - Aug. 2006

Responsibilities include designing and building a SQL Server 2005

database based on data in Excel workbooks and in an Access 2003 database,

designing and building a VB.NET WinForms-based interface to allow the user

to enter parameters to run one of three possible applications, Translating

VBA for Excel 2003 into VB.NET classes.

Independent Contractor

Wheels, Inc. Consultant - Visual Basic Developer April 2005 - July 2005

Responsibilities include working on a team to update and redesign the

Visual Basic 6 front-end of an existing application to use C#.NET Web

Services for the data, and add enhancements, working with other team

members to debug the Web Services and the SQL Server Stored Procedures.

W. M. Mercer

Consultant - Web Developer Sept 2004 to Jan 2005

Responsibilities include updating the reporting part of an existing

C#.NET web application to use 2 international accounting standards (IAS 19

and FRS 17), create charts for a web page using Office Web Components

charting facility, and working on a team to build a new web site, using

C#.NET, and ASP.NET with a SQL Server database behind it.

GE Medical Systems

Consultant - Demo Coordinator July 2003 to Sept 2004

Responsibilities include defining timelines for preparing the

software, hardware, and integration between software applications for

private demonstrations and trade shows, working with multiple development

groups to create timelines for adding features and integration into their

respective products and managing those timelines, building servers and

workstations and installing the applications, presenting timely progress

reports to upper management, correcting applications using C#.NET, VB.NET,

Visual Basic and ASP, making database corrections on a Microsoft SQL Server

database, shipping all hardware to the trade show or demonstration site,

and traveling to trade shows and private demonstrations to setup the

hardware and test it prior to the show or demonstration.

Rotary International

Consultant Feb. 2003 to June 2003

Responsibilities include developing Crystal Reports, ASP pages, and

XML pages, coordinating work with other team members to build ASP and XML

pages for Crystal Reports that they are working on, working with other team

members to debug ASP pages and Crystal Reports, following corporate

development standards and framework, create database VIEWS, Functions, and

Stored Procedures in an Oracle database, using PL/SQL, build additional

functionality to existing Visual Basic 6.0 applications while learning and

following the corporate standards and framework for Visual Basic

development, mentoring other team members in the use of Microsoft Interdev

6.0, Crystal Reports 8.5, and the XML 2.0.

University of Chicago Hospitals

Senior Specialist Jan. 2002 to Jan. 2003

Responsibilities included mentoring other employees in Visual Basic,

working with a team to maintain and support the Oacis gateway, help

maintain the Oacis Clinical Display version 6.40 application, taking a turn

in a rotation for 24/7 support for 1 week, maintaining and enhancing a

Sybase database which housed the Clinical Repository. Working with team

members to solve Clinical Repository problems and working together to

implement the solutions. Automate manual processes for our team to improve

efficiency for the person who is on-call using VBA for Microsoft Word and

VBA for Microsoft Excel. Use Microsoft Access to analyze data from the

Clinical Repository for reporting to users. Assisted Sybase developers with

converting queries to Oracle PL/SQL. Collaborated with other team members

to build a Visual Basic .NET monitoring system for the new E*Gate gateway.

DHS & Associates, Inc.

Consultant Mar. 1996 to Nov. 2001

Kemper Insurance, Inc.

Responsibilities include being part of a team to build an application

using Microsoft Visual Basic 6.0, Microsoft Visual C++ 6.0, IIS, Oracle

database, and Microsoft Visual Interdev 6.0 to redesign a web-based claim

capture application to Kemper standards and Kemper needs. COM+ objects were

created using both Visual Basic and C++. Other COM+ objects, written in

Visual Basic and C++, were modified to the business needs of the users.

Pechiney Plastics, Inc.

Responsibilities include being part of a team implementing a Web

based customer sales tracking system using Visual Basic 6.0, ASP, COM+, and

Visual C++ 6.0. Analyzing data in the SQL Server database to determine the

best way to display the information to the users. Work with team members to

create Visual Basic and Visual C++ COM+ objects to assist in retrieving

data from the SQL Server database.

First Health, Inc.

Responsibilities include being part of a team to build an application

using Microsoft Visual Basic 6.0 to manage dynamic, contractual

information, storing this information in an Oracle database. Analyze and

make recommendations as to more efficient database design and maintenance.

Working with others doing data analysis to determine the validity of our

data, and correcting it as needed. Create reports for the users, using

Microsoft Access, based on data analysis done by the team. Assist the user

community by making development recommendations based on my understanding

of the application and data.

Littelfuse, Inc.

Responsibilities include being part of a team to build an application

using Microsoft Visual Basic 6.0, interfacing with digital gages, hand

scanners, barcode printers, and SAP R/3, to capture data from tests that

the inspectors are doing to newly made fuses. Analyzing the best way to

work through a problem when dealing with outside vendors and recommending

solutions to these problems.

CNA Insurance

Responsibilities include being part of a team to build an application

using Microsoft Visual Basic 3.0 and Sybase database. Being a technical

lead for other team members as they learn Visual Basic. Work with the DBA

group to help setup a Sybase database. Documented the database so the other

team members will be able to understand and use the database within the

Visual Basic application.

TAP Pharmaceutical, Inc.

Responsibilities include learning building applications using Visual

Basic 4.0 to assist clients in storing documents into a Documentum version

3.1.5.2 docbase. Being the technical resource for Documentum. Installing

Windows NT Server 4.0, Oracle database 7, and Documentum 3.1.5 on the

development and production servers. Writing Microsoft C 5.1 applications to

test Documentum. Training other team members to use Documentum with Visual

Basic. Working with others to meet the goals and business needs of the

clients. Installing and supporting Windows NT and Windows 95 workstations.

Building solutions using internet/intranet technologies including Microsoft

Visual J++, Microsoft VB Script.

CNA Insurance

Responsibilities include being a technical resource for working with

a Sybase database loading data by building scripts and documenting the

scripts. Helping new employees to learn my job and responsibilities. Taking

requirements gathered by an Analyst and to database requirements.

Documenting the process to aid in knowledge transfer to the CNA employees

who were maintaining the application.

The Spectrum Group

Consultant Sept. 1994 to Mar. 1996

McDonalds Corporation

Responsibilities include building applications using Microsoft Access

connecting to SQL Server, Oracle, and DB2 databases under Windows 3.11.

Analyzing customer needs and requirements. Working with the various MIS

groups to assist in locating the data and rolling out the applications.

Working with other MIS people on a team, to create an Executive Information

System for all the Vice Presidents and the President, using Microsoft

Access.

Ameritech

Responsibilities include setting up an NT server and writing scripts

to convert the data for a FoxPro application. Work with other team members

to convert FoxPro data to SQL Server database.

Dade International

Responsibilities include working with others as a team to create

business solutions using Microsoft Access on Windows NT 3.5 workstations,

using a SQL Server database as our repository. Helping other team members

in solving development problems. Working with other team members to create

templates that assist in creating reports to meet future client needs and

requirements.

Uni*Quality, Inc.

Consultant Nov. 1991 to Sept. 1994

Abbott Laboratories

Responsibilities include answering client support questions at the

support center, going to the client to correct problems that may arise.

Support for Microsoft Windows 3.1, Microsoft Word for Windows, Microsoft

Excel, Microsoft Mail, Microsoft PowerPoint, Microsoft Access, Microsoft

Lan Manager 2.1 and 2.2, support for OS/2 Lan Manager servers, Compaq 286,

386, and 486 class machines. Create Windows applications using Visual Basic

3.0 Professional Edition.

Charter Electric Melting

Programmer Sept. 1990 to Oct. 1991

Responsibilities include: rewriting BASIC Programs from Apple BASIC

and QuickBasic 2.0 to Microsoft Professional

BASIC 7.1, data entry into Rbase, Rbase Programming, Novell Network

administrator support, Desqview 386 installation and operation, Assembler

programming, C programming, and working with Microsoft Windows 3.0.

Converted a program from QuickBasic 2.0 to Microsoft Professional

Development System 7.1 BASIC for a spectrograph. Wrote a program to convert

a text file to a DBF format to be transferred to our rolling mill.

Converted a program for simple interest loan calculations from Apple BASIC

to Microsoft Professional Development System BASIC 7.1. Wrote applications

using Rbase including purchasing and inventory systems.

Wrote a purchasing system using Foxpro including purchase order management,

receiving inventory, and inventory management.

EDUCATION

BA Computer Science, Bethel College, Mishawaka, IN

Microsoft Certified Product Specialist - July, 1995 Microsoft Access

Microsoft Certified Solution Developer - August 1995

Microsoft Visual Basic 6.0 Enterprise Development - July 1998

Microsoft Visual Basic 6.0 Desktop Development - August 1998

Building COM objects using C++ training - May 2001

Documentum System Administrator - August 1996

Documentum Application Developer - September 1996

ESPS Core Dossier System Administrator - December 1997

ESPS Core Dossier Developer - December 1997

Aptify 4.x Developer training

Aptify 4.x Administrator training

Aptify 4.x Fundamentals and Applications training.

References available upon request.

Contact this candidate