Fernando Castro Email & Phone Number

Charlotte, NC, US

Charlotte, North Carolina, US

• (Tech Lead, Solutions Architect, Data Engineer, Software Engineer, DevOps)
• Led a team of 4-9 developers across diverse backgrounds, including data, backend, and frontend fostering collaboration and skill growth
• Streamlined processes by implementing a structured development agreement, enabling parallel team progress to achieve goals
• Empowered teams through initiatives such as leading code review workshops, fostering Dev-to-Dev interactions, and organizing role alignment to ensure balanced workloads across around 16 members of our Agile team
• Provided hands-on support, guiding developers through complex technical challenges, including coding and system issues such as caching data in DynamoDB to support our APIs in API Gateway
• Developed a real-time data pipeline leveraging SQL Server, Kafka, and TigerGraph to process data changes efficiently

Charlotte, North Carolina, US

• (Solutions Architect, Data Architect)
• Designed scalable and secure cloud-based solutions, including MongoDB and ElasticSearch, adhering to modern architecture principles
• Presented solution architectures to architects’ forums to facilitate consultation and secure approvals across multiple teams
• Developed the data architecture for the LH – IT – InSite team, utilizing NoSQL design principles and MongoDB’s document-based features to support a geolocation-heavy solution
• Contributed to data architecture discussions for the LH – IT – CaST team, focusing on optimizing the document versioning design

Reston, Virginia, US

• (Data Engineer, Data Analyst, Developer)
• Improved data engineering pipeline by reducing the processing time by 400% with our Spark jobs running on AWS EC2 EMR
• Quickly developed new solutions like real-time data stream processing by architecting a solution using Minikube, Kubernetes, NiFi, Kafka, Scala, Flink, ElasticSearch and Kibana so the company could quickly see new.
• Researched data inconsistencies with Jupyter Notebook together with Python, PySpark, Data Frames, and Panda by querying our raw denormalized data formatted in JSON located in AWS S3 buckets and also using SQuirrelSQL.
• Developed and maintained our PySpark code in our Git repository leveraging BitBucket (or SourceTree) to manage the changes
• Developed a data mockup tool in Python to help during dashboard development with the use of our BI tool (Arcadia)

Lisbon, Lisbon, PT

• (Senior System Integrator, Data Analyst, Software Developer)
• Managed and lead teams of 3-5 people with multiple concurrent projects at hand
• Used Jira for Sprint planning, task allocation and Confluence for internal documentation
• Migrated TSQL from Microsoft SQL Server to into Oracle’s PL/SQL scripts
• Contributed to projects’ timelines and cost by suggesting a different plan of action
• Performed performance improvements on SQL query times, server architectures and programming methodologies

Lisbon, Lisbon, PT

• (System Integrator, Data Analyst, Software Developer)
• Designed, implemented, supported new projects by using Flow-Based Programming with the company’s ETL/Dashboarding/Business Intelligence tool on RHET and AWS environments, combined with Oracle DB development
• Troubleshot performance issues by looking at the application server’s stats (network, disk, CPU and memory usage) together with JVM and DB stats
• Performed a code fix for a Java program that was communicating to a Webservice and was impacting client’s Production environment
• Great support and customer interaction reported by clients from on-site deployments
• Created and demoed POCs that lead to contracts

Lisbon, Lisbon, PT

• (System Integrator, Data Analyst, Software Developer)
• Integrated a Tier 1 client (3B records, 160,000 files, 70GB per day) with the use of 4 RHEL environments, using BASH scripts and cronjobs
• Created special reports to clients by creating a branch of the Perl code to adjust to clients’ needs
• Provided support to Operations when a challenging one-off report was requested
• Maintained and documented part of the company’s Perl product code
• Learned company's new products and framework voluntarily and quickly

Lisbon, Lisbon, PT

• (Operations, Data Analyst)
• Gathered data via SCP, FTP, WGET or CDs and processed it through one of the company’s product across 8 different RHEL servers, from 24 different data sources totaling about 2B records a month
• Processed data for 36 different telecom switches using 1 RHEL server totaling about 1.5B records a month
• Voluntarily automated data gathering using BASH scripts, MySQL and cronjob so the team’s focus was where it is most needed resulting in earlier delivery to the clients
• Under-delivered time/data sensitive one-off reports to clients by using BASH, Perl, MySQL and ETL methodologies
• Decreased time to run reports by at least 50% by using ETL SQL methodologies

B.S., Computer Science

Transfer, Computer Science