Ross Y. Ozaki
Farmington,CT
Summary
Senior Business Analyst/Data Analyst professional with proven ability to drive strategic initiatives and deliver impactful results. Strong focus on team collaboration, adapting to changing needs, and ensuring reliable performance. Expertise in project management, data analysis, and stakeholder engagement, combined with excellent problem-solving and communication skills. Known for integrity, reliability, and dedication to achieving organizational goals.
Overview
23
23
years of professional experience
Work History
Senior Consultant, Data Management
Travelers Insurance
03.2023 - 02.2025
- Working on an agile team towards data modernization.
- Moving legacy applications to cloud sources for reporting.
- Mapping attributes from source system to stage database.
- Collaborating with Data Engineers to review and implement queries.
Senior Consultant, Data Management
Travelers Insurance
01.2020 - 03.2023
- Migrated 23 queries from HOST mainframe jobs to Teradata SQL.
- Submitted data call requests from state insurance departments.
- Developed KNIME automation of SQL queries to reduce time required to generate state reports.
- Evaluated existing business processes, recommending improvements that led to increased operational efficiency.
- Provided thorogh reviews with business customers to review data call requirements are met and data was verified prior to submission to state insurance bureaus.
Consultant, Management Information
Travelers Insurance
03.2013 - 01.2020
- Worked with business customers, business analysts, and other subject matter experts to derive requirements for design of SSIS package to identify unused appointments which result in unnecessary cost in renewal fees to the company.
- Assisted in analysis of business requirements and writing of SQL code and SSIS package necessary to identify agent or agency appointments that could be potentially terminated due to lack of production.
- Project successfully identified 252,135 appointments that could potentially be non renewed resulting in a savings of $3.5 million in appointment fees.
Lead Associate-Metrics
AXA Equitable
08.2009 - 03.2013
- Produced daily, weekly, monthly, and quarterly reports obtaining information from multiple SQL databases, MS Access, and MS Excel to compile and generate reports.
- Works closely with IT to resolve any wholesaler inquiries on compensation on life insurance cases.
- Coordinates with IT to support wholesaler assignments for retail and third party distribution sales organizations.
- Works with the sales senior management team and runs SQL queries to create sales reports in MS Access and Excel.
- Responsible for all ad hoc reporting regarding new business and underwriting application counts, compliance requests for information, and licensing reports.
- Trained as system administrator for Salesforce.com. Assists with testing and signoff of releases into the production environment.
- Assisted with the release of Salesforce.com, conducted testing(utilizing Quality Center), and assisted with creating custom reports.
Senior IT Business Analyst
The Hartford Financial Services Group
07.2004 - 05.2009
- Responsible for enhancements on application to create commission payments to broker dealer firms. Worked with business and developers to determine scope and estimates for system enhancements and created business specifications. Validated project requirements with marketing and product development teams.
- Identified defect for fixed product renewal commissions not calculating and worked with developers and business partners to implement code change.
- Created SQL query to create report for capturing affected contracts in the interim so that business customers could pay the commissions manually until code change was implemented.
- As a result commissions were calculated systematically and thus eliminated the need for a full time employee to manually disperse commissions.
- Implemented requests for custom commission schedules.
- Met with business customers monthly to discuss and prioritize enhancement requests.
- Produced SQL scripts necessary for the release of approximately 20 new products as part of Leaders 4 and CRC Select II projects.
- Conducted SIT testing utilizing Quality Center and delivered commission schedules within standard of 99% defect free.
- Wrote and executed custom SQL scripts for data validation in test environments.
- Ensured SQL insert scripts were checked in and versioned correctly for implementation in PVCS Tracker on time for each test environment.
- Assessed and resolved production support issues with remote on and offshore resources utilizing Remedy application.
- Worked with application manager and project managers to quickly assimilate and estimate change control items as they arose.
- Created custom SQL queries as needed as requested by other departments.
- Followed SDLC methodology for projects.
Business Analyst
The Hartford Financial Services Company
10.2001 - 07.2004
- Conducted quality assurance testing for implementation of PRIME project. Reported system problems and worked with system developers to identify and resolve issues.
- Assisted with training team members on Prime system.
- Initiated system improvement for Vista selling agreement windows expanding window view and adding filters allowing users to choose views based on different criteria.
- These changes resulted in reduced time required for research in selling agreement maintenance. Also responsible for quality assurance testing and reviewing design specifications with business partners and IT staff on system releases and communicating changes to the system users.
- Utilizes SQL to validate data with IT staff and run report requests for business partners.
Timeline
Senior Consultant, Data Management
Travelers Insurance
03.2023 - 02.2025
Senior Consultant, Data Management
Travelers Insurance
01.2020 - 03.2023
Consultant, Management Information
Travelers Insurance
03.2013 - 01.2020
Lead Associate-Metrics
AXA Equitable
08.2009 - 03.2013
Senior IT Business Analyst
The Hartford Financial Services Group
07.2004 - 05.2009
Business Analyst
The Hartford Financial Services Company
10.2001 - 07.2004
Similar Profiles
Anastasiia PotychkoAnastasiia Potychko
Business Process Management Intern at Travelers InsuranceBusiness Process Management Intern at Travelers Insurance
Terilynn SalasTerilynn Salas
First Party Medical Adjsuter at Travelers InsuranceFirst Party Medical Adjsuter at Travelers Insurance
Joy TuttleJoy Tuttle
Claims Adjuster at Travelers InsuranceClaims Adjuster at Travelers Insurance
Eliel PolancoEliel Polanco
Property Resolution Claim Representative at Travelers InsuranceProperty Resolution Claim Representative at Travelers Insurance
Niranjan Rajesh KumarNiranjan Rajesh Kumar
Mathematics Tutor at RSMMathematics Tutor at RSM