Currently I am supporting electronic health record systems in a hosting organization as a SQL Server database administrator. I have experience programming medical information interfaces and conversions. During the past thirteen years I have developed SQL database administration and programming skills. I have 14 years of SQL Server reporting experience.
- Applications: Microsoft SQL Server, ConnectR, Reporting Services, Crystal Reports, Great Plains, Enterprise Reporter, Lotus Notes, Access, Excel
- Languages: T-SQL, .Net, Visual Basic 6.0, Visual Basic for Applications, Lotus Notes scripting and formula language
- Systems: Windows 2000 - 2008, Windows NT, SQL Server, Visual SourceSafe, and Visio
- Knowledge: Visual Basic .NET
- Documentation: Requirements, Support, and Help documents
MS SQL SERVER DATABASE SUPPORT
- SSIS and DTS package programming and troubleshooting
- Backups and restores
- Troubleshoot problems using SQL Profiler and Query Analyzer
- Analyze Index Performance
Certified Lotus Programmer Domino R5 Application Developer
Confidential, April 2011 to present
South Burlington , VT
Install and support Centricity Practice Solution and Centricity Electronic Medical Record in a hosted environment. SQL Server 2005 and 2008, Windows 2003 and 2008, Oracle SQL Developer.
Confidential, March 2008 to April 2011
South Burlington ,VT
Programmer analyst for medical systems data extractions and loads. Specialize in extraction, transformation and load of legacy data to TouchWorks Electronic Medical Record System. Tools used:
- ConnectR interface engine
- SQL Server SSIS 2005
- SQL Server 2005 Management Console
- VB.NET data scrubbing routines
- VB Script
Confidential, April 2007 to March 2008
Microsoft SQL Server 2000 database administration, Access, andVisual Basic 6.0. Lead programmer for warehouse system integration to manufacturing system and cost accounting system. Used SQL Server database and DTS packages to integrate flat files created by source system triggers to load cost accounting system and warehousing applications.
Confidential, December 2004 - April 2007
South Burlington, VT
Microsoft SQL Server 2000 database administrator, Access and Visual Basic 6.0 programming, automation projects, database analysis, and optimized Microsoft SQL Server 2000 installation. Wrote testing white paper and test plans, and managed project for testing efforts for claims adjudication system. Documented cost saving analysis proposal for management for combining business platforms. Created various Access 2003 and Visual Basic 6.0 front ends to display data warehouse information and load data to data warehouse. Created Access 2003 data load projects for claims adjudication system that pass parameters to execute DTS packages using global variables and dynamic properties. Acted as technical lead on automated voice attendant install. Translated technical spec from vendor into presentation to senior management, and derived test cases for testing from presentation.
Confidential, August 2004 - September 2004
Consultant at Burlington City Hall. Duties consisted of report writing, Access programming, application and DBA support, and documenting legacy applications.
Confidential, May 2004 - June 2004
Member of Financial Reporting group. Maintained SAP and Cognos cost accounting reports and created Access 97 tools.
Confidential, February 2003 - September 2003
Developer on Crystal Reports and Lotus Notes report generator and broadcast application team. Duties consisted of creating Crystal Reports, stored procedures, and Lotus Notes programming or support and enhancement of reporting application. Integrated Lotus Notes data into SQL Server 2000 or Access 97 databases, and created Access 97 tools for accounting staff.
Confidential, January 2000 - February 2003
Duties consisted of supporting users of financial programs Great Plains eEnterprise and Enterprise Reporter using SQL Server 2000 Enterprise Manager components, SQL Query Analyzer, SQL Profiler and DTS, including database backups and restores. Researched and implemented IT solutions for financial group using Lotus Notes scripting, Visual Basic 6, T-SQL, and Access 97 VBA.
Confidential, September 1998 - January 2000
Duties consisted of maintaining and reconciling cash accounts and researching individual transactions for internal and Partner needs using Access reports and queries.
Confidential, May 1998-August 1998
Duties consisted of aging returned checks, requesting adjustments of customer accounts, maintaining cash spreadsheet, and researching customer accounts.
Certificate Program in Visual Basic
Bachelor of Arts in Business Administration, Accounting
2004 Microsoft ASP.NET Web Applications Using Visual Studio .NET
Bellevue Community College, WA
2003 Programming Databases with Visual Basic .NET (UW)
Visual Basic .NET Programming - Level 1 (BellevueCommunity College)