Created the database for reporting team.

Extracted data from multiple sources including SQL Server databases and spreadsheets. This likely involved writing SQL queries to retrieve specific datasets from the HR/CV database.

Developed interactive reports within Power BI that allowed users to explore the data dynamically and gain deeper insights into HR/CV metrics.

Collaborated with stakeholders at HSBC to understand reporting requirements and translate them into actionable insights through visualizations

Collaborated with cross-functional teams to gather data requirements and translate them into effective Power BI solutions.

Ensured data integrity and quality during the extraction process.

Experience with ServiceNow Configuration.

Conducted data cleaning activities to preprocess the dataset for analysis. This included removing errors, inconsistencies, and handling missing values to ensure the dataset was reliable and suitable for reporting purposes.

Expertise in system log file analysis.

Experienced in maintaining and managing batch scheduling environments and monitoring systems.

Created SQL Server Reports using SSRS for management.

Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.

Documented the data such as entity relationships and attributes, file description and definitions.

Implemented data cleansing and transformation processes to ensure data accuracy and consistency.

Built a data model using Power BI to organize and structure the cleaned dataset. This involved defining relationships between different tables to support efficient querying and visualization.

Developed and Maintained Power BI dashboard and reports to provide real-time insights into key performance indicators(KPI).

Collaborated with Data Engineers to improve data pipeline and data quality.

Looking after the Incident and request tickets in ServiceNow and making sure it’s been completed successfully and closed well before SLA breach.