Aric Jimenez | Public Safety Modernization Artifacts & AI-Enabled Delivery

Reporting Modernization & Data Platform Strategy

Power BI | tableau | SRSS

PowerBI - Calendar Year | Demographic Drill Down

PowerBI - Calendar Year | Geospatial Drill Down

tableau - Calendar Year | Revenue Generation

SQL Server Reporting Services (SSRS) - School Benchmark Reporting

I help agencies move from fragmented reporting to supportable analytics ecosystems. This includes legacy SSRS, Power BI, operational reporting, cloud databases, hybrid replication, Snowflake/Databricks alignment, KPI governance, validation checkpoints, and executive-ready views. AI-assisted engineering can speed up discovery, mapping, and documentation while governed data and human review keep analytics dependable.

SaaS Deployment, Integration & Vendor Enablement

Angular | .NET | JS | SQL | Postgres | Figma | JIRA | Trello

Clickup - Development Project Management

QWS - Quick Writing Scores - SAAS Assessment Rubric Based Writing Tool

PSA - Public Safety Academy - SAAS Training Academy solution that standardizes operations.

TMG - Track My Grants - SAAS grant management solution that tracks through a workflow that is mandated by a governance process.

Trusted Driver - SAAS Police Department citation solution not requiring hardward. Other products include - court backoffice management, analytics, and other governance processes.

Vendor-side and agency-side implementation support across integrations, data exchange, workflow validation, and adoption. I translate operational needs into technical workstreams, reduce cutover friction, and help teams preserve reporting and interface continuity after migration. AI-assisted engineering supports discovery, ETL development, schema mapping, test design, documentation, and readiness work, with subject-matter review at each step.

Enterprise Architecture & Migration Governance

Lucidchart | draw.io | Visio | Teams | Slack | GitLab | Docker

High Level Infrastructure - Supporting Enterprise SAAS Solution

Enterprise Process Diagram - SAAS solution with 3 API

Enterprise Process Diagram - SAAS solution with Single Sign using Azure AD

Enterprise Relational Diagram - SAAS On-Boarding Employmment solution

Enterprise Relational Diagram - SAAS Records Management Solution

GitLab - Managing releases to different environments

Docker - Controlling differnet images that are being released from Docker management

Architecture artifacts used to drive modernization: dependency mapping, migration sequencing, data model alignment, CJIS-aware governance, interface planning, validation checkpoints, and executive decision support. The goal is repeatability and reduced risk.

AI-Assisted Modernization & Responsible AI Readiness

I apply AI-assisted engineering to practical modernization work: exploring legacy data, drafting schema mappings, accelerating ETL and ingestion scripts, preparing validation tests, and improving documentation. AI supports the work; agency experts remain accountable for decisions and acceptance.

Modernization workflow

Discover → map → transform → stage → validate → review → ingest → govern.

Delivery guardrails

Human review, data quality checks, security and CJIS-aware handling, traceable changes, and agency sign-off.

Operational Programs, DFR & Multi-Agency Innovation

Ideas | Creativity | Innovation | Design | Execution

ESRI - San Antonio Fusion Center - Public Safety with GIS in the Field

ESRI - Safety & Security Summit Presented - Situational Awareness using Common Operating Picture

Fusion Center - Tactical Response to a virtual cyber threat using drones to respond quickly in urban area

IACP - International Association of Chiefs of Police - Presented after action for Special Events using the Core Network capabilities.

Program design and operational enablement, including Drone as First Responder, fusion center operations, special events, geospatial awareness, and multi-agency information sharing. I focus on governance, adoption, CAD/RMS workflow integration, and measurable public safety outcomes.

Awards and Recognition