Shane Doohan
Advanced Data Analyst at Farmers Alliance Companies- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Confronting Bias: Thriving Across Our Differences
LinkedInJan, 2021- Nov, 2024
Experience
-
Farmers Alliance Companies
-
United States
-
Insurance
-
100 - 200 Employee
-
Advanced Data Analyst
-
Sep 2021 - Present
-
-
-
McGrath Doohan Consulting LLC
-
United States
-
Financial Analyst
-
2012 - Present
Analyse financial projections of energy solutions for varied international clients Analyse financial projections of energy solutions for varied international clients
-
-
-
Hudson Insurance Group
-
United States
-
Insurance
-
400 - 500 Employee
-
Actuarial Analyst
-
Mar 2019 - Mar 2021
-
-
-
-
Actuarial Associate
-
Jan 2015 - Feb 2019
Commercial Lines Ratemaking and Reserving Commercial Lines Ratemaking and Reserving
-
-
-
CPA Site Solutions
-
United States
-
Marketing Services
-
1 - 100 Employee
-
Marketing Analyst
-
Oct 2014 - Jan 2015
Customer matching and verification using SQL Server Customer matching and verification using SQL Server
-
-
-
Milliman
-
United States
-
Business Consulting and Services
-
700 & Above Employee
-
Actuarial Analyst
-
May 2014 - Sep 2014
Built and updated pricing models and client correspondence for P & C Insurance. Used Excel/VBA, Qlikview and SQL Server Built and updated pricing models and client correspondence for P & C Insurance. Used Excel/VBA, Qlikview and SQL Server
-
-
-
Westpac
-
Australia
-
Banking
-
700 & Above Employee
-
Senior Data Warehouse Specialist
-
2009 - 2012
Set up several datamining models and improved efficiency of existing data models after liaising with the business owners. Certified Teradata SQL Specialist. Also used Business Objects and BTEQ. Set up several datamining models and improved efficiency of existing data models after liaising with the business owners. Certified Teradata SQL Specialist. Also used Business Objects and BTEQ.
-
-
-
St.George Bank
-
Australia
-
Banking
-
700 & Above Employee
-
Data Warehouse Specialist
-
2002 - 2007
Built, administered tables, monitored query impact on the data warehouse and educated users from all departments on more efficient query design and Business Objects report design. Designed and taught SQL and Business Objects courses for users. Built, administered tables, monitored query impact on the data warehouse and educated users from all departments on more efficient query design and Business Objects report design. Designed and taught SQL and Business Objects courses for users.
-
-
-
Drake International
-
Canada
-
Human Resources Services
-
500 - 600 Employee
-
Report Writer
-
2001 - 2002
Used VBA programming behind Excel and Access to automate report generation for the regional headquarters in Sydney. Used VBA programming behind Excel and Access to automate report generation for the regional headquarters in Sydney.
-
-
-
NAB
-
Australia
-
Banking
-
700 & Above Employee
-
Report Writer
-
2000 - 2001
Designed a tool using VBA to efficiently and automatically extract information from a legacy database. Designed a tool using VBA to efficiently and automatically extract information from a legacy database.
-
-
-
QBE Insurance
-
Australia
-
Insurance
-
700 & Above Employee
-
Support Analyst
-
1997 - 2000
Recreated user problems, identified database tables with the incorrect data and targeted resolution through to the development team. Recreated user problems, identified database tables with the incorrect data and targeted resolution through to the development team.
-
-
Education
-
University of Technology
Graduate Diploma, IT -
University of Adelaide
Music, Composition -
University of Adelaide
Bachelor, Music; Comp