John B. Email & Phone Number

Troutman, Nc, Us

San Francisco, California, Us

Manage data science initiatives for the Consumer-Small Business Banking team, focusing on advanced analytics and AI-driven solutions. Oversee the automation of reporting functions and database updates in SQL Server, contributing to operational efficiency. Collaborate and work closely with business leaders to ensure the effective use of data holdings, enabling informed decision-making through the development of telemetry databases.Highlights of accomplishments in this role include:• Spearheaded the migration of 150 Oracle-based staging tables into a streamlined Hadoop environment, reducing the table count by 87% and achieving significant cost savings in data storage.• Designed and implemented a proof-of-concept telemetry database in SQL Server for an enterprise-wide data and analytics recommendation platform, aimed at providing leadership with critical insights into data usage patterns. • Improved data governance and resource allocation efficiency, and currently collaborating on phase 2 to integrate metadata from additional systems.• Achieved recognition as the first Alteryx Change Champion across the business unit, automating workflows that cut monthly reporting workloads by 12 hours and reduced daily book-balancing tasks by two hours for international finance teams

Columbia, Missouri, Us

Cooperated with cross-functional teams to gather and analyze sales data, developing comprehensive reporting solutions that addressed key business challenges. Delivered actionable reports and dashboards using Looker, supporting Key Performance Indicator (KPI) tracking across various management levels and refining data-driven decision-making processes.Highlights of accomplishments in this role include:• Recovered over $2M in unpaid insurance premiums by updating the insurance premium dashboard and identifying discrepancies in tracking policies and payment expirations using SQL.• Audited and optimized the Looker BI platform by reducing the number of administrators by 80%, implementing structured user roles based on job descriptions, and strengthening platform security and functionality.• Automated data pipelines in PyCharm and Jenkins, improving data processing efficiency by 10% and reducing manual intervention in data processing by 20%.• Created a detailed administrative guide for the Looker platform, providing leadership with a streamlined process for ongoing user role administration and BI tool optimization.

Arlington, Virginia, Us

Collaborated and worked closely with senior Department of Defense leaders to assess and upgrade the effectiveness of analytical programs, tools, and training initiatives. Steered efforts to collect, organize, and analyze U.S. Army operational data, generating insights to inform long-term modernization strategies. Compiled critical findings into comprehensive reports, handbooks, and information papers, disseminating key operational lessons across military leadership.Highlights of accomplishments in this role include:• Directed a cross-functional team of 80 analysts in consolidating data on the U.S. Army's response to COVID-19, producing two executive-level reports that drove operational changes across the force.• Supervised a team of 14 senior analysts in producing detailed reports on U.S. Army operational support during the Ukrainian conflict, providing critical insights consumed by the Secretary of the Army and other top military officials.• Initiated a strategic planning effort to realign the Army’s analytical programs with evolving priorities, increasing resource utilization by 50% and ensuring mission-critical objectives were met.• Authored 12 key publications, including four handbooks and eight information papers, documenting best practices and lessons learned from ongoing military operations, contributing to budget-conscious modernization initiatives.

Arlington, Virginia, Us

Led data collection, validation, governance, and analysis efforts on adversary activities and military capabilities to facilitate U.S. national intelligence objectives. Confirmed compliance with analytic standards by performing quality assurance inspections in alignment with Director of National Intelligence guidelines. Produced intelligence products that informed U.S. Army operations and contributed to national security planning.Highlights of accomplishments in this role include:• Authored 12 comprehensive studies on adversarial military operations, with two studies included in the Presidential daily read-book, contributing to high-level decision-making.• Supported 24 additional analytical reports, presenting threat capability briefings to five military units preparing for deployment, advancing mission readiness, and strategic planning.• Evaluated 40 analytic products for compliance with post-9/11 standards, serving as a tradecraft representative to maintain rigorous quality and analytical integrity across intelligence outputs.• Pioneered the production of actionable intelligence products as the first uniformed analyst at NGIC, transitioning the role from administrative to analytical and establishing a new standard for uniformed personnel.

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Arlington, Virginia, Us

Master'S Degree, Data Analytics

Bachelor'S Degree, History

Nanodegree, Programming For Data Science With Python

Professional Certificate, Google Data Analytics

Certificate, Creating Business Value With Data And Looker Specialization