Hialeah, Florida · Available for new roles

Hiram Sanchez

Senior Business Analyst    POS Systems Specialist

Eighteen years engineering enterprise retail technology — POS platforms, SQL Server, ASP.NET applications, and the in-store software that keeps a 400-register operation running. Lately, leaning hard into AI-assisted development.

18+
Years in retail tech
400+
POS registers managed
200+
SQL servers
30+
In-store apps shipped
~5K
Business rules governed
§ 01

The work behind the work.

I work at the intersection of point-of-sale systems, SQL Server engineering, and the day-to-day technical glue that keeps an enterprise retail operation running. For the last eighteen years that's been at Duty Free Americas, where I'm the gatekeeper for POS change control and business-rule governance across 400+ registers and 200+ SQL servers running Oracle Xstore.

I'm probably most proud of POS Plus Platform — a suite of 30+ custom in-store applications I built and maintain, running 24/7 across all locations to extend Xstore functionality where the platform stops. Beyond that, my day looks like SQL schema work, ASP.NET application development, ERP integrations with Oracle Retek Resa and SIM, BI/SSRS reporting, and the occasional payment-hardware integration.

Lately I've leaned hard into AI-assisted development — Claude, GitHub Copilot, ChatGPT, Gemini, and Ollama for local models. The honest version of that story isn't "AI replaces engineers"; it's that I can now ship internal tools, automate documentation, and shorten time-to-resolution on complex incidents at a rate that wasn't possible two years ago.

I'm a calm problem-solver who likes owning things end-to-end — from debugging a register at the script level to architecting a new integration. Bilingual (English / Spanish). Based in Hialeah.

§ 02

Where I've been operating.

Feb 2008 — Present
Senior Business Analyst & POS Systems Lead
Duty Free Americas · Hollywood, FL
POS platforms & governance
  • Own POS change control and business rules across 400+ registers and 200+ SQL servers, including a rule database of ~5,000 covering promotions, discounts, tenders, and store behaviors.
  • Implemented and maintain Oracle Xstore, Xcenter, and Xoffice; installed, tested, and certified a new POS system company-wide and worked on the Oracle 16 upgrade.
  • Lead configurator for SAP POS 2.3 across multiple retail divisions (builds, testing, gold images, store upgrades); trained and certified on GK Software POS.
  • Work directly in Xstore's pricing internals (deal engine and customer-group triggers, manual discounts, hierarchical item pricing, coupons) to deliver wholesale, KYC-tier, and loyalty pricing Xstore doesn't support out of the box.
  • Run the POS lab: several Xstore lab registers for testing upgrades, researching new features, and proving changes before they reach stores.
Applications & development
  • Architect of POS Plus Platform, a suite of 30+ custom applications running 24/7 across all retail locations.
  • Built and run Xstore Hub, an IIS portal unifying DFA's internal Xstore web apps with monitoring for every scheduled console job behind them.
  • Built ASP.NET applications for employee management (Xstore / Xoffice integration), A/R customer management with KYC, and store attributes (taxes, receipt header/footer), each producing flat files for store deployment.
  • Spec-driven AI-assisted development: research, lab proof, a written PLAN.md / CLAUDE.md, then the build with Claude Code in Visual Studio.
  • Developed a custom Magento admin interface on the Magento API with VB.NET, plus mobile app work in Ionic / Cordova and Xamarin.
  • Built BI dashboards and SSRS reports for real-time visibility into sales, exceptions, KPIs, and system health.
Data & integration
  • Oracle 19c (SQL*Plus, SQL Developer, Toad) for schema research and scripted changes; SQL Server across 200+ store servers rolled out with custom views; Oracle and Magento database administration (backups, restores, indexing).
  • Maintain the ERP transformation and integration servers and correct transactions that fail on their way into Oracle Retail ReSA and SIM.
  • Keep data moving with scheduled tasks and MNT / DataLoader files, including an automated inventory movement system that collects and stages store inventory files every five minutes, built in native batch to meet a locked-down security policy.
Payments, hardware & rollouts
  • Delivered PCI compliance, EMV / contactless certification, merchant credit/debit testing, Dynamic Currency Conversion, and loyalty integration.
  • Tested and launched the first-generation tablet POS and peripherals, mobile sales, and a customer self-checkout that improved on the older POS.
  • Integrate and support Verifone pinpads (forms, MX Downloader), Zebra scanners (123Scan), NCR receipt printers, and mobile devices managed through SimpleMDM and Scalefusion.
  • Run the in-store digital signage network with Samsung MagicInfo and BrightSign, scheduling content and deploying media to store displays.
