We provide IT Staff Augmentation Services!

Systems Architect Resume

5.00/5 (Submit Your Rating)

IL

SUMMARY

  • A highly technical person who also enjoys interacting with people, my goal is to leverage technology to create solutions to business problems. I am currently seeking a stable position that possibly could lead to a management role.

TECHNICAL SKILLS

Languages: C#, ASP.Net, HTML5, VB.Net, RDLC, MSRS, Ajax, SQL, SSIS, PL/SQL, TSQL, XML, XAML, XBAP, WPF, WCF, WWF, Regular Expressions, Assembler, Perl, COBOL, PL/B, Visual Basic, C++, Java, Django, Ruby, ASP, Python, SQL, ADSI, WMI, COM+, ADO, DB/C, VBScript, JavaScript, JQuery, PowerShell, Active Directory, Active MQ, Web Services, Angular, Node JS, Bootstrap, AWS, OpenStack, others

Development Tools: Azure, aWs, OpenStack, Microsoft TM Visual Studio .Net/Team System/WebMatrix, git Source Control, Rational Rose/Robot/ClearQuest, Rally, Nunit, ReSharper, AutoIt, WRQ Reflection, Cognos Reporting, Visio, SQL Enterprise Manager, SSRS, SSAS, SSIS, Red Gate SQL Compare, Visual Paradigm, DTM Data Molder, Altova DB Design, Embarcadero ER Studio, XCase, IBM Eclipse, IBM DB2 Client, PowerBuilder, Borland Jbuilder, Embarcadero E/R Studio, ESRI GIS Servers and Applications, Google Maps, Crystal Reports, DevExpress, Infragistics, Telerik, others

Project Management Methodologies: Waterfall, Agile, TDD

Database Systems: Oracle 8i/9i/10, DB2, SQL Server 2000/2005/2008/2012 , SharePoint, Access, Dbase, OLAP, ISAM, Versant OODBMS, others

PROFESSIONAL EXPERIENCE

Confidential, IL

Systems Architect

Responsibilities:

  • Developed a Windows Presentation Foundation application to automatically schedule employees and printing presses for order fulfillment. System populates a SQL Server 2017 database from a Clarion database, reads that data, then creates employee and equipment schedules as a result.
  • Documented and analyzed thousands of scripts written to run PeopleSoft HR and Elite Financial systems for this multi billion dollar a year company. Scripts include Perl, Shell, Korn Shell, PowerShell, Batch Files, and VBScript.
  • Created a C# application which interrogates all servers for scheduled tasks and catalogs that information into a SQL Server database.

Confidential

Senior Programmer

Responsibilities:

  • Managed the Full Life Cycle Development for an MVC 5 web application used to support Pulmonary Hypertension Research. Implemented the Repository and Unit of Work design patterns together with Kendo UI for the front end. Developed an algorithm combining three proven AI algorithms to produce a Soundex search engine which, in addition to the results, displays the matching probability percentage. Developed unit tests.
  • Re - factored existing ASP.Net web form application used for the last 15 years to support medical research. Improved performance and functionality. System guides staff through numerous and complex phone surveys. Provide support and upgrades on a day to day basis.
  • Developed console applications to consolidate various Project Management Systems data, providing management with project metrics reports as a result.
  • Developed reporting portals using IBM Cognos Framework Manager and Reports. Mentored users, and developed a user guide, in the usage of Cognos to query data.
  • Developed utilities for tracking author publications published to the National Center for Biotechnology Information
  • Developed proposal for alternate means of searching DNA data, utilizing Image Recognition technology Managed the Full Life Cycle Development for an MVC 5 web application allowing researchers to create dynamic queries on Cancer Patient data. Includes Windows Workflow Foundation for submitting research proposals and reviewing/approving those, as well as datasets. Included unit tests. Approved projects send data results to a super computer powered by OpenStack and AWS to generate virtual machines loaded with data and data visualizations. The data access layer was a port of the framework I developed for the PHT application. Revised this data layer to remove the Repository and Unit of Work, because it was redundant (already built into the Entity Framework) - result is a lean, generic and lightening fast data access layer.
  • My original goal in developing a DAL framework was so we had a framework we could re-purpose for future projects. This has proven beneficial.
  • Developed proof of concept mobile applications.

