Imagen de perfil de SergioAlfaroV
@SergioAlfaroV
Bandera de Peru Lima, Peru
Miembro desde el 22 de junio de 2015
4 recomendaciones

SergioAlfaroV

En línea Desconectado
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. **
$40 USD/hr
31 comentarios
6.1
  • 97%Trabajos completados
  • 97%Dentro del Presupuesto
  • 86%A tiempo
  • 13%Tasa de recontratación

Elementos del portafolio

Comentarios recientes

  • imagen de Richard L. DTSX Package. £50.00 GBP

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

  • imagen de Dominick B. SQL Programmer/Data Warehouse Cube $2650.00 USD

    “Wonderful communication and work -”

  • imagen de Julieta Marina F. Crear presentación de Power Bi - Fecha límite 14/08 $50.00 USD

    “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!!”

  • imagen de Tom C. Rolling Balance Sheet Power BI $300.00 USD

    “Performed work very quickly, very easy to work with.”

  • imagen de Ilan T. Project 26553040 has been deleted $50.00 USD

    “i liked very much to work with him”

  • imagen de Chris A. SQL Server - T-SQL Expert Coder $75.00 USD

    “Sergio is an excellent resource on writing T-SQL (SQL Server) complex queries. He had delivered the work right on time with tight dead lines. Guys I'm pretty sure he would live up to all your expectations. Hire him!!! I would definitely go for him again.”

Experiencia

Viewpoint/SSRS Specialist

BairesDev | Client: Kimbel Mechanical Systems Apr 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)

Business Intelligence Consultant

MDP Consulting | Client: Ferreyros Jan 2016 - Sep 2016 (8 months)

• 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).

SQL Server Specialist

Cencosud Sep 2015 - Nov 2015 (2 months)

• Conducted migration of previous multi-node schema databases to virtual servers. Indexing and partitioning of massive tables, as well as control and monitoring of the migration project. • Research and development of advanced solutions using SQL Server, such as encrypted data management, SQLCMD, xp_cmdshell, and database event auditing, among others.

Senior IT Consultant

PSS | Client: Banco Falabella Mar 2015 - Dec 2015 (9 months)

• Development of the loading process of Credit Card Applications interfaces, multidimensional modeling and respective reports, using DTS 2000. • Support to the Datawarehouse team, in data monitoring and reprocessing tasks. • Customer Data and Transaction Quality Assessment, to evaluate the feasibility of the Datamart Liabilities project, using Oracle, DataStage and Business Objects. • Business Analysis of the Datamart Liabilities project, and management through the stages of the project.

Qlikview Specialist

Cerámica San Lorenzo Jan 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 Analyst

Yanbal International Apr 2012 - Sep 2013 (1 year)

• BI projects Management for the areas of Customer Service, Marketing, Finance, Salesforce Training, etc. • Built-in reporting for internal customer decision making, with SSRS, SSAS and Cognos. • Support to the Data Warehouse loading process, in SQL Server (TSQL).

Qlikview Consultant

Qliksoft Jan 2012 - Apr 2012 (3 months)

- Construction of extraction processes using QV. - Design, development and PTP of Qlikview dashboards. - Database programming in SQL Server and Oracle.

Educación

MBA

Universidad ESAN , Peru 2013 - 2015 (2 years)

Business Intelligence and Strategic Information Management

Universidad Peruana de Ciencias Aplicadas, Peru 2012 - 2012 (1 month)

Bachelor Degree: Systems Engineer

Universidad Alas Peruanas, Peru 2001 - 2005 (4 years)

Business Internationalization Course, ICEX

Spain 2015 - 2015 (1 month)

IT Project Management Course, Cibertec

Peru 2009 - 2009 (1 month)

Calificaciones

MCSA: Microsoft Certified Solutions Associate: SQL Server 2014 (2017)

Microsoft

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

First Certificate in English (2011)

University of Cambridge

Certificate that accredits proficiency on English language: reading, writing, speaking and listening.

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

Microsoft

MCSE: Microsoft Certified Solutions Expert: Data Management and Analytics

Certificaciones

  • Spanish - English Translation
    97%
  • US English Level 1
    95%
  • Preferred Freelancer Program SLA
    92%
  • SQL Level 1
    92%
  • oraclesql 1
    90%
  • US English Level 3
    90%
  • Numeracy 1
    87%
  • US English Level 2
    85%
  • C# 1
    85%
  • Data Entry Level 1
    85%
  • MySQL Level 1
    85%
  • SQL Server 1
    82%
  • SQL Server 2
    82%
  • SQL Level 3
    82%
  • SQL Server 3
    77%
  • SQL Level 2
    77%
  • UK English 1
    75%

Verificaciones

  • Conectado a Facebook
  • Freelancer Preferido
  • Pago verificado
  • Teléfono verificado
  • Identidad verificada
  • Correo Electrónico Verificado

Mis habilidades principales

Buscar freelancers similares

Usuario anterior Usuario siguiente