Hình đại diện của SergioAlfaroV
@SergioAlfaroV
Cờ của Peru Lima, Peru
Làm thành viên từ Ngày 22 tháng 06 năm 2015
1 Đề xuất

SergioAlfaroV

Trực tuyến Ngoại tuyến
I have 12 years of experience in Business Intelligence, reporting, ETL, multidimensional modeling, data analysis, database management, and database related projects. A Software Engineer located in Peru, with a Master of Business Administration, studies in Project Management and Business Intelligence, MCTS SQL Server 2008-R2, and MCSA SQL Server 2014, currently preparing myself to obtain the MCSE: Data Management and Analytics. Native Spanish speaker, and a near-native English speaker, I share the same time zone that the American Central Time Zone (GMT -05). Adjustable hourly rate according to work complexity, urgency, and/or project size. Microsoft Skills: - SQL Server (T-SQL) - SQL Server BI (SSRS, SSAS, SSIS) - Reporting Services / Report Builder - Analysis Services: Tabular (DAX) and Multidim (MDX) - Integration Services - Excel - Access - Azure - VB.NET - Power BI - Powershell Other Skills: - English Language - QlikView - Oracle (PL/SQL) - MySQL - PowerView
$35 USD/hr
16 nhận xét
5.5
  • 100%Công việc đã Hoàn thành
  • 93%Đúng ngân sách
  • 65%Đúng hạn
  • 14%Tỉ lệ thuê lại

Portfolio

Các nhận xét gần đây

  • hình của cpatronperez SQL script for renaming all tables in a DB $75.00 USD

    “He delivered a perfect job! Highly recommended!”

  • hình của vruffini Project for Sergio A. €30.00 EUR

    “We had an ETL problem and Sergio pointed us to the right direction to solve it. So a very simpe project, but he delievered out of his excellent knowledge of Reporting Services and Analysis services.”

  • hình của Jaimeaga SQL QUERIES TO MANAGE INFORMATION IN EXCEL $160.00 USD

    “It was a pleassure to work with Sergio, he understood the idea after a very few questions, the delivery was exaclty what I was looking for. Despite I add complexity he was able to fullfil the new requirements”

  • hình của jasonsetzer81 SQL Server - Finish SQL View Report (Excel and PowerBI) $420.00 USD

    “Great work”

  • hình của josenandopr Microsoft SQL Server Management Studio €60.00 EUR

    “Pretty straight to the point, professional mostly. Sometimes forgets about stuff, needs to ask a few times.”

  • hình của dsb100 Digitize hard copy data $500.00 USD

    “The project took Sergio longer than the original quote.”

Trải nghiệm

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.

Giáo dục

MBA

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)

Bằng Cấp

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.

Chứng nhận

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

Xác minh

  • Đã kết nối với Facebook
  • Freelancer ưa thích
  • Thanh toán đã được xác minh
  • Đã xác nhận qua điện thoại
  • Đã xác thực danh tính
  • Email đã được xác minh

Các kỹ năng hàng đầu của tôi

Xem những Freelancer tương tự