Confidential - Downers Grove IL

Architect/Developer

Responsibilities:

  • Developed an Active Directory based Single Sign On web portal for their clients to access multiple network and equipment monitoring applications and Sharepoint sites Developed a mobile version of the same.
  • Developed prototype portal utilizing Azure Active Directory Federation Services.
  • Configured and modified Solar Winds and Kaysea monitoring applications using HTML5 postMessage to implement SSO
  • Converted SharePoint 2010 Farm to use Claims Authentication rather than Classic, configured two new SharePoint Servers for Dev purposes
  • Configured SharePoint server to use Forms Authentication and created customized login pages Developed Custom SharePoint 2010 WSP to implement SSO using Claims Token Developed ASP.Net C$ portal, including management tools to manage Active Directory Users and Roles.
  • Developed C# Console application to send out notifications for accounts whose passwords are about to expire.
  • Setup Virtual Servers including Active Directory Doman Win2008 Server and IIS7 2008 Server

Confidential - South Bend IN

Developer/Architect

Responsibilities:

  • Re-architecture of existing Online Healthcare satisfaction survey system used by 70% of US Hospitals. Modified and created SQL 2008/12 Databases Integration with Db2 databases
  • Created ETL/DML scripts, Automated processes, procedures
  • Implemented and managed Open source Git, Jenkins, RoundhousE, DropKick, Ruby for continuous integration deployment of C# code
  • Improved and added functionality to WPF, ASP.Net, and Mobile applications utilizing Visual
  • Studio 2012, Dependency Injection, IOC, and NServiceBus/MSMQ
  • Setup, configured and managed Windows 2008 servers and deployed applications
  • Reviewed design proposal for custom built web service based on an ASP.Net Model View Controller application without the View. Proposed utilization of .Net 4.0 Web API solution instead.
  • Developed Accounting Reconciliation reports Developed Web API proof of concept service
  • Scrum Master for team of 3 onsite developers and 17 offshore developers for modifying legacy application to work with the Affordable Care Act. Company provided intensive Agile Training courses.
  • Created .Net Web Service to call Java Active MQ Service Developed TSQL code, procedures, views, SSIS Packages

Confidential

WPF Application and SQL Server Developer Consultant

Responsibilities:

  • Designed and developed WCF Web service based modules utilizing Windows Presentation Workflow External Rule sets. Modules handle complex Business Logic and Contractual Restrictions for an XBAP application. Programmers simply pass a list of their contract objects to the Business Rule or Contractual Restrictions (CR) methods. The list of objects are returned, updated with custom properties such as “Is Approval Required”, a list of Approvers, or details on CR violations.
  • Develop WPF/XBAP pages for the same contract management system
  • Developed tables, indexes, functions, and stored procedures for SQL Server database, including financial queries.
  • System developed in two months, manages all contracts and item pricing for Confidential . System developed to replace legacy mainframe.
  • Architected web based Nuclear Chemistry Analysis Reporting System
  • Utilizes Enterprise Library and Patterns and Practices Web Client Software Factory MVP and Unit Tests Uses ADO.Net interfaced with Oracle 11, Aspose.Cells, and DevExpress controls Developed Oracle Database, Tables, Views, Procedures, and Functions
  • Purpose is to be a central repository of approved reporting spreadsheets, applying access control and auditing

Confidential

Systems Architect Consultant

