Enterprise · 2014 – 2015 · Cognizant — Financial Services Client

Profitability Analytics Dataset

Enterprise data warehouse for actuarial predictive analytics

Context

Consolidated premium and loss data from 12 heterogeneous upstreams — mainframe COBOL flat files, DB2 z/OS, and MSSQL — into a Teradata staging zone, then transformed it through Informatica PowerCenter workflows into a curated functional layer used by the Actuary team for predictive analytics on the P&C portfolio.

Architecture

Loading diagram...
Swipe the diagram sideways →

What I owned

  • Sourced premium and loss data from 12 heterogeneous systems (mainframe COBOL files, DB2 z/OS, MSSQL) into a single analytics-ready layer on Teradata
  • Established the PowerExchange connections and mapped incoming records against COBOL copybook layouts — the deepest technical lift on the program
  • Designed Informatica PowerCenter workflows for Stage / Raw-Base / Functional layering, the schema Actuary built predictive models against
  • Optimized partition strategy and parallel load — reduced nightly load window by 4 hours
  • Owned end-to-end ETL delivery as Sr Engineer IC across 12 source platforms

Stack

Informatica PowerCenterPowerExchangeTeradataDB2MSSQLCOBOLShell ScriptsJCLCopybooks