Experience

Cars.com

• United States
• Internet Publishing
• 700 & Above Employee

• Sr. Business Intelligence Engineer

  • Nov 2021 - Present



Shake Shack

• United States
• Hospitality
• 700 & Above Employee

• Sr. BI Analyst/Developer

  • Jul 2021 - Nov 2021



McDonald's

• United States
• Restaurants
• 700 & Above Employee

• Sr. Data Analyst (Data Governance | BI)

  • Nov 2019 - Jul 2021

  •Assisted in root cause analysis, investigated data errors/anomalies and implementing solutions to correct data problems. •Prepare and consolidate data for established, periodic review and maintain Data Quality Tableau dashboards. •Collaborate with business stakeholders to develop and document policies and procedures surrounding Data Governance. •Assisted in the creation of Critical Data Elements and document Data Mappings across various data sources. •Created complex Data Quality SQL checks. •Liaise with internal/external stakeholders to provide exception management reconciliation/reporting.



Cars.com

• United States
• Internet Publishing
• 700 & Above Employee

• Senior Data Analyst

  • Sep 2017 - Nov 2019

  •Design and develop BI solutions and integration with databases and data warehouses for customers.•Develop targeted, high-performance Tableau extracts directly against multiple different database platforms (including Teradata, Hadoop, and Oracle) using views and complex custom SQL.•Assisted BI team in establishing Tableau self-service initiatives across the organization which led to the creation of Tableau Office Hours and best-practices training to help drive Tableau adoption.•Participated in cross-functional project teams and collaborated with business partners to determine and translate business requirements into technology solutions.•Applied technical skills using Tableau, Python and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.•Created visually impactful dashboards in Tableau for data validation purposes. •Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.•Maintained and assisted in the development of moderately complex business solutions, which included data, reporting, business intelligence/analytics.•Function as a Tableau Administrator, maintaining two unique Tableau Server high-availability environments supporting thousands of users. Plan and conduct Tableau upgrades, conduct stress-testing and benchmarking using Tabjolt.

• Senior Business Intelligence Reports Developer

  • Aug 2012 - Sep 2017

  •Executed the complete end to end process of requirement gathering from the business, building data extracts against our Teradata Database, developing Tableau workbooks, publishing to Tableau Server, and granting user access.•Tuned queries that decreased runtime by using temp tables/stats and indexing.•Write queries against our Hadoop environment using Hive, focusing on Adobe Omniture and Google DFP data.•Worked on SQL tuning and optimization of Tableau Extracts, Business Objects and Crystal reports utilizing custom SQL.•Performed complex ad-hoc SQL queries for the Analytics team when immediate access to data was required.•Developed and modified Tableau extracts, visualizations and dashboards using Tableau.•Building and publishing customized interactive reports and dashboards, report scheduling using Tableau server.•Assisted in setting up the Tableau Self Service environment for our internal user base. •Expertise in both Crystal Reports and Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS & CMC).



NorthShore University HealthSystem

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Senior BI Programmer/Analyst

  • Mar 2011 - Aug 2012

  •Business Objects Universe Designer responsible for migrating Cognos Packages to Business Objects. •Built custom ad-hoc queries for Doctors sourced from the Clinical Data Mart. •Created ad-hoc reports for the Finance Department from the Hospital Billing Data Mart. •Automated Clinical Cancer Registry reports in Cognos for Cancer Department. •Project lead responsible for development of the project schedule, task assignment and execution, user acceptance testing and status reporting for the integration of Business Intelligence tools with Epic hospital software.



Walgreens

• United States
• Retail
• 700 & Above Employee

• Business Intelligence Developer

  • Jun 2003 - Mar 2011

  •Support and development of a financial analytics data warehouse comprised of Sales, Billing, Inventory, and Marketing metrics for 7,000 retail stores and corporate initiatives.•Provided detail analysis into Sales and Profit data. •Determine business user reporting needs and system functionality requirements in order to develop a methodology for accessing required BI data. •Profound knowledge of Business Objects and solid database query with SQL. Also developed and tested multiple Business Objects Reports.•Inquire about user concerns and questions regarding the new reporting data and system response times, in an effort to foster an interested and empowered user community. •Mentor new team members by providing training and direction on software tools and application development procedures. •Monitor data integrity and perform tests on data extraction (ETL) programs developed by other departments.

• Decision Support Programmer Analyst

  • May 2000 - Jun 2003

  •Develop client/server applications with Discoverer and Oracle Reports for deployment to 200 clients located in the Marketing/Purchasing and Loss Prevention departments. •Trained end users in using full client Oracle Discoverer for analysis and reporting.•Flagged suspect PLN items and maintained web application used by both store managers and Loss Prevention Department. •Gather business requirements and identify data sources in corporate legacy systems. •Oracle Discoverer Administrator for over 200 clients.•Wrote and executed SQL ad-hoc queries for the Finance, Merchandising, Marketing, Advertising, Store Operations and Loss Prevention business units.•Serve as a liaison between the system users and the IT project teams by suggesting changes in applications, technologies, defining process standards and documentation requirements.