Danik Collin Email & Phone Number

Canada

Ottawa, Ontario, Canada

Analyzed and translated complex data findings into visually appealing and informative reports using tools such as SSIS, SSRS, and Power BI. Modified and massaged data to ensure its quality and consistency, improving the accuracy and reliability of the analysis. Created and implemented an ETL (Extract, Transform, Load) package, allowing for the efficient transfer and processing of data between systems. Created a database job using SSMS to execute the ETL packages, improving… Show more Analyzed and translated complex data findings into visually appealing and informative reports using tools such as SSIS, SSRS, and Power BI. Modified and massaged data to ensure its quality and consistency, improving the accuracy and reliability of the analysis. Created and implemented an ETL (Extract, Transform, Load) package, allowing for the efficient transfer and processing of data between systems. Created a database job using SSMS to execute the ETL packages, improving the automation and reliability of the system. Followed up on maintenance and support needs of clients, ensuring their satisfaction and providing a high level of customer service. Documented the process and implementation of the solution, enabling future maintenance and development. Show less

Ottawa, Ontario, Canada

Designed and implemented a custom solution for automating the cleaning and formatting of Excel reports, reducing manual effort and improving the accuracy and timeliness of data analysis. Linked SQL servers to Excel spreadsheets, enabling seamless integration and data transfer between systems. Created automation using PowerShell scripting, allowing for the efficient and reliable execution of the report cleaning and formatting process. Utilized pivot tables and charts to… Show more Designed and implemented a custom solution for automating the cleaning and formatting of Excel reports, reducing manual effort and improving the accuracy and timeliness of data analysis. Linked SQL servers to Excel spreadsheets, enabling seamless integration and data transfer between systems. Created automation using PowerShell scripting, allowing for the efficient and reliable execution of the report cleaning and formatting process. Utilized pivot tables and charts to analyze and display the data in a user-friendly and visually appealing manner, improving comprehension and decision-making. Documented the process and implementation of the solution, enabling future maintenance and development. Worked with a range of technologies, including PowerShell, Excel, and SSMS, demonstrating versatility and expertise in various tools and systems. Show less

Ottawa, Ontario, Canada

Repaired an outdated solution for generating offline cubes, converting old .NET Framework code to .NET Core for improved functionality and compatibility. Created automation using PowerShell, reducing manual effort and improving efficiency in cube processing and availability. Built an offline multi-function script that streamlined the cube processing and availability process, improving accessibility and ease of use for end-users. Documented the process and implementation of… Show more Repaired an outdated solution for generating offline cubes, converting old .NET Framework code to .NET Core for improved functionality and compatibility. Created automation using PowerShell, reducing manual effort and improving efficiency in cube processing and availability. Built an offline multi-function script that streamlined the cube processing and availability process, improving accessibility and ease of use for end-users. Documented the process and implementation of the solution, enabling future maintenance and development. Worked in an environment that included SQL Server 2016/2017, SSMS, SSIS, SSRS, Team Foundation Server, Azure DevOps, Visual Studio 2019, SharePoint 2014/2016, SSIS, Microsoft Dynamic 365, and Power BI, demonstrating versatility in working with various tools and technologies. Developed a custom solution to automate the creation and maintenance of SQL Server Analysis Services (SSAS) cubes, reducing manual effort and improving the accuracy and timeliness of the data. Implemented JSON data formatting and processing for improved data integration and analysis within the SSAS cubes. Utilized PowerShell scripting to automate the deployment and maintenance of the SSAS cubes, improving the efficiency and reliability of the system. Designed and implemented security protocols for the SSAS cubes, ensuring the protection and confidentiality of sensitive data. Show less

Ottawa, Ontario, Canada

Designed and developed web APIs using .NET Core, C#, and SQL Server, enabling data integration and communication between different applications and systems. Created interactive and visually appealing BI solutions using Power BI and SSRS, allowing stakeholders to make data-driven decisions and gain insights into business operations and performance. Worked collaboratively with application development, server, and storage groups to ensure optimal performance and efficiency of IT… Show more Designed and developed web APIs using .NET Core, C#, and SQL Server, enabling data integration and communication between different applications and systems. Created interactive and visually appealing BI solutions using Power BI and SSRS, allowing stakeholders to make data-driven decisions and gain insights into business operations and performance. Worked collaboratively with application development, server, and storage groups to ensure optimal performance and efficiency of IT systems, and identified areas for improvement and optimization. Conducted tests and debugging to ensure the quality and functionality of applications, identifying and resolving issues in a timely manner. Provided quick and constructive feedback to team members and stakeholders, contributing to a positive and productive work environment. Environment: SQL Server 2016/2017, SSMS, SSIS, SSRS, Team Foundation Server, Azure DevOps, Visual Studio 2019, SharePoint 2014/2016, SSIS, Microsoft Dynamic 365, Power BI. Show less

Ottawa, Ontario, Canada

Provided technical support to customers via phone, email, and chat, resolving issues related to internet connectivity, software and hardware problems, and billing inquiries. Developed and maintained internal IT systems and infrastructure, including servers, network devices, and software applications, ensuring their reliability, security, and scalability. Assisted in the design and implementation of new IT projects, such as software upgrades, network expansions, and cloud… Show more Provided technical support to customers via phone, email, and chat, resolving issues related to internet connectivity, software and hardware problems, and billing inquiries. Developed and maintained internal IT systems and infrastructure, including servers, network devices, and software applications, ensuring their reliability, security, and scalability. Assisted in the design and implementation of new IT projects, such as software upgrades, network expansions, and cloud migrations, providing technical expertise and project management skills Conducted training sessions for colleagues and customers, teaching them how to use new software and systems, as well as troubleshooting techniques for common issues. Collaborated with cross-functional teams, such as marketing, sales, and product development, to identify and implement IT solutions that enhance customer experience and satisfaction. Show less

Computer Programming

Computer Engineering