Robert Rogers Email & Phone Number

Salem, MA, US

San Francisco Bay Area

Boston, Massachusetts, United States

Migrated all Hatch commercial systems - and related integrations - over to Measurabl.Interviewed all departments as to their current state, needs, wants and pain points as part of research and planning for a broad Salesforce rollout within Measurabl. Developed an architectural roadmap and communications guide to explain which teams would be on-boarded into.

Boston, Massachusetts, United States

Robert conducts stakeholder interviews, scopes, leads and implements all Salesforce and related commercial solutions in order to ensure maximum team productivity and data hygiene.This includes the alignment of data for all integrations in/out of Salesforce (NetSuite, JIRA, marketing tools and Hatch's core product platform) as well as related datalake/BI.

Greater Boston Area

Stood up Salesforce instance from the ground up and developed custom workflow and solutions to meet team needs. Consulted with NetSuite team to align on representation of customer data with Salesforce. Integrated Salesforce and NetSuite using Celigo; built out remaining data integrations to other commercial systems using Dell Boomi.Owned all commercial.

Boston, Massachusetts, United States

Boston

As part of the Center of Excellence within EnerNOC, I work to build value with customers by integrating our Energy Intelligence Software with their external systems, architect new and innovative customizations, and deliver custom reporting solutions.The Center of Excellence is a group of practice area leads from a variety of disciplines that seeks to:1..

Greater Boston Area

• Lead the architecture and design of enterprise data warehouse and ETL operations, emphasizing design patterns that were organized, repeatable, easy to understand, and supportable by the entire team;
• Built out Salesforce architecture to support cross-system integrations around Salesforce ServiceCloud;
• Championed new warehouse to become the company's central data integration mechanism;
• Regularly synced, merged and cleansed data between multiple legacy and operational systems;
• Solved many a "fuzzy match" challenge, linking disparate systems with poor data quality together;
• Managed BI team's development in JIRA, working in two-week agile scrums;

Greater Boston Area

• Increased business understanding of its data through creation of data marts, accessed through user-friendly data visualization tools in Excel, PowerView, PowerPivot and other Microsoft BI tools;
• Implemented data synchronizations between Salesforce and in-house SQL Server databases;
• Salesforce Apex development, Apex trigger development & Salesforce administration;
• ETL/SSIS development to sync legacy reporting systems and current operational ones;

Salem, MA

Sausalito, CA

• Enabled company's product expansions by directing technology platform to support multiple products that integrate with and enhance each other, creating a "single platform" solution for the customer.
• Created new revenue opportunities by re-designing and re-positioning OESjobs product. Incorporated deep customer and partnership input to create a more practical solution for day-to-day customer pain points.
• Informed, and incorporated feedback from, executive team on evolving product strategy roadmap.

Sausalito, CA

• Conceptualized, designed, and engineered the reporting, automated email, and customer HR database integration components of company's core (web-based) OES platform.
• Directed core database and software architecture to support multiple customers using multiple integrated products.
• Regularly achieved SQL query performance improvements of 10-100x as platform grew and required rework.
• Architected and engineered a flexible SQL Server DTS ETL solution that was used for importing HR data from any customer in any format -- later migrated this to SSIS.
• Created a system of software components that allowed established SQL queries to be flexibly combined and re-used, enabling new applications to perform complex queries with minimal development time and risk of error.
• Migrated database platform from SQL Server 2000 to SQL Server 2008.

Ms, Technology & Policy

Apex Code Development

Executive Education Certificate, Product Management

Fulbright Scholar, Hydrogen Fuel Cells

Bs, Chemical Engineering, Engineering