Sandra Andstrom
Manchester,CT
Summary
Forward-thinking Operations Specialist bringing 24 years of expertise in project leadership, production mainframe support and troubleshooting, audit and compliance and innovation / automation for Travelers Insurance. Cultivates rapport with individuals to optimize project goals and output, resolve complex problems and deliver innovative improvement strategies. Proficient in COBOL, CA7, DB2, ISPF, TSO, Endevor, JCL, Sarbanes-Oxley audit controls and Records Retention procedures.
Overview
25
25
years of professional experience
Work History
Strategic Initiatives Consultant
Travelers Insurance
05.2022 - Current
- As an LSO, created ServiceNow requests for onboarding new resources including equipment orders, software; Active Directory assignments using SailPoint. Designed, implemented metrics for SLT.
- Lead for Workforce Management Tool, designed to track onboarding requests using AWS/ JavaScript rather than tracking manually using Microsoft Word/Excel.
- Records Retention Coordinator and certifier for Digital Enablement.
- Digital Enablement SOX audit lead for Tier 1 shared controls. Created ServiceNow reports to extract Changes and Incidents for items completed and closed during evidence collection timeframe.
- Participated in InJam to automate mainframe SOX control evidence collection to be leveraged across all LOB's. Created JCL, COBOL program to automatically generating emails based on condition codes.
Senior Business Systems Specialist
Travelers Insurance
03.2019 - 05.2022
- Prepared documentation procedures for Sarbanes-Oxley Controls.
- Certified Kanban Master for Corp Tech, Shared Services.
- Prepared, certified SOX Tier 1 shared controls for all Tier 1 applications.
- Assisted SailPoint certification manager with campaigns as needed.
Software Engineer
Travelers Insurance
06.2014 - 03.2019
- Developed an innovative process to automatically detect a potential mainframe abend. Utilized Excel, NDM transfer, csv to dataset conversion, COBOL programming, CA7, JCL, mvs email creation.
- Assisted business application team with application upgrade installs and troubleshoot application access issues.
- Provided off hours production support to assess, correct and restart job execution after production failure. Worked with Technology Operations Center to correct issues utilizing Endevor, CA7, JCL, COBOL.
- Chosen member of the CSS Innovation Team along with SLT to derive innovative ideas from CSS team members and implement.
Software Developer
Travelers Insurance
08.1999 - 06.2014
- Technical Project Lead in Reinsurance for implementing Reinsurance, Canadian processing. Created specifications, project plan, production readiness. Project was delivered on time with expected results validated against business' requirements.
- Tech Lead for CA Gen upgrades, assuring upgrades were tested successfully and working as expected.
- Designed CA Gen data models for DB2 table creation and upgrades.
- As a CA Gen SME, created a CA Gen technical manual for teaching CA Gen to other software developers in Hartford and St. Paul.
- Automated manual financial balancing process, balancing SQL Server database extract with mainframe Focus database extract. Out of balance triggered an abend and automated email based on forced condition codes.
Education
Bachelor of Science - Management Information Systems
University of New Haven
Norwich, CT06.1989
Associate of Science - Computer Science
Thames Valley State Technical College
Norwich, CT06.1987
Skills
- Client Requirements Assessment
- Disaster Recovery Planning
- Change Management
- Processes and Procedures
- User Support
- Failure Analysis
- Operations Analysis
- Continuous Improvement
- Project Implementation
- Project Leadership
- Problem-Solving
- Subject Matter Expert
Timeline
Strategic Initiatives Consultant
Travelers Insurance
05.2022 - Current
Senior Business Systems Specialist
Travelers Insurance
03.2019 - 05.2022
Software Engineer
Travelers Insurance
06.2014 - 03.2019
Software Developer
Travelers Insurance
08.1999 - 06.2014
Bachelor of Science - Management Information Systems
University of New Haven
Associate of Science - Computer Science
Thames Valley State Technical College