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

Jesus Alejandro G.

@jesus21282

 5.0 (13 レビュー)
4.4
4.4
100%
100%
$30 USD / 時間
VENEZUELAのフラグ
maracaibo, venezuela
$30 USD / 時間
100%
完了したプロジェクト
100%
予算内
100%
期限内
27%
再採用率

Excel Expert - VBA - PowerPivot - Power BI

Strong Excel and Power BI skills, with extensive experience in the following: ✓ Excel Spreadsheet Formulas, Charts and Pivot Tables ✓ Reports & Dashboard Design with Excel, PowerPivot and Power BI ✓ Advanced DAX for PowerPivot / Power BI Data Models ✓ Database design and implementation with MS Access and SQL queries ✓ VBA for Macros, User-Forms, reporting tools and web scraping ✓ Data Cleansing & Data Manipulation *** +24 Months Experience as an Excel and Power BI Data Analyst. Major accomplishments include: - Implemented the Corporate KPIs dashboards for Management of a major venezuelan Oilfield Drilling Contractor - Designed and implemented sales performance dashboards (with calculations in DAX) for several franchise-stores companies. *** Bachelor Telecommunications Engineer *** Upwork Top Rated Freelancer Do not hesitate to contact me If you need an Excel expert, this may save you considerable time and money.
Freelancer Excel Experts Venezuela
全て見る Excel Experts 、 Venezuela

仕事についてJesus Alejandro G.に連絡する

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

ポートフォリオ

2641816
Project consisting in making Workbook for registering sales of a venezuelan sand-mining farm. Approached with VBA buttons and UserForms. Accomplishments: - Cleaned and normalized existing data - Developed data model prior to creating definitive tables - Implemented an Input UserForm that retrieves relevant data and writes all the information to tables error-free. - Created macro for reporting summary about weekly Sales per customer per product.
VBA Solution for Sales Log and Report
Project consisting in making Workbook for registering sales of a venezuelan sand-mining farm. Approached with VBA buttons and UserForms. Accomplishments: - Cleaned and normalized existing data - Developed data model prior to creating definitive tables - Implemented an Input UserForm that retrieves relevant data and writes all the information to tables error-free. - Created macro for reporting summary about weekly Sales per customer per product.
VBA Solution for Sales Log and Report
2641813
This small project consisted in implementing a custom Polar-coordinates Layout for plotting the trajectory of a directional oilwell. Required geometrics and Excel Charts knowledge.
Custom Polar Plot in Excel
2641777
Upwork project consisting in making complex analysis +32000 rows of raw data from two CSV files. Accomplishments: - Imported CSVs to Excel - Cleaned and normalized data using VBA code - Develop and load a Excel's PowerPivot data model out of the raw data - Developed two Calculated Fields out of the data model with DAX code, using relational tables functions and custom filtering - Displayed calculated fields in explicit graphs from Pivot Tables and Pivot Charts Remarks: - Solved a complex data analysis problem using DAX, which couldn't be easily or totally not achievable with regular Excel formulas. - Performance level in this project was rewarded with 33% bonus in payment, and heading for work continuity with employer.
Statistical Analysis of raw data using PowerPivot
Upwork project consisting in making complex analysis +32000 rows of raw data from two CSV files. Accomplishments: - Imported CSVs to Excel - Cleaned and normalized data using VBA code - Develop and load a Excel's PowerPivot data model out of the raw data - Developed two Calculated Fields out of the data model with DAX code, using relational tables functions and custom filtering - Displayed calculated fields in explicit graphs from Pivot Tables and Pivot Charts Remarks: - Solved a complex data analysis problem using DAX, which couldn't be easily or totally not achievable with regular Excel formulas. - Performance level in this project was rewarded with 33% bonus in payment, and heading for work continuity with employer.
Statistical Analysis of raw data using PowerPivot
1660251
Valid CCNA-RS Certification. Cisco ID CSCO12363131.
Cisco Certified Network Associate - Routing & Switching
2641816
Project consisting in making Workbook for registering sales of a venezuelan sand-mining farm. Approached with VBA buttons and UserForms. Accomplishments: - Cleaned and normalized existing data - Developed data model prior to creating definitive tables - Implemented an Input UserForm that retrieves relevant data and writes all the information to tables error-free. - Created macro for reporting summary about weekly Sales per customer per product.
VBA Solution for Sales Log and Report
Project consisting in making Workbook for registering sales of a venezuelan sand-mining farm. Approached with VBA buttons and UserForms. Accomplishments: - Cleaned and normalized existing data - Developed data model prior to creating definitive tables - Implemented an Input UserForm that retrieves relevant data and writes all the information to tables error-free. - Created macro for reporting summary about weekly Sales per customer per product.
VBA Solution for Sales Log and Report
2641813
This small project consisted in implementing a custom Polar-coordinates Layout for plotting the trajectory of a directional oilwell. Required geometrics and Excel Charts knowledge.
Custom Polar Plot in Excel
2641777
Upwork project consisting in making complex analysis +32000 rows of raw data from two CSV files. Accomplishments: - Imported CSVs to Excel - Cleaned and normalized data using VBA code - Develop and load a Excel's PowerPivot data model out of the raw data - Developed two Calculated Fields out of the data model with DAX code, using relational tables functions and custom filtering - Displayed calculated fields in explicit graphs from Pivot Tables and Pivot Charts Remarks: - Solved a complex data analysis problem using DAX, which couldn't be easily or totally not achievable with regular Excel formulas. - Performance level in this project was rewarded with 33% bonus in payment, and heading for work continuity with employer.
Statistical Analysis of raw data using PowerPivot
Upwork project consisting in making complex analysis +32000 rows of raw data from two CSV files. Accomplishments: - Imported CSVs to Excel - Cleaned and normalized data using VBA code - Develop and load a Excel's PowerPivot data model out of the raw data - Developed two Calculated Fields out of the data model with DAX code, using relational tables functions and custom filtering - Displayed calculated fields in explicit graphs from Pivot Tables and Pivot Charts Remarks: - Solved a complex data analysis problem using DAX, which couldn't be easily or totally not achievable with regular Excel formulas. - Performance level in this project was rewarded with 33% bonus in payment, and heading for work continuity with employer.
Statistical Analysis of raw data using PowerPivot
1660251
Valid CCNA-RS Certification. Cisco ID CSCO12363131.
Cisco Certified Network Associate - Routing & Switching

