Nicholas Scott Email & Phone Number

Durham, North Carolina, United States

Columbia, South Carolina

Influenced senior management and key stakeholders with regards to the broad use of reporting tools and data strategies as well as problem solve specific reporting and operational opportunities.Created / Hosted an Enterprise-Wide Tableau User Group and Tableau Office Hour meetings to support a community of Tableau Creators / Viewers.Collaborated with key business partners to implement my proposed solutions or troubleshoot existing solutions to increase their effectiveness by leveraging technology and my unique problem solving ability.Produced POC data solutions to ameliorate previously unconquerable data challenges associated with key enterprise reporting needs through the use of dynamic, production-deployable ETL workflows and visualizations.Led development of critical enterprise reporting and operational workflows (SBA PPP Tableau Dashboards and SBA PPP Alteryx Workflow).Mentored Tableau developers on calculations (frequently Level of Detail Expressions), data structures, visualization types, effective dashboard design, Tableau Server and other data related questions.Consulted with various business units to assess their data pain points and gauge the potential effectiveness of a Tableau/Alteryx/Tableau Prep based solution.Evangelized the adoption and use of Tableau, Alteryx and other technologies.Deployed, configured, maintained and administered a Tableau Server environment at an enterprise level including developing and supporting an effective data governance model.Promoted effective storytelling by helping users explore the potential stories their data could tell.Liberated Tableau Creators and Viewers from a reporting mentality that is confined by the technical limitations of Excel. Developed dynamic, scalable and sustainable ETL and Visualization data solutions using Alteryx, Tableau Prep and Tableau with an eye towards full automation.Leveraged API’s to bring in 3rd party data to create new data solutions and enhance existing solutions.

Columbia, South Carolina

Brought Tableau Reporting and Alteryx to First Citizens' Mortgage Division to address their unique reporting needs.Evangelized the benefits of Tableau reporting to end users, helped end users conceive of the possibilities of a post excel-reporting environment.Used Alteryx to craft complex data extracts that wed disparate data sources with emphasis on scalability and automation.Leveraged Alteryx and Machine Learning to dynamically ingest hundreds of mainframe text files with an ever-growing schema to create a single data extract that housed loan data as it changed over time.Empowered analysts in other business units by helping them transition to Alteryx/Tableau based data solutions.

Brown Deer, Wi

Singlehandedly developed and maintained a Tableau Server reporting environment with end users ranging from VP/EVP level to the Board of Directors.Analyzed business operations to understand the data points involved as well as develop the context necessary to support the business unit’s unique reporting needs.Crafted complex data extracts/custom loan sale files from loan servicing SQL server and Loan Origination System (“LOS”) using Alteryx and MS Access.Developed a custom pricing & rate sheet production engine that automatically modeled pricing off of live market data and produced bespoke rate sheets for distribution to correspondents.Designed and maintained a Tableau-based invoicing system. Created a custom MERS validation system, reducing a 16+ hour manual operation to under 2 minutes.Automated manual processes using Foxtrot RPA.Co-implemented a LOS in 3 months.Trained correspondents on using our LOS as well as assisted with lock-based and LOS-based questions.Mentored co-workers on in-cell formula use in Excel.

La Molina, Lima, Peru

Taught Private and Group English, GMAT, TOEFL, and SAT classes.Conducted business conversation classes as well as worked with students on preparing English CVs and preparing for Interviews in English.Explored and discussed US & Peruvian cultural insights.

Glendale, Wi

Managed 12 direct reports, with tasks ranging from monthly call reviews to semi-annual and annual performance reviews.Trained and coached representatives as well as assisting with performance improvement.Recruited and interviewed job applicants.Took ownership to help resolve complex, escalated participant issues.Handled disciplinary issues, including the preparation and delivery of verbal and written warnings.Educated 401k participants about IRS regulations and investment options via telephone.

Glendale, Wi

Informed customers about their options while exploring their computing needs.

London, United Kingdom

Conversed with customers throughout the UK over the telephone/email, assessed their needs and presented solutions through the company website and catalogue.Improved the sites ability to address FAQ's through requests to the Marketing Dept.Resolved problem queries through communication with other departments.Trained new employees in customer service procedures.

Santiago, Chile

Expanded on Full Time Teacher's lesson plans to groups of 10-15 Fifth Graders.Shared insights on American and Chilean culture.

Brown Deer, Wi

Conducted conversion from Windows NT to Windows XP in lending branches across the US.Troubleshot lingering issues from the Windows XP conversion with end users.Prepared Home Equity loans for transfer to other financial institutions.Updated and maintained various Excel spreadsheets and Access databases.

Bachelor Of Arts (B.A.), Spanish Language And Culture

Graduated in 3.5 years with my last semester spent studying abroad in Santiago, Chile.

Education record

Study Abroad

Education record

Study Abroad