Melchor Baay

• Extensive experience as Microsoft SQL Server developer implementing SSIS, SSAS, and SSRS using Microsoft Business Intelligence development studio, SQL Server Data Tools and DAX Studio.
• Design and develop Data Warehouse using Code-first approach in .net core.
• Developed SSIS packages to extract, transform and load (ETL) data into the Data warehouse from SQL Server.
• Complex SQL scripting.
• Extensive hands-on experience in several data flow transformations included derived-column, script, slowly changing dimension, look up and data conversion.
• Strong knowledge in dimensional star schema and snowflakes schema.
• Knowledge in MS Power BI and QlikSense for dashboard presentation from various sources such as SQL Server, SQL Tabular Analysis service.

• Extensive experience as Microsoft SQL Server developer implementing SSIS, SSAS, and SSRS using Microsoft Business Intelligence development studio, SQL Server Data Tools and DAX Studio.
• Design and develop Data Warehouse using Code-first approach in .net core.
• Developed SSIS packages to extract, transform and load (ETL) data into the Data warehouse from SQL Server.
• Complex SQL scripting.
• Extensive hands-on experience in several data flow transformations included derived-column, script, slowly changing dimension, look up and data conversion.
• Strong knowledge in dimensional star schema and snowflakes schema.
• Knowledge in MS Power BI and QlikSense for dashboard presentation from various sources such as SQL Server, SQL Tabular Analysis service.

Develop custom ASP.NET MVC Web Application, windows service and WPF/windows form application.
Workflow design and implementation using OpenText/Livelink and .NET Captaris Workflow System.
SharePoint Administration, branding and dashboard development using excel service
Administration of GPS System, customize existing corporate application (e.g. MENAPAY/MENAHR) and Finger Print Time and Attendance System and RFID Card Remote Attendance Application, web and windows services.

Develop Application Software using Visual C#.NET and VB.NET in .NET 3.5 Framework; Design User Interface (UI) of an application software using WPF/Infragistics; Create reports using Crystal Report and Microsoft SQL Reporting Service

Managing the internal and external operations of the school; Attend seminars and conferences relative to my function as