ardian
timeline and tech
september 2024 - december 2024
- python
- javascript/typescript
- nextjs
- sql
- pytorch
- .net
role
ardian is a global private investment house with a strong focus on long-term value creation. i contributed as a software engineer intern on the prgx division(more specifically on the audit recovery team).
work product
i focused on building data-driven infrastructure to streamline audit operations and enhance query efficiency. i began with implementing and improving etl pipelines to extract and transform data from large relational databases for further qa screening. this included optimizing sql queries and views. one of the core projects i worked on involved engineering a gui-driven pipeline in python to automate extraction and organization of embedded objects from complex excel files. this tool simplified internal audit workflows.
to manage client datasets, i developed parallel column-level fluctuation detection scripts to identify optimal segmentation criteria. this enabled smart partitioning of combined tables and supported efficient deduplication logic. i also worked on optimizing system stored procedures within the server environment.
machine learning
i conducted research & development into a random-forest anomaly detection approach for client-statistic report analysis. an internal tool used sql scripts to produce stat reports that were sent back to clients. before delivery, analytics had to validate details like vendor population and field-level patterns against prior years, which was a heavy manual task. using historical validated reports, we trained a model to predict whether rows needed qa attention (binary prediction / confidence scoring). this used isolation forest as the primary approach and gave me strong hands-on experience with model fit against real enterprise data workflows.