Jason Kirschner Email & Phone Number

Simpsonville, Sc, Us

United States

Reporting and Data Programs:•Built and refreshed reports for Executives and Business Leads to view operating results using Excel, Python, Power BI and SQL.•Produced ad-hoc reports throughout year, developing them within either Excel, Power BI, Alteryx or Python depending on information needed and frequency of updating reports.•Analyzed, updated and reconciled monthly reports for Claims, Premium, Production.•Developed and remodeled reports to make more efficient in updating time, provide additional information and made more user friendly.•Prepared and sent out reports to be sent to outside businesses to provide information.•Automated existing reports using Power Bi, Alteryx or Python for upper management and operations team to increase efficiency and accuracy of reports.Data Management/Quality:•Built framework and loaded data using Visual Studio into SQL Server to build data warehouse.•Regularly loaded data into SQL Data warehouse to keep data warehouse up to date.•Manually scrubbed data to be beneficial to upper management.•Reviewed data being provided to data warehouse to make sure was flowing downstream accurately.Product/Billing:•Searched and billed members behind on payments on a weekly basis.•Updated monthly billing reports for Business 2 Business and tracked business payments.•Provided weekly eligibility reports to keep member information updated.

Remote

IT Data Analyst:• Write SQL queries to extract data across multiple data servers to compare, analyze and identify errors.• Monitored financial reports for discrepancies and data sources not matching and then researched the discrepancies to help developers fix problem.Scrum Lead:• Installed and led agile methods (Scrum) to help team become more efficient and be able to track progress on projects.• Updated backlog and sprints within Azure DevOps so that all related product backlog items were linked and they were all located under correct Feature and Epic.• In charge of maintaining and updating Azure DevOps for the Financial Data Services team.• Created dashboard in Azure DevOps, that allowed developers to monitor individual progress and team leads/managers to view progress during sprint.• Handled Change Control Request meetings so developers could deploy code or updates on time. Also updated business on changes being implemented.• Dealt with any problems, obstacles, or delays that developers faced with other employees so their progress wouldn’t be stalled waiting on piece to be finished.

Greenville, South Carolina, United States

Reporting:•Built and refreshed reports for Executives and Business Leads to view operating results using Excel, PowerPivot and SQL•Produced ad-hoc reports throughout year and for quarterly board presentations•Analyzed, updated and reconciled monthly reports for Distribution, Production, Losses, And Retention•Updated SharePoint site to share monthly results with company.•Developed and remodeled reports to make more efficient in updating time, provide additional information and made more user friendly.Data Quality:•Improved existing fields for more accurate analysis•Manually scrubbed data to be beneficial to upper management.•Reviewed data being provided to data warehouse to make sure was flowing downstream accurately.Product:•Managed product lines for the Western region•Reviewed and implemented yearly product changes for entire region•Improved price adequacy within business lines and by state•Preformed market research to compare and analyze competitor filings to see potential improvements for business.

Greenville, South Carolina Area

Adjusted claims on daily basis that consisted of investigating, evaluating, negotiating and documenting claims that allowed me to close the claim with an appropriate decision. Consistently communicated with interested parties for a claim and managed desktop to keep an organized schedule.Also was promoted to mid-liability claims adjuster in November of 2016

Winston-Salem, Nc

Summer JobIn charge of handling any complaints or conflicts with members and employeesScheduled times and days on when the lifeguards would come in and workContinued to do the assistant manager jobs that I did the previous year

Summer JobCleaned and maintained pool and facilities to ensure health and safety regulations were metSet up tables, chairs and decorations when Graylyn was hosting a big event at the pool

Summer JobHandled inventory of merchandise, analyzed sale of products and communicated with manager on what to restockManaged cash box of up to $800

Teller at first ever Credit Union inside of a high school in Forsyth CountyCreated and developed a marketing plan so Allegacy could reach out to Generation YCompleted surveys of high school students, researched the web, and examined ways other companies were communicating with Generation Y.Traveled to other high schools in Forsyth County to help them get started and prepared with running their own credit union