Power Bi Software Development

Abdul Hameed Dhawood

Mobile No – 009*********** Email: - **********@*****.***

SUMMARY

Over 15 years of working experience in the field of software development using Microsoft Dot Net, SharePoint and Power BI solutions. Experience in all the phases of System Development Life Cycle (SDLC) such as analyzing, designing, coding, testing, debugging, deployment and documentation also worked in familiar companies such as STC, Mobily, Riyadh Bank, Royal Saudi Air Force and other government sectors.

EMPLOYMENT HISTORY

Sep 2010 to at present

SharePoint Team Lead / SharePoint Architect / SharePoint Administrator & Developer / Power Platform Consultant, KSA

Responsibilities

•Designing and Developing Microsoft SharePoint 2019 / 2016 / 2013 / 2010 Applications.

•Experience in Installing, Configuring, Administrating, Maintaining and Troubleshooting in SharePoint 2019 / 2016/2013/2010.

•Experience in Office 365 and SharePoint Online.

•Experience in SharePoint Framework, Power Apps, Power Flow and Power BI.

•Experience in translating business needs into technical specifications, building and deploying Power BI solutions.

•Experience in Developing Power BI Dashboards and Reports.

•Experience in performing DAX queries and functions in Power BI.

•Experience in make technical changes to existing BI systems in order to enhance their functioning.

•Experience in installing and managing Microsoft Project Server in SharePoint 2019

•Proficient on SharePoint Site Branding by modifying and creating Master Pages, Page Layouts, CSS, Themes, CAML, HTML, XML, jQuery and Ribbon Interface.

•Experience in Developing and building Visual Web Parts using Visual Studio 2013 and 2015/2017.

•Experience in developing workflows using SharePoint designer, visual studio and out of the box workflows.

•Experience in Developing InfoPath forms with electronic approvals.

•Experience in using LINQ to SQL and ADO.NET to develop Data Access Layer.

•Experience in designing and implementing various SharePoint Web Parts, Event Receivers, Web Part Pages, Content Types and various Document Libraries and Lists.

•Experience using Taxonomy feature in SP 2016/2013/2010 for Enterprise Metadata Management.

•Experience in developing Client / Server Applications using C#, ASP.NET & ASP.NET MVC.

•Supports Intranet sites built on SharePoint 2010/2013/2016

•SharePoint Administration like Backups, Restore, and Importing User profiles etc.

•Experience in migration from 2010 to 2019 as well as in-place upgrades procedures.

•Managing and checking the overall server health and functionality.

•Monitoring SharePoint disk space usage through the built-in SharePoint reports for each site collection.

•Managing SharePoint permissions.

•Analyzing and reporting upon SharePoint usage and activity.

•Regular review of the events and messages reported in Event Viewer and Performance Monitor.

•Setting up alerts and enforcing policies.

•Regularly auditing SharePoint environment.

•Patching & Upgrades.

•Service application management specially Search, User Profile Service application.

•Manages site quotas and file size limits.

•Manages content databases and creating new ones as required.

•Manages security for sites and sub-sites.

•Manages the site layout structure and content.

•Provides SharePoint support to end users.

•Experience in using Power Shell commends and Central Administration Panel.

•Experience in using PNP Power Shell and CSOM objects.

•Documents SharePoint configuration and architecture.

•Experience in Security, Office Integration Advanced Document Management, Web Content Management, Enterprise Content Management and Shared Services.

•Experience in developing Business Data Catalog, Enterprise Content management.

•Experience in SQL Server 2008 R2 / 2012 / 2014 SP2 /2016 Database Installation and Configuration.

Details of projects done recently, listed below.

Project Title

Intranet portal with HR E-Form system

Client

Aramco Rowan Office

Duration

August 1, 2019 To Dec 31, 2022

Team Size

1

Software

SharePoint Online, SharePoint Designer 2013, JQuery, Power Flow, Power Apps, SharePoint Framework and Power BI.

Responsibility

Design, Development and Testing

Project Description: The purpose of system is to create an intranet portal for company.

The portal is a private and secure network, where employees can find company resources, services and tools to stay productive. It is a central location for departments to provide updates, store information and collaborate with others.

The portal has the powerful document management system with multi-level approval processing, for every approval document. DMS makes it easy for team members to distribute, store, manage, search, and locate knowledge assets.

It can provide all the information employees need daily at their fingertips so they don’t have to go searching for it. This will save time, keep them informed, and enable them complete tasks better and faster.

Other functionalities built into the intranet site include news and events, policies and procedures, learning and teaching, and employee center tabs, as well as a services and support page.

One of the good feature of system was SharePoint Online Data can be transferred to SharePoint On-Premises servers using 3rd party tool.

HR E-Form system

