Fernando Gallegos-Juarez
Seattle,WA
Overview
7
7
years of professional experience
Work History
Data Engineer
Stanley 1913
12.2023 - Current
- Designed Enterprise Data Platform architecture on Microsoft Fabric and Azure Databricks to modernize business from an on-prem solution to cloud
- Refactored and optimized 50+ PL-SQL stored procedures to Pyspark Python notebooks reducing ETL run time by 25%
- Integrated and normalized new ecommerce data via API's from sources such as Shopify, Meta Ads, Google Ads, and TikTok
- Provided modern reporting solutions via PowerBI and Fabric Synapse Analytics working with 15+ cross functional teams
SQL Developer
Wipro Technologies
01.2022 - 11.2023
- Scaled and maintained Oracle databases and data marts backing self service Java web app that serviced over 2,000+ entry's a day
- Lead team of 4 developers to automate and streamline over 10 reference data sets to be populated for on-demand needs for customers
- Collaborated with over 100+ customer teams to deliver data scenarios for production release testing with tight deadlines using Jira for tracking and delivery
- Collaborated with business intelligence staff to produce customized ETL pipelines using Oracle SOA
SQL Server Developer
WaFd Bank
09.2017 - 01.2022
- Implemented partitions on large data marts as well as index functions using Snowflake resulting in 90% improved performance
- Developed core ETL pipelines on SSIS to migrate 6 TB Data warehouse from an Oracle DB platform to Azure SQL DB with multiple strong data integrity checks
- Design and develop new ETL pipelines using Big Data tools such as Talend, Snaplogic, and Mulesoft on data platforms such as SQL Server 2016, Azure SQL DB, Oracle DB, and Snowflake
Education
Database Analyst Certificate - Computer Science And Programming
Bellevue College
Bellevue, WA2017
Skills
- Languages and Frameworks: T-SQL, PL-SQL, MySQL, Python, PowerShell, Java, Spark, Spring
- Data tools: Azure Data Factory, Azure Synapse, Microsoft Fabric, Azure Databricks, Oracle Data Integrator, Talend, Snaplogic, Mulesoft, SSIS
- Databases: Oracle, Azure SQLDB, Snowflake, BigQuery, SQL Server 2014/2016, Cassandra, MySQL
- Reporting tools: PowerBI, Tableau, SSRS, SSAS, Oracle EBS
- Cloud Services: Azure, Google Cloud Platform, Microsoft Fabric
- Developer tools: Git, Gitlabs, Github, Jira, Confluence, AzureDevops, VS Code, Visual Studio, Postman
Timeline
Data Engineer
Stanley 1913
12.2023 - Current
SQL Developer
Wipro Technologies
01.2022 - 11.2023
SQL Server Developer
WaFd Bank
09.2017 - 01.2022
Database Analyst Certificate - Computer Science And Programming
Bellevue College
Similar Profiles
Antoine HUICHARDAntoine HUICHARD
Intern at Parma Calcio 1913Intern at Parma Calcio 1913
Regi T HallRegi T Hall
Monitoring Specialist, Customer Service Specialist at Stanley Black & Decker, StanleyMonitoring Specialist, Customer Service Specialist at Stanley Black & Decker, Stanley
Heidi CanfieldHeidi Canfield
Municipal Court Clerk at Stanley Municipal Court/City of StanleyMunicipal Court Clerk at Stanley Municipal Court/City of Stanley