DevOps, SSIS, ETL, PowerShell, Access (2017)
Type: Health Care : Finance
Company: Provincial Health Services Authority
Location: Vancouver, British Columbia
Role: Senior Business Analyst / Application Developer
MSAccess Client Application, SSIS/SSRS, ETL, PowerShell, Technical Documentation, KTLO, JIRA, Support and Development, Design Document (SAD).
Wrote and deployed several fixes and enhancements to an MS Access client application with SQL database backend — a client/server setup implementing complex business rules. Wrote PowerShell scripts to automate some steps in the daily KTLO task, eliminating the need to manually access remote servers and take screen shots. Scheduled scripts and data extracts via SSIS and created SSRS report. Prepared design document to extract records from a remote database as part of BA work.
Prepared technical documentation, release notes and temporary versioning for each development task.