Tanner Yatsko

• Build data pipelines using SSIS to transport data from a variety of sources to a data warehouse (these pipelines can involve more steps than just an SSIS package).
• Use SSRS to create, modify, and improve paginated report solutions with a variety of formats and functionality.
• Use SSAS to help manage a tabular model that allows end users to build their own reports and perform ad hoc analysis.
• Some experience building MS Power Apps to allow users to make edits to data within custom tables in databases.
• Create and make updates to Yardi custom reports, which involves SQL script to pull data, and Yardi script for filters and formatting.
• Build flows in MS Power Automate to trigger notifications and to update, create, or delete certain data within databases, when data was changed in another source. Also, to transport files to various external servers for them to be ingested by certain software.
• Work with dataflows associated with Dataverse tables to pull from external data sources like APIs.
• Manage and oversee projects that involve expertise in IT and specifically data transfer.
• Work with Freshservice ticketing system to manage a variety of different requests from a simple Yardi user addition, through to a report update that requires changes to tables, SSIS packages, etc. in a single ticket.
• Work with Excel PivotTables for analysis and testing changes to tabular model.
• Monitor SQL Server Agent jobs that execute nightly data refreshes in the staging environment and troubleshoot failures.
• Focus on being proactive in finding lasting solutions, rather than performing patch work.
• Educate users on new items such as reports, business processes, data policy, and navigation and usage of certain software.

• Worked with Power BI to create new reports that allowed stakeholders across departments to have a quicker view into relevant data. Involved connecting to various data sources, data transformation, and creating relationships between the data from the various sources.
• Worked with Azure to create dataflows to pull data from various external data sources, format it, and then be brought into the Azure hosted data warehouse.
• Played a key role with the BI System selection and development process by completing research and deliverables that described the company-wide business needs and expectations to be met by this BI system.
• Worked closely with business departments to design and improve systems, applications, and processes such as business intelligence and reporting.
• Developed, maintained, and enhanced custom reports to meet the changing needs of the business and ensure optimal performance.
• Lead the development and/or implementation of process improvement solutions.
• Designed reports used to export data for use in financial analysis and KPI reporting.
• Designed, developed, prepared, and distributed regularly occurring reports.
• Served as Support escalation (and backup) for Yardi modules and other systems.
• Completed special projects and other duties as needed.

• Routine report production for Finance, Sales, Marketing, and various other divisions of the company (debug Excel macros, review reports for accuracy, send reports and address client questions)
• Created and worked with a variety of report types such as High Cost Claimant (HCC), Enrollment, and Claims
• Validated monthly metrics for accuracy
• Ad hoc reporting using IBM Mainframe (TSO/JCL SAS), Microsoft SQL Server (T-SQL) and Excel
• Acquired business knowledge and healthcare industry knowledge
• Updated SQL code based on specs and did tests against production
• Completed status reports and weekly time entry