HR E-Form system is an automated approval processing system, allowing you to track, improve and automate HR business processes. HR E-Form system, fulfill unique needs of the organization, while offering an array of options to address multi-tiered demands of HR processes.

HR workflows are the set of predictable and repetitive tasks within any HR process, which means that before an item begins the workflow, and can know exactly what path it should take. HR process workflows are set up to handle an unlimited number of items going through them. Each HR workflow has its own approval rules, fulfillments tasks, and process alerts.

The system has various workflow forms like Employee Transfer, Employee Promotion / Demotion, Crew Change, Vacation request, Travel request, Training request, Promotion & Demotion with salary changes, Termination, personal changes and government letter request etc.

HR E-Form system can speed up HR processes and improve their efficiency without compromising on security.

Project

SharePoint Migration with New Functionalities

Client

Abdul Latif Jameel, KSA

Duration

Jan 1, 2018 To December 30, 2018

Team size

1

Responsibility

Design, Development and Testing

Project Description:

The purpose of project is to upgrade the SharePoint version from 2010 to 2016 due to, to take advantage of new features and functionalities of SharePoint 2016.

The previous portal has high volume of data, thus, first cleaned up the all the unused data, and did the pre-check validations and migrated to latest version SQL server, using Database Upgrade approach method.

Designed the topology for SharePoint 2016 and configured the WFE, Application, database server’s roles and user’s security settings. All the custom functionalities and workflows are re-complied with latest framework and re-published. Then applied new look and feel to portal with new master page.

New custom functionalities are developed as per requirements.

Project Title

Internal Portal

Client

Modern Field Establishment, KSA

Duration

Mar 1, 2016 To October 30, 2017

Team Size

1

Software

SharePoint Server 2016, SharePoint Designer, SQL Server 2014, Visual Studio 2015 and Windows Server 2012 R2.

Responsibility

Design, Development and Testing

Project Description: Intranet portal is a site which will be published trusted e-content (text, images, multimedia, etc.). Intranet portal delivers the e-document management

Services to the staff members and all published document and content are on the internal.

The content, policies, documents and other related information will be published on intranet portal after verifying and passing though the approved approval process.

The basic function of the portal is the website to configure and define sections to giving awareness to the staff members. Some of informative pages under the internal gate will be accessible without any registrations or user authentications.

The portal has the following functionalities

•Manage services like newsletters, publications etc.

•Manage user’s publications, grand powers and other central administrations sections.

•Reporting & BI (Initial)

•Detailed Department information

•Contact book

•My Site

•Electronic voting system

•Notification system through SMS (Need SMS Service) & Email Alarm

•Latest announcements

•Industry news feeds

•Social networking items

•Message from management

•Document Management System

•Knowledge based system

•Policies and procedures

•Company FAQ

•suggestion box

•Polls and surveys

•Feedback procedure to update the surveys

•Employee collaboration

Project

Intranet Portal

Client

King Fahd Military University

Duration

December 1, 2015 To December 30, 2016

Team size

1

Environment

SharePoint Server 2013, SharePoint Designer, MS Office, Workflow, InfoPath forms, .NET 4.5, C#, SQL Server 2012, Visual Studio 2013 and Windows Server 2012.

Responsibility

Design, Development and Testing

Project Description: The purpose of Intranet system is to implement SharePoint and Create an Information System for the all Departments. The required systems to be automate the processes that are being done manually by all the Departments.

Portal involved with document management system, navigation and search capabilities enhancement. Administrators have easy access to version history, source documents, workflow automation, and reminders when documents are due for review. They needed a better way to enable collaboration, document management, and enterprise search among thousands of documents.

Responsibilities

•Created Sites, Document Libraries, Lists and List Views to collaborate Users.

•Designed and Developed Master Pages and Custom Page Layouts for Branding and Chroming of portal by SP Designer.

•Worked on List Template, Site Template and Site Definition to customize the Portal.

•Created Site Columns and Content Types to resume schema of column in different lists of web application.

•Created InfoPath forms and published it in to Share Point Forms Library

•Used SPMetal to parse the lists and import them into VS and used LINQ to query data from SharePoint List.

•Created Web Parts using Object Model and deployed them in to Web Part gallery.

•Created Taxonomy using Managed Metadata Services and used in different site collection.

•Branding and Customizing sites by modifying Master Pages

•Created Event Handler by using SharePoint Event Receivers

•Implemented Data View Web part to import data from database and connectable web parts to exchange data between Web parts

•Worked on SharePoint Administration like Backup/Restore and imported user profiles.

Project Title

School Management System

Duration

June 1, 2010 To September 30, 2013

Client

British Embassy school, KSA

Team Size

1

Software

SharePoint 2010, ASP.Net, C#, SQL SERVER 2012, HTML, DHTML, XML and XSL.

