Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Arun Thiyagarajan

Hopkinton,MA

Summary

Strategic and results-driven technology leader with 14 years of deep expertise in database administration, energy management systems, and mission-critical utility platforms. Recognized Subject Matter Expert in Hitachi ABB ADMS/OMS and GIS integration, with a strong track record of leading full-cycle implementations across the New York and New England regions. Skilled in bridging IT and OT environments, with hands-on experience in Oracle RAC, GoldenGate, SCADA, and network model accuracy. Demonstrated ability to lead cross-functional teams, manage high-impact initiatives, and drive operational excellence while maintaining strict compliance with NERC CIP standards. Lean Six Sigma certified, with a passion for mentoring teams and shaping resilient, future-ready energy infrastructures.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Principal Platform Engineer, CNI ADMS

National Grid
Northborough, USA
07.2021 - Current
  • Served as a Subject Matter Expert (SME) for Hitachi ABB OMS and ADMS, specializing in Outage Management, Network Model Design, and GIS integration with GE Smallworld.
  • Led the ADMS implementation across New York and New England, concurrently supporting legacy OMS systems and emergency storm operations.
  • Collaborated with GIS developers to enhance the Smallworld extractor, enabling enriched data flow into the ADMS environment.
  • Architected and migrated the GIS-ADMS extractor from Magik to Python (NSE) for efficient weekly feeder and substation VVO data processing.
  • Maintained seamless ADMS/OMS-DSCADA integration, ensuring real-time data accuracy and operational reliability.
  • Ensured network model accuracy in ADMS by validating alignment with EMS and GIS systems.
  • Delivered critical functionality including FLISR, DSCADA, and VVO MVPs to Distribution Control Rooms in NY and MA.
  • Spearheaded the Rhode Island divestiture, developing and executing scripts to purge RI network data from ADMS systems before Go-Live.
  • Led the legacy OMS-to-ADMS data migration, ensuring continuity and readiness during system cutover.
  • Executed Agile-based application and database upgrades using Release Train methodology.
  • Acted as a key liaison between business stakeholders and technical teams, resolving database and application blockers during ADMS rollout.
  • Conducted comprehensive functional and non-functional testing of OMS/ADMS features including Outage Interface, CIS integration, DSCADA, and Load Flow modules.
  • Configured and maintained ADMS Power Systems Explorer (PSE) by managing External Data Objects (EDOs) across environments for consistent setup.
  • Ensured compliance with NERC Critical Infrastructure Protection (CIP) standards.
  • Created custom Oracle Grid Views to support business-specific data and reporting needs.
  • Managed production and non-production Oracle databases for ADMS, supporting mission-critical operations.
  • Performed advanced DBA tasks including Data Pump refreshes, GoldenGate replication, RMAN-based recovery, RAC troubleshooting, and security patching.
  • Recovered Data Guard standby environments from primary RMAN backups using SCN-based restoration, ensuring full synchronization between primary and DR sites.

Senior Analyst, Critical National Infrastructure (CNI) – OMS/ADMS

National Grid
Northborough, USA
09.2014 - 06.2021
  • Delivered 24/7 production support for ABB Outage Management System (OMS), resolving critical issues during business hours, off-hours, and emergency storm events to ensure uninterrupted operation of a Critical National Infrastructure (CNI) platform.
  • Served as the primary resource representing CNI in the implementation of New England ADMS, contributing to key design and development sessions defining ‘AS-IS’ and ‘TO-BE’ models for distribution network management and change control.
  • Led initial configuration of the NE ADMS system, coordinated GIS extractor enhancements, validated updates via rigorous Incremental Update (IU) testing, and ensured model reliability.
  • Diagnosed and corrected Unbalanced Load Flow (UBL) issues on feeders, maintaining operational integrity of network models.
  • Acted as an internal SME to guide ADMS activities, removing technical blockers for cross-functional teams to ensure timely project execution.
  • Oversaw and troubleshot Incremental Update ingestion of GIS and customer data into OMS, preserving feeder health and compliance.
  • Collaborated with GIS and mapping teams to resolve electrical model and data extraction issues, enhancing GIS-OMS alignment.
  • Designed, developed, and deployed a new customer load process using SQL and PL/SQL, cutting execution time from 2.5 hours to 10 minutes while achieving 100% data accuracy.
  • Developed complex SQL scripts for on-demand business, regulatory, and operational reports tailored to OMS needs.
  • Automated OMS data workflows with custom scripts extracting backend Oracle data, parsing OMS logic, and delivering structured reports via Secure FTP for business analytics.
  • Managed ABB OMS software upgrades, including comprehensive testing of network model updates, customer data loads, and system interfaces.
  • Executed full Primary-to-Backup site switchovers for OMS during disaster recovery exercises, ensuring business continuity.
  • Created and scheduled Shell scripts and cron jobs within Linux environments to support internal data transfer processes.
  • Maintained Active Directory environments, resolving user and group access issues to support OMS operations.
  • Authored Business Readiness Documents and process flows for OMS interfaces and database architecture as part of project initiation and stakeholder alignment.
  • Contributed to every phase of OMS system implementation, from system configuration and interface integration to testing, upgrades, and production cutover execution.
  • Mentored junior team members, sharing expertise in OMS/ADMS systems and best practices to enhance team capability.
  • Applied ITIL-based ITSM processes to manage P1/P2 incidents, ensuring timely resolution and controlled production change management.
  • Recognized for excellence and significant contributions in delivering and supporting OMS and ADMS platforms within CNI operations.

