Sergio A. Profile

4,9

(31 değerlendirme)

Şu anda adlı kullanıcıyı takip ediyorsunuz

Kullanıcıyı takip etmede hata.

Bu kullanıcı kullanıcıların kendisini takip etmesine izin vermiyor.

Zaten bu kullanıcıyı takip ediyorsunuz.

Üyelik planınız sadece 0 takibe izin veriyor. Buradan yükseltme yapın.

başarılı bir şekilde takipten çıkarıldı

Kullanıcının takip edilmesinde hata.

adlı kullanıcıyı başarılı bir şekilde tavsiye ettiniz

Kullanıcıyı tavsiye etmede hata.

Bir şeyler yanlış gitti. Lütfen sayfayı yenileyin ve tekrar deneyin.

E-posta başarılı bir şekilde doğrulandı.

$40 USD / hour

lima,

peru

$40 USD / hour

Şu anda burada saat 12:03 ÖS

Haziran 22, 2015 tarihinde katıldı

4 Tavsiye

Sergio A.

@SergioAlfaroV

4,9

(31 değerlendirme)

6,1

100%

$40 USD / hour

lima,

peru

$40 USD / hour

%97

Tamamlanmış İş

%97

Bütçe Dahilinde

%86

Zamanında

%13

Tekrar İşe Alınma Oranı

Microsoft Certified Data Solutions Expert, MBA

15+ years of experience in Data Engineering, BI, SQL, reports/dashboards design and construction, ETL/ELT, Data Warehousing, Data Analytics, database administration/tuning/optimization, and related work. 7+ years of experience working remotely on project all around the world. Native Spanish speaker, and near-native English speaker, located in the American Central Timezone (GMT -05). Ideal for near-shore projects requiring constant communication during office hours. TECH STACK =========== MS SQL SERVER: - Transact-SQL - Administration - Tuning MS SQL SERVER BI ON PREM STACK: - Power BI: DAX, M - Reporting Services - Analysis Services: Tabular (DAX), OLAP(MDX) - Integration Services AZURE CLOUD DATA STACK: - Azure Data Factory - Synapse - Databricks - Data Lake SCRIPTING: - Python - VB.NET - C# - PowerShell OTHERS: - Snowflake - MS Excel: Formulas, VBA (Macros) - QlikView - Tableau - Oracle (PL/SQL) - MySQL - PostgreSQL - UNIX - XML - YML - JSON - Git - SCRUM ** Adjustable rates according to work complexity, urgency, and/or project size. **

SQL Developers freelancerlarından Peru içinden olanlarının tümünü görün.

Sergio A. ile işiniz hakkında iletişime geçin

Detayları sohbet üzerinden tartışmak için giriş yapın.

Portföy

This is a Time Tracker Application to be used by supervisor of a wood processing plant to register labor and duration per employee, work order, machine and type of task.

Time Tracker App (VB.Net + SQL)

This is an app for the user to import PDF filled forms to SQL Server. The main importing logic was written on the SQL procedure, while other validation rules was coded on the VB.NET app. The core functionality detected the fillable fields on the PDF file and converted their contents to a XML file. Then, the XML data structure is pulled to a table in SQL Server.

App to import PDF forms (VB.NET+SQL)

This is a suicide prevalence world wide map per Country that I made using Power BI. I used the Filled Map visual that pulls the world wide map from Bing, suicide prevalence data from the WHO, and Country ISO codes (2 and 3 letters) and names from a Wikipedia page.

Suicide prevalence map per Country

This is my MCSE (Microsoft Certified Solutions Expert) Data Management and Analytics Certificate, obtained in November 2019.

MCSE Data Mgmt and Analytics Certif

This is a Traffic Incidents Dashboard I made using Power BI and SQL Server. I built the SQL database from scratch based on a series of data sources, flat files and APIs, and also the Power BI dashboard.

Power BI Traffic Incidents Dashboard

This is a T-SQL Create Database Trigger to auto-create User Based on Login, which is basically a server level trigger that executes when a database is created. What it does is create a user within the newly created database, based on a previously created login, grant needed permissions, and associate with the mentioned login. Also the trigger does this for all the databases where this user hasn't been created before.

T-SQL Complex Server Level Trigger

Time Tracker App (VB.Net + SQL)

App to import PDF forms (VB.NET+SQL)

Suicide prevalence map per Country

MCSE Data Mgmt and Analytics Certif

Power BI Traffic Incidents Dashboard

T-SQL Complex Server Level Trigger

Değerlendirmeler

Değişiklikler kaydedildi

31 değerlendirme içinden 1 - 5 arasındakiler gösteriliyor

Değerlendirmeleri filtreleme kriteri:

5,0

£50,00 GBP

DTSX Package.

A true pro. Really new his stuff. Very quick.

SQL

Microsoft SQL Server

SSIS (SQL Server Integration Services)

Richard L.

@Slixter

•

10 ay önce

5,0

$2.650,00 USD

SQL Programmer/Data Warehouse Cube

Wonderful communication and work -

SQL

Oracle

Database Administration

Database Programming

Microsoft SQL Server

Dominick B.

@nbarbarise2020

•

3 yıl önce

5,0

$50,00 USD

Crear presentación de Power Bi - Fecha límite 14/08

Sergio cumplió con mis expectativas. Estubo muy atento, enviandome en todo momento los avances de mi proyecto. Gran comprensión de las consignas y feedback. Lo recomiendo y seguramente volveré a solicitar sus servicios!!! Muchas Gracias Sergio!!

Presentations

Big Data Sales

T-SQL (Transact Structures Query Language)

Power BI

Julieta Marina F.

@AromasMgZN

•

4 yıl önce

5,0

$300,00 USD

Rolling Balance Sheet Power BI

Performed work very quickly, very easy to work with.

Power BI

Tom C.

@tcasekpi

•

4 yıl önce

5,0

$50,00 USD

Project 26553040 has been deleted

i liked very much to work with him

Ilan T.

@ilantep

•

4 yıl önce

Deneyim

BairesDev | Client: Kimbel Mechanical Systems

Nis 2016 - Şu anda

Telecommuting (home/office) work. Design and development of accounting and financial reports, using Viewpoint ERP, SQL Server 2014 (T-SQL) and SSRS. Work entirely in English (since the client is based in Arkansas, USA). Major Projects: - Daily Dashboard (with daily indicators, for the CEO) - Profit and Loss: Cost of Construction (for the CFO) - Monthly Reports (battery of monthly reports, for several users) - Daily Invoices (daily subscription - invoices w/attachments, for several users)

Cerámica San Lorenzo

Oca 2013 - Şu anda

Long time on-demand freelancer - with approximately 500 work hours through more than 4 years. Analysis, design, development and implementation of Sales, Logistics and Marketing dashboards (customer segmentation matrix) using SQL Server and Qlikview.

MDP Consulting | Client: Ferreyros

Oca 2016 - Eyl 2016 (8 ay, 1 gün)

• Requirement identification, development and deployment of Fill Rate Indicators Datamart, for Logistics and Grand Mining (AS/400, SQL Server (T-SQL), DataStage, Cognos). • Improvements in Audit/FIU reports (Cognos). • Financial Consolidation project (MS Excel, , SSIS, T-SQL).