|
Programming Languages
|
C#, VB.NET, T-SQL, HTML, CSS, Java Script, VB, VBA, C/C++ and STL, MFC, Java.
|
|
Development Tools
|
Visual Studio (including SQL Server Data Tools), Blend, Expression Studio,
JetBrains (ReSharper, dotTrace, dotMemory), SQL Server Management Studio, TFS, MS
Office, Reporting Services Designer, Crystal Reports.
|
|
Development Experience
|
WEB applications (ASP.NET, MVC, Razor), Desktop applications (WPF, MVVM,
Window Forms) , Windows Services, WCF, WEB Services, SQL Server, Entity
Framework, Database applications, TCP/IP sockets (client/server), Office
automation, Windows API, multi-threading, printing, graphics, generics, design
patterns, hardware control (RS-232/RS-422).
|
|
Server
|
Microsoft Azure (SQL server, IIS, Service Bus, Storage Tables), Windows Server, IIS, SQL Server (Integration Services, Analysis Services,
Reporting Services), Active Directory (and Exchange), Message Queue, Oracle.
|
|
Applications
|
Office (including Access, Project and Visio). Graphics, video and audio editing
software.
|
|
Skills
|
C#, WPF, MVVM, Windows Forms, ASP.NET, MVC, Razor, Entity Framework, T-SQL,
HTML, CSS.
|
|
Technology
|
.NET 4.5, Visual Studio 2013, Blend 2013, Expression Studio 4, JetBrains
(ReSharper, dotTrace, dotMemory), SQL Server Management Studio.
|
|
Overview
|
In 2013 I decided to start my own consulting and software company called
Ron's Place Software. My WEB development and application development skills can
be clearly seen at the company website (http://www.ronsplace.ca).
|
|
Achievements
|
-
Full e-commerce website (integrated with PayPal), written in ASP.NET MVC (Razor).
-
Commercial quality applications written in C#: Rons CSV Editor and Rons Renamer.
-
Customers including IBM, Boeing and Visa.
|
|
Skills
|
C#, ASP.NET, MVC, WEB API, REST, Razor, Entity Framework, T-SQL, HTML, CSS.
|
|
Technology
|
.NET 4.5, Visual Studio 2015, Microsoft Azure (SQL server, IIS, Service Bus, Storage Tables), SQL Server Management Studio, SQL Server 2012, JetBrains (ReSharper, dotTrace, dotMemory).
|
|
Overview
|
Hired to work on WEB APIs for an Azure hosted backend for hospitality services, my initial assignment was to design the protocols for the next version of the API. Next I was put in charge of the re-write of one of the company’s core products, including the design and architecture. Finally I was made interim team lead/development manager, until a replacement could be found.
|
|
Achievements
|
-
Designed and wrote a backend REST API for frontend mobile and web apps, using MVC and Entity Framework (SQL), running on Azure.
-
Designed, architected, and lead a team to build a global dashboard application from disparate global data sources, using MVC, Entity Framework (SQL), Service Bus and Storage Tables, running on Azure.
|
|
Skills
|
C#, Windows Forms, Windows Services, Entity Framework, T-SQL, PL/SQL, Progress
SQL, finance reporting.
|
|
Technology
|
.NET 3.5, Visual Studio 2013, JetBrains (ReSharper, dotTrace, dotMemory), SQL
Server Management Studio, Crystal Reports XI, Oracle 11, SQL Server 2000-2012,
Active Directory (Exchange Server). MISYS FusionInvest (Sophis Value).
|
|
Finance
|
Assets classes (equity, bonds, property, hedge funds), internal/external
funds, performance calculations (money weighted, time weighted), currency
forwards and hedging, bond calculations.
|
|
Overview
|
Initially hired as a reporting specialist, my additional skills were quickly
put to use designing and building a financial data warehouse. My primary client,
Asset Management, also utilised my C#, Forms and SQL skills to solve a variety of
operational requirements as they arose.
In March 2013 I took the opportunity to start my own company, Rons Place Software, and work for Anthos as an external consultant.
|
|
Achievements
|
-
Designed and created a Windows Forms desktop application in C#, to present a single user interface for all report execution, data load control and extended data input.
-
Designed and created a financial data reporting warehouse, including
writing the data load in C#. Data was sourced from Sophis Value (an Oracle
Database), REMS (a Progress database), Active Directory and others.
-
Various tools written in C# to automate report production and testing, data mining and management.
-
Designed and implemented a directory security auditing and management
tool using C# and SQL Server. A client service ran on each server, uploading
audit data in XML to a central windows service via a TCP connection.
-
Overhaul and organisation of the report architecture. Created and
maintained financial reports, intended internally for the asset management team
and externally for the clients. The reports were written in T-SQL, Crystal
Reports and Reporting Services.
-
Continual study of investment finance to gain the knowledge required
to complete my job.
|
|
Skills
|
VB.NET, ASP.NET, Windows Services, J(ava) Script, T-SQL, HTML, DHTML, MySQL .NET
data connector, assistance with infrastructure, user support.
|
|
Technology
|
.NET 2.0, Visual Studio 2005/2008, SQL Server 2000/2005 (Integration Services,
Analysis Services, Reporting Services), IIS 6, MySQL, OLE DB, ASP.NET, Active
Directory (Exchange Server), Infragistics NetAdvantage 2007, Windows services.
|
|
Overview
|
Primarily contracted to work on a series of internal reporting applications that
ran on Shell’s global Intranet (effectively an Extranet). I quickly took
over another failing project, and after successful completion of that, moved back
to my original assignment, and then others as needed.
|
|
Achievements
|
-
Analysis of requirements and source data, gathering that data, compiling
it into a reportable format, and delivering reports in a secure a targeted way.
-
Designed and implemented an intranet application to track 3rd
party access to resources. Overnight processes collected data about hardware,
like routers, firewalls, and users from Active directory, and compiled it into a
reportable format in SQL server. Originally used for monitoring, the project was
re-written and many features added including editing, updating Active Directory,
and collecting user feedback.
-
Implemented a distributed server management architecture. A
multi-threaded windows service ran on each remote server, which checked a central
management server periodically for scripts and schedules. These were downloaded,
executed, and the results then re-uploaded. All was controlled from an SQL Server
backed ASP.NET Intranet site.
|
|
Skills
|
C#, Windows Forms, ASP, C/C++ (Windows API), VB 6, J(ava) Script, VBA, T-SQL,
HTML, DHTML, Windows services, remoting, total/team solution development,
assistance with infrastructure, user support.
|
|
Technology
|
.NET 1.0, Visual Studio 6-2005, VB 6, SQL Server 7-2005 (Integration Services,
Analysis Services, Reporting Services), IIS 5/6, OLE DB, ASP/ASP.NET, Active
Directory (Exchange Server), Crystal Reports, Reporting Services, SharePoint
2007, Workflow, Windows Scripting.
|
|
Overview
|
Initially hired as a developer to implement the firms case management system,
over the years my development skills were utilised in almost every aspect of the
IT department on a wide variety of projects.
|
|
Achievements
|
-
Consulting on, designing and writing numerous projects to satisfy various
business and IT needs.
-
Designed and wrote the case management reporting Warehouse. A
multi-threaded Windows Service, parsing XML export files, and synchronizing with
a SQL 2005 server. Using remoting the service was controlled from a Windows
desktop application which could start and stop the service and change the number
of threads running. Data was dynamically compiled into summary tables and used to
populate an Analysis Services cube, and reported on using Reporting Services.
-
Played a pivotal role in design and implementation of VisualFiles case
management system, including entity model, integration with contact management
(InterAction) in C# and .NET, external components in VisualBasic, and design of
reporting warehouse.
-
Designed and wrote the company's Intranet in HTML, ASP and SQL. The
site contained a project database, support database, staff phone list, notice
board all populated from an SQL database. Full security, using NT authentication,
the entire site was configurable from a WEB browser.
-
Contribution to the administration of the network and user support.
|
Curriculum Vitae
- Aaron Stewart
