Uploaded File
add photo
Duncan
dhenry@llu.edu
909-488-1365
Star, ID 83669
Senior Business Intelligence Analyst
20 years experience W2
0
Recommendations
Average rating
15
Profile views
Summary

  • Hard-working, goal-oriented analyst with experience juggling multiple high priority projects. Proven ability to communicate with stakeholders and users at all levels. Dedicated to providing value through effective use of technology, collaborative relationships, and process improvement.

Expertise

  • Databases: MS SQL Server, HP Vertica, hsqldb, sqlite, Infobright, mysql, postgres
  • Languages: SQL/T-SQL, Java, Python, javascript, HTML, XML, CSS
  • Software: Pentaho Business Analytics Suite, Apache Directory Studio, Tableau, VirtualBox, Crystal, WinSCP, putty, LiquidOfficev

Experience
Senior Business Intelligence Analyst
Information Technology
Jan 2011 - Jan 2016

Business Intelligence Analyst for 900+ physician practice. Promoted to Senior BI Analyst in recognition of leadership role within the Decision Support department. Designed data transformations to support variety of use-cases. Worked with both internal and external teams to process data exports/imports. Responsibilities extended beyond the back-end and included creating user-facing content, administering access, and troubleshooting user issues.

Highlights:

  • Developed and optimized Kimball-style data warehouse to support transition from IDX/Cerner to Epic.
  • Led migration to analytic database resulting in dramatic performance improvements and reduced administrative overhead.
  • Oversaw multiple hardware, software, and database migrations/upgrades.
  • Responsible for department hardware and software infrastructure, including acquisition, installation, and maintenance.
  • Worked directly with end-users, group administrators, and senior leadership to provide accurate and timely information.
Business Intelligence Data Warehousing
Remove Skill
Programmer Analyst
Information Technology
Jan 2006 - Jan 2011

Provided application support and process automation to Institutional Review Board, Institutional Animal Care and Use Committee, Sponsored Projects Financial Management, Clinical Research, and Intellectual Property Management departments. Highlights:

  • Migrated users from shared Excel workbooks and MS Access databases to modern e
  • forms and robust data storage.
  • Prototyped initial transition to web-based in-house workflows using PHP/Zend/JQuery/CSS
  • Reverse-engineered legacy applications to enable continued functionality
Microsoft Excel
Remove Skill
Database Programmer
Information Technology
Jan 2002 - Jan 2006

Long-term large population study involving tens of thousands of participants, hundreds of survey questions, and clinical data samples. Responsibilities included database administration, data manipulation/extraction for statisticians, and writing custom applications to support office and analytical operations. Highlights:

  • Automated data ingestion processes.
  • Implemented extensive data validation measures.
  • Averted catastrophic data loss by following database management best practices.
DBA
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in n/a
SOUTHERN ADVENTIST UNIVERSITY 2004
Skills
Business Intelligence
2016
5
Data Warehousing
2016
5
Microsoft Excel
2011
5
DBA
2006
4
Java
0
1
Process Improvement
0
1
SQL
0
1
SQL Server
0
1
T-SQL
0
1
Tableau
0
1