Mark Tilley Email & Phone Number

Dallas-Fort Worth Metroplex

United States

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.

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

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)

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

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.

Bachelor Of Science In Business With Concentration In Project Management, Business, Management, Marketing, And Related Support Services, 3.6 Gpa

Bachelor of Science in Business with Concentration in Project Management

Associate Of Science - As, Computer Technology/Computer Systems Technology, 3.8 Gpa