Responsibilities:

  • Architected a highly flexible Microsoft .Net C# Winform Plant Equipment Management System Created online reporting portal, using the DevExpress Control suite.
  • Converted their Accounting Sage Accpac ERP Database and system Finances not available to continue project
  • Developed online Logistics ERP application and databases. Including GIS enabled reports, report subscription engine. Provides real time visibility into inventory levels for their clients, as well as automated alerts.
  • Created archival database system that queried (intelligently based on business rules) the UPS tracking database. The system archives every UPS action for aprox. 2000 deliveries per day. Used to return a substantial savings via rebates based on proven service records.
  • Created an AJAX online solution that allows guides customers through the creation process of lubricant labels, and presents a real-time preview of those labels to them.
  • Developed an on demand reporting solution used to fulfill orders Developed accounting reports
  • Architected solution to convert their online course SQL Server and Oracle Databases to an improved architecture.
  • Architected and developed an Oracle 9i ASP.Net C# 2.0 Business Intelligence and Reporting solution for financial analysis
  • Create Databases, Tables, Views, Stored Procedures, Packages, Triggers and Sequences Develop C# ASP.Net modules and AJAX pages

Confidential, Chicago IL

Application Developer Employee

Responsibilities:

  • Individually managed the Full Life Cycle and development of a C#/ASP.NET/SQL Server 2005 application and GUI that manages the processes, flow, dynamic form generation, and E-mail distribution of notifications and forms, for all Projects undertaken at Denver International Airport. Prototype developed in three weeks, upon presentation to DIA management, they unexpectedly announced they would invest $300,000 to improve it.
  • Developed a Tablet PC application deployed on 12 tablets, used to conduct a Geospatial Airport Pavement Evaluation for all runways and taxiways at Denver International Airport. Project was allocated 1000 hours, but due to a management mix-up the application was required immediately. Designed, built, and delivered application in four days which saved the $5 million project.
  • Individually managed the Full Life Cycle and development of a C#/ASP.NET/SQL Server 2005 application and GUI for a web based Property Management System to manage high rise condominiums including the new Aqua 80 story complex under construction Developed SQL Reporting Services Reports
  • Developed SQL Server 2005 Databases, tables, views, stored procedures
  • One-month contract extended
  • Developed SQL Server, Report Services, .Net Web Services, and VB.Net code for implementing new invoicing functionality for construction equipment disbursement

Confidential, Batavia IL

Senior VB.Net and SQL Server Developer Consultant

Responsibilities:

  • Managed the entire Life Cycle Development and Delivery of a major systems upgrade for an ASP.Net/OEM Wireless Receiver application
  • Managed a full analysis of performance bottlenecks, developed and implemented resolutions, in a large redundant SQL Server 2005 database that manages Blood Units for all VA Hospitals in the country Debugged C# classes and Nunit test cases in this complex application.
  • Automated a manual invoicing and inventory process by creating a C# .Net 2.0 Windows Service that would listen for incoming XML files, and convert them to an EDI format used in the client’s order processing system. Files then FTP’d to client. Designed and managed the Full Life Cycle Development
  • Consolidated Purchase Order and Invoicing into a web based application
  • Consolidated two separate legacy Health Care Insurance Claim applications into one new UNIX system, managed the Full Life Cycle Development of C# and SSIS packages for conversion

Confidential

SQL Server Developer Consultant

Responsibilities:

  • Interfaced SQL Server with Oracle data for financial information Developed automated bank account reconciliation module
  • Consolidated legacy Mainframe applications which handled all of this company’s insurance claims onto a more modern platform
  • Developed an easy to use and reliable VB.Net Point of Sale Application and database
  • Created data mining solutions and custom reports to report on operating statistics, procurement, and finances.
  • Managed the Full Life Cycle Development of a major application upgrade for a Police Arrest application that I previously built. offered permanent position, declined offer due to distance from family Developed a web (Intranet) based Hospital Capacity Management System.
  • Presented to Vice President who was so impressed he mandated that this program be deployed at each of their hospitals, instead of just the one I was working for.

We'd love your feedback!