Imej profil SergioAlfaroV
Penanda Peru Lima, Peru
Ahli semenjak 22 Jun 2015
4 Cadangan


Dalam Talian Luar Talian
14 years of experience in Data Engineering, Business Intelligence, SQL, reports/dashboards design and construction, ETL, Data Warehousing, analytics, database administration, and database related projects. 4 years of experience working remotely on project all around the world. A Software Engineer located in Lima, Peru, with a Master of Business Administration, studies in Project Management and Business Intelligence, MCTS SQL Server 2008-R2, MCSA SQL Server 2014, and MCSE Data Management and Analytics, currently preparing myself to obtain the Scrum Master certification. Native Spanish speaker, and near-native English speaker, located in American Central Time Zone (GMT -05). SKILLS: - SQL Server (T-SQL & DBA) - SQL Server BI Stack: - Power BI/DAX - Report Builder/SSRS - Analysis Services: Tabular(DAX) & OLAP(MDX) - SSIS - QlikView/QlikSense - Tableau - Data Warehousing - Agile: Scrum/Kanban - Excel - Access - Azure - VB.NET - C# - Powershell - Oracle (PL/SQL) - MySQL - PostgreSQL Adjustable hourly rate according to work complexity, urgency, and/or project size.
$30 USD/hr
26 ulasan
  • 97%Kerja Diselesai
  • 95%Mengikut Bajet
  • 76%Tepat Pada Masa
  • 17%Kadar Ulang Upah

Portfolio Items

Ulasan Terkini

  • Imej 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.”

  • Imej Craig W. Project for Sergio A. $100.00 USD

    “Sergio is a creative thinker and is always able to take what I am hoping to accomplish and make it reality with his SQL skills.”

  • Imej Fran G. Consulta SQL - Microsft Access $25.00 USD

    “Muy buen trabajador, educado y responsable. el trabajo un 100%”

  • Imej Infocus B. Consultor Power BI $275.00 USD

    “Sergio respondió rápidamente y cumplió en tiempo y forma con las tareas solicitadas referidas a Power BI. Estamos muy conformes y seguramente continuemos contratando sus servicios.”

  • Imej Gary S. Power BI Matrix Report Creation from flat files + explanation document on how to receate this report £110.00 GBP

    “Sergio is a pleasure to work with. Professional and knows what he is doing, completed the project on time and within budget and provided great explanation of how he had created the report. Would recommend and will be working with Sergio in the future.”

  • Imej Don H. Oracle to SQL Server view/sp/function conversion $40.00 USD

    “Excellent Oracle/SQL Server skillset! Will definitely use again!”


Viewpoint/SSRS Specialist

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

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

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

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

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

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

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.



2013 - 2015 (2 years)

Business Intelligence and Strategic Information Management

2012 - 2012 (1 month)

Bachelor Degree: Systems Engineer

2001 - 2005 (4 years)

Business Internationalization Course, ICEX

2015 - 2015 (1 month)

IT Project Management Course, Cibertec

2009 - 2009 (1 month)


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


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.


  • Spanish - English Translation
  • US English Level 1
  • SQL Level 1
  • Preferred Freelancer Program SLA
  • oraclesql 1
  • US English Level 3
  • Numeracy 1
  • C# 1
  • Data Entry Level 1
  • MySQL Level 1
  • US English Level 2
  • SQL Level 3
  • SQL Server 1
  • SQL Server 2
  • SQL Level 2
  • SQL Server 3
  • UK English 1


  • Facebook Disambung
  • Freelancer Keutamaan
  • Bayaran Disahkan
  • Telefon Disahkan
  • Identiti Disahkan
  • E-mel Disahkan

Kemahiran Teratas Saya

Cari Freelancer yang serupa