Systems
Building Scalable, Secure, and Efficient Enterprise Systems
I specialize in architecting and leading the development of enterprise-scale software solutions. My approach ensures that systems are highly performant, secure and flexible enough to adapt to evolving business needs.
• End-to-End Leadership – From concept to deployment, I act as the architect, lead developer, and strategist, ensuring a seamless build.
• Scalability First – Systems are built to handle high traffic, large datasets, and growing demands.
• Security & Compliance – Every system is auditable, resilient, and secure, meeting enterprise standards.
• Automation & Efficiency – Self-service and automation to reduce manual effort while improving accuracy and speed.
• Business-Centric Development – I bridge the gap between business needs and technical solutions.
Automated Reporting Suite
Automated enterprise reporting, reducing manual effort from a month to real-time insights.
Automated enterprise reporting, reducing manual effort from a month to real-time insights.
AWS
Python
AWS Redshift
SLS Framework
A fully automated reporting system, drastically reducing the time spent on complex enterprise reports. Features:
- Dynamic Reporting Engine: Allowed users to generate reports on demand.
- Data Validation & Auditing: Full logging and traceability for compliance.
- High Availability & Backup: Redundant storage on S3 with backup strategies.
- Stale Data Detection: Automatically flagged and identified outdated or inconsistent data in reports.
- Closed-Book Audit Tracking: Implemented detection for modifications on closed books, ensuring financial integrity.
This system cut reporting time from a month to minutes, ensuring data accuracy and business agility.
Tableau Integration
Enabled real-time self-serve analytics, cutting reporting time from 1 month to minutes.
Enabled real-time self-serve analytics, cutting reporting time from 1 month to minutes.
Tableau
AWS
AWS Redshift
Python
A self-service reporting and analytics platform, allowing the company to run on-demand reports with Tableau. This system included:
- Tableau Deployment: Hosted on AWS EC2 behind a load balancer in a private VPC, passing strenuous security checks.
- Direct Data Warehouse Integration: Connected to Redshift data marts, enabling real-time insights.
- Role-Based Access Control: Ensured secure and restricted access.
This system eliminated manual report generation, empowering business teams with real-time data visibility.
Billing & Payment Processing System
Enabled self-service billing updates, reducing call center dependency and improving user experience.
Enabled self-service billing updates, reducing call center dependency and improving user experience.
AWS
TypeScript
Python
SLS Framework
A self-service billing system built to integrate Moneris with a major insurance provider. The goal was to eliminate reliance on call centers for billing updates and make the process seamless for users.
- Moneris Integration: Allowed secure credit card and payment updates, with full PCI compliace.
- AWS Serverless Architecture: Fully event-driven for cost efficiency and scalability.
- Improved User Experience: Allowed members to update billing details without needing support calls.
By eliminating the need for manual billing changes, this system reduced operational overhead and significantly improved customer experience.
Enterprise Payment Integration
Built a unified payment integration framework with end-to-end reconciliation, ensuring accurate transactions across multiple systems.
Built a unified payment integration framework with end-to-end reconciliation, ensuring accurate transactions across multiple systems.
AWS
Python
SLS Framework
We revamped payment integrations across multiple enterprise systems, designing a flexible, scalable, and auditable framework. Unlike traditional integrations, we took a start-to-finish approach, ensuring every transaction was automatically reconciled at both the source and target systems.
- End-to-End Payment Flow: Tracked every transaction from initiation to settlement, ensuring full visibility.
- Flexible Integration Framework: Designed to easily accommodate new payment providers and processing rules.
- Automated Reconciliation: Built an auto-reconciliation process, cross-checking payment extracts between all systems.
- Scalability & Compliance: Architected with serverless AWS technologies, ensuring high availability, audit logs, and compliance with financial standards.
This system eliminated manual reconciliation efforts, reduced errors, and ensured that every dollar processed was accounted for across the enterprise.
Data Warehousing & Infrastructure Rebuild
Built an enterprise data warehouse handling 150+ daily data extracts, cutting data delivery time from 1 month to 1 day.
Built an enterprise data warehouse handling 150+ daily data extracts, cutting data delivery time from 1 month to 1 day.
AWS
Python
AWS Redshift
SLS Framework
Splunk
A major enterprise data warehouse rebuild, designed to streamline ingestion, transformation, and reporting for a very large insurance client. The system included:
- Data Ingestion: Integrated with 5 external companies, processing 150+ daily data extracts.
- ETL Pipeline: A custom AWS Glue-based ETL process with full compliance auditing and logging for IFRS17 reporting.
- Validation Engine: A flexible validation system that allowed business users to modify data rules dynamically.
- SQL-Based ETL Engine: Optimized for AWS Redshift, allowing rapid data mart generation.
- Data Quarantine & Automated Fixes: Implemented a quarantine process for bad data, enabling automated correction workflows.
- Data Quality & Governance: Established a quality and validation framework, integrated stale data detection, and implemented enhanced PII protection.
- Faster Insights: Reduced data request time from weeks to a day.
This system transformed the company’s ability to deliver data on-demand, drastically improving efficiency, transparency, and allowed data-driven decisions.
Enterprise Client Integrations
Enabled seamless enrollment, reporting, and payment processing for large clients.
Enabled seamless enrollment, reporting, and payment processing for large clients.
AWS
Python
SLS Framework
A major enterprise integration for a high-value client, allowing them to seamlessly enroll customers, process payments, and generate reports. The system included:
- Enrollment Processing: Automated onboarding and real-time validation.
- Data Integrations: Connected with multiple internal systems to synchronize data.
- Payment Processing: Fully integrated with existing billing and claims workflows.
By implementing this system, the company onboarded two high-value clients, leading to substantial revenue growth.
Enrollment Processing System
Automated enrollment and claims processing for 1M+ users.
Automated enrollment and claims processing for 1M+ users.
AWS
TypeScript
Python
SLS Framework
Splunk
Two major insurance companies needed an integration to create a fully automated enrolment and claims processing system to handle over 1 million students. The entire system was built serverless on AWS, leveraging:
- Admin & User Portals: A TypeScript-based frontend for both admin and customer interactions.
- Data Pipeline: A Python-driven ETL process using AWS Glue.
- High Availability: Designed with multi-AZ failover, disaster recovery, and auto-scaling.
- Security & Compliance: Integrated CloudTrail, SonarQube, and Snyk for enterprise security.
The result was a fully automated, scalable solution that streamlined claims processing and drastically reduced manual workload. This increased customer satisfaction and massively reduced resource costs.
Projects
Skills

Python
7 years

TypeScript
6 years

HTML5
6 years

CSS/SCSS
6 years

ReactJS
4 years

Node.js
4 years

NextJS
4 years

Django
3 years

VueJS
3 years

PostgreSQL
3 years

MongoDB
3 years

AWS
3 years

SLS Framework
2 years

AWS Redshift
2 years

Splunk
2 years

Tableau
1 year
There are a few dozen more that wont fit on here. Email me for inquiries!
About Me
Hi!
I am a solutions architect based in Toronto, Canada. I love a good challenge and learning new skills.
Architect & Lead at The Fourth Dimension.
Got inquiries? Email me at: hello@artnikitin.dev

Or find me on my socials:
