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 data warehousing environment by eliminating data redundancy across the multiple subject areas without negatively impacting the many dependent analytical layers involved. Project was successfully implemented within the expected timeframe.

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 consolidation of collections systems, managing vendor decommission, retirement of legacy systems, and transition phases to new systems.• 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 and development staff to ensure appropriate solutions were provided. Facilitated requirements gathering sessions with users, SMEs and LOB representatives using JAD sessions.• 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• Managed team of developers and testers through the correction of high priority defects in legacy code

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 due-diligence processing for new data enhancement vendors and data providers. Ensured compliance to the various state and federal legislations that affected the usage of data and access to data.• 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 consultant for clients that needed further guidance

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. Responsible for management of the external vendor hosting the Marketing Database. Assisted in the development of the new in-house database, including logical and physical data modeling, to ensure accurate integration from the hosted database.• 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• Initiated a Data Model group which ensured consistency in updates or new data structures• Designed and implemented many new system processes, administering effective training that reduced or eliminated support desk calls, ensuring more rapid acceptance by user group

Columbus, Ohio Area