Download
resume in Word 2003 format
John Nuechterlein
3505 North Claremont, #1,
Certifications/Degrees/Web Sites:
§
Ph.D., M.A., B.A. (Philosophy)
§
MCP (MCSD.NET track)
§ MCSE (NT)
§
Brainbench: C#, SQL Server 2000 Admin
·
Official Transcript:
·
http://www.brainbench.com/xml/bb/transcript/public/viewtranscript.xml?pid=4721961
§ Crescendo Technologies: http://www.e-Crescendo.com
§ Chicago Alt.Net User Group: http://chicagoalt.net
Skills:
§
Languages: VB, C#, ASP .NET, JavaScript,
T-SQL
§
Architectures: SOA, Data-driven Web
Applications, Client/Server, n-Tier, Asynchronous messaging
§ Databases/Platforms: SQL Server 2005-2008, MySQL, Microsoft Office Sharepoint Server 2007
§
Data Access Technology:
LINQ to SQL, NHibernate, Enterprise Library, WORM, ADO.NET, T-SQL, DTS, SSIS
§
Methodologies: Agile, TDD, Waterfall, Pull
§
Programming Principles:
SOLID, DRY, YAGNI
§
Source Control, Unit Testing and Build Management: Visual Source Safe, Team Foundation Server,
Subversion, Nant, Visual Studio Team Suite, NUnit, Draco.Net,
Rational ClearCase
§
Web Technologies:
XML, JavaScript, CSS, HTML, XHTML
§
Other Technologies:
Active Directory, DNS, DHCP, WINS, RAS, TCP/IP, SSL
§
Emerging Technologies:
ASP.NET MVC, Azure
Experience:
Northern Trust
Chicago, IL 8/2009 to 12/2009
Sr. .NET Architect
§
http://www.northerntrust.com/
– personal and institutional financial services
§
Contract position – Contracted through Crescendo Technologies
§
Develop and architect support for internal trade support system
§
Heterogeneous environment
o
Code/Server: : Java, C#, Oracle, SQL Server,
MQ
o
Trading systems: FiServ, RTT, Charles River
§
Upgrade .NET 1.1 code to .NET 3.5.
§
Introduce SOLID principles
§
Introduce Specification style automated
testing
§
Troubleshoot environment issues
§ Troubleshoot production support issues
JP Morgan Chase Chicago, IL 7/2007 to 6/2009
SQL
Data Architect/C# Developer/Architect
§ http://www.jpmorganchase.com –
an asset management company
§ Contract position – Contracted through Crescendo Technologies
§
Design/Develop/Architect
support for PaymentNet Commercial Card Enterprise Web
Application
§ C#
o Business
tier and data tier code
§ Programming
to interfaces and other modern programming techniques
§ Ability
to use different data access systems (ADO.NET, Enterprise Library, Custom ORM)
o Console
application for file processing
§ SQL
o Multi
TB datastore
o DTS
and T-SQL for external file loading
§ Daily
loading of large external text files into OLTP system
o Triggers
for audit trail processing and business logic
§ Smart
processing to ensure only desired data changes are logged to the audit system
o Stored
procedures based data access
§ Use
of XML datatype to pass in strongly typed objects for
business logic processing
o Custom
ORM framework
§ 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
§ Code-behind passes down through business and
data tiers
o Javascript for client-side code
§ Input
validation based on business requirements
o 508
compliant design
§ All
pages designed to meet federal accessibility requirements
o Custom
server controls
§ Standard
.NET controls extended for additional functionality, such as automatic regex validation on input
o Data-driven
page design
§ 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 1/2005 to 6/2007
SQL
Data Architect/C# Developer/Architect
§ http://www.calamos.com – an asset management
company
§ Contract position – Contracted through Crescendo Technologies
§ 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 (DPM) and OR/M (Dataguard)
§ Infragistics controls (both)
§ Traditional waterfall (DPM) and TDD/Agile
development (Dataguard)
§ N-tier architecture (both)
§ SQL Architect
o XpressFeed (S&P product)
§ 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
§ 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
§ 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
§ 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
§ reverse
engineer existing FoxPro and SQL Server tables to provide view into current
schemas
Jones Lang Lasalle
.NET Developer
§ http://www.joneslanglasalle.com – a real estate services and investment management firm
§ 2 month contract position
§ 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
§ 3 month contract position
§ 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 redundant data 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
System Architect/.NET Developer
§ http://www.uop.com – a refinery technology company
§ 6 month 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
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
Styleclick
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
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
§ Work over a dozen 24 hour shifts, as well as 7 days a week to ensure critical launch date success
Kenneth-Lian Corporation
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.
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
§ Taught at
Education:
Ph.D.
and M.A. in Philosophy June 1995
§ Graduated with Honors
B.A.,
Philosophy May 1991
§ Graduated Magna Cum Laude with Honors
§ Wrote A Ghost Story, a fictional novel, Honors Thesis