Sql Server Data Warehouse

Masud M. Hasan

**** ***** **** *** ***** River OH 44116

Email: *********@*****.***

Home: 216-***-****, Cell: 216-***-****

Summary of Qualifications

Masud Hasan has:

Over 20 years of professional experience in data warehousing, database structure, ETL, and reporting

Extensive experience in data warehousing in a wide range of industries like public sector, law, and automotive

Thorough understanding of advanced SQL queries, stored procedures, security, and database backup

Outstanding leadership knowledge of team management, project management, and several ERP systems

Experience collaborating with managing vendors, consultants, and in-house IT team members

Excellent interpersonal communication skills and detail-oriented

Capable of working both independently and as part of a team

Technical Summary

Database: SQL Server (2000 to 2019) DTS, SSIS, ADO.NET, ETL, MS Access

Web development Tools: ASP, ASP.Net (2.0, 3.0, 3.5, 4.0), VBScript,

HTML, MS Expression Web 2, FrontPage, Web Forms

Languages: C#.Net, VBScript, T-SQL

Reporting System: Crystal Report, SSRS

Software Tools: MS Visual Studio .NET (2003, 2005, 2008, 2010, 2015), SQL Server BI Development Studio, Adobe Photoshop, Microsoft Windows, Microsoft Office

ERP Systems: Tessitura - nonprofit software, Elite - real estate software, Yardi - public housing software

Education & Training Summary

Cleveland State University, 2000, Cleveland, OH

Master of Business Administration, Major: Computer Information Systems

Georgian Technical University Tbilisi, Georgia

Bachelor of Science in Electrical Engineering

Professional Summary

Stanley Black & Decker (SBD), OH 02/24 – 04/25

Business Systems Software Engineer

Managed and maintained SBD SQL Server data warehouse

Maintained data flow between several ERP systems like JD Edwards and Report Now

Created and maintained data warehouse backup, recovery, and SQL jobs

Set up security and provided user access to SQL Server instances and objects

Created reports to support supply chains like Boeing and Airbus

Produce aerospace, defense, and space systems reports for customers in over 150 countries.

MS SQL Server, T-SQL, SQL-Job, SSRS, JD Edward tools used for these applications

Cuyahoga County Housing Authority, OH 04/18 – 02/2024

SQL Server Database Administrator

Managed and maintained CMHA SQL Server data warehouse as an MS SQL DBA

Maintained housing authority ERP software Elite for day-to-day business

Created and maintained data warehouse backup, recovery, and security system

Created and modified tables, stored procedures, and views in SQL Server data warehouse

Managed and updated with over 300 reports within the Elite ERP software system

MS SQL Server, T-SQL, SQL-Job, SQL Backup, SSRS, Crystal Report tools used for these applications

Cleveland Museum of Natural History, OH 02/16 – 02/2018

Assistant to IT Director / SQL Server Database Administrator

Managed the day-to-day operations of the IT department as a backup for the Museum’s IT Director

Oversaw the entire IT department, including infrastructure and applications for the museum

Maintained Tessitura ERP system used for ticketing, admissions, fundraising, and memberships

Controlled and monitored user access to the database, backed up and recovered the database

Created, scheduled, and maintained SQL Server Agent jobs to produce Tessitura reports

Created and modified internal website with C# and SSRS reports

The Garland Company, OH 07/15 – 01/2016

SQL Server Database Administrator

Developed and maintained Garland’s data warehouse as a full SQL DBA role

Created, modified, and maintained ETL packages using SSIS

Scheduled packages through SQL Agent for day-to-day data extraction and loading from Excel files

Maintained nightly SQL jobs, backup, and restored the database

ASP.NET, T-SQL, SSRS, and SSIS tools used for these applications

MaritzCX, OH 01/15 – 05/2015

General Motors - IT Consultant

Developed and maintained General Motors’ website for over 5000 dealers in the USA and Canada

Maintained survey data for month-end performance and batch processing

Identify the data requirement to be extracted from the data warehouse for ad hoc reports

ASP.NET, VBScript, T-SQL, SSRS, SSIS, and ETL tools used for these applications

Express Seed Company, OH 02/14 – 11/2014

Programmer Analyst

Developed and maintained company dashboards for accounting and financial reports

Converted several CMS ASP web applications to ASP.NET web applications

Identify the data requirement to be extracted from the data warehouse in a PeopleSoft environment

ASP.Net 2010, Web Forms, C#, VBScript, T-SQL tools used for these applications

Philips Healthcare, OH 02/13 – 05/2013

IT Consultant

Designed and developed a web-based application for the Philips CAT Scan system

More than 20 engineers and 50 technicians can log, store, and retrieve data

A new application was designed to save about $30,000.00 per year for the department

ASP.NET 2010, C#, and Web Forms were used to create the frontend for the application

Weltman, Weinberg & Reis Co., LPA, OH 07/06 – 01/2013

Programmer Analyst / Web Administrator

Designed, developed, and managed internal and external websites using C#, ASP.NET 2003,2005

Provided data analysis, research, and reporting to internal customers and attorneys

Created and modified database utilizing SQL 2005, 2008, T-SQL, SSRS

Solved more than 400 work orders related to the company intranet and database every year

Ford Motor Company, OH 05/00 – 10/2005

Programmer Analyst

Designed, developed, and maintained numerous data-driven web applications

Create Web Applications with Visual Basic and C#

SQL and T-SQL were used for queries and data manipulation

ASP, ASP.Net, HTML, DHTML, SQL Server used to develop web applications

Training:

ASP.NET and MS SQL Server, Microsoft, California

MS SQL Server, Ford Motor Company, Ohio

ASP, ASP.Net, C#, Cleveland State University continuing education, Ohio

Photoshop, MS SQL Server, Cleveland State University, Ohio

Contact this candidate