レビュー

変更を保存しました
1 - 5 / 12 レビュー表示中
 レビューを絞り込む：
5.0
$340.00 USD
Project for Jesus Alejandro G. -- 2
Great BI expert!
Excel
SQL
Microsoft Access
Analytics
+1 もっと
I
のフラグ Tyler O.
@indigoc
•
6年前
5.0
$60.00 USD
Project for Jesus Alejandro G.
Súper considerado, un placer.
Excel
SQL
Microsoft Access
Analytics
+1 もっと
ユーザーアバター
のフラグ Alexander R.
@acrcpr
•
6年前
5.0
£80.00 GBP
Project for Jesus Alejandro G.
Small job - but required expertise in DAX and Powerpivot. Jesus understood the brief and delivered exactly what i asked for including very professional explanation of the code. Many thanks.
Excel
Web Scraping
Microsoft Access
Telecommunications Engineering
+1 もっと
D
のフラグ David B.
@davidrbetts
•
7年前
5.0
$80.00 AUD
access and excel 1
GOOD WORK................................
Excel
Microsoft Access
ユーザーアバター
のフラグ Rammohan M.
@rammohan944
•
7年前
5.0
€150.00 EUR
Power BI connection to API + data organization in graphs
again good work
Excel
ユーザーアバター
のフラグ Michal M.
@michalemem
•
7年前

経験

Data & Phone Cabling Technician

PDVSA
8月 2011 - 10月 2011 (2 , 1 )
Data & Phone Cabling Technician. Switched networks. Structured cabling.

教育

Petroleum Engineer

Universidad del Zulia, Venezuela 2008 - 2015
(7 )

Telecommunications Engineer

Universidad Rafael Urdaneta, Venezuela 2007 - 2012
(5 )

資格

Duolingo Proficiency Exam: 10.0 / 10 in English

Duolingo - Test Center
2014
Duolingo Test Center - Scored 10/10 in English Language (Expert) "Expert. Can understand virtually anything heard or read, even intellectually demanding material such as an academic lecture or a book on philosophy. Can use the language fluently and spontaneously in a way that can even be more advanced than an average native speaker."

CCNA R&S

Cisco Systems Inc.
2013
Cisco Certified Network Associate - Routing & Switching

出版物

Evaluation of Packet Microwave as an alternative for modernization of mobile networks of Maracaibo

University Rafael Urdaneta
Special Gradework for applying to the title of Telecommunications Engineer. 2012: University Rafael Urdaneta. Maracaibo, Venezuela. Applied evaluation matrix for comparing NG-SDH vs Packet Microwave as technologies for data transport for further mobile network deployments in Maracaibo VE

仕事についてJesus Alejandro G.に連絡する

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

認証

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

認定

us_eng_1.png US English 1 75%

トップスキル

Excel 14
Microsoft Access 10
Visual Basic for Apps 7
SQL 4
Analytics 3

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

Excel Experts in Venezuela
Excel Experts
Microsoft Access Developers
Visual Basic for Apps Developers

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

Excel
Microsoft Access
Visual Basic for Apps
SQL
前のユーザー 新しいユーザー
招待状の送信に成功しました！
ありがとうございます！無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
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)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。