Profiles search
Travis Law
Information Security Engineer at The Church of Jesus Christ of Latter-day Saints
Herriman, UT, United States
Details
Experience:
• Security engineer working with roles and permissions
• Create security profiles, install monitoring software, whitelist activity, audit security related activity
• Run, monitor, update SQL scripts
2019 : Present
The Church of Jesus Christ of Latter-day Saints
Information Security Engineer
• Built and created standards for Tableau Data Source development, administered the FamilySearch Tableau Server instance, and deployed metrics on department Intranet site.
• Consolidated 18 different sources (MySQL, Access, Excel, SharePoint Lists, Oracle) for Mixed Workforce project, architected new solution, presented to senior staff. Took over project management, ETL data from sources into Dynamics CRM, and did some development work within Dynamics above and beyond normal job function.
• Demonstrating integrity, expertise, and knowledge of data led to an appointment as the department’s data steward by the FamilySearch CEO. Duties and responsibilities include classifying all data and approving/denying internal and external data sharing agreements as part of our data governance policies.
• Built trust and confidence with other data owners that allowed us to combine our information with sensitive information from other groups. This significantly sped up the approval times for shared data requests and allowed access to information most groups struggle to achieve.
• Convinced executive management to put FamilySearch data into the Enterprise Data Warehouse to create a single source of reporting truth. Involved in business requirement gathering, modeling, ETL, and testing.
• Built FamilySearch centralized BI site in SharePoint, utilizing SSRS to solve issues with deploying needed reports and dashboards requiring accessibility globally in different languages.
2011 : 2019
FamilySearch
Business Data Architect; Data Steward
• Modeled, proto-typed, and project managed the start of the FamilySearch Data Warehouse using Kimball methodology for proof of concept, while looking ahead towards moving it into the Enterprise Data Warehouse.
• Alerted management that years of previous reporting was inaccurate, and worked with application engineers to correct data, add additional fields, and fix misunderstandings.
• Learned and utilized Omniture for website analytics reporting, prior to bringing the data into the Enterprise Warehouse.
• Made software recommendations to management to support dashboarding and reporting that were implemented within the department.
• Proposed, designed, built, and administered a server that housed remote desktops giving the volunteer workforce home access to perform service functions for Family History Support administrators.
• Learned to develop dashboards in the application, Corda, and utilized it for executive dashboards.
• Trained others on how to properly utilize department data and understand the different nuances of the data.
2010 : 2011
FamilySearch
Data Engineer
• Implemented strategic practices to reduce duplication and increase team effectiveness through automating processes and procedures.
• Increased the performance and accuracy of existing databases and reporting tools by implementing an effective system of auditing and troubleshooting, and by instituting design and application corrections, and initiated quality check measures.
• Developed reports and modified them for multiple languages.
2008 : 2010
FamilySearch
Data Analyst II
• Significantly reduced auditing labor/time through creation of department level auditing database and application.
• Promoted quickly after taking the initiative to learn new reporting applications (SAP Business Objects Deski, Teradata SQL Assistant, SAS).
• Rapidly learned the data in WellPoint’s databases, and without assistance because all database engineers were laid off during a merger.
• Became a knowledgeable and trusted data resource for the Actuarial Team.
• Assisted others by enhancing their Access Databases with VB and by applying database modeling principles.
2001 : 2008
WellPoint
Data Analyst II
• Create security profiles, install monitoring software, whitelist activity, audit security related activity
• Run, monitor, update SQL scripts
2019 : Present
The Church of Jesus Christ of Latter-day Saints
Information Security Engineer
• Built and created standards for Tableau Data Source development, administered the FamilySearch Tableau Server instance, and deployed metrics on department Intranet site.
• Consolidated 18 different sources (MySQL, Access, Excel, SharePoint Lists, Oracle) for Mixed Workforce project, architected new solution, presented to senior staff. Took over project management, ETL data from sources into Dynamics CRM, and did some development work within Dynamics above and beyond normal job function.
• Demonstrating integrity, expertise, and knowledge of data led to an appointment as the department’s data steward by the FamilySearch CEO. Duties and responsibilities include classifying all data and approving/denying internal and external data sharing agreements as part of our data governance policies.
• Built trust and confidence with other data owners that allowed us to combine our information with sensitive information from other groups. This significantly sped up the approval times for shared data requests and allowed access to information most groups struggle to achieve.
• Convinced executive management to put FamilySearch data into the Enterprise Data Warehouse to create a single source of reporting truth. Involved in business requirement gathering, modeling, ETL, and testing.
• Built FamilySearch centralized BI site in SharePoint, utilizing SSRS to solve issues with deploying needed reports and dashboards requiring accessibility globally in different languages.
2011 : 2019
FamilySearch
Business Data Architect; Data Steward
• Modeled, proto-typed, and project managed the start of the FamilySearch Data Warehouse using Kimball methodology for proof of concept, while looking ahead towards moving it into the Enterprise Data Warehouse.
• Alerted management that years of previous reporting was inaccurate, and worked with application engineers to correct data, add additional fields, and fix misunderstandings.
• Learned and utilized Omniture for website analytics reporting, prior to bringing the data into the Enterprise Warehouse.
• Made software recommendations to management to support dashboarding and reporting that were implemented within the department.
• Proposed, designed, built, and administered a server that housed remote desktops giving the volunteer workforce home access to perform service functions for Family History Support administrators.
• Learned to develop dashboards in the application, Corda, and utilized it for executive dashboards.
• Trained others on how to properly utilize department data and understand the different nuances of the data.
2010 : 2011
FamilySearch
Data Engineer
• Implemented strategic practices to reduce duplication and increase team effectiveness through automating processes and procedures.
• Increased the performance and accuracy of existing databases and reporting tools by implementing an effective system of auditing and troubleshooting, and by instituting design and application corrections, and initiated quality check measures.
• Developed reports and modified them for multiple languages.
2008 : 2010
FamilySearch
Data Analyst II
• Significantly reduced auditing labor/time through creation of department level auditing database and application.
• Promoted quickly after taking the initiative to learn new reporting applications (SAP Business Objects Deski, Teradata SQL Assistant, SAS).
• Rapidly learned the data in WellPoint’s databases, and without assistance because all database engineers were laid off during a merger.
• Became a knowledgeable and trusted data resource for the Actuarial Team.
• Assisted others by enhancing their Access Databases with VB and by applying database modeling principles.
2001 : 2008
WellPoint
Data Analyst II
Company:
The Church of Jesus Christ of Latter-day Saints
About
Transformed Business Intelligence at FamilySearch. Worked side by side with management to build the FamilySearch Business Intelligence program from scratch, including organizing a team of Business Analysts and Report Developers, as well as creating a centralized source of reporting truth within the Enterprise Data Warehouse.
Profile Photo
