⚙️
Engineering
Design and build scalable apps, RESTful APIs, and stable releases with CI/CD fundamentals and solid documentation.
Available for new projects
Websites • Web Apps • Databases
Building fast, reliable systems — from UI to data pipelines.
Web & App Developer with 8+ years of experience delivering business websites and scalable web applications, optimizing databases, and leading IT support workflows in Agile environments.
SQL Server optimization: -35% execution time
Support SLA: 95% tickets resolved < 24h
Downtime reduction: -30% via proactive monitoring
Quick Profile
- Core: Business websites, custom web apps, REST APIs, SQL performance, ETL
- Frontend: AngularJS, jQuery, Bootstrap
- Backend: C#/.NET, Java
- Data: SQL Server, Oracle DB, ODI, MySQL
- Ways of working: Agile/Scrum, Jira, Confluence, Git
- Certs: CSM • Azure Fundamentals
What I bring
Clear documentation, predictable delivery, and systems that stay up. I combine hands-on engineering with practical support experience to keep products running smoothly.
About
I’ve spent the last 8+ years building and supporting business-critical software. My work spans full stack development, database performance, and structured data migration projects (Oracle + ODI). I care about clean architecture, measurable outcomes, and making systems easy to maintain.
📊
Data & Performance
SQL Server tuning (queries & structures), data integrity, validation routines, and ETL workflows with ODI.
🛡️
Operational Mindset
Support leadership experience: SLA-driven resolution, proactive monitoring, training, and repeatable runbooks.
Impact
Selected outcomes from recent roles and projects.
35%
SQL Server query & structure optimization improved execution time and app performance.
95%
Support tickets resolved within 24 hours (lead analyst role).
30%
Downtime reduced through monitoring, maintenance, and prevention.
100+
Users trained with documentation that reduced recurring requests.
Skills
Tools and technologies I’ve used in production or in project environments.
⚙️ Backend
🎨 Frontend
🗄️ Data
🤝 Ops & Collaboration
💻 IT Support
🏆 Certifications
Services (Canada)
You have a deadline, a budget, and a business to run. I handle the build — clean code, clear milestones, and a product that works on day one. No fluff, no surprises.
🌐
Business Websites
Fast, mobile-friendly sites designed to convert: landing pages, service sites, and multi-page business websites.
- SEO-ready structure + performance basics
- Contact forms (privacy-friendly) or backend-enabled
- Analytics setup (optional)
📱
Custom Web Apps
Internal tools, portals, dashboards, and workflow apps — built around your process.
- Role-based access (RBAC)
- API integrations
- Clean architecture + maintainability
🗄️
Databases & Performance
When your app is slow or your data is messy: tuning, migrations, and validation.
- SQL Server optimization (queries & structure)
- Oracle / ODI ETL workflows
- Data validation & reconciliation
Get a quote in 24 hours
1
DiscoveryWe align on scope, timeline, and budget — no guesswork2
BuildWeekly demos so you're always in the loop3
LaunchLive deployment + full handover docs, yours to keepTell me your project type, must-have features, deadline, and 1–2 reference sites. I'll reply with a clear scope and price — usually within 24 hours.
Let's Work Together →FAQs
Common questions from clients in Canada looking for websites or custom web apps — including HIS/health software, inventory systems, and event ticketing platforms.
🌐 Websites (Small Business)
Examples: franksorganicgarden.com and olgapaternina.com.
How long does a business website take?
Typical timelines:
- Landing page: 3–7 days
- 5–8 pages: 2–3 weeks
- Website + blog + forms: 3–5 weeks
Do you include SEO?
Yes — I include SEO fundamentals: clean structure, fast load basics, metadata, friendly URLs,
mobile responsiveness, and Google Search Console setup. For competitive keywords, we can add a monthly SEO plan.
Can you handle hosting, domain, and emails?
Yes. I can set up hosting, DNS, SSL, and business email (Microsoft 365 or Google Workspace),
or work with your existing provider.
🎟️ Event Ticketing
Ideal for churches, conferences, workshops, and community events: ticket types, QR check-in, capacity control, and reporting.
What features can you build for tickets?
Common features include:
- Multiple ticket types (free/paid), promo codes
- Stripe payments, refunds, email confirmations
- QR codes + check-in dashboard (mobile friendly)
- Seat/capacity limits, attendee exports (CSV)
- Admin panel for events, discounts, and staff roles
Can you integrate Stripe and automate emails?
Yes. Stripe integration + webhook automation (confirmation emails, receipts, status updates).
If you use Mailchimp or Brevo, I can connect it as well.
Do you provide on-site support for the event?
Remote support is standard. On-site support can be arranged (based on location/date) for large events.
📦 Inventory Systems
For warehouses, small businesses, or multi-location teams: track stock, purchases, transfers, and audit trails.
What does an inventory MVP usually include?
A solid MVP typically includes:
- Products, categories, suppliers
- Stock in/out, adjustments, low-stock alerts
- Locations (bins/warehouses), transfers
- Role-based access + activity logs
- Reports: stock valuation, movement, discrepancies
Can you integrate barcodes and scanners?
Yes — barcode support can be done via web (camera scanning) or with standard USB/Bluetooth scanners
that behave like keyboard input. We’ll choose the approach based on your workflow.
What database do you recommend?
For most clients: PostgreSQL or SQL Server. If you already run Oracle, we can integrate with it.
The choice depends on your existing systems, reporting needs, and budget.
🏥 Health Software (HIS / Salud)
Experience supporting business-critical health platforms: reliability, data integrity, auditability, and performance.
Can you build or extend a HIS (appointments, EMR-like workflows, billing)?
Yes. Typical modules include scheduling, patient registry, clinical notes workflows, billing integrations, reporting,
and interoperability endpoints. Scope depends on compliance requirements and the target audience (clinic vs. enterprise).
How do you approach security and privacy?
I follow practical security-by-design: least privilege (RBAC), audit trails, encryption in transit (HTTPS),
secure secrets management, backups, and logging. For regulated environments, we align to your compliance obligations.
Can you help with performance issues in SQL Server/Oracle?
Yes — I do query profiling, indexing strategy, execution plan analysis, and database structure improvements.
I’ve delivered measurable performance gains (e.g., significant reductions in query execution time) through optimization.
Ready to build something?
Share your goal, the features you need, your deadline, and 1–2 sites you like as reference. I’ll get back to you with a clear scope and price — usually within 24 hours.
Let’s Work Together →Experience
Recent roles — with emphasis on outcomes, ownership, and scale.
- Provided technical support during deployments, upgrades, and incident resolution.
- Optimized SQL Server queries and database structures, reducing execution time by 35%.
- Implemented best practices for scalability, integrity, and security.
- Translated business requirements into technical solutions with cross-functional teams.
- Built and maintained ODI ETL workflows aligned to business rules and technical constraints.
- Produced source-to-target data mappings and validation evidence for auditability.
- Executed reconciliation (counts, sampling, rule checks) to ensure completeness and accuracy.
- Troubleshot ETL failures (mapping gaps, anomalies, constraints) and implemented fixes.
- Supported cutover planning and post-migration stabilization.
- Designed and maintained web applications for internal teams and customers.
- Resolved 95% of support tickets within 24 hours to maintain availability.
- Reduced downtime by 30% via monitoring, maintenance, and prevention.
- Trained 100+ users and created documentation to reduce repeat issues.
- Supported development and maintenance of web-based applications.
- Resolved 90%+ of customer issues within SLAs.
- Assisted with security improvements and vulnerability reduction.
- Delivered technical training to 40+ staff members.
- Increased user engagement and reduced page load times.
- Improved website security and stability.
- Boosted organic search traffic and conversion rates.
- Enhanced uptime and implemented SEO strategies.
Case Studies
Short, recruiter-friendly breakdowns you can scan quickly.
SQL Server Performance Optimization
Role: Database Optimization Specialist • Company: Sistemas Infotec
🔴 Problem
Slow-running queries impacting key workflows and user experience.
⚡ Actions
- Query analysis and refactoring.
- Database structure improvements and best practices.
- Validation with before/after benchmarks.
🎯 Result
35% reduction in execution time; improved application performance.
Oracle Migration with ODI (ETL)
Role: Database Migration Specialist • Contract: SNR (Colombia)
🔴 Problem
Standardize and migrate institutional data across environments with auditability.
⚡ Actions
- Built ODI workflows for extract/transform/load.
- Created source-to-target mapping docs.
- Reconciliation: row counts, sampling, rule checks.
- Troubleshot ETL failures and data anomalies.
🎯 Result
Repeatable runbooks + validation evidence supporting cutover and stabilization.
Support Leadership & Reliability
Role: Lead IT Support Analyst • Sistemas Infotec
🔴 Problem
Recurring issues and downtime affecting operations and customer satisfaction.
⚡ Actions
- Built documentation and trained 100+ users.
- Proactive monitoring and maintenance routines.
- Ticket workflow improvements to meet SLAs.
🎯 Result
95% tickets resolved < 24h and 30% downtime reduction.
Want deeper technical artifacts (runbooks, scripts, diagrams)? I can share samples upon request or during interviews.
Live Demos
Real, working demos — not mockups. Click any to explore a fully functional interface built with HTML, CSS, and JavaScript. Each demo represents a service type I can build for you.
🍽️
Business Website
A polished restaurant landing page with hero, menu, reservation form, and mobile-friendly design. Representative of any service business site.
- Responsive layout + mobile nav
- Reservation form with validation
- Menu grid + animated cards
🎟️
Event Ticketing App
A full event ticketing page with live countdown, tiered ticket selection, speaker lineup, and conference schedule. Stripe-ready flow.
- Live countdown timer
- Ticket tiers with quantity selector
- Speaker grid + schedule
📊
Admin Dashboard
A full admin panel with sidebar navigation, KPI cards, live Chart.js charts (line + doughnut), and an interactive orders table.
- Real Chart.js revenue + traffic charts
- KPI cards with trend indicators
- Orders table with status badges
📦
Inventory Management
A warehouse inventory system with product table, stock level bars, low-stock alerts, category filters, and role-based sidebar navigation.
- Product table with stock indicators
- Low stock alerts + out-of-stock tracking
- Search, filter, and pagination UI
Need something specific? I build custom dashboards, portals, booking systems, and more — let's talk about your project.
Let’s Build Something Together
Got a project in mind? Whether you’re hiring or need a website, web app, or database solution in Canada — I’m ready to help. Reach out and get a clear answer within 24 hours.
Direct
- Emailcriscastrob022@gmail.com
- Phone+1 (647) 504-5640
- LocationNewmarket, Ontario
- LanguagesEnglish • Spanish
- LinkedInProfile