Summary
Overview
Work History
Education
Skills
Timeline
Generic

GARY F. KOSS

Smithfield,RI

Summary

Business intelligence and data warehousing/architecture professional with over 15 years of experience driving business solutions through leading-edge technology for national and global organizations spanning $200M to $10B+ Genuinely passionate about data architecture design with expertise in BI system design, implementation, and optimization

Overview

14
14
years of professional experience

Work History

Database Administrator

  • Hands for Hire VS Seat at the TABLE!!! ) - support of GE’s world-class core functionality of our SupportCentral platform across all of our GE businesses
  • Product Manage of GE Digital build Data Warehouse KPI from source systems
  • Designing Dimensional Data Model to support Membership Metrics and Analysis
  • Both On Premise & Cloud (MS Azure) Databases
  • Managing initiative to build Data Warehouse KPI from source systems
  • Designing Dimensional Data Model to support Membership Metrics and Analysis.

Project Manager & Release

IBM
  • Manager for Data Warehouse initiatives utilizing, DataStage and Netezza
  • Dramatically improved business and financial functions by creating the most widely used corporate system; introduced improvements that grew the enterprise BI platform user base from 40 to 500+
  • Cited for Best Practice of User Provisioning and Security for Six Sigma Kaizen Event
  • Tackled and resolved issues of BI security and governance by working with 14 business areas to gather insights, determine priorities and initiate strategic planning and change initiatives
  • Managed a team in the administration of SAP Business Objects Enterprise Reporting and ensured 100% compliance with corporate ethics and guidelines
  • Planned and oversaw concurrent version upgrade to meet future business needs which included resource planning and budget ownership and accountability
  • Led ERP Database Indexing and Infrastructure troubleshooting to improve critical reporting timely delivery
  • Developed and implemented enterprise data governance program with process flows, end-user training, request forms and identification of data owners and authorized approvers
  • Managed for the functionality, performance, troubleshooting and management of the enterprise-wide SAP Business Objects Enterprise Reporting Program
  • Provided leadership and support for CMC administration, database connectivity, security, universe design and report development/scheduling
  • Managed WEBI intelligence, performance management dashboards and SAP case management and facilitated training programs.

BI and Data Warehousing Consultant

PRICEWATERHOUSECOOPERS LLP
  • Executed client engagements and served as BI and data warehousing subject matter expert for high-profile organizations in the financial and insurance fields
  • Performed business analysis and proposed fiscal management solutions
  • Established open communication with internal and external stakeholders
  • Selected Contributions:
  • Fidelity Investments: designed a Best Practice Research Study highlighting 34 benchmarks for the seamless, full-life cycle implementation of Hyperion ESSBASE and Multi-dimensional OLAP
  • Bombardier Capital: served as Assistant Project Manager in implementing Oracle Financials for global client
  • Coordinated the complete project life cycle through implementation, testing and launch
  • FMGlobal Insurance Company: analyzed business practices and designed functional specifications for web-enabled data warehouse that will enable Engineers and Architects to configure an international commercial roofing system.

Senior Data Engineer

General Electric, GE
01.2019 - Current
  • Corporate CoreTech & Cyber / CORP CTCR-Digital Workplace
  • Design & lead database solutions to provide a flow of essential information to make critical decisions
  • Lead Data Warehouse Team to deliver
  • Executive dashboard of crucial metrics to identify scalability of production, reduce costs and mitigate risks
  • NEED TO SHOW THAT I Can deliver results!!! SHOW THEM THE $$$
  • CAN I PUT ALL THAT I’VE DONE IN 3 SHORT SENTENCES??
  • 3 MOST IMPORTANT
  • LET THEM ASK THE REST!!
  • STAR – SITUATION, TASKS, ACTION & RESULTS!!! HAVE 3 STORIES READY
  • Can they scale prod
  • Yes!!! INEED TO EVOLVE FROM ENGINEER TO LEADER
  • What does it solve!!! How does it create $$$?
  • Expand capacity by engaging global diverse teams to apply agile and lean methodologies.

Business Intelligence Project Manager

AAA NORTHEAST
03.2018 - 12.2018
  • Managing initiative to build Data Warehouse KPI from source systems
  • Designing Dimensional Data Model to support Membership Metrics and Analysis.

Sr System Analyst/Data Warehouse

FIDELITY INVESTMENTS
06.2015 - 12.2017
  • Partnered closely with internal customers (e.g
  • VPs, Directors, Managers, PMs, Analysts, Developers and Architects within risk, marketing, operations services, finance and customer service) to understand their initiatives and analytical needs, translate those needs into concrete technical requirements, gain consensus & sign-off and design a Dimensional Data Model solution from Source to Target using Kimball Dimensional Modeling within the Fidelity Data Warehouse
  • Subject Areas engaged included: trading, transactions, positions, money movements, cashiering, call center upgrades
  • Performed complex research and analysis of complex high volume transactional source systems for the purpose of designing solutions in both Real Time & Historical Reporting on very large-scale databases; Oracle, Netezza, IBM Mainframe and SQL Server
  • Worked on several Big Data POCs: Hadoop sourced data on Oracle and applying Data Quality with Informatica IDQ; Migrating from Netezza Data Models onto Hadoop and validating query performance and tuning with SQOOP and Hive Hue on Hadoop.

