Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Patrick Lohn

Pompton Plains

Summary

Dynamic Business Intelligence professional with a proven track record at Shiseido Americas Corporation, excelling in data analysis and staff training. Spearheaded the implementation of BI solutions that enhanced data accessibility, driving strategic decision-making and fostering a data-driven culture. Adept at relationship building and optimizing workflows to exceed customer expectations.

Overview

2026
2026
years of professional experience

Work History

Manager Business Intelligence Reporting

Shiseido Americas Corporation
11.2003 - 07.2025
  • Planned, created, tested and deployed system life cycle methodology to produce high quality systems to meet and exceed customer expectations.
  • Trained personnel in equipment maintenance and enforced participation in exercises focused on developing key skills.
  • Implemented best practices in project management to optimize workflow and reduce lead times.

Business Intelligence Consultant

Cognos
03.1998 - 11.2003
  • Analyzed complex data sets to derive actionable insights for business strategy development.
  • Designed and implemented BI solutions, enhancing data accessibility across departments.
  • Collaborated with stakeholders to identify key performance indicators and reporting requirements.
  • Developed interactive dashboards using Tableau, improving visualization of critical business metrics.
  • Conducted training sessions for staff on BI tools and best practices, fostering a data-driven culture.

Senior Business Intelligence Developer

Ortho-McNeil Pharmaceuticals
08.1993 - 03.1998
  • Developed and optimized complex ETL processes to enhance data integration efficiency.
  • Led cross-functional teams in delivering actionable business insights through BI reporting tools.
  • Designed and implemented data visualization solutions to facilitate strategic decision-making across departments.
  • Mentored junior developers on best practices in BI development and data analytics methodologies.
  • Conducted comprehensive analyses of large datasets to identify trends, opportunities, and areas for improvement.

Business Intelligence Consultant

Comshare
1990 - 1993
  • Provided strategic recommendations based on predictive analytics to drive revenue growth initiatives.
  • Designed customized data collection models for specific visualization tasks.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Created data analysis tools to allow teams to query acquired information for unique details.

Education

Hotel, Motel, And Restaurant Management

Northern Arizona University
Flagstaff, AZ
05-1984

Skills

  • Customer service
  • Time management
  • Decision-making
  • Verbal and written communication
  • Staff training and development
  • Relationship building
  • Data analysis
  • Adaptability and flexibility

Accomplishments

Managed the transition from legacy Cognos PowerPlay to Cognos Analytics.

Developed maintained Power BI Dashboards utilized byt a notional sales team as well and planning and marketing executives.

Timeline

Manager Business Intelligence Reporting

Shiseido Americas Corporation
11.2003 - 07.2025

Business Intelligence Consultant

Cognos
03.1998 - 11.2003

Senior Business Intelligence Developer

Ortho-McNeil Pharmaceuticals
08.1993 - 03.1998

Business Intelligence Consultant

Comshare
1990 - 1993

Hotel, Motel, And Restaurant Management

Northern Arizona University
Patrick Lohn