Ryan Jones Email & Phone Number

Mclean, Va, Us

Card Authorizations Gateway - controlling the flow of transaction data between Capital One and our network partners. • Manage the gateways used by Capital One to communicate with other payment networks like TSYS, WorldPay, Visa, Mastercard, etc. while adhering to the ISO 8583 authorization standard• Tech stack is primarily Java EC2 instances with some Python lambdas and other odds and ends thrown in

Mclean, Va, Us

I was part of a newly stood up team building an identity resolution engine used to fingerprint visitors to the Capital One website. With the launch of our MVP in late 2023 we began incorporating additional data sources and expanding its scope. By the time I left is was processing over 1 million records a day. • Spent the first year creating design docs, making architecture decisions, testing various tech stacks, building proofs of concept, and collaborating with up/downstream users to determine the best way to build out the final engine• Worked with AWS serverless components (Lambdas, SQS Queues, DynamoDB) to continue development of the IR Engine• Wrangled data structures and cooked up schemas• Wrote a lot of Python code• Built APIs for downstream users• Used agile and all that stuff

Mclean, Va, Us

I transferred from supporting a single application in capital markets to supporting the entire multifamily platform via the BTO. My team was responsible for migrating a myriad of legacy DBs over to a single MongoDB data lake and building the associated data API for the next generation of Freddie apps to use. • Converted existing VBA/.NET applications over to new Java Spring/Angular tech stack• Consolidated legacy databases (DB2, Oracle, SQL Server, etc.) into singular MongoDB instance• Participated in daily standups and develop code in sprints under the agile methodology• Helped define business and user needs and processes; identified solutions, worked with project team/sponsors in identifying best solution• Participated in requirements analysis; helped design applications based on system requirements; promoted top code quality and solved meaningful issues related to performance tuning and scalability • Supported implementation of software application changes with aggressive deployment timelines

Mclean, Va, Us

I worked with a team of developers and business analysts to maintain and improve mission critical in-house software used to price approx. $200B of Multifamily Housing Loans annually. My role focused on developing enhancements for VBA applications and T-SQL stored procedures. For 6 months during the pandemic I was the sole developer, but I kept the ship afloat and continued to hit our deadlines.• Designed, built, tested, and deployed software enhancements across separate environments ensuring minimal production downtime and mitigating any disruption to downstream applications • Mentored new developers on the codebase and our vast expanse of tribal knowledge• Coordinated with other dev teams to ensure our software integrated smoothly with their tech stacks• Interfaced directly with business stakeholders to prioritize enhancement requests and translate them into dev plans• Provided timely ad hoc data analysis on over 1.5M records in a Microsoft SQL Server database• Used a combination of Python, C#, and whatever else was lying around to automate tasks like scraping web data

Gb

I inspected Fortune 500 client computer systems and procedures to ensure their security and compliance with various Federal and Organizational standards (e.g., SOX, GAAP, COBIT).• Reviewed corporate IT systems to ensure proper configuration and security posture• Assessed client T-SQL and PowerShell scripts for completeness and accuracy• Manipulated large unstructured data-sets to search for irregularities• Took the initiative to replace hours of manual labor by developing a Python script that scraped information on over 10,000 targeted files from client systems in under a minute• Took the initiative to automate engagement billing analytics using Python and VBA to extract raw T&E data from PwC’s timekeeping system and consolidate it in a single workbook for presentation to management• Designed dashboards and status trackers to summarize complex results and quickly convey relevant information to both internal and external stakeholders• Created and presented detailed workpapers documenting testing steps, calculations, and overall findings

Williamsburg, Va, Us

I was a graduate assistant for the Master of Accounting "summer bootcamp." I tutored students, graded exams, lead review sessions, and just generally helped them survive the program.

Williamsburg, Va, Us

I still did all the cool tech things from below, but now with the added joys of hiring, scheduling, and training other technicians. I even came up with a professional development seminar on managing finances that I get called back annually to present because the students love it so much.

Williamsburg, Va, Us

If an event needed shiny things, I was there. Microphones, mixers, video recording, you name it. I also installed wall ports and projectors sometimes.

Gb

Similar to regular risk assurance above, but with more free food.

Master'S Degree, Computer Science

Master’S Degree, Accounting

Bachelor'S Degree, Economics