Advertisement:
Skystone Software
http://www.SkystoneSoftware.comEmployment History
|
|
Scott Waletzko has been a professional Information Technology consultant since 1996, and is a Microsoft Most Valuable Professional (Visual Developer - Visual Basic). The founder and President of Echosoft Design Studios and Skystone Software and an indepedent project consultant specializing in system and data architecture, focusing primarily on .NET and XML-based technologies Please feel free to browse this online resume, and feel free to send an e-mail to with any specific questions you may have. |
2004
to
Present
Echosoft Design Studios, LLC
(Canton,
CT)
:
President / Owner
Echosoft Design Studios provides artistic and highly accessible Web content design and development. From custom Web site development to the ground-breaking Tempest Web content management system, Echosoft Design Studios specializes in Web page design using the newest technologies available, including Flash, XML / XSL, and IIS-based server-side development using ASP classic or .NET-based languages.
2000
to
2008
Intellisponse
(Waterbury,
CT)
:
Senior Vice President of Technology
Initially brought onboard from a consulting role to design, build, and maintain the first version of the proprietary Synapse Survey software – a first of its kind Web survey authoring and hosting system designed to extend market research professional’s reach to the Internet – and eventually moving into department head and ultimately Senior Vice President roles, managing teams of developers and infrastructure specialists, and leading the company’s technological growth. Developed and implemented company-wide security, acceptable use, and best practice standards. Managed data center design and builds, equipment purchasing, and in-house development processes.
1998
to
1999
JAWSystems, LLC
(Canton,
CT)
:
Senior Consultant
Designer and developer on several custom projects, interacting directly with end users to determine project requirements, providing system design and implementation best practices and recommendations, and managing enterprise systems through each phase of the software development lifecycle.
1997
to
1998
MVP Consulting
(Hopkinton,
MA)
:
Senior Consultant
Briefly departed from the world of Windows development to learn AS/400 programming skills; participated in several high-profile projects including the roll-out of JDEdwards One World software at Digital Equipment Corporation.
1996
to
1997
Cornerstone Consulting
(Agawam,
MA)
:
Consultant
Cornerstone Consulting, headquartered in Springfield, MA, provides expert MitemView programming, mentoring and training services to over thirty MITEM customers.
Project History
2009
Annuity Tax Component Enhancements
(Mass Mututal)
Responsible for designing and coding enhancements to the tax processing component of a Web-based annuity management system for its second release. Responsibilities include meeting with internal clients to refine and functionally / technically document requirements and specifications, and designing and developing (using Visual Basic 2008) all requested enhancements to Federal and State tax withholding and reporting components.[...]
Customer Marketing Portal (The Worx Group)
Responsible for designing and developing a Web-based marketing portal for a data storage provider. The application is made up of an SQL Server-based data tier wrapped in a LINQ to Entity Framework data access tier fronted by an ASP.NET front-end, and provides a restricted administration and reporting portal to employees and dynamic marketing portal to customers.[...]
2008
Microsoft Most Valuable Professional Award - 2007
Awarded Microsoft Most Valuable Professional (Visual Developer - Visual Basic) for 2007. "As a recipient of [the] Most Valuable Professional award, Scott joins an elite group of individuals in online and offline technical communities around the world who share their passion for Microsoft products and technologies with others. Microsoft® salutes all MVPs for promoting the spirit of community by helping other people realize their potential through technology." [...]
Synapse V3 Survey Designer (Intellisponse)
Designed and developed a Windows-based survey design program allowing users to design and deploy surveys to the Synapse V3 Survey Collection System. Written in C#, this application uses an Access database to store survey design information and publishes compiled surveys to an SQL Server 2005 database. The software allows users to create and modify survey design elements, customizing the look and feel (through the use of CSS style sheets), content (allowing for multiple language HTML captions to[...]
XML Canonical Schema Architecture (XL Insurance)
Data Architect on an Information Architecture team responsible for designing the XML Canonical Schema for a company-wide S.O.A. integration project. Responsibilities include meeting with all participating workstreams to gather requirements and collect data models, documentation of requirements, recommendations regarding XML Schema capabilities, limitations, and design best practices (including versioning and deloyment), and design and development of the XML Schema, ultimately used as part of th[...]
Common Reference Data Architecture (XL Insurance)
Data Architect on an Information Architecture team responsible for designing a Common Reference Data solution for a company-wide S.O.A. integration project. Responsibilities included meeting with all participating workstreams to gather requirements and collect data models, documentation of requirements, recommendations regarding system design, architecture, best practices, and deployment, and design and development of a SQL Server database (tables, stored procedures, triggers, etc) associated .[...]
2007
Synapse V3 Survey Runtime Components
(Intellisponse)
Designed and developed the Synapse v3 Survey Runtime, a collection of component libraries written in C# that provide dynamic and feature-rich survey rendering and collection functionality. This library provides the capability for unique and fully customizable Internet survey rendering and validation, using a proprietary Document Object Model and events that trigger default functionality or can be hooked to dynamically-compiled C# or VB.Net code, enabling unlimited customization. Survey pages co[...]
Synapse V3 Survey Collection System (Intellisponse)
Designed and developed an ASP.NET-based survey collection system designed to handle high volumes of Web traffic. Written in C#, the system wraps the Synapse V3 Survey Runtime Components, handling requests for Web clients and interfacing with a SQL Server database back end. The system was launched in February of 2008 and proved its design, collecting almost 30,000 surveys in the first 3 day period on 3 servers. [...]
Secure Data Center Build (Intellisponse)
Oversaw planning, budgeting, and implementation of a highly secure and scalable data center. Built on HP Blade servers and VMWare virtual servers and workstations, this environment passed a high-level security audit by a financial institution client, allowing the company to become a partner in a strategic marketing initiative involving research panels and ongoing survey collection.[...]
Microsoft Most Valuable Professional Award - 2006
Awarded Microsoft Most Valuable Professional (Visual Developer - Visual Basic) for 2006. "As a recipient of [the] Most Valuable Professional award, Scott joins an elite group of individuals in online and offline technical communities around the world who share their passion for Microsoft products and technologies with others. Microsoft® salutes all MVPs for promoting the spirit of community by helping other people realize their potential through technology." [...]
Xml 101 Course at VBCity Academy
Wrote and moderated an online course called "Xml 101 - An Introduction to Xml for .NET Developers" for the VBCity.com Online Academy. This free self-paced course served as an introduction to the usage of Xml as a data definition language within the .NET framework. First a characterization and history of Xml was covered in order to obtain a base to work from, then the System.Xml namespace in .NET was introduced via a simple sample contact management project that students built step by step. [...]
2006
Microsoft Most Valuable Professional Award
Awarded Microsoft Most Valuable Professional (Visual Developer - Visual Basic) for 2005. "As a recipient of [the] Most Valuable Professional award, Scott joins an elite group of individuals in online and offline technical communities around the world who share their passion for Microsoft products and technologies with others. Microsoft® salutes all MVPs for promoting the spirit of community by helping other people realize their potential through technology." [...]
Lotus Notes to Exchange Migration (Intellisponse)
Managed corporate e-mail migration from Lotus Notes to Outlook / Exchange, overseeing Exchange installation and configuration, mailbox migration and conversion, and installation and configuration of Outlook on end-user's computers. [...]
SynapseSurveys (v3) Framework Development (Intellisponse)
Developed the framework and application program interface for the third version of Synapse Surveys (a proprietary survey authoring, management, and data collection system). The framework and API, written in C#, is a unique shell application (and companion API component library) designed to provide fully customizable modular functionality to users. Modules (or "plugins") are added dynamically to the application's interface at startup, based on the user's selection of which functionality to inclu[...]
Online Credit Application (Ontario Credit Corporation)
Designed and developed a 3-page online application for credit for a financing / equipment leasing company. The online form allows users to securely enter all information related to a request for a line of credit, storing the data in a database and sending a notification e-mail to credit personnel upon completion. The form was written in classic ASP using a Microsoft Access database. [...]
2005
Tempest / myBard.com
Designed and developed the prototype version of Tempest, a proprietary Web Content Management system for Echosoft Design Studios and MyBard.com. This system, written in Visual Basic .Net, includes an SQL Server database-communication library tier, a Windows-based administration component, and a set of Web-services (utilizing the data-tier library). Together, these components provide unique Web-based site content management capabilities to end-users, and with comprehensive client, design file, a[...]
Software Regression and Quality Assurance Model
Designed and developed a software regression and quality assurance model for Echosoft Design Studios. This set of components are written in C#, and provide automated regression teting and logging capabilities, designed to facilitate developer testing of software components before human testing. This component library is used by developers to benchmark and certify software before it is released to end users for BETA testing. Tracking changes to each release; comparing and logging current benchma[...]
SynapseSurveys (v3) System Architecture (Intellisponse)
Designed the third version of Synapse Surveys, the proprietary survey authoring, management, and data collection system, to be built in C# and VB as a multi-tiered Windows application accessing an SQL Server database via distributed Web services. This version will represent the consolidation of several existing systems, migrating separate Windows- and Web-based systems into a single comprehensive package. Survey authoring, management, and reporting capabilities will be included alongside projec[...]
RSS Aggregator (Windows) (Intellisponse)
Designed a Windows Forms based RSS aggregator utility for use by Intellisponse employees, clients, and vendors. Created static and deployment object model diagrams using UML (in Microsoft Visio), designed application user interfaces, and wrote specifications and use case scenarios. Mentored new VB programmers on application development and architecture concepts including RSS 2.0 specifications, use of the System.XML namespace, and development of applications in a .NET framework environment bas[...]
Flash Image Viewer (Intellisponse)
Designed and built a Flash image viewer for use in Web surveys. The viewer (built in Flash MX and Actionscript 2.0) is configurable via command parameters, and was designed to display 15 images (video game box covers) in a random layout. The images are either displayed for a specific number of seconds, or the user is timed (and the time recorded in the survey) to see how long it takes them to pick out and click a specific image. [...]
Personal Windows Helpdesk (v2) (Intellisponse)
Architected a comprehensive Windows-based helpdesk utility, designed to run in the system tray of a user"s computer until needed; assisting with daily MIS functions (such as accessing remote networks via VPN, mapping network drives and printers, logging, managing, and reviewing helpdesk tickets, and backing up local files to the network). The system has an administrative component which can be installed as a snap-in, enhancing the program for advanced users. This program replaces several d[...]
2004
Personal Windows Helpdesk (v1)
(Intellisponse)
Designed and developed a self-updating personal helpdesk utility (and associated Web services) for Intellisponse in Visual Basic .Net. This program operates in the user"s system tray, and was designed to replace functionality typically provided by Windows 2000 login scripts and group policy. Right-clicking the tray icon enables the user to automatically connect via VPN to the corporate network, map / un-map network drives and printers, backup local files to a personal folder on the file se[...]
Kytherea (v3)
Designed and developed Kytherea 3, the third generation personal encryption software. This release, written entirely in Visual Basic .Net, uses the native .Net encryption library to provide fast and secure document encryption. The program runs in the user"s system tray, providing right-click access to any secure data (such as passwords and credit card information) that the user desires. Project responsibilities include application and component design (including abstract user interface[...]
WinSpy
Developed a Windows process Spy utility and associated set of components in Visual Basic .Net (and the Win32API) that enables users to enumerate, find, gain information about, and interact with other processes on the current machine. Project responsibilities include application and component design and development.[...]
Auto-update / Bug Tracking Component
Created a Web service and related .Net component in Visual Basic .Net that integrates bug tracking and automatic software updates into any application. Bug logs are stored in an Internet-based SQL Server database (accessed via Web services), and the component contains a user interface for tracking the status of previously-submitted bug reports. A standalone utility checks the database for updates to the program (by comparing version numbers through a Web service), updating the local components [...]
HTML DOM Components
Designed and developed an HTML Document Object Model component library, associated Windows display controls (HTML Treeview, HTML Listview, HTML Textbox), and stand-alone document viewer. Together, these components provide powerful and flexible access to the document object model (DOM) of any HTML document, allowing developers to access and manipulate elements as with the System.XML components. All components were written in Visual Basic .Net. Project responsibilities include component desig[...]
XML Treeview Control
Developed an XML Treeview Windows control in Visual Basic .Net for the express purpose of enabling developers to display XML documents to end users without having to write redundant code. The control accepts an XML document as a property, allowing developers to control the display options of each individual node by responding to events, rather than looping through the hierarchy of the document. Project responsibilities include component design and development.[...]
Intellisponse Web Site Redesign (Intellisponse)
Redesigned the Intellisponse Web site using HTML, Flash, and Active Server Pages in an effort to make upkeep easier and more efficient. Web site derives text data from a database that can be updated by corporate users through a simple interface. Project responsibilities include graphic design, site layout design, and site development.[...]
Bulk Mail System (Intellisponse)
Designed and developed a Web-based bulk mail system (using ASP.Net and SQL Server) that is fully integrated into existing project management, profit and loss, and reporting systems. This application allows users to upload files containing lists of e-mail addresses, and then manage, review, and release the lists through a Web interface. Project usage costs are automatically allocated to the appropriate project in the related management systems. The application has a companion WinForms utility th[...]
2003
Online Helpdesk System
(Intellisponse)
Designed and developed a helpdesk ticket submission and tracking system using ASP .Net and SQL Server. This system provides users a method for submitting trouble tickets via a 3-step wizard, enabling helpdesk collaboration through automatic ticket assignment and the ability to rapidly escalate tickets to the appropriate support personnel. Included in the system design is a simple device inventory and documentation component allowing helpdesk tickets to be tracked by user, category, or device. T[...]
Time and Project Management System (Intellisponse)
Designed and developed a comprehensive internal Timesheets and Projects Management using ASP.Net, SQL Server 2000, and Data Dynamics Active Reports (encapsulated in a proprietary reporting Web services system). The system provides employees with a Web-based vehicle for entering and tracking timesheets entries for billing purposes, and includes personal, management and executive reporting systems. Additionally, project costs and timelines can be tracked and managed, facilitating executive profit[...]
Online Reporting Web Service (Intellisponse)
Designed and developed a reporting Web service using ASP.Net, SQL Server and DataDynamics ActiveReports.Net. The Web service processes requests for report files (dynamically adjusting database connections and report query parameters) and streams PDF or HTML reports to the requesting client without using server file space or the need to rewrite the reporting HTTP Handlers. Project responsibilities include system architecture (application and component design, data modeling, security blueprin[...]
Data Center (New York)
Designed (and supervised installation of) a new information center in New York in order to accommodate increased bandwidth requirements of Intellisponse"s proprietary systems. Located at an MCI co-location facility, the data center includes 3 racks of servers, routers, and firewalls, all directly connected to the frame-relay hub. The network itself is actually 4 distinct networks, separated by Windows 2000 domain and on 4 different routers (to optimize traffic to each dedicated system). Ea[...]
2002
Respondent Data Harvester
(Intellisponse)
Designed and developed a data harvesting component for Intellisponse using Visual Basic .Net and SQL Server 2000. This console-based application is designed to run as a scheduled task, harvesting data regularly from the Lotus Notes-based proprietary survey software into a relational database. Using .Net Web services, the system translates records from one system into the other using transactions, updating the SQL Server database only when all records have been transferred without error. The ori[...]
Tables Posting utility (Intellisponse)
Developed a text file processing utility in Visual Basic / ASP.Net, designed to processes respondent data files from a variety of sources, extracting pertinent information and formatting it for reporting purposes. The utility uses class inheritance to provide processing capabilities for multiple brands of data files with maximum code reuse and reduced developer maintenance requirements. This program were integrated into the Intellisponse .Net System, a proprietary ASP.Net system designed to enc[...]
Intellisponse .Net System (Intellisponse)
Designed and developed the framework for an online system in ASP.Net designed to be the foundation for all Web-based software development at Intellisponse. The system authenticates Intellisponse users against existing user accounts on Lotus Notes servers using a proprietary and unique secure authentication protocol, and then tracks user activity internally. Also supporting non-Notes user logins (for external users and clients), the system manages its own user and group identities, and offers a [...]
Kytherea (v2)
Designed and developed Kytherea (version 2) - a personal key-based encryption program that utilizes the Blowfish and Twofish encryption algorithms to provide users with desktop file and password security. The application was built using Visual Basic .Net and uses carefully coded replicas of the popular Counterpane Labs encryption algorithms. Project responsibilities include application and component design and development.[...]
SynapseSurveys (v2) / SE-Script (Intellisponse)
Managed the design, development, and deployment of the second incarnation of Synapse Surveys, a unique survey authoring tool that allows market research professionals to write complex surveys and publish them to proprietary web server software for survey administration, data collection and data reporting. This suite of client and server applications was developed using Visual Basic 6 (client) and Lotus Notes (server), and leverages a custom server-side scripting language to create dynamic Web p[...]
Helius (v2)
Ported Helius (a freeware Atomic clock synchronization utility for Windows-based computers) to Visual Basic .Net (from VB 6). This program runs in the system tray, polling public atomic clock servers via the Internet, and updating the system clock as needed. Project responsibilities include application and component design and development.[...]
2001
Bulk Mail List Processor (v2)
(Intellisponse)
Ported to Visual Basic .Net Intellisponse"s proprietary XML document creation / upload program, allowing market research professionals to convert lists of survey respondents from tab-delimited files to XML, and transfer (via FTP) the XML documents to a 3rd party rewards vendor (www.iGain.com). Project responsibilities include application and component design and development.[...]
Kytherea (v1)
Designed and developed a personal key-based encryption program that utilizes the Blowfish and Twofish encryption algorithms to provide users with desktop file and password security. The application is written in Visual Basic 6 and uses carefully coded replicas of the popular Counterpane Labs encryption algorithms.[...]
2000
Helius (v1)
Developed Helius, a freeware Atomic clock synchronization utility for Windows-based computers in Visual Basic 6. This program runs in the system tray, polling public atomic clock servers via the Internet, and updating the system clock as needed. Project responsibilities include application and component design and development.[...]
Data Center (Waterbury, CT) (Intellisponse)
Co-designed (and supervised installation of) a new information center in Waterbury, Connecticut containing a generator, Inergen fire suppression system, Liebert battery system, and 15 Windows 2000 servers. The network, built on 4 different Windows 2000 Active Directory domains and located on 2 sets of redundant T1 lines, utilizes Cisco firewalls, routers and switches for maximum throughput and redundancy. Each server in the network was designed to be capable of responding to 1 million page requ[...]
CartWatcher / Intellicept (Intellisponse)
Architected and supervised development of the patent-pending Intelli-popup (intelligent web site intercept) multi-tier technology for Intellisponse. This technology, developed using a unique combination of VB-Script, HTML / JavaScript, Visual Basic COM+ components, and SQL Server database stored procedures, drove Intellisponse"s CartWatcher and SitePerfector Web site intercept applications, requiring customers to place only a few lines of code into specific pages on their Web site in order[...]
Bulk Mail List Processor (v1) (Intellisponse)
Designed and developed an XML document creation / upload program that allows market research professionals to convert lists of survey respondents from tab-delimited files to XML, and transfer (via FTP) the XML documents to a 3rd party rewards vendor (www.iGain.com). This application was written in Visual Basic 6. Project responsibilities include application and component design and development.[...]
Development Team Utilities (Intellisponse)
Developed a suite of Web-based applications for Intellisponse including a program to track upcoming and current internal projects, and a bug-tracking database (complete with a discussion thread for each bug report). These HTML programs were coded in Active Server Pages using VB-Script and an MS Access database, and were used by developed and quality testing teams during ongoing system development projects. Project responsibilities include application and component design and development.[...]
SynapseSurveys (v1) (Intellisponse)
Co-led the team that was tasked with creating Synapse Surveys, a ground-breaking proprietary survey authoring and collection system for Intellisponse (then called the Harrison Group). Responsibilities included overseeing the design, development, and testing of the Windows-based survey authoring client software, which integrated with a server-based Web hosting and data collection component (developed by the rest of the team) automatically via FTP. The Windows-based program allowed authors to eas[...]
SynapseTables (Intellisponse)
Led a team of developers through the process of designing, developing, testing, and deploying SynapseTables, a data analysis companion program to Synapse Surveys. This system imported data from Synapse Surveys, enabling users to generate text-based aggregate reports on respondent data by combining answers into rows and columns (tabs) and filtering the data by any number of methods. Written in Visual Basic 6, the program used a Microsoft Access database to store and process data. Project res[...]
1999
Shipping Business Management System
(Mystic Transport / CAM Logistics)
Designed and developed a self-updating client / server system to handle shipping logistics, truck dispatch, and delivery verification for Mystic Transport / CAM Logistics. Responsible for overseeing all aspects of the project, including needs assessment, specifications gathering and authoring, systems architecture, database architecture / development / administration, and software component design and development. Designed self-describing components to imitate object inheritance (not otherwise [...]
Warehouse Inventory Tracking System (Mystic Transport / CAM Logistics)
Designed, developed and deployed a client / server warehouse inventory program that allowed warehouse workers to inventory and tag items arriving by truck, then store and sort them according to destination. The system generated pallet tickets with barcodes and destinations printed on them, enabling warehouse personnel to use inventory scanners in lieu of computer interfaces to easily and accurately remove items from inventory. The application was written using Visual Basic 5 with an SQL Server [...]
1998
OneWorld Rollout Mentoring
(Digital Equipment Corporation (DEC))
Involved in one of the first full-scale JDEdwards One World software rollouts at Digital Equipment Corporation; leveraged Windows development experience with AS/400 and JDEdwards development experience in order to mentor the DEC development team on use of the Windows-based One World ODBC reporting tool.[...]
Z-Files System Development (Sodexho USA)
Lead a team of developers through the development and testing phases of a custom JDEdwards Z-Files system designed to translate uploaded national field data into General Ledger entries for the corporate finance department at Sodexho USA. Worked closely with users and testing staff to enhance original specifications and troubleshoot completed programs. Designed interfaces and reports; wrote developer specifications for all programs in the system. Scheduled testing procedures and assisted users w[...]
Custom PTF Upgrade (Toyota Tsusho)
Handled all modification upgrades and worked with PTF implementation during a JDEdwards software upgrade at Toyota Tsusho in NYC; assisted in coordinating the upgrade between two AS/400 servers.[...]
Cost Center Budgeting System (Sodexho USA)
Worked on the team responsible for the development of a budgeting application requisitioned by the corporate finance division of Sodexho USA. Functionality developed as part of the team included reporting procedures displaying database information using any combination of 100 different form views chosen by the user at run time, and a factoring interface allowing the user to view and edit budget information for a particular business unit using spread and automatic calculation methods. Developed,[...]
Library Kiosk Utility
Developed and deployed a custom application to control and track usage of programs installed on a library reference computer at Mercer Management. The program (written in Visual Basic 5 with an Access database) tracked application usage by user and department, generating custom reports for use as internal billing invoices. Project responsibilities include application and design and development.[...]
Finance Text-file Extraction Utility (Sodexho USA)
Using Powerbuilder, developed a utility to import pertinent information from an AS400 extract file into a Sybase database, simultaneously displaying the information to the user in a custom user interface.[...]
1997
MitemView Development
(Central Maine Power)
Worked with an in-house development team, writing new components and reworking existing code for a call center system at Oklahoma Natural Gas. Assisted management in refocusing development on several sub-systems, and mentored the team on the concepts and best practices of mainframe access system design and development using Visual Basic and MitemView.[...]
MitemView Mentoring / Development (Oklahoma Natural Gas)
Worked with an in-house development team, writing new components and reworking existing code for a call center system at Oklahoma Natural Gas. Assisted management in refocusing development on several sub-systems, and mentored the team on the concepts and best practices of mainframe access system design and development using Visual Basic and MitemView.[...]
Microsoft MVP
Scott Waletzko has been awarded the distinguished honor of being named a Most Valuable Professional (Visual Developer - Visual Basic) by Microsoft each year since 2006.
"As a recipient of this year's Most Valuable Professional award, Scott joins an elite group of individuals in online and offline technical communities around the world who share their passion for Microsoft products and technologies with others. Microsoft® salutes all MVPs for promoting the spirit of community by helping other people realize their potential through technology."
| Click here to learn more about the MVP Program.Click here to view Scott's profile on the MVP site. |