Support, operations & training
  • Primary Tier 2 escalation point: trace incidents through xstore.log, repl.log, replicationAudit.log, PosLog and EFTLink logs to separate store-side from Xcenter-side failures.
  • Prepare gold images, install and configure POS software, and script monitoring and maintenance for 400+ registers.
  • Windows administration: group policy, user and password management, and LAPS, coordinating Active Directory issues with the network team.
  • Work with vendors on issue resolution, upgrades, patches, hardware, and larger projects.
  • Store and corporate trainer; author SOPs, documentation, and Camtasia training videos for IT staff and store users.
2023 — Present
Founder & Operator Side Venture
Independent E-commerce Business
  • Operate a Shopify storefront with Printify integration for end-to-end print-on-demand fulfillment — theme customization (Horizon), product catalog, and order operations.
  • Built custom internal tools to streamline content ops: a Metricool-compatible CSV export for multi-platform video scheduling, a brand-voice-driven social post generator across five platforms, and a Shopify-aware post generator.
  • Manage multi-platform social media (Facebook, Instagram, TikTok, YouTube, Pinterest) via Metricool, Postiz, and Post Studio.
  • Produce graphics, product art, and promotional content with Adobe Photoshop / Illustrator, Canva, and Leonardo.ai.
Jan 2004 — Feb 2008
Assistant Manager
Best Buy · Hialeah, FL
  • Ran daily store operations and customer experience in a high-volume retail environment.
  • Trained and coached staff, improving sales performance and operational consistency.
  • Managed inventory, merchandising, and customer escalations with a focus on service quality.
§ 03

Two platforms, two different problems.

One lives on the registers and keeps 400+ lanes running. The other is the front door for the business users and support staff who manage what those registers do.

A In-store · Register level

POS Plus Platform

A suite of 30+ custom in-store applications I architected and maintain, running 24/7 across every retail location. It exists because off-the-shelf POS, even something as substantial as Oracle Xstore, can't anticipate every operational reality.

When the platform falls short of what stores actually need, I build the piece that closes the gap, then keep it running: monitoring, scheduled maintenance, register-level utilities, and the file-based integrations that move data between stores and central systems.

30+
Production applications running 24/7 across every retail location.
CoverageAll stores · 400+ registers
Uptime24/7 production
Stack.NET · VB.NET / C# · batch
OwnershipDesign through support
B Central · Web portal

Xstore Hub

An IIS-hosted portal that brings all of DFA's internal Xstore web applications under one roof, with built-in monitoring for every scheduled console job behind them, from promotion publishers to inventory movement jobs.

Business users, authorizers, and the support desk get one place to manage employees, store data, promotions, and customer tiers without touching the database directly. IT gets one place to see whether the jobs that feed the stores actually ran.

9
Internal Xstore applications built and running in production.
HostingIIS · host-name bindings
StackASP.NET · .NET 8 → 10
DataOracle 19c · SQL Server
MonitoringAll scheduled console jobs
Applications delivered
Employee ManagementEmployee records and access with Xstore / Xoffice integration
Store Info ManagementPer-store attributes, taxes, and receipt header and footer
Xstore Flight ExceptionAirport flight-data exception handling
KYC Tier PortalImports KYC customer exports and assigns four pricing tiers via MNT
Discount ManagerManages Xstore manual discounts and wholesale pricing without direct DB work
Simple Promo AppPromotion entry, authorizer approval, and auto-publish as MNT files every 15 minutes
PromoCheckerCatches errors in DataLoader promotion and deal files before they reach stores
Coupon AppRole-gated coupon creation and QR-redeemable serialized coupons with use limits
Support Desk RotaSupport desk staff scheduling, rebuilt in ASP.NET
§ 04

How the work actually gets done.

→ 01 · Incident analysis

Production incident root-cause analysis

Investigated a reported data discrepancy between a store and the central Xcenter environment. Analysis of Xstore application and replication logs confirmed every record had replicated successfully after transient connection retries, isolating the issue to the central system and routing remediation to the right team.

