Jacob Golding
Data Analytics and Visualization
Pittsburgh,PA
Summary
Business Intelligence Analyst with over 20 years of experience in managing people, projects, and processes. Excellent reputation for identifying actionable insights that drive overall improvement though data analysis, with a passion for creating data visualizations.
Overview
20
20
years of professional experience
Work History
Business Analytics Consultant Lead, VP
PNC Bank
Pittsburgh, PA
02.2023 - Current
- Lead data visualization efforts for high profile dashboards, presented to senior management and executives
- Identified projects with best potential return to drive decision on how Tableau development hours were spent
- Implemented "why" functionality into the department's flagship dashboard to provide users with hover pop-up charts for data point outliers
- Participated in numerous meetings as the subject matter expert for Customer Interaction Management (CIM) analytics and performance reporting
- Designed system to update treatment prioritization values used in the CIM decision engine algorithm
- Built and managed multiple dashboards for high profile projects that required creative solutions for combining standard CIM data with data not available in databases, with daily updates
- Co-Managed contractors, provided guidance on questions related to technical work, and road map direction
Business Analytics Consultant Sr., AVP
PNC Bank
Pittsburgh, PA
03.2019 - 02.2023
- Converted department methodology from receiving requests and responding with ad-hoc reports into self-serve analytics by creating Tableau reports that enabled non-data users to query through drop down menus, add/remove columns, swap out variables in each column, adjust timeframes, and many other customizations
- Rebuilt entire report generation process for Customer Interaction Analytics department, converting from individual data pulls from 10 sources to one single reporting table, and transitioned from creating reports in Excel into Tableau
- Designed and implemented many daily, monthly and yearly reports using advanced Tableau Functions
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best utilization of resources.
- Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices.
- Created business and technical requirements documentation and developed solution designs for analytics implementation.
- Utilized data visualization tools to effectively communicate business insights.
- Participated in team projects, demonstrating an ability to work collaboratively and effectively
Business Analytics Consultant, AVP
PNC Bank
Pittsburgh, PA
01.2014 - 03.2019
- Developed key customer interaction metrics such as contact frequency, retention rates, seasonal purchase patterns, used to track improvements in marketing efficiency
- Worked closely with product marketing teams to create and maintain Tableau dashboards focused on KPI trends and customer behaviors, used to drive marketing strategy
- Built centralized Data repository combining up to 10 sources to produce reports and presentations, highlighting findings and recommending changes
- Assessed strategic implications of business intelligence data, developing segment profiles for customer interaction management and product strategy areas
- Problem solved issues regarding integrity of data flow into Teradata, Oracle, and other relational databases
- Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action
- Demonstrated strong organizational and time management skills while managing multiple projects
- Demonstrated leadership skills in managing projects from concept to completion
- Exercised leadership capabilities by successfully motivating and inspiring others
Business Analyst II, Officer
PNC Bank
Pittsburgh, PA
01.2013 - 01.2014
- Developed queries in Oracle, DB2, and Teradata databases using combinations of SAS, Brio, Toad, and Teradata to create targeted lists of customers who will receive marketing communications and offers
- Elicited campaign criteria through interviews with campaign subject matter experts
- Represented the campaign list team at numerous Line of Business meetings, providing information necessary to focus and improve marketing campaigns
- Managed business partner expectations by providing status reports, performing troubleshooting when concerns are identified, and providing time-to-complete estimates during the campaign planning process.
Business Analyst
UPMC Health Plan
Pittsburgh, PA
11.2012 - 01.2013
- Created summary reports including trend analysis and sub-reports per business requirements that were developed in conjunction with stakeholders
- Developed analysis that informed the location of future Urgent Care Centers
- Created numerous reports including but not limited to: Box Reports, Clinical Summaries, Executive Dashboards, Scorecards, Lag Reports and ad-hoc requests
- Developed workflows with SQL Server Integration Services (SSIS) to integrate SQL Server 2005 tables into an Oracle database, delivered to clients and business partners through SQL Server Reporting Services (SSRS).
Account Manager
JBH Technologies, Inc
Pittsburgh, PA
02.2011 - 08.2011
- Managed customer requirements and expectations through email, phone, and face to face interactions
- Streamlined sales process through strong attention to detail and excellent organizational abilities
- Investigated, proposed, and communicated solutions in response issues reported by equipment users
Architect III
Design Collective Incorporated
Baltimore, MD
10.2008 - 03.2010
- Prioritized tasks and managed design documentation production teams for many high-profile projects
- Identified client requirements and expectations through phone, email, and face to face client meetings
- Coordinated client requirements and expectations with the design, construction, and production staff.
Associate
Mahan Rykiel And Associates
Baltimore, MD
10.2006 - 10.2008
- Successfully completed both support and management roles for many large municipal projects
- Improved document production process through research and implementation of latest CAD technologies
- Independently created documents to client specifications, resulting in client satisfaction and repeat business
- Presented project solutions, created project proposals, and managed project consultants.
Task Manager
PBS&J
Pittsburgh, PA
10.2002 - 10.2006
- Managed teams of up to 10 people while traveling throughout many countries in Europe, Asia, and the Middle East
- Elicited client requirements for numerous web-based inventory management systems
- Key contributor to the creation and implementation of a Real Property Graphic User Interface
- Led multiple training seminars for new employees
Education
Master of Science - Management Information Systems
Robert Morris University
Bachelor of Science - Landscape Architecture Landscape Architecture
Ohio State University
Columbus, OHSkills
- SAS: Data management, data mining, data retrieving
- Tableau: Creating data visualizations focused on identifying and communicating actionable insights
- Problem Solving Skills: Working with business partners to identify problems and propose data driven solutions
- Microsoft Excel: Using shortcuts and formula functions, building charts and graphs, utilizing pivot tables
- Coding Languages: Primarily SQL
- Analytical And Critical Thinking: Aptitude for descriptive analytics
Timeline
Business Analytics Consultant Lead, VP
PNC Bank
02.2023 - Current
Business Analytics Consultant Sr., AVP
PNC Bank
03.2019 - 02.2023
Business Analytics Consultant, AVP
PNC Bank
01.2014 - 03.2019
Business Analyst II, Officer
PNC Bank
01.2013 - 01.2014
Business Analyst
UPMC Health Plan
11.2012 - 01.2013
Account Manager
JBH Technologies, Inc
02.2011 - 08.2011
Architect III
Design Collective Incorporated
10.2008 - 03.2010
Associate
Mahan Rykiel And Associates
10.2006 - 10.2008
Task Manager
PBS&J
10.2002 - 10.2006
Master of Science - Management Information Systems
Robert Morris University
Bachelor of Science - Landscape Architecture Landscape Architecture
Ohio State University