Stephen Ger Email & Phone Number

•Eliminated 78% of manual work merging information between two databases using OpenAI’s GPT 3.5 Turbo.•Architected a web-based policy rerating system, reducing process time from hours to seconds and improving reliability.•Implemented a Python and FastAPI backend with a MongoDB database, consolidating 10 state-specific SQL-based reraters into one unified system.•Enabled advanced reporting features, streamlining analytics across multiple departments and replacing outdated Excel-based methods.•Automated fraud detection processes, flagging inconsistencies for review.•Acted as a go-to expert for ad-hoc data tasks spanning Claims, Underwriting, Product, Actuarial, and Marketing.•Reported directly to the President and closely collaborated with SVPs.

•Automated document processing using Python, optical character recognition (OCR), and natural language processing (NLP), cutting manual document review by 20%.•Utilized Python to automate various web-based processes, completing weeks' worth of manual work in hours.•Develop new models to fine-tune rate algorithm, improve retention, and increase profitability.

•Overhauled rate-change process, replacing slow and error-prone Excel processes with SQL.•Automated Excel report refresh and email distribution using PowerShell scripting.•Standardized complex SQL processes with stored procedures and inline table-valued functions.•Developed cost-benefit analyses for 3rd party vendor products.•Designed SQL onboarding course and mentored junior team members.

Plano, Texas

•Created unified Budget Plan and KPI reports to accurately track company profitability and production metrics.•Handled SERFF filings and objections for Personal Auto and Renters products in Texas and Ohio.•Provided SQL queries as the benchmark for accuracy for new data warehouse system.