John Spicer Email & Phone Number

Gb

I manage seamless data collection, processing, and analysis efforts, ensuring high quality and integrity across all initiatives. Leading a team of 16, including 3 Senior Data Analysts, 8 Data Analyst IIs, and 5 Data Analysts, I formulate data strategies aligned with organizational goals, transforming business requirements into effective, data-driven solutions. I oversee project lifecycles from conception to delivery, ensuring alignment with timelines and objectives. Additionally, I establish and enforce data governance policies to maintain compliance with privacy standards such as HIPAA, ensuring secure and ethical data handling.I enhance team technical proficiency through comprehensive training programs, leveraging tools like SQL, Alteryx, and ETL methodologies. I maintain professional and cooperative interactions with clients, management, and colleagues, fostering a collaborative and team-oriented approach. Key accomplishments include migrating database management systems from SSMS to Azure Cloud to optimize data storage and accessibility, leading the implementation of ETL processes and automation to improve data handling efficiency, and directing daily operations of the data team while providing mentorship and development support.

Columbia, Sc, Us

I ensured the quality and timeliness of all reporting, both internal and client-focused while collaborating with the operations team to facilitate new client integrations and maintain ongoing client accounts. I provided advanced SQL Server database management, including updating databases and creating tables, views, and stored procedures. Additionally, I mentored junior Data Analysts, supporting their growth and assisting the Data Analyst Manager with supervisory tasks. I managed multiple projects simultaneously, always maintaining the confidentiality and security of protected health information (PHI) in compliance with HIPAA regulations.Key accomplishments include developing and implementing software automation tools to boost productivity, designing and executing comprehensive test scenarios and scripts to contribute to robust software solutions, and consulting with users to assess hardware, software, and system requirements to ensure client satisfaction. I also spearheaded the creation of a Power BI reporting framework, which streamlined data visualization and analysis processes, and managed change requests to maintain project momentum and meet critical deadlines.

Columbia, Sc, Us

I developed comprehensive accounts receivable (A/R) analyses, full reports, flash reports, invoices, and ad hoc deliverables using tools like Power BI, SSRS, Excel, and PowerPoint, ensuring accuracy and timeliness to support both client and internal decision-making processes. My expertise in SQL Server allowed me to maintain database integrity, creating and updating tables, views, and procedures with precision. I also facilitated client data integration by managing data loads, import summary reports, and new client setups, ensuring seamless onboarding of new accounts. Additionally, I analyzed pre-project revenue potential, providing key insights to support business development opportunities.Key accomplishments include improving SQL code efficiency, which significantly reduced processing errors and enhanced data quality and introducing error-catching mechanisms and detailed logging processes to elevate the robustness of data handling procedures. I collaborated closely with the operations team to identify data trends, enabling proactive adjustments to client strategies. I also participated in ongoing educational programs to stay current with industry trends and advancements in technology, ensuring continuous improvement in my technical proficiency.

Columbia, Sc, Us

I executed the loading and scrubbing of client data for database integration, ensuring both accuracy and security, particularly in handling protected health information (PHI). With expertise in SQL Server, I developed and maintained databases, including creating tables, views, and procedures using T-SQL scripting. I streamlined data processing workflows to facilitate the production of critical financial reports, such as the Placement Summary and Weekly Cash Report.Key contributions include organizing and transforming large data sets to successfully import and manage client information within tight deadlines. I also supported the Data Analyst II role by delivering accurate and timely client and internal reports, such as A/R analyses and biweekly updates. Additionally, I produced vital financial reports like the Transaction Recon Summary and Takebacks/Dups Report, which played a crucial role in ensuring transparency and accurate reconciliation of accounts receivable.

Columbia, Sc, Us

I conducted comprehensive training programs for both new and existing employees, focusing on account follow-up processes and client engagement preparedness within healthcare revenue cycle management. I developed instructional materials tailored to key areas such as claims handling, transaction reviews, and patient account resolution. By mentoring staff and addressing performance gaps, I cultivated a learning environment that facilitated continuous technical skill development. I worked closely with the Learning and Education Team to assess training needs and implement effective educational strategies, ensuring staff proficiency and enhanced client service.Key accomplishments include improving staff quality of work by 85% through targeted mentoring, achieving an 80% retention rate by training and developing 100 new staff members annually, and boosting daily production by 50%. Additionally, I played a pivotal role in the creation of job aids and instructional materials, which streamlined onboarding and contributed to ongoing education efforts.

Columbia, Sc, Us

Worked accounts to full resolution – i.e., through payment, adjustment, identification of patient responsibility, and/or client-specified point of return. Resolved accounts and/or performed a secondary review of specific account actions to validate accuracy, completeness and appropriateness of actions taken to resolve accounts in adherence to client, organization, regulatory policies, and procedures. Duties: Possessed a thorough understanding of the hospital revenue cycle with specialization in hospital billing, follow-up, and the account resolution process to include, but not limited to; claims submission, acceptance, and adjudication, transaction reviews, adjustment posting, identification of patient responsibility, etc. Utilized and applied industry knowledge to resolve aged accounts receivable by working various account types. Leveraged available resources and systems (both internal and external) to analyze patient accounting information and took appropriate action for payment resolution. Documented all activity in accordance with organization and client policies Assisted in mentoring of new hires including, but not limited, to shadowing and answering general collection questions.

Columbia, Sc, Us

Analyzed the disposition of aged accounts receivable. Identified necessary actions to resolve the outstanding balance, and took identified resolution steps in adherence to client, organization, regulatory policies, and procedures.

Doctoral Degree, Business Administration And Management, General

Master Of Business Administration - Mba, Business Administration And Management, General

Bachelor Of Business Administration - Bba, Business Administration And Management, General