Wilfredo F. Silva
DeBary,FL
Summary
Results-driven Solutions Cloud Architect with extensive experience in cloud architecture, data engineering, and ETL optimization. Specializes in designing scalable data solutions and automating workflows to improve operational efficiency. Proven success in executing migrations and enhancing cloud adoption within enterprise environments.
Overview
28
28
years of professional experience
1
1
Certification
Work History
Solutions Cloud Architect
Teradata
10.2023 - 06.2025
- Designed and provided strategic guidance for Teradata migrations from on-premises to AWS, Azure, and Google Cloud Platform, ensuring performance, scalability, and security across enterprise environments.
- Successfully executed large-scale cloud migration projects for customers in retail, financial services, telecommunications, transportation, and healthcare industries.
- Conducted interviews and discovery sessions to assess current-state Teradata environments and architecture, identifying opportunities for cloud migration and modernization.
- Collaborated with cross-functional customer teams to define migration strategy, validate workloads, and implement modernized ETL, data warehouse, and analytics processes.
- Delivered actionable recommendations and best practices for cloud adoption, workload optimization, and cost reduction while ensuring minimal disruption to business operations.
- Assessed cloud migration requirements for architecture, network infrastructure, data transfer, data security, data processes, and business continuity for each migration project.
- Supported post-migration stabilization, documentation, and knowledge transfer for sustainable cloud operations.
- Various U.S. Locations & Industries (Healthcare, Finance, Retail, Transportation and Telecommunications)
Professional Services Senior Consultant – Roles: Technical Lead / Enterprise Architect / Business Continuity Architect
Teradata
11.2014 - 10.2023
- Provided technical leadership and consulting for the implementation of Teradata Data Mover with DSA, including configuration, setup, best practice documentation, and knowledge transfer sessions. Collaborated with Teradata Engineering to resolve complex implementation issues.
- Successfully completed a project originally estimated to take over a year in less than six months, demonstrating efficiency and technical problem-solving.
- Configured Data Mover to enhance network performance across 14 Teradata systems for Charter, while providing technical support for new customers’ test, development, and production systems.
- Architected, documented, and implemented standards for system options, database/user configuration, security, and performance, ensuring consistency across enterprise deployments.
- Integrated ETL workflows and promoted new configurations of Data Mover and Ecosystem Manager into production environments.
- Designed and developed Unix automation scripts to streamline BAR activities between on-premises and cloud Teradata systems, integrating Unix and DSA activities to improve operational efficiency.
- Led discovery and analysis for disaster recovery environments, delivering architecture recommendations for AT&T and other enterprise clients.
- Implemented proof-of-concept deployments of Data Mover DSA for on-premises to cloud and cloud-to-cloud Teradata transfers (AWS, IntelliFlex). Enabled secure, automated data transfers between multiple Teradata systems.
- Conducted knowledge sharing sessions, including Lunch & Learn presentations for clients like Nike, on Data Mover architecture, use cases, and best practices, fostering client understanding and engagement.
- Various U.S. & Canada Locations
Senior Consultant – ETL Developer / Data Engineer
NCS Technologies
04.2013 - 11.2014
- Designed and developed ETL workflows and automation using Unix shell scripting, Perl, Hadoop, Hive, BTEQ, and Arcmain to support large-scale data movement initiatives.
- Collaborated with Bank of America’s DBA team to deliver senior-level database and ETL support for development, test, and production Teradata environments.
- Built migration solutions to transition data from Teradata to Hadoop Distributed File System (HDFS), enabling more cost-effective archiving and data lifecycle management.
- Developed bidirectional data validation scripts (Teradata → Hadoop and Hadoop → Teradata) using Unix, Hive, BTEQ, and Arcmain to ensure accuracy, completeness, and integrity of migrated datasets.
- Designed enterprise archive/restore solution to manage large volumes of Teradata-based applications for the bank.
- Executed performance tuning, troubleshooting, and optimization strategies across Teradata and Hadoop environments to enhance system reliability.
- Client: Bank of America
Senior Consultant – Data Architect / ETL Developer / Data Modeler
NCS Technologies
06.2009 - 02.2013
- Data Architect: Designed and implemented data models for the USTRANSCOM Security Administration office based on business requirements, applied data naming standards, and developed ETL processes to populate the physical database. Delivered comprehensive documentation for all database objects and ETL workflows.
- ETL Developer: Developed complex ETL mappings using Informatica PowerCenter, Teradata Parallel Transporter (TPT), and XML for data integration and migration tasks.
- Data Modeler: Participated in data modeling sessions and delivered final data models for applications, including a web application for NAVAIR.
- Supported end-to-end implementation of recommendations, including development, testing, deployment, and documentation of data warehousing solutions across multiple government systems.
- Collaborated with cross-functional teams to align business requirements with architecture and ETL processes, facilitating successful project implementation.
- Recommended best practices for software development life cycle (SDLC) processes in ETL development, data modeling, and software/hardware architecture, enhancing project outcomes for government clients.
Senior Consultant – Lead DBA / ETL Specialist / Data Warehouse Architect
Baseline Consulting
03.2006 - 05.2009
- Data Warehouse Architect: Delivered technical recommendations on data warehouse architectures, database design, and data modeling for multiple enterprise clients, enhancing data integration and accessibility.
- Lead DBA: Achieved significant performance improvements on Teradata systems for Charles Schwab, including: Reduced ETL load times from 5+ hours to 15–30 minutes. Optimized views to reduce execution times from 1+ hour to under 2 minutes. Leveraged SQL tuning and Teradata Priority Scheduler for resource allocation and workload optimization.
- ETL Specialist / Technical Lead: Designed, developed, and implemented ETL workflows; conducted gap analysis of ETL environments; streamlined processes and recommended resources to optimize ETL operations.
- Business & Data Analyst: Gathered business, data, and functional requirements; identified source systems; profiled data; ensured accurate translation of business needs into ETL mappings and warehouse design, facilitating seamless data flow.
- Data Management & Analysis: Supported Customer Data Integration (CDI), Master Data Management (MDM), and data profiling initiatives to ensure high-quality, consistent, and usable enterprise data.
- Delivered measurable improvements in database performance, ETL efficiency, and data quality for enterprise clients across financial services, insurance, technology, and healthcare industries.
- Provided enterprise clients with guidance and best practices across the full Business Intelligence lifecycle, including business requirements gathering, software/hardware architecture, ETL development, testing, and BI reporting implementation.
Principal Consultant – Lead DBA
Keane Federal Systems, Inc.
Fort Lee, USA
10.1999 - 03.2006
- Functioned as the chief technical resource for DeCA’s first Enterprise Data Warehouse (EDW), managing all aspects from concept through implementation of a 7-terabyte system utilized for daily operational and analytical reporting.
- Data Warehouse Architecture & Design: Provided technical oversight for initial and ongoing design, development, and rollout of EDW infrastructure. Designed database schemas, load strategies, and ETL processes to optimize system performance.
- Performance & ETL Optimization: Streamlined ETL load processes from 24 hours to 6 hours, improving system efficiency and operational throughput.
- Technical Leadership: Directed efforts across ETL, data quality, data analysis, security compliance, disaster recovery, capacity planning, archive/recovery, applications support, and database administration. Maintained Teradata/Unix systems at peak stability and performance.
- Applications & Solutions: Designed and implemented solutions for fraud detection, automated vendor credit memos, dishonored checks, disaster recovery, and reporting workflows.
- Business Impact: Architecture and implementation efforts saved DeCA approximately $3 million in design and implementation costs while delivering operational efficiencies, automated business processes, and enhanced analytical capabilities.
- Delivered production support as Technical Lead DBA for six years, ensuring system stability.
- Client: Defense Commissary Agency, DeCA
IT Systems Specialist
IBM Global Services
01.1997 - 10.1999
- Administered, maintained, developed, and supported Lucent Technologies’ 'Warehouse Information Network Systems' team, managing Internet, Intranet, UNIX, NT, and Teradata database systems for 400–3,000 users in a 24x7 environment.
- Application & System Support: Provided 24x7 support for VM, MVS, and UNIX issues impacting Teradata database hardware and software, ensuring continuous system uptime.
- Teradata Database Administration: Managed three Teradata systems, assisted with client installations on UNIX, VM, and MVS platforms, and ensured high availability and performance.
- Automation & Scripting: Developed UNIX scripts, Visual Basic GUI applications, and cron jobs to automate administrative tasks, reducing manual effort and improving operational efficiency.
- Developed website and CGI/Perl scripts on NCR UNIX system to facilitate Connect:Direct installation, administration, and troubleshooting.
- Led nationwide rollout of AT&T’s proprietary Y2K communications software migration to Connect:Direct, overseeing installation and support across all U.S. servers.
- Client: Lucent Technologies
Education
Bachelor of Engineering - Electrical Engineering
City College School of Engineering
New York, NY02-1997
Skills
- ETL design and development
- AWS, GCP, and Azure
- On-premises to cloud migration
- Teradata and Informatica
- Talend and DataStage
- DBT and Airflow
- SQL optimization techniques
- Python scripting
- REST APIs integration
- CI/CD pipelines
- Git version control
- GitHub and GitLab
- Terraform infrastructure as code
- KSH and Bash
- Perl programming
- Batch processing systems
- Validation automation processes
- Distributed systems management
- Workload migration strategies
- Storage optimization solutions
- Schema and data conversion
- datadog monitoring and logging
- Splunk data analysis
- Unix administration
- automation of systems
- JIRA project management
- datadog monitoring and logging
- Splunk data analysis
Open To Remote
True
Core Skills
ETL design, Teradata, Informatica/Talend, SQL optimization, DBT (beginner), Airflow, Python, KSH, Bash, Perl, REST APIs, CLI tool development, AWS (S3, Glue, Lambda, Redshift), GCP (BigQuery, Dataflow), Azure (Synapse), On-prem → Cloud, schema/data conversion, workload migration, validation automation, Batch processing, distributed systems, storage optimization, data modeling, Git, CI/CD, Docker, Unix admin, system automation, Jira, GitHub/GitLab, Terraform (beginner), Datadog, Splunk
Languages
Spanish
Professional
Certification
- Teradata Master V2R5
- Teradata Vantage Cloud Lake Associate
Timeline
Solutions Cloud Architect
Teradata
10.2023 - 06.2025
Professional Services Senior Consultant – Roles: Technical Lead / Enterprise Architect / Business Continuity Architect
Teradata
11.2014 - 10.2023
Senior Consultant – ETL Developer / Data Engineer
NCS Technologies
04.2013 - 11.2014
Senior Consultant – Data Architect / ETL Developer / Data Modeler
NCS Technologies
06.2009 - 02.2013
Senior Consultant – Lead DBA / ETL Specialist / Data Warehouse Architect
Baseline Consulting
03.2006 - 05.2009
Principal Consultant – Lead DBA
Keane Federal Systems, Inc.
10.1999 - 03.2006
IT Systems Specialist
IBM Global Services
01.1997 - 10.1999
Bachelor of Engineering - Electrical Engineering
City College School of Engineering