Kevin Paulson Email & Phone Number

Waterloo, Ontario, Canada

* Major project: Python Module - Problem: The newly released API for MindBridge was difficult to use with the tools clients and internal users were used to - Solution: Created a new Python software development kit (SDK) - Impact: Result was significantly improved experience for both clients and internal users* Created and update Python projects to automate repetitive tasks* Lead the end-to-end data ETL (extract, transfer, load) processes from a customer's ERP system into MindBridge* Extracted, formatted, and loaded financial data using tools such as Python, Excel, and command line tools* Provided feedback and influence the product decisions based on customers' needs

Waterloo, Ontario, Canada

* Major project: Self-Serve Reporting - Problem: Clients unable to get data without significant assistance - Solution: Brought reporting to a new maturity by creating a data access layer that provides consistent and clear access to data - Impact: Result was significantly improved client experience, better product, and more efficient report creation* Created SQL functions, tables, indexes, triggers, permissions, and complex queries in PostgreSQL to support storage and analysis of data* Created and maintained an ETL (extract, transfer, load) process that has extensive data validation using Python and SQL* Collaborated with clients and internal stakeholders to identify critical data points and develop their reports and dashboards with Tableau and Excel* Automated deployments with Python with XML API interactions* Conducted code reviews with GitLab and mentored teammates

Kitchener, Canada Area

* Major project: Tooling Switch - Problem: Reports were using MS Excel and MS Access which could take hours to generate and required significant manual effort to produce - Solution: Implemented switch to MS SQL Server using SQL Server Integration Services to create data warehouse - Impact: Result was faster report generation enabling business leaders to make decisions with confidence* Created reports with interactive functions using advanced Excel tools such as VBA and pivot tables to support business leaders* Completed technical design, development, and testing of reports* Analyzed business procedures and gathered information from key stakeholders to develop high quality, insightful reporting* Identified opportunities for improvements and presented business cases to support recommendations* Extracted data using SQL Server Integration Services from various internal sources including DB2, mainframe, text, Excel, Access, and other SQL servers* Created complex stored procedures in SQL to facilitate analysis and reporting

Toronto, Canada Area

* Major project: Project Standardization - Problem: All reporting projects used different techniques and approaches to achieve deliverables - Solution: Implemented standardized data aggregation techniques. Standardized client deliverables where possible using guidance from internal experts - Impact: Consistent process and deliverables resulted in more repeatable processes* Trained, coached, motivated, and managed a team of 10 Data Analysts* Analyzed the Data Services processing workflow, identifying, and implementing solutions to streamline procedures* Collaborated with analysts, engineers, and software developers to recommend changes to current products and processing tools* Communicated with clients to ensure that all requirements were captured accurately* Managed extensive amounts of data using various database systems* Wrote SQL scripts to analyze, interpret, update, organize and summarize data for clients* Completed "Practical Project Management Fundamentals" course