Brian Morge

**** *. ******* ***. + Evergreen Park, IL 60805 + 708-***-**** + ac9bjg@r.postjobfree.com

Professional Experience

SOFTWARE DEVELOPMENT: C# 5/VISUAL BASIC/VB.NET/VISUAL STUDIO 2013 SQL SERVER 2005, 2008, 2012/SQL SERVER INTEGRATION SERVICES/ORACLE CRYSTAL REPORTS/ORACLE REPORT BUILDER/SQL SERVER REPORT SERVICES

.NET 3.5,4.0,4.5/ASP.NET 4.5/HTML 4.0/JAVASCRIPT 5.0 Periscope June 2017 – March 2019 Database Developer / Analyst Periscope is a marketing firm that provides end-to-end solutions in the advertising world. As a member of the data driven marketing department, my main focus was on providing customer support for various projects including deep data analysis, custom reporting utilizing SQL Server Report Services and application development with C#. Other projects included creating a data warehouse in SQL Server 2012 and providing periodic feeds into the data and feeds providing output. Additional solutions were developed with SQL Server Integration Services for weekly customer requested feeds.

Heniff Transportation Systems, LLC October 2014 – May 2017 Software Developer/Analyst Heniff specializes in liquid bulk transportation. Their emphasis is on safety and relates directly to over 400 drivers adhering to company safety guidelines. To encourage adherence to company safety goals, monthly bonus was calculated based on metrics gathered around driver performance such as speed violations, fuel mpg, sudden stops, etc. As programmer analyst, main duties consisted of gathering data on all drivers and transforming into understandable reports. Multiple applications were developed in C# utilizing .NET framework and Entity framework facilitating data gathering from multiple sources such as flat files, Microsoft Excel spreadsheets and internet XML sources. In addition, developed over 25 complex reports using Sql Server Report Services and supporting data imports developed with Sql Server Integration Services providing updates, upgrades and troubleshooting.

Unison Consulting Group December 2012 – September 2014 Software Engineer Unison Consulting is an aviation consulting firm that advises worldwide clients and provides consulting services. My role included supporting latest enterprise system Retail Management System, a web based lease management system developed for the Chicago Department of Aviation Concessions group which handles all business with the vendors located throughout O’Hare and Midway airports. Duties included initial design and development using Visual Studio VB.net, ASP.net and Oracle as backend database. Tasks included development of web services, database tables, views, triggers and several Crystal Reports. Periodic status meetings were held with the client along with implementation support as well as ongoing user support. Other duties included supporting CarePlus within the Chicago Department of Aviation. CarePlus reported on multiple airport projects involving construction, consulting, payroll and many other interdepartmental activities. CarePlus used several web based applications for reporting, payroll and project management. Main duties included adding functionality to existing parts of application using a combination of HTML, Java and Oracle. Additionally, developed several reports with Oracle Report Builder.

Kristine Fallon & Associates February 2012 – December 2012 Consultant KFA specializes in providing custom solutions involving Web-based Project Management, Building Information Modeling with Training Classes, Digital Archive for Architecture System and Research. As a database developer, initial responsibilities centered on data conversions for prominent clients using various tools such as Visual Basic 6.0/VB.net and Microsoft Access. Additional responsibilities included onsite consulting services with clients engaged in requirements gathering and solutions review. Acted as project manager within a sub-contractor role working for the Regional Transportation Authority to value all assets under the Chicago Transit Authority, Metra and Pace including gathering all submitted client data on assets, transforming data into a Microsoft Access database and producing Microsoft Excel pivot tables for analysis. Also acted as SharePoint administrator to help consolidate all project data for easy review. This included managing underlying file/folder structure and adding users.

9519 S. Millard ave. + Evergreen Park, IL 60805 + 708-***-**** + ac9bjg@r.postjobfree.com Page 2

Brian Morge

Health Care Service Corporation Blue Cross Blue Shield April 2011 – February 2012 Software Developer / Analyst

