CARLOS VILLARROEL

Plantation, Florida

adn33o@r.postjobfree.com / 954-***-**** / www.linkedin.com/in/Carlos-Villarroel-FL

Data Quality Analyst

Dynamic professional with more than eighteen years in Information Technology, Highly knowledgeable and Experienced SQL Developer and Project Managing, focusing on detail with challenging objectives and with the ability to design solutions aligned with the organization.

My career objective is to find a job that allows me to meet new challenges professionally and personally, to help with the business, strategic projects and giving all my potential, skills and experience.

CORE STRENGTHS:

Strong Analytical Skills

Proficient

Problem-Solver

Communicator

Motivated

Results Oriented

Leadership

Data Analysis

Proactive

Innovative

Query Writing and Optimization

Performance Improvements

Team Player

Project Manager

Change Manager

PROFESSIONAL EXPERIENCE:

Wilen Direct Deerfield Beach, FL

Data Quality Analyst

April 2018 -

SQL Scripts (Views, Aggregate Function, Store Procedure, Trigger, CTE).

Defining, Analyzing and Documenting requirements / ETL using RedPoint Software

Defining scope and system objectives, Managing projects Milestones, Phases and resources.

Validate data integration / Transforming Data / Design Reports for owner

Development Alternative solutions (Java, SQLServer)

Carshoez, Inc. Fort Lauderdale, FL

Data Quality / Report Analyst

Jun 2017 - April 2018

Design and Maintain SQL Scripts. (Update, Union, Recursive Table, Transact-SQL).

Explore data / Data Analysis / Research Alternative Solutions.

Works with cross functional teams on business process improvement.

Design, Develop and Deploy Alternative solutions. (MySQL, JAVA, PHP)

Excel at developing and implementing reporting and data solutions.

Validate data integration / Design Reports for owner

Development Macros to Automate master sheets.

Corporacion Knio, Venezuela.

Project Manager

May 2016 - March 2017

Design and Maintain SQL Scripts.

Provide technical support and guidance to Developer Staff and Project Team.

Assistant Managing Project Team / risk / schedule / conflicts / project delivery

Explore data / Data Analysis / Research Alternative Solutions.

Excel at developing and implementing reporting and data solutions.

In-depth understanding of all stages of software development life cycle (SDLC).

Validate data integration / Design Reports for owner

Working on MySQL and SQL Server / Using data collections, working with the Development Team to investigate and correct software bugs and deficiencies.

Ferro-Ceramica Valcro, Venezuela.

SQL Developer / Data Analyst

Jun 2013 - Oct 2016

Creating and Optimizing diverse SQL queries

Design, develop, test and deploy an integration between Billing System and ERP.

Advised clients on necessary update and changes to Project Milestones.

Extracting and Collecting data to create needed reports.

In-depth understanding of all stages of software development life cycle (SDLC).

Managing Customer expectations proactively to maintain high satisfaction.

Assistant Managing Project Team including schedule / conflicts and project delivery.

Working on MySQL and SQL Server / using a big data collections, to help smarter business decisions. SQL queries to analyze and troubleshoot data.

Designed databases, modeling, write store procedures, reports, complex joins, nested sub-queries.

Experience BI Developing custom reports to analyze financial, operating, and billing processes

Experience using and understanding of SSRS, SSIS, SSAS, OLAP cube and Architecture.

Ferreteria EPA, C.A., Venezuela - Costa Rica.

Data Analyst / Business Analyst / Junior SQL Developer

March 1997 - Jun 2013

Implement Point of Sales Application on MySQL Database.

Develop SQL DB2 Database Interfaces, between SAP and Legacy System.

Extracting and Collecting data to create needed reports.

Excel at developing and implementing reporting and data solutions.

In-depth understanding of all stages of software development life cycle (SDLC).

Managing Customer expectations proactively to maintain high satisfaction.

Design Querys, Views and Store procedure to fill KPI on SAP BI, apply ETL for our legacy applications.

Teach Microsoft Excel Basic, Intermediate and Advanced Level .

Validate the macros performed by other users in standards documents and procedures.

Design, develop, test and implement Querys, Views and Store procedure on SQL Server Database at Point of Sales Java Application.

Design, develop, test and implement Querys, Views and Store procedure on SQL Server Database of ERP Application in house, to change and improve they application portfolio, was a support to a group company.

LANGUAGES:

EDUCATION:

Spanish: Native

English: Intermediate

IUTAJS, Valencia, Venezuela

Advanced Technical Degree in Informatics

PROFESSIONAL TRAINING:

MySQL Performance Tuning, Java Programming Language, Rational Software Modeler Fundamentals, Objects Technology and UML, in Analysis and System Design, Advanced Management Program (Coach in organizational environment), SQL Fundamental.

TECHNICAL SKILL:

SQL Server

Microsoft Office

Crystal Report, iReport, Birt, Jasper

Collaboration Tools

MySQL / Oracle/ DB2

Microsoft Excel Expert

TeamConcert.

MS Project

SQL (ETL)

Modeling Data

Java

SDLC

Google Apps

Iterative Development

SQL Scripts

Visual Basic

MS SharePoint

Google Site, Office 365

Change Management

Business Process Improvement

Contact this candidate