Kevin Bock Email & Phone Number

Remote

Plainville, Massachusetts, United States

• Day-to-day operational management of a private dental office. Provided tier two support for dental team and escalation of patient issues. Generated weekly and monthly business and accounting reports to owners and.
• Created, analyzed, and provided KPI reports and dashboards to ownership.
• Created company Standard Operating Procedures (SOP) for all positions.
• Lead weekly team meetings.
• Office financial management.
• Insurance claim management and escalation.

Remote

• Executive-level business intelligence data reporting. Assisted other finance groups in configuring reporting and other data requests. Primary technical support of finance analytics team. Translated team’s technical.
• Automated SQL process to collect monthly unreturned equipment inventory report adding customer and financial level data to assist in recovering unbilled revenue in excess of $100,000 per month.o Collaborated with.
• Consolidated data from multiple billing system databases using SQL to generate weekly reports of non-recurring charges adding customer-level information for at-risk customers perform root cause analysis of lost.
• Automated SQL to generate executive Work in Progress (WIP) report for finance dispute resolution department with supporting details, used by Vice President of Finance to report progress of its group to Senior Vice.

Braintree, Massachusetts, United States

• Responsible for ETL, collection, analysis, processing, and billing of 250 million records per month from over 20 different sources into internal data warehouse. Analyzed large sets of SQL data for accuracy issues and.
• Member of four-person team that integrated Broadview and ATX billing and SQL data warehouse systems over a 12-month period.o Gathered business requirements and translated into technical requirements and scripts.o.
• Developed SQL based process to fulfill law-enforcement and internal team subpoena requests for allowing search of calls across SQL database of one billion records.o Innovated process to be insourced to a single group.

Braintree, Massachusetts, United States

• Created processes and reports to determine validity and accuracy of all processed usage. Communicated with internal teams during network changes. Analyzed large datasets providing executive-level reporting and.
• Member of four-person team that completed the migration of Bridgecom billing and SQL data warehouse systems to Broadview over a six-month period.o Gathered business requirements and translated into technical.
• Corrected migration carrier access billing from one vendor to another.o Created new SQL processes, reports, dashboards, and audits, as well as supporting documentation for billing over $1,000,000 monthly.o Enabled.

Braintree, Massachusetts, United States

• Identified and resolved issues for all groups under Senior Vice President of Operations. Collaborated with other groups as needed in SQL reporting, process improvement, and tool and application creation. Main technical.
• Member of four-person agile team that completed the migration of Network Plus to Broadview billing over 12-month period.o Gathered business requirements and translated into technical requirements and scripts.o Migrated.
• Developed applications, using SQL, Visual Basic, and MS Access to assist care, sales, and escalations groups in supporting day-to-day operations.o Provided 20 different report functions used by over 100 support team.
• Named to President’s Club in 2002.

Randolph, MA

Bs, Industrial Design

Aerospace Engineering