Health Care Service Corporation (HCSC) is a customer-owned health benefits company Through its plans, affiliates and subsidiaries, HCSC offers health and life insurance products and related services, including coverage under Blue Cross and Blue Shield of Illinois, Blue Cross and Blue Shield of New Mexico, Blue Cross and Blue Shield of Oklahoma, and Blue Cross and Blue Shield of Texas, and Dearborn National. As a Developer Analyst, main responsibilities included monitoring claims penalties resulting from late processing and predicting future trends. Also maintained several metric reports consisting of a variety of tools including Visual Basic 6.0, Microsoft SQL, Microsoft Excel, Visual Basic for Applications, Teradata, Cognos and SAS 9.2. Other duties included taking adhoc requests from customers, operating claims handling centers and researching those request utilizing IBM emulator by logging into CICS, ICTSO mainframe and analyzing data related to those requests. Accruent January 2011 – April 2011 Consultant

Re-entered into a consultant agreement to develop custom applications using Visual Basic 6.0, Visual Basic .Net 2008 and Microsoft SQL Server 2000/2005/2008. Projects included enhancements to existing applications based on client requirements and new application development centered around Accruent’s enterprise suite SLIM. Projects consisted of Windows applications.

Electronic Brokerage Systems LLC November 2010 – March 2011 Database Developer Electronic Brokerage Systems, LLC provided brokerage services to the investment banking community. It provides brokerage, clearing services, trading equities and options services. The company creates electronic connectivity for broker dealers in the securities industry, as well as routes orders to various security exchanges and electronic clearing networks that offer liquidity. It conducts business in equity, fixed income, and derivative securities. The company was incorporated in 1999 and operates as a subsidiary of Belzberg Technologies Inc. Core responsibilities were support for the clearing department and included monitoring automated daily reports generated within MS SQL Server database, month-end billing practices and support for the clearing department’s main technology tool named Shadow, a client server application which provided its users information relating to prior/current day trading activities. Other responsibilities included performing end-of-day activities to settle current day’s trades by running several custom SQL procedures to incorporate trading activity into EBS’ data warehouse. Additional support included design, development and modification of SQL stored procedures providing clearing department with required views into underlying data. Accruent May 2004 – October 2010 Software Developer Accruent leads the real estate management software industry with a comprehensive suite of enterprise location management solutions including SLIM (Strategic Lease Information Management). SLIM and its additional custom built applications were my primary responsibilities. In May 2004, NFG joined forces with Accruent, its largest competitor and I remained on as SLIM’s primary resource. 9519 S. Millard ave. + Evergreen Park, IL 60805 + 708-***-**** + ac9bjg@r.postjobfree.com Page 3

Brian Morge

SLIM – Client Custom Integrations

JP Morgan Chase - Involved in design with client to provide solution in facilitating data exports/imports from Accruent solution, SLIM and client legacy systems, in this case SAP. The challenge was the amount of transactions going into SAP which numbered between 200,000 and 400,000 rows of data. Originally, client desired the ability to control the program flow through a thin client interface connected to underlying SQL 2005 database. Upon further review, client agreed to more efficient solution which consisted of database stored procedures scheduled to run overnight and allow client the ability to review output residing in staging tables before final delivery to SAP. Originally designed process took about 3 to 4 hours to complete. Scheduled kickoff of database stored procedures completed in 15 minutes. After client reviewed increased efficiency, remaining 9 custom applications were designed in the same manner. Statistical information was generated during processes and written to custom tables available to client. Overall, project ran for 14 months with client requested changes to custom applications and core product solution, SLIM being accommodated throughout project.

Giant Eagle – Developed Oracle 10g stored procedures to import large data set flat files. using Visual Basic 6.0 to replace original process that ran for 20 hours. Once solution was designed and developed, process was implemented with oracle install scripts and overall process was cut from 20 hours to 25 minutes. The success with clients’ sales import solution led to two other applications being designed, developed and implemented which included an accounts payable export and an accounts receivable export. Both applications were a combination of Visual Basic 6.0 thin client interface and Oracle 10g underlying stored procedures.

