Nic Hanson Email & Phone Number

Abbott Park, Illinois, Us

● Provide extensive reporting and dashboarding solutions to enable our sales organization ● Advanced Tableau and PowerBI experience in designing customized interactive dashboards ● Experienced in writing complex SQL queries, stored procedures and views to support reporting needs● Experience in gathering business requirements, analysis, design, development, testing, implementations and documentation of various functionalities of data warehouse and BI● Involved in full life cycle development of reporting projects, includes requirements gathering/ analysis, design, development, testing and productionFocused Skill Areas: Tableau, SQL Server, CRM, Salesforce, Power BI, Power Apps, Microsoft CRM, Snowflake,

Saint Paul, Mn, Us

● Design, develop and maintain business intelligence solutions● Craft and execute queries upon request for data● Present information through reports and visualization (SSRS, Power BI)● Perform code building tasks (design/code reviews and approval, object promotions, production processrepresentation)● Maintain technical documentation and project plan for development activities including full SDLC process● Perform necessary SQL Server programming as well as analyze, maintain, and produce SSRS/SSIS BI solutions as required.● Participate with other team members in the design, development, testing, and implementation of best practice Data Warehousing solutions.● Participate in data warehouse initiatives with key business stakeholders by gathering and documenting key business definitions, measures, and standards.● Evaluate BI system performance and make technical recommendations to resolve issues.

● Manage Data Warehouse and SQL technologies (Stored Procedures, SSAS, SSIS), database (SQL Server), and enterprise Reporting applications (SSRS, Crystal Reports, Excel Pivot Tables, & other technologies).● Responsible for modeling data warehouse & cube designs, analyzing, testing, & validating the results, generating reports & dashboards, and addressing user questions concerning data integrity.● Create Business Intelligence best practices, Data Warehouse architectures & concepts - ETL, fact, dimension, & measures, relational structures, dimensional data modeling, SQL, data mining, data warehouse & reporting techniques.● Write / review / maintain documentation describing all elements of data warehouse and cube design (including standards, functionality, logic, deployment & implementation procedures, time estimates, and test plans).● Assist with the evaluation and selection of the software that will be included in the technical architecture, as well as the evaluation and selection of the hardware on which the technical architecture will be developed, tested and deployed

Pearl City, Il, Us

● Design, develop, and maintain financial and operational reports. ● Design, develop, and implementation of Internal operations software. ● Responsible for all SQL Server administration and ERP Security.● Structured a new chart of accounts and item list to improve financials reporting.● Planned and managing all data and software migrations.● Overall responsible for all data storage, backups, and recovery methodologies.● Responsible for all hardware and software acquisitions.

● Oversee all general accounting functions such as account payables/receivables, invoicing, income tax preparation/filing, and cash flow.● Assisted President with preparation of business plan. Assisted President with business decisions that involved new projects, alliances, and pricing options.● Created and implemented an accurate financial job costing system.● Monitor revenues and expenses. Perform financial analyses and special projections. Analyzed invoices, and other relevant documents for financial credits or risks.● Structured a new chart of accounts and item list to improve information of financial reports such as Profit/Loss Statement and Balance Sheet.

Middleton, Wi, Us

● Managed 15+ direct reports, offer accurate and timely feedback● Created dashboards and ad-hoc reports● Led a vast array of technical projects; project planning, scheduling, project cost management and project close out● Successfully managed day-to-day operations● Other duties included, quality assurance, technical and quality training and documentation, employee evaluation, and employee development