Services
We are a full service technology partner that will guide you though your digital journey. From data warehousing, analysis, and visualization to business intelligence, cloud and AI.
Evaluate Business Needs
Call us today to evaluate your current business operations and determine areas where custom software or cloud services can help reduce friction and increase velocity. We like to meet with stakeholders and end-users to get a 360-degree view. Initial consultations are always free of charge.
Architecture and Design
Before we cut any code, we develop an architecture map with a detailed overview of cloud services and costs. We benchmark any potential performance bottlenecks and test for scale. We wireframe UI designs, advise on security best practices, and review compliance needs.
Project Management
Communication is a critical aspect of developing great software, so it is important to have all team members on the same page. Depending on the size of your project, you might have a dedicated Project Manager or a senior team member in charge of coordination and communication.
Data and Back-End Services
Your data store and backend strategy are critical to the success of your business. We have extensive experience with SQL and NoSQL data stores. We’ve built complex, reliable, and highly performant cloud architectures for the most demanding clients.
UI / UX / Data Visualization
Secure, reliable, and performant software is not enough. Users must be able to interact with systems in a way that is intuitive and supports their needs. Screens must be organized in a logical manner. Navigation must be clear and unambiguous.
Middle Tier and Front-End Development
We have developers that are masters at developing robust and reliable code. We follow an agile, iterative development methodology so that we stay flexible to changing business needs. This keeps us nimble and saves time and money.
Deployment & Training
Getting the finished code into the hands of end-users securely and reliably is an important part of software development. Whether it is via an App Store, internal storage, or an endpoint management tool, we’ve got you covered.
Security & Compliance
Security is woven into every aspect of our development process. We follow OWASP guidelines and perform security reviews and monitoring. We also have experience with regulatory compliance including GDPR, TCPA, ORS, PIPEDA.
Maintenance & Support
We offer flexible, ultra-responsive support plans so that you can get the answers you need right away. We also provide monitoring services to keep your systems running smoothly and alerts and notifications when issues arise.
Technical Expertise
Development Technology
.NET Core / 5 / 6 / 7
UWP / WPF / MAUI
ASP.NET
Signal R / Blazor
JavaScript / HTML / CSS
TypeScript
Cloud Computing
AWS / Azure
Serverless
Event-Driven Architecture
Backend Services
Microsoft Graph
Web API
Big Data
Data Warehouse
Analysis Services
SQL
Redis
DynamoDB
Analysis Services
Data Visualization
PowerBI
Power Platform
DevExpress
Case Study – Automated Workflow
A global financial research firm was outgrowing its data infrastructure. Every new project required copying document templates from previous projects and updating them with new data. The manual process was error-prone, difficult to manage, and impossible to scale.
After a detailed review of their workflow with executives and internal staff, Fog City Code Works developed a prototype system to automate data collection, analysis, and reporting. We scheduled a phased release, tackling the low-hanging fruit first and working our way up the tree. End-users quickly saw the value, and executives now had insight into real-time business metrics. The system evolved quickly, bottlenecks were eliminated, project turnaround was cut in half, new hires were quickly trained, and the business was able to grow by 5x.
Case Study – Big Data
A client had recently invested in a business unit that was doubling its data processing every 12 months and quickly approaching a billion data points. They were on a path to outgrow their current on-premise MySQL database by the following quarter. Fog City Code Works was contracted to build a cloud-enabled data warehouse that was capable of rapidly scaling to handle data ingestion. And a separate high-performance analysis database was needed for processing and reporting.
Due to the nature of the business, the system needed to be built on the fly and deployed in real-time in order to avoid gaps in client deliverables. The team at Fog City quickly developed a data architecture, performed scale testing, and built ETL processing to handle the incoming load. Within two months the system was up and running and processing data. A set of client tools were developed and deployed for data analysis and management, and the system has scaled effortlessly to meet evolving business requirements and new data processing needs.
Case Study – Cloud Services
Audio transcription is a growing area of interest and a client recently approached us with the need to implement an automated system that recognizes new audio files on a SharePoint drive and processes them in real-time. The audio files were jargon-rich and all attempts to transcribe them using off-the-shelf services were proving futile.
Fog City built and deployed a completely serverless system using AWS Transcribe services with a custom-trained model, S3, Microsoft Graph API, and an event-driven cloud architecture that would be invoked when a new file was created on the SharePoint site. Using AWS EventBridge and SQS (message queuing service) allowed the system to scale effectively to meet demand. Backend monitoring and notifications were configured to detect issues and bottlenecks in processing.
Case Study – User Experience
A global financial services client approached us to develop and deploy an end-user tool that would be used by staff members to expand information flow and increase productivity. The target users had a varying level of technical skills so the system needed to accommodate novice users with an intuitive and instinctive design but also provide powerful advanced features for advanced users.
Using the latest development tools, Fog City created an interface that combines icons, colors, and data to convey relevant information and highlight meaningful calls to action. Using hover tips and discoverable glyphs, advanced users could invoke sophisticated features for filtering, sorting, and displaying detailed information. While non-technical users could still digest and act on information without feeling overwhelmed by options. This system has been operational 24-7 for over 10 years to the delight of global end users and increased information flow has resulted in significantly higher quality and lower costs for our client.
Case Study – Security & Authentication
In the current regulatory environment, protecting your company’s data and personally identifiable information (PII) of all contacts is paramount. Therefore, we weave security into every aspect of our customer engagements from customer communications to source code repositories to OWASP best practices. As part of our weekly code review process, we review every line of code for security issues or vulnerabilities.
As part of our commitment to our client’s data protection, we have built a line of business security layer that is designed specifically to limit access to critical data using the latest security services from AWS. This layer has been thoroughly penetration tested by third-party security firms who have found zero vulnerabilities.
When requested by clients, we perform full security monitoring and periodic audits and use AI to detect access anomalies.
Case Study – Data Visualization
We recently worked with a client who needed to aggregate data into presentation format from a rather large cloud-based data warehouse. Using Microsoft Power BI, we developed a highly performant snowflake data architecture and ETL process using Power Query that became the foundation for their reporting engine, capable of filtering a 500 million row fact tables in less than a second.
As our success with this new reporting engine proliferated, our client realized the need for a custom Power BI visual for a unique data set. Using the Power BI SDK, we built and deployed a custom visual available to all internal users, that allowed full flexibility in configuration and data selection. This Power BI customization saved our client hundreds of hours of manual effort and streamlined their report generation process.
