Looking for a job

Aditya Pratap

@adityapratap2

Message

Senior Data Modeler at SATC shaping insurance data models and Guidewire integrations for U.S. markets.

India

Message

At SATC, I work on the P & C Insurance project, providing functional support for product development in U.S. markets. I develop insurance OLTP and dimensional data models and design interfaces between Guidewire and external systems.

At Iris Software, I designed enterprise data models for trade, accounting, settlement, risk, and regulatory reporting across Equities, Fixed Income, FX, and Derivatives. I also developed data dictionaries and source-to-target mappings, and implemented a Medallion Architecture for trade and risk data.

Across healthcare, pharma, financial services, and machine health projects, I’ve worked on data modeling, ETL, analytics, and reporting. My work has included building Alteryx flows and Power BI dashboards, as well as designing models for Databricks Lakehouse implementations.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Modeler

Current

SATC

Jun 2024 - Present (2 years 4 months)

Working for a North America Insurance client, providing functional support for product development for U.S. markets. Involved in development of Insurance OLTP/Dimensional data modeling and configuration of Guidewire System components.

Data Modeler

Iris Software

Oct 2020 - Jun 2024 (3 years 8 months)

Designed enterprise data models supporting stock and multi-asset trade lifecycle, accounting, settlement, risk and regulatory reporting across Equities, Fixed Income, FX and Derivatives. Implemented Medallion Architecture to standardize ingestion, transformation and consumption of trade and risk data.

Erwin Data Modeling Dimensional Modeling Calypso Treasury System Murex SwapOne Medallion Architecture Data Dictionary Metadata Source To Target Mapping

Senior Data Modeler

Wipro

Mar 2018 - Dec 2019 (1 year 9 months)

Designed and developed data models for pharma domain covering end-to-end drug lifecycle, clinical trial operations, adverse event tracking, pharmacovigilance and regulatory reporting. Created dimensional models for clinical trial data and drug safety data.

Data Modeling Dimensional Modeling Clinical Trial Data Pharmacovigilance Regulatory Reporting Erwin

Analyst

GlobalLogic

Oct 2015 - Oct 2017 (2 years)

Created Alteryx flows to read client files and modify incoming data, used SQL queries to fetch existing DB2 data, and created dashboards in Power BI. Supported data analysis, requirements gathering, and solution development.

Alteryx SQL DB2 Power BI Python Pandas NumPy Matplotlib Azure Data Factory

Analyst Trainee

HCL Technologies

Dec 2012 - May 2015 (2 years 5 months)

Worked on Augury Machine Health solutions, leveraging data-driven insights to increase client engagement. Led creation of Customer Health Score project and improved analytics around days to label and time to review.