John Sarsfield Cdmp, Cbip Email & Phone Number

Columbus, Ohio Area

Quick Solutions is now Fusion Alliance.Consulted at State Auto in Columbus, Ohio, providing data analysis and business intelligence reporting primarily for the home and auto actuarial and pricing groups.Previously consulted at Nationwide Insurance as a data analyst within their Information Management group. The engagement focused on simplifying a complex.

Westerville, OH

Currently consulting for an on-site program at a Fortune 100 company in central Ohio as a data analyst within their Information Management group. The program focuses on simplifying a complex data warehousing environment by eliminating data redundancy across the multiple subject areas without negatively impacting the many dependent analytical layers involved.

Columbus, Ohio Area

• Managed the default reporting team in Columbus and Parma, OH supporting all default lines of business, including Default Risk, Bankruptcy, Foreclosure, Loss Mitigation, and Consumer Collections. Led project for.
• Supported internal and external audit groups such as the OCC and CFPB and ensured accurate reporting and context were provided in all data provided
• Re-engineered reporting operations to accommodate early morning report SLAs
• Developed cross-departmental monitoring reports and applications that eliminated hundreds of weekly man-hours spent manually reviewing for processing exceptions or compliance issues
• Managed external vendors and data providers to ensure accurate and timely data interchanges
• Acted as process improvement specialist to lines of business by utilizing fact based measurements of current and future state processes.

Columbus, Ohio Area

• Participated as a technical lead and data architect on project rescue and staff augmentation assignments. Mentored junior team members in development of logic, SQL, and documentation. Acted as liaison between business.
• Assisted as data architect and credit card SME to bring previously outsourced credit union data in-house, establishing a new bank for client’s employees and customers
• Led team of Agile ETL developers to deliver usable data and reporting on-time and within budget
• Provided detailed analysis of defect tickets assigned to team with accurate cost assessment to the client
• Supplied technical analysis of SQL defects, ETL errors and database view issues
• Conducted meetings with client’s internal and external data providers to determine integration requirements and data usage rules to assist in development of data models for warehouse and reporting marts

Columbus, Ohio Area

• Managed the data assets of the marketing database. Responsible for developing and enforcing data security standards, ensuring compliance with corporate and client security policies. Initiated and coordinated.
• Implemented public/private key encryption with multiple internal and external data providers
• Initiated a centralized data transfer group to facilitate secure and consistent treatment of incoming and outgoing data feeds
• Developed a mirrored consumer name and address database with an external vendor which reduced data transfers and ensured timely processing of National Change of Address for more than 500,000,000 consumer records annually
• Developed and administered training to all associates affected by the new centralized transfer group. Assisted associates in the explanation of new security measures to their external clients. Acted as a technical.

Columbus, Ohio Area

• Worked as liaison between business users and IT department, developing use cases to ensure critical requirements were properly addressed and deliverables were met as outlined in requirements documentation and SLAs..
• Supervised data quality program for multi-client consumer marketing database, increasing audit points more than 1000x while decreasing time for audit review to less than 10% of original
• Developed best practices for data audit and quality control, trouble ticket investigation and resolution and managed internal trouble ticket system
• Acted as business analyst for new processes and assumed additional responsibility for proactively identifying data or process issues and determining solutions
• Developed hierarchical rules and calculations for combining duplicate consumer entries and corresponding financial transactions across multiple databases
• Initiated and maintained data dictionary and process documentation which eliminated obsolete paper documentation for regularly updated web-based documentation

Columbus, Ohio Area