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