SERGIO CATLLA

APRIL 2023 - Present

PipelinesR.Us, Ltd. Co., Spartanburg, SC - Freelance

• Delivered effective solutions to problems using Bash, Jenkins, Groovy, Python, Docker containers and AWS (ECR, EC2, ECS/EC2, Fargate, RDS, Aurora, Lambda) to customers in the financial services industry’s regulatory entities.

JANUARY 2021 - OCTOBER 2022

Catlla Consulting L.L.C., Spartanburg, SC - Freelance

• Cleared CNCF Certified Kubernetes Administrator (CKA) exam, September 2022
• Cleared CNCF Certified Kubernetes Application Developer (CKAD) exam, August 2022
• Cleared AWS Authorized Instructor certification (AAI), September 2021
• Cleared AWS Certified AWS DevOps Professional exam (recertification), February 2021
• Embedded into end-clients’ teams using Agile methodologies to collaborate with their operators, engineers, architects and vendors in the USA, EU and India using proprietary and open source tools to deliver automation and pipelines using AWS CDK in Python and Typescript into multi-account, multi-region and multi-VPC AWS stages
• Designed, developed and deployed continuous build and delivery pipelines targeting CloudFormation
• Rapid prototyping in CDK for deployment to ECS, Fargate and EKS; data pipelines for data anonymization
• Designed and implemented bespoke event-driven Lambda custodial bots for cloud resource compliance across AWS Organizations
• Migrated/ported Python code into Lambda from EC2
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders

JUNE 2019 - DECEMBER 2020

Perceptyx Inc, Temecula, CA - Perl Developer

• Cleared AWS Solutions Architect Professional exam (recertification), December 2020
• Cleared AWS Certified Alexa Skill Builder exam, February 2020
• Cleared AWS Certified Security – Specialty exam, January 2020
• Developed in Perl, JavaScript, SQL, bash to enhance reporting and analytics REST endpoints of application to display useful data about survey results, including sentiment analysis of natural language processing of survey comments text
• Assisted Data Science team in gathering data for labeling purposes
• Collaborated with team in California and Europe to carve out monolith into Python microservices
• Proved successful working within tight deadlines and fast-paced atmosphere
• Offered friendly and efficient service to customers, handled challenging situations with ease
• Participated in team-building activities to enhance working relationships
• Collaborated with team members to achieve target results
• Exceeded goals through effective task prioritization and great work ethic

APRIL 2018 - MAY 2019

Amazon Web Services (AWS), Atlanta, GA - Cloud Application Architect

• Cleared AWS Certified Machine Learning – Specialty exam, May 2019
• Cleared AWS Certified Big Data – Specialty exam, April 2019
• Minimized cost and undifferentiated heavy lifting while solving for performance and desired outcomes with end customers’ engineers, architects and vendors, both on-site and distributed globally
• Delivered solutions predicated by customer needs and requirements
• Migrated workloads of varied sizes and tech stacks from RackSpace to AWS
• Application and infrastructure development in Python using boto3 and troposphere
• Implemented Lambda@Edge functions for serverless authN/Z of SPAs
• Serverless applications using Lambda, API Gateway, Cognito, Step Functions, DynamoDB
• Dockerized workloads onto ECR, ECS Fargate with Aurora Serverless (v1) MySQL
• Built pipelines using AWS Code* suite manually, via CFT and TerraForm
• Worked onsite with customer’s engineers to deliver infrastructure using TerraForm for critical Blue Green requirement with Code* suite

APRIL 2015 - APRIL 2018

Capital One Financial Corp, San Francisco, CA - Software Engineer

