Logo de Freelancer Cómo funcionaBusca trabajos
Iniciar sesión Registrarse
Publica un proyecto
Foto de portada de perfil
Ahora estás siguiendo a
Error al seguir a usuario.
Este usuario no permite que los usuarios lo sigan.
Ya estás siguiendo a este usuario.
Tu plan de membresía solo permite 0 seguimientos. Mejora tu membresía aquí.
Dejaste de seguir correctamente a
Error al dejar de seguir al usuario.
Has recomendado exitosamente a
Error al recomendar al usuario.
Algo salió mal. Por favor, actualiza la página e intenta de nuevo.
Email verificado correctamente.
Avatar del usuario
$30 USD / hora
Bandera de VENEZUELA
maracaibo, venezuela
$30 USD / hora
Aquí son las 7:55 p. m.
Se unió el enero 19, 2015
3 recomendaciones

Jesus Alejandro G.

@jesus21282

 5,0 (13 comentarios)
4,4
4,4
100%
100%
$30 USD / hora
Bandera de VENEZUELA
maracaibo, venezuela
$30 USD / hora
100 %
Trabajos finalizados
100 %
Dentro del presupuesto
100 %
A tiempo
27 %
Tasa de recontratación

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
Ver todo Excel Experts en Venezuela

Contacta Jesus Alejandro G. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Portafolio

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

Comentarios

Cambios guardados
Mostrando 1 - 5 de 12 reseñas
 Filtrar reseñas por:
5,0
$340,00 USD
Project for Jesus Alejandro G. -- 2
Great BI expert!
Excel
SQL
Microsoft Access
Analytics
+1 más
I
Bandera de Tyler O.
@indigoc
•
hace 6 años
5,0
$60,00 USD
Project for Jesus Alejandro G.
Súper considerado, un placer.
Excel
SQL
Microsoft Access
Analytics
+1 más
Avatar del usuario
Bandera de Alexander R.
@acrcpr
•
hace 6 años
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 más
D
Bandera de David B.
@davidrbetts
•
hace 7 años
5,0
$80,00 AUD
access and excel 1
GOOD WORK................................
Excel
Microsoft Access
Avatar del usuario
Bandera de Rammohan M.
@rammohan944
•
hace 7 años
5,0
€150,00 EUR
Power BI connection to API + data organization in graphs
again good work
Excel
Avatar del usuario
Bandera de Michal M.
@michalemem
•
hace 7 años

Experiencia

Data & Phone Cabling Technician

PDVSA
ago 2011 - oct 2011 (2 meses, 1 día)
Data & Phone Cabling Technician. Switched networks. Structured cabling.

Educación

Petroleum Engineer

Universidad del Zulia, Venezuela 2008 - 2015
(7 años)

Telecommunications Engineer

Universidad Rafael Urdaneta, Venezuela 2007 - 2012
(5 años)

Calificaciones

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

Publicaciones

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

Contacta Jesus Alejandro G. sobre tu trabajo

Inicia sesión para comentar cualquier detalle por chat.

Verificaciones

Freelancer preferente
Identidad verificada
Pago verificado
Teléfono verificado
Email verificado
Facebook conectado

Certificaciones

us_eng_1.png US English 1 75%

Principales habilidades

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

Explorar freelancers similares

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

Explorar galerías similares

Excel
Microsoft Access
Visual Basic for Apps
SQL
Usuario anterior Usuario siguiente
¡Invitación enviada correctamente!
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Logo de Freelancer Uruguay / Español Ayuda y soporte Freelancer CategoríasProyectos Concursos Freelancers Empresarial MembresíaPrograma de Freelancers Preferentes Gestión del proyecto Trabajos localesPhoto Anywhere GaleríaAPI para desarrolladoresVerifícate Software de escritorio Información Quiénes somos Cómo funciona Seguridad Inversionista Mapa del sitio Historias NoticiasEquipoPremiosComunicados de prensaEmpleos Términos Política de privacidadTérminos y condicionesPolítica de derechos de autorCódigo de conductaCargos y TarifasSociosEscrow.comLoadshiftWarrior Forum Apps Logo de "App Store" de AppleLogo de Google Play
Falló el copiado al portapapeles. Intenta de nuevo después de ajustar tus permisos.
Copiado al portapapeles.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.