Kevin Swain Email & Phone Number

Boston, Massachusetts

Boston, Massachusetts

Greater Boston Area

Maintained Legacy First Wind Systems and continued on development and improvement on operating systems to incorporate legacy data with SunEdison.Primary BI developer for all Wind BI solutions and enhancements for over 3GW (1000+ Wind Turbines) of operational assets.Continued BI solutions development for various groups such as Reporting, Operations Center, and Asset management.Lead Event Management and Data Warehousing work streams (Ongoing): Daily, Weekly, and… Show more Maintained Legacy First Wind Systems and continued on development and improvement on operating systems to incorporate legacy data with SunEdison.Primary BI developer for all Wind BI solutions and enhancements for over 3GW (1000+ Wind Turbines) of operational assets.Continued BI solutions development for various groups such as Reporting, Operations Center, and Asset management.Lead Event Management and Data Warehousing work streams (Ongoing): Daily, Weekly, and Monthly Meetings to track Agile Development Implemented Integrated Fleet wide solution (Developed and acquired assets) Project designed to increase key company KPIS such as mean time to detect issues, generation and asset performance tracking, IPR OPR WPR, contractual availability and Operational (Field Services) performanceSix Sigma Green Belt Certification for Consolidated ReportingServed as primary developer for all SQL SSIS and SSAS Development to integrate Sunedison and First Wind systems for top 80% of revenue generating projectsProject served as precursor to REDI Project Show less

Greater Boston Area

Developing and maintaining Business Intelligence solutions for data analysis and operational performance enhancement.Developed and Maintained Operational Reporting System including:Real Time Operational Event Monitoring for 2GW of Operational Wind and Solar PlantsEstimated Energy and Revenue and LossReporting of key business and operational metrics including Daily Production, CAFD Tracking, and Monthly Operating ReportsMaintained and improved device event management… Show more Developing and maintaining Business Intelligence solutions for data analysis and operational performance enhancement.Developed and Maintained Operational Reporting System including:Real Time Operational Event Monitoring for 2GW of Operational Wind and Solar PlantsEstimated Energy and Revenue and LossReporting of key business and operational metrics including Daily Production, CAFD Tracking, and Monthly Operating ReportsMaintained and improved device event management and tracking software as well as created logic based on specific manufacturer data schemas to extract, transform, and load specific period of time identified to impact performance and alert the Renewable Operations Control Center.Managed multiple large scale SQL Databases containing all operational data for the entire fleet (2GW)On boarded newly developed and acquired projects into SQL, SharePoint, and related reporting systemsDeveloped several SSAS Cubes for Reporting Services and EngineeringImplemented various BI solutions to migrate data from SharePoint and other sources to be used and maintained for reporting and analysis. Such as gearbox performance tracking, oil sample analysis, CAFD and EBITA tracking, and control center monitoring tools. Show less

Greater Boston Area

Monitor and control 16 Wind Farms distributed across the U.S. totaling 980 megawatts (MW).Analyze, monitor, and document wind turbine and substation status to track, diagnose, and prevent downtime events to maximum fleet performance Coordinate event response, power system switching operations, and turbine repair activities with onsite techniciansServe as the primary communications interface with site operating staff, utilities, and Independent System… Show more Monitor and control 16 Wind Farms distributed across the U.S. totaling 980 megawatts (MW).Analyze, monitor, and document wind turbine and substation status to track, diagnose, and prevent downtime events to maximum fleet performance Coordinate event response, power system switching operations, and turbine repair activities with onsite techniciansServe as the primary communications interface with site operating staff, utilities, and Independent System Operators.Follow Standard Operating Procedures (SOP) to control turbine and substation components and respond to events/alarms. As well as, actively write and contribute to instructions, procedures and manuals following documentation standards to guide end users.Create,modify, and analyze Pi processbook displays and excel used for real time systems monitoring, predictive analysis, and prevention component failures Regularly interact with various information systems personnel to clarify program intent, identify problems and suggest changesEnsure compliance with all local, state and federal regulations in all concerns, including but not limited to; environmental, NERC/FERC, local laws and regulations.NERC Certified Balancing Interchange and Transmission Operator Show less

Set up computer network for the Boston MarathonPositioned routers, computers, switches, and wireless access pointsConfigured switches, networked drives, and printers at various locations including the medical tent and family meeting areaMaintained network during race using HP ProCurve technologiesImplemented network for an automated warehouseWired a 5 story automated structure with wireless antennasImplemented several hot fixes during the assembly such as wireing models… Show more Set up computer network for the Boston MarathonPositioned routers, computers, switches, and wireless access pointsConfigured switches, networked drives, and printers at various locations including the medical tent and family meeting areaMaintained network during race using HP ProCurve technologiesImplemented network for an automated warehouseWired a 5 story automated structure with wireless antennasImplemented several hot fixes during the assembly such as wireing models and structural enhancements to the antennas Show less

Database management and software development for proprietary program (Subscription Automation)Subscription Automation retrieves electrical meter data and billing information and distributes it to suppliers via FTPCurrently over 500 commercial TOU (time of use) electrical accounts subscribed to this serviceCommunicated directly with Meter Reading Data Management and Supplier Services to optimize system for convenienceImplemented various enhancements such as data backup, data… Show more Database management and software development for proprietary program (Subscription Automation)Subscription Automation retrieves electrical meter data and billing information and distributes it to suppliers via FTPCurrently over 500 commercial TOU (time of use) electrical accounts subscribed to this serviceCommunicated directly with Meter Reading Data Management and Supplier Services to optimize system for convenienceImplemented various enhancements such as data backup, data logging, and improved user interfacesPlanned hardware and software upgrade to be performed after co-op periodOutlined meter data and billing server migration from current serverDetailed potential software issues in updated software including database compatibility, data format, and overall process design Resolved various interoffice technical issues including editing Excel macros in VBA, debugging proprietary software, configuring ODBC connections, and writing/editing SQL queries and Crystal Reports functions Assumed key roles and duties of Data Analysis Coop in team members absenceData extraction and supplier relations with over 15 companies encompassing 1.4 million commercial TOU electrical accountsDeveloped and executed macro’s to enhance various aspects of data analysis, processing, and billingIncreased productivity of data extraction through the automation of repetitive tasksUpdated all training and reference documentation Show less