Edwin S. Profile

EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$15 USD / hour

imus,

philippines

$15 USD / hour

It's currently 12:13 PM here

Joined April 23, 2019

0 Recommendations

Edwin S.

@eisanchez57

0.0

(0 reviews)

0.0

$15 USD / hour

imus,

philippines

$15 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

Goal-Oriented SQL, VB/C# & Power BI Professional

I help established clients take their SQL Server, Windows Forms and ASP.Net projects to the next level with satisfying results on time and budget. But data doesn’t stop with storage and powerful queries. Your data should provide business insights using data analysis and data visualization. “Edwin was my team leader and mentor for more than 15 years. I learned a lot from him when it comes to T-SQL, Database Design, Programming and System Analysis. Edwin is competent and has a positive attitude especially when dealing with difficult scenarios, ... I believe Edwin has a tremendous amount of potential and an excellent addition to a team.” – Jun Marfil, a former colleague in Magsaysay Group of Companies through LinkedIn recommendations What I Offer: ✔ Database Design ✔ T-SQL Programming ✔ ETL/Integration using SSIS ✔ SSAS/Power BI Data Analysis ✔ Windows Forms and ASP.Net Web Forms ✔ Sharepoint site customization ✔ Web Research Please click the blue Hire Me button to start.

See all Visual Basic Developers in Philippines

Contact Edwin S. about your job

Portfolio

This sample shows how data can be mapped to a geographic location. The report is interactive by selecting a US State, and the graphs will change accordingly.

Relevant for Power BI, Data Visualization, Data Analysis

Map Visualization Using Power BI

This sample diagram shows a freelancing database design that showcases freelancer info and account, buyer/employer info, and project/project bids.

Take note of the following:
1. Use of primary keys with the right size
2. Use of foreign keys to ensure data integrity
3. Creation of a secondary index (lastname, firstname, middlename) for query performance when querying based on name
4. FreelancerId auto-create unique id

Database Design Diagram Using SQL Server 2017

This Power BI sample is for project cost reporting which are categorized by customer and their contract price, expenses, estimated vs. actual costs, and profit.

The data source is an Excel file.

Power BI Data Visualization on Project Management Cost

This sample shows sales information that highlights the total sales per year with a year slicer on the left.

Other key information are:
1. Performance of Sales Reps (Top 5 Sellers)
2. Sales per Quarter
3. Sales Per Region
4. Sales Per Sales Rep
5. Sales Per Item

Data and charts change when selecting a different year.

User can drill down per month.

The report also utilizes DAX (Data Analysis Expressions) in creating the time dimension.

Power BI Data Visualization Sample on Sales

This is part of the Insurance Brokering System where I used SQL Server Analysis Services (SSAS) for generating the monthly sales KPI of the group and per account officer.

The image shows the data source view coming from the billing module (fact table) with dimensions like Month period (time dimension), insurance company, insurance line, client, monthly sales targets per account officer and others.

SQL Server Analysis Services (SSAS) Sample for Sales KPI

Map Visualization Using Power BI

Database Design Diagram Using SQL Server 2017

Power BI Data Visualization on Project Management Cost

Power BI Data Visualization Sample on Sales

SQL Server Analysis Services (SSAS) Sample for Sales KPI

Reviews

Changes saved

No reviews to see here!

Experience

Valuemax Nutraceuticals

Jun 2017 - Present

Provides IT expert advise in system development

A. Magsaysay Inc.

Dec 2000 - Dec 2016 (16 years)

Managed and delivered projects successfully that increased productivity, minimized manual jobs, and deliver timely reports. The most recent projects were: 1. MHIBI system - Insurance brokering system of Magsaysay Houlders Insurnace Brokers Inc. Developed using Sharepoint 2010, SQL Server, SSIS, SSAS, SSRS, Power BI, HTML, Javascript, CSS, and jQuery. 2. Online Petty Cash - filing and routing of petty cash transactions. Developed using Sharepoint 2013, InfoPath, SQL Server, SSIS, Power BI