Sql Server Vb .Net

ANDREW J. BRONS

*******@***.***

https://www.linkedin.com/in/andrewbrons

I have experience in electronic health record systems in a hosting organization as a SQL Server engineer, and programming medical information interfaces and conversions. I have developed: reporting, SQL database administration and programming skills.

SKILLS

●Microsoft SQL Server, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Tableau, Crystal Reports and Sisense, PowerShell, and PowerBI

●Applications: Great Plains, Lotus Notes, Access, Excel, Allscripts Touchworks, General Electric Centricity Practice Solution and Centricity EMR, Cerner HIS, and Psych Consult

●Languages: T-SQL, VB.Net, Visual Basic 6.0, Visual Basic for Applications

●Source Control: Visual SourceSafe, SVN, Toad, and Visio

MS SQL SERVER DATABASE SUPPORT

●SSIS package programming and troubleshooting

●Backups and restores using PowerShell

●Troubleshoot problems using SQL Profiler and Query Analyzer

●Analyze Index Performance

●Optimization

●SQL Server Audit using PowerShell tools

●PowerShell SQL Connection testing

●Availability Groups management using PowerShell Tools

●Monitoring Index usage into tracking table using PowerShell

CURRENT CAREER DEVELOPMENT

Google Advanced Data Analytics Cert Microsoft Azure AZ900 Cert Effortless Snowflake Data Orchestrations

PROFESSIONAL EXPERIENCE

SQL Developer

CAI

August 2023 – December 2023

TSQL Programmer for a large health care services organization. Responsible for researching rebills and voids for encounters to be submitted to payers and then batching and resending rebills and voids. Managed requests outgoing to partners for rebilling specified tasks.

SQL Developer

Apex Systems

Oct 2022 – April 2023

TSQL Programmer for large ambulatory practice using Altera Touchworks EHR and PM. Tasked with upgrades, custom programming using SSIS for ETL and reporting. Reviewing TouchWorks stored procedures for custom code to facilitate 20.x upgrade. Created Reporting Services reports that combined billing data from Allscripts PM and clinical data from Touchworks. I investigated performance and blocking issues. Extended existing custom programming for referring providers ordering a consulting physician. Build upgrade environments for testing Touchworks 20.x upgrade by instantiating v17 stored procedures in v20 environment using PowerShell.

Data Modeler

Mediquant

November 2020 – July 2022

Independence, Ohio

Mapped and archived a variety of legacy Electronic Health Record systems. Systems transformed into a proprietary data warehouse: Allscripts TouchWorks Allscripts Pro Meditech Magic Quest Care360.

The mapping of the various source systems involved writing TSQL, reading stored procedures, views, functions and foreign and primary keys. Optimized extraction scripts for very large data sets.

Visualization and ETLDeveloper and Database Administrator

Freelance

Feburary 2017 – October 2020

Reverse engineering and documenting Sisense BI initiative to Power BI for demos for healthcare dashboarding start

up. Also used Tableau and Python libraries for data analysis and visualizations.

Acted as technical liaison to potential technology partners. Technical resource for CDA document Discharge

Refactoring and researching failed data warehousing and BI initiative. Co-designer in new data warehouse initiative. Extracts from clients to legacy data warehouse and next generation data warehouse.

Backups Restores and Always On maintenance using PowerShell

Consultant

HCTec July 2016 – January 2017

Brentwood, TN

Integration Architect for Allscripts TouchWorks V10 archiving project to in house archiving system. Developed extract using TSQL scripts and refactored Java routines to load clinical data to an in house archiving system. Used SSIS in fuzzy matching routines to map document types to archiving folders. Reviewed notes and scanned images not matched in SSIS routines to archiving folders.

Database Administrator

Divurgent, November 2015 –December 2016

Virginia Beach, Virginia

SQL DBA for ambulatory billing group for a large teaching university hospital. Duties consist of documenting legacy systems including Siemens Signature and the newly installed Soarian financials. Cerner DSS was a data warehouse taking Sorian Financials Revenue Cycle data. The DSS was the data source for Claims Management and Revenue Cycle reporting. I Maintained and extended the Cerner DSS data warehouse and SSIS extraction routines and troubleshooting daily production issues using TSQL and optimizing and refactoring legacy code. Acted as lead technical resource on upgrade of DSS data warehouse. Monitoring Index usage into tracking table using PowerShell

