Data professional with ten years of financial industry experience who can tackle complex projects. Skilled at communicating and collaborating with teams to define requirements, objectives, and progress reports. Excellent issue resolution skills with the ability to look for root causes and implement workable solutions. Produced a system to improve data report quality and speed by 15%. Improved data matching by 5% for large enterprise UAT project. Seeking to leverage my technical skills and experience to provide solutions for a leading organization. Summary of skills: EXPERT: Requirements Gathering, Data Analysis, Data Quality, PII Data Classification, RDBMS, and Data LineageADVANCED: MSSQL, Agile Project Management, Data Mining, Microsoft Excel, Microsoft Access, JIRA, and ConfluenceINTERMEDIATE: Tableau, Power BI, ETL, Statistical Analysis, AI Integration, and Informatica Axon.NEW: Python, Matplotlib, Pandas, and SAS.
-
Data AnalystHomesteaders Life Company Nov 2023 - Mar 2024West Des Moines, Iowa, United StatesPerformed user acceptance testing and facilitated the evaluation of key financial calculations for new business system.•Investigated current data mapping, grouping, and key joins to improve transaction matching by 5%•Designed a method to compare 2 large SQL extracts 50% faster than the original method•Produced Jira user stories and epic to track over 160 user stories, which improved the speed of UAT report testing by 15%•Provided concrete solutions to resolve matching issues between new software and legacy program -
Lead Data Mgmt AnalystWells Fargo Oct 2022 - Oct 2023Conducted data mining, statistical analysis, and UAT testing on source and data warehouse information for outgoing marketing campaigns. •Fulfilled campaign data requests from numerous departments successfully•Extracted data from multiple environments: SQL Server, Oracle, HIVE, & Teradata•Executed statistical analysis using tools like Tableau, SSMS, Power BI, SAS, and Excel•Enriched data by tying it back to multiple data sources to improve data quality•Conducted UAT with marketing managers to ensure delivery of usable data•Composed process documentation in Confluence to train data analysts -
Business Systems AdminWright Service Corp. Dec 2021 - Oct 2022West Des Moines, Iowa, United StatesProvided excellent service for the ERP Accounting Software Production Team managing incoming ticket flow and delegation for a team of 3 support analysts and 8 developers. •Triaged incoming support tickets based on difficulty and development skills required •Elicited and documented requirements from users to define user stories and acceptance criteria•Reduced user story backlog from 89 to 35 resulting in a 61% decrease•Revamped training program that resulted in a reduction of new user orientation time by 20%•Provided ongoing support to accounting team in accordance with the SLA•Managed accounting user stores to completion with the help of multiple resources -
Lead Data AnalystPrincipal Financial Group May 2020 - Dec 2021Des Moines, Iowa, United StatesFunctioned as lead analyst for the complex Trust conversion from Wells-Fargo to Principal.•Improved Programmer productivity 10% by prioritizing Cobol builds based on hierarchy, order of operations, and dependencies•Facilitated regular meetings with clients and vendors to monitor the project status, resolve issues, and ensure quality standards•Elicited and gathered requirements for the Trust Department•Automated the creation of over 200 user stories in Jira•Generated high level analysis of workloads and production schedules for upper management•Supervised the work of 3 other consultants who assisted in the heavy workload•Successfully identified and collected requirements for over 100 external and internal ETLs -
Data Quality Team LeaderWells Fargo Jul 2018 - May 2020West Des Moines, IowaDelivered data quality reporting documents for retail business databases. This includes movement, detective, and preventative data controls for 33 different sources. Participated in stand up meetings with team members. Trained new analysts on system processes and procedures. Develop processes to improve accuracy and productivity of our data quality reporting team.
-
Senior App DeveloperFarm Bureau Financial Services May 2016 - Apr 2018West Des Moines, IaMember of Production Support Team for Farm Bureau’s new life insurance admin system. Worked on Agile Production Support Team developing integration solutions in SQL Server, SSRS, Sharepoint, Informatica, TFS, Service Now and Agile Development software. Interviewed system users and managers to extract requirements for user stories. Participated in daily production support scrum meetings. Groomed stories for development. Create stories for backlog. Built system integrations between SQL Server, Informatica, SSRS, PowerShell, SharePoint, and Control-M.
Mark Varner Education Details
Frequently Asked Questions about Mark Varner
What is Mark Varner's role at the current company?
Mark Varner's current role is Business and Data Analyst.
What schools did Mark Varner attend?
Mark Varner attended Iowa State University - College Of Business, Iowa State University - College Of Business.
Not the Mark Varner you were looking for?
-
-
3ameritech.net, bellsouth.net, carfax.com2 +177026XXXXX
-
Mark Varner
Memphis, Tn2mwacareers.org, edwardjones.com -
1pse.com4 +142564XXXXX
Free Chrome Extension
Find emails, phones & company data instantly
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