Christian Wanser

Data Wizard & Mentor | Helping data nerds launch & advance their data careers | Sr. Data Analyst | MS Analytics

(All of my content is my personal views and opinions) 

Thanks for checking out my page! I am a data professional with years of experience in data analysis, data visualization, machine learning, dashboarding, and other data requirements.

I am an engineer turned data expert with extensive experience providing insights through data. I discovered my passion for data while completing my B.S. in Chemical Engineering and I went on to receive my M.S. in Data Science & Analytics!

I am a strong critical thinker, with robust technical skills that are healthily balanced with intuition and an innate ability to communicate data. I live to see the lightbulb moment when I’m discussing topics with people!

How can we help each other?

Throughout my schooling and professional career, I have always enjoyed helping my peers and coworkers. With LinkedIn and Medium, I'm casting a wider net! Reach out, connect, follow, or just pass through. Whatever floats your boat and best of luck on your journey!

Sr. Data Analyst

TruStage

Data Analyst

U.S. Bank

●	Led two teams of engineers, onshore and offshore, to use modern technologies to stream mainframe data to Cassandra resulting in $25,000  per month savings on mainframe costs and usage 
 ●	Modified Python script to automate database inserts for testing. Saved 2 hours per test.
●	Wrote queries and programs to combine Active Directory accounts with web ids on the mainframe database. Deleted Active Directory accounts for customers who had not logged in for over two years. This avoided incurring thousands in extra charges by staying under twenty-five million accounts.
●	Reviewed the cost analysis of queries and recommended efficiency changes. Resulted in 75 total minutes in reduced run time

Northwestern Mutual

●	Created and modified reports using SAS and SAS Windowing to reduce underwriting backlog    by 5%, reduced overtime costs by $15.000 per month
●       Created automated process to run before and after queries for common table updates to compare and format before and after results. Saved over 50 hours and over $3,750 in labor cost on project
●	Created confluence pages for on-boarding new hires decreasing training time by 12 hours
●	Performed High-level analysis on sprint stories to define scope and objective

Great Lakes Educational Loan Services, Inc.

●	Led and implemented project to replace manual fax and email process with an automated  process saving over 300 hours and $15,000 dollars per month in the process.
●	Installed, customized, and monitored IBM Rational Asset Analyzer Metadata Repository, allowing developers to reduce analysis time by an average of 10%.
●	Performed ETL for Data Warehouse using DataStage, reduced development time by 15%.
●	Created BI Reports using Microsoft Analysis Services.
●	Gathered data and computed costs of data warehouse project. Cost included development resources, both contract and in-house staff. Software licensing and storage costs for both mainframe and servers. Mainframe disk storage. Calculated clock and cpu time of mainframe ETL jobs. Compiled costs into a report for CTO to present to executives

Data Scientist with Post Graduate Certificate. Data Science and Data Analysis. May 2022. 28 years of SQL and relational database experience with an emphasis on  high performing SQL.  

Expert business and data analysis skills. Adept at finding not only the what in data but the why.

Experienced at automating processes to save time and money.

Strong in Machine Learning using both R and Python. Excellent statistical model building skills.Top notch data and business analysis skills. Excellent written and spoken communication skills. Experienced at requirement gathering and as a team lead. Proficient in  project leadership. I have led multiple small and medium size projects that finished on time and on or under budget.

Created Tableau dashboard for FP&A area to assist them in their monthly financial reporting. Created dashboards of Legacy and New table counts to assist Data Engineers verify re-designed Data Warehouse. 

Performed accuracy testing of data in new vs legacy warehouse. Investigated discrepancies and discussed findings with Data Engineers.

taplio

The Battle

Christian Wanser

Jim Ryan

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?