Resume

Business Analyst Consumers Energy

Location:

Grosse Pointe, MI, 48236

Posted:

December 16, 2022

Contact this candidate

Resume:

Mathew Krogulecki

adt3k4@r.postjobfree.com / 202-***-****

Specializing in GIS/SQL production systems, business analyst roles focused on large project data collection; Utility, Engineering, Environmental project experience, esp. facility inventories, condition assessments, deficiency/defect inventories, asset management and repair/replace budgets; ESRI geodatabase development for Enterprise and Web; SQL Server T-SQL, SSIS and SSRS; Excellent interface for internal and external clients - consistently increasing stakeholder understanding and utility of project data content

TECHNICAL SKILLS:

Microsoft SQL Server 2008, 2012, 2014, T-SQL, SSAS, SSRS

GIS: ESRI ArcGIS Suite 10.x, Desktop, Enterprise SDE, ArcGIS Online, ArcGIS Server

BIM/CAD: AUTODESK Revit and AutoCAD for O&M and SRM

Production Data Workflows Specialty; Business Analyst Roles in SQL and GIS/BIM/CAD environment

Quality Assurance Development, Quality Control Implementation

Education/Training materials, course development; formerly ESRI Certified Trainer

Manage Production Staff: Database Developer, GIS/CAD Technicians, Programmer Analysts

SELECTED PROFESSIONAL EXPERIENCE:

Integration Consultant

GeoNexus Technologies, Ann Arbor, MI (01/2020 – 10/2022)

Work with multiple clients daily (usually water, gas, electric utilities) to install and configure integration software for enterprise GIS and Asset Management (EAM) application systems database synchronization, including requirements analysis, design and implementation of use cases, data model documentation, customer support, Production Stand Ups and Cutover documentation

Data Base Discovery and Client tools for data modeling; Database objects including tables, views, indexes, security, logins, credentials, scheduled maintenance, temp tables, exploit system tables for processes, data dictionary tables for data structures, configuration table space, parameters for network index and table growth, data loading strategies, database object analysis for existing and new objects requirements

Connection parameter development for database, REST and Web Service between ESRI GIS and EAM (Maximo, Hitachi Ellipse); Database discovery using Oracle Developer, DBeaver, SQL Server, schemas, table relations, database objects for Assets, work orders, deficiencies, service requests, electric gas and water models in GIS; customize parameters for Oracle WebLogic Server, IBM WebSphere Application Server (WAS), Tomcat; other network concomitants e.g. certificates, cross domain, Windows services; Task Scheduler with xml conditional for success/fail task executions

ESRI GIS Data Models including Geometric Network (GN) and Utility Network (UN), especially asset data dictionaries and domains; Migration geodatabases GN to UN data modeling and implementation; Domain conversion, table alignment and field mapping documentation and spreadsheets; link documentation spreadsheets to automate configurations

Most aspects of ESRI Enterprise Geodatabase Development and Management: Install and configure ESRI Web App Builder Developer and Microsoft IIS for serving GIS dashboard applications; GIS Web Service development, content, map services, feature services, publishing, service management using Enterprise Server Admin; refresh services plan for schema updates; log management and trouble shoot; Replications and Publication databases in GIS

Design, Documentation and implementation: Visio, Erwin, Oracle SQL Developer Data Modeler, SQL Server Management Studio Data Modeling (Database Diagrams); Process/Work Flow models, data alignment and field mapping spreadsheets, configuration specifications, special topics, conceptual database models, Prod Stand ups and cutover implementation plans;

Systems Analyst

Consumers Energy, Contractor through Iconma LLC (12/2017 – 2019)

Create and manage ArcGIS Replications for Consumers Energy: Electric Distribution, Gas Transmission, Gas Distribution, Landbase in Dev, QA, Production environments;

SDE Administration, Distributed Geodatabase and Replica Management; GIS Schema change management with replication updates; Prerequisites Matrix for schema change under Replication

Create and manage Publication Geodatabase physical design using file groups; ArcGIS Server services management and Bentley Open Utilities Map (BOUM GIS) test data integration, BOUM and SAP work management

Maintain Infrastructure Architecture Server diagrams using Visio; Cutover/Implementation Plans for Prod; Process Diagrams, detailed procedural documentation for GeoDatabase using SQL Server and ArcGIS; Oracle and SQL Server Queries for audit data quality, SDE process monitoring and production; constraints, triggers, indexing file group management; Python scripts for audit data quality and production, test for replication prerequisites, file group assignment;

Software Design Documentation (SDD) review and edit; Interact with contractors ESRI, Bentley to develop technical solutions to implementation issues between Application Softwares and CE Customizations, Configurations; Business Requirements Documentation for MXD Optimization, Use Cases

Consultant Business Analyst and Database Developer

Consultant to Metropolitan Reporting Bureau, Philadelphia, PA (07/2016 – Current)

Create/customize databases using SQL Server Data Definition DDL, Data Manipulation DML Languages

Relational database discovery, documentation, design

Data Dictionary development, subject database content documentation

UML Use Cases for table deletion procedures, current records management old record flushing and backup, table relations and index analysis; CASE Design Tools

T-SQL Query development, views, stored procedures, cursor procedural programming