• Cleared AWS Certified DevOps Engineer – Professional exam, November 2017
• Cleared AWS Certified Solutions Architect – Professional exam, November 2017
• Cleared AWS Certified SysOps Administrator – Associate exam, June 2017
• Cleared AWS Certified Developer – Associate exam, October 27, 2016
• Cleared AWS Certified Solutions Architect – Associate exam, October 17, 2016
• Developed REST API and backend processes in Perl, Dancer, MySQL, bash
• Developed frontend using Angular, Backbone, JQuery, HTML, CSS
• Developed mock services for CI/CD for third party services IDanalytics, MasterCard, LexisNexis used for risk analysis and fraud detection
• Partnered with Audit and Risk to create database views, queries, UIs and automated reports to improve fraud detection workflow
• Gathered module dependencies of existing monolith application, built Dockerfiles
• Prototyped microservices with JWT, Node.js, Express
• Integrated third-party tools (NewRelic) and components into applications
• Troubleshot calls to API server from iOS, Android and POS devices
• Rotationally functioned as release master, dev on call, tech lead, scrum master as needed

SEPTEMBER 2014 - APRIL 2015

Windstream Communications Inc., Greenville, SC – ETL Engineer

• Programmed ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability using Perl, SQL and bash
• Updated existing scripts for data warehouse migration from Oracle 9i to 11g, including deprecation of db links in favor of locally mirrored tablespaces
• Extracted data from myriad db engines including MariaDB, Oracle, MS SQL, Sybase, PostgreSQL, MySQL and MongoDB, transformed and loaded into Oracle data warehouse
• Developed password vault web service with web UI using Perl (Dancer framework) / REST / AngularJS / Nginx / Redis, mTLS
• Implemented ElasticSearch / LogStash / Kibana (ELK stack) for aggregation and search of process logs
• Used JavaScript, Bash/Linux shell scripting, Perl (Dancer), AngularJS, Nginx, Redis to create ETL jobs and associated dashboard
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls
• Contributed to internal activities for overall process improvements, efficiencies and innovation
• Built databases and table structures for data warehouse and web applications
• Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders
• Designed and implemented effective database solutions and models to store and retrieve data
• Documented and communicated database schemas using accepted notations

FEBRUARY 2013 - SEPTEMBER 2014

Empowered Benefits, Charlotte, NC – Perl Developer

• Engineered ETL system for EDI feeds between Affordable Care Act Private Exchange participants including health insurance carriers, distribution partners and front-end Java platform
• Gathered requirements from distribution partners and multiple health insurance carriers
• Collaborated with counterpart at distribution partner to design, develop and implement ETL for partner's data warehouse
• Proved successful working within tight deadlines and fast-paced atmosphere
• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development
• Updated old code bases to modern development standards, improving functionality
• Translated customer requirements into written use cases
• Collaborated on stages of systems development lifecycle from requirement gathering to production releases
• Documented technical workflows and knowledge to educate newly hired employees
• Collaborated with management, internal and development partners regarding software application design status and project progress

AUGUST 2007 - FEBRUARY 2013

Automated Trading Desk (Citigroup), Mt Pleasant, SC – Database Developer

• Developed, tested and maintained Perl scripts which manipulated data from Oracle 9i/10g/11g RAC installations in order to build human-readable reports for customers and Compliance department, and to build machine-readable reports for regulatory authorities (FINRA, OATS, SEC) and third-parties (BNY/Convergex Clearing, Thomson Trading Analytics MSI) each in FIX or their own particular file/record/field layouts
• Loaded security feeds from multiple providers (Bloomberg, NYSE, NASDAQ, in-house) to build security universe database used for daily trading
• Provided reporting and supporting data to Compliance during SEC and FINRA audits
• Designed and implemented systems to support new regulatory reporting requirements (NMS expansion, large trader id, Rule 605, short-sell exempt, NSCC Clearing)
• Designed and implemented incoming and outgoing feeds to data warehouse systems (Netezza) to enable agglomeration of data for firm-wide reporting
• Designed, implemented and supported position/holding feed into firm-wide global risk data warehouse
• Designed and implemented Bamboo installation and pipeline to build RPMs built from svn source and CPAN tarballs and deliver them to Linux hosts
• Implemented process to package Perl CPAN packages into RPMs
• Designed and implemented Nagios/GroundWorks installation for monitoring 50+ production and QA hosts at host availability level and at service and cron job execution level

