Data Analyst Software Engineer

Jonathan Seamon

Eau Claire, WI 608-***-**** ********.*.******@*****.***

SR SOFTWARE ENGINEER/DATA ANALYST

Senior Software Engineer with a proven track record in Risk Management Information Systems (RMIS) and Ad Hoc Business Insurance Claims Data Reporting at Liberty Mutual Insurance. Specializes in collaborating with external clients, business analysts, and account managers to deliver high-quality business intelligence solutions. Skilled in advanced SQL development, dashboard creation, and data extraction, while providing front-line corporate support. Experienced in data conversion processes and systems integration, particularly in loading data into customer reporting warehouses. Expert in planning, documenting, programming, testing, and deploying custom ad hoc reports. Known for developing innovative solutions to both known and emerging challenges, and for streamlining processes to improve the user experience. A collaborative professional committed to making both colleagues’ and clients’ lives easier.

WORK EXPERIENCE

Technical Expertise using SQL, SAS, MS Suite, Hyperion, & Microstrategy Project Planning, Development, Testing, Automation, & Documentation Data Conversion Projects Production Team Lead Agile Methodology – JIRA board used to prioritize and track stories Business Insurance Claims Data Collaboration with National Accounts Strong Team Dynamics Problem-Solving Skills Continuous Process Improvement

TECHNICAL SKILLS & TOOLS

BI Development and Reporting: SQL, SAS (Azure cloud), DB2 DB, Microstrategy, Hyperion, SalesForce, Power BI

Coding Languages: SQL, SAS, MS Suite/Macros, VBA, Access, COBOL/CICS/JCL.

Platforms and Tools: SAS Server, DB2 DB, Microsoft Suite, IBM Mainframe

AREAS OF EXPERTISE

Teamwork. Enjoyed working with all of my team including users, developers, business analysts, project owners, other systems teams, account managers, account executives, external insureds and brokers.

Quality. Assured clean data and accurate coding while providing clear concise requirements and documentation.

Efficiency. Emphasized making systems run more efficiently while making requested updates.

Security. Utilized SFTP for file delivery and secure email. Encrypting PII data was a standard.

Analysis. Initiated deep dives to overcome blockers, find bugs, or create better solutions.

Presentation. Provided results and work to stakeholders in bi-monthly Agile meetings.

Work Environment. Worked and played on high functioning Agile team from a remote work site.

Data Conversions. Increased knowledge and skills while working on a data conversion analyst team.

Conflict Resolution. Evaluated recommendations to provide professional insights into divergent opinions.

Controlled Chaos. Multi-tasked amidst addressing impediments, maintaining production systems, and supporting high priority projects.

Continuous Learning. Currently working to broaden my technical knowledge with Python courses at Codecademy and AWS Cloud Practitioner Essentials on the AWS training site.

Page 1 of 2

PROFESSIONAL EXPERIENCE

Liberty Mutual Insurance, Dover, NH 1990-2023

Senior Software Engineer (worked remotely via Microsoft Teams starting February 2019)

•Belonged to a high functioning Team supporting Liberty Mutual’s RMIS Ad Hoc systems and processes.

•Supported and maintained Data Extract SFTP deliveries via a custom inhouse application.

•Worked on multiple data conversion projects for brokers, Third-Party Administrators, and Insureds.

•Provided Account Executives, External Insureds, Brokers, Third-Party Administrators, and Business Analysts with technical and analytical support.

•Assigned, Programmed, Tested, Deployed, and Automated Ad Hoc report requests on a daily basis.

•Utilized Agile methodology development environment using a JIRA board for story prioritization.

•Led the Liberty RMIS production team that deploys, runs, maintains, delivers and tracks over 15,000 reports and data extracts (annually) delivered using SAS, Microstrategy, & Hyperion.

•Provided support as a SAS captain ensuring a secure and stable environment.

•Developed and supported a Data Extract Utility to efficiently process 148 scheduled data extracts monthly.

•Independently managed and developed targeted business projects.

IMPACTFUL PROJECTS

•Consulted with external teams to establish an automated process to run SAS scripts and deliver files via SLIM/SFTP, saving the reporting team 300 hours per month.

•Designed setup of a new production reporting environment in SalesForce, allowing for flexible business reporting and daily run tracking capabilities.

•Worked with internal audit and legal teams to develop reports to satisfy legal requirements.

•Leveraged SQL and MS Visual Basic macros to create reports saving the Legal department 100+ hours/year.

•Supported the successful migration of key reports from Hyperion to MicroStrategy environment.

•On-boarded and trained 4 new developers on the Ad-Hoc production team.

•Designed and Managed Third-Party Administrator data conversion projects.

EDUCATION

Bachelor of Art (B.A.), Computer Science, (Math minor)

Gustavus Adolphus College, Saint Peter, MN

CERTIFICATIONS

Chartered Property Casualty Underwriter (CPCU)

Page 2 of 2

Contact this candidate