Download resume

 

 

 

John Nuechterlein

 

2245 West School St, #2, Chicago, IL 60618 ● (773) 791-9139 ● kingcrim@earthlink.net

 

 

Certifications/Degrees/Web Sites:

§  Certified ScrumMaster

§  MCP (MCSD.NET track)

§  MCSE (NT)

§  Ph.D., M.A., B.A. (Philosophy)

§  Brainbench : C#, SQL Server 2000 Admin

·         Official Transcript:

·         http://www.brainbench.com/xml/bb/transcript/public/viewtranscript.xml?pid=4721961

§  Crescendo Technologies: http://www.crescendotechnologies.com

§  Chicago Alt.Net User Group: http://chicagoalt.net

                                         

Skills:

§  Languages: VB, C#, JavaScript, T-SQL

§  Architectures: SOA, Data-driven Web Applications, Client/Server, n-Tier, Asynchronous messaging

§  Databases/Platforms: SQL Server 2005-2014, MySQL, Microsoft Office Sharepoint

§  Data Access Technology: Entity Framework, LINQ to SQL, NHibernate, Enterprise Library, WORM, ADO.NET, T-SQL, DTS, SSIS

§  Methodologies: Agile, TDD, Waterfall, Kanban

§  Programming Principles : SOLID, DRY, YAGNI, CQRS

§  Source Control, Unit Testing and Build Management: StructureMap, MOQ, Rhino Mocks, Git, NUnit, Visual Source Safe, Team Foundation Server,Subversion, Nant, Visual Studio Team Suite, Draco.Net, Rational ClearCase, PVCS

§  Web Technologies: WCF, ASP.NET, ASP.NET MVC, JavaScript, JQuery, CSS, HTML, XHTML, SCSS, Highcharts

§  Other Technologies: AutoMapper, Active Directory, DNS, DHCP, WINS, RAS, TCP/IP, SSL

§  Financial tools: Advent, Fiserv, Compustat, Fundamental Analytics, LIM, RTT

Experience:

                               

ABN Amro , Chicago, IL                                                                                            June 2014 to Present

Sr. .NET Architect/Developer/Analyst

·          Contract position – Contracted through Crescendo Technologies

·          Overall main focus of work: design, develop and maintain systems to run and support clearing system activities

·          Interface with local and global teams to manage critical global business systems

·          Help to design and implement Kanban management systems and processes

·          Full project lifecycle management: requirements gathering with key stakeholders, project management (documentation, tracking), development and testing

·          Design and implement dividend processing and allocation processes

·          Technologies used: C#, FIX/FIXML, SQL, MSMQ, MQ, Great Plains, AutoMapper, Windows Workflow, Entity Framework

 

 

BP Amoco , Chicago, IL                                                                                            May 2012 to May 2014

Sr. .NET Architect

·         Contract position – Contracted through Crescendo Technologies

·         Overall main focus of work:  design, develop and maintain commodity pricing tool used by traders and analysts to make trading decisions

·         C#/SQL architecture.  Javascript, JQuery, CSS, SCSS.  Entity Framework, LINQ to SQL, custom data access, TFS/VSS, Highcharts

·         External data feeds from Morningstar.Internal data feeds from Asset Control.Both interface with pricing tool through LIM

·         Full project lifecycle management: requirements gathering with key stakeholders, project management (documentation, tracking), development and testing

·         Introduced Kanban Software Development methodology to development team.  Used Kanban board to manage internal development work.

·         AutomatedWatinintegration test suite

·         Write reports for web based cash reconciliation tool (CMT), Javascript, CSS

 

 

Northern Trust , Chicago, IL                                                                               August 2009 to May 2012

Sr. .NET Architect/Team Lead

·         Contract position – Contracted through Crescendo Technologies

·         Overall main focus of work:  design, develop and maintain processes used by trading system, largely interfacing between Advent's Advent Portfolio Exchange (APX) and Fiserv's Upstream platform.

·         Team Lead

·         Determine cost and time estimates for development tasks and large projects

·         Distribute work to other developers on team

·         Mentor and manage development process

·         C#/SQL architecture.  Rewrote existing systems interfacing with APX, and implemented new systems to do the same. 

·         ETL processes that perform full life-cycle handshake between Advent and Fiserv (Advent to Fiserv, then Fiserv back to Advent).

·         Introduced Kanban Software Development methodology to development team.  Received senior management approval to introduce methodology to trading team.  Using Kanban board to manage internal development work.

