Christopher Zahrobsky

Associate Managing Director - Programmer Analyst IV

Web and Database Systems Developer concentrating in C#.NET, Microsoft SQL, Java, JavaScript, Python, PowerShell, VBA, Azure migrations and secure API integration

• Developed over a dozen MVC web apps with framework features in C#.Net and JavaScript employing JQuery and Telerik components
• Continuously developing our core LDAP active directory access and version control monitoring routines, advocating Azure Entra active directory process standards
• Collaborated to troubleshoot and resolve Network RBAC / Firewall security setup issues
• Built, documented and supported JWT and certificate-based authentication to replace encrypted password-based configurations
• Authored a roles-based workflow engine from project spreadsheet metadata exports
• Proofed and formatted Federal Reserve NYSE holdings SHLA compliance report filings
• Created a user interface for external investment and cash account collateral holds
• Automated vendor data imports for loan collateralization sufficiency reporting
• Collaborated on CI/CD build pipeline enhancements and installer automation
• Built ETL processors incorporating Java/Talend and Microsoft SSIS packages with an evolving observer-observable pattern service provider plug-in architecture
• Created a tablet-based sign-up app for onsite marketing promotions
• Evaluated and implemented sample API Python and ActionScript methods for the digital mobile banking initiative’s app vendor review
• Designed content management HTML, CSS and JavaScript plug-ins for the BOLD leadership HR initiative site with single sign-on training materials integration
• Implemented multiple Bloomberg API interfaces for USD, CAD and GBP exchange rates and municipal bond risk rating lookup with WCF and .NET Core Swagger-UI endpoints
• Lead agile on-site and remote collaboration of consultant onboarding and support
• Promoted data-driven monolithic architecture separation, refactoring for optimal code reuse, in pair-coding sessions
• Used Outlook and Excel interop and macros to integrate websites with Microsoft Office
• Documented step-by-step system requirement standards for new projects in Confluence
• Participated in Azure AZ-900 certification and Ethereum blockchain initiative training
• Volunteered for multiple BRAVEN Community Resource Act mentoring opportunities

Senior .NET Developer

Developed and maintained desktop and mobile device applications and service-oriented architecture for the Hyatt Client Advantage Mobile (HyCAM) platform, integrating legacy hotel systems with ongoing data initiatives.

• Worked with Oracle MICROS Systems vendor relations and subject matter experts in supporting and enhancing integration features of the Opera hotel reservations system in Microsoft C#.NET, PowerShell and VB6 on Amazon Web Service (AWS) EC2 cloud servers.
• Developed automated guest check-in and check-out notification features for the Experian (CCMP) Cross-Channel Marketing Platform and the RabbitMQ Advanced Message Queuing Protocol
• Enhanced the Hyatt Digital Forms iPad, WCF services, and WPF Desktop application to facilitate electronic capture of registration card and folio receipt signatures using TLS1.2 encrypted network security
• Collaborated with the offshore team in China to develop a multilingual room directions editor in PHP, HTML, CSS and JQuery
• Created an extensible smoke test command line utility for rapid file search, configuration and database queries with psexec for remote processing
• Coded Excel macros to convert multi-lingual unicode message text worksheets into uniform data for SQL batch processing
• Used Git Flow, BitBucket and JIRA to manage source control of new features, releases and hot fix enhancements
• Provided on-call troubleshooting and technical support of live system issues in the Service Now support ticket and change management system over VPN and Remote Desktop to over 600 hotel servers
• Conducted log searches and dashboard analytics in the SPLUNK Enterprise portal tool
• Helped manage technical support documentation updates on a SharePoint site

Senior .NET Developer

Collaborated with a team of developers to create new features for the Northern Trust Goals Powered Initiative platform for investment planning with mobile and WPF client components.

