Profiles
|
Coding website profiles showcase a developer's skills, experience, and contributions through interactive portfolios, projects, and community engagement |
Power BI
|
Microsoft Power BI projects include dynamic dashboards, performance reports and analytics to identify trends and drive business strategy. |
Report Server
|
Microsoft SQL Server Reporting Services (SSRS) projects include graphical and paginated reports. |
Visual Studio
|
Various projects in C#, VB.NET, JavaScript and Markdown including Active Directory attribute export, Documentum batch script, SharePoint web parts, Azure DevOps Services dashboards |
Office
|
Microsoft Office projects in .NET and VBA (Access, Excel, Outlook, Visio, Word) |
AutoCAD
|
AutoCAD automation projects in .NET and VBA |
Stack Exchange Profile
Stack Exchange is a network of community-driven Q&A websites where people can ask and answer questions on a wide range of topics, from programming and mathematics to cooking and photography. Each site in the network focuses on a specific subject area, with communities of experts and enthusiasts providing accurate, peer-reviewed answers. The platform emphasizes high-quality, reliable information, with a voting system that allows the best answers to rise to the top. Stack Exchange fosters a collaborative environment where users can learn, share knowledge, and connect with others who have similar interests or expertise. * Stack Overflow Profile * Database Administrators Profile * Code Review Profile |
Microsoft Learn Profile
Microsoft Learn is an online learning platform that offers a wide range of courses, tutorials, and certifications to help individuals develop technical skills and expertise across Microsoft technologies. It provides interactive, self-paced learning experiences for beginners to advanced users, covering topics like Azure, Microsoft 365, Power BI, Dynamics 365, and more. With hands-on labs, step-by-step guides, and assessments, Microsoft Learn helps users gain practical knowledge, earn badges and certifications, and advance their careers by mastering the latest tools and technologies in the Microsoft ecosystem. |
Microsoft Fabric Community
The Microsoft Fabric Community is a collaborative platform designed for data professionals, developers, and enthusiasts to engage, learn, and share knowledge about Microsoft Fabric, an integrated data and analytics platform. It provides a space for users to discuss best practices, exchange ideas, seek guidance, and stay updated on the latest features and advancements. Members can participate in forums, attend webinars, access learning resources, and contribute to discussions to enhance their understanding of data integration, transformation, analytics, and governance within the Microsoft ecosystem. |
User Metrics
The User Metrics Dashboard is a comprehensive Power BI solution designed to provide stakeholders with a clear and concise overview of key performance metrics across various timeframes. This user-friendly dashboard offers a visually appealing interface that facilitates easy interpretation of data trends and patterns, empowering decision-makers to make informed strategic decisions. These metrics are strategically broken down by different timeframes, enabling users to analyze trends over several different intervals. |
Data Quality
The Data Quality Trends Dashboard in Power BI provides a comprehensive overview of key metrics including completeness, accuracy, timeliness, and consistency over time, allowing organizations to monitor and analyze the quality of their data assets effectively. |
Attendance Dashboard
The Attendance Dashboard is a comprehensive visualization tool designed to provide insights into employee office attendance patterns over time. Utilizing Power BI's dynamic features, this dashboard offers a visually appealing representation of attendance data, allowing managers and HR professionals to track attendance trends, identify areas of concern, and make informed decisions to optimize workforce management. |
Marketing Metrics
The Marketing Performance Insights Dashboard is a comprehensive visualization tool designed to provide marketing professionals with actionable insights, client engagement, and overall performance. Developed using Power BI, this dashboard offers a user-friendly interface that consolidates key metrics from various marketing channels, enabling stakeholders to make data-driven decisions and optimize marketing strategies. Additionally, the dashboard is optimized for mobile viewing, ensuring that marketing professionals can access key insights and metrics on-the-go, facilitating quick decision-making and responsiveness to real-time data trends. |
Dynamic Trend Analysis
The Trend Analysis Page within the Marketing Performance Insights Dashboard provides a deeper examination of historical data trends across key performance metrics. Through intuitive visualizations such as line graphs, heatmaps, and trendlines, marketers can identify patterns, seasonal fluctuations, and long-term growth trajectories. This page enables users to uncover insights into which marketing strategies have consistently driven success over time and identify emerging trends that may inform future campaign planning and optimization efforts. Additionally, interactive features allow users to drill down into specific time periods or segments, providing granular insights for informed decision-making and strategy refinement. |
Service Ticket Dashboard
The ServiceNow Ticket Analytics Dashboard is a comprehensive visualization tool designed to provide deep insights into the performance, trends, and key metrics related to tickets generated within the ServiceNow platform. Leveraging the power of Power BI, this dashboard offers a user-friendly interface that allows stakeholders, IT managers, and support teams to monitor, analyze, and optimize ticket management processes effectively. |
Weekly Calendar
This report uses a nested tablix inside of a matrix to show a calendar view. The document map is used to navigate the report or exported spreadsheet. The dynamic grouping is used to produce a summary page and a calendar per page/grouping. I use bookmarks to navigate from the summary page to individual calendars. Assigning colours to groups is done by using a DENSE_RANK to produce a row number per group per calendar items. That row number is matched to a row number of a colour view. Embedded code written in Visual Basic is used to assign alternating row colours. |
SharePoint Report Viewer Heat Map Calendar
The SharePoint team site was setup with a report viewer web part. The report uses a nested tablix inside of a matrix to show a calendar view. The heat map is implemented using a function with a report variable for the base color to produce a gradients of the color. Each day on the calendar is a hyperlink to a detailed Reporting Services report. |
S Curve Cumulative Progress
This report is used for querying the cumulative hours or sales quantities plotted against time. It is dynamicly grouped by either quarter, month or weekending. |
Data Dictionary
This report is used for querying the data dictionary of a SQL Server database. |
Scheduled Jobs Gantt Chart
This report is used for querying the scheduled jobs for a SQL Server database. |
Activity Monitor
This report queries the activity monitor from SQL Server. |
Report Listing
This report is used for querying the deployed SSRS reports, their subscriptions and their execution logs. |
Report Subscriptions
This report is used for querying the deployed SSRS subscriptions. |
Report Execution Log
This report is used for querying the report server exection log table. |
Azure DevOps Services
I've set up Azure DevOps Services to efficiently manage the entire software development lifecycle, providing a centralized platform for version control, collaboration, and continuous integration and delivery. By creating dedicated repositories for Power BI assets, reports, integrations, and database schemas, the organization maintains a structured approach to managing various development components. A hierarchical permissions structure is in place to ensure secure access and control, enabling team members to collaborate effectively while safeguarding sensitive data. This setup streamlines development workflows, enhances code quality, and fosters a culture of agile development within the organization. |
Azure DevOps Services Dashboard (Report Project)
Dashboard for SSRS report solution project in Azure DevOps Services. |
Azure DevOps Services Dashboard (All Projects)
Dashboard for all projects in Azure DevOps Services. |
Active Directory Search
The application, developed in C# using Windows Forms, enables users to search and query Active Directory for specific information such as user accounts, groups, and organizational units. With an intuitive and easy-to-use interface, the application allows users to specify search criteria, filter results, and view detailed information about Active Directory objects. Once the desired data is retrieved, users can effortlessly save the search results to a .csv file for further analysis, reporting, or archival purposes. This tool simplifies Active Directory searches and enhances administrative efficiency by providing a straightforward way to access and export directory information. |
Documentum Script Administrator
The application, written in C# using Windows Presentation Foundation (WPF), provides a user-friendly interface for executing .dql files as single commands against the idql32 or idql64 utilities for EMC Documentum docbases. It streamlines the process of running Documentum Query Language (DQL) scripts, allowing users to easily select and execute their .dql files without needing to interact with the command line directly. The application supports both 32-bit and 64-bit versions of the idql utility, ensuring compatibility with various system configurations and enhancing productivity by simplifying and automating query execution for Documentum environments. |
SharePoint Webpart Timezones & Temperature
Written in HTML/Javascript, it displays timezones with hyperlinks to temperature. The time updates every second. |
Excel Script Help (VSTO)
This Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the ribbon allows a quick way of preparing a bulk data load. Otherwise, the requests can be both time-consuming and error prone. Written in C#, VB.NET and VBA. |
Excel Server Help (VSTO)
This Add-In allows the user to ping a list of servers and creates a file for Microsoft Remote Desktop Manager from an Excel table. This is used for quickly determining which servers are offline in a list. Written in C#, VB.NET and VBA. |
Excel Markup (VSTO)
This Add-In is used for marking up Excel files with revisions. There are two common methods of indicating where a revision has changed a drawing that contains a system diagram. The first is the cloud method, were each change is enclosed by a cloud shape. The second method involves placing a triangle with the revision number next to each effected portion of the drawing. The cloud method indicates changes from the most recent revision only, whereas the second method indicates all revisions to the drawing because all of the previous revision circles remain on the drawing. Written in C#, VB.NET and VBA. |
Excel Favorites (VSTO)
This Add-In gives the user a custom favorites ribbon. Key distinctive attributes include dedicated buttons for changing the visibility/sort order of sheets, copying visible cells, Excel's camera feature, Snipping Tool, Problem Steps Recorder (PSR) and Windows Calculator. Written in C#, VB.NET and VBA. |
Excel Timesheet (VBA)
This Add-In is used to produce a timesheet file with functionality to import your Google Timeline. The standard timesheet has options for start and end dates, day of week and default start, end and break times. The Google timeline options are start and end dates, UTC selection, daylight savings time parameters and title filter for timeline entries. There is also a right click shortcut to open your Google timeline to the date of the row that is currently selected. |
Excel Cell Extract Ribbon (VBA)
This project was done as an Excel VBA Addin with a ribbon to import enrollment data from multiple files. The median import time is 2 seconds per file. I used a column mapping to the cell references in multiple sheets to generate the import specification. |
Access VBA Examples
Written in VBA, here are examples of reports and code for MS Access. |
Visio Shape Export (VSTO)
Written in C#, VB.NET and VBA, it allows the user to export the shape attributes to a .csv file. |
Outlook Calendar Add-In (VSTO)
Written in C#, VB.NET and VBA, it allows the user to import calendars. |
Attribute Extract Tool
The AutoCAD Automation Extracting Tool allows the user to loop through each entity in a piping and instrumentation drawing to then extract entities and attribute values. Depending on the parameter options entities are extracted within clouding for new project work or no clouding as with as building at project completion. The application uses stored layer names to determine the cloud types. A standard list of entities and attributes are used to query the extracted data for reporting in SSRS. There is an option in the settings to use either a SQL Server localDB or a server database. SQL Server localDB is used for the portable version. The original project was migrated from VBA/dvb project file. This application is in Visual Studio 2015 in VB .NET/WPF using the AutoCAD 2016 object model. The procedures are multi-threaded using background workers. The application uses late binding for a current session of AutoCAD and early binding for a new session. ClickOnce deployment is used for the install. The API documentation is done with Microsoft Sandcastle. The application diagrams are done with Microsoft Visio. The “As Is” documentation is done in a markdown file in Azure DevOps Services. |
Batch Plotting Tool
The AutoCAD Automation Plotting Tool allows the user to batch plot AutoCAD files with options to convert drawings to pdf files. Plot styles are applied to the drawings during the conversion. Logging is implemented with Log4Net to track errors during the conversion of 200,000 files. There was less than a 0.5% failure in the process. The processing time took 3 virtual machines 5 days to complete. The median processing time was 10 seconds per file. It can also send the files to a plotter with a selected page size in the active space either model or paper. There is also an option to add or remove a layered watermark using a .dwt file. It was written in VB.NET, Windows Presentation Foundation (WPF) in Visual Studio 2017. |
Title Block Tool
Title Block Tool extracts entity block attributes from multiple files by using standardized naming conventions for the title block names. The title block and attribute names are stored in a template table and referenced during the extraction process. A custom edit attributes form is used to select values from dropdown lists to improve data quality. The application also allows the users to bulk update the title blocks from the database back to the original files. The modules and classes are exported with a procedure for source control check-in. The install was done in Wise Installer. It was developed in a compiled VBA/dvb file with the database in Microsoft Access & Oracle. Microsoft Access is used for the portable version. The custom AutoCAD menu is in DIESEL. |