·         Northern Trust generally uses traditional waterfall practices, but individual aspects of various work has used some agile practices, such as TDD, pair programming, and Kanban.

 

·         Heterogeneous environment:

Code/Server: : Java, C#, Oracle, SQL Server, MQ, TFS

Trading systems: FiServ, APX, RTT

·         Upgrade trading support system from .NET 1.1 code to .NET 3.5.

·         Ongoing application functionality enhancements to support business growing at 20-30% annual rate

·         Introduce SOLID principles

·         Introduce Specification style automated testing

·         Introduce Kanban Software Development methodology

·         Interface with business partners for requirements gathering

·         Mentor junior developers

·         Troubleshoot environment issues

·         Troubleshoot production support issues

 

 

JP Morgan Chase, Chicago, IL                                                                              July 2007 to June 2009

SQL/C#/ASP.NET Developer/Architect

·         Contract position – Contracted through Crescendo Technologies

·         Overall main project: work on staged upgrade releases to their PaymentNet CommercialCard Web application, used by large corporations and various departments of the US government

·         C#/SQL/ASP.NET web forms architecture.  Worked on all aspects of the architecture, sometimes as a developer, sometimes in an architectural role, sometimes both.  Worked full end-to-end process, from requirements gathering to design to coding to implementation to post migration validation.

·         JPMC generally uses traditional waterfall practices, but individual aspects of various staged releases used some agile practices, such as TDD.

 

·         C#

o    Business tier and data tier code

o    Solid Principles

o    Ability to use different data access systems (ADO.NET, Enterprise Library, Custom ORM)

o    Console application for file processing

§  SQL

o    Multi TBdatastore

o    DTS and T-SQL for external file loading

o    Daily loading of large external text files into OLTP system

o    Triggers for audit trail processing and business logic

o    Smart processing to ensure only desired data changes are logged to the audit system

o    Stored procedures based data access

o    Use of XML datatype to pass in strongly typed objects for business logic processing

o    Custom ORM framework

o    Combine dynamic SQL with stored procedure and view support

o    SSIS Conversion

·         Conversion of existing Employee Import DTS package to DTS

·         Conversion of Active X Script to Script Component

§  ASP.NET

o    Web-forms application using custom asynchronous n-Tier framework

o    Code-behind passes down through business and data tiers

o    JavaScript for client-side code

o    Input validation based on business requirements

o    508 compliant design

o    All pages designed to meet federal accessibility requirements

o    Custom server controls

o    Standard .NET controls extended for additional functionality, such as automatic regex validation on input

o    Data-driven page design

o    Custom system to generate placement of controls from a data-driven perspective

§  Other

o    Manage offshore resources

o    Full end-to-end design process, from functional specification gathering to design to build to QA testing to production deployment

 

 

Calamos , Lisle, IL                                                                                             January 2005 to June 2007

SQL Data Architect/C# Developer/Architect

§  Contract position – Contracted through Crescendo Technologies

·         Overall main project: convert existing ETL process from CompuStat Research Insight product to use CompuStat XpressFeed product.

·         Feed pulled in company market data fundamentals from CompuStat and fed them into internal systems which Calamos used to determine trading strategy on individual assets.

·         C#/SQL architecture, designed and then implemented by me. 

·         Calamos generally uses traditional waterfall practices, but individual parts of the overall project were implemented using standard agile practices, such as TDD, pair programming, and iterative development.

 

·         C# Developer/Architect

o    Various Windows Forms Applications

§  DPM – used to view and manage alerts produced by in-house built Perl-based monitoring system

§  Dataguard – used to view and manage data points flagged by in-house built Per-based data cleansing system

o    Various technologies and methodologies used

§  Typed datasets and OR/M

§  Infragistics controls

§  Traditional waterfall and TDD/Agile development

§  N-tier architecture

·         SQL Architect

o    XpressFeed (S&P product)

o    Phase one (promoted to production 1/2006)

§  Build new ETL system to move data from vendor product into internal FoxPro and SQL databases

§  Mimic processed data provided by Research Insight (other S&P product), transforming raw XpressFeed data

§  Work with S&P to design calculations implemented in UDFs

§  Hand-generated T-SQL script for data transformation into staging database

§  Use of Linked Server technology to match vendor data with existing data in SQL systems

§  Use of FoxPro loaders to move transformed XpressFeed data into FoxPro systems

§  Provide data for new internal systems developed after phase promotion completed

