Data Analysis Manager, Systems 2015–2018• Manage and mentor a diverse team of Data Analysts of varying experience levels, providing learning opportunities for professional growth.• Provide process and data guidance to multiple departments to include the most efficient and cost-effective methods to accomplish stated goals.• Interpret data & analyze results using statistical techniques on behalf of multiple departments, including Operations, Banking, Finance, and Compliance.• Troubleshoot data-related problems for source and solutions. • Draft complex data update and insertion scripts as necessary into proprietary project-specific databases.

• Assessed project and processing requirements based on court documents including Stipulation Agreements, Plans of Allocation, Notices and Claim Forms. • Translated business needs into technical requirements for Systems. • Reviewed and analyzed data and processes, including data monitoring, plans of allocation, documents, and financial distribution for settlement funds ranging from $300K to $105M• Prioritized and managed competing deadlines based upon court requirements. • Utilized best practices to ensure cost savings (i.e., NCOA search to save on postage for 1M+ piece mailing).

Furnished analytical support for solution development and system changes. Collaborated with internal and external customers to identify and specify business requirements and processes. Analyzed and defined requirements for system impact; determined system, data, and data structure requirements. Prepared specifications for enhancements, development, and problem resolution requests. Identified error trends and presented feedback to management, along with project and account issues. Worked with client managers to identify and specify industry needs. Participated with clients and applicable, internal functional areas throughout development, enhancement, conversion, defect, testing, and installation processes.• Researched and evaluated alternative approaches to customized, customer needs—explained and translated actual needs to customers. Recommended efficient and cost-effective solutions.• Served as the SME on SQL, HIPAA 834 reporting, DMV regulations, insurance laws, and insurance-reporting for most states; conducted training to associates.

• Created custom reports and deliverables. • Established data quality reports for business units to review and monitor for accuracy. Updated market trackers to reflect continually changing needs of clients.• Maintained all steps in the technical production of meter categories. Oversaw special projects and ad hoc, SQL requests.• Reduced the monthly production cycle from 35 days to 17 days by streamlining the musical digital- production process.• Served a key role in major technical and procedural contributions to the successful launch of 2 video digital products.

Managed the technical growth and development of a 16-member team. Supported and coached 75 eligibility services employees in four states, seven billing analysts locally, and additional billing personnel in two states. Conducted training for SQL and proprietary systems. Developed complex, nonstandard SQL reports to support customer needs. Reviewed and approved job aides for distribution to eligibility analysts companywide. Resolved escalations. Participated in interviewing and hiring. Defined and developed business practices and requirements for new, eligibility-services procedures.• Documented, explained, and coordinated HIPAA 834, FSA, and HSA requirements to internal and external clients.• Discovered critical errors by assessing error trends for global and system-related impacts.• Converted client eligibility files into a format compatible with proprietary systems by writing detailed, complex, programming specifications.• Served as the project leader for national and location-based special projects.

• Business practices and requirements for IT planning• Legal research regarding documentation requirements• Development of dynamic forms, using SQL to feed data into static text• Quality Assurance Testing