Sorin RUSU

Experience

• 

  FlashXML.net

  Oct 2011 - May 2012

  Suport tehnic și suport clienți
• 

  TeamNet

  Jul 2012 - Mar 2018

  GIS Specialist

  Data manipulation-Nation-wide vector datasets: protected sites, administrative units, roads and road networks, rivers and geometric networks, addresses-Large scale, nation-wide raster datasets: orthorectified aerial image mosaics, topographic raster mosaics (scale 1:25.000, 1:5.000, 1:500)-RDBMS geodabase storage: Microsoft SQL Server, Oracle Database, PostgreSQL + PostGIS-Attribute table management, update, join and production; spatial representation of non-spatial data-GIS analysis models and Python scriptingData QA/QC & production, nomenclature generationGIS System configuration-ArcGIS Desktop-Server and M$SQL and Oracle SDE installation and licensing-GIS Server site, security and connections management-WebGIS Service: map tile cache creation & management, network analysis services, geoprocessing servicesGIS consultancy, demo, prototyping, presentations, analysis-GIS demos:creation of demo apps, demo data geodabase creation, demo servicespublishing, functionality research, demo presentation-GISconsultancy: functionality documentation, technical compliance matrices, proof of concept, GIS system analisys, licensing documentation-GIS prototyping and presentations: client, partner and industry specific presentations; marketing materials; technological prototyping with new platforms, APIs, applications or workflows- GIS analysis: client needs, content discrepancies and limitations, documentation of workflows, database structure, desktop&server integration.Cartography and Map development-Creation of large wall print thematic maps; Map atlas generation-Vector basemap templates, thematic webmap services, OSM basemaps, raster mosaicsGIS Research and Developement-UAV&GIS integration, nearIR digital photography-WebGIS + WebGL 2D/3D + software plugins-Open data and Open Source: analysis, documentation, integrationGIS tutoring and mentoring- GIS mentorship: intern teaching program, knowledge sharing and skill developement- GIS workshops and tutorials Show less

• 

  Essensys Software

  Mar 2018 - Dec 2018

  GIS Analyst

  GIS & Business AnalystLead business analyst for World Health Organization's Maternal, Child and Adolescent portal, secondary analyst for the WHO Global Health Observatory Portal; data analyst on the GHO data repository; Lead GIS & business analyst and architect for the ROSCI0129 Nordul Gorjului de Vest - management plan and conservation portal: Wordpress, OpenLayers, Geoserver, PostgreSQL. INSPIRE Directive technical documentation and demo for Romanian Meteorological Agency, INSPIRE implementation for GeoEcoMar. Developed geospatial integrations in Essensys' Dynamic Dox worklfow software. Show less

• 

  E.ON

  Jan 2019 - now

  Helping clean and make sense of Data, one row at a time. Successfully developed open-source driven integration pipeline from GIS (Intergraph technology stack), SAP ERP (Plant Maintenance), SAP IS-U (billing module) & SCADA index readings to fuel our Grid Planning and Analysis software. The scope of the integration:- Integrate all high-voltage grid network (3500+ km)- Integrate and model all 180 primary substations (HV>MV)- Integrate all middle voltage grid networks (aerial and cables- Integrate and model all 15.000+ transformers (MV>LV)- Resolve grid topology for 90.000+ network nodes (HV/MV/LV)- Model both consumption and generation digital twins of the grid - Publish Maps on our ArcGIS Portal with analysis done on the digital gridSuccessfully developed big-data business intelligence solution on the web for gas network leakage detection field-work, updated daily.The scope of the solution:- Handle the hundreds of millions of datapoints collected annually from field work- Analyze and enrich the hundreds of thousands of field work missions - Leverage cloud storage and up-to-date datasets, and data archiving solution- Hotspot analysis for problematic area identification and historical traceability of work- Integrate GIS gas distribution networks for visual analysis Cloudify GIS data publishing and reporting ArcGIS Enterprise implementation in Azure Cloud with database integration to Geomedia Smart Client for easy Map Services integration, Azure AD integration, resource publishing Fully automated refresh/extract/publish data pipeline, for both gas / power distribution networks Operational data mobile map package and basemap (VTPK) workflow generation Data warehouse updated daily from GIS production environment to Azure Cloud Storage as JSON and Parquet filesTech Stack Data: PostgreSQL + PostGIS, Azure Storage Processing: GDAL 3.7, Python 3.x ESRI: ArcGIS Desktop 10.8, ArcGIS Pro, ArcGIS Server 10.9, ArcG Show less Bringing the power of "Where" to the utilities industry. Mastered Intergraph GINIUS data model for utilities and automated GTechnology Designer in the organization. Mastered Intergraph Geomedia Smart Client and Server infrastructure and provided continuous improvement for 500+ users. Several improvements to the GIS - SAP interface and integration.Successfully integrated Integraph Electricity network model with NEPLAN v5 for network calculations via Python scripting. Mastered the NEPLAN data model and characteristics libraries and piloted electrical area capacity.Successfully developed the technical calculation system CPT for calculating, network modelling and forcasting distribution network losses: Liferay, SAS Energy Forecast; Successful integrations: SAP Globe & SAP ISU, GIS, Smart Meters.Updated automated extraction scripts for regulatory reportings as well as several critical data Quality Assurance & Quality Control for the electrical elements in the distribution network.Successfully implemented an ArcGIS Enterprise instance for publishing Gas & Electricity networks inside the organization. Show less

  • Product Owner - Data Digital Transformation

    May 2020 - now

  • IT Consultant - GIS

    Jan 2019 - Apr 2020