o    Phase two (promoted to production 5/2007)

§  Implement new system based on redesigned vendor data schema

§  SQL-based metadata driven system for high configurability

§  C#-driven code generation of T-SQL scripts for data transformation into staging database

§  Use of SSIS to load production

§  Implement delta processing on top of vendor system

·         ETL Vendor Analysis

o    Analysis of BizTalk and Informatica products in comparison to existing in house processes

o    Side by side comparison of BizTalk orchestration versus existing scripted solution

o    Analysis of Informatica against the enterprise wide needs of the business

·         Data Model Architect

o    New Enterprise Data Model designed to replace entire existing FoxPro system

o    Help with managing data requirements across all business functions

o    Meetings with each specific business function to determine specific needs and requirements

o    Research existing FoxPro system to determine requirements for ETL from that system to new Data Model

o    Analysis of all existing FoxPro tables and existing client applications that hit those tables

o    Use of Visio Enterprise Architect to transform database diagrams from multiple designers into consolidated database schema in SQL Server 2000

o    reverse engineer existing FoxPro and SQL Server tables to provide view into current schemas

 

 

                               Jones LangLasalle                                                                    Westmont, IL 11/2004 to 12/2004

                                        .NET Developer

§        http://www.joneslanglasalle.com – a real estate services and investment management firm

§  Contract position – Contracted through Crescendo Technologies

§  Bug fixes and enhancements to a financial returns calculation system built on ASP.NET and VB.NET, running against SQL Server 2000 with Analysis Services and Web Services

§  Create and update VB.NET code to implement fixes and enhancements

§  Add/modify MDX queries to allow for additional return parameters

§  Add/modify VB.NET-wrapped JavaScript functions

§  Fixes and enhancements to the UI

§  T-SQL and stored procedure enhancements

§  Create Analysis Services installation document

 

                               Lucent                                                                                                Lisle, IL 07/2004 to 9/2004

                                        System Architect/Senior Analyst

§        http://www.lucent.com – a communications networks company

§  Contract position – Contracted through Crescendo Technologies

§  Upgrade legacy VB 6 Windows form/ VB.NET 1.0 Web application using text files to VB.NET 1.1 using SQL Server 2000

o    Create VB.NET Windows form to load existing text files into SQL Server

o    Create VB.NET Windows form to extract data from text files into new table design

o    Update Web application:

§  Update code to access SQL instead of text files

§  Improve efficiency of existing code by rewriting according to standard best practices

·         Eliminate unnecessary if-then structures

·         Eliminate unnecessary code looping

·         Eliminate redundantdata access calls

o    SQL Server 2000:

§  Add new table structure to existing database using standard best practices

§  Begin redesign of existing table structure

·         Rename columns to reflect data consistently across tables

·         Add keys and indexes

o    Assist other team members in rewriting VB 6 applications to access data in SQL instead of text files

 

                               UOP                                                                                         Des Plaines, IL 12/2003 to 6/2004

                                        System Architect/.NET Developer        

§        http://www.uop.com – a refinery technology company

§  Contract position – Contracted through Crescendo Technologies

§  Upgrade legacy VB 6 Windows form application using Access 97 to C# ASP.NET web application using SQL Server 2000

o    Flesh out technical user requirements from higher level user requirements

o    Extensible base object written in C#

o    Objects passed through session state based on XML Serialization

o    Customized Microsoft Application Blocks used: Data Access Version 2, Exception Handling, Configuration

§  Write Exception handling class to write error information to Event Viewer Log and SQL Server 2000

o    Utilize User Controls and CSS for consistent page appearance

o    Utilize DataGrid, DataList for data display

o    Architect SQL Server database solution

§  ‘From scratch’ table design

§  Standard best practices:

·         Data access based solely on stored procedures and Data Access Application Block

·         Enforce primary and foreign key requirements on all tables necessary

·         Clustered Indexes on all primary keys, indexes on all foreign keys and commonly searched columns

 

                               Crescendo Technologies                                                               Chicago, IL 1/2003 to Present

                                        Founder/System Architect/.NET Developer

§  This is the consultant company I created to fulfill client contracts that are desired corp-to-corp, as well as other projects

§  Athletics International, Inc.

o    Design and build Retail/eCommerce transactional software system using VB.NET and C#, ADO.NET, SQL Server 2000, MSMQ, COM+, XML Serialization

§  VB.NET and C# ASP.NET Web Forms using code-behind files

