Virginia L. Farrell Email and Phone Number
Virginia L. Farrell work email
- Valid
Virginia L. Farrell personal email
- Valid
Provides exceptional results as a senior-level Enterprise Data Architect, custom product innovator, and expert Data Modeler with Data Engineering knowledge. Deep experience in industry frameworks and models like TOGAF, ISO 20022, ACORD, BDW, IIW, AAIS, MISMO, Dublin Core, DAMA DMBOK, Open Group OSDU, PPDM , and COBIT. Offers solid strategies, techniques, and solutions for organizations to manage data in its entire lifecycle. Passion to be a hands-on, applying industry knowledge and design techniques to projects that produce results that meet or exceed expectations.Diverse industry background, specializing in financial services, including health, auto, property and casualty insurance, banking, credit card processing, mortgage financing, and brokerage trading. Also experienced in human resources consulting, oil and gas, retail, mining, and Department of Defense and Department of Energy government sectors. With advanced skills in multiple modeling technologies, able to build, integrate, and deliver a comprehensive viewpoint of organizational data across the entire architectural stack for use in maturing master and metadata management, data governance, quality, and lineage processes and best practices. Recipient of numerous technical honors, including IBM Service Excellence Award in 2013, IBM Manager’s Choice award in 2018, IBM Expertise Sharing recognition in 2018/2019 for data modeling and industry knowledge sharing, and CIO Magazine's 2008 Top 100 Most Innovative Solutions for data warehouse design.Professional Specialties include but not limited to: • Conceptual, Logical, Physical, Dimensional, Analytical, Canonical, Data Vault, NoSQL Data Modeling• Enterprise Data Architecture Management • Data Warehousing, Data Fabric, Data Mesh, Data Analytics, and Data Visualization• Data Governance, Data Quality, Data Lineage, Metadata Management, Master Data ManagementOther work tenures include Argonne National Laboratory, Department of Defense, Aon/Hewitt Associates, Health Care Service Corporation (Blue Cross Blue Shield of Illinois), CCC Information Services.Key certifications include TOGAF and Enterprise Architecture
-
Enterprise Data Management Lead, Data ModelingGallagherChicago, Il, Us -
Managing Data Engineer Consultant, Data Technology & TransformationIbm Jan 2020 - Jul 2023Chicago, Illinois, United StatesKEY CLIENTS: State Farm, USAA, MetLife, AIG, PayPal, Fiserv, Northern Trust, Agricultural Bank of China, AAIS, Old Mutual South Africa, Delta Airlines, Shell, Chevron, Blue Shield of California, State of New Mexico Medicaid, The Hartford, Newmont Mining, Panasonic, Wells Fargo• Engineered a canonical data model for a blockchain-powered network insurance data exchange streamlining its statutory reporting platform. Translated 20-year-old legacy design into industry-specific domain models and JSON schema. Executed a POC demonstrating the JSON schema’s design adaptability by extending it to include COVID-19 business interruption insurance requirements in less than 2 weeks. This innovation has since been adopted by Linux Foundation Insurance Open Governance Network.• Led 15 data engineers and spearheaded design of policy domain content for development of an information messaging model. Improved best practices, acted as a Guidewire Policy SME, developed custom reports in IDA, monitored RTC usage, reviewed and approved team member’s work. • Engineered an innovative mapping tool utilizing TOGAF’s ADM framework that integrated data model content, mappings, and governance metadata. This innovation served as a basis for providing data lineage for data content to be deployed in Infosphere Governance Catalog. Reduced data entry error over 70% by eliminating redundancy found in Excel mapping spreadsheets.• Developed a custom innovation that populates metadata into data modeling tools via an Excel/VB interface, reducing project development efforts 90% and providing high-quality models and DDL within aggressive timelines. This tool has been since been incorporated as a strategic data asset within the consulting firm.• Analyzed prototype PowerBI & Denodo visualizations and procedures to produce data models, mappings, and data lineage from legacy sources into Open Group OSDU industry framework, providing a path towards liberation of data from legacy source constraints. -
Managing Consultant, Global Business Services, Data PlatformsIbm May 2014 - Jan 2020Chicago, Illinois, United States• Executed a proof-of-concept at a major international financial markets firm that demonstrated the ISO20022 industry model could be translated into JSON by converting Account and Party domains into an enterprise canonical data model from multiple legacy sources. This work set the stage that resulted in a multi-year, multi-million-dollar consulting contract.• Led a team of data modelers on a project to re-engineer a major international financial market’s legacy source systems into an event-driven data fabric architecture. Developed conceptual design of 9 data domains and architected the Fund Utility domain canonical data model by extending ISO20022 industry model to meet functional requirements. Performed source to target mappings and full data lineage from multiple sources into target solution. • Performed a system audit at an international banking firm doing business in New York in an effort to rectify a series of fines, including a $215 Million money-laundering fine for violation of new state anti-money laundering laws. Developed roadmap of modifications required to bring the system design into compliance and delivered updated data analytic and reporting capabilities, data standards, data mapping, logical/physical data models and test results validating compliance requirements were met.• Developed a framework for integrating source system data into target operational and analytic data systems, based on IBM proven practices for data sourced into the data lake raw data zone. This framework documented proven practices for a service catalog involved in the overall data integration process and development of a project planning framework to execute the data integration effort, including a project planning framework utilizing both Waterfall and Agile methodologies.
-
Managing Consultant, Data Modeler, BaoIbm Oct 2011 - May 2014Armonk, New York, United States• Headed a group of over 50 consultants and client team members that architected a consolidated insurance policy harmonized data design from the client’s commercial and personal lines property/casualty, auto, life, and health lines in less than 6 months. Delivered source-to-target mappings, logical, physical and canonical data models from 25,000+ data elements in 23 policy systems producing a target design of 100+ entities and 4000+ attributes. • Authored and employed a factory-method agile-based workflow that reduced effort timeline over 70%--from 2 years to less than 6 months--realizing the client’s vision of transforming their 40+ year old legacy business portfolio into an industry-leading technology platform. Produced training material as a result of this work that became consulting firm’s standard methods that subsequent teams employed on their engagements.• Directed a team of over 10 architects and data governance professionals in an attempt to mature architectural artifacts that support design and development of the client’s enterprise architecture repository. Employed TOGAF framework to develop design principles and blueprints, development tenets, quality service level agreements, process workflow, change control mechanisms, release management strategies, and full data lineage artifacts. Reduced by over 50% the number of unique business data elements, services and business rules identified due to a flaw in the repository metamodel's design.• Engaged in design of a set of logical, star schema physical and ETL staging data models for a new enterprise data warehouse to replace an existing SAP BI/BW environment. Built 6 reporting data marts from 50 SAP ECC reporting cubes with over 2000 attributes. Developed data modeling standards and best practices. Architected a custom cognitive mapping accelerator that analyzed SAP metadata to apply to the new data model design. Accelerator identified of over 52% of the key attributes and properly place in model.
-
Data Management ConsultantFirst Tennessee Bank Jun 2011 - Oct 2011Greater Memphis Area• Architected a custom data provisioning hub for analyzing information associated the bank’s credit card processing systems. • Built a custom innovation that allowed translation of First Data (Fiserv) data and process conversion manuals into a data design that was utilized in the migration of First Tennessee's credit card data from TSYS legacy platform. This design saved the project months of manual analysis effort by producing an automated method for capturing, identifying and tagging key information from over 3000 pages of electronic content into a target logical data models and source to target mappings that was utilized to perform the conversion.• Customized IBM’s Banking Industry Model, performed data mapping, data modeling, data quality and data management activities required for converting the bank’s legacy credit card processing system from TSYS to First Data. -
Data Warehouse Architect ConsultantBank Of America Jan 2011 - Jun 2011Greater Los Angeles Area• Designing conceptual, logical, and physical data models for BOA Home Loans to support LOB and enterprise information and analytic needs during integration of the federal government’s Making Homes Affordable (MHA) mortgage modification process during the Countrywide Financial’s acquisition. • Integrating IBM’s Banking and Financial Services Data Warehouse Model and MISMO mortgaging messaging standards into its design.• Participated in capturing, defining, and performing data quality on KPIs required for integration of Countrywide Financial's data into the design. -
Data Warehouse Architect ConsultantFarmers Insurance Jul 2010 - Jan 2011Greater Los Angeles Area• Architected a transformational Commercial Policy/Premium (CDS) operational data hub data design in DB2, providing a foundational construct for the development of a new Commercial Policy Enterprise Data Warehouse. • Integrated Zurich’s policy data into the hub during Farmer’s acquisition process. • Provided Enterprise Data Architect expertise into building roadmaps, data modeling, data warehousing, business intelligence, data quality and data management best practices. -
Systems Design Analyst ConsultantBlue Cross And Blue Shield Association Mar 2010 - Jul 2010Greater Chicago Area• Drove business requirements and developed ETL system use cases for the Provider Pricing Analysis data mart that delivered service pricing statistics to members for all plans serviced by the association. • Defined master data management, data quality, and data governance requirements and candidate data design for a Provider Master integrated into the association’s data warehouses and marts. -
Senior Enterprise Architect For Data ArchitectureCna Insurance Mar 1998 - Aug 2009Greater Chicago Area• Drove strategic direction of Data Architecture Management in Enterprise Architecture. • Responsible for enterprise modeling product portfolio, making all key decisions on software upgrades, tooling, usage, and vendor management. • Headed design and development of CNA’s Enterprise Canonical Data Model, representing 60% of CNA's business data assets.• Authored CNA’s Corporate Data Naming Standards and Data Modeling Framework. • Founded and led CNA’s Data Modeling Community of Practice.• Produced an innovative data warehousing design that won the CIO Magazine 2008 100 Most Innovative IT Solutions award. This design revolutionized CNA’s Accounts Receivable and Cash Management processes and saved $23.5 million the first 16 months.• Pioneered the development of a design structure that transformed legacy claims systems. Partnered with Guidewire to launch a software product brought to market and is sold to this day.• Architect and tester for the enterprise architecture repository proof-of-concept program. • Assessed viability of utilizing Telelogic System Architect and TOGAF framework to model CNA’s enterprise data and business architectures. Extended Enterprise Architecture metamodel to support data architecture pillar.• Designer of Common Customer, Producer and Policy Master, integrating customer account and policy information into the company’s first, central Master Data Management (MDM) schema. • Participated in development of CNA's first fully integrated Data Governance and Metadata Management Platform utilizing IBM's data governance tooling.• Architected a data solution for a transformational Accounting Center interface database that changed the way CNA performed general ledger accounting functions and strengthened Sarbanes Oxley (SOX) compliance. • Re-engineered an Application Lifecycle Management database enabling portfolio architects to identify obsolete technologies to make informed, strategic decisions on future infrastructure projects.
Virginia L. Farrell Skills
Virginia L. Farrell Education Details
-
3.88/4.0 -
Pre-Med/Medicine
Frequently Asked Questions about Virginia L. Farrell
What company does Virginia L. Farrell work for?
Virginia L. Farrell works for Gallagher
What is Virginia L. Farrell's role at the current company?
Virginia L. Farrell's current role is Enterprise Data Management Lead, Data Modeling.
What is Virginia L. Farrell's email address?
Virginia L. Farrell's email address is vl****@****hoo.com
What schools did Virginia L. Farrell attend?
Virginia L. Farrell attended Devry University, Loyola University Chicago.
What skills is Virginia L. Farrell known for?
Virginia L. Farrell has skills like Data Warehousing, Data Modeling, Enterprise Architecture, Data Architecture, Master Data Management, Information Management, Solution Architecture, Business Intelligence, Oracle, Etl, Data Integration, Data Management.
Who are Virginia L. Farrell's colleagues?
Virginia L. Farrell's colleagues are Rachel Swanson, Saloni Ag, Ribo, Paul Mosher, Gagan Navlani, Gulgun Ates, Marco Antonio Mejía Basto, Rosemary Hughes.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial