Renne Botchway

Developed serverless applications using Python and AWS Lambda for real-time data analysis, and delivered a Bedrock agent with RAG over finance policy documents. Built ETL pipelines with S3, Snowflake, and Matillion, optimising SQL queries to reduce runtime by 60%.

Engineered a multi-layer Snowflake data warehouse for Motor and Household Claims and Underwriting domains, with schema versioning via Flyway and Matillion CI/CD pipelines. Built CDC-based incremental loading pipelines and implemented a metadata-driven data retention framework.

Architected proxy hedging data pipeline integrating dimension tables and forward curve pricing, reducing processing time by 60%. Led modernisation of legacy Oracle-based trading platform to AWS cloud-native services and transitioned from Matillion to dbt.

Designed scalable data solutions using AWS, SAP, dbt, Snowflake, and Fivetran, pioneering a custom marketing data platform integrating 10+ sources and reducing data collection time by 80%. Achieved 40% improvement in Power BI dashboard performance.

Built real-time streaming data pipelines using AWS Kinesis, Lambda, and Glue for scalable ETL workflows, enhancing Power BI dashboards with complex SQL queries in Redshift. Led team optimisation of data pipelines, reducing processing times by 40%.

Established data analytics and business intelligence functions within finance transformation programme, optimising Power BI dashboard performance by 40%. Designed and implemented SSIS packages for automated ETL processes, reducing manual data preparation time by 45%.

Implemented Power BI to analyse and report on large datasets for GE Power division, identifying underperforming product lines and saving $300k annually. Created interactive dashboards generating monthly/quarterly reports, saving 8 hours per week FTE.

Integrated Salesforce with SAP ERP data tools across finance departments, achieving 65% reduction in pricing quote turnaround time through automated workflows and data consolidation.

Managed payroll processing and bonus calculations for 200+ employees, coordinating with HR and finance teams to resolve discrepancies and ensure regulatory compliance.

Prepared comprehensive financial statements including P&L, balance sheets, and cash flow statements for 5 entities, ensuring accuracy and compliance with accounting standards.

Professional qualification as ACMA and CGMA from the Chartered Institute of Management Accountants.

Bachelor of Business Administration (Hons) from the University of Kent at Canterbury.