Responsibility

Design, Development and Testing

Project Description: Student management system (SMS) is software to manage all day to day operations for a school effectively.

The aim of this software is to implement a Student Management system suitable for a School and University, providing flexibility to adapt to new and changing requirements. This Student management system is an automated version of manual Student Management System and using this software means securing the activities of the Student Management. The vision is to provide a progressive and expandable information service to staff, student and applicants.

The School Management System has the following Modules:

•Student Registration System

•Student’s Progress Reporting System.

•Fees collection and management system

•Employees Management system

•Uniform Management System

Company Name

Zuhair Fayez and Partnership

Duration

July 1, 2006 To Oct 30, 2009

Position

Senior Web Developer

Responsibilities

•Web Development using ASP.Net, C#, VB.Net, java script, HTML, DHTML, XML and XSL, SQL Server 2005 and 2008.

•Client/Server application development.

•Identify, analyses and document customer/project requirements.

•Lead and provide inputs for the development of system requirement specifications.

•Assist in the development of new automated approaches to current systems and procedures.

•Assist and provide inputs for the development of the project design specifications and development plans.

•Provide inputs for the preparation of technical documentation for applications.

•Assist and provide inputs to developers in all system development activities of the R&D group to ensure compliance with the identified project requirements.

•Interface with client for coordinated and ensuring that client requirements are met, as well as provide operational support and assist client in utilizing the developed automated systems and applications.

Project Details below

Project Name - Human Resources Management System

Project Description

The Automated Human Resources System is a software package designed and developed to the various tasks commonly performed by the HR Department of any Saudi company

It is a comprehensive people management solution that is composed of several applications that were developed to efficiently manage a company’s workforce by providing easy access to employee related information. It is composed of several applications designed to manage employee documents and other employee related information.

The application provides automated workflow, for example, some of the applications provide self-service employee access to data that they require (e.g. personal data) and department manager access to managerial functions (e.g. online approval of requests). It also supports imaging, which allows employees to attach images or softcopy of files when needed.

The Human Resources application has the following features:

•Convenient user friendly interface

•Numerous integrated modules for different office applications

•Fully bilingual

•Multi-user and true client / server system

•Powerful security system with flexible definition of each user

•Provides quick and accurate reports

•Automatic date conversion (Gregorian and Hijri)

•Automatic e-mail notification

The applications that comprise the Automated Human Resources System are as follows:

1. Employee List (This module will cover complete Employees Surveys)

2. Time and Attendance

3. Personal Action (employee’s benefits schemes)

4. Policies & Procedures

5. Headed Letters

6. Reports

7. Training

8. Travel

9. Vacation

10. Appraisal

11. Jawazat

12. Career Development

13. Employee Start & End

Project Title

Integrated Financial Application

Client

Matbouli Group

Team size

3

Software for web

ASP.Net, C#, SQL SERVER 2005,HTML, DHTML, XML, XSL.

Responsibility

Design and Development

My Role: Coordinate with the Team leader and QA team and I developed the complete web based financial report using ASP dot net and Crystal as a report engine. This financial report will run on both environment windows as well as web based.

Description: This project is a customized integrated financial application in windows as well as web enabled. All modules are designed to be plugging INS type. Whenever a module is not required can be taken off without affecting the other modules. The system includes module like purchase, cash sales, whole sale, project sale, stock control, payables, receivables, general ledger, maintenance, cash control, asset control, payroll etc.

Project Title

Facilities Information System

Client

Saudi Air Force

Team size

45

Software

C, Visual C++ 5.0/6.0, Visual Basic 6.0 Oracle 8i, Crystal 6.0 / 7.0.

Responsibility

Testing and Development

Projection Description

The FIS is one of the powerful systems in Geographical information system technology, which is designed to provide instant access to graphical and non -graphical information, by means of convenient, easy to use GUI.

In any geographical information system. Facilities management system project data is the largest single investment comprising over half of the total project cost. the single most powerful feature of FIS is its ability to integrate a variety of underling software modules into one shell through its versatile query reporting function .A comprehensive query composition panel allows queries allow to be composed and saved. in this way all FIS functionality is accessible to the user through the use of these saved queries that may be executed simply by pointing and clicking the mouse.

My Role in this project

- Design and development of “reports module” application in VB 6.0

As front and oracle 7/8i as back end using crystal reports 7.0

As reporting engine.

- Design and development of user interface of most of the modules

of FIS using visual C++ 5.0/6.0 as front end.

- Design and customized development of third party application

Programming interface (DLL’s) using ‘C’ the power full integration

Of MAXIMO (third party MMS application) with FIS. This is one of

The main module in FIS.

- integrated the oracle forms (developer 2000)in MAXIMO

(Mms application) using ‘C’

