Eric Carter Email & Phone Number

Los Angeles, CA, US

• KEY ACHIEVEMENTSBuilt a process for restating FTP
• Profitability team needed a restatement for loan FTP in time for a release and Treasury claimed it would take them 2 weeks due to an antiquated process in Excel
• Rebuilt the process in Alteryx, Python scripts, and Snowflake to complete the restatement in 2 daysDesigned the team’s Snowflake database to house profitability data. Highlights include:
• Worked with IT to set up appropriate roles and schemas, including roles for users to move data across databases
• Implemented a row-level security model to provide data to line of business users who have restricted access
• Created stored procedures and scheduled tasks to update a number of tables daily for consumption by users and other platforms Remediated several processes that were housed in MS Access databases

New York, NY, US

• OneWest Bank division - Analytics & Strategic InitiativesKEY ACHIEVEMENTSImproved efficiency by creating a SQL Server based platform to ingest data from data warehouse allowing for an automated reporting process
• Automated posting of sales scorecards directly to SharePoint, and emailing campaign reports directly to stakeholders
• Created an automated process for tracking customer incentives where a customer had to meet requirements to get a cash rewardPerformed as mentor to junior analysts who have gone on to successful careers as data.
• Provided strategic guidance and actionable insights to the Director of Marketing and the Marketing Department.
• Performed as Lead Analyst on a team that supported many areas of the Retail Banking Group, including marketing, branches, call center, and branch operations
• Created acquisition financial models for marketing campaigns

Charlotte, NC, US

• Mortgage Servicing - Servicing Operations Analytics and ReportingKEY ACHIEVEMENTSCreated a tool to generate data for common ad-hoc requests
• Used SQL, Excel, and VBA to allow a user to input accounts and automate the output from several data sources
• Developed a script in VBA to retrieve data row by row due to system limitations saving countless man-hours and reducing errors in generating these reportsRESPONSIBILITES· Used SQL Stored Procedures and SSRS to create.

Charlotte, NC, US

• Correspondent Lending DivisionKEY ACHIEVEMENTSDeveloped and prototyped a scoring system for mortgage sellers
• Pulled data with SQL queries and did transformation in MS Access
• Used statistical analysis to determine seller’s elasticity and identify those sellers most/least likely to successfully deliver their loansSaved the organization millions of dollars by building an audit platform
• Used SQL and the data warehouse to identify system errors & points of failure
• Produced 2 dozen audit reports to SharePoint using SQL, Stored Procedures, and VBA scripts
• Tracked the curing of the audit reports in SharePointRESPONSIBILITIES· Provided actionable insights to improve profit margins based on customer (mortgage sellers) behavior· Verified the accuracy of pricing updates.

Data Science

Ios Programming

Master Of Fine Arts (Mfa), Photograhy & Media And Integrated Media

Bachelor Of Arts (B.A.), Media Theory & Criticism