→ 02 · Pricing research

Wholesale and KYC pricing in Xstore

Xstore has no native wholesale feature, so I delivered one by combining three existing engines: hierarchical item pricing, the deal engine with customer-group triggers, and manual discounts. I also delivered four KYC customer pricing tiers driven by MNT group assignments instead of cashier buttons.

→ 03 · Deal engine

Automatic loyalty deal

Built a transaction-wide 10% loyalty deal with customer-group triggers across five loyalty tiers, replacing a cashier-applied discount so qualifying customers get the price automatically.

→ 04 · Integration

Inventory movement automation

Built a scheduled integration that collects inventory movement files from every store every five minutes and stages them centrally for downstream processing, tagging each with store and timestamp and keeping daily audit logs with 30-day retention. Engineered in native Windows batch to meet a locked-down security policy.

→ 05 · Method

Research → lab → spec → build

Every project follows the same loop: read the Xstore manuals and the live schema, prove the approach in a lab database, write a PLAN.md / CLAUDE.md specification, then hand the build to Claude Code inside Visual Studio.

→ 06 · Enterprise rollouts

Payments, compliance, and new lanes

PCI compliance, EMV and contactless certifications, Dynamic Currency Conversion, loyalty integration, first-generation tablet POS, and customer self-checkout, plus Verifone pinpad and Zebra scanner integration across the fleet.

→ 07 · Multi-platform POS

More than one POS platform

Lead configurator for SAP POS 2.3 across multiple retail divisions: managing builds, testing every release, preparing gold images, and upgrading stores. Also trained and certified on GK Software POS, so I've run more than one platform end to end.

→ 08 · Digital signage & web

Store screens and the e-commerce back office

Run the in-store signage network with Samsung MagicInfo and BrightSign, scheduling content and pushing media to store displays. Separately built a custom Magento admin interface on the Magento API with VB.NET to manage the e-commerce site.

§ 05

The toolkit.

POS Platforms
Oracle Xstore · Xcenter · Xoffice · Xcenter replication · RTLog broadcaster · SAP POS 2.3 · GK Software POS
Xstore Internals
Deal pricing engine (prc_deal, customer-group triggers) · manual discounts (DSC_*) · hierarchical item pricing & Best Deal · serialized coupons · customer affiliations · MNT / DataLoader
ERP / Retail Systems
Oracle Retail ReSA · SIM · RTLog · ERP transformation servers
Databases & BI
Oracle 19c (SQL*Plus, SQL Developer) · SQL Server (T-SQL, schema design, stored procedures, tuning) · SSRS · KPI & exception reporting
Development
ASP.NET · .NET 8 → .NET 10 · VB.NET / C# · IIS hosting · console publisher services · Batch / cmd · PowerShell (DPAPI credentials) · React · JavaScript
Payment & Compliance
Verifone pinpads (forms, MX Downloader) · EMV / contactless · PCI · merchant credit/debit certification · Dynamic Currency Conversion
Mobile & Devices
Tablet POS · mobile sales · Ionic / Cordova · Xamarin · SimpleMDM · Scalefusion · Zebra scanners (123Scan) · NCR receipt printers
Digital Signage
Samsung MagicInfo · BrightSign · content scheduling · media deployment to store displays
AI-Assisted Development
Claude Code in Visual Studio (spec-driven: PLAN.md / CLAUDE.md) · Claude · GitHub Copilot · ChatGPT · Gemini · Ollama
E-commerce & Creative
Magento (API integration) · Shopify (Horizon themes) · Etsy · eBay · Printify · Adobe Photoshop & Illustrator · Canva · Leonardo.ai
Systems / Remote Admin
Intel AMT · PsExec · UltraVNC · WMI · WinRM · Group Policy · LAPS · Windows Scheduled Tasks
Tools & Workflow
Visual Studio (2012 through current) · SQL Server Management Studio · Report Builder · Toad · Jira · Assembla · SAP Configurator · Camtasia · Microsoft Office · Google Workspace
Education
Associate's Degree
Miami Dade College
Languages
English · Spanish
Native bilingual
§ 06 · Get in Touch

Let's talk shop.

Open to senior IC and lead roles — POS systems, business systems analysis, solutions architecture, retail technology, or anywhere deep retail-stack knowledge meets AI-assisted engineering.