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 outside professional services. Process improvement and technical documentation creation for all aspects of the business.• 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.• Implemented new patient communications systems.• Patient and team issue management.• Main contact for vendors and technicians.• Developed HIPPA, OSHA, Infection Control/COVID protocols.• Project manager of new office building development.O Managed team of engineers, architects, town officials, and buildersO Prepared financial records and reports for SBA

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 requirements for company-wide data into Oracle and SQL environment including Tableau dashboard creation.• 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 external departments to gather business requirements and translated into technical requirements and scripts.o Created and automated SQL code to combine information across databases into a unified table for dashboard reporting.• 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 revenue.o Provided Vice President of Finance and Collections with statistical analysis needed for month-end executive reporting.• 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 President.o Enabled internal team to meet Service-Level Agreements (SLAs) by prioritizing working of queue from oldest to newest.

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 trending. Provided key reports and dashboards for executive team. Performed revenue assurance, data analytics, operations reporting, financial reporting, data management and ad-hoc reporting.• 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 Migrated all customer-level SQL data, auditing and confirming billing accuracy of over 30 million monthly records.• 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 over the previous process which involved two teams and an outside vendor.o Reduced turnaround time from days to under one hour.

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 dashboards.• 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 requirements and scripts.o Migrated all customer-level SQL data, auditing and confirming billing accuracy of over 20 million monthly records.• 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 reduction of processing time from five days to one, while also reducing team size from three to one.

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 contact between financial and customer service teams with IT group.• 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 all customer-level data, auditing and confirming billing accuracy of over 15 million calls.• 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 members.• Named to President’s Club in 2002.

Randolph, Ma

Bs, Industrial Design

Aerospace Engineering