Senior Software Developer
Farmington, Ct, Us
Assisted in PPACA Risk and Reinsurance initiative to import and export enrollment, claim, pharmaceutical and supplemental data into and out of our SQL database in XML format. Used .NET XSD.EXE tool to build object model from federal government provided XSDs. Built suite of inheritable .NET console applications using the object model, Entity Framework, LINQ and SQL Server to provide necessary XML import/export functionality for data team.Worked on phase 2, 3, 4 and 8 UI, logic and reporting enhancements to the SOLO enrollment ASP.NET health insurance website and supporting the data and business rules WCF web services in regards to The Patient Protection and Affordable Care Act (PPACA) or "Obamacare". Researched, documented and implemented front-end jQuery/javascript solution to accept initial premium payments by credit card using the Cybersource API. Augmented and created several SQL 2008 data tables and objects used by the WCF web services. Worked directly with Business Analysts/QA to deploy, test and troubleshoot changes in development, test and staging environments. Worked on various bug fixes and enhancements related to the Producer, Provider, SOLO Quoting, Enrollment, GroupAdmin and Membership ASP.NET health insurance websites and WCF web services.Provided first-level technical support to the Intake department regarding the SOLO Quoting, Enrollment, GroupAdmin and Membership web sites.Trained two new f/t developers in using/maintaining SOLO related websites.Worked on creating/fixing multiple SSRS Reports in regards to PPACA Phase 8 requirements. Worked with Emblem and adding ability to SQL DTS jobs, responsible for cleansing and loading Medicare Hospital and Medical claim data, to provide new claim and service line data for Medicare Hospital claims. Altering provider website ASP.NET C# code to show some of these new fields and all detail data.