FEBRUARY 2007 - JULY 2007

LiveText, La Grange, IL – Perl Developer

• Built and maintained web pages (livetext.com) using Object Oriented Perl, Apache, mod_perl, Template Toolkit, JavaScript
• Interim DBA of MySQL 4.x servers in stand-alone and master-slave replication configurations to support development, QA and production.

JUNE 2006 - FEBRUARY 2007

Motricity, Durham, NC – Perl Developer, PostgreSQL DBA

• Built and maintained pages using mod_perl with HTML::Mason and Template Toolkit
• Performance tuning and administration of PostgreSQL 7.4 server, CentOS, memcached, Tomcat, Lucene
• Query tuning of SQL embedded in Perl code
• Improved average response time of admin site from 7 minutes to 10 seconds
• Optimized search function at www.ereader.com
• Fixed bugs and added features to www.ereader.com and ebooks.palm.com
• Designed and developed java servlets for Tomcat 5.5 for XML file upload
• Designed and developed daemon perl scripts for XML file parsing (XML::Twig) and loading into PostgreSQL 7.4 database (DBI, DBD::Pg)
• Experimented with Catalyst framework (http://www.catalystframework.org/)
• Experimented with Spring/Hibernate frameworks (http://www.appfuse.org/)

APRIL 2006 - JUNE 2006

Tekelec Inc, Morrisville, NC – Telecom Analyst II

• Contracted to perform on-site surveys and installations of voice and data traffic signaling equipment in Mexico and Brazil
• Installed Linux, Windows and applications on servers
• Configured and provisioned TCP/IP networks between servers
• Studied SS7, SIGTRAN and SIP protocols

NOVEMBER 2005 - APRIL 2006

Evergreen Investments (Wachovia), Charlotte, NC – Database Developer

• Responsible for writing ETL tools in Perl, bash on Solaris against Sybase ASE.
• Responsible for data loads into development, QA, DR and production data warehouses.
• Responsible for Reuters DataScope financial data load

JULY 2004 - NOVEMBER 2005

Citadel Investment Group, Chicago, IL – Front Office Software Developer (Market Data / Financial Engineering)

• Designed and implemented DDL for normalized data tables to hold financial market data.
• Designed and developed ETL software in Perl and Sybase ASE SQL on Linux to feed Sybase IQ data warehouse; implemented workload automation using IBM Tivoli
• On call 24x7 to support data loads into development and production data warehouses

DECEMBER 2000 - JULY 2004

Companion Technologies (BCBS of SC), Columbia, SC – Information Systems Engineer VIII

• Designed and developed backend programs using Perl, Java, XML and COBOL.
• Developed browser-based end-user applications, reporting and monitoring utilities and administrative tools using Java, Perl, PHP, XML, HTML, JavaScript, SQL, Apache, Tomcat, MySQL, PostgreSQL and Oracle.
• Developed applications using Perl, Java and XML that communicate between (and act as glue for) relational databases, mainframe data storage, web-based data content.
• Configured and administered installations of PostgreSQL running on RedHat Linux.
• Designed and optimized databases under PostgreSQL 7.
• Member of team that developed a HIPAA-compliant claims-management application using AcuCOBOL, AcuSQL, Perl, Java and PHP.
• Assisted in database design for storing and processing data parsed from 837I, 837P, 270, 271, 276 and 277 HIPAA ANSI X12 transactions using XML as intermediary between proprietary data formats.
• Configured ODBC and UnixODBC to allow programmers to connect to PostgreSQL using Perl, PHP, Java and COBOL.
• On call 24x7, responsible for availability of production and development Perl, Java and PHP code, application servers and database servers.