Sql Server Data
Resume:
Eric J Brosnan
Mansfield, MA 02048
*********@*****.***
Technical Skills:
MS Office Suite, MS Access 97 - 13, SQL Server 2000-08, Visual BASIC 6.0, WITT IV and Xper, Lumedx Apollo, Phillips Xcelera for Echo, Merge Hemo and Cardio, McKesson Spotfire, RedCap
Education:
Client/Server Certification, 2001
Bryant College: Bachelors Degree, CIS, 2000
Dean College: Associates Degree, Business Administration, 1994
Employment History:
December 2016 to Current
Dana Farber Cancer Institute, Boston MA
Data Analyst III
Develop, implement, and maintain multiple research databases in MS Access
Develop queries and ad-hoc reports as needed from a multitude of data sources
Create survey databases in RedCap software
Query data from multiple sources for principle study investigators
Query cohort data for clinical research studies
October 2001 to December 2016
Tufts Medical Center, Boston MA
Data Manager
Develop, implement, and maintain numerous custom clinical and research databases across The Tufts Medical Center Cardiovascular Center (Adult Cardiac Cath Lab, EP, Echo labs, & Cardiac Transplant) to support both clinical and business based decisions
Developed clinical study databases based on physician supplied clinical review forms
Worked on developing performance based dashboards for the dept. of Cardiology
Worked with principle stakeholders to ensure data completeness and integrity for multiple state and national cardiac registries (NCDR, Mass-DAC, ICD Registry, and STS)
Work with other managers to develop methods of retrieving, reporting, and recording department metrics for review in both standard and ad-hoc formats used in both clinical care and business decision making utilizing multiple sources of data (clinical, financial, and claims data)
Manipulate data from a variety of database (MS Access, proprietary, MS SQL Server) sources into useable formats (MS Excel, MS Word, MS Access, Crystal, SQL Server, Spotfire) for key stakeholders
Utilized electronic inventory capture system to enable better charge capture for case related equipment
Participated in decision making process for new software products utilized by business and clinical teams
First line of hardware and technical support for end users in Cardiology
Function as liaison to project management teams on new and developing applications and various IT related projects
September 2000 to October 2001
Convention Data Services, Inc., Bourne MA
Data Base Analyst
Developed databases in SQL Server and MS Access based on internal and external client requirements
Performed data cleansing to ensure integrity of recorded data utilizing stored procedures and views in SQL Server
Manipulated data in various formats from clients via Alpha IV software
Wrote guidelines and documentation for onsite end users utilizing new databases within SQL Server
Merged files of various formats (Excel, Word, delimited text, etc.) from clients into SQL databases utilizing SQL Server DTS functionality
Prepared standardized and ad-hoc reports per client request
March 1997 to September 2000
Kidde-Fenwal, Ashland, MA
Accounts Payable Specialist
Responsible for paying and reconciling vendor invoices in a multi-million dollar manufacturing organization in a timely fashion..
Maintained vendor relationships through interaction and problem resolution
Performed monthly journal entries’ in additional to producing month-end reports for key stake holders.
Participated in monthly and yearly closing functions.
Responsible for weekly check runs
Special projects and ad-hoc reporting done as requested.
Contact this candidate