LIFESPAN Sr System Analyst

SAP
03.2014 - 05.2015
  • Sized and scaled, designed and implemented, Business Intelligence Suite 4.1, to support Epic Healthcare system conversion supporting over 13k users
  • Implemented SAP products included over 40 SAP Business Objects Universes, Business Explorer and over 900 Crystal Reports using both Clarity and Cogito Data Warehouse databases
  • Designed enhancements to Data Warehouse using Star Schema methodology
  • Lead efforts with the Strategic Planning and the Operational Excellence departments to build advanced analytical self-service reporting using SAP products.

Data Architect

FALLON COMMUNITY HEALTH PLAN
09.2013 - 12.2013
  • Designed & developed a Data Model DDL using Erwin to meet Affordable Care Act “Out of Pocket Maximum” (OOPM) reporting requirements.

Enterprise Business Intelligence Architect

BLUE CROSS BLUE SHIELD OF RHODE ISLAND
10.2007 - 05.2013
  • Reported to AVP Enterprise Information Management and spearheaded technology projects supporting and improved business operations on an enterprise-wide scale
  • Managed and administered all aspects of SAP BI/Data Warehouse Reporting Program (Facets, SunGard, Direct Pay, Grievance & Appeals, Medicare, and Customer Service)
  • SME on enterprise BI reporting for ICD10 (Diagnosis and Procedure)
  • Created and enhance solutions for scheduling, auditing and HIPAA compliance, data profiling, data governance & meta data
  • Designed and lead Enterprise BI upgrades projects
  • Supervised teams in developing BI reporting, ETL code, database connection and Enterprise Reporting Platforms
  • Conducted presentations to leaders and end users and introduced and enforced policies, procedures and best practices
  • Managed a team of 6 outsourced BI Developers, Platform Administrators and Project Managers
  • Managed multiple concurrent vendors as both Project Manager and Business Owner to build out an SAP Business Objects Enterprise Business Intelligence Reporting Program for the State's Dominant Healthcare Provider during its 4 year $250M Facet's Claims Adjudication System Implementation
  • Program provided in excess of 600 unique Crystal Reports covering all business lines
  • Provided for Data Center Scheduling Events, HIPAA compliance and is fully scalable and auditable.

Education

Master of Business Administration - Business Administration And Management

Bryant University
Smithfield, RI

Bachelor of Science - Accounting

Bryant University
Smithfield, RI

Skills

  • Finance and Accounting Degree and Background
  • Data architecture design
  • Enterprise BI and data warehouse solutions
  • SDLC management and launch
  • Business Intelligence Software: SAP Business Objects Enterprise Platform, Administering Servers & Security, Sizing Platforms, Deployment, Hot Fixes, and Service Packs
  • Databases: Oracle, Netezza, Sybase, SQL Server, Indexing, Triggers, Scripting, Patches and Fixes
  • Query Tools: SQL Server Management Studio, Toad, Aginity, SQL Server Management Studio
  • Process: MS Visio
  • PM Tools: MS Project, JIRA
  • Data Modeling: CA ErWin 8 & 9
  • ETL Tools (“Lift & Shift” Data Tools): SAP Data Services, IBM DataStage, Informatica
  • Content Management: SharePoint, Worksite
  • Additional Tools:
  • SAP BOE Universe Designer, SAP BOE Information Design Tool, SAP BOE Webi Intelligence (WEBI), Security Authentication LDAP & Windows AD Authentication with SSO, BOE XI r2, 31 Central Management Console, Brio Query, Crystal Reports XI r2, Fiserv InformEnt, Visual Studio, MOLAP Cube, Hyperion ESSBASE OLAP Server 61, HTML, CSS, XML, VB Script, Microsoft Office
  • Software Used:
  • Toad for Oracle, Informatica IDQ, Aginity for Netezza, JIRA, MS Visio, SAP Business Objects and MS SQL Server Management Studio SQL Server Stored Procedures (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • Strong SQL scripting skills including stored procedures, triggers and functions
  • Expertise in standard software development techniques (SDLC) and Project Management
  • Experience with configuration of business rules and design of applications using business rules

Timeline

Senior Data Engineer

General Electric, GE
01.2019 - Current

Business Intelligence Project Manager

AAA NORTHEAST
03.2018 - 12.2018

Sr System Analyst/Data Warehouse

FIDELITY INVESTMENTS
06.2015 - 12.2017

LIFESPAN Sr System Analyst

SAP
03.2014 - 05.2015

Data Architect

FALLON COMMUNITY HEALTH PLAN
09.2013 - 12.2013

Enterprise Business Intelligence Architect

BLUE CROSS BLUE SHIELD OF RHODE ISLAND
10.2007 - 05.2013

Database Administrator

Project Manager & Release

IBM

BI and Data Warehousing Consultant

PRICEWATERHOUSECOOPERS LLP

Master of Business Administration - Business Administration And Management

Bryant University

Bachelor of Science - Accounting

Bryant University

Similar Profiles

CREATE PROFILE
GARY F. KOSS