Summary
Highly motivated Developer Professional who thrives in high-pressure environments with more than 5 years of experience working with government database and Enterprise database in SQL Server (2008, 2012/2014). Iām a person that wants to contribute to overall goals of the organization, displaying attitude, interest and applying the acquired knowledge and making available the same, so I can grow professionally while I expand my knowledge, helping and being useful to the organization in conjunction with the staff that surrounds me.
Skills
Programming:
C#.Net (ASP.NET, MVC 5, Entity Framework).
Data Base:
MySQL, MS-SQL Server (2005, 2008, 2012/2014)
Front End:
HTML, CSS, JavaScript, JQuery.
Others :
Reporting Services.
Languages
English
Spanish
Experience
Database developer
July 2014 to September 2017
General direction of Public Investment in the Ministry of Economy and Development Planning. Dirección General de Inversión Pública (DGIP) en el Ministerio de Economía Planificación y Desarrollo (MEPYD).
Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
SQL Server Reporting Services writing, updating and supporting reports using TSQL
Participates on project teams related to their area of expertise and determine productions needs with regard to systems and data requirements
Designing and creating SQL Server tables.
Writes technical specification documents and business requirements documents needed to build and support the data warehouse environment and the applications.
Assisting in transferring databases, including TempDB, to new servers using TSQL scripts
Satisfies business line data reporting requirements for the various application specific databases and or repositories used throughout the Institution.
Maintains database interfaces and monitors systems configuration to ensure and assist in the validation of data integrity.
Creates specs and implement code/scripts for any mission critical interfaces for data transport between applications, reports or data repositories
SQL Server Developer
June 2011 ā June 2014
Vixicom ā Dominican Republic, Santo Domingo
Store Procedure in SQL Server and MySQL
Creation of complex database queries, & indexes
Created Stored Procedures, User Defined functions, & Triggers
Creation of complex database queries, & indexes
SMTP, sending mail to CEO and COO (Reports Daily) in Mysql
Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.
Experience writing complex SQL Queries and Procedures.
Data Modeling
Education
Certification Querying Microsoft SQL Server 2012/2014, 2016.
Universidad Iberoamericana (UNIBE) Ingeniería Tecnologías de la Información y comunicación.2015
Instituto Tecnológico de las Américas (ITLA) tecnólogo de Desarrollo de Software, 2011.
Instituto Tecnológico de las Américas (ITLA) PHP básico, 2010.
Instituto Politécnico Parroquial Santa Ana (IPOPSA) Educación secundaria, 2008.