• Coded and enhanced three WPF clients using the Microsoft Model-View-ViewModel (MVVM) pattern with the Prism Library
• Performed code and configuration tasks for 5 separate WCF services
• Managed Oracle 11g stored procedure packages with XML data updates
• Developed XAML framework components with Microsoft Expression Blend, PDF Toolkit, Paint.NET and Telerik graph and grid controls
• Configured and Supported TFS and Bamboo build environments with nuGet package management and NUnit continuous integration test projects
• Integrated CheckMarx code analysis daily scans into the build process
• Used the Moq mocking library to isolate and test individual units of code
• Introduced a financial formula testing strategy combining Excel and C# outputs
• Lead the migration of all projects to new .NET 4.5.2 framework standards

Database Systems Architect

Augmented the fixed income trading platform team's agile development efforts

• Provided service layer troubleshooting and bug fixes in C#.NET with NUnit testing
• Helped update onboarding procedures to increase new developer productivity
• Created a stand-alone web-based Subversion archive download utility for new users without administrative permissions
• Coded and deployed a multi-threaded BCP data transfer utility with zip compression in SharpZipLib and AES encryption in C#.NET to automate timely data archive backup and relocation in multiple SQL Server and Dot.NET framework versions
• Setup secure FTP B-HUB transfer to servers in the London office
• Automated recurring batch processes with Microsoft SQL Server job scheduling and AutoSys JIL scripts
• Worked with the messaging team to optimize TIBCO EMS transaction retention by topic

Database Systems Architect

Migrated web forms, web services, database objects and source code to Windows Server 2008 servers for the Web Applications Development group.

• Introduced test-driven development (TDD) in C#.NET to the component design process
• Authored the household matching strategy used to reduce redundant mailings
• Refactored workflows to implement common interfaces and optimize code reuse

Microsoft Systems Architect

Joined a team of Microsoft consultants to deliver a suite of related software components to support a meaningful refresh in Grant Thornton's audit methodology.

• Collaborating on Microsoft Office VSTO add-in coding in C#.NET with MVC data query
• Serving as Scrum Master hosting a daily stand-up using Microsoft Lync and TFS Kanban board review, planning Sprint ceremony activities over join.me conferencing with SeeNowDo for retrospective collaboration, and adapted agile processes to the priorities of product owners, team members and stake holders
• Wrote a TFS reporting utility outlining work item acceptance criteria for Sprint Review
• Managing Microsoft Azure web host and virtual machine assets with Remote Desktop, SQL Server Management Studio and FileZilla FTP
• As build master, setup and corrected team build errors in Visual Studio solutions, nuGet repository library content, and WiX installer projects on an Azure TFS build controller
• Coded command-line build tools for assembly version labelling, ftp file sync, zip archive packaging, and PowerShell script integration
• Performed SQL 2012 deployment troubleshooting and fixes for MVC application deliverables
• Designed, coded and maintained a website for daily package deployment with OAuth sign-up, role-based access, and Sprint metrics using Microsoft Entity Framework

Desktop Systems Architect

Created multiple VSTO add-ins and a Distribution Group management website to fulfill Lotus Notes conversion to Outlook, regulatory compliance requirements, and data loss prevention initiatives.

• Managed a group of seven consultants to deliver website functionality and Microsoft Office banking regulation compliance enhancements
• Performed code reviews and merges in Team Foundation Server (TFS) with WinMerge
• Wrote add-ins for Microsoft Outlook and Microsoft Office to support message signing, encryption, and asset classification requirements in C#.NET and Ribbon XML
• Implemented setup scripting and deployment packaging in Microsoft Visual Studio, ClickOnce, and Inno Studio Setup, with C# Authenticode certificate registration logic
• Optimized a web form layout tool in PowerPoint with VBA macros to layout custom controls via a dynamic ASP.NET rendering engine
• Used C#.NET, Windows Power Shell, and Exchange Management Console to create remote test-driven LDAP query and email system scripting routines

SmallTalk to .NET Conversion Architect

Designed a dynamic WPF forms engine to replace the legacy Assets, Institutions and Pricing application originally written in VisualAge SmallTalk .

