With extensive experience as a seasoned Systems Engineer, I excel in analyzing, designing, developing, and seamlessly implementing cutting-edge applications across various platforms, including Windows, Web, Components, and Win/Web Services, alongside expertise in database management. My forte lies in process automation through the integration of the latest technologies.Microsoft Development:As a Microsoft Developer Specialist, I demonstrate proficiency in crafting Business Windows and Web .NET Applications. Leveraging Visual Studio .NET tools, Basic .Net, and C# .Net languages, I deliver solutions that adhere to the highest industry standards.Dynamic Senior Web Developer:In web development, I possess diverse skills in Classic ASP, ASP .Net, JavaScript, AJAX, JQuery, Angular JS, NodeJS, and PHP, managing databases such as MS SQL Server, MySQL, Aurora, and PostgreSQL.Business Intelligence and Data Engineering:I navigate the complexities of Business Intelligence and Data Consolidation, constructing sophisticated Advanced Analysis and Dashboards using AWS QuickSight, AWS Glue, and MS Power BI tools for comprehensive insights.Cloud / AWS:My AWS expertise includes IAM, VPC, EC2, RDS, S3, Lambda, Event Bridge, QuickSight, DMS, and AWS Glue, deployed strategically in various applications. I proficiently handle Data Migration and ETL processes within the AWS ecosystem.SQL Server Developer:With a foundation in MS SQL Server spanning 2008 to 2019, I possess advanced proficiency in SQL Server development, administration, and performance tuning. My expertise extends to query optimization, execution plan analysis, index optimization, database design, normalization, and optimization for scalability and performance. Additionally, I specialize in ETL processes, data integration, and data warehousing, with a knack for troubleshooting and resolving performance bottlenecks.Database Administrator:I have managed over 600 distributed databases, specializing in configuring servers and RDS instances, with expertise in AWS RDS with SQL Server and MySQL Aurora.Integration and Migration Specialist:Facilitating seamless integration between SQL Server and AWS Aurora databases, I execute complex database migrations involving EC2 MSSQL, AWS RDS MSSQL, and AWS Aurora with precision and efficiency.Please feel free to review my detailed experience on my LinkedIn profile:https://www.linkedin.com/in/gerardoalegria/
Listed skills include Microsoft Sql Server, Web Applications, Software Development, Asp.Net, and 24 others.
