Keith Conroy
47 Congress St., Apt 17 Nashua,United States
Summary
Results-driven Business Intelligence Analyst with a proven track record at TaxAct, specializing in Tableau dashboard development and SQL query optimization. Achieved a 20% increase in stakeholder satisfaction through innovative data visualization solutions. Core competencies include ETL processes and report writing, with a strong focus on fostering collaborative environments for data-informed decision-making. Experienced in transforming complex data into clear, user-friendly documents that enhance company communication.
Overview
27
27
years of professional experience
1
1
Certification
Work History
Tableau Report Writer (Contractor)
Sonesta Corporation
Newton, United States
10.2023 - Current
- Designed KPI dashboards in Tableau to track critical metrics like RevPAR, ADR, and total room nights, improving visibility across properties
- Integrated GA 360 data with BigQuery for real-time campaign performance monitoring, enabling marketing optimizations
- Identified operational inefficiencies and growth opportunities through BigQuery analytics, influencing cross-property strategies
- Conducted acceptance testing to validate workflows and ensure compliance with project requirements
- Streamline data visualization processes by developing automated Tableau dashboards for key hospitality metrics, driving data-informed decision-making
- Design and implement cross-platform analytics solutions integrating multiple data sources for comprehensive business intelligence reporting
Senior Business Intelligence Analyst - Tableau Developer
TaxAct
Dallas, United States
09.2021 - 10.2023
- Developed advanced dashboards in Tableau, enhancing stakeholder satisfaction by 20%
- Analyzed user behavior with BigQuery, improving customer retention strategies by 10%
- Created ETL pipelines with CRM and Snowflake, reducing churn by 15%
- Applied predictive modeling for marketing and operational decisions
- Implemented cross-functional data visualization solutions in Tableau, resulting in measurable improvements to stakeholder decision-making processes
Tableau Developer III – Business Intelligence
Amerihealth Caritas Family of Companies
Philadelphia, United States
01.2021 - 09.2021
- Developed SQL-driven BI solutions, enhancing report accuracy by 25%
- Reduced data errors by 30% through effective QC/QA workflows
- Presented insights that cut operational inefficiencies by 12%
- Designed Epic EMR reports to improve care delivery and satisfaction
- Architected end-to-end BI solutions integrating Epic EMR data, resulting in 25% improved reporting accuracy while streamlining healthcare provider workflows
Senior Computer Systems Analyst (FEDERAL CONTRACTOR)
Precise Systems
Lexington Park, United States
07.2020 - 12.2020
- Optimized SQL procedures, cutting query times and boosting team efficiency
- Automated data tasks, enhancing productivity and removing redundancies
- Provided data insights to leadership, influencing strategic decisions
- Spearheaded cross-functional system optimization initiatives, implementing advanced data architecture solutions for enhanced operational efficiency
Business Intelligence Data Analyst
Logix Health
Bedford, United States
03.2015 - 07.2020
- Created Tableau dashboards, enhancing workflow efficiency by 25%
- Generated accurate SSRS reports, reducing discrepancies by 30%
- Collaborated to improve operations, achieving 20% efficiency gains
- Implemented data visualization strategies, optimizing reporting systems
- Enhanced decision-making with improved workflow efficiency
Data Conversion Specialist
Intellisoft Group
Nashua, United States
10.2014 - 03.2015
- Validated data pipelines, ensuring quality and scalability for ETL processes
- Created Salesforce links, improving client data management efficiency
- Designed OLAP structures, enhancing reporting accuracy
- Developed automated tool, saving 10 hours weekly, boosting team productivity
- Optimized ETL workflows through data profiling and validation, while implementing automated extraction tools that reduced manual data gathering by 10 hours weekly
Reporting Specialist
AdvantEdge Healthcare Solutions
Salem, United States
06.2013 - 10.2014
- Developed SSIS packages for efficient ETL processes, enhancing data integration accuracy
- Improved SQL database performance by rebuilding indexes, boosting query speed
- Managed automated SQL reports, resolving technical issues using JIRA
- Engineered robust SQL database solutions, focusing on performance tuning and automated reporting systems while maintaining data integrity and accuracy
Data Production Analyst
Amergent
Peabody, United States
10.2010 - 12.2012
- Aligned client data formats for enhanced readability, boosting downstream process efficiency
- Developed and maintained instructional documents, reducing onboarding time for new team members
- Worked with account teams to address data issues, ensuring all project deadlines were met
- Implemented data standardization protocols and developed comprehensive documentation systems, leading to measurable improvements in process efficiency and team performance
Various Roles (Business Intelligence Developer, Business Analyst, Reporting Analyst)
Coventry Workers’ Compensation Services (Formerly Concentra)
Burlington, United States
01.1998 - 01.2010
- Automated SQL reports, boosting Field Case insights and operational efficiency
- Analyzed costs, enhancing workflow efficiency and identifying savings
- Developed data models and dashboards, improving ROI tracking and analytics
- Spearheaded development of enterprise-wide SQL reporting framework, integrating field case management data streams and enhancing operational visibility
- Partnered with stakeholders to identify reporting gaps, designing custom solutions that aligned with business objectives and enhanced ROI tracking
Education
Bachelor of History/Secondary Education - Secondary Education/American History
Westfield State University
Westfield, MA01.1997
Associate of Computer Science and Electronics -
ITT Technical Institute
Woburn, MA06.2004
Associates - Liberal Arts -
Bunker Hill Community College
Charleston06.1991
Python Certification -
Udemy
12.2024
Tableau Desktop Certified Professional -
Tableau
12.2020
Tableau Desktop Specialist -
Tableau
12.2019
Skills
- Tableau Dashboard Development
- SQL Query Development
- Python
- ETL Process Management
- Google BigQuery Expertise
- Proficient in Snowflake
- Oracle Database Management
- PostgreSQL
- SSIS Development
- Amazon Web Services
- KPI tracking
- Data quality assurance
- Business intelligence
- SQL Server Reporting Services
- Database Scripting
- T-SQL
- Agile Methodologies
- JIRA Workflow Optimization
- Experience with Epic EMR Systems
- Statistical Analysis
- Data Modeling
- Power BI Data Visualization
Custom Section - Tableau Public Portfolio
- Territory Sales for Product Line, https://public.tableau.com/profile/keith.r.conroy#!/vizhome/TerritorySalesforProductline
- Sales Inc Report, https://public.tableau.com/profile/keith.r.conroy#!/vizhome/SalesIncReport
- Account Tracker for Internal Salesforce, https://public.tableau.com/profile/keith.r.conroy#!/vizhome/AccountTrackerforInternalSalesforce
Certification
Tableau Desktop Certified Professional - Jan 2019
Tableau Desktop Specialist - Jan 2020
References
References available upon request.
Timeline
Tableau Report Writer (Contractor)
Sonesta Corporation
10.2023 - Current
Senior Business Intelligence Analyst - Tableau Developer
TaxAct
09.2021 - 10.2023
Tableau Developer III – Business Intelligence
Amerihealth Caritas Family of Companies
01.2021 - 09.2021
Senior Computer Systems Analyst (FEDERAL CONTRACTOR)
Precise Systems
07.2020 - 12.2020
Business Intelligence Data Analyst
Logix Health
03.2015 - 07.2020
Data Conversion Specialist
Intellisoft Group
10.2014 - 03.2015
Reporting Specialist
AdvantEdge Healthcare Solutions
06.2013 - 10.2014
Data Production Analyst
Amergent
10.2010 - 12.2012
Various Roles (Business Intelligence Developer, Business Analyst, Reporting Analyst)
Coventry Workers’ Compensation Services (Formerly Concentra)
01.1998 - 01.2010
Bachelor of History/Secondary Education - Secondary Education/American History
Westfield State University
Associate of Computer Science and Electronics -
ITT Technical Institute
Associates - Liberal Arts -
Bunker Hill Community College
Python Certification -
Udemy
Tableau Desktop Certified Professional -
Tableau
Tableau Desktop Specialist -
Tableau
Similar Profiles
Karina RosalesKarina Rosales
Dual Catering Sales Manager at Sonesta CorporationDual Catering Sales Manager at Sonesta Corporation
Molly KostkaMolly Kostka
Public Relations & Social Media Sr.Specialist at Sonesta International Hotels CorporationPublic Relations & Social Media Sr.Specialist at Sonesta International Hotels Corporation
Sylvia Claramunt-AcostaSylvia Claramunt-Acosta
Guest Service Agent at Sonesta International Hotels CorporationGuest Service Agent at Sonesta International Hotels Corporation
Asher RomeroAsher Romero
Assistant Unit Counselor at Girl Scouts of the Green and White MountainsAssistant Unit Counselor at Girl Scouts of the Green and White Mountains
Pabbola VikramPabbola Vikram
Financial Analyst at Amazon Development Centre India pvt ltdFinancial Analyst at Amazon Development Centre India pvt ltd