Process automation related to data maintenance using stored procedures

Consultant to Gordian Knot Analytics Group, Washington DC (07/2015 – 07/2017)

Data Base ETL and Analytics, Data Warehouse, Sisense, MicroStrategy BI tools

BI Visualizations, Dashboard development for presentation, Materials and delivery for content and education

Multiple application areas including web travel, medical imaging, account retention

T-SQL queries, production for Matlab® based modeling software

Data Dictionary spreadsheets for content documentation and presentation, planned usage

Combine BI with GIS analysis to site new restaurant for Phildelphia Union Club

Combine BI and GIS analysis to classify medical imagery types in use during different weather events

GIS Analyst and Business Application Specialist

Cook County Clerk Election Division, Chicago, IL (01/2014 – 06/2015)

Microsoft Access SQL scripts and Visual Basic Applications VBA for reporting and data development

Distributed Production Processes for voter address verification, geocoding, Versioned Editing; Census data/ACS language mapping and demographics for mandated poll place language assistance; Bar Code Scanning Process to Excel for QC; VBA scripting with Access for metric development from voter statistics

Elections Modelling using ArcGIS 10.x with historical and current voter rolls to assess distance to polls, voting patterns especially turnout; Python scripting for automation of QC on voter district codes; Metric Development

GIS Consultant

MJK International, GIS Consulting, Arlington, VA (07/2011 – 12/2013)

GIS and database support to Election Data Services, Inc. during redistricting, clients including: Chicago Board of Elections, Cook County IL, Bridgeport City CT, Massachusetts state, Rhode Island state

Manage development ArcGIS Extension: redrawing election precincts using Arc Objects and C# with VS 2010

Cartographic design and production: Nationwide Election Results Maps using live feed from Associated Press Election Night Data Server

Department of Justice vs. Osceola County, FL County Commission Reapportionment, ArcGIS data layer production Census block and block group demographics, summary statistics, election results

Senior Business Analyst

MACTEC/AMEC Engineering and Consulting Inc., Facility Life Cycle Group, Atlanta, GA (03/2007 – 06/2011)

Business Requirements Analysis: Use Cases for create/update Engineered Management Systems EMS

GIS, CAD and BIM field data collection; geodatabase production and maintenance

Metric development for 5-D Modelling – 3-D plus Time plus Budget – Repair/Replace Schedules for DOD

ArcGIS Model Builder for backhauling telecomm connections between towers and fiber backbone

Install and configure ArcGIS Server, create and deploy services, SQL Server database migration

ArcGIS Online cloud-based mapping platform and ESRI Collector for field data collection, editing and geodatabase creation; Python scripting for attachment access after data collection

Defense Logistics Agency (DLA): QA development for detailed 2-d and 3-d mapping DLA warehouse/administrative facilities worldwide. Automate quality control, ensure tolerances. Design/implement quality tests for positional/attribute accuracy, logical consistency, and completeness; Metrics for presentation

Roof Condition Assessments at continental US Air Force Bases: All aspects of design/production of Roof plans including for hangars, warehouse, admin buildings at air force bases. Manage five CAD/GIS technicians - AutoCAD and ArcGIS formats created and delivered.

QA development/QC implement for US Navy Facilities Condition Assessment: T-SQL database queries/stored procedures for error reporting in building material, condition and budget database for facilities world-wide.

Technical Analyst

Mitofsky International, National Exit Polling firm, New York, NY 2006

Database and statistical support for sampling systems and exit polling

SPSS®, Stata® technical proficiency, conversion and production of survey response data; scripts for input, labeling, value assignment; batch processing for output cross-tabulations and regressions

Bivariate analysis, multivariate analysis, especially: OLS Regression, Probit analysis of political data, survey response; Factor analysis using principle components, Cronbach’s Alpha, Scree Test to determine usability of indexes for items such as internal and external efficacy, political participation indexes

Microsoft T-SQL queries and Excel® spreadsheet production to generate reports for quality verification of sample selections - reports to substantiate vote coverage and probability of selection

SELECTED PUBLICATIONS

"Data Quality in GIS Data Base Production" - Professional Surveyor

"A Prototype Decision Guide and Audit Log for Preparation of Spatial Data Bases" - Photogrammetric Engineering and Remote Sensing

EDUCATION

Bachelor of Science – Geography, Remote Sensing – Michigan State University 1984

PUBLIC TRUST CLEARANCE

Public Trust Clearance for one and one-half years through Cook County Clerk Elections Department 2014-2015 including secure access to County Building and election/voter data records for Cook County Voting systems.

Public Trust Clearance for one year through Chicago Board of Elections 2012, including secure access to City/County Building and election/voter data records for City of Chicago Voting systems.

Public Trust Clearance through Federal government for five years 2007-2011, including Common Access Card (CAC) privileges Department of Defense Credential four years, 2007-2011. Federal Clearance allowed me to work on all DOD bases worldwide.

PROFESSIONAL REFERENCES:

Derek Elliot

GIS Tower Lead

City of Indianapolis

adt3k4@r.postjobfree.com

317-***-****

Kenric McCay

Applications Administrator and GIS Admin

Fayetteville Public Works Commission

Fayetteville, NC

adt3k4@r.postjobfree.com

910-***-****