- Prepared Business Requirements, User Stories, Stakeholder Engagement Report, Analysis and Options Document to support Customer Outage Review (COR) initiatives.
- Worked closely with Test Analyst by creating testable business, stakeholder & functional requirements for several COR initiatives. Worked on the design building workshops for the Data Capture Tool and communicated the application requirements with the external vendor.
- Automated Employee Productivity Report by integrating data from Payroll system, HR system and internal system. Supported business processes, created process documentation using BPMN in MS Visio, increased Employee Productivity from 35% in February 2020 to 85% in June 2020.
- Gathered requirements for data extraction from Microsoft Azure databases and data warehouses by writing advanced SQL queries, mapping and integrating the data using SSIS package, cleansing and wrangling. Developed error handling code for integration.
- Constructed dashboard visualisations in MS Excel, Tableau and Power BI for data driven decision making.