Brian L. Caissie
** ********* ****, *********, ** 01606
774-***-**** *******@*****.***
TECHNICAL SKILLS
Software engineer with experience in multiple environments can design and develop programs using the most appropriate technology. Key skills include:
• C#, C, VB.NET, SQL, PL/SQL, T-SQL, ANSI SQL, VB 6.0, VBA (Excel), Win Forms,
• SQL Server, Sybase, Oracle, Ingres, Netezza, DB2, Stored Procedures, Triggers, XML
• SQL Server Management Studio, Cognos Report Studio, Crystal Reports, MS Access DB and Reports
• Data Junction (ETL), Data Modeling, Erwin, Toad, JIRA, SVN, Visual Studio 2019, Agile, Scrum EXPERIENCE
Casamba Wilmington, MA Senior Software Engineer 2017–2019
• Designed and added new functionality to the VB.NET, Win Forms internal configuration tool
• Team member that successfully converted the “FinanceWyse” Win Forms application from VB6 to C#.
• Added new functionality to the C# Customer “AdminWyse” Win Forms tool from functional specs.
• Provided bug fixes and new functionality in VB6, VB.NET and C# to various other company applications. Roche Diagnostics Westborough, MA Contract Software Developer 2015–2016
• Authored the “Hercules” Excel VBA/MS Jet Database program to import data from the new Roche Cobas blood analyzer. This program tracks analyzer results for the recent start of the analyzer FDA trials, increasing efficiency and ensuring the data was accurate and ready for FDA evaluation.
• Was the team lead and designer for the “Hercules” software and authored the detailed design, functional specification, test procedures, and test validation scripts. Constant Contact Waltham, MA Business Intelligence Reporting Analyst 2011–2015
• Worked with Data Analyst requirements to create and maintain BI reports. Created ad hoc reports from the data warehouse using the following technologies: Cognos Report Studio, Crystal Reports, Aginity, Toad, DB2, Netezza database and Excel.
• Created and modified Netezza stored procedures for the lead scoring project that allowed the sales team to first call prospects that have a higher probable conversion rate.
• Communicated with stakeholders to review and explain BI insights and maintain valued working relationships. Kronos Chelmsford, MA SQL Programmer 2011
• Provided data mining and validation support for Kronos sales team using SQL Server 2005 Management Studio.
• Maintained and modified stored procedures and SQL queries to support existing Excel 2007 reports.
• Created complex SQL Server queries for Excel 2007 reports. EPM, Inc. Framingham, MA Sr. Developer 2009–2010
• Designed, documented, coded and tested VB 6.0 Win Forms and VBA/Excel reports for the Edison/Safe nuclear plant design application interfaced to Oracle 10g and SQL Server 2005 databases.
• Modified existing SQL to comply with the ANSI SQL standard. Increased performance of several key reports.
• Implemented ANSI-compatible SQL functions that reduced code changes between Oracle and SQL Server.
• Completed VB.NET training in preparation for migrating existing VB6.0 code to VB.NET. 2007–2009
BRIAN L. CAISSIE 774-***-**** *******@*****.*** Page 2 Mercer Norwood, MA Sr. Database Analyst
• Provided ETL conversion/data mapping support via the Data Junction tool for Health & Benefits carrier files.
• Drastically improved performance of many existing SQL queries to run in seconds instead of minutes.
• Consistently received high marks from all the business analysts for competency and effectiveness.
• Debugged several problematic programs that other team members could not fix.
• Coordinated and managed tasks sent to offshore programmers.
• Ran quality assurance checks on work completed by offshore programmers. ADDITIONAL WORK HISTORY
Signal Integrity Software Maynard, MA Sales Account Manager
• Managed sales efforts from initial call to the award of the purchase order. 2004–2006
Fidelity Investments Merrimack, NH Software Developer
• Resolved all Y2K applications issues before the millennium occurred.
• Analyzed and modified existing systems developed in C, C++, VB and Sybase for Y2K compliance.
• Provided Oracle query and VB6 developer support to internal groups. 1997–2003
Communications Analysis Corp. Ashland, MA Software Contractor
• Designed and developed a VB6.0 to MS Access application to maintain phone traffic for commercial and military installations.
• Designed the entire MS Access database using data modeling normalization rules, and then moved the design to an MS SQL Server database.
1997–1999
Unifi Corporation Lowell, MA Sr. Database Engineer
• Using Oracle Forms 4.5, redesigned several existing forms that could not effectively be maintained because of spaghetti code and poor documentation.
1996–1997
Private Health Care Systems Waltham, MA Sr. Programmer Analyst
• Was hired for my Ingres database client-server expertise and my ability to learn new technology.
• Took the Oracle Forms 3.0 course in 1 week and immediately began to design, code and test modules of the PAS system that managed the entire network of healthcare providers.
• Promoted to senior level after only 1 year.
1995–1996
Raytheon Company Marlboro/Sudbury, MA Software & Hardware Engineering Specialist
• Developed C code for the Amsterdam Air Traffic Controller system
• Wrote Pascal program to create paper tapes for E-prom memory storage
• Computer hardware repair tech for the Patriot Missile system. 1983–1995
EDUCATION AND TRAINING
Clark University, Framingham, MA Client/Server Certificate Program Oracle-Certified Associate Passed SQL portion, preparing for the PL/SQL portion Courses Completed VB.NET; SQL Server 2008: Installing, Querying, Security; C++; JAVA, ASP 2.0; Unix Framingham State College, Framingham, MA Computer Science courses Northeastern University, Boston, MA Computer Technology courses Control Data Institute, Waltham MA Computer Repair Certificate Program