Noah Lancaster
Elgin,IL
Summary
Experienced business systems analyst with expertise in data analysis and systems analysis. Possessing over a decade of professional experience, I have developed a strong skill set in reporting, system development, and cross-functional collaboration to ensure accurancy and effectiveness. Proficient in identifying and resolving intricate business issues, I utilize my analytical mindset to streamline processes and elevate overall performance. Committed to delivering top-notch outcomes, I excel in dynamic work settings where my eye for detail and problem-solving abilities can be utilized effectively.
Overview
19
19
years of professional experience
Work History
Business Systems Analyst
Zurich NA
05.2018 - Current
- Created new reporting solution integrating SQL stored procedures and SSRS, resulting in a 90% increase in both data accuracy and time to market
- Developed intricate SQL queries for data migration to external databases, enabling actuaries to analyze and modify production data
- Collaborated on the creation of a new ETL solution, offering valuable design insights to enhance data extraction capabilities and streamline file generation processes
- Extensive experience with Excel, writing VBA macros to parse flat files, consolidate data from various sources, and automate email communication
- Developed a universally utilized SQL query enabling users to input variables and access essential policy information; easily scalable to incorporate extra tables
- Translated business requirements into technical requirements
- Collaborated with developers, business analysts, testers and project leaders throughout the development lifecycle to successfully deliver downstream projects
- Second level production support providing resolutions to clear issues quickly
Systems Analyst
Zurich NA
08.2012 - 05.2018
- Generated reports in DB2 by integrating data from various sources, facilitating decision-making process for diverse user groups
- Application SME for business users, testers and developers
- Provided valuable insights to BAs, reviewing and suggesting improvements to new or revised requirements
- Collaborated with many different teams on multiple projects to ensure releases went smoothly
- Identified defects and provided recommendations for fixes
- Second/Third level application support
- Complete testing of new or updated functionality
Application Support Manager
Zurich NA
10.2010 - 09.2012
- Oversaw a team of support analysts for underwriting applications
- Cultivated critical partnerships with IT and business users, facilitating swift problem recognition and resolution
- Developed new tracking categories to enhance visibility of trending issues resulting in expedited deployment of solutions by IT
Application Support Analyst
Zurich NA
11.2008 - 10.2010
- Applied strong analytical and problem-solving skills to successfully troubleshoot users' issues, ensuring timely resolution without the need for escalation
- Rapidly mastered numerous proprietary systems and discerned the linkages between them
Inside Catastrophe Claim Adjuster
Allstate Insurance
03.2007 - 11.2008
- Reviewed damage estimates and worked with claimants throughout the claim process
- Quickly learned advanced functions of the software suite and helped others with questions around the functionality
- Completed adjustor licensing for all required states in less than two months.
Auto Claim Adjuster
State Farm Insurance
10.2005 - 03.2007
- Determined liability based on policy reports and claimant statements
- Worked directly with claimants to resolve all parts of the claim
- Selected by management to join a team responsible for finding deficiencies in the existing workflow and make recommendations for process improvement.
Education
Bachelor of Science -
Robert Morris College
Peoria, IL05.2005
Skills
- SQL (TSQL)
- SSRS
- Data Mapping
- Report Writing
- Systems Analysis
- Functional specifications
- Problem-Solving
- Analytical Thinking
Timeline
Business Systems Analyst
Zurich NA
05.2018 - Current
Systems Analyst
Zurich NA
08.2012 - 05.2018
Application Support Manager
Zurich NA
10.2010 - 09.2012
Application Support Analyst
Zurich NA
11.2008 - 10.2010
Inside Catastrophe Claim Adjuster
Allstate Insurance
03.2007 - 11.2008
Auto Claim Adjuster
State Farm Insurance
10.2005 - 03.2007
Bachelor of Science -
Robert Morris College
Similar Profiles
Soraya PickettSoraya Pickett
Regional Underwriting Officer at Zurich NARegional Underwriting Officer at Zurich NA
David JenczmionkaDavid Jenczmionka
Business Systems Analyst / Data Analyst at Zurich NABusiness Systems Analyst / Data Analyst at Zurich NA
Jennie BlevinsJennie Blevins
Executive Assistant II at Zurich NAExecutive Assistant II at Zurich NA