Hello! Welcome to my page.
I am Anthony Estrada, currently a Senior Engineer at STMicroelectronics.
For the past 8 years, I have been working with data, focusing on data engineering, business intelligence and analytics.
Currently, I am learning AI and NLP, inspired by the potential of automation and chatbots.
I love coaching, building things, and solving problems.
If you need my services or want to collaborate on some projects, please feel free to reach out.
Career History
click here for my Resume for more detailed career background-
Senior Engineer - Data Analytics
Power BI, Python, Azure, Synapse, ADLS2, Databricks, Oracle, MariaDB
Researched and developed solutions that saved over $200,000 in equipment usage costs and enhanced efficiency tracking. Engineered two Python-based software products to monitor machine logs, validate data, and detect anomalies. Additionally, significantly reduced the processing time of Oracle MES Server algorithms by 60% to 90%. Also implemented a self-service reporting solution that increased team productivity and managed a data engineering team of five members. Currently working on data centralization project on Azure.
-
Microsoft Fabric Development - Mar 2024 - Present
Freelance
Created and architeched Microsoft Fabric Lakehouse and Data warehouse. Data source are from ADSL2, Azure MSQL and REST APIS. Used data factory and some notebook for data ingestion.
OTaxi Aug 2023 - Jan 2024
Freelance
Perform traning in usage of Microsoft Power BI, Created dashboard and reports and design a web application that will served as report extaction tool for external users.
weloveland.com March 2023 - Jun 2023
Upwork
Architeched a database for real estate CRM application. Created an ETL tool to load complex excel file to postgres database hosted at supabase.
-
Business intelligence Developer 3
Power BI, Python, Azure, AWS, Synapse, ADLS2, Databricks, MSSQL, Mysql
Successfully led and completed three major big data and platform migration projects, demonstrating my ability to manage complex initiatives from inception to completion. In addition, Engineered new software products using Python and C#, significantly enhancing the productivity and operational efficiency of the supply chain and production departments. Furthermore, I implemented a data warehouse to streamline reporting solutions, ensuring data accuracy and accessibility. I also established development standards for SQL, PowerBI, and Data Warehouse, promoting consistency and best practices across the organization. My work extensively involved Azure, Azure Synapse, and Data Factory, leveraging these technologies to optimize data management and analytics capabilities.
-
System Analyst / Programmer
C#, Asp.net, Javascript, MSQL, SSIS
Successfully completed a data migration project to consolidate three different ERP systems, ensuring seamless integration and data consistency across the organization. Independently, I addressed major bottlenecks and eliminated database lockups in MS SQL Server by implementing a data warehouse and data purging strategies. These improvements significantly increased performance and eliminated transaction losses, saving the company $100,000 annually in downtime costs. Additionally, I led the conversion of the current ERP system from a Windows-based application to a web-based application, enhancing accessibility and user experience.