Senior Software Developer

Data Analytics – Power BI – On-premises/Cloud

Build/administer dashboards for various KPIs from incident/change/problem ticket systems

Set up infrastructure from ETL (T-SQL) -> data marts -> layered system

Split data into FACTs (KPI calculations) and dimensions (raw data) via SQL views and stored procedures

Visualize with Power BI

Configure Data Gateway -> Azure

Migrate dashboards from on-premises to Azure

Set up a banking environment in Azure (architect/developer)

Installed via PowerShell/AZ CLI

Azure Bastion for RDP access

Azure Storage Explorer for file transfer on-premises -> Azure

Test SharePoint -> Azure Active Directory + ADDS for authentication

Connect SharePoint -> Okta/OneID – SSO

Migrate all apps (VB6/C#) -> Azure

.NET Framework (NET Core, ASP.NET MVC)

Tools: Visual Studio 2022

Develop Power BI / SSRS (data analytics)

Install/configure Power BI/SSRS servers

Create dashboards / paginated reports

Build SSRS reports from custom stored procedures (SQL Server)

Build SSAS cubes

Develop Power BI dashboards (data modeling)

Data marts + dashboards

ETL frameworks

Data models, database design, data mining

Databases (SQL etc.)

SharePoint 2019 (admin/developer)

Install/configure SharePoint 2019

Configure Health Services and logging

Configure auditing

Configure security NTLM/LDAP

Install via PowerShell

Migrate SP2010 -> SP2019

Develop LDAP membership provider (VS2019/C#)

Develop SQL membership provider (VS2019/C#)

Migrate farm solutions (8 projects) SP2010 -> SP2019 (farm features / lists / security)

Tools: VS2019 / C#

Blazor as app framework (developer)

Compare Blazor with previous JS frameworks for future projects

DevExpress UI components for Blazor

Component structure

Dependency injection and data access

Authentication with OWIN (OpenID Connect/SSO)

Routing, editing, and validation

JavaScript interop

Blazor Server <-> Blazor WebAssembly

Build DWH / SQL Server (>2012) (admin/developer)

Set up a DWH server

Prepare for reporting (standard reporting, framework for multiple clients, just onboarding needed)

KPI calculation based on configuration

Layer/data marts from tables

Dimension tables for BI prep

Layer concept (templates generating dynamic SQL)

SharePoint 2016 (admin/developer)

Install/configure SharePoint 2016

Configure Search Service (formerly FastTrack)

Configure Health Services and logging

Configure auditing

Configure security NTLM/LDAP

Install via PowerShell

SharePoint 2013 Foundation (admin/developer)

Install/configure SharePoint 2013

Configure Search Service (formerly FastTrack)

Configure Nintex workflows including security

Build custom membership provider

Configure Health Services and logging

Configure auditing

Configure security NTLM

Install via PowerShell

Develop web applications (software architect/developer)

Build applications of varying sizes per client requirements

Maintain and enhance existing applications

Architect and design applications

Integrate into IBM’s IT landscape

Continuous integration with SVN/Git + Jenkins

UI with WPF

Tech: Visual Studio 2010-2022, C#, HTML, XSLT, XML, JavaScript, jQuery, JSON, Subversion, T-SQL, LINQ, Entity Framework, WCF services, Web API, MVC

Enhance and maintain internal tool Shared Cockpit (software architect/developer)

Tool allows generic table management in the web using Entity Framework

Framework built in C#, OOP

Specialized features added via ascx or generic configurable modules

Example: role delegation

Dynamic input form generation

Continuous integration with SVN + Jenkins

Tech: Visual Studio 2010-2022, C#, XML, WCF, UI via jQuery, T-SQL

Create a VisualBoard in SharePoint 2010 (software architect/developer)

VisualBoard shows KPIs and manages issues/tasks/logs for GDF

Also tracks health index of each pool

Implemented for 35 pools

Use SharePoint’s role-based security

Admin via application pages in SharePoint

Data used for charts in GDF framework

Home page as web part page so each pool can arrange parts as needed

Web parts to display pool structure/members and issue overview

Database: MS SQL Server

Build data model for processing

KPI numbers via parametrized SSRS reports

Process large data with T-SQL for KPI business logic

Tech: Visual Studio 2010-2013, C#, HTML, XSLT, XML, JavaScript, jQuery, SharePoint features, SSRS, event receivers, Subversion, LINQ, Entity Framework, data lists, WCF, Web API

SharePoint 2007 -> 2010 migration (software architect/developer)

Plan, document, and execute migration

Introduce SharePoint 2010

Admin tasks – implement FBA login via LDAP

Program application pages in C# within SharePoint

Connect external data via BCS

Set up enterprise search environment

Develop web parts with C# and web part connectivity

Use Subversion for source control

Build workflows with Nintex Enterprise

Reporting solution

Built a complete DWH (data modeling) with reporting solution and documentation

Create automated import interfaces for DWH via email and direct import (SSIS)

Design a fully automated data loader with logging and restarts

Design/reports via SSRS and integrate into SharePoint 2007 MOSS/2010

Write and optimize stored procedures and T-SQL/SQL

Tech: SQL Server 2005/2008+R2, SSRS, SSIS, Subversion

General

Extended existing ASP.NET apps in VB.NET and C# using Dynamic Data in VS 2005-2017

Deep knowledge of LINQ & Entity Framework

Solid web fundamentals: HTML, XSLT, XML, JavaScript

Testing with NUnit

Scrum used as development framework.

Project SAP@AM

Process delivered data from multiple custody accounts into file format for SAP@AM

Program reads input data and creates MT535 Swift messages

I handled complete implementation with SOX compliance

Documented requirements, implementation, and test cases

Tech: Excel VBA

Project VB to .NET migration

Evaluate small VB apps and migrate to .NET

Defined common data model after functional analysis

Produced OOP/OAD documentation

Implemented solution in C#/.NET, including data modeling

Tech: C#/.NET/ADO.NET, 3-tier app on Oracle 10g

Oracle 8i -> 10g migration

Migrate DB to Oracle 10g

Evaluate dependencies, document/test/adapt applications, coordinate production rollout

Adjust PL/SQL statements and provide SQL scripts to operations

Project FXPMS/FIDB

Maintain and test FXPMS and FIDB apps

FXPMS processes trades from Bloomberg and delivers hedges via reports

Apps built in VB, DB on Oracle 10g, ETL with Oracle Warehouse Builder, scheduling with Redwood Cronacle

Expand PL/SQL procedures/Redwood chains, update data model, adjust UI as needed

Follow SOX compliance and testing

Project MCD/FDR to OPDP

For official AXA-CH reporting, load data from MCD/FDR via SQL*Loader, transform, and store in reporting tables

Focus: data modeling, ADO, PL/SQL, OWB, BI with SSIS+SSRS