Sopaul Jauck
Senior Data Analyst · First Tech Fed Credit Union
Banks, ORIn 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 Union2014 – 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 Seterus2013 – 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 University2011
Bachelor of Networking
Bachelor in Security
Coleman University2011
Bachelor in Security
Bachelor of Science
University of California1997
Bachelor of Science