FRANK ALEXOPOULOS

508-***-****

ad0eeg@r.postjobfree.com

Franklin, MA

www.linkedin.com/in/Frank-Alexopoulos

PROFESSIONAL SUMMARY

Experienced full stack .NET software developer with over fifteen years of technical ability in delivering custom enterprise web applications. Ability to lead projects from end-to-end. In-depth knowledge of designing relational databases and building ETL solutions under SQL Server platform. Experienced in Agile/Scrum methodology. Highly skilled in developing ASP.NET, C#, .NET, SQL Server, and Oracle. Performs exceptionally well in challenging and demanding environments.

SPECIALITIES

•Custom Software Development

•Project Management

•Database Design and Development

•Software Development Life Cycle

•Agile/Scrum Methodology

•Business Analysis

•ETL Data Modeling & Data warehousing

•Leading development efforts

•Vendor Assessment/Management

•Team Leadership

TECHNICAL SKILLS

Cloud

AZURE SQL

Database:

Microsoft SQL Server, 2005,2008,2012,2016, 2019, AZURE SQL, Oracle, MS-Access, MySQL, XML, TSQL, ORACLE PL/SQL

Development:

ASP.NET MVC, .NET Core, C#, VB.NET, JavaScript, jQuery, HTML, DHTML, CSS, AJAX, JSON, Classic ASP, Visual Basic, VBScript, Entity Framework, ASP.Net Web Forms, .NET Web API, WinForms, Razor, Web Services, RESTful Services, React, Bootstrap, Power Apps, NodeJS, Angular, SOA

BI and Reporting:

Microsoft SSRS, Power BI, Crystal Reports

ETL Tools:

SQL Server Integration Services, Data Transformation Services, Erwin

Development Tools:

Visual Studio 2012/2013/2017/2019, Report Builder, Oracle SQL Developer, SSMS, Visio, Postman, Swagger

Version Control:

Git, DevOps, Team Foundation, SourceSafe

Collaboration and Content Management:

WordPress, OnBase, SharePoint, Smartsheets,, Asana

Web Servers:

IIS, Tomcat

EXPERIENCE

RHODE ISLAND JUDICIARY COURTS CENTER

Stonewall Solutions (Contract)

SOFTWARE ARCHITECT

OCTOBER 2022 – AUGUST 2023

•Re-Engineered legacy, vendor-based Attendance Management System

•Objectives: Redesign and build new system under a modern .NET CORE platform, migrate ORACLE data to SQL Server, assume control of source code for future enhancements, integrate with HR and Payroll, deploy to seven courts and over three hundred users.

•Collaborated with stakeholders and project management team to build scope of work and implement new attendance recording policies.

•Designed and developed modules including tracking projects, tasks, weekly timesheets, approvals, workflow, reporting, analysis, data visualization, notifications, and alerts.

•Implemented reporting functionality with SQL Server Reporting Services

•Integrated with Human Resources and Payroll systems.

•Integrated security with Microsoft Active Directory Services.

•Created test plan for pilot implementation.

•Partnered with technology team to design and build technical environment.

•Client-side tools: Microsoft Visual Studio, SQL Server Management Studio, ORACLE SQL Developer

•Reporting tools: Microsoft SQL Server Reporting Services, Report Builder

•Client-side Languages: HTML, JavaScript, jQuery, AJAX, JSON,

•UI: CSS/Bootstrap, Responsive Development

•Server-side languages: ASP.NET .CORE

•Databases: Microsoft SQL Server, ORACLE

MUNICIPAL POLICE TRAINING COMMITTEE

Stonewall Solutions (Contract)

SOLUTION ARCHITECT

JANUARY 2022– JUNE 2023

Data warehouse

oCollaborated with company stakeholders and vendor to build Microsoft Azure SQL data warehouse replicating training records from an AWS/ORACLE Learning Management System.

oEmployed SQL Azure Data Factory to deliver data to Massachusetts Peace Officer Standards and Training Commission Snowflake database.

Data warehouse Reporting and Business Intelligence

oDesigned and built tabular, matrix and chart reports using SSRS and Power BI Report Builder to generate information on training, instructors, classes, and enrollments of state-wide police officers to assist with police reform.

Document Imaging and Storage

oEngineered ASP.NET MVC/C# application software to consume data from digitized documents into SQL Server.

oIntegrated digitized Azure/SQL Server data with vendor AWS/Oracle database.

oCreated Power BI dashboards for executive stakeholders.

BOSTON POLICE DEPARTMENT: INFORMATION SYSTEMS GROUP

APPLICATIONS DEVELOPMENT MANAGER, SENIOR SOFTWARE ENGINEER

JANUARY 2008 - JANUARY 2022

HIGHLIGHTS

Reported directly to Chief Information Officer as Applications Development Manager and lead engineer and architect.

Key advisor to police department officials and stakeholders.

Mentored staff of ten software developers using knowledge sharing in the areas of software development, database engineering, report building and systems integration.

Established cross-functional teams to assist with building system architecture.

Installed and managed all IIS website applications and SQL Server databases.

Product Owner for all team-based software development efforts using Agile/Scrum methodology.

Maintained detailed ETL system documentation including requirements, data dictionaries, data mappings, and operations.

Lead technical architect for the design and implementation of a SQL Server data warehouse.

Built ETL data transfer mechanisms using SSRS including data mapping and analysis, extraction, and transformation, planning and execution, quality assurance, documentation, and reporting.

Provided application support for a 24/7/365 workplace.

Redesigned legacy IBM Mainframe Overtime Payroll and Paid Detail Systems under ASP.NET. Core/C# application integrating payroll with PeopleSoft system.

Designed mission-critical enterprise reports using SSRS to assist administration, finance, human resources, and enterprise deployment strategies.

Engineered a secure ASP.NET MVC/SQL Server enterprise portal to host applications and reports using Active Directory, Single-Sign-on for over five thousand users.

Designed, developed and customized over ten .NET applications to tracking police incidents, arrests, restraining orders, domestic violence cases, overtime and paid details, firearms licensing, 911, Weapon inventory, motor vehicle accidents and citations.

Partnered with Massachusetts District Attorney and Department of Criminal Justice Information Services to build ASP.NET RESTFul web services and SSIS to exchange police and court criminal records data.

Partnered with IBM COPLINK to build criminal intelligence system for criminal data and offender image exchange with Department of Justice, U.S. Immigration and Customs Enforcement Initiative using SSRS and SQL Server.

Planned and reengineered fifteen Classic ASP software applications to ASP.NET MVC framework.

Architected, designed, developed, and implemented ASP.Net WEB API interfaces and data integration for enterprise applications and databases.

Created fully responsive web applications using Bootstrap Framework

Coordinated and conducted all requirements gathering meetings with department stakeholders for potential software development efforts.

Senior lead for the development of a suite of enterprise-wide transaction systems under the full stack ASP.NET Core,MVC/C#/HTML/JavaScript/CSS/jQuery/SQL Server.

Participated in the evaluation and award process for six vendor systems.

Designed and implemented department Intranet content site using WORDPRESS/MySQL.

EDUCATION

Bachelor of Science: Electrical Engineering and Computer Science

Northeastern University, Boston, Ma

Associate of Science: Electrical Engineering

Benjamin Franklin Institute, Boston, Ma

AWARDS

Commissioners Commendation, Bringing Technology to Community Policing

Special Commendation, Domestic Violence Outreach Program

Commissioners Special Commendation, COPSMore Grant, Incident Reporting Project

Commissioners Special Commendation, Technology Advancements

Contact this candidate