Gregory Muench Email & Phone Number

Canandaigua, NY, US

Rochester, New York, US

Bellevue, Washington, US

• Designed several large and complex geo-spatial database systems that stored imagery, building outlines, and geo-located attributes derived from imagery by machine learning. First in Oracle, then migrated to Postgres.
• Architected databases combining Postgres (AWS Aurora) and DynamoDB used by our Graph system.
• For Postgres, utilized PostGIS spatial extension for geography data and partitioned with geohashes for speed and scalability and maintainability.
• Wrote PSQL functions to handle partitioning and for ingesting data and retrieving data geo-spatially.
• Used Sqitch for database change management and deployments
• Extensive use of FME to transform data for a data-driven workflow and customer reports.

US

• Architected, coded (C# and T-SQL) then managed 5+ software engineers in the development of enterprise GIS (Geographic Information Systems) applications that enable the design and deployment of a BPL (Broadband over.
• Collaborated with power distribution engineers. Data repository was SQL Server 2000. The database held tens of millions of records used to depict the power distribution network and the BPL network on top of it.
• Developed import and conversion scripts to pull in power company data on a monthly basis into our database using DTS and T-SQL.
• Produced automated shape file overlays using FME (Safe Software)
• Created dynamic overlays with shapelib and MapWinGIS.
• Led development of 5 GIS applications: Design Tool (desktop app), Deployment Zone (web app), Pole Search (web app), Site Survey (mobile CE), Work Order (web).

• Re-factored, optimized and enhanced a multi-level marketing (MLM) cigarette sales commission engine in T-SQL.
• Optimized the commission engine process that used to run daily for 17 hours down to just under 1 minute.
• Fixed programming defects that caused over $300K worth of annual commission inaccuracies.
• Enhanced online ordering web site using ASP, VB script, and Javascript.

Fairport, New York, US

• Enhanced desktop and web application and database.
• SQL Server stored procedures, Crystal Reports, C#, XML data islands and XSL transforms.

• Developed three-tier application model for Warehouse Management System (WMS)
• SQL Server, Transact-SQL stored procs, VB6, ASP.NET, C#, Data Dynamics Active Reports

• Project team leader, managing 3+ developers, responsible for Bill of Material (BOMCenter) application.
• Developed web solution using ASP.NET, C#, VB.NET, COM, SQL Server 2000, and Crystal Reports 8.5.