§  Extensible base object written in VB.NET and inherited by VB.NET and C# classes

§  Objects passed through session state based on XML Serialization

§  Data access based on modified version of Microsoft Data Access Application Block

§  Utilize User Controls and CSS for consistent page appearance

§  Utilize DataGrid, DataRepeater for data display

§  Utilize caching for improved performance

§  Write Exception handling class to write error information to Event Viewer Log and SQL Server 2000

§  Data access based solely on stored procedures

§  Enforce primary and foreign key requirements on all tables necessary

§  Clustered Indexes on all primary keys, indexes on all foreign keys and commonly searched columns

§  Implementation of Windows 2000, IIS 5, MailEnableStandard environment

o    Design PHP forms hitting a MySQL backend

§  Create PHP forms to track customers for future marketing efforts

§  Use phpMyAdmin to administer MySQL database

§  SpunLogic

o    Use .NET classes as a remoting bridge between ColdFusion web front and Pervasive DB backend

o    Financial services client required reporting pages for sensitive financial data

o    ColdFusion development team required a COM+ package that sat on web server with no direct access to Pervasive SQL database server that it could query, no in-house skill set to build

o    Middle-tier server with access to Pervasive DB server through a mapped drive

o    COM+ object needed to be seen as VB 6 object

o    Used .NET remoting and VB 6/.NET interop to fulfill requirements, utilizing XML Serialization

§  SST

o    Fully featured eCommerce shopping site

§  Built using .NET 4.0 and 4.5

·         Use of dynamic for Excel interaction

·         Use of async for CQRS commands

§  Built using Asp.NET MVC 3 Razor

§  Use of SQL Server 2008 as its persistence backend

§  Built using CQRS principles

·         Internal message bus system for commands and events

·         Fully persisted command store

·         Fully persisted event store

 

                              Styleclick                                                                                         Chicago,IL 3/2001 to 3/2003

                                        Advanced Technology System Architect

§  Full-Time position

§  Develop and implement .NET applications using managed SQL Data Provider and SQL Server 2000, MSMQ, COM+ Transactions using Enterprise Services, Multi-Threading, Forms and Windows Authentication, Web Services, VB.NET, C#, ADO.NET

o    Upgrade existing VB6 form executable to ASP.NET Web Form to manage the process of maintaining 50,000+ images across the image farm for improved scalability and reliability

§  Utilize DataGrid, DataRepeater for data display

§  Utilize User Controls and CSS for consistent page appearance

§  Utilize caching for improved performance

o    Implement SQL Query Analyzer functionality from an ASP.NET Web Form

o    Implement Event Viewer functionality from an ASP.NET Web Form                                                  

o    Begin building of Operations Suite Web Site

§  Manage movement of all ASP pages across web farm, utilizing SQL Server 2000 and MSMQ

§  Web-based site build functionality, to end requirement of manually building on each web server

§  Manage movement of all production images, utilizing SQL Server 2000 and MSMQ

§  Project and Technical Lead for upgrading environment from NT 4 /SQL Server 7 to Windows 2000/SQL Server 2000

o    Engage Microsoft Technology Center in 2 week project to fix initial performance degradation of 35%, improve to 1000% performance improvement by modifying COM+ JIT activation settings on individual COM+ packages

o    Develop and implement web server upgrade procedure from NT 4/IIS 4 to Windows 2000/IIS 5 with no down time for client web sites

o    Design and test SQL Server upgrade procedure

o    Project manager for all affected areas:

§  Work with Application Development team to implement improvements to build process to implement advanced COM+ JIT Activation settings

§  Work with AppDev team to fix cryptography class to work with Windows 2000

§  Work with Cryptoswift Vendor to fix SSL Hardware Accelerator driver memory leak

§  Work with DBA team to improve downtime required for SQL Server upgrade

§  Work with all other teams to inform them of client communication requirements for upgrade procedures, including call center

o    Negotiate Microsoft licensing terms with vendor

o    Resulting performance improvement saved need for $2.1 million in hardware costs

§  Implement Image Farm Architecture

o    Remove need to maintain images across 25+ web servers by implementing a 3 server image farm

o    Work with Creative team for ASP page changes required for implementation

§  Implement Portal Server Farm Architecture

o    Upgrade architecture to allow for multiple servers to serve internal Portal Server farm for reporting, customer service, vendor fulfillment, and merchandizing across all clients, stakeholders and independent vendors

