• Develop and deployment of several Allegro’s Horizon class events to enhance its functionality using C# on Visual Studio 2019 and SQL Server 2012. • Worked with the Allegro and Ernst & Young implementation team to develop the visual model, data model, and class events to Allegro testing environments. Created and maintained a code repository on Microsoft Team Foundation to control the versioning of the Allegro objects.• Developed multiple SQL queries to perform data clean up on Allegro test databases. Created different scripts to recreate test database environments and Allegro configurations for user testing.

• Maintenance and enhancement of SSIS packages to import data from Endur staging tables to Allegro Database using Visual Studio 2017.• Develop and deployment to Allegro of several reports using SSRS for Crude and Natural Gas according to the business specification.• Worked with Ernst & Young Business Analysts to design and develop several class events using C# on Visual Studio 2019 and SQL Server 2012 for the customization of Allegro to specific user requirements.• Worked with Ernst & Young Business Analysts to ensure proper design and implementation of SQL queries, stored procedures, and views used in Allegro business processes.

• Involved in the complete system development life cycle including requirement gathering, analysis, design, and development of C# modules to be used in Repsol ETRM application.• Provided technical support to Repsol’s Allegro NAGP team on SQL Server performance tuning and query optimization using SQL Server Management Studio execution plans. • Used SQL Server profiler to analyze and optimize the performance of queries and made suggestions of code improvements and/or clustered or non-clustered index creation.• Created and deployed SQL Server Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers, CTEs, and Triggers to facilitate efficient data manipulation using Repsol ETRM application.• Created and scheduled jobs to run on Allegro for the weekly and monthly archiving of data using SQL Server Stored Procedures.• Created and deployed SQL Server Stored Procedures to facilitate efficient data archiving from Allegro’s database.• Created and maintained technical documentation of the newly developed functionalities including user and operation guides, process, and support manuals.

Multiple developments in C#, ASP.NET, SQL Server, SQL Server Integration Services (SSIS), Ext.NET JavaScrip framework, Telerik Kendo UI JavaScript framework to support different bussiness process.Analyzed requirements and eventually redesigned applications according to users needs.

Multiple network responsibilities. Installation, configuration, and administration of the fiber-optic network on a complete refinery, this infrastructure was used to support the connection between administrative and production areas.Helped to train staff in troubleshooting computer installation and configuration, printers, modems, and network operating systems, hardware, and software conflicts. Assisted staff with technical writing, product documentation, and web page layout design. Wrote custom applications in Visual Basic 3.0 to assist customer service and tech support.DBA Admin of an Oracle database based on HP-Unix mainframe.HP-Openmail administrator.