Jermaine Sizemore

E-Prescribing Platform EPCS Regulatory Compliance (MS SQL/TypeScript/Visual Basic)

• Worked cross-functionally with engineering, QA, and product teams to deliver critical solutions that secured $1.3M+ in follow-on business opportunities for ASMBL
• Led the update of pharmaceutical company's e-prescribing platform to achieve EPCS certification, addressing DEA mandates critical to the pharmaceutical industry
• Overcame challenges posed by outdated VB/.NET Framework 4.6.2 code and poor code quality, resulting in successful audit completion with 96% of requirements passing on the first round

E-Prescribing Platform API Modernization (MS SQL/C#)

• Implemented best practices in a legacy .NET Framework C# web API, improving maintainability and scalability, and ensuring compliance with modern development standards
• Redesigned the authentication system for platform API by introducing user-specific auth tokens, replacing the Basic auth scheme
• Enhanced logging systems to capture and store API access logs in SQL databases, improving traceability and security

Discrete Database Integration (MS SQL/PostgreSQL/TypeScript/C#/Azure)

• Implemented a cloud-based integration solution to synchronize data between client's D365 JSON-based database and its MS SQL database
• Collaborated with product owners to resolve complex entity mappings & created some of the first end-to-end workflows, including data validation via Zod in TypeScript
• Improved Azure function PostgreSQL logs to be more informative and help with tracing entity data flow
• Guided other engineers in developing data workflows within Azure Function and stored procedures, ensuring robust integration of disparate databases

Fox XF Pipelines (PostgreSQL/Elixir/React.js/TypeScript/Terraform/AWS)

• Researched the feasibility of moving from AWS Data Firehose to AWS EMR to support delivery of several streams' data to Apache Iceberg via Flink jobs, while avoiding AWS Managed Flink costs
• Created Terraform module responsible for deploying an EMR cluster that could handle several long-running Apache Flink jobs and mirrored the functionality of the existing AWS Data Firehose approach

Fox Lighthouse (PostgreSQL/Elixir/Python/React.js/JavaScript/TypeScript/CDK/AWS)

• Improved app security by adding a new endpoint that obfuscated the data being delivered to frontend
• Researched & implemented backup & restore functionality for the Aurora PostgreSQL DB, supporting point-in-time recovery and pre-/post-deploy snapshot recovery
• Implemented backup system monitoring service for the RDS backups using a slack bot in CDK
• Created a report detailing opportunities for improvement in both the backend & IaC codebases
• Reduced costs associated with GitHub Actions by splitting deployment workflows into modular pieces

Stell Engineering Platform (PostgreSQL/C#/.NET/.NET Blazor/Terraform/AWS)

• Optimized client-side data handling and backend data retrieval / SQL querying to cut average page load times, resulting in near-instant UI responsiveness and API latency being reduced by as much as 80-90%
• Contributed to large-scope design discussions that will have lasting impacts on the security, maintainability, & scalability of the application
• Normalized styles across a variety of pages to reflect the expected state of the app given by Figma designs, and created / implemented custom Blazor components
• Added a variety of new features each sprint, including password validation, user account management pages, custom data fields
• Regularly and proactively addressed bugs and improved responsiveness across the application stack

ML Builder Experience Metrics (NoSQL/Java/TypeScript/Smithy/CDK/AWS)

• Researched and developed LLD for ETL pipeline that extracts event metrics emitted in varying file formats from regionalized ML Builder tool systems
• Created language/protocol-agnostic service model used as a source of truth for expected data format(s)
• Established an infrastructure-as-code approach for all the relevant system architecture via CDK

ML Model Comparison Report Generation Tool (Python/DSL/AWS)

• Designed and implemented automated testing system that leveraged AWS Step Functions to run integration tests with a cadence on report generator tool workflows
• Added several early warning alarms and documented common issues with the service
• Diagrammed the inherited service's architecture and modeled potential security threat vectors along with mitigations

Legacy Java App Server Conversion & Migration (SQL/Java/.NET Core 3.1/Azure)

• Converted legacy Java monolith app server functionality to modern C# .NET Core 3.1 distributed microservices with N-tier architecture
• Updated existing SQL databases and Azure cloud-based infrastructure using Terraform and Jenkins
• Proactively created caching NuGet package with Redis functionality for eventual cloud caching migration
• Created some developer tools and workflows for internal API gateway management

eCAC/pCAC Cloud Migration (SQL/.NET Core 3.1/Azure)

• Collaborated with the eCAC team to build a resilient distributed HL7/XML message processing system that can handle 30K cases/hr, 10M messages/day
• Built out a scalable, cloud-based system consisting of an Azure App Service REST API, Azure Functions & Queues
• Executed improvements for CAC Pro, e.g., incorporating Redis cache layer to reduce SQL query volume

Dash Cam Microservice/Web Portal (SQL/.NET Core 3.1/React.js/AWS)

• Led development & design of commercial Dash Cam Microservice API written using C# .NET Core 3.1 with an N-layer architecture
• Implemented live streaming using Google FCM and various levels of testing
• Set up automated testing, building, & deployment to Microsoft IIS via CircleCI, Jenkins, & Octopus Deploy

Internal CRM (SQL/.NET Core 2.1/React.js/AWS)

• Integrated Twilio communication service API into internal CRM, supporting 9k+ monthly SMS messages and 180k+ monthly calls
• Rebuilt company card-charging infrastructure, resulting in the successful collection of $1.5M+
• Augmented the internal CRM performance by adding lazy loading and memoization improvements in the React layer that increased 200+ sales employees' work efficiency by 5x
• Acted as a point of contact between business & developers, addressing bugs and explaining business requirements