SQL Programmer

HowardCenter, October 2012 – September 2015

Burlington, VT

Created TSQL stored procedures and triggers for custom documents in Psych Consult electronic medical record application. Extract electronic health records for data migrations, ad hoc reports and Crystal Reports and SQL Reporting Services reports. System administrator for Reporting Services. Programmer for SQL Server Integration Services and report writer for Clinical and Revenue Cycle and Accounting and HR. Programmed data migration to Microsoft Great Plains Dynamics using SQL Server Integration Services.

Interface Programmer

Rutland Regional Medical Center, April 2012 – October 2012

Rutland, VT

Support Cerner HIS by monitoring Cerner Open Interface engine. Support and development in Sybase eBiz Impact and Mirth Interface engines. HL7 and X12 message exchange using TCP/IP and SFTP and FTP protocols. System Analyst for add on and net new projects. Create documentation for legacy and new applications. Cerner CCL reporting.

Database Administrator

General Electric Healthcare IT, April 2011– March 2012

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 and PL SQL, Microsoft Management Studio and TSQL. Publishing applications using XenApp AppCenter and adding users to Citrix presentation servers and troubleshooting Citrix issues. Configuring and upgrading Centricity Practice Solution and Centricity Electronic Medical Record. Working with hosting center staff on networking issues.

Data Analyst Programmer

Allscripts Healthcare Solutions Inc, March 2008–April 2011

South Burlington, VT

HL7 Interface programmer and programmer analyst for medical systems data extractions and loads. Specialize in extraction, transformation and load of legacy data to Allscripts Enterprise Electronic Medical Record System for large ambulatory practices (50 doctors and larger). Tools used:

SQL Server Integration Service

Used SSIS to extract data directly from Misys Electronic Medical Record Systems and NextGen Electronic Medical Record Systems used by large practices and then loaded to Allscripts Enterprise EMR via TSQL cursor scripts. Loaded documents and images from various EMRs via file extracts. Images loaded using proprietary Allscripts Image Conversion tool to Allscripts Enterprise.

Used VB.NET data scrubbing routines in SSIS packages to clean file extracts.

SQL Server Management Console

Used SQL scripts to clean and check order result compendiums, provider, and clinical data type dictionaries including ICD9, CPT9 and Medication dictionaries based on Medcin codes. Created adhoc SQL reports for clinicians to revise dictionary mappings and created acceptance reports for patient and clinical data loads into Allscripts Enterprise.

Developed adhoc queries for querying Misys EMR AIX servers from SQL Server using Open Rowset T-SQL command including AIX meta data tables. This led to more efficient utilization of programmers effort for Misys EMR conversions.

ConnectR interface engine

ADT Admission Discharge Transfer Messages

SIU Scheduling Information Unsolicited Messages

ORU Document Messages

ORM/ORU Order Results Messages

ACK Acknowledgement Messages

Data Types

Images

Documents

Procedures

Problems

Vitals

Results

Immunization

Allergies

Medications

Medication Allergies

Application Developer

Cabot Creamery/Agri Mark, Inc., April 2007–March 2008

Montpelier, VT

Microsoft SQL Server 2000 database administration, Access, and Visual Basic 6.0. Lead programmer for warehouse system integration using SSIS 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.

Systems Analyst/Programmer

CBA/EBPA, December 2004–April 2007

South Burlington, VT

Microsoft SQL Server 2000 database administrator, Access and Visual Basic 6.0 programming, Reporting Service reports, 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.

Data Analyst

Technical Connection, August 2004–September 2004

Burlington, VT

Consultant at Burlington City Hall. Duties consisted of report writing, Access programming, application and DBA support, and documenting legacy applications.

Business Analyst

Puget Sound Energy, May 2004–June 2004

Bellevue, WA

Member of Financial Reporting group. Maintained SAP and Cognos cost accounting reports and created Access 97 tools.

Coinstar, Inc.,

Bellevue, WA, September 1998 – February 2003

Associate Developer

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.

Application Specialist

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.

Revenue Accountant

Duties consisted of maintaining and reconciling cash accounts and researching individual transactions for internal and Partner needs using Access reports and queries.

EDUCATION

University of Washington Extension

Certificate Program in Visual Basic, January 2002

University of Washington

Bachelor of Arts in Business Administration, Accounting, May 1998

Contact this candidate