SJ

Sopaul Jauck

Senior Data Analyst · First Tech Fed Credit Union

Banks, OR

In My Own Words

Find stories through data, trends, reporting, and analysis. Provided optimization in data transformation and analytics delivery using Tableau and Alteryx. Tableau Desktop Certified.

Work Experience

Senior Data Analyst

First Tech Fed Credit Union

2014 – Present

Mined data from various databases, flat files, and other sources using SQL Alteryx, and Tableau; major connections made to core system Oracle Reporting Server (DNA), Originating and Collection System (Akcelerant), and Enterprise Data Warehouse. Experienced working with large data set. Analyzed trends, created forecasting, provided predictions, extensive data blending, data investigation, and data story telling. Completed many analyses and provided many recommendations on system optimizations and business improvements. Worked closely with key stake holders within internal and external business units in analysis and in delivering results. Played a key role in data transformation, data delivery and automation, as well as assisted in the development of Enterprise Data Warehouse in moving key data from Oracle Database and Akcelerant to it. Also assisted in mapping data from Core Databases to EDW and provided strategic efforts in getting EDW data refreshed in an on-going basis. Certified in Tableau and have used many of the advanced functions in creating advance interactive and dynamic dashboards: including skills with Sets, Pivoting, Level of Details (LOD), Parameters, Custom Table Calculations, Geo-Map, Custom Filters, Hierarchy, and many more. Assisted in mentoring new analysts on data analytics, data mining, and data knowledge.

Analyst

IBM Seterus

2013 – 2014

Analyzed and monitored serviced loans purchased by Fannie Mae. Depending on quality of loans, asked originating servicers for MSR Repurchase, Full Repurchase, or Indemnification as directed by Fannie Mae guidelines. Perform additional analytics as needed.

Prior career experienced: Senior Logistic Coordinator and Sales

Education

Bachelor of Networking

Coleman University

2011

Bachelor of Networking

Bachelor in Security

Coleman University

2011

Bachelor in Security

Bachelor of Science

University of California

1997

Bachelor of Science