Fernando Castro Email & Phone Number

Charlotte, Nc, Us

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• Developed a Java Spring Boot application to capture changes in Duke’s Active Directory and produce to consumers• Owned development responsibilities, including creating, maintaining, and improving CI/CD Concourse pipelines. Creating and maintaining Terraform configurations for multiple projects in AWS. Led the Python 3.8 to 3.11 migration for AWS Lambda functions without production downtime (affecting 30+ Lambdas and Layers).

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 capabilities• 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 with Hive and Impala drivers to query our transformed data on HDFS• 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)• Developed custom JavaScript and CSS Styles with our BI tool to accomplish complex requests from our internal users and customers• Contributed to our front-end React codebase by integrating Matomo for visibility into our platform usage• Participated in BI Tool market assessment (such as PowerBI, Qlik Sense, Tableau, MicroStrategy, etc) and quickly learned to use MicroStrategy to display its capabilities internally• Standardized our dashboard request/creation process by leveraging our BI tool (Arcadia) features• Constant communication with the Business Analysts, Product Owners and SMEs to give new suggestions to better improve our healthcare focused dashboards and clarification on requirements• Participated in PI and Sprint planning, estimating some of our team’s tasks effort and thinking of any dependencies from other teams, leveraging JIRA and Confluence• Exceeded expectations year after year according to yearly reviews

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• Was consulted on design choices for new and existing projects by other architects and senior colleagues• Continued supporting existing projects while designing and implementing new projects mainly with Oracle, BASH and Flow-Based Programming using the company’s ETL/Dashboarding/Business Intelligence tool• Kept team members challenged and, at the same time, satisfied with the work

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• Held discussions and requirements gathering with clients around the world• Maintained Microsoft SQL Server scripts and delivered time-sensitive reports to clients

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• Troubleshot issues in the Perl code for data processing before getting to the development team• Trained new team members on data processing and one-off reporting• Took the initiative to create an internal tool using LAMP to minimize the time spent internally and to deliver actionable information• Set goals to the team when new upper management was hired

B.S., Computer Science

Transfer, Computer Science