Bob Kilmer Email & Phone Number

United States

Support and maintain Smallworld GIS geospatial asset management system and PowerOn Restore outage management system.Evaluate and refine current business processes.Prepare work and budgetary estimates for business and technology projects.Plan and communicate specific work tasks for database creation and management, application development, and ongoing maintenance.Act as Project Manager (PM) for various GIS projects.Oversee outsourced vendor services.Integrate electric utility data into geospatial maps.Reports problems or deviations associated with environmental issues and the Environmental Management System (EMS) to the Environmental Department.

Subject matter expert (SME) for business-critical Certegy Check Services applicationsLead developer for expert systems, client-server applications, and databases supporting financial risk management, payment processing, consumer credit reporting, and call center functionsAnalyzed data to identify trends, support business decisions, monitor regulatory and procedural compliance, and assure ongoing data integrityDeveloped and automated reporting for the benefit of business analysts, regulatory compliance analysts and managers using SQL, Oracle. PL/SQL, TOAD, SSRS, T-SQL, SFTP, Excel and AccessDeveloped and delivered presentations to groups of technical staff, end users or managersLed software design and technical review sessionsResponded to critical support calls with unique expertise at any time on any day when requiredIncreased reliability and maintainability of daily reporting processes by porting system from UNIX shell, cron jobs and SQLPlus scripts into PL/SQL packages and Scheduler jobsInitiated redesign of server processes to improve error analysis and identify the source of recurrent system problemsLanguages and technologies include C, C++, C#, .Net, SQL Server, Transact-SQL, T-SQL, SQL Server Reporting Services (SSRS), Oracle, PL/SQL, ARTScript (artificial intelligence, rules, cases), VBScript, Visual Basic, command line, PowerShell, Visual Studio, MS Windows, MS Office, Excel, Access, Crystal Reports, Visio.

Produced statistical data extracts regarding efficacy of health care treatments for presentation to business analysts, domain experts and stakeholders using primarily T-SQL and Excel.

Helped migrate Verizon's IDDS and ICGS OSP management software to Microstation V8 with GeoGraphics and Projectwise compatibility using MDL, C, VB, PL/SQL.

Design, code, test, document, deploy and maintain banking, accounting, and commissary management client-server applications using VB6 and PL/SQL. Automate data exchange processes over the Internet using FTP, Oracle & PL/SQL. Author system design and user documentation.

Debug and repair Verizon's Intelligent Design and Drafting System (IDDS) using Microstation MDL and C.

Enhance and maintain health insurance rating applications using AI, Visual Basic, T-SQL, SQL Server.

Design, code, test, document, deploy and maintain geographic information systems (GIS). Automate bulk data processing in an engineering environment. Automate and customize Microstation using Microstation Basic, MDL, C, PL/SQL, Visual Basic 6.0 and OLE Automation.