Hola 🗺, I’m Valerie
Software Engineer

Sr Software Engineer, @CapitalOne, Card

Projects

3.0 version of an Internal Facing app for enabling various credit card application workflow

• Developed multiple reusable UI components of our new systems using ReactJS
• Engineered the process for enabling integration testing on our CICD pipeline for our UI
• Blueprinted Operational Excellence guidelines for future development of our new services
• Designed and built AWS ECS infrastructure for backend services
• Contributed on the design sessions for key system components on the full stack and on the AWS infrastructure
• Developed backend API and enhancements using Golang
• Worked on UI security features for configuring AWS Security Groups that enabled SSO on our system
• Main technologies used: ReactJS, AWS ECS(EC2), Go, Docker, NPM Libraries, CapitalOne Internal DevTools

Critical Infrastructure Migration for external APIs from its legacy platform (AWS classical ELB and EC2s) into a modernized and cyber compliant deployment model and infrastructure using ECS

• Designed built, and maintained a new cyber compliant ECS infrastructure, this entailed selecting EC2 types, memory and CPU allocation, determining the task placement, autoscaling, and AMI refresher strategies
• Set observability standards in order to simplify the Mean Time To Identify & Mean Time To Repair of our critical stack. This was achieved by the following
• Integrated Splunk, New Relic, and AWS CloudWatch for our services and infrastructure
• Developed CloudWatch dashboards by creating AWS LogInsights queries with both infrastructure metrics and service behaivors
• Enabled New Relic dashboards with percentile data and services profiling
• Developed a blue/green strategy for our deployments on the new API ecosystem on ECS
• Generated documentation on the migration process and its components in order to ensure the rest of the team was familiarized with the work with the new stack
• Introduced AWS best practices for ensuring separation of concerns on security permissions
• Main technologies used: AWS ECS, AWS CloudWatch, AWS LogInsights AWS IAM, Docker, CapitalOne Internal Dev Tools, Splunk, New Relic

Feature Development on existing Internal Facing app (2.0) that enables credit card application workflow

• Developed UI functonality and backend services for onboarding additional credit card products in order to finalize the data center exit.
• Main technologies used: ReactJS, Go, NodeJS, AWS Lambda, CapitalOne Internal Dev Tools

A day in the life of a Card engineer

• PR reviews for other engineers for the multiple repos that we owned, these include front-end, backend, and infrastructure as code
• Moderation for features from external teams
• Cyber remediations
• Provide guidance to other engineers on CapitalOne systems and/or practices.
• Created Documentation on feature work or on existing processes that lacked documentation. Among the documentation generated I can name: Chronicles of a Prod Support Engineer, Display contents goes blue/green, Goldielogs and the three dashboards
• DevOps on our multiple applications, this involved some cross-team collaboration for deployment coordination and/or releases
• Daily Agile ceremonies such as retros, planning, standup, etc
• Provide KT sessions to other team memnbers on feature development or on things I have become an SME such as on ECS
• Other technologies used: AWS S3, AWS IAM, Java, Docker, Jenkins

Software Engineer, @CapitalOne, Capital Markets & Analytics

Development critical data extractions for acheiving CapitalOne Data Transformation Strategy for Treasury Systems

• Develop multiple and complex ETL logic from our trade data to be migrated to the cloud and be ingested by multiple data analysts on finance
• Tested data integrity between legacy extractions and the new ETL process
• Automated the data extraction process using CapitalOne internal dev tools
• Migrated legacy reports into an existing Microservice platform
• Main technologies used: PL/SQL, AWS, Java, CapitalOne Internal Dev Tools

Migrated 40 critical file transfers from the enterprise Cash Management System from onprem transfers to the cloud

• Served as liason between CapitalOne and twelve 3rd party vendors for the setup and test of critical file transfers inbound and outbound to our systems
• Developed a process for consumtion of files for numerous scenarions given an ongoing data center exit
• Main technologies used: AWS S3, Java, CapitalOne Internal Dev Tools

