Professional Headshot of John Victor Ubana

Enterprise Systems Architect & Operations Leader

๐Ÿ“Œ Looking to volunteering: Animal Welfare ยท Science and Technology, Information Technology ยท Dogs

๐Ÿ’ผ Career: Tharp Custom Cabinetry (2026) ยท Ridgeview Classical Schools (2021โ€“2025) ยท Elcon Precision (2012โ€“2021)

Enterprise Systems Architect & Process Automation Leader with 15+ years eliminating operational silos and building intelligent technology backbones for manufacturing and service organizations. Expert in seamless system integration, workflow automation, and turning complex technical challenges into competitive advantages.

Performance Analytics

Interactive Accomplishments Dashboard

Explore 55+ documented projects by filtering strategic domains, organizational context, or by using the search function. Deep-dive analytics across Tharp, Ridgeview, and Elcon initiatives.

Tharp Performance
Pipeline Projects 12
Queries Deployed 40+
Automation Coverage 100%
Technical Depth
Power Query
Infor Syteline
PowerShell
Power BI
Business Impact
14

Commission Queries Automated

80-110h

Annual Time Saved

100%

Data Accuracy

๐Ÿš€ Key Project Highlights (Tharp, Ridgeview & Elcon)

๐Ÿ”„

Cabinet Vision โ†’ Infor Syteline BOM Pipeline (Tharp)

Engineered end-to-end automation eliminating manual data transfer and reducing order-to-production cycle time with intelligent prefix-based routing and zero-width character handling.

DecisionExcelerator PowerShell CAD Integration
๐Ÿ“Š

Tharp ERP Dashboard

  • โœ… 12 Projects deployed & maintained
  • โœ… 40+ Power Query scripts automated
  • โœ… 100% Data Integrity across BI dashboards
  • โœ… Cabinet Vision โ†’ Infor Syteline full pipeline
  • โœ… Real-time reporting framework
๐Ÿ”—

Data Integration Framework (Tharp)

Built reusable Power Query architecture connecting Infor Syteline to BI platforms with custom date parsing and multi-workcode filtering for real-time reporting.

๐Ÿ’ฐ

Major Project Budget Control (Ridgeview)

Executed $230k+ infrastructure upgrades $14,839 under budget, demonstrating financial oversight and operational stewardship across multi-phase technology initiatives.

โš™๏ธ

ERP Costing System (Elcon)

Authored procedures formalizing Sage 100 financial structure for labor rates and overhead, establishing foundation for accurate job costing and profitability analysis.

๐Ÿ“ˆ

Commission Reporting v2 (Tharp)

Architected 14-query automated system with modular configuration, ensuring 100% accuracy and eliminating manual calculation errors for payroll processing.

๐Ÿ“ž

Service Desk Management (Ridgeview)

Implemented centralized ticketing system achieving 85% first-hour resolution rate, drastically improving support efficiency and user satisfaction.

๐Ÿ“Š

OTD Reporting (Elcon)

Developed custom SQL/Excel reports tracking On-Time Delivery against customer promise dates, enabling proactive delinquency management and risk analysis.

๐Ÿข Filter by Organization:

๐ŸŽฏ Filter by Strategic Domain:

Technical Mastery Audit

๐Ÿ“ ERP Process Ownership

๐ŸŒ Infrastructure Portfolio

BI Performance Visualizations

Data-driven impact metrics across infrastructure, finance, and operations

Cumulative Cost Savings Trend

Recurring annual savings + one-time recoveries across all initiatives

System Reliability & Uptime

99.9%

Managed uptime across 500+ users

~52.6 minutes downtime/year

Capital Project Budget Control

Process Mastery Audit

Data Quality & Integrity

ERP Data Accuracy 94%
BI Reporting Completeness 98%
Error Rate Reduction 87%
Process Standardization 92%

Technology Stack Adoption

ERP Systems BI/Analytics Cloud Infra Security

Methodology Adoption

Agile (Jira)
Waterfall (MS Project)

Operational Efficiency Gains

Strategic Portfolio Performance

Initiative Timeline Status Financial Impact Users Affected
Multi-Phase IT Capital Upgrade (Ridgeview) 2023โ€“2024 โœ“ COMPLETE -$14.8K (Under) 500+ users
ERP & BI Optimization (Sage 100, Elcon) 2017โ€“2021 โœ“ COMPLETE 100% ROI 50+ staff
Cloud Migration (Azure/M365, Ridgeview) 2022โ€“2023 โœ“ COMPLETE On-Budget 500+ users
NIST Cybersecurity Framework (Ridgeview) 2022โ€“2024 โœ“ COMPLETE Risk โ†“ 50% Enterprise
Infor Syteline Implementation (Tharp) 2025โ€“2026 โ— IN PROGRESS Pending Delivery 90+ users

PM Toolkit & Governance

MS Project Jira ClickUp ITIL Change Control NIST/ITAR Compliance

Resource Stewardship

  • โ€ข Secured 10% reduction in annualized VoIP/ISP spend.
  • โ€ข Negotiated contract terms for multi-million dollar infrastructures.
  • โ€ข Coordinated security, safety, and faculty teams for rollouts.

Career Timeline

15+ years of progressive leadership across manufacturing, education, and cabinet design

15+

Years Experience

3

Organizations

1000+

Users Supported

58

Projects Delivered

ERP Technical Analyst

Tharp Custom Cabinetry

โš™๏ธ

March 2026 โ€“ Present

20

Projects

90+

Users

4mo

