Experience

Actively Seeking

• Information Technology & Services
• 1 - 100 Employee

• Data Specialist

  • Aug 2018 - Present



Alegeus

• Waltham, MA

• Data Analyst

  • Mar 2017 - Jul 2018

  I am a Data Analyst/Technical Consultant /SSIS/SQL programmer in Alegeus' Data Solutions group. I am responsible for automating processes that required much manual manipulation involving EDI data coming from and going to clients. I accomplish this with a combination of SSIS packages, SQL queries/stored procedures and use of SSIS and other technologies to manipulate, verify according to business rules, and name according to client specifications, files going to/from Alegeus. I have also been instrumental in bringing in third party enhancements to SSIS and changing to corporate culture to be more amenable to these enhancements in order to accomplish my goal of automating processes whenever possible. Show less



ImmunoGen, Inc.

• United States
• Biotechnology Research
• 200 - 300 Employee

• Business Analyst/SQL Server Developer/Report Writer/ETL Developer

  • May 2014 - Sep 2015

  Understanding business processes of various groups involved in manufacturing in an FDA controlled environment (QA,QC, etc.) Serving as a liaison between the business users and the underlying SQL Server Structure Setting up an SSRS based reporting environment Writing SSIS packages Understanding business processes of various groups involved in manufacturing in an FDA controlled environment (QA,QC, etc.) Serving as a liaison between the business users and the underlying SQL Server Structure Setting up an SSRS based reporting environment Writing SSIS packages



Mass General Brigham - Salem Hospital

• Hospitals and Health Care
• 500 - 600 Employee

• Database Developer/Report Developer/System Analyst

  • Nov 2010 - May 2014

  Primary Report Developer for Enterprise Wide Healthcare Quality Reporting and Analysis Team Responsibilities include: • Gather user specifications • Analyze SQL Server Data Warehouse to match reporting requirements with data • Develop and Implement new database objects (tables, views) for reporting purposes • Create queries/stored procedures to meet reporting needs • Develop and implement reports using a variety of tools Primary Report Developer for Enterprise Wide Healthcare Quality Reporting and Analysis Team Responsibilities include: • Gather user specifications • Analyze SQL Server Data Warehouse to match reporting requirements with data • Develop and Implement new database objects (tables, views) for reporting purposes • Create queries/stored procedures to meet reporting needs • Develop and implement reports using a variety of tools



Cambridge College

• United States
• Higher Education
• 400 - 500 Employee

• Data Analyst

  • Dec 2009 - Nov 2010

  Responsible for developing automated processes for insuring the integrity of the College’s Admissions, Registration and Faculty data Wrote stored procedures, functions and SSIS packages to implement these processes Responsible for developing automated processes for insuring the integrity of the College’s Admissions, Registration and Faculty data Wrote stored procedures, functions and SSIS packages to implement these processes



Outside The Classroom

• Database Administrator/Developer

  • Jan 2008 - Nov 2008

  • Responsible for the company’s database that supports their online Alcohol Education program. o Database Administration, Performance and Tuning o Writing and modifying queries and stored procedures to meet business needs usinng TSQL on SQL Server 2000 o Creation of new database tables to support increased business needs. o Administering Report Creation System • Responsible for the company’s database that supports their online Alcohol Education program. o Database Administration, Performance and Tuning o Writing and modifying queries and stored procedures to meet business needs usinng TSQL on SQL Server 2000 o Creation of new database tables to support increased business needs. o Administering Report Creation System



Lasell University

• United States
• Higher Education
• 300 - 400 Employee

• Database Developer/Analyst

  • Apr 2002 - Jan 2008

  • Managed campus wide administrative system from third party vendor. Determined user department’s business needs and determined the optimal manner to utilize the system to meet those needs. • Wrote subsystems to provide added functionality not in vendor product • Primary Report Creator for the College. Wrote and modified reports using primarily Crystal Reports • Developed data stores (data models) to present data to end users in a manner enabling them to do their own reporting • Served as Database Administrator (DBA) for Microsoft SQL Server 2000/2005 servers • Wrote DTS scripts for data import Show less