• Devised a means to automate capturing of windows form layout coordinates from screens running in the legacy AIP application
• Prototyped a Windows Forms proof-of-concept rendering screens encoded in the capture process
• Researched and prioritized available technologies and growth patterns within Northern Trust to ensure internal compatibility and maintainability with present data virtualization strategies
• Invented Data-View-Controller (DVC) architecture to obviate massive domain models
• Introduced test-driven development of data methods to the project's database lead
• Constructed a WCF service layer for DB2 table data and screen metadata in ADO.NET supporting late-binding to COBOL procedure parameters via DataDirect Connect drivers
• Managed evolving form metadata in Microsoft Excel with VBA macro automation
• Delivered dynamic client rendering functionality in Windows Presentation Foundation using common control interfaces, reflection, standard XAML and Infragistics NetAdvantage WPF controls
• Implemented static WPF MVVM (Model View ViewModel) controls, models and custom bindings to facilitate ongoing offshore design initiatives

Senior Web Developer

Enhanced and maintained features of the Physician Advisory Services portal connecting doctors to healthcare service support providers.

• Completed the eTTACH PDF upload utility with custom installer in VB.NET using the Black Ice Color Plus PDF printer driver library to enable encrypted document upload from any printable source
• Added controls and functionality to the primary DotNetNuke portal in ASP.NET, jQuery and JavaScript, with SQL Server back end scripting
• Implemented spell-check and automated text functionality on ASP.NET pages using JavaScript, AJAX, JSON and custom handlers with the Keyoti RapidSpell Web user control library
• Designed and developed extensible realtime portal-based communication features for the Physician Advisory Services site
• Introduced continuous integration and test-driven development best practices to both local and offshore developers, collaborating through Webex web conference sessions

Consulting Programmer-Analyst

Migrated web forms, web services, database objects and source code to Windows Server 2008 servers for the Web Applications Development group.

• Built VMWare developer workstation virtual machine images for SQL Server Integration Services, IIS and FTP roles, Subversion source control, Visual Studio 2010, Infragistics controls, and WPF / Silverlight development
• Added Active Directory user validation, request relay, and base-64 encoded attachment features to a SMTP email ASMX web service in C#.NET with custom XML serialization
• Audited and reported on FTP and web server request logs to migrate legacy sites and services from Windows Server 2000 to Windows Server 2008
• Authored SSIS data transform packages to summarize web service use, user account info, and Source Safe archive contents for data and source code migration
• Wrote Source Safe backup and time card automation macros in Excel 2010
• Designed a file and subversion archive search utility to identify source files for conversion
• Converted the ASP.NET authentication model of several websites to implement Active Directory roles
• Enhanced TSQL queries to optimize data search filters in SQL Server 2008
• Tested and fixed ASP.NET web form user interface issues in Visual Studio 2010
• Configured and documented secure FTPS file transfer requirements

Senior Web Architect

Coded and maintained eCommerce web applications for a world leader in personal development audio books.

• Designed and coded an affiliate referral sales reporting engine in ASP.NET with Fusion Charts and interactive detail, accessing Google Analytics, Lyris and DirectTrack XML web traffic data
• Created a web interface to configure promotion codes for web and email campaigns saving hours of complex data entry each week
• Wrote an MP3 customer library WCF web service for the MediaFly WhiteBox streaming audio application allowing users access to their digital content via cell phone and other web-enabled devices
• Added installment payment, terms & conditions, and digital media functionality to the shopping cart and product pages in VB.NET
• Streamlined SQL queries in Microsoft SQL Server Management Studio with version control
• Designed a single page shopping cart plug-in for AJAX-enabled user authentication, zip code lookup, and automatic cart population with components in VB.NET and C#.NET
• Setup a build server and wrote a site update utility to archive changed items by date

Consulting Web Developer

Built a web service and web content for a highly respected HR incentive rewards company.