§  Manage and then transition to new hire the production and office server environment to support the eCommerce web sites of NHL, NBA, PGA, CBS Sportsline, and NASCAR

o    Manage 1st, 2nd and 3rd shift operations employees

o    Manage DBA team

                               

                               MVP.Com/BigEdge.Com                                                                                       Chicago, IL 6/1999 to 3/2001

                                        Operations Manager/System Engineer                                                                                                                              

§  Full-Time Position

§  Architect, design, and maintain 50+ server multi-domain NT network to support eCommerce sites for MVP/BigEdge, CBS Sportsline, MLB, PGA, iGoGolf, PlanetOutdoors

o    SQL 7 Enterprise Edition running on Microsoft Cluster Server

o    Load Balanced web farm or 25 servers, running behind BigIP and then Foundry load balancing hardware

o    Write and run test scripts using Microsoft Homer for IIS performance and scalability testing and enhancement

o    Use XTune to tune IIS metabase settings for enhanced performance

o    Work with Application Development team to tune COM settings for enhanced performance

o    Develop SQL Server replication topology

o    Maintain in-house page generation servers

o    Work with Compaq and Microsoft on various troubleshooting issues

§  Responsible for 24/7 uptime of all web sites, running IIS and Site Server Commerce Edition 3

o    Develop and implement site build process

o    Develop SQL ad-hoc queries to highlight site errors

o    Run SQL Profiler to highlight long running queries for DBA and AppDev team to tune

o    Develop Performance Monitor views for real-time performance monitoring

o    Develop paging schedule for 24/7 support

o    Re-create replication topology after critical failures

o    Monitor site performance during peak events (including John Elway mentioning MVP.Com during Super Bowl telecast, MLB playoffs, MVP.Com commercial broadcasts during CBS NFL telecasts)

§  Manage 2nd and 3rd shift operations employees

§  Manage SSL certificates for all sites

§  Design and implement network security policies

o    Work with Network Engineer on network hardware security

o    Harden IIS to prevent common security flaws

§  Work with Microsoft on initial migration tests to Windows 2000

§  Work with Unisys on initial migration tests to their ES7000 32-CPU Enterprise Server

§  Work over a dozen 24 hour shifts, as well as 7 days a week to ensure critical launch date success

 

                               Kenneth-LianCorporation                                                                                                            Miami ,FL 2/1999

                                        Consultant

§  1 month contract

§  Design and install of Office LAN for day trading financial company

§  BackOffice NT 4 running IIS 4, Exchange Server 5.5, Microsoft Proxy Server 2.0, Windows 98 clients, Ascend Pipeline ISDN router   

 

                                         UIS, Inc.                                                                                                                         Miami ,FL 11/1996 to 8/1998

                                        MIS/HR Manager

§  Full-Time Position

§  Design, installation and management of Windows NT 4 Network, running Exchange Server 5.5, IIS 4, WinProxy 2.0, Marketwave HitList Standard Edition 3.0

§  Migrate Access 95 database to SQL Server 7.0

§  Migrate mixed Novell/NT network to pure NT environment, including migration of IPX to Tcp/IP

§  Develop and maintain Corporate web site using IIS 4, Front Page 95, and Visual Interdev 1.0

§  Negotiate all telecommunications contracts, including data and voice

§  Program and manage Nortel Norstar KSU phone system with 4 port StarTalk Flash voicemail

§  Control and administer Human Resources Department, including payroll, insurance, and legal issues

o    Correct overtime reporting

o    Select health/dental insurance coverage

o    Run ADP and CompuPay payroll software

o    Upgrade Time Clock hardware and software

§  Manage receptionist team

                                         

                                         Various Universities                                                                                                               FL 1/1995 to 12/1996

                                        Adjunct Professor

§  Instruction of various state mandated core curriculum courses in Philosophy

§  Received consistently high student evaluations while maintaining high standards

§  Presented a paper at the Eastern Division of the APA in Pittsburgh (Spring 1997)

§  Taught at University of Miami , Florida Atlantic University, Florida International University

 

                                         

                 

Education:             University of Miami                                                                                                              Coral Gables , FL

                                         Ph.D. and M.A. in Philosophy                                                                                                                 June 1995

§  Graduated with Honors

 

                                         University of Houston                                                                                                                  Houston , TX

                                         B.A., Philosophy                                                                                                                                             May 1991

§  Graduated Magna Cum Laude with Honors

§  Wrote A Ghost Story, a fictional novel, Honors Thesis