- Design and development of database tool using ‘c’ as front end oracle8 as back end

- Design and development of clone toll using ‘c’ as front and oracle 8.x as back end .it is a database management tool. which verifies data between the spatial and attribute

Tool Title

Bill of Quantity

Client

Saudi Air Force

Team size

2

Software

Visual c++ 5.0 as front end. oracle 8.x database as back end crystal6.0 /7.0 reporting tool

Responsibility

Design and development

Tool Description: the following tool collects all the information from MMS side such as all the equipment’s quantity (electrical equipment’s. fire equipment’s, plumping and etc. …) and displays the information in reports.

WEB Design and Development

Project Title

Credit Bureau System

Client

Jeddah chamber of commerce

Team size

2

Software

ASP.Net, C#, HTML, DHTML, XML, XSL. The back end Database is SQL server.

Responsibility

Design and development

Project description: this system is designed in a way to facilitate the companies, organizations and individual consumers can conduct business

Transaction with each other over the internet by using the system of credit established by the Credit bureau. In the order to realize the full benefits of the credit bureau web site, companies, organization and individual consumers have to submit their important in formation to become registered member of the credit bureau web site .upon review and approved of information provided by members, the systems allows registered companies and organization to present and sell their products to registered consumers who visit the web site.

This system has adequate feature for managing user, transactions, Processes and data to guarantee to security and privacy of the sensitive information transmitted between consumer, organization and the JCCI credit bureau, the system has necessary provisions for security and Reliability.

Project Title

Savola (internet based application)

Client

Savola group of companies.

Team size

4

Software

ASP.Net, C#, SQL SERVER 2005,HTML, DHTML, XML, XSL.

Responsibility

Design and development

Project Description: This project is designed purely for HR Department of Savola group of companies and consists of different modules like

Training division

Library

Human Resources information

News bulletins

At Tamayuz

I was involved in Training. Library and at Tamayuz modules where training modules is designed to help employees to submit their there

Training request to HR dept. and assist HR dept. to keep track the help

Growth rate of employees under training. On completion of training the

Employees training results documents or certificate are scanned and attached with the employees training information.

At Tamayuz module is an internet based application where the employee can apply for their promotion. This module consist two bands they are MP and OS. Each band has zone with its relevant door. It has three different modules they are ADMINSTRATOR, LINE MANAGER and EMPLOYEE.

ADMINSTRATOR - All master data entry forms.

LINE MANAGER - Only for manager or administrator, this module

Consist all the information related to employee whether the employee is eligible to promotion.

EMPLOYEE - Module for employees, they fill the forms for promotions.

Project Title

Events (Intranet based application)

Client

Islamic Development Bank (Jeddah)

Team Size

4

Software

ASP.Net, C#, SQL SERVER 2005,HTML, DHTML, XML, XSL.

Responsibility

Design and Development

Project Description: Islamic Development bank is worldwide organization having their branches over many countries. Round the year this organization conduct different events of different occasions. For every event there are number of programs and for each program number of attendances (Delegates) from various countries and organization.

This system helps to simplify the task of planning events and their programs, invitation, evaluating expenses on each delegate. Sorting of the delegates status of their treatment like providing hotel, vehicle etc.

Recent training Completed ( ERP )

Microsoft Dynamic AX 2012 R3 Development and Administration

SKILLS

•SharePoint Technologies:

•SharePoint Server 2019 / 2016/2013/2010, SharePoint Online, SharePoint Framework, Power Apps, Power Flow, SharePoint Designer, InfoPath forms, Workflows.

•Business Intelligence Tools

Power BI Report Server, Power BI Service, DAX, MDX, SSIS, SSAS and SSRS.

•.NET Technologies

•DOT NET Framework (2.0/3.0/3.5, 4.0, 4.5), ASP.NET MVC Core, ASP.NET, ASP.NET MVC, LINQ, Entity Framework.

•Web Based Technologies

•HTML5, XHTML, Web Services, SOAP, WCF, REST & OData, Angular JS, JQUERY, Node JS, React JS, JSON, AJAX, CSS, XML, XSL, XSLT, X-Path, CAML, Silver light.

•Web Servers

•MS Internet Information Server 7.0/8.0

•RDBMS

•SQL Server 2005/2008/2012/2014.

•Languages

•C, C++, C#, XML, HTML.

•Scripting Languages

•JavaScript, VBScript

•Business Intelligence

•SSRS, SSIS

•Testing Tools

•MS-TEST 3.0, Visual Test 4.0, Rational Visual Test 6.5

EDUCATIONAL QUALIFICATIONS

•Master of Computer Applications

Tamil Nadu, India

•Bachelor of Computer Applications

Tamil Nadu, India

•Diploma in Computer Technology

Tamil Nadu, India

Contact this candidate