Dave Eckholm Email & Phone Number

• Developed and lead SQL and SAS training sessions for team of analysts.• Created validation queries, discussed findings with technical team and made recommendations for resolution during transition from Hadoop to Redshift.• Consolidated data from various sources to produce email reporting that included email metrics such as sents, click and opens along with transactional details like orders, revenue and products purchased.• Reduced run time for critical program by converting from SAS to Redshift SQL using nested queries and windowing functions.• Developed inventory reporting that identified entry errors during the transition from one distribution center to another.

• Built reusable data pipelines for ingesting, cleansing, transforming and delivering features to data scientist using Streamsets Transformer• Transformed a critical customer identification process from SAS to PySpark improving the delivery time by 87% • Designed, coded and tested multiple Impala SQL queries that were placed in production and used for executive reporting. • Gathered and presented data requirements to our solution architects responsible for building an enterprise data vault through business interviews, establishing connection to data sources, writing and testing SQL queries and producing the final documentation.• Assisted data scientist build a buyer model by developing features, providing feedback on feature importance details, recommending threshold for precision and recall metrics, making pipeline adjustments when needed and helping present results.

• Designed and maintained an automated framework for reporting campaign performance using SAS, SQL and Tableau reducing adhoc data requests by 40%.• Standardized reporting by creating tableau reports that incorporated level of detail calculations,workbook actions and parameters providing all campaign managers the ability to monitor resultsthrough the same reports.• Collaborate with leaders of strategic initiatives to drive analytic information into business actions.• Provided campaign level reporting, strategic direction and cost savings recommendationscontributing to a 15% growth in revenue.• Developed customer segmentation program that classifies customer’s purchase activity tostrategically match complexity of inbound calls to the skill level of service reps.• Created requirements for development of corporate wide data warehouse used for campaignreporting, model development and customer contact selections.• Improved customer contact accuracy by adding audit control steps in all selections programs.• Developed SAS, SQL, Unix and Tableau training sessions for reporting and analytics team.

• Developed tools, policies and strategies to enable operations to effectively manage a $25 billion mobile home mortgage portfolio using SAS and SQL.• Provided analytical support for two payment default projects with reclaimed annual revenue of $2.1 million and $825,000 respectively.• Executed project specific analysis in support of business information needs, including narrative summaries and recommendations.• Maintained and developed reports for senior management providing data based guidance for planning the strategic direction of our loan portfolio.• Created monthly reports to monitor trends for bankruptcies, rate modifications, extensions and repossessions.• Actively participated in the development of a new corporate data warehouse used for forecasting and modeling loans, financial impact analysis and improved management reporting.• Tested and provided feedback to system administrators during the installment of UNIX server for SAS.• Acted as mentor to Senior Risk Analyst in SAS development.

• Created, managed, and refined systems/processes related to tracking and analyzing direct marketing initiatives.• Coordinated reporting to ensure accuracy, consistency, efficiency and data integrity.• Worked with end users and management to create business and reporting requirements.• Developed customer scoring model used to select names for telemarketing programs.• Developed pipeline reporting to monitor all stages of loan applications.• Worked closely with vendors during the development of internal prospect database.• Maintained positive vendor relationships• Provided recommendations to improve database and application performance.