Chipotle – Worked with clients Real Estate department to design 9 custom applications utilizing a mixture of VB.Net and SQL Server 2005 database stored procedures. These included accounts payable import and export, a property portfolio import; a percentage rent export and sales data import. Project lasted approximately 11 months. At a later date, client requested a straight line depreciation application which needed to run nightly and based on user interaction within Accruent solution SLIM, custom application would calculate new schedules for any leases within SLIM that were modified during prior day. The solution consisted of SQL Server 2005 stored procedures and update triggers on key tables to flag which leases within client portfolio needed to be recalculated.

Duane Reade – After successfully implementing 3 custom solutions designed to interface clients legacy financial systems which included both an accounts payable export and import and an accounts receivable export utilizing a mixture of Visual Basic 6.0 and SQL Server 2005, client asked for a straight line depreciation application developed for another client. Solution was fine-tuned for client’s requirements.

The Home Depot – Worked with project team as main developer for custom applications to facilitate imports and exports to Accruent main product SLIM and clients legacy financial system SAP. Overall, 11 custom applications were designed, developed and implemented on site with client over a project life cycle of 15 months. Custom solutions include accounts payable imports and exports, vendor imports, expense reconciliation and CAM exports for financial reporting. Client also purchased straight line solution developed for previous clients. Technologies included SQL 2005 and VB.Net.

Sonic – Designed, developed and implemented several custom programs to import and export financial data with Accruent core solution SLIM and client legacy financial systems. Solutions included accounts payable import and export, general ledger accounting export to produce ledger entry file from SLIM financial information for import to client’s legacy accounting system. Solutions were a mixture of SQL 2005 stored procedures and user interfaces developed with Visual Basic 6.0. 9519 S. Millard ave. + Evergreen Park, IL 60805 + 708-***-**** + ac9bjg@r.postjobfree.com Page 4

Brian Morge

Starbucks – Created financial imports and exports from existing client financial systems and Accruent core product SLIM. These included sales data import; percentage rent export and sales audit reports via views created within SQL 2005 database with Visual Basic 6.0 front end. Helped client upgrade from earlier version of SLIM with Oracle to latest release with SQL Server 2005 which included converting their Oracle database to SQL Server via SSIS packages.

Target – Worked on small team to design, develop and implement 16 custom applications designed to move financial data between Accruent solution SLIM and client’s legacy financial systems. Project lasted approximately 18 months. Solution consisted of SQL 2005 stored procedures and VB.Net for user interfaces.

SLIM – Data Conversions

With every new client, a conversion of their existing real estate portfolio usually needed to occur. This was accomplished using a variety of tools including Microsoft Access, Visual Basic 6.0, SQL Server and Oracle scripts. This process would entail several initial mapping sessions with client followed by development of tools to perform conversion. Client source data was delivered in several formats including Microsoft FoxPro, Microsoft Excel, flat files and SQL Server or Oracle. A general set of tools wasn’t practical because clients would differ in their source data formats. Once a set of tools was created for any particular client, this combination of SQL Server/Oracle scripts, Microsoft Access queries and Visual Basic 6.0 could be used over and over again to deliver as many iterations of client data as needed.

SLIM – Strategic Lease Information Management

Enterprise wide client server solution designed for real estate managers handling large portfolios. Clients included those listed in this document as well as American Express, CVS, DollarTree, Family Dollar, Morgan Stanley and several other well-known companies. Technology used consisted of Visual Basic 6.0, VB.Net, SQL Server 2000/2005 and/or Oracle 9/10, Microsoft Remote Data Objects and Microsoft ActiveX Data Objects. Project started in 1999 and remained in effect until 2010 and included yearly product upgrades, maintenance and releases.

Responsibilities included gathering client requirements, form/screen design and development, testing and quality assurance and implementation.

Suite consisted of over 100 forms and over 50 code modules. Client projects revolved around SLIM as main component with additional custom integrations available at additional cost as well as data conversions of existing client real estate data. I was hired in 1999 to help complete the SLIM project and over time, became the sole resource for any SLIM work. For almost a decade, SLIM held a strong position among real estate managers as a valuable solution to streamline manager’s day-to-day responsibilities. As the project matured and less new development was required, priorities shifted from working on core solution and more to custom applications designed to facilitate SLIM communicating with client legacy financial systems in place such as SAP.

Contact this candidate