Colton Spillman
Cedar Falls,IA
Summary
Experienced Internal Controls analyst with over 3 years experience at Transamerica in the finance and accounting field. Skilled within Excel and other software's such as Wings, Jira, and Sharepoint.
Overview
2
2
years of professional experience
Work History
Internal Controls Analyst
Transamerica
Cedar Rapids, IA
05.2023 - Current
- Tested over 150 controls my first year
- Currently the SME (Subject Matter Expert) for two processes
- Led Walkthrough meetings with process owners and auditors
- Provided timely feedback to management regarding the effectiveness of current policies and procedures.
- Communicated with team members on the status of controls
- Assisted external auditors in their review process by providing requested information or documents.
Investment Reporting Intern
Transamerica
Cedar Rapids
01.2023 - Current
- Cleaned out GL Suspense Overrides in Excel
- Assigned duplicate transactions to suspense accounts
- Streamlined out GL Suspense Override project within excel to speed up our daily process. Trained team members on the new process.
- Gained experience in Microsoft Teams and Outlook
- Gained experience working with Wings Software
Risk and Compliance Intern
Transamerica
Cedar Rapids
05.2022 - 08.2022
- Led and participated in daily meetings
- Trained and assisted new interns
- Worked in and uploaded to Sharepoint daily
- Worked with my manager 1 on 1 to accomplish tasks.
- Assisted with the implementation of new software systems for tracking compliance data
Expense Management Intern
Transamerica
Cedar Rapids
01.2022 - 05.2022
- Worked with multiple programs including Excel, Wave, Anaplan, Outlook, and Jira Software
- Used excel to organize Wave Initiatives and Jira Tickets
- Analyzed and approved Jira Tickets
- Worked with other departments to move Wave Initiatives to L5 before monthly deadlines
- Worked with GTS Expense reports and assigned expenses to cost centers
- Collaborated with team members to complete projects
Education
Bachelor of Arts In Finance -
University of Northern Iowa
05.2023
Skills
- Internal Auditing
- Documentation Review
- Teamwork and Collaboration
- Analytical Skills
- Task Prioritization
- Adaptability
- Excel
- Risk Assessment
Timeline
Internal Controls Analyst
Transamerica
05.2023 - Current
Investment Reporting Intern
Transamerica
01.2023 - Current
Risk and Compliance Intern
Transamerica
05.2022 - 08.2022
Expense Management Intern
Transamerica
01.2022 - 05.2022
Bachelor of Arts In Finance -
University of Northern Iowa
Similar Profiles
Deepika GehlotDeepika Gehlot
Annuity Specialist at transamericaAnnuity Specialist at transamerica
SAMUEL EYONGETAHSAMUEL EYONGETAH
Life Insurance Agent at TransamericaLife Insurance Agent at Transamerica
JOHN FREELJOHN FREEL
Director of Procurement at TransamericaDirector of Procurement at Transamerica
Martha Hirschfield, CDMP, PCMMartha Hirschfield, CDMP, PCM
Senior Channel Marketing Specialist at TransamericaSenior Channel Marketing Specialist at Transamerica
Andrew DutcherAndrew Dutcher
Parts Professional at O'Reilly Auto PartsParts Professional at O'Reilly Auto Parts