Business Intelligence Product Owner

PROFESSIONAL PROFILE

Business Intelligence professional with 20+ years of experience in reporting and data analytics.

PROFESSIONAL EXPERIENCE

Nationwide Bank

Business Intelligence Analyst / Product Owner January 2011 – October 2023

Pulled data from various production sources for special projects to answer Credit Risk questions about various aspects of our customer base, building interactive visualizations in WebI.

Product owner of the reporting tool used by bank employees to build canned and ad-hoc reports and data visualizations.

Wrote and tested user stories and requirements with internal customers and developers to streamline requirements gathering and development of the bank reporting tool.

Led discussions with developers and business to track and prioritize the backlog of additional features and enhancements planned for the bank reporting tool.

Served as subject matter expert for all reporting and data analytics needs for the bank, as well as mentoring other analysts with regards to SQL and the bank reporting tool.

Tracked all data from source to warehouse and maintained the data dictionary. Worked with corporate data governance team to provide meaningful definitions to all data.

Built interactive report in Tableau to track team and project hours, issues, delays, and spend, from data obtained from Jira. This tool is still used by several different managers.

Ensured data quality between all sources and the bank data warehouse and the bank reporting database using SQL, Unix, VBA macros, and Excel.

Led discussions with business and IT users at all levels to determine requirements and scope for reports and the overall reporting environment.

Worked with cross-functional teams to identify issues with regards to reporting and analytic needs within the organization, as well as making those changes necessary to close gaps and improve inefficiencies.

Built and maintained regulatory reporting as defined by banking regulations using Excel VBA macros.

Pulled data for small analytic questions using SQL, Excel, V- and Xlookups, and pivot tables, answering and delivering insights to junior and senior leadership.

Planned, built, and maintained new reports based on various semantic layers, across several lines of business using SAP Business Objects (WebI and Crystal Reports), Tableau, Power BI, SQL, and Microsoft Office applications.

Planned, built, and maintained ad hoc reporting environment for several lines of business using Business Objects Universe Designer.

Planned, built, and maintained Informatica Power Center 9 and 10 mappings and workflows in support of Nationwide Bank’s Netezza reporting environment and the Data Vault 2.0 historical database.

Design, develop, and support ETL (Informatica) and reporting (SAP Crystal Reports) needs for commission payment system (SAP Callidus).

Plan with SAP Support for updates and maintenance activities within the Callidus system.

Nationwide Children’s Hospital

Universe Architect January 2009 – December 2010

Planned, built, organized, and maintained the tables, joins, classes, objects, and contexts that make up the main SAP Business Objects reporting universe.

Planned, built, and maintained a robust semantic layer that utilized inheritance to meet the operational and strategic reporting needs of the institution while limiting amount of Universe maintenance required to meet the needs of the end users.

Planned, built, and maintained the child universes’ relationships with the main parent universe.

Contributed to design of the database layer used to support the semantic layer.

Responsible for rebuild/redesign of existing reports within the new reporting environment.

Provided advice to other report builders on how to best use the new reporting environment.

Led discussions with internal customers to gather requirements and set scope for new reports and ad-hoc reporting environment.

Assisted trainers with lesson plans regarding use of the universes.

Developed, applied, and enforced naming standards for all database elements and universe objects.

Designed, built, and maintained process used to generate technical universe documentation, to be used by internal customers when building reports.

E-Play

Lead Developer - Reporting February 2008 – October 2008

Analyzed various reporting tools to recommend purchase.

Built, ran, and maintained all Crystal Reports tracking CD and customer behavior.

Led discussions with leadership and others to determine scope and requirements for all reports.

Worked with the database team to design the SQL Server databases for front-end and reporting use.

Honda of America

Business Objects Administrator/Developer July 2005 – February 2008

Worked with internal customers to gather reporting requirements and built the universes to support those reporting needs. These customers ranged from inventory, quality assurance, and human resources.

Trained users on the use of SAP Business Objects and assisted with report and dashboard building.

Wrote and provided documentation to users with regards to scheduling and writing both ad-hoc and static reports.

Administered the reporting user base with regards to installation and access.

Analyzed reporting needs with Teradata database administrators to determine database objects needed for reporting and any tuning needs.

Odyssey Reinsurance

Business Intelligence Programmer/Analyst May 2002 – July 2005

Worked with internal customers to determine reporting needs and build the universes to support those reporting needs. These customers ranged from underwriting, claims, finance, and actuarial.

Trained users on the use of SAP Business Objects and assist with report and dashboard building.

Wrote and provided documentation to users with regards to ad-hoc and static report building.

Analyzed reporting needs with database administrators to determine database objects needed for reporting and any tuning needs.

Supported and modified ETL from Pick database into reporting database using a proprietary ETL tool built using Delphi.

TECHNICAL SKILLS

Databases:

DB2, Oracle, Microsoft Access, Netezza, Teradata, SQL Server

ETL Tools:

Informatica, SQL Server, Alteryx

OLAP:

Power BI, Tableau, SAP Business Objects (Universe Designer, WebI, Crystal Reports), Data Vault 2.0

Other Software:

Development Languages:

Microsoft Office, Microsoft Visio, Unix Shell

Transact-SQL, PL/SQL, Python, VB.NET, VBScript, Delphi

CERTIFICATIONS AND ACCREDITATIONS

PL-300 Microsoft Power BI Data Analyst

Business Objects XI R2: Universe Design

Business Objects XI R2: Web Intelligence

AWS Certified Cloud Practitioner

EDUCATION BACKGROUND

Clarkson University

B.S., 1993

Major: Chemistry

Minor: Mathematics and Army ROTC

Contact this candidate