• Coded a generic middle tier ASMX webservice to implement debit card functionality
• Supervised the implementation of card web services on five public-facing sites
• Created a custom WinForms test-driven development (TDD) module in Visual Studio 2010
• Wrote and maintained SQL queries in Microsoft SQL Server Management Studio
• Authored an innovative data-driven email reporting tool using ADO.NET, CSS and the Telerik RadEditor
• Used SQL Server Reporting Services (SSRS) to generate activity reports and awards certificates with layout defined in Microsoft RDL format
• Improved the design and functionality of web forms in C#.NET, JavaScript, CSS, AJAX, jQuery, XML and Classic ASP

Consulting Programmer-Analyst

Streamlined an RFC intranet web form system to optimize UI and data integrity concerns.

• Managed code quality and deployment considerations with Microsoft Visual Studio unit testing and TFS version control
• Reduced ASP.NET postback through AJAX implementation and JavaScript 'chunky vs. chatty' XML data population, search and validation
• Used LINQ to SQL persistence with Microsoft SQL Server for user and request data ORM
• Designed ASP.NET, JavaScript and CSS components to show / hide and conditionally validate hierarchical data structure dependencies
• Wrote Active Directory LDAP query, data encryption, and SMTP library functions in C#.NET to facilitate user data lookup, authentication, and automated email alerts
• Optimized database, email and server access through automated build scripts and loosely-coupled context-sensitive configuration
• Utilized the Infragistics WebHtmlEditor, Telerik RadGrid, and RadDock ASP.NET Web UI components for rich client interface design
• Implemented ScrumWorks and custom Projetrix project management tools to track and prioritize a backlog of system deliverables

Senior Programmer-Analyst

Designed workflow components to automate government form lockbox processing.

• Worked on the Application Service Layer team in the Treasury Services department
• Used NUnit and Rhino Mocks with Resharper for test-driven development (TDD) and defect resolution in Visual Studio with Microsoft TFS for version control
• Monitored Cruise Control continuous integration and NCover code coverage reports to resolve build issues and testing concerns related to large-scale team coding efforts
• Generated code review artifacts and managed version conflict updates with WinMerge
• Wrote and optimized a form data matching service in (Java) J2EE 1.4.3 using the Eclipse Ganymede IDE configured with TeamPrise version control, the TestNG unit test framework, and Apache Maven build plug-ins
• Implemented validation rules with XML using apache commons generic beans validation and serialized hierarchical field matching rules in the Drools and Drools.NET business rule management system (BRMS) platform languages
• Automated deployment reports and Spring.NET form mapping XML configuration using Excel macros

Reporting Programmer-Analyst

Developed internal reporting applications and process enhancements.

• Managed Agile software development projects through definition of requirements, planning and coordination of resources, coding, testing and implementation
• Worked with object-oriented design experts and completed Learning Tree .NET Best Practices and Design Patterns training, successfully implementing test-driven development, .NET generics, and common design patterns in subsequent projects
• Utilized Microsoft Test and NUnit for TDD and Resharper for code refactoring in Visual Studio with Microsoft TFS and later Subversion with Ankh for version control
• Configured CruiseControl with NAnt for continuous integration, and wrote custom remote service deployment COM components in C# utilizing Windows Management Instrumentation (WMI) and PsTools to roll-out software updates
• Wrote and implemented a nightly Edgar Online institutional ownership SEC data filing import service, web stock quote XML service and synchronization utility in C#.Net 2005 with the Infragistics UltraWinGrid control
• Used ScrumWorks, HP Mercury TestDirector, JIRA and Sharepoint Portal Server to plan and track agile project development and testing responsibilities
• Created a web-based survey automation tool in Microsoft C#.NET and ASP.NET with offline data archiving capabilities
• Utilized the Microsoft MVP (model-view-presenter) and CSLA.NET frameworks for object model, view, presentation and business rule decoupling
• Setup and customized ASP.NET content portal prototypes using the Microsoft Community Starter Kit and DotNetNuke web application frameworks
• Introduced Excel interoperability to the company's reporting client in C# to deliver configurable offshore product marketing materials
• Added compression functionality to the project framework using the SharpZipLib free open-source C# .NET library
• Automated product management and RiskMetrics spreadsheets using VBA in Excel 2003
• Researched a bug within a legacy Visual Basic 6.0 application and wrote a server-side work-around using Transact SQL in SQL Server 2000
• Wrote code generation macros to simplify NHibernate data mapping
• Developed internal reports with Crystal Reports XI and Visual Studio .NET 2005

