Technical Analyst
CurrentDevelop reports in Microsoft Visual Studio 2013 and MS Reporting Services from Oracle, SQLServer and Netezza databases delivered through subscription via email or posting through batch jobs on Sharepoint sites. The reports are for the STRS Ohio Disability and Member Benefits departments. Develop a cube for Workflow Reporting in MS Analysis Services using the Tabular model and DAX formula language. . Extract data from the Line of Business database to our reporting database using Microsoft Integration Services (SSIS) packages.Worked with users in the STRS Ohio Health Care department and analysts/coders to support health care functionality in a legacy IBM mainframe system using PACBASE on a DB2 database until 2009. Worked with consultants to design a new system with richer functionality in a browser-based benefit administration system on an Oracle database. This system is a customization of a product benefit administration system created by Vitech Systems Group. Health Care functionality includes:o Collection of health care premiums from retired teachers’ pension checks or directly by invoicingo Medicare information o Calculation and establishment of premiums for all types of covered individuals, plans, Medicare statuses and premium subsidy levelso Reporting of eligibility and actuarial information to vendorso Tracking of eligibility for Medicare Advantage and Medicare Part D programso Annual open enrollmento Generation of reports and lettersRecreated eligibility files to vendors using ANSI 834 ASC X12 standard transactions as part of STRS Ohio compliance with the Health Insurance Portability And Accountability Act (HIPAA).Ensured STRS Ohio compliance with HIPAA requirements through training and presentations to spread awareness, definition of legal status and confidentiality notices on emails. Assisted in discoveries for STRS Ohio lawsuits.Managed performance of team members through day-to-day direction, counseling, setting goals and appraisals.
