John Hancock Financial Services
Sr. Data Analyst
Tumbledie Games, LLC
Member/Manager
Sr. Data Analyst with a background in customer relations, support and sales. 13 years of financial industry experience, primarily with fixed & variable annuities and mutual funds. 10 years IT analysis. Strong analytical skills that provide quick insight into unfamiliar and complex issues, with a focus on business systems and process improvement.
Thrives on varied responsibilities and latitude to explore unorthodox problem solving solutions.
Southern New Hampshire University
Bachelor's Degree, Business Information Systems
2011-2015
ITT-Technical Institute Online
Associate's Degree, Information Technology
2007-2009
Senior Data Analyst
Apr 2017-Present
Portsmouth, NH
Leadership Responsibilities: Team Leadership; Training; Process Coordination; Vendor & Off-Site Team Collaboration; Interdepartmental Collaboration; Process Improvement; Standards & Best Practices Development & Implementation; Process Efficiency Improvement; Knowledgebase Development & Maintenance
Technical Responsibilities: MS-SQL Database Analysis, Reporting and Maintenance; Data Modeling; Version Management & Code Repository Management (SVN); Code Development, Deployment & Certification/Functional/Region Testing; Systems and Application Administration (MS Windows/Azure/Cloud); Informatica Application Support; Project Analysis & Documentation; Systems Analysis & Documentation
Member/Manager, "Master of Coin"
Mar 2020-Present
Rochester, NH
IT Business Analyst III
Aug 2015-April 2017 | 1 yr 9 mos
Portsmouth, NH
Database and reporting analysis for financial products (Microsoft SQL Server and Cognos): fixed & variable annuities, group pension plans and others. Process development and improvement; automation via CA Workload Automation & Informatica; data modeling and relational database development/improvement; database versioning and implementation; test plan development and execution; master data management (MDM).
Business Systems Analyst
Mar 2010-Aug 2015 | 5 yrs 6 mos
Portsmouth, NH
Production support in the IT group for the Vantage-One mainframe, AWD document-management and Datastores/reporting systems (Cognos). Includes project analysis, project documentation, database analysis and development (MS SQL & DB2), reporting analysis and development (MS SQL & DB2), data modeling, code deployment and implementation, version management, systems development life-cycle, test plan development and execution, analysis and troubleshooting of issues encountered, understanding of business needs in the financial services industry--specialty: fixed and variable annuities.
Client Services Representative
Nov 2007-Mar 2010 | 2 yrs 5 mos
Portsmouth, NH
Phone-based customer support in an incoming call-center; peer support & training; knowledge management; escalated issue resolution
Consultant
Jan 2006-Dec 2012 | 7 yrs
Freelance website design & consultation services; computer & home network installation, troubleshooting and maintenance; purchase and upgrade assistance.
Technology Services Manager
Jun 2006-Nov 2007 | 1 yr 6 mos
IT purchasing; network administration; PC maintenance and repair; data backup & storage; desktop publishing (Adobe InDesign); graphic art and cover design (Adobe Photoshop)
Account Manager
Jan 2006-May 2006 | 5 mos
Sales; customer support; relationship building
PC Services Technician
Sep 2003-Nov 2005 | 2 yrs 3 mos
Customer support; relationship management; PC troubleshooting and repair; virus removal & maintenance; spyware removal & maintenance; sales