Migrated CapitalOne Cash Management System from an onprem environment to AWS

• Main technologies used: AWS EC2, AWS S3

A day in the life as a Capital Markets engineer

• Provide guidance to other engineers on CapitalOne systems and/or practices.
• Served as an SME to our Prod Support team on application features
• Documentation on feature work or on existing processes
• Daily Agile ceremonies such as retros, planning, standup, etc
• KT sessions to other team memnbers on feature development or on things I have become an SME.
• Main technologies used: AWS ecosystem, CapitalOne Internal Dev Tools

Data Engineer Consultant, @Avanade

Projects

@Internal Customer

• Designed, developed, and acted as a SME of an ETL process for granting and revoking access to users to an internally used Pricing app. These efforts were known as the “going global” for the Pricing app. Main technologies used: SQL Server Integration Services (SSIS), TSQL, AWS SQS, .NET components.
• Worked as a developer in the enhancement of the Pricing app; I worked on both the front-end and backend of the application. Main technologies used: AngularJS, Node APIs, .NET web services.
• Developed Pricing-Aiding app for one of the financial teams, I was the main front-end developer of the first version of this app. Main technologies used: AngularJS, SpreadJS.
• Enhanced an existing API used for tracking the activity of the whole API ecosystem. Main technologies used: Node.JS, AWS CloudWatch, AWS DynamoDB.
• Worked in enabling the Pricing app for another group within the company. This role is not only as a developer but also as a SME to new developers that are working on these efforts. Main technologies used: AngularJS, Node.JS, .NET.
• Worked on a major refactoring of the Pricing app to enable the usage of new APIs and the deprecation of the existing APIs. As part of these efforts I’ll be designing a data migration strategy.Main technologies used: AngularJS, Node.JS

@One of the biggest health insurance companies in the USA

• Engaged with clients in the requirements gathering process of a workflow and tool for processing 3rd party reference data for validating their provider data.
• Designed and implemented a daily ETL process for consolidating and transforming data needed to be consumed through a front-end application. Main technologies used: SQL Server Integration Services (SSIS), TSQL, .NET (C#).
• Developed a Proof of Concept, and provided technical assessment for helping determine the design of the new system (from architecture, database design, UI design, and data security measures).
• Developed an application using SQL Server for its back-end (tables, views, complex stored procedures,and triggers)and MSAccessfor its front-end. Main Technologies Used:TSQL,VBA.

@Multi-billion dollar wholesale bank (QC Data Migration Project)

• Designed, built, tested, and supported the new ETL process for consolidating heterogeneous loan quality control data that was coming from different vendors into one single data repository. Main technologies used: TSQL, SSIS, Control-M.
• Managed client resources for the implementations of the orchestration of the ETL process.
• Served as SME for our Production Support team on the overall design and troubleshooting guidelines

@Multi-billion dollar wholesale bank (QC Project)

• Analyzed, enhanced, and integrated an existing app in the workflow of a new loan quality control process we were implementing. In total, I analyzed, updated, and deployed changes to more than one hundred objects. This included changes to SQL queries, UI forms, reports, and backend application changes. Main technologies used: TSQL, VBA,MSAccessSQL.
• Identified Personal Identifiable Information data in the system and build a console app for scrubbing all the PPI for developers. Main technologies used: .NET (C#).
• Worked in the design and development of a .Net Windows Forms application for performing the monthly selection of loans for quality control. Main technologies used: TSQL,VBA,.NETWinForms (C#).
• Worked with client’s business SME for implementing and designing new requirements in their legacy app
• Assisted the architects during the design phase and was the designer of future enhancements of the application.
• Worked with testers and users for supporting system test and UAT for the various releases.
• Participated in the design and development of a new SQL Server database. Main technologies used: TSQL.
• Created and led multiple one-time data migration strategies from the legacy app to the new app. Main technologies used: TSQL, SSIS.