Tenure

  • Manage Infor Syteline (Infor Syteline) ERP via Mongoose framework with 90+ concurrent users
  • Engineered Cabinet Vision โ†’ Infor Syteline BOM automation pipeline (PowerShell stack)
  • Built 14-query Power Query commission reporting system

Director of IT

Ridgeview Classical Schools

๐Ÿซ

2021 โ€“ 2025 (4 years)

21

Projects

500+

Users

$230K+

Budget Managed

  • Led $230K+ capital projects ($14.8K under budget)
  • Implemented NIST-aligned cybersecurity (50% risk reduction)
  • Architected 99.9% uptime infrastructure for 500+ users across Azure/Google Workspace

Volunteer Technical Consultant

God's Helping & Healing Hands

๐Ÿค

2024 โ€“ Present

2

Years

โ€”

Volunteer

Ongoing

Commitment

  • Provide technical administration & security oversight
  • Secure software grants to maximize operational budget efficiency

Project Management & Systems Specialist

Elcon Precision LLC

๐Ÿญ

2012 โ€“ 2021 (9 years)

15

Projects

50+

Staff

100%

ROI

  • Led Sage 100 ERP implementation & formalized labor costing procedures
  • Authored ITAR/EAR compliance procedures with 256-bit AES encryption standards
  • Developed advanced SQL/VBA reporting (OTD, Job Costing, Gold Calculations)

๐Ÿ“Š Key Achievements

  • โœ“ $1.68M+ cost savings documented
  • โœ“ 3 ERP systems mastered (Sage 100, Infor Syteline)
  • โœ“ 58 projects delivered across domains
  • โœ“ 1000+ users directly managed

๐ŸŽฏ Core Competencies

  • โ€ข ERP Administration & Implementation
  • โ€ข Business Intelligence & Data Analytics
  • โ€ข Financial Stewardship & Budget Control
  • โ€ข Infrastructure & Security Architecture

๐Ÿ“ˆ Responsibility Growth

  • Team: 1 โ†’ 50 โ†’ 500+ users
  • Budget: $0 โ†’ $230K+ managed
  • Scope: Specialist โ†’ Director โ†’ Technical Architect
  • Impact: Individual โ†’ Enterprise โ†’ Multi-Org

Socials & Continuous Learning

I believe that excellence in IT requires a commitment to lifelong learning and academic precision. I am constantly expanding my technical stack and management methodology to stay at the forefront of the industry.

๐Ÿ“œ

Academic Excellence

"In the kiln of higher education, a foundation of steel was forged."

My academic journey transpires as a substantive display of dedication. Achieving high-tier honors and a GPA that mirrors my professional precision, I maintained a standard of excellence that foreshadowed my reputation as the "beast IT guy."

๐Ÿš€ View Official Transcript
๐ŸŒŸ Dean's List & Honors Graduate
๐ŸŽ“

Skill Mastery Audit

Track my technical certifications and continuous skill progression in cloud infrastructure, security, and advanced data analytics via Pluralsight.

๐Ÿ‘ฅ

Community Hub

Connect with me for community updates, professional networking, and personal insights into the intersection of technology and community growth.

Core Competencies

A multi-disciplinary matrix of technical, strategic, and analytical proficiencies.

๐Ÿ› ๏ธ Technical Systems

Infor Syteline (Infor Syteline) & Mongoose Power BI & Power Query (M-Code) Complex SQL Joins Sage 100 ERP (Mastery) VBA & Excel Automation Microsoft 365 Admin Azure & Google Workspace Sonicwall/Meraki Networking Verkada Security & Access MS Project, Jira, ClickUp & Slack MDM (Intune/WDS/MDT) EdTech (PowerSchool/Edsby) Data Cleaning & NaN Resolution

๐Ÿ“ˆ Strategic Leadership

Project Management (Agile/Waterfall) IT Roadmap Forecasting Budget & License Optimization NIST & ITAR Compliance Vendor Performance Mgmt Cost Accounting Integration Process Formalization (AP Specs) Data Governance & Integrity Disaster Recovery Planning Cross-Functional Leadership

๐Ÿ“Š Analytical Attributes

Technical Writing (Procedures) Business Intelligence (BI) Root Cause Analysis MRP Process Flow Systems Administration Data-Driven Decision Making Stakeholder Communication Analytical Problem-Solver Adaptable & Quick Learner Detailed Financial Stewardship

Executive Personality Blueprint

An analytical assessment defining the "Strategic Architect" archetype: A fusion of high-level technical precision, data-driven operations, and stoic leadership.

The Strategic Architect Matrix

Visualizing the "Magic Touch" combined with disciplined restraint.

๐Ÿง 

Analytical Precision

Synthesizes complex data into actionable strategy. Thinks deeply about past outcomes to instigate future success.

โš™๏ธ

Data-Driven Operator

Favors specific metrics (budget variances, net carbs) over abstraction. Adheres to a rigorous denominator of quality.

๐Ÿ—ฟ

Stoic Fortitude

Maintains disciplined restraint in high-stakes environments. Unaffected by external emotional fluctuations.

๐Ÿช„

Technical Mastery

The "beast IT" factor. Provides a deep sense of security through undeniable technological prowess and stewardship.

Professional Endorsements

Validating technical prowess through peer testimony and a commitment to ethical governance.

๐Ÿ†

Performance Excellence

"A rare fusion of technical mastery and interpersonal grace."

Review formal employee evaluations and performance metrics that document a history of high-level responsiveness, NIST-aligned security management, and consistent praise for technical leadership and user support.

๐Ÿš€ View Professional Evaluations

Direct Contact Information

Please reach out directly to discuss job opportunities or contract work.