I want to spend my time mentoring, coding, modeling, and optimizing. I want task-based work. I will work remote only with minimal meetings. No full time. No permanent.
Avalon Health Care Solutions, Tampa, FL
Responsible for integrating flat file data (health care data including claims, enrollment,...
Avalon Health Care Solutions, Tampa, FL
Responsible for integrating flat file data (health care data including claims, enrollment, provider) into to various systems using SSIS. Used C# for special processing in SSIS. Ensure data quality and integrity. Design processes and model data objects (tables, stored procedures, triggers, views, indexes) to incorporate new data. Work closely with application development to ensure proper database usage for online prior authorization and claim editing software. Implemented claim editing and other business rules in SQL Server. Miscellaneous production support, query optimization, and ad hoc reports. Follow strict agile software development methodology.
Developed and maintained database applications for managing Medicaid data for the State of Connecticut in a SQL Server environment. Da...
Developed and maintained database applications for managing Medicaid data for the State of Connecticut in a SQL Server environment. Data included claims, physician directory, insurance coverage, diagnosis codes, laboratory results data, and drug data (NDC). Implemented complex business rules using T-SQL. Designed an entire data warehouse for query performance optimization. Extensive work in ETL (extract, transform, load), database design, query optimization, data validation, reporting, data extracts, and data cleansing for large scale databases (i.e. tables with over a billion rows). Used SSIS and C# to load data into very large tables. Used GIT for source control in a continuous delivery/continuous integration environment. Exposure to Rabbit MQ and Mongo DB. Wrote a variety of utilities in C# to support application monitoring and ETL operations. Worked on API’s in ASP.NET.
Worked with Coverall database (both MIC and data warehouse) for data validation and report writing. Wrote parameterized Reporting Serv...
Worked with Coverall database (both MIC and data warehouse) for data validation and report writing. Wrote parameterized Reporting Services queries using SQL Server 2012. Deployed a SQL CLR routine to enable use of regular expressions in the database. Wrote a .NET multi-threaded console application for BI cube cache warming. Performed root cause analysis of data anomalies. Performance tuning for SQL queries. Wrote balancing reports. Involved in data cleansing. Wrote SQL user defined functions for data extraction.