Database Administrator

KayCee Vision Inc.
Syracuse, USA
08.2011 - 09.2014
  • Installed and configured Oracle 8i/9i/10g standalone and Data Guard databases on Red Hat Enterprise Linux (RHEL), IBM AIX, and SQL Server 2005/2008 on Windows platforms.
  • Set up and managed Oracle Enterprise Manager (OEM) Grid Control 10g/11g for centralized monitoring across production, development, and test environments.
  • Performed 24x7 database administration for high-availability OLTP/OLAP systems; managed up to 5 TB transactional data warehouses.
  • Conducted performance analysis using AWR, ADDM, ASH, Explain Plan, TKPROF, and improved query efficiency through advanced SQL tuning techniques.
  • Implemented table partitioning strategies on large datasets to enhance performance and support annual data archival processes.
  • Configured RMAN and Data Pump for full/incremental backups and recovery strategies across development and production environments.
  • Developed and maintained database objects: schemas, tables, views, constraints, indexes, stored procedures, packages, triggers, and functions.
  • Resolved space issues and optimized resource utilization at both server (RHEL, AIX, Windows) and database (Oracle, SQL Server) levels.
  • Performed patching, upgrading, and schema-level refreshes for Oracle and SQL Server databases.
  • Utilized SQL LOADER (direct and parallel) to handle flat file imports into Oracle.
  • Collaborated with business stakeholders to gather requirements and design efficient, scalable database solutions.
  • Partnered with UNIX and Wintel teams for day-to-day space and system management on AIX, RHEL, and Windows servers.
  • Managed change control processes using BMC Remedy, ServiceNow, and HPSM, including ticketing for production-level database changes.
  • Configured and administered IBM WebSphere MQ (clustered queue managers, channels, local/remote queues) across OMS environments.
  • Supported OMS performance testing and site assessments, handled interface troubleshooting, system failovers, and site switchovers.
  • Worked alongside vendors and system integrators to deploy OMS enhancements and resolve complex data replication and mapping issues.
  • Authored documentation covering technical architecture, problem-solving techniques, and software development methodologies to support knowledge sharing and team growth.
  • Continuously improved team capabilities by staying current with emerging technologies, tools, and industry best practices.

Education

HBX CORe: Credential of Readiness - Economics For Managers, Accounting, Biz. Analytics

Harvard Business School
Cambridge, MA
06-2016

Master of Science - Computer Science

Southern Illinois University
Carbondale, IL
05.2011

Bachelor of Engineering - Computer Science

Sri Sivasubramaniya Nadar College of Engineering
Chennai, Tamil Nadu, India
04-2008

Skills

Utility Platforms & Systems

  • Hitachi ABB: ADMS, OMS, VVO, FLISR, WS500, ADMS data integration
  • GE Smallworld GIS, Landbase, NetCadops, FocalPoint, PORT
  • Energy Systems: EMS, DSCADA, SCADA Confirmed Outages, Load Forecasting, Unbalanced/Balanced Load Flow (UBLF/BLF), Distribution Generations (DGs)
  • Metering & Reporting: AMI, Power Out Reporting Tool (PORT)

Database Technologies

  • Oracle: 8i–19c, RAC, GoldenGate, Streams, Data Guard, RMAN, OEM, ASM, Data Pump, Flashback
  • SQL Server: 2005, 2008, 2012, SSIS, SSRS, SSAS
  • Other DBs: MongoDB, AWS RDS
  • Core Skills: Database design, performance tuning, data warehousing, ETL, patching/upgrades

Programming & Scripting

  • SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, JSON

Cloud & DevOps

  • AWS: EC2, RDS, DMS
  • Virtualization & OS: IBM AIX, Red Hat Enterprise Linux, Windows Server, VMWare

Infrastructure & Tools

  • IBM WebSphere MQ, Microsoft Active Directory, SharePoint, JIRA

Regulatory Compliance

  • NERC CIP standards & cybersecurity best practices

Certification

  • Lean Six Sigma Yellow Belt Certified, 09/24
  • Oracle Database 11g Administrator Certified Professional (OCP), 03/16

Timeline

Principal Platform Engineer, CNI ADMS

National Grid
07.2021 - Current

Senior Analyst, Critical National Infrastructure (CNI) – OMS/ADMS

National Grid
09.2014 - 06.2021

Database Administrator

KayCee Vision Inc.
08.2011 - 09.2014

HBX CORe: Credential of Readiness - Economics For Managers, Accounting, Biz. Analytics

Harvard Business School

Master of Science - Computer Science

Southern Illinois University

Bachelor of Engineering - Computer Science

Sri Sivasubramaniya Nadar College of Engineering

Similar Profiles

CREATE PROFILE
Arun Thiyagarajan