Catherine Franke Email & Phone Number

Cedar Park, Tx, Us

Austin, Texas

Part of the management team responsible for ensuring the infrastructure to deliver water/sewer services to over 1800 homes is maintained. Serves on the Park subcommittee and the Deed Restriction Committee.The Parks subcommittee oversees maintenance and improvements in the WTCMUD1 parks. Past projects include: Replacing playscape equipment and installing shade coversRenovation of the community center which included security and AV upgrades. Installation of the Wildflower Micro Disc Golf CourseMemorial GardenCurrent ProjectsDeveloping a 5 year plan for park improvements

Austin, Texas Area

Develop ETL processes using T-SQL to support data analytics in the enrollment department.Migrate Access DB processes to SSIS and SQL.Develop processes to create transactional data for data analytics to identify trends in membership andnetwork sufficiency.Develop SQL stored procedures that run in a parameterized environment to validate across multiple products.

Data Warehouse Developer ■ Developed policy system data extracts■ Updated transform code written in T-SQL to accommodate changes in source systems ■ Implemented process to track & cleanup dirty data from source systems■ Installed & configured BusinessObjects■ Developed reports for internal | external users■ Developed BusinessObjects Universes optimized for different time | transaction reporting objectivesData Administrator■ Managed on-going loading, verification and validation of data into data warehouse■ Wrote analysis programs in T-SQL to identify missing|incorrect data. Identified|corrected existing data | implemented solutions to prevent moving forward including changes to business process, training | additional data validation in source systems■ Worked with accting dept to develop reconciliation process between policy system & general ledger for Accounts Receivable/Unearned Premium/Earned Premium, bank reconciliation process between the general ledger & the data warehouse■ Researched reconciliation items uncovered by accting. Determined cause & resolved problem with correction of source data | training of system end-usersProject Manager for system migration■ Wrote data extracts■ Wrote rating model requirements■ Implemented rating modelsBusiness Analyst ■ Analyzed profitability by multiple dimensions such as line of business, insured, policy yr, loss yr, fiscal yr, reinsurance yr■ Loss ratio analysis■ Analyzed rating models■ Designed web data collection requirementsProgrammer/Analyst for policy admin system■ Programmed premium calculations. ■ Developed all reporting■ Developed business process with accting dept for automated invoice export/import to replace manual data entry into accounts receivable. Export generated journal entries which were tracked so historical extracts could be reproduced to meet financial auditor requirements■ Managed coding & documentation■ Implemented version control system■ Wrote testing specifications

Lead programmer for the RPMS multi-line policy administration system written in PROGRESS 4GL. Managed system development to support the entire underwriting life cycle. ■ Programmed all rating algorithms and maintained associated rate structures.■ Developed all reporting from policy system required for policy administration including reinsurer reporting requirements.■ Wrote requirement specifications for junior team members to implement.■ Created testing specifications as part of system deployment.■ Wrote data conversion programs as part of implementing policy administration system for TAC.■ Wrote user manual for policy administration system.

Performed policy renewal and endorsement activities including the placement of specialty coverage with TCPIA.