Senior Research Programmer/Analyst Resume Profile Andover, MA - Hire IT People

PROFESSIONAL SUMMARY

Experience throughout the systems development life cycle: requirements, design, development, testing, implementation, with special focus on data
Deep experience in data modeling, data migration ETL , data quality, and analytics
Experienced in assessing quality of clinical and claims data for analytics and research
Articulate, process-oriented, and analytical, strong in hybrid technical/business roles
MS from Tufts University in Engineering
Advanced SQL skills, experience
Certified Data Management Professional CDMP at the mastery level

TECHNICAL SUMMARY

SQL, Teradata, Microsoft SQL Server 2005/2008/R2, T-SQL, Oracle 11g, SQL Discoverer, PL/SQL, MS Access, Kimball methodology, Tableau, SSRS SQL Server Reporting Services, Excel PowerPivot, SAS, SSAS SQL Server Analysis Services, Crystal Reports, C, Python, SAS, VBA, Microsoft PowerPoint, Excel, Visio, OneNote

PROFESSIONAL EXPERIENCE

Senior Research Programmer/Analyst

Confidential

Lead initiative to implement Data Governance approach within the company
Co-author of enterprise strategic Data and Analytic Needs Assessment document
Develop master patient matching strategy to integrate claims and clinical data patient-centric master data management
Contribute to development of enterprise clinical data model
Draft metadata strategy for the enterprise and develop data dictionaries
Write SQL scripts to extract, transform and load ETL data elements useful for research
Lead initiative to select and adopt data discovery tools such as Tableau
Conduct data investigations to inform mapping between clinical vocabularies
Design and develop data quality metrics for clinical data sources prior to integration into the research data warehouse
Received company Values in Action award in 2014 for clinical data quality assessment
Selected to deliver presentation at Enterprise Data World conference on 'Evaluating Quality of Clinical Data for use in Healthcare Research'

Senior Business Systems Analyst

Confidential

Facilitated group requirements sessions with business stakeholders
Wrote detailed ETL requirements documents
Built data model using the Object Role Model ORM methodology
Developed detailed test plan for data migration ETL
Wrote ad hoc SQL scripts to reveal data integration issues to be addressed in migration

Senior Business Systems Analyst

Confidential

Analyzed database schemas and sample data for multiple source database formats to determine ETL data mapping requirements and expose integration issues
Facilitated schema design meetings with software developers and stakeholders, contributed to data model development, and gave presentations to clients at conferences
Built prototype business intelligence solutions using SQL Server Reporting Services and PowerPivot, including drill-down, drill-through, parameters, maps, and sparklines features
Re-wrote a key ETL process in T-SQL, shortening a 24 hour process to 28 minutes

Research Analyst

Confidential

Sought, obtained and evaluated statistical datasets with demographic and building data. Wrote T-SQL scripts to address data quality issues and transform into consistent spatial resolution.

We provide IT Staff Augmentation Services!

Senior Research Programmer/analyst Resume Profile

Andover, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship