Marc Samuelson
Sr. Reporting Analyst/BI Analyst/Data Analyst
Minnetrista, Minnesota 55375
ad1yae@r.postjobfree.com
https://www.linkedin.com/in/marcrsamuelson/
Professional Summary
13+ years gathering business requirements, modeling, analyzing, reporting, data, and creating dashboard visualizations using such tools as IBM Framework Manager, IBM Cognos Analytics, SSMS, MS Power BI, and MS Excel. Trainer, consulter, and mentor. Strong ability to explain technical concepts to non-technical audience at all levels of an organization. Solid understanding of data warehousing concepts and ETL processes. Competent with relational, star, snowflake database schemas, facts, dimensions, measures, constraints, foreign keys, and table joins. Passionate for data and learning new technologies. Excellent analytical, communication, customer service skills, and a great work ethic. Capabilities Results
Problem Solving
Dimensional Data Modeling/Automation
Project Management
Complex Reporting
Data Analytics/Visualizations
Communication
Saved Commercial Finance 25+ hours each month by resolving an inefficiency issue with accessing monthly Cognos reports and data feeds.
Reversed engineered data warehouse to developed custom IBM Framework Manager Package/Data Mart to automate
Commercial Finances’ laborious process of gathering data from 30+ Microsoft Excel spreadsheets, resulting in a decrease in delivery time of final monthly reporting metrics to corporate accounting by 5 days.
Gathered, organized, analyzed, documented, and converted 500+ reports and data feeds from 6 TCF banking regions for new large Commercial Loan Servicing system conversion project. Was awarded TCF’s IT Excellence award for completing project before deadline and under budget.
Won TCF’s Annual Customer Service award for exercising patience and tolerance with the Vice President of Credit Administration while working on an extremely complicated Loans to One Borrower report that required 18 query subjects to accommodate 20+ different customer Total Exposure scenarios. Utilizing MS Power BI, created dashboards for Commercial Loan Serving to assist in tracking delinquencies, new loans processed, monthly transactions, transaction reversals, RPA, and SWAP loans, total loan exposure as well as the entire commercial portfolio of open and closed loans.
Created successful internal training program and manual to advance the end-users knowledge of IBM Cognos.
Requirements Gathering, Written and Verbal Communication, Documentation of custom data marts, reports and extracts, IBM Framework Manager, IBM Cognos Analytics, MS SQL Server Management Studio (DDL, DML), Stored Procedures, Triggers for Audit tables, MS Power BI, Microsoft Office 365, MS Visio, Bright Star Meta Data Manager, Agile, Waterfall, Informatica (1 year), Customer Service, Trainer/Consultant/Mentor/Standup Teacher. Marc Samuelson Page II
Professional Experience
Senior Reporting Analyst/Dimension Data Modeler/BI Analyst/Data Analyst TCF National Bank (now Huntington Bank)
Dates Employed: November 2007-February 2020
Location: Plymouth/Minnetonka, Minnesota
Provided data-related solutions for the Business by gathering requirements, building custom models and data marts utilizing IBM Framework Manager.
Created recurring, ad hoc reports, visualizations/stories, and internal/external data feeds using IBM Cognos Analytics and Microsoft Power BI.
Monitored daily, monthly, quarterly, and annual report/extract schedules. Responded to any schedule failures and communicated status to the business on an hourly timeframe.
Documented and saved all source code.
Mentored less experienced BI Developers and Business Users. Created successful internal training program and training manual to assist the Business with advancing their knowledge of Cognos Analytics.
Participated in Quarterly Audits, helping auditors with the selection criteria and SQL syntax behind a model, report, or extract.
Worked closely with ETL team to create successful/failure monthly notifications for customized IBM Framework Manager data feeds.
Earned Subject Matter Expert status.
Data Analyst (Contractor)
Boston Scientific
Dates Employed: March 2007 – November 2007
Location: Arden Hills, Minnesota
Developed ad hoc and recurring queries for medical device tracking purposes using SQL Server 2000 and MS Excel.
Education
University of Wisconsin-River Falls
Bachelor of Science in Business Administration and Economics Location: River Falls, Wisconsin
Core Technologies/Skills