Infor SyteLine / SQL Developer - Arlington Heights, IL

Stan Golin

Infor SyteLine / SQL Developer

Arlington Heights, IL 60004

********@*****.***

Objective:

To find work that utilizes my current skills as a Infor Syteline / SQL developer as well as offer career growth in IT. Summary:

● Create / Modify Syteline Forms, FormScript, Form Events, Email events, UETs and IDOs

● SSRS / MS Report Builder 4.0 / Crystal Reports developer on data sources such as: SQL Server, Oracle, MS-Access, Excel

● Ability to communicate technical details into short summaries for status updates with managers, office staff and/or end clients.

● ETL skills using MS SSIS, VB / C#, JSON, XML, CSV, MS SQL, Oracle, Access and Excel VBA / VSTO.

● VB .NET / C# Web Developer with experience using SQL stored procedures, SQL/PL, Oracle, MS-Access and XML data.

● Website developer using .NET MVC, JavaScript APIs, jQuery, BootStrap, RESTful, HTML5, CSS, and Classic ASP.

● Developed WCF RESTful web service applications with Visual Studio web methods (.asmx /.svc).

● Used third party ASP.NET libraries / APIs / Themes for website frontend UI with form css style controls for calendars, menu navigation, etc. ( i.e. SiteFinity CMS, SiteCore CMS and ThemeForest assets / templates. )

● Technical Support for end users (Windows 11, 10, Win7), desktop and website application support, web server IIS performance troubleshooting, MS-SQL, Oracle client software, MS-Access, Excel VBA, Visual Basic and Lotus Notes. Education & Training:

Associate Computer Science, College of Lake County, Grayslake, IL High School Diploma, Antioch Community High School, Antioch, IL

● MS Power BI @ learn . Microsoft . com ( Feb. 2025 )

● Model Data with Power BI @ learn. Microsoft . com ( Feb. 2025 )

● Power BI visuals and reports @ learn . Microsoft . com ( Feb. 2025 )

● Visual Studio TFS with Agile\Scrum ( Feb. 2014 )

● WPF Developer Skills Builder for Microsoft .NET ( Feb. 2006 )

● Building XML Based Web Applications - MOC 1905C ( March 2005 ) Technical Skills Summary:

SyteLine Developer 9+ years, Ver. 9, CSI v10

MS Reporting Services SSRS, BI 8+ years, Ver. 2022, 2019, 2013, 2010 (Visual Studio Designer) Visual Studio / TFS 6+ years, Ver. 2022, 2019, 2013, 2010 ( TFS – Agile, Scrum, RAD ) VB.Net, C#.Net, ASP.Net 7+ years, Ver. 2026 17.13, C# 14, 8.0, Classic ASP Visual Basic / VB Script 9+ years, Ver. 2026 17.13 MS SQL Server, SSIS, BI 9+ years, Ver. 2022, 2019, 2016 T-SQL, PL/SQL 9+ years, Microsoft SQL and Oracle

Crystal Reports 4+ years, Ver. 2011, X Enterprise, IX Oracle Client / Server ( OLEDB )3+ years, Ver. 19c, 12c, 11g ( Quest Tools - SQL Toad ) MS Access / MS Excel 7+ years, Ver. Office365, 2024, 2010 ( VBA and VSTO automation ) Programming Languages:

VB-Script, VB.NET, C#.NET and ASP.NET using Visual Studio, MS-SQL P/L, VB 6.0, VB Script, MS Access VBA/VSTO, Excel VBA/VSTO, Windows Services .asmx/.svc API, ODBC, OLEDB, Classic ASP, JavaScript, jQuery, CSS, HTML Website Development:

Windows IIS, Visual Studio, VB.NET, ASP.NET, VB Script, C#, SiteFinity CMS, HTML, jQuery, CSS, JavaScript, BootStrap, XML Datasources, Classic ASP

Software Tools Used:

SQL Management Studio SSMS, Quest SQL Toad, MS Visual Studio 2022, MS-Access, MS Reporting Services (SSRS), Crystal Reports, Remedy & Issuetrak Help Desk, Ipswitch WS_FTP Pro, MS-SQL Server 2016, MS Integration Services SSIS, MS-Excel, MS-Schedule, MS-Office 365, MS-Visio, Lotus Notes, iNotes, Domino, Remote Desktop (mstsc.exe), Enterprise\IIS Manager, MS Virtual PC, SDK Tools and FTP Utilities, Ultra VNC remote desktop utility, GIT source code repository, Operating Systems:

