Experience

Hiscox USA

• United States
• Insurance
• 300 - 400 Employee

• Senior Business Analyst

  • May 2022 - Present



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Managing Consultant

  • Aug 2000 - May 2022

  Internal consultant/team leader for business development for long-term database and reporting project Led team of business analysts and developers to integrate disparate data (bidding to ledger) into a centralized analytic and report hub for utilization and profitability analyses. Created process for merging bid and fulfillment data to enable previously unavailable measurements of winning bids without requiring changes of upstream systems. Designed extraction routines, error detection and record repair routines, processing logic to join data to derive resultant information. Monitored development of database structures and conducted testing of resultant. Developed SQL, Excel, and Cognos Analytics reports and dashboards showing profitability by key metrics. Trusted advisor to client for interpretation and explanation of revenue and ledger data. Provide continual updating and enhancements of system through changing landscape of sources including adoption of new ERP system. Represented client in ERP process design stipulating data capture and data extraction rules.