Healthcare Systems Developer-Analyst

Hired to help develop and promote a line of healthcare billing and scheduling applications.

• Implemented and enhanced two UltraApps project management web sites using Active Server Pages and Cascading Style Sheets (CSS) in Microsoft Visual InterDev
• Produced a computer-based training course for LynxIT Solution, ASN's ASP-based handheld patient billing product using Camtasia Studio, and Adobe Premiere
• Authored an interactive interface for CD-ROM materials in C++ and Visual Basic 6.0
• Prototyped a product website using JavaScript, CSS and DHTML
• Developed a patient demographics import utility in VB.NET
• Automated Respironics sleep study reporting using VBA macros in Microsoft Word
• Developed ScheduleMax, a shift-oriented technician scheduling system using Windows Forms in Visual Basic, Microsoft Access, ADO, Crystal Reports, and the Wise Installation Toolkit

Web Developer

Volunteered to add eCommerce functionality for Twelfth Night, Chicago's longest running private black tie masquerade ball, automating ticket payment collection for over half of the guests.

• Produced soundtracks for the party's individual events in Magix Audio Studio
• Designed and maintained the CSS and eCommerce portions of the party's web site www.12thnightmasque.com
• Setup an additional collaboration portal in DotNetNuke at GoDaddy.com
• Created interactive DVD presentations of the event using Adobe Premiere
• Authored the 2007 DVD in Sony DVD Architect

Consulting Programmer-Analyst

Chosen to enhance the functionality of electronic forms, deliver online setup and registration, and recommend new technology purchases.

Impact: Accelerated results using low-overhead Agile software development, delivering data extraction, validation and export to over 4000 insurance agents.

• Authored eFactFinder, a web-based FDF data archive utility in IBASIC Professional
• Used JavaScript for field validation and FDF format data extraction in Adobe Acrobat Professional with Adobe Acrobat Reader support
• Designed web layouts in Macromedia Dreamweaver
• Added HTML form validation and navigation, web form data consolidation, and additional Acrobat functionality through JavaScript
• Worked with Access XP to provide links to Microsoft Outlook data submissions from a ColdFusion script, data backup restore functionality, decryption logic, and include file package integration for IBASIC compilation
• Managed IIS test site hosting and Agile DSDM project methodology, involving several iterations with multiple builds each day, testing rollouts over a local web, with online prioritization of feedback
• Scripted installation through WSH and workflow optimization using VBScript
• Conducted Agent laptop requirements research and negotiations
• Authored a time tracking database application, MDI Agent Workbench prototype with online web mail delivery, and background FTP proof of concept in VB.NET 2003
• Created documentation and presentation graphics using Microsoft Word, Excel, PowerPoint, Visio, Adobe Acrobat Distiller , PhotoShop, ULead Video Studio, Cool 3D, and TechSmith Camtasia Studio
• Performed graphic palette reduction and forms cleanup in ULead Video Studio
• Developed additional document merge functionality in Java, iText and PDFTK

Project Manager / Lead Programmer-Analyst

Signed on to develop and test business applications for this 40+ doctor nephrology group's billing operations in order to provide improved collections, accounting system enhancements, and patient care assessment feedback. Worked with vendors and service partners to automate over $1.7 million in supervision charges monthly and deliver regional quality improvement indicators based on third-party laboratory results. Built close working relationship with company executives and technology staff.

Impact: NANI has enjoyed uninterrupted cash flow, with over 50% of charge revenues generated through automated processes despite numerous internal and industry-wide changes in medical billing practices.

