What have I done?
Performed large scale Electric Utility CIS Data Conversion
Project Overview
While serving as Data Services Manager at Cogsdale, I led a project for a mid-sized city in Southeastern Massachusetts to migrate utility management data from an SAP system to a new Customer Information System (CIS) using SmartConnect and MS-SQL Server in the Azure Cloud. This initiative, which involved using Smart Connect and custom stored procedures maintained by my team and me, enhanced data management capabilities and overall functionality. The project modernized infrastructure and improved service delivery for 70,000 locations in a Boston suburb, showcasing Green Island Data’s expertise in delivering high-quality data conversion solutions that drive operational efficiency and modernization for utility companies.
Source System: SAP – Electric Provider (MS-SQL Server)
Target System: Cogsdale CIS Solution (Azure Cloud MS-SQL Server)
Role: Lead Data Conversion Specialist
Project Scope
The project involved migrating data from the legacy SAP system to a new Customer Information System (CIS) built on MS-SQL Server for an electric service provider in Massachusetts. The scope included a comprehensive data conversion covering customer profiles, service locations, meter readings, financial transactions, equipment details, connection information, deposits, balances, meter reads, account notes, and budgets. The project aimed to ensure data integrity, consistency, and completeness, addressing issues such as duplicates, incorrect data, incomplete records, and inconsistent data formats. Detailed validation and cleansing processes were implemented to resolve data discrepancies and ensure a smooth transition. This effort was a critical part of the electric service provider’s infrastructure modernization and service enhancement initiative.
Key Responsibilities
Data Conversion Planning and Execution: Developed and executed a detailed data conversion strategy to ensure a smooth transition from SAP to the new system. This included preparation, multiple iterations of data conversion, and post-conversion validation.
Stakeholder Collaboration: Worked closely with the electric company stakeholders and consultants to align the data conversion objectives with business needs, ensuring seamless integration and functionality in the new CIS environment.
Data Integrity and Validation: Conducted extensive data integrity checks and validation to ensure the accuracy and completeness of the migrated data, employing various tools and methodologies to address data anomalies.
Issue Tracking and Resolution: Utilized Jira to manage and track issues throughout the conversion process, facilitating efficient resolution and continuous communication among team members.
Outcome
The successful migration to the new CIS system significantly improved data accessibility and utility for the electric company, streamlining operations and enhancing customer service capabilities. The project also dramatically reduced the risk of data discrepancies and provided the company with robust tools for future data management and reporting needs.
This data conversion project exemplifies Green Island Data’s expertise in managing complex data migrations and our commitment to delivering high-quality solutions that enhance operational efficiencies and data governance.
Technologies and Tools
SAP (Source System)
SmartList (Validation Listing)
Jira (Issue Tracking)
Data Conversion ETL Tools (SmartConnect)
SQL Server Management Studio (SQL Stored Procedures, Views, Function etc.)
Green Island Data 