Eric Smith Email & Phone Number

Circle Pines, Mn, Us

Remote

• Constructed a compensation credit validation model in Anaplan which allows users to input compensation territory rules specific to individual salespeople, generates SQL scripts based on user inputs, and runs the compensation credit calculations in SSMS• Adjusted the compensation credit validation model to display individual’s compensation territory rules in an easy to read fashion to individual salespeople for use in their sales incentive plans• Built a multitude of different Anaplan dashboards and modules used in FY20 planning by regional operations and sales management to set quota, build KPMs, re-assign account owners, model capacity, set target accounts, plan for upcoming renewals, and assign individual’s compensation territory rules• Delivered adhoc Salesforce reporting for management and regional operations where needed• Developed reporting and dashboards in Tableau to support Renewals tracking, management and insights

Greater Minneapolis-St. Paul Area

Liaises with key business partners to create new processes and implement initiatives where needed.Build and maintain SQL Teradata scripts and complex queries for data analysis and extraction.Review key indicators to check performance and control management of assigned operations.Provide subject matter expertise on specific assigned and ongoing business operations to ensure success in meeting business goals and objectives.Create daily reports in SAP Business objects to report production statistics for management.Proactively identify any potential process gaps and propose e possible solutions to fill gaps.Analyze customer escalations for trends, perform root cause analysis, and correct any associated process issues to avoid possible reoccurrence.

Greater Minneapolis-St. Paul Area

Researched, compiled, analyzed, and reported a variety of data from multiple sources, including productivity and qualitystatisticsHelped create a new training program for new hires in the Escrow Analyst departmentCreated multiple reporting tools used by management as well as created and published procedures on how to use themManaged several projects and created processes to put certain projects into productionSearched and sorted through data to identify trends, reported findings to management and made recommendations for resolutionCreated multiple control reports in BO to query loans that were worked incorrectly or have illogical conditionCreated and implemented multiple processes that saved manual production efforts by up to 50 production hours a week

St Louis Park, Minnesota

Review loans before performing an analyses, research upcoming tax payments and make adjustments if necessary, as well as help with back filling a multitude of other processes during times of increased volume.

Prescott, Wisconsin

Delivered Great customer service in a timely manor, perform a variety of basic bank functions, as well as refer potential banking clients to personal bankers in hopes to acquire their business

Eagan, Minnesota

Worked in the imaging department of Wells Fargo scanning mortgages and indexing specific documents to their respective locations.

Traveled to various Home Depots around the metro to generate leads for concrete related projects.

Bachelor Of Science (Bs), Finance

High School Diploma