• Coded transaction modules working with Micromed NextGen EPM and top service partners for Electronic Data Interchange
• Developed HIPAA-compliant cross-platform portable data collection solutions in AppForge Mobile VB for PalmOS and PocketPC PDA devices under the guidance of the corporate technology committee
• Managed several code sets to ensure the proper formatting of NSF and HIPAA X12N 837 electronic insurance claims and paper forms in Visual Basic 6.0, VB.NET, Access 97 / XP, and SQL Server 2000
• Adapted explanation of benefits imports to the X12N 835 electronic remittance specification
• Wrote encryption algorithms in Microsoft Access VBA, ActiveX, J2SE, and 4th Dimension
• Automated spreadsheets for an accounts reconciliation database tying together account activity, cash posting, and remittance to provide an accurate daily snapshot of cash on hand
• Created a payroll system which imports time clock data from an Oracle 8i database, supports timesheet entry, and calculates salary/wage disbursements with paid time off accrual
• Outsourced the nephdocs.com website and trained staff in HTML design

Consulting Programmer-Analyst

Hired to help the proprietor of a musical instrument refurbishing business simplify eCommerce operations.

Impact: Reduced development costs by 75% while enabling more timely site updates.

• Wrote an instrument tracking system to update the inventory web page HTML and graphics for internationalwoodwind.com
• Tutored the owner in the use of FrontPage98 and FTP programs, and provided system upgrades

Consulting Programmer-Analyst

Worked with a team of 9 technology consultants to provide billing, reporting and statistical analysis solutions for a major US healthcare service provider.

Impact: Enhanced efficiency and stability of dialysis operations which lead to a lucrative buy-out offer from Fresenius Medical Care, North America.

• Wrote a lab results quality core performance indicators ETL system in MS Access and SQL-Server, Crystal Reports using the ProEssentials Graph and PKWare PKZip control libraries
• Implemented Visual SourceSafe version control and TotalAccess Analyzer testing
• Created a dialysis facility statistical analysis utility that interfaces two Baxter databases
• Coded accounting transaction modules for a medical supply inventory database
• Automated patient billing business processes with insurance verification and contractually adjusted charges for accurate accounts receivable totals

Consulting Programmer-Analyst / Phase One Design Team Principal

Collaborated with a group of over 50 contractors on an automotive insurance marketing application for Nationwide Insurance.

Impact: Consultants at Ernst & Young provided an extensible object-orient database system to run in all Nationwide Insurance call centers.

• Participated in initial business system specifications, custom control architecture, project management, and test interface deployment using the PowerSoft PowerBuilder 5.0 object-oriented fourth generation language (OOP 4GL) integrated development environment against an Oracle8 RDBMS
• Designed and scripted test applications using PowerBuilder, Visual Basic 5.0, AutoDesk 3D Studio, Adobe PhotoShop 4.0, and Rational Visual Test
• Used Lotus Notes as a project tracking database, and PVCS for version control
• Documented system features for roll-off to Nationwide?s internal development team

Manager of Technical Support / Database Administrator

Lead the technical support team for CD-ROM game customers in Windows 95, DOS 5.0 and Macintosh System 7.5 while developing database and marketing skills.

• Designed and maintained SQL Server and MS Access relational databases
• Used Visual Basic 4.0, Crystal Reports, Borland C++ and macros within Excel spreadsheets for data analysis and technical support systems
• Incorporated Adobe Premiere non-linear video editing, PhotoShop, 3D Studio, Microsoft Quick Basic, Excel, and Word in the design of marketing presentations and database projects

Reporting Representative

• Prepared account level financial reporting in Microsoft Excel 3.0 - 5.0
• Supervised synchronization of customer data on an AS400 WAN connection
• Used FOCUS and Informix with Microsoft QBASIC to parse and summarize data output from internal DEC VAX VMS and IBM CICS reporting applications
• Authored interactive quarterly report generation software in Visual Basic 2.0
• Wrote instruction manuals and on-line tutorials to document processes

Management Information Systems

Served as member of the inventory systems conversion team responsible for keying product inventory data, generating bar-coded SKU tags from a custom Prime Computer database, and providing systems training to the Guitar Center sales force.