Fernando Castro

Fernando Castro Email and Phone Number

Team Lead - Senior Data Engineer @ Duke Energy Corporation
Charlotte, NC, US
Fernando Castro's Location
Charlotte, North Carolina, United States, United States
Fernando Castro's Contact Details

Fernando Castro personal email

n/a
About Fernando Castro

Quick and eager learner, detail-oriented with a wide range of expertise revolving around data (Engineering, Analysis, Solution Architecting); be it working with Big Data technologies (such as Spark, Hive, Flink, AWS EMR, and others), developing ETL solutions in multiple languages (Python, Scala, Perl) leveraging multiple storage systems, creating dashboards with BI Tools, implementing web analytics tool into a React front-end, architecting solutions from A to Z, leading teams in multiple concurrent projects, performing root cause analysis and performance improvements. Willing and ready to help wherever I can to move forward the company’s goals.

Fernando Castro's Current Company Details
Duke Energy Corporation

Duke Energy Corporation

View
Team Lead - Senior Data Engineer
Charlotte, NC, US
Website:
duke-energy.com
Employees:
25069
Fernando Castro Work Experience Details
  • Duke Energy Corporation
    Team Lead - Senior Data Engineer
    Duke Energy Corporation
    Charlotte, Nc, Us
  • Duke Energy Corporation
    Senior Software Engineer Technical Lead
    Duke Energy Corporation Feb 2021 - Present
    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).
  • Duke Energy Corporation
    Solutions Architect
    Duke Energy Corporation Jun 2020 - Feb 2021
    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
  • Leidos
    Data Analyst
    Leidos Aug 2018 - Jun 2020
    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
  • Wedo Technologies
    Team Lead Consultant
    Wedo Technologies Aug 2016 - Aug 2018
    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
  • Wedo Technologies
    Experienced Consultant
    Wedo Technologies Aug 2012 - Aug 2016
    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
  • Wedo Technologies
    Technical Projects Engineer
    Wedo Technologies Nov 2011 - Aug 2012
    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
  • Wedo Technologies
    Operations Engineer
    Wedo Technologies Oct 2010 - Nov 2011
    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

Fernando Castro Skills

Mysql Linux Perl Bash Unix Shell Scripting Database Design Java Data Analysis Oracle Sql Javase Reporting And Analysis Microsoft Sql Server

Fernando Castro Education Details

  • University Of Maryland
    University Of Maryland
    Computer Science
  • Howard Community College
    Howard Community College
    Computer Science

Frequently Asked Questions about Fernando Castro

What company does Fernando Castro work for?

Fernando Castro works for Duke Energy Corporation

What is Fernando Castro's role at the current company?

Fernando Castro's current role is Team Lead - Senior Data Engineer.

What is Fernando Castro's email address?

Fernando Castro's email address is fe****@****ies.com

What schools did Fernando Castro attend?

Fernando Castro attended University Of Maryland, Howard Community College.

What skills is Fernando Castro known for?

Fernando Castro has skills like Mysql, Linux, Perl, Bash, Unix Shell Scripting, Database Design, Java, Data Analysis, Oracle Sql, Javase, Reporting And Analysis, Microsoft Sql Server.

Who are Fernando Castro's colleagues?

Fernando Castro's colleagues are Debra White, Taylor Ron, Tom Pitts, Md Mumtaz, Corey Myslewiec, Jesse Mccay, Casey Walters.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.