Automate the process of taking hundreds of insurance carrier plan detail files, extracting the needed information, and combining into one standardized file that fits the format needed to load into our database tables. This saves 2 to 8 hours per carrier.Automating parts of the agent appointing process, saving the Licensing team countless hours of manual tasks. This involves taking PDF formats, connecting to database to retrieve relevant information and placing them onto the specified locations on the PDF. Administrator of our agent licensing/appointing system, consisting of architectural design, user management, report building, and system maintenance.Manage Online Enrollment Center (OEC) platform used by our insurance agents to enroll customers in Medicare Advantage and Prescription Drug Plans.Provide consultation and assistance in redesign and modernization of OEC platform.Build .NET Core APIs to be used by new OEC platform to retrieve backend information for display on the forms.Update and maintain data tables that feed into the new OEC platform.Manage business reporting dashboards across different software: DOMO and SSRS.Engage with external clients in yearly preparation for Medicare's Annual Enrollment Period (AEP).Provide support for legacy C# and VB.NET programs.

Manage business reporting dashboards across different software: DOMO and SSRS.Transform data using T-SQL in SSMS to extract meaningful information.Maintain and update daily reporting files sent to insurance broker clients.

Extract, transform, and load insurance plan data into our Medicare Quoting Tool for agent and customer use.Perform competitive analysis on Medicare Advantage plans.

Perform Quality Assurance tests on insurance plans loaded into our Medicare Quoting Tool.

Assist in filing producer licenses and appointments, data entry, digitizing files, quality assurance, writing copy, competitive analysis.

Publicity Committee, Strategic Planning Committee, Membership Committee.

Scanned and cataloged photographs into a database to make searching for photos easier. Assisted the curatorial consultant with the accessioning of items and photographs.

Helped clean, prepare, and cook food; catered events; delivered food.