Daniel Tessier Email and Phone Number

Created complete automated ETL processes with SSIS, including scripting complex data movement and manipulation in C#, error reporting and handling, and associated tables and procedures in SSMS using TSQL/Dynamic SQL, for full normalization and integration of new clients into relational software database. Created complete automated data extraction processes in TSQL/Dynamic SQL that generate varying files and summary reports (CSV/XLSX), using SSIS and scripting in C#, to provide daily account activity updates to clients via SFTP and Email. Created multiple ETL file drop and data evaluation processes for numerous departments with SSIS using C# scripting and TSQL. Created fully automated file drop Data Scrub product with SSIS and TSQL, basing matches on various ranked groupings of demographic criteria, and including a future match monitoring and reporting feature. Automated existing processes with SSIS and TSQL. Researched, identified, and remedied data discrepancies in SQL Database in SSMS. Developed API for PBX phone system in C#.

Identified areas that can be improved upon, regarding patient data collection and administrative tasks, and created web based tools, using JavaScript/VBScript, HTML & CSS and TSQL, to incorporate into the company’s medical record software, to streamline and simplify the identified job functions. Developed scripts and stored procedures in JavaScript/VBScript and TSQL, to automate repetitive job functions across the company in order to alleviate the need for user involvement in more complex tasks. Supported the company’s Help Desk involving but not limited to software, hardware, and network issues.

Made/received phone calls to/from providers to determine the cause(s) of medical claim rejections based on a wide range of criteria varying by state and membership type. Created new and alter existing SQL queries to retrieve billing information from across numerous databases within the system. Created and distributed custom reports from the database, with SQL, regarding patient and department statistics.

Logged medical appeals and determined the proper queue(s) to send them based on a wide variety of criteria.