BOB GROMMES |
SOFTWARE ARCHITECT / DEVELOPER | ITHACA, NY |
480-540-6317 | bob@bobgrommes.com |
bobgrommes.com | linkedin.com/in/bobgrommes |
TECHNICAL SKILLS
Microsoft .NET platform | C# | VB.NET | ASP.NET | ADO.NET | Windows Services | SQL Server | Python | PHP | TypeScript
EXPERIENCE
Software Architect / Team Lead | Ansonia Credit Data, delivering real-time BI for a global clientele 2008 — 2020; 2020 to present as acquired subsidiary of Equifax Corp |
— Designed custom ETL platform that scaled to handle hundreds of data contributors with minimal human intervention. The system processes millions of records per month in real time
— Built rule-based engine for standardizing business names and addresses, including custom hygiene for removing extraneous notations, standardizing beyond postal requirements and more. Created tools for offloading significant data QA work to non-developers. Optimized to a cached in-memory system to relieve pressure on the production database
— Created industry-leading quality assurance practices and business rule implementations that resulted in detecting inconsistent or inaccurate data that is missed by competitors
— Implemented real-time proprietary credit risk score that provides predictive rather than reactive payment performance ratings
Software Developer, Cortera.com, integrating acquired technology into a unified whole
2007 — 2008
— Transitioned legacy code to client’s platform
— Performed analysis and created custom ETL code development for new data formats and sources
Lead Software Developer, Global Database Marketing, modernizing a CRM code base
2002 — 2004; part time through 2007
— Ported and upgraded existing database and CRM software and transition tools to the .NET platform. Designed an ORM. Hired, trained and supervised developers for this project
— Designed and built data conversion components supporting many proprietary raw data formats
— Redesigned mail prep system, integrated tools from a new vendor and eliminated complex, error-prone tasks using COM interop to vendor API
— Created scripts to support new digital color press system using a proprietary scripting language based on C++
— Managed outside team producing a content-management system
— Led crash project to support special data processing requirements of large new client
Lead Software Developer, The Credit Exchange Inc, building an innovative credit service
1997 – 2001
— Helped transform the fledgling commercial credit reporting industry
— Corrected a stalled initial product design and proof of concept, bringing it to rapid completion
— Built a bulk data intake and QA system, and assisted with website development for one of the few internet startups of the pre-2000 era that had a viable business plan, paying customers and profits
— Used classic ASP, SQL Server and FoxPro
— Helped build the company to become a successful acquisition by eCredit
Independent Consultant, Bob Grommes Consulting, serving the needs of a diverse client base
1983 — 1996
— Built software for a range of problem domains, including typesetting, warehousing, manufacturing planning, accounting and inventory management
— Authored software developer training courseware and taught seminars in various cities
— Served as technical editor of a developer monthly, including author recruitment and development
— Co-authored three books (lead author for two) on software development, produced articles for developer magazines and spoke at developer conferences
— Recruited and worked with teams of full-time subcontractors
— Ran full-time consulting practice throughout this period