.Net Developer
Medassets
Designed and implemented Windows services and tools in C#, XML, and SSIS for a product called XCollect which manages collections processing for hospitals. Utilized a full range of C#, XML, ADO.NET, SQL Server stored procedures (T-SQL) and SSIS features to provide a highly-configurable ETL application (called XFI). This system imports daily batch feeds for account updates into a SQL Server database, and processes realtime transactions using a health industry protocol called HL7.Performed role of principal designer and programmer for XFI. The development environment was Visual Studio 2005, C# 2.0, and SQL Server 2005. The DTS / SSIS packages defined package-level variables, some of which were assigned values passed-in from invoking C# code. The packages defined connection managers some of which were used to log rows re-directed (for error reporting) from OLE DB Destination DataFlow components. Extensive use was made of Execute SQL Task (EST) components within ControlFlow components. Some of these EST components invoked stored procedures, whereas others defined native T-SQL code. Upon return of the package from its invokation from C#, any errors encountered were handled by the C# code. These packages used DTS config files for such things as connection strings, etc