Quoting more than $3.5 billion annually, ICW Group Insurance Companies is the largest privately held insurance company domiciled in California. I develop and maintain the logic for pricing our workers compensation line and work closely with various departments such as DevOps, DBA, and Underwriting to ensure timely and accurate production releases. I also conduct various analyses to ensure our rates are fair and reflect the latest trends. I have built several applications to automate much of my department's tasks and to facilitate handling large amounts of data using various languages such as Java, Python, R, SQL, VBA, Batch scripts, etc. I'm also currently developing for our XML and Excel based pricing API, building out JSON test cases for our QA work using Postman, assisting our development team in porting existing code from various languages to Java, debugging and implementing fixes for our nightly SQL ETL pipelines, and a host of other responsibilities.
Highlights
- Designed and built ETL application in VBA using Factory and Reflection Patterns to process over 30 Excel tables of varying dimensions and locations for upload to a normalized SQL database
- Rebuilt SQL ETL stored procedure to random sample warehouse data up to a specified size, reducing an iterative 21-pull process down to a single pull
- Automated data cleaning, uploading, and manipulation tasks using VBA, R, SQL, and Python
- Debugged SQL ETL pipelines with over 15,000 lines of code
- Pair-programmed with Java developers to build pricing webservice API using Spring Boot
- Conducted actuarial analyses on loss forecasting, credibility weighting, territorial segmentation, and other studies to offer competitive prices
- Designed JSON test samples for testing webservices using Postman
- Worked with end users to define SRS for new features
- Trained new and rotational staff on writing clean, reusable, and scalable code