Preston H. Email & Phone Number

Riverton, Ut, Us

Mclean, Virginia, Us

Atlanta, Georgia, Us

• Trained in SAP S4/HANA enterprise resource planning (ERP) software. • Trained in thorough root cause analysis on systemic and operational issues, implementing strategic solutions to address challenges and improve overall transportation processes, demonstrating a keen ability to identify and resolve complex problems.

San Francisco, California, Us

● Leveraged SQL and Python to extract, transform, and analyze complex datasets, uncovering actionable insights and presenting findings through interactive Tableau dashboards, facilitating data-driven decision making. ● Spearheaded regression testing efforts, ensuring the reliability of critical systems by designing and executing comprehensive test scripts, pinpointing issues, and collaborating with cross-functional teams to implement effective solutions. Led User Acceptance Testing (UAT) sessions, validating system enhancements to align with business requirements. ● Designed and optimized ETL (Extract, Transform, Load) workflows using SQL, streamlining data extraction from diverse sources, cleansing, and transforming data to enhance data accuracy and reliability, improving overall quality by 25%.● Employed Python to develop statistical models, performing in-depth analysis on historical data to forecast trends, identify anomalies, and guide strategic decision-making processes, ultimately enhancing business performance and efficiency. ● Designed and implemented VBA macros in Microsoft Excel to automate repetitive tasks, increasing efficiency and accuracy in data processing and report generation. Utilized Excel’s advanced features to create customized solutions for complex data manipulation and analysis, further enhancing productivity withing the organization.

San Francisco, California, Us

• Mentored team of 10 with a focus on performance and professional development using leadership and communication skills, effectively meeting team and department KPI goals.• Designed agile interactive tools, using Microsoft Excel and VBA, that increased team production and efficiency by 30% and decreased errors and missed tasks. • Utilized Tableau and Microsoft Excel to scrape and extract raw data from various available data sources. • Employing data visualization techniques, I created charts and visualizations that showcased key trends and patterns. These insights facilitated strategic business decisions, resulting in improved decision-making processes and enhanced overall outcomes.• Researched, analyzed, and responded to over 500 high risk escalated inquiries and complaints requiring special handling, using root cause analysis, and a thorough knowledge of banking regulation and risk compliance, to resolve and remediate potential legal, reputational, and regulatory risk to the company.• Developed an automation tool to streamline mailing processes using Python libraries; Pandas and NumPy, and Adobe PDF resulting in a team productivity increase of 20%.

San Francisco, California, Us

• Provide analytical support for Credit and Debit cards, fraud, and nonfraud claims.• Support Credit Card complaints forecasting data and analytics.• Identify and mitigate credit card claim abuse activities.• Create insightful dashboards to monitor key business metrics.• Investigate and address the root causes of fraud and system issues and errors, enhancing customer experience.

• Led a team of five soldiers in executing dozens of civil-military operations across the Nuristan province in support of Operation Enduring Freedom, resulting in increased stability and improved quality of life for local communities.• Conducted needs assessments and collaborated with local government officials to implement and oversee 15 community development projects, including water distribution systems and school construction, totaling $5 million in funding.• Assist in evaluating analyzing and production of Civil Affairs area studies and Civil Military Operation estimates.• Coordinated with a variety of military and civilian organizations to provide essential services to local communities, including health clinics, veterinary care, and basic infrastructure repairs.

Eugene, Or, Us

• Delivered comprehensive instruction and training for the University of Oregon's Data Analytics course, covering topics including Microsoft Excel VBA, Jupyter Notebooks, SQLite, Tableau, Matplotlib, Pandas, NumPy, and other essential Python libraries for ETL and data visualization achieving a class graduation rate of over 80%.• Leveraged effective leadership and communication skills to deliver personalized tutoring and support to students. This individualized approach resulted in notable improvements in their performance and significantly enhanced their overall learning outcomes.• Applied strong written communication skills to review and grade assignments and projects. Through targeted and specific feedback, I guided students towards areas of improvement, resulting in enhanced performance on subsequent assignments.

Cincinnati, Ohio, Us

• Designed and developed, high-volume document automation solutions across client platforms, utilizing xPresso for Adobe InDesign authoring tools, allowing organizations to produce documentation for upwards of hundreds of thousands of individuals based on specific customer profiles.• Thoroughly tested, debugged, documented, and provided ongoing support for the document composition process using research analysis and interoffice communications ensuring seamless and efficient operations.

Midvale, Utah, Us

• Work with property owners to list and market their properties for sale or rent. Including taking photos and creating descriptions for marketing materials, conducting open houses, and negotiating offers. • Working with buyers to find properties that meet their specific needs and preferences. Researching and showing properties, providing market analysis, and assisting with negotiations.• Manage the transaction process, including drafting contracts, coordinating inspections and appraisals, and ensuring all necessary paperwork is completed accurately and in a timely manner. • Work closely with lenders, attorneys, and other professionals to ensure a smooth closing process.

• Evaluate loan documentation and financial data to determine the most appropriate loss mitigation options available to the borrower.• Work with borrowers to identify the root cause of default and evaluate repayment capacity.• Analyze borrower financial statements and hardship letters to identify the most appropriate loss mitigation option.• Assist borrowers in completing necessary documentation and applications for loss mitigation programs including HAMP, HAFA, Deed In Lieu, Short Sales, etc. • Work with investors, insurers, and other third-party service providers to evaluate and process loss mitigation applications.• Negotiate payment arrangements and workout solutions with borrowers, including but not limited to repayment plans, loan modifications, and short sales.• Ensure that all borrower communication is conducted in accordance with regulatory requirements and company policies.• Maintain accurate records of all loss mitigation activity in the loan servicing system and provide regular reports to management.

Riverwoods, Il, Us

Locating and communicating with debtors.Developing payment plans and negotiating debt payments.Negotiating payment settlements on recoverable debt.Logging every contact attempt and the outcome of the contact.Respecting customer policies and procedures.

Bachelor'S Degree, Data Management/Data Analytics

Data Analytics Nanodegree

Software Development Bootcamp, Software Development