PROFESSIONAL PROFILE

IT specialist with **+ years of professional experience in warehouse development and universe design. Expert and highly familiar with a wide variety of security, engineering, networking, and operating system software.

TECHNICAL SKILLS

Databases:

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

ETL Tools:

Informatica, SQL Server

OLAP:

Power BI, Business Objects Universe Designer, Business Objects Web Intelligence, Crystal Reports

Other Software:

Development Languages:

Microsoft Office, Microsoft Visio, Unix Shell

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

PROFESSIONAL EXPERIENCE

Nationwide Financial

Specialist, NFIT July 2018 – October 2023

Nationwide Financial provides various investment and retirement services to businesses and individuals. NFIT provides full product lifecycle services for the products in this space, from design and development to maintenance and support.

Agile Team: Commissions Team

Overview:

CommSquad performs end-to-end responsibilities on the Callidus Commission application owned by NFCS.

Responsibilities:

Design, develop, and debug code in support of all aspects of the Callidus application.

Provide on-call support for Callidus application.

Build and train team on use of GitHub code repository.

Provide access to new users with regards to all aspects of the Callidus application.

Agile Team: Claims Team

Overview:

The Agile Rangers provide full-suite support for several applications in IPS, most notably the Claims Desktop and ITAM.

Responsibilities:

Assist business users in the use of the web-based Claims Desktop.

Enhance data quality by correcting data as directed by the business users.

Rebuilt Life Data Feed ETL flow to work in a production environment, after having been running on a personal laptop.

Agile Team: Data Warehouse Team

Overview:

The Elite Transformers provide development and application enhancement services for the Nationwide Financial Data Warehouse and many of the warehouse’s supporting data sources.

Responsibilities:

Provide ETL development support and training for newer developers in the use of Informatica and its supporting environments.

Build and modify ETL scripts to support the organizational direction in moving to a cloud-based environment.

Nationwide Bank

Specialist, Credit Risk December 2015 – June 2018

Nationwide Bank provides banking services to businesses and individuals. The Bank Data Warehouse contains several years of data consisting of loans, credit cards, and deposit information, and is currently in a state of improvement.

Bank Credit Risk

Overview:

The Credit Risk team develops models and analyzes data to predict risk regarding the financial stability of potential customers, current customers, and purchase pools.

Responsibilities:

Use advanced SQL knowledge to navigate source reporting from 40+ different monthly files.

Produce an ILDR report monthly that is sourced from many disparate data sources. Report is utilized by management as a comprehensive view of all Bank assets. This report is shared with the government as part of our regulatory requirement.

Developed and maintain exception reporting for all Bank products. This reporting is presented to executive management monthly to understand the risk present within the Bank portfolio.

Top-level subject matter expert on all data-related inquiries from internal and external partners.

Provide direction in matters of data integration and data governance.

Frequently work with multiple areas of the Bank to coordinate data needs, including: Product Management, Compliance, IT, Marketing, Operations, Accounting, and Finance.

Creation of many periodic and ad hoc reports to understand production vs. plan, new business mix and inherent risk within the portfolio.

Led new employee training on systems, data extraction tools, and general Banking knowledge.

Communicate with technical and non-technical peers regarding requirements for Bank Data Warehouse improvements.

TEK Systems/FTE

Data Warehouse Developer - consulting October 2011 – December 2015

Data Warehouse Developer

Overview:

Core member of agile team responsible for the design and construction of the semantic layer used to support the reporting needs of the team tasked with tracking loan, credit card, and deposit accounts.

Core member of agile team responsible for developing complex reports, and training non-technical users on how to use the semantic layer to develop their own ad-hoc reports.

Additional member of agile team responsible for building and maintaining ETL scripts used to populate the data warehouse.

Responsibilities:

Plan, build, organize, and maintain the tables, joins, classes, objects, and contexts that make up the universe.

Train bank users on use of the semantic layer.

Contribute to design of the database used by the semantic layer.

Contribute to development of ETL processes used to populate the data warehouse.

Provide user-friendly documentation regarding the design of the semantic layer.

Nationwide Better Health

TEK Systems

Universe Designer/Reporting Lead - consulting January 2011 – August 2011

Nationwide Better Health supplies client companies a health improvement system. Client employees, spouses, and dependants participate by filling out surveys on a yearly basis and enrolling in self-improvement activities. Nationwide Better Health provides clients with timely status reports on their employees’ overall health.

Universe Designer

Overview:

Core member of team responsible for the design and construction of the semantic layer used to support the reporting needs of the team tasked with tracking employee health surveys for Nationwide Better Health clients.

Responsibilities:

Plan, build, organize, and maintain the tables, joins, classes, objects, and contexts that make up the universe.

Contribute to design of the database used by the semantic layer.

Provide user-friendly documentation regarding the design of the semantic layer.

Reporting Lead

Overview:

Lead developer for reports tracking employee health surveys for Nationwide Better Health clients.

Responsibilities:

Plan, build, and maintain new reports based on the semantic layer.

Provide assistance and training to business analysts and report builders on how to develop complex reports.

Provide user-friendly documentation regarding the development and maintenance of all new and inherited reports.

Environment:

Windows XP, Netezza, Business Objects XIR3, WebI, Business Objects Universe Designer, WinSQL

Nationwide Children’s Hospital

TEK Systems

Universe Architect - consulting January 2009 – December 2010

The EDW Group at NCH is responsible for providing a new reporting environment for the various departments within the hospital, as well as modifying all old reports to work within the new reporting environment.

Universe Developer

Overview:

Core member of team responsible for the design and construction of a robust semantic layer used to support the operational and strategic reporting needs of the institution.

Responsibilities:

Plan, build, organize, and maintain the tables, joins, classes, objects, and contexts that make up the main parent universe.

Plan, build, and maintain a robust semantic layer that utilizes 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.

Plan, build, and maintain the child universes’ relationships with the main parent universe.

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

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

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

Gather requirements, design and build new reports for internal customers.

Assist trainers with lesson plans regarding use of the universes.

Develop, apply, and enforce naming standards for all database elements and universe objects.

Design, build, and maintain process used to generate technical universe documentation, to be used by internal customers when building reports.

Environment:

Windows XP, Oracle 10g, Business Objects XIR3, WebI, Business Objects Universe Designer, SQL Developer

e-Play

Lead Developer - Reporting February 2008 – October 2008

e-Play provided a Redbox-like machine in several locations that allowed customers to rent and return DVDs.

Analyze various reporting tools to recommend purchase.

Build, run, and maintain all Crystal Reports tracking CD and customer behavior.

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

Honda of America

Business Objects Designer / Developer / Administrator July 2005 – February 2008

Honda of America builds motorcycles, automobiles, recreational vehicles, and power tools.

Work with internal customers to determine reporting needs and build the universes to support those reporting needs. These customers ranged from inventory, quality assurance, and human resources.

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

Write and provide documentation to users with regards to scheduling and writing both ad-hoc and static reports.

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

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

Odyssey Reinsurance

Business Intelligence Programmer/Analyst May 2002 – July 2005

OdysseyRe is a leading provider of reinsurance and specialty insurance.

Work 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.

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

Write and provide documentation to users with regards to ad-hoc and static report building.

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

CERTIFICATIONS AND ACCREDITATIONS

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

GPA: 2.8

Contact this candidate