Key Accomplishments • SSIS o Create text files and move to FTP server o Compile commission statement results o Print PDF statements, Process audit excel files, Send email with attachments o Extract, transform and load data from multiple data sources to create tax forms o Use logic and custom coding to error check SQL table • SSRS o Created over 100 SSRS self-service and scheduled reports ? Traditional table style reports ? Commission statements ? Tax forms • Power BI o Commission Rate to Premium over time by state o Group premium by platform • Tableau o Dashboard broker commission payment by platform o Track call center response time • ASP.NET using Visual studio 2019 o Created an intra company web application to add and edit records for broker commission payments o Created a web application for tax forms o Created a database to add and store multiple email addresses • Automation – saved 10,000 data entry hours annually o Auto entered around 80K records each year into Attachmate Reflection (terminal emulator) o Auto entered around 2.5K records each year into Basics (web) o Uploaded 150K images to DocDNA (web) o Downloaded 200K records from PCIS (terminal emulator)