Bruce Colligan

Senior Analyst/Business Intelligence Engineer

Sherwin Williams•  March 2021 - Present•  Cleveland, OH

- Develop and present marketing data analytics reports using SQL, Tableau, Python, and Dataiku. - Design, create, manage, and troubleshoot reporting & analytics data workflows, pipelines, and ETL/ELT processes. - Partner with data science team, data engineering team, and external vendors to seamlessly integrate Snowflake with platforms like AWS S3, BigQuery, Dataiku, MicroStrategy, and various internal systems, ensuring smooth data flow and interoperability across the enterprise. - Leverage Snowflake SnowPro certifications and experience to create proof of concept prototypes and implement new database processes for our Marketing Analytics group. - Create high-profile dashboards using Tableau and Tableau Server. - Present and demonstrate new platform features, benefits, and updates to the broader marketing data infrastructure and analysis teams. - Planning and testing for data warehouse migration from SQL Server to Snowflake, which allowed reduced time to insight for sales, marketing, and retail store teams. - Key member of a team that migrated marketing processes from an external vendor to an in-house solution within Snowflake, reducing annual license costs by $500K.

Senior Analytics Consultant and Tableau Administrator - Business Intelligence Professional Services

Precision Dialogue•  February 2016 - February 2021•  Cleveland, OH

- Worked directly with customers and stakeholders in the retail/luxury retail, CPG, and automotive industries to understand and scope analytics and dashboard projects and present project findings. - Created and presented marketing analytics reports using R, Python, and Tableau. - Created and managed Tableau dashboards tied to high-volume Snowflake, SQL Server, and PostgreSQL databases as well as other sources such as Google Analytics. - Developed and managed reporting & analytics data pipelines and ETL processes. - Performed Tableau Server & Desktop solution design, custom development, testing, and release/deployment. - Managed Precision Dialogue's Tableau Server environment, including hardware/architecture planning, process optimization, upgrades, and automation.

Senior Consultant - Governance, Risk, and Compliance (GRC) Professional Services

Wolters Kluwer•  April 2007 - September 2015•  Cleveland, OH

- Conducted reporting & analytics using SQL Server, Microsoft Access and advanced Excel to identify areas of concern and opportunity in our business. - Design and implementation of Governance, Risk and Compliance (GRC) system for clients in the CPG, Pharmaceutical, Medical Device, and Insurance industries. - Partnered with clients to minimize risk of non-compliance with multiple mandates and regulations such as Sarbanes Oxley (SOX), Foreign Corrupt Practices Act (FCPA), HIPAA, Enterprise Risk Management (ERM), and Corporate Integrity Agreements. - Created high-visibility executive reporting & analytics using a variety of database and business applications for data analysis and presentation. - Analyzed clients' current compliance management & training processes, systems, and data to determine configuration, custom development, and integration requirements. - Collaborated with product management, engineering, and pre-sales teams to evaluate and incorporate customer feedback and product enhancement requests. - Participated in the RFP response and pre-sales process.