Resume / CV

Current Position(s)

John Hancock Financial Services
Sr. Data Analyst

Tumbledie Games, LLC
Member/Manager

About

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.

Specialties

  • Cross-specialty Communication
  • Legacy Systems Analysis & Support
  • Relational Databases
  • Data Analysis (Python/Pandas, T-SQL, MySQL)
  • Iterative Development (Agile)
  • Workflow Automation (Python)

Certifications

Education

Southern New Hampshire University
Bachelor's Degree, Business Information Systems
2011-2015

ITT-Technical Institute Online
Associate's Degree, Information Technology
2007-2009

Work Experience

John Hancock Financial Services

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

Tumbledie Games, LLC

Member/Manager, "Master of Coin"
Mar 2020-Present
Rochester, NH

  • Accounting/Bookkeeping
  • Book/Publication Design
  • Graphic Design
  • Host: Threat Dice podcast
  • Producer: Threat Dice podcast
John Hancock Financial Services

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).

John Hancock Financial Services

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.

John Hancock Financial Services

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

Self-Employment

Consultant
Jan 2006-Dec 2012 | 7 yrs
Freelance website design & consultation services; computer & home network installation, troubleshooting and maintenance; purchase and upgrade assistance.

Leanta Books, LLC

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)

PC Connection

Account Manager
Jan 2006-May 2006 | 5 mos
Sales; customer support; relationship building

Circuit City

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