Windows 11 Pro, 10, 7, XP Pro, Windows Server 2022, 2018, 2016, Mac OS, MS-DOS, Novell, Linux Professional Experience

Decision Resources, Inc., Pittsburgh, PA ( Remote online office ) Aug 2025 to Jan 2026 Products Developer / Systems Analyst

Duties & Accomplishments:

● Configure Middleware e-commerce data to facilitate Credit Card and ACH payments with SyteLine v9 and CSI v10

● Project management skills applied for multiple e-commerce clients with weekly meetings, updates via MS-Teams.

● Test / Debug middleware using Visual Studio 2019 ( VB & C# projects with GIT repository )

● Setup / Test MS Office 365 client as tenants to use Outlook 365 as a Middleware interface for transaction history.

● Create, schedule and host meetings with company end clients to provide testing status updates for their e-commerce project.

● Create Visio and Excel files as small repositories for data and images to help with meetings, discussions, training, etc.

● Multiple environments for Dev and UAT, Production roll-outs were coordinated with client SyteLine networks. Environment: Windows 11/10 Pro, Windows VM Servers, MS-Teams, Remote admin, SharePoint Progressive Data Corp, Arlington Heights, IL Feb 2025 to July 2025 SyteLine / SQL Developer / Report Writer (Contractor) Duties & Accomplishments:

● Create/Modify Infor Syteline ERP forms, reports, FormScript and Form events for client needs.

● Used Report Builder 4.0 and Visual Studio SSRS to create/modify client reports for use with Syteline, SharePoint, etc.

● SQL Developer for MS-SQL stored procedures, triggers, views and scheduled jobs with SSMS client. Environment: Windows 11 Pro, Windows Server 2016, MS-Teams, Remote administration, SharePoint OTTO Engineering, Inc., Carpentersville, IL Oct 2015 to Jan 2025

.NET Report Writer / SQL Developer ( Contractor - Pyramid Consulting ) Duties & Accomplishments:

● Modify Infor Syteline / Mongoose ERP forms, reports, FormScript and email events for various manager needs.

● IDO Extensions, IDO Validations, Business Logic for email delivery, Event Handling on form load/save and button events.

● Used Visual Studio SSRS and Report Builder 4.0 for SyteLine v9 report modifications and/or create new reports.

● SQL Developer for MS-SQL stored procedures, triggers, views and scheduled jobs with SSMS client.

● Daily use of Issuetrak ( Help Desk & Customer Support ) software for Syteline issues, sprint tracking, etc.

● Export product data to a .xlsx format ftp output folder via a Visual Studio SQL service ( .asmx /.svc ) nightly job.

● Create/maintain a SQL/PL script that runs nightly for vendor “ScoreCards” datamart summary reports emailed to suppliers.

● Used MS PowerShell to view/update Excel files with multiple tabs.

● Shared knowledge with co-workers on SQL programming via MS-Teams remote screens or at their desk. Environment: Windows 11/10 Pro, Windows Server 2016, MS-Teams, Remote administration, SharePoint Professional Convention Management Association (PCMA.org), Chicago, IL June 2015 to Sept 2015

.NET Web Developer (Contractor)

Duties & Accomplishments:

● ASP.NET MVC website development using Visual Studio 2013/2012. GIT repository source code management.

● SiteFinity CMS development including Javascript, jQuery, CSS and multiple organization websites based on PCMA.org

● Master page design conversion based on themes purchased from ThemeForest.net to integrate with SiteFinity CMS.

● Create/modify classes or models for use with object oriented patterns such as MVC and Javascript APIs.

● Javascript API frameworks used: jQuery, BootStrap 3.1.1, Knockout, Google Analytics and OWL Carousel.

● QA Testing for credit card business logic with test data, debugging and problem resolution. Environment: IIS server admin, Win 8, Visual Studio, VB.NET, MS-SQL Server Lions Clubs International, Oak Brook, IL Sept 2014 to Feb 2015

.NET Web Developer (Contractor)

Duties & Accomplishments:

● RAD ASP.NET development using C#/VB.NET with Visual Studio 2013 TFS and Agile sprints and daily stand ups.

● Create/modify classes or models for use with object oriented patterns such as MVC and Javascript APIs.

● LINQ SQL, Javascript, jQuery, CSS and SQL stored procedures are used frequently as tasks are assigned.

● Used Ajax control toolkit and/or jQuery for field inputs, UI calendars and other features to enhance the UX design.

● Some tasks involve multiple language integration in web pages such as Spanish, French, Chinese, Korean and Japanese. Environment: Win7, Visual Studio TFS, ASP.NET, MS-SQL Server, Crystal Reports 2011, MS SSRS, Remote IIS server admin Progressive Data Corp, Arlington Heights, IL Nov 2013 to Sept 2014

.NET Web Developer / Report Writer (Contractor)

Duties & Accomplishments:

● Client website upgrades: Convert Classic ASP applications into ASP.NET MVC4 using a WCF RESTful JSON data tier.

● Used CSS to format website pages and AJAX / JavaScript for calendar UI / data validation.

● Data ETL from .csv text and/or Access tables into Excel spreadsheets for use in pivot tables and VLookup functions.

● Use of SQL Management Studio to edit SQL server permissions and attach new databases to the server. Environment: Win7 32/64bit, Win XP Pro, Visual Studio TFS, C#.Net, UAT Sandbox, MS-SQL Server, Crystal Reports 2011, MS SSRS, MS-Excel VBA, MS-Access VBA, Classic ASP, ASP.Net, IIS, Remote Desktop (mstsc.exe) Oce` / Canon USA, Inc. ( Cumberland Ave, Chicago, IL ) March 2010 to Oct 2013

.NET Developer / Application Middleware Support (Contractor) Duties & Accomplishments: ( Prior to merger with Canon USA )

● Support middleware web services and file transfer ETL for ERP systems. ETL modifications using VS 2010 for ASP.NET, Classic ASP, VB Scripts. Create/Modify WS_FTP scripts for 40+ middleware workflow items.

● Use of SSIS and SSMS software to update data in MS-SQL server database/tables and automate ETL when needed.

● Update existing code for company intranet/extranet websites using ASP.Net using VB.Net and C#.Net.

● Maintain middleware systems for file transfers, renaming and import into Oracle, MS-SQL or SAP servers.

● Used Remedy Help Desk to track help desk issues, MS-Excel VBA and MS-Access. Environment: Win XP Pro, ETL with MS SSIS, UAT Sandbox, MS-SQL Server, SQL*Toad, Visual Studio 2012/2010, VB.Net, C#.Net, MS SSRS, MS-Excel VBA, MS-Access, ASP, ASP.Net, IIS, Remote Desktop (mstsc.exe) Nicor Gas / BP Amoco / Sears Holdings / Elgin Sweeper June 2007 to Feb 2010 Developer / Database Consultant

Duties & Accomplishments:

● For Nicor Gas, system automation for inventory tracking and meter reading using MS Access VBA forms and reports.

● For BP Amoco, created MS-Excel VBA applications for their new franchise systems with the ability to discover errors through data mining by applying a dynamic category for all GUI drop down lists on the inventory spreadsheets. Used Excel VBA for dynamic SQL commands, drop downs and the ability to pull from multiple Excel templates.

● For Sears Holdings, automated the monthly financial roll-up process using Excel VBA with dynamic parameters such as business unit, division and department which reduced the manual creation time needed.

● For Elgin Sweeper, converted applications from MS Access to Classic ASP with SQL Server data on IIS for Intranet / VPN usage. Developed several MS SSRS reports that use SQL Server data on their local intranet.

● Used Visual Studio 2008, SSRS, SSIS/ETL and VBA for Excel and MS-Access with dynamic SQL query commands.

● Used Crystal Reports X Enterprise for report creation and conversions from MS Access formats. Environment: Win XP Pro, SQL Server 2000/2005, SQL*Toad, Visual Studio 2008/2005, VB.Net, MS SSIS/ETL, Excel VBA, MS-Access VBA, MS SSRS, Crystal Reports X Enterprise, ASP, ASP.Net, IIS, SharePoint, CRM, UAT Sandbox AC Nielsen Jan 2007 to May 2007

VB Developer / Database Consultant

Duties & Accomplishments:

● Created Excel VBA automation for PowerPoint presentation that showed real time analysis graphs. Emphasis on dynamic SQL commands, data cubes and graphing options.

● Extensive use of VBA with SQL (ADO) queries dynamically created from form input for data selection criteria.

● Live remote demonstrations, UAL test procedures and role out implementation documentation.

● Report writing with MS Access to provide market details and performance related summaries.

● Application support for enhancement requests using VBA, VB 6, Access and PowerPoint Environment: Windows XP Pro, PowerPoint VBA, VB 6.0, Excel VBA, Visual Studio 2005/2003, MS-Access LaSalle Bank June 2006 to Dec 2006

VB Developer / Database Consultant

Duties & Accomplishments:

● Modify VB 6, VBA macros, MS Access development with large financial loan documents related to apartment rental properties.

● Report writing with Crystal Reports IX, MS-Access reports and SQL data sources to provide loan details and performance related summaries.

● Application support for MS Access application(s) and data sources that merge into financial templates.

● Existing application support for VBA bug fixes and enhancement requests using VB6 or MS Access. Environment: Windows 2000, Win XP Pro, VB 6.0, Excel VBA, MS-Access, Crystal Reports IX Progressive Data Corp, Arlington Heights, IL Apr 2003 to May 2006 Web Developer / Report Writer (Contractor)

Duties & Accomplishments:

● Used CSS to create website pages with AJAX / JavaScript for calendar UI / data validation.

● Create and update SSRS reports, Access reports, Excel pivot tables and/or Crystal Reports.

● Data ETL from .csv text and/or Access tables into Excel spreadsheets for use in pivot tables and VLookup functions.

● Use of SQL Management Studio to edit SQL server permissions and attach new databases to the server. Environment: Win XP Pro, Visual Studio TFS, C#.Net, UAT Sandbox, MS-SQL Server, Crystal Reports, MS SSRS, MS-Excel VBA, MS-Access VBA, Classic ASP, ASP.Net, IIS, Remote Desktop (mstsc.exe) Accenture Inc.Dec 2002 to March 2003

Application Remediation Developer (Contractor)

Duties & Accomplishments:

● Migration project from Notes Domino e-mail systems to HTML/MIME email compatibility.

● Analyzed client DHTML, Cascading Style Sheets and JavaScript DOM to troubleshoot errors.

● Provided XML, XSLT DOM analysis and automated reporting using Adobe Acrobat Distiller 5 PDF files.

● Technical support in Lotus Notes Domino, Lotus-Script, Domino.Doc based messaging for customers converting from Notes Domino R5 to MS-Exchange and VB 6.0 solutions. Created custom utilities in LotusScript as needed. Environment: Win XP Pro, VB 6.0, Lotus Notes, Lotus Script, XML, XLST, DHTML, HTML\MIME Blue Cross Blue Shield Association, June 2001 to Nov 2002 Applications Support / Developer Consultant

Duties & Accomplishments:

● Provided application support using SQL*Toad, Classic ASP, Visual Basic 6, MS-Access and dBase IV for DOS.

● Created custom ad-hoc VB6 forms and utilities in VB-Script as needed.

● Provided project management assistance and technical support for migration from X-Base application to ASP based model including VB-Script, SQL & Java applications for XML data exports.

● Internal support for departmental business units with software analysis and modifications. Environment: Windows 98, SQL Server, SQL*Toad, ASP, VB 6.0, MS-Access, Excel, dBase IV John Crane Inc.Feb 2001 to May 2001

Notes Domino Dev. / Admin. II

Duties & Accomplishments:

● Developed Web pages on their intranet website for HR forms and FAQ resources. ODBC with MS-SQL databases

● Notes Domino server/user migrations, desktop support, server maintenance and DAT backup procedures. Environment: Windows 2000, Lotus Notes Domino, Lotus Script, MS-Access, IIS, HTML, VB Script, Excel Central Dupage Health Dec 2000 to Feb 2001

Lotus Notes Consultant

Duties & Accomplishments:

● Performed Lotus Notes Domino and Domino.Doc modifications for local Intranet

● Intranet web design with AS/400 as a Domino server and troubleshoot terminal emulation into AS/400 resources. Environment: Windows NT 4.0 and IBM AS/400, Lotus Notes Domino, Domino.Doc, MS-Access, Excel Equity Office Inc.Oct 2000 to Dec 2000

Lotus Notes Consultant / Support II

Duties & Accomplishments:

● Custom application and PC support help desk II and utility development to ease the management of Notes Domino server cluster maintenance for network administrators.

Environment: Windows 98 and NT 4.0, Lotus Notes Domino, MS-Access, Excel Schiff Hardin & Waite May 2000 to Oct 2000

Lotus Notes Consultant / Server Administrator

Duties & Accomplishments:

● Notes developer analyst II / Notes Admin. / Notes Help Desk II for internal staff and projects.

● Notes Domino server analysis / recommendations for performance and cost savings. Environment: Windows 98 and NT 4.0, Lotus Notes Domino, Lotus Script, MS-Access, Excel

Contact this candidate