Database Analyst

Mabel Guerra Saumell

Brown Deer • Wisconsin • USA • adbn23@r.postjobfree.com • 623-***-****

PROFESSIONAL SUMMARY

Bachelor in Computer Sciences, more than 8 years working in Technical environment. Ability to prioritize and multi-task in a relatively complex environment. Ability to effectively communicate with internal IT staff and company personnel. Self-starter and quick learner who enjoys problem solving.

More than 8 years working in Database Design, Development and Implementation with experience in Microsoft SQL Server 2008/2012/2014, T-SQL.

Skills in query optimization, creating database objects, data modification and data retrieval.

Experience in Execution Plan Analysis.

Index creation and index maintenance (Clustered, NonClustered, FullTex Index).

Experience writing Views, Functions, Stored Procedures, Indexes, and Database Triggers using T-SQL.

Error Handling.

Application troubleshooting. Find the root cause of the error and implement both immediate and long-term solutions.

Database Project Development using Team Foundation Service (TFS).

Experience in ETL processes using SQL Server Integration Services.

Data warehousing design.

SSAS multidimensional model, Tabular Model.

Skills developing reports using SQL Server Reporting Services.

DBA skills.

TECHNICAL SKILLS

Database Systems:

SQL Server 2008, SQL server 2012, SQL Server 2014, SQL server 2016.

Software’s/Features:

SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services. SQL Server Agent Jobs. SQL Server Management Studio. SQL Server Analysis Services. Team Foundation Services.

Languages:

SQL, T-SQL, C#. Familiarity with HTML5, CSS3.

EDUCATION

Sept. 2001 – July 2006 Technical Systems Engineering.

Holguín University UHO “Oscar Lucero Moya”, Holguín, Cuba.

PROFESSIONAL EXPERIENCE

AB Data Ltd. Glendale, WI. Feb. 2019 – Present

Database Analyst

Development and maintenance of the main data migration processes, using a combination of ETL tools like SSIS packages and stored procedures. Migration occurs from Azure server to on-premises servers, as well as from on-premises servers to other servers of the same type.

Preparation of table structures with their different columns and their respective data types to ensure successful loading of data during the migration process.

Development of complex queries to respond to different requests for reports by project coordinators. Using joins, CTEs, temporary tables, and other resources.

Extensive handling of the data manipulation language to ensure that the final information on the production server has the quality standards of the company. Using updates, deletes, inserts daily, and over large volumes of data.

Automating processes such as stored procedures execution and SSIS packages execution using SQL Server Agent Job.

State Distance University (UNED) San José, Costa Rica. Jan. 2015 – Dec. 2018

Database Analyst / Developer.

Write complex queries in T-SQL for reports using SS Reporting Services.

Rebuild existing reports in order to cover new requirements.

Manage back-ups of database and others basics DBA tasks.

Development of simple and complex ETL processes for the integration of data in the system, using SSIS.

Provide all the technical documentation for new ETL processes and new reports.

Perform queries optimization to improve database performance.

Provide technical support to end-users of the application.

Automated some maintenance tasks using SQL Server Agent Jobs.

Multidimensional and Tabular Model using SSAS. Facts, Dimensions, Cubes, Partitions.

Alfa Médica S.A/ Suministros Médicos San José, Costa Rica. Feb. 2012– Nov. 2014

Database Developer

Working along with de Database Administrator in order to achieve the optimal functioning of the system through the creation of indexes, as well as the optimization of queries.

Perform basic tasks of maintenance and security of the database, such as management of user permissions, management of backup copies of the database, release unused space in TempDb, among others.

Provide technical support to end-users of the application, specifically of the accounting module, and human resources module.

Application troubleshooting. Find the root cause of the error and implement both immediate and long-term solutions.

Univ. of Computer Science UCI. La Habana, Cuba. Sept. 2006 – July 2011

Instructor

Instructor for the Systems Engineer career’s Database program, specifically Databases I and II.

Collaborate in the development of the student database system for the University using PosgreSQL.

Provide all the technical documentation for the database design and implementation using Rational Rose tool.

TRAINING AND CERTIFICATIONS

2019 Microsoft Certified Solutions Expert: Data Management and Analytics.

2019 Microsoft Certified Solutions Associate: SQL Server 2012/2014.

2019 Microsoft Certified Professional: Implementing a Data Warehouse with SQL Server.

2018 Microsoft Certified Professional: Querying SQL Server.

2018 Microsoft Certified Professional: Administering SQL Server 2012/2014 databases

2014 Cenfotec Univ. Costa Rica. SQL Server Data Tools for Visual Studio 2013.

Contact this candidate