Mark Tilley

Mark Tilley Email and Phone Number

Principal Business Intelligence Engineer at Zillow @ Zillow
seattle, washington, united states
Mark Tilley's Location
Dallas-Fort Worth Metroplex, United States
Mark Tilley's Contact Details

Mark Tilley personal email

n/a
About Mark Tilley

Results-focused and goal-oriented professional with broad-based experience in business intelligence, compliance, analysis, data warehouse and data governance; complemented with proven ability in providing critical and highly accurate information. Demonstrate keen attention to detail in processing documents to ensure data integrity and accuracy. Possess the ability to adapt and thrive in fast-paced and highly competitive environments through analytical approaches, time management skills and critical outside the box thinking. Exemplify proven aptitude in developing business intelligence infrastructure, data analytics and data warehouse designs and operations.

Mark Tilley's Current Company Details
Zillow

Zillow

View
Principal Business Intelligence Engineer at Zillow
seattle, washington, united states
Website:
zillow.com
Employees:
6314
Mark Tilley Work Experience Details
  • Zillow
    Principal Business Intelligence Engineer
    Zillow Nov 2021 - Present
    Dallas-Fort Worth Metroplex
  • Kind Lending
    Vice President Of Data Architecture
    Kind Lending Mar 2020 - Oct 2021
  • First Guaranty Mortgage Corporation®
    Senior Manager Business Intelligence
    First Guaranty Mortgage Corporation® Sep 2019 - Mar 2020
    United States
  • Stearns Lending (Nmls #1854)
    Director Business Intelligence
    Stearns Lending (Nmls #1854) Jun 2014 - Sep 2019
    Dallas/Fort Worth Area
    • Direct, design, and implement infrastructure of enterprise reporting systems covering Cognos, PowerBI, Motivity, and SQL-based BI solutions.• Developed, Maintained and performed User Acceptance Testing for our Extract Transform and Load (ETL) process.• Scripted Stored Procedure and SQL required development for various channels throughout the Enterprise.• Required to schedule / maintain jobs using SQL Server Agent.• Role Level Security architecture design for Power BI and Cognos.• Managed Azure active directory for accessing certain programs, security folders and groups.• Senior Lead on data governance for the whole enterprise.• Scheduled event system triggers to notify all responsible parties about data failures or delays using automation.• Lead Data architecture developer for concepts and design when creating new systems or report repositories. • Multiple projects spearheading business process optimization across the enterprise.• Senior translator for business requirements and turning them into technical requirements for the system developers.• Multiple Team management experience. • SSIS, SSRS • Managed three business intelligence system at once (Power BI, Motivity and Cognos).• Microsoft SharePoint Designer and Administrator.• Microsoft Flow concepts and design. *** Additional duties at Stearns Lending outside of Business Intelligence Role. ***o Provided all required reporting for Mortgage Call Report. o Answered all state and federal examiner request on reporting related items.o Provided all required reporting for the HMDA Loan Application Register requirements yearly.o Delivered Human Resource Department with all compensation related reporting.o Power BI application management. o Cognos application management. o PNP and tool creations for Business Intelligence systems.o Business Intelligence training company wide.
  • Nationstar Mortgage
    Senior Business Analyst
    Nationstar Mortgage Feb 2013 - Jun 2014
    Dallas/Fort Worth Area
    • Leveraged industry expertise in maintaining system entity relationship diagrams; translating business requirements to transactional database schema designs; evaluating appropriateness of replicated data; and verifying database tool compatibility and application software packages with existing database architecture standards• Streamlined physical database designs for specific DBMS, and held responsible for approving schema changes, call patterns, and SQL code• Collaborated with production database administrators in transferring schema and stored procedure changes into the production• Systematically organized required documents, and supported the execution of change control and verification processes• Played a pivotal role in making design decisions while working closely with a team of developers• Render developer consulting on performance and SQL script optimization• Meticulously analyzed and reviewed new technologies and architectures associated with company applications • Expertly wrote SQL query codes and supported database needs for diverse environment• Successfully designed a quality control database for the department
  • Utls Default Services ( Formerly Landamerica Onestop Ds)
    Senior Loss Mitigation Negotiator And Quality Assurance Team Leader
    Utls Default Services ( Formerly Landamerica Onestop Ds) Nov 2011 - Dec 2012
    Dallas/Fort Worth Area
    • Evaluated workout candidates for alternative programs such as Home Affordable Modification Program (HMP), Fannie Mae, Freddie Mac, Federal Housing Administration (FHA), Veterans Affair (VA), conventional, prime, and sub-prime mortgage loans• Maintained strategic association with investors, borrower, FH, VA, PMI companies, brokers, and escrows to ensure compliance with investor and agency requirements• Facilitated quality assurance reviews for short sale loans, and evaluated adherence to necessary program guidelines and requirements• Assumed full responsibility in evaluating fully documented loan histories, imaged documents, and information available from all sources to determine validity of information used in home retention and loss mitigation decisions• Conformed to program standards in negotiating Government-Sponsored Enterprise (GSE) and non-GSE loans• Effectively handled timelines with appraisers or realtors, while requesting postponements and overseeing foreclosure processes • Collaborated with realtor to find offers in line with suggested price list and ensure that house is listed• Adhered to the Fair Debt Collection Act when communicating with borrowers over the phone• Systematically recorded data and evaluated conclusions in the Quality Assurance System (QAS)
  • Pasley Information Technology Services
    Network Administrator
    Pasley Information Technology Services Jan 2010 - Mar 2011
    Dallas/Fort Worth Area
    • Supervised a 14-person team in charge of web design, technical support, and software development• Provided easy access and analysis on inventory data with viable reporting tools by executing data warehouse for the Procurement Department• Spearheaded traditional department management functions including fiscal responsibility, resource management, project management, and administrative detail• Rendered assistance with selection, delivery, and new technology management
  • Us Army
    Petroleum Supply Specialist
    Us Army Sep 2004 - Aug 2007
    Kansas City, Missouri Area
    While state side I was the motor petroleum supply specialist. Was in charge maintaining all chemical house within our company motor pool. While in Iraq I was used a post environmental protection agent that controlled all inbound and outbound chemical such as oils, petroleum and etc. Also coordinate live refuel mission for BIG RED ONE when they were relocating back to Fort Riley, Kansas.

Mark Tilley Skills

Data Analysis Leadership Business Analysis Risk Management Microsoft Sql Server Microsoft Office Team Building Regulatory Compliance Cognos Business Intelligence Data Warehousing Databases Sql Data Governance Analytical Skills Management Customer Service Project Management Data Management Data Modeling Business Requirements Database Design Data Integration Sql Server Integration Services Sql Server Reporting Services Microsoft Power Bi Visual Studio Microsoft Azure Data Warehouse Architecture Reporting Systems Change Data Capture High Level Of Accuracy Microsoft Servers Risk Assessment Architectural Design User Acceptance Testing Reporting Reporting And Analysis Executive Reporting Ms Reporting Services Ad Hoc Reporting Microsoft Reporting Service Data Integrity Architecture Analytics Data Architecture Technology Management Cloud Computing Business Relationship Management

Mark Tilley Education Details

Frequently Asked Questions about Mark Tilley

What company does Mark Tilley work for?

Mark Tilley works for Zillow

What is Mark Tilley's role at the current company?

Mark Tilley's current role is Principal Business Intelligence Engineer at Zillow.

What is Mark Tilley's email address?

Mark Tilley's email address is mt****@****oup.com

What schools did Mark Tilley attend?

Mark Tilley attended University Of Phoenix, Rio Salado College.

What skills is Mark Tilley known for?

Mark Tilley has skills like Data Analysis, Leadership, Business Analysis, Risk Management, Microsoft Sql Server, Microsoft Office, Team Building, Regulatory Compliance, Cognos, Business Intelligence, Data Warehousing, Databases.

Who are Mark Tilley's colleagues?

Mark Tilley's colleagues are Rebecca Svoma, Gisela Condado, Narayana V, Tricia Brown, Nick Wright, Christian Bunyan, Seema Rohilla.

Not the Mark Tilley you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.