Christopher Nick

Senior Analyst focused on data validation, data integrity, and business reporting within high-volume insurance operations. Uses SQL, Power BI, Python, Power Automate, and VBA to analyze transaction data, trace defects, and monitor processing results. Converts business requirements into reporting tools, automation changes, and documented support procedures. Resolves production issues, explains findings to business and technical teams, and trains users on new processes and tools.

Senior Analyst, Robotic Process Automation - Nationwide Insurance - Scottsdale, AZ

(2018-01)

• Develop, deploy, and support approximately 15–25 automation solutions, covering requirements, testing, production monitoring, defect correction, and enhancement work.
• Analyze transaction data, system logs, processing exceptions, and workflow results to trace production defects and reconcile discrepancies.
• Converted an undocumented insurance process into a production automation within 3 months, completing development in 2 months and defining requirements with business partners; in its first month, the solution processed 17,506 policies and $1.1M in premium at 1.24 policies per minute versus 1 every 4 minutes manually.
• Corrected a Python file-handling defect that caused claims documents to be missed during each run by appending sequential numbers to duplicate filenames, raising process accuracy from 90% to 97%.
• Modify VBA and Excel macros used with AS400/WINS workflows to resolve processing issues and adapt tools to business-user needs.
• Create Power BI reports and monitoring views that track processing results, failures, exception volumes, and data inconsistencies across automation workflows.
• Translate operational requirements and production findings into workflow updates, validation rules, and process documentation, then train users on revised tools and procedures.
• Maintain code versions in GitHub, track planning and defect work in Jira, and prepare requirements, support, and release documentation for automation deployments.
• 4 years supporting high-volume business data entry operations through manual entry and VBA-driven process automation tools.
• Lead training for manual data entry processes and VBA based macros for data entry, also responsible for QA of trainees' work
• Supported, enhanced, modified, and maintained VBA-based Excel automation tools used in high-volume operational workflows.
• Served as a subject matter resource for processors utilizing VBA automation tools.
• Assisted users with troubleshooting macro-related issues, process questions, and workflow improvements.

Tier 1 Technical Support (Remote) - ChyronHego - New York, NY

(2015-08 - 2020-03)

• Calibrated player-tracking software and camera arrays before live games, tested performance during batting practice, and monitored game-day data capture.
• Diagnosed a camera-to-server outage during an inning break, restarted local hardware, escalated the unresolved failure before play resumed, and documented the recovery steps for later improvements to camera-server connections.
• Reconfigured the camera system after a hardware failure, manually repositioning 4 cameras to maintain complete data capture without reported data loss.