Freelancer ロゴ 使用方法 仕事を検索する
ログイン 登録
プロジェクトを投稿する
プロフィールカバー写真
あなたはをフォローしました
ユーザーのフォローエラー。
このユーザーはフォローを許可していません。
このユーザーをすでにフォローしています。
あなたのメンバーシッププランは、0 個のフォローのみ許可します。アップグレードは、 こちら。
のフォローを解除しました
ユーザーのフォロー解除エラー。
あなたはを推薦しました
ユーザーの推薦エラー。
何か問題が発生しました。ページを更新してもう一度お試しください。
メールの認証に成功しました。
ユーザーアバター
$40 USD / 時間
PERUのフラグ
lima, peru
$40 USD / 時間
こちらは現在1:53 午前です
登録日: 6月 22, 2015
4 推薦

Sergio A.

@SergioAlfaroV

annual-level-three.svg
verified-v2.svg
preferred-freelancer-v2.svg 4.9 (31 レビュー)
6.1
6.1
100%
100%
$40 USD / 時間
PERUのフラグ
lima, peru
$40 USD / 時間
97%
完了したプロジェクト
97%
予算内
86%
期限内
13%
再採用率

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. **
Freelancer SQL Developers Peru
全て見る SQL Developers 、 Peru

仕事についてSergio A.に連絡する

ログインしてチャットで詳細を相談しましょう、

ポートフォリオ

8385491
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 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)
7273365
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 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)
7272976
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
7272697
This is my MCSE (Microsoft Certified Solutions Expert) Data Management and Analytics Certificate, obtained in November 2019.
MCSE Data Mgmt and Analytics Certif
6453114
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 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 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 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 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
5898774
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
8385491
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 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)
7273365
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 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)
7272976
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
7272697
This is my MCSE (Microsoft Certified Solutions Expert) Data Management and Analytics Certificate, obtained in November 2019.
MCSE Data Mgmt and Analytics Certif
6453114
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 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 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 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 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
5898774
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

レビュー

変更を保存しました
1 - 5 / 31 レビュー表示中
 レビューを絞り込む：
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)
S
のフラグ Richard L.
@Slixter
•
11か月前
5.0
$2,650.00 USD
SQL Programmer/Data Warehouse Cube
Wonderful communication and work -
SQL
Oracle
Database Administration
Database Programming
Microsoft SQL Server
N
のフラグ Dominick B.
@nbarbarise2020
•
3年前
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年前
5.0
$300.00 USD
Rolling Balance Sheet Power BI
Performed work very quickly, very easy to work with.
Power BI
T
のフラグ Tom C.
@tcasekpi
•
4年前
5.0
$50.00 USD
Project 26553040 has been deleted
i liked very much to work with him
I
のフラグ Ilan T.
@ilantep
•
4年前

経験

Viewpoint/SSRS Specialist

BairesDev | Client: Kimbel Mechanical Systems
4月 2016 - 現在
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)

Qlikview Specialist

Cerámica San Lorenzo
1月 2013 - 現在
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.

Business Intelligence Consultant

MDP Consulting | Client: Ferreyros
1月 2016 - 9月 2016 (8 , 1 )
• 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).

教育

Business Internationalization Course, ICEX

Spain 2015
(1年未満)

MBA

Universidad ESAN , Peru 2013 - 2015
(2 )

Business Intelligence and Strategic Information Management

Universidad Peruana de Ciencias Aplicadas, Peru 2012
(1年未満)

資格

MCSE: Microsoft Certified Solutions Expert: Data Management and Analytics

Microsoft
2019
MCSE: Microsoft Certified Solutions Expert: Data Management and Analytics

First Certificate in English

University of Cambridge
2011
Certificate that accredits proficiency on English language: reading, writing, speaking and listening.

MCSA: Microsoft Certified Solutions Associate: SQL Server 2014

Microsoft
2017
This certificate proves my knowledge and proficiency on Microsoft SQL Server 2014.

仕事についてSergio A.に連絡する

ログインしてチャットで詳細を相談しましょう、

認証

優先フリーランサー
本人確認済み
認証済み支払方法
電話番号認証済み
メール認証済み
Facebook接続済み

認定

span-eng.png Spanish to English Translation 1 97%
us_eng_1.png US English 1 95%
SQL_1.png SQL 1 92%
preferredfreelancer-1.png Preferred Freelancer Program SLA 1 92%
oraclesql-1.png OracleSQL 1 90%

トップスキル

SQL 27
Microsoft SQL Server 23
Excel 16
Database Administration 9
Business Analysis 8

同じようなフリーランサーを検索

SQL Developers in Peru
SQL Developers
Microsoft SQL Server Professionals
Excel Experts

同じようなショーケースを検索

SQL
Microsoft SQL Server
Excel
Database Administration
前のユーザー 新しいユーザー
招待状の送信に成功しました！
ありがとうございます！無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
Freelancer ロゴ Japan / 日本語 ヘルプ＆サポート フリーランサー カテゴリー プロジェクト コンテスト フリーランサー エンタープライズ メンバーシップ 優先フリーランサープログラム プロジェクト管理 ローカルジョブ Photo Anywhere ショーケース 開発者用API 認証を受ける デスクトップアプリ 関連情報 当社について ご利用方法 セキュリティ 投資家 サイトマップ ストーリー ニュース チーム アワード プレスリリース Careers 利用規約 プライバシーポリシー 利用規約 コピーライトポリシー 行動規範 手数料とその他費用 パートナー Escrow.com Loadshift Warrior Forum アプリApple App Store のロゴGoogle Play ロゴ
クリップボードへのコピーが失敗しました、権限を調整してからもう一度お試しください。
クリップボードにコピーされました。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。