Summary
Overview
Work history
Education
Skills
Websites
Certification
Languages
References
Timeline
SoftwareDeveloper

Wardha Sajid Mir

Greater Manchester,United Kingdom

Summary

I am an experienced Lead Data Specialist/Migration Analyst, DBA, Database Developer, Senior Analyst, Administration Executive and Software Developer, with over years of experience at multiple national and international organisations.

Overview

11
11
years of professional experience
27
27
Certification

Work history

Data Migration Specialist

Legal and General
London
02.2023 - Current
  • Lead & Executed Oracle data migration activities to maximize efficiency and accuracy of migration, validating data across system & aligning configuration with migration
  • Lead data purge, field mapping, data dictionary activities
  • Manage discussion with Subject Matter Experts, Functional, Integration, Testing, Data Architecture teams
  • Developed Workflow is Alteryx & documented in confluence
  • Determined ways to improve efficiency and ensure accuracy of transfer using suitable tools (Alteryx/Notepad++/Beyond Compare/VS code/Power Automate/Excel/Macro/Python)
  • Prepared reports & data visualisations.
  • Resolved risks & solve problem as early as possible, to ensure minimal impact to wider program, managing solutions for risk mitigation
  • Tested system to validate functional & non functional requirement
  • Analysed different system like Business Objects, Resource Link, Harbour, SMART with BA and improve data quality for migration

HRIS Data Specialist

Fresenius Medical Care
Nottingham
03.2022 - 02.2023
  • Lead for gathering relevant data for each wave from multiple Countries in NCE and deliver with agreed time scales for Workday
  • Implementation, functional and user testing across different modules
  • Oversee implementation of HR technology requirements, determine appropriate revisions to policies and procedures, analyse proposed changes from HR and non-HR groups and provide appropriate guidance to management
  • Resolving complex HR reporting requests for all levels of management
  • Improved efficiency of data gathering process by reviewing and revising how data is stored and collected locally
  • Translating and mapping data from both live and legacy systems
  • Analysing different reports using Excel advance skills
  • Uploading data to Visier, aligning Global Job Catalogue reporting with Workday job profiles
  • Merging large datasets, checking, and improving overall data quality and integrity for Workday and Visie reporting
  • Handling project requirement and test implementation for document management and document generation
  • Documented all relevant project actions and documents using appropriate tools such as Confluence, JIRA, SharePoint
  • Prepared monthly and ad hoc reporting to support different teams
  • Adherence to GDPR - data being collected was confidential, personal, and sensitive, always protected it
  • Proving training for new system and support Go Live activities
  • Execute data improvement initiatives by increasing automation, reducing department costs.

Data Analyst

Magnum Utilities
Greater Manchester
07.2021 - 12.2021
  • Extracted workflow data from industry database (SQL) to create schedules of completed work
  • Prepared and sharing detailed reports with clients, suppliers, and team
  • Proactively developed regular benchmarking reporting and analysis to enhance understanding of performance relative to providers
  • Analysed big data set, using Advance Excel skills.
  • Identified, analysed, and interpreted trends or patterns in complex data sets
  • Work with field management team and client services team to ensure data is recorded accurately, answering queries related to data
  • Supported and contributed to ongoing design, development, promotion, training and rollout of Intelligence tool and systems
  • Monitored quality of data and to work with services to improve quality of data, negotiating and influencing recovery plans as required

Commercial Data Administrator

City and County Healthcare
Manchester
03.2021 - 07.2021
  • Defined technical and commercial requirements for invoice information, content, and format
  • Extracted and transformed data, accurately loading into data warehouse
  • Documented format and fields required to ensure correct invoicing, including definition and documentation of all rules required to produce invoice
  • Automated and systemised invoice production by Business intelligence and IT teams
  • Facilitated implementation of new operational systems according to established project plans and ensuring work stream milestones and deliverables accordingly
  • Completed pre-go-live checks
  • Updated master data and ensured best data quality
  • Liaised with Rates and Specialist Invoicing Team members on first invoice run of each new invoice, ensuring all data output is generated as expected
  • Analysed of visit exports to ensure data compliance and integrity - Alteryx
  • Troubleshooted data discrepancies

Data Analyst

National Grid
Coventry
08.2020 - 12.2020
  • Execute completion of first and second stage assessment of Agreement Management processes
  • Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
  • Ensuring alignment between current and evolving processes and underlying reporting and system capabilities
  • Ensuring organizational alignment with broader company goals/changes i.e Digital products, data aggregation efforts and work management tool implementations and evolutions
  • Critically review assessment outcomes and result letters to ensure information accuracy
  • Highlighted and resolved complex issues or potential issues
  • Prepared for application appeals
  • Improved data integrity with rigorous auditing and cleansing.

Data Administrator

Harrods
London
10.2019 - 02.2020
  • Ensured all data is accurate and up to date in multiple database systems (SAP, PIM, Enactor)
  • Oversaw correct synchronisation between databases, troubleshooting application-related issues
  • Used SAP and PIM systems to maintain data integrity daily and carry out data quality checks
  • Reviewed and investigated Workday data for any inconsistencies early on, focusing on finding cause and providing solution
  • Liaised with data providers and suppliers for missing data & ensured all product, pricing and commercial information is up to date
  • Identified areas of improvement in systems and processes
  • Developed close working relationships with Key Stakeholders
  • Provide administration support and resolution to administrative queries to ensure smooth, efficient running of Department
  • Provided project management capability including creation and ownership of project documentation.

Patient Access Coordinator - Temporary

NHS
London
10.2019 - 10.2024
  • Maintained information on internal systems - EMS, Datix
  • Act as first point of call for all patient access queries to Trust
  • Ensure that vetting process has been followed in line with departmental guidelines liaising with Referral Management Centre as required
  • Liaised with hospitals, patients, clinicians, and healthcare staff to book clinics and investigatory procedures
  • Be responsible for scheduling of outpatient, elective admissions, and all associated appointments according to clinical urgency and length of wait in accordance with departmental procedures and Trust Policies
  • Ensured that departmental standards are met for patients receiving notification or acknowledgement of their visit
  • Managed databases and information systems, maintaining accurate and accessible records.

Database Developer and Administrator

International Renewable Energy Agency (IRENA)
Abu Dhabi
02.2017 - 04.2019
  • Lead database development project to ensure all modules are deliver on time and according to requirement
  • Created tables, queries and views in SQL
  • Planned requirement gathering, data collection procedures, data updating, and data quality check
  • Wrote queries using SQL to retrieve, build, delete or update information in database.
  • Handled server permissions, assisting new users, assigning login's and provide training
  • Managed database access, security/integrity, and backup procedures
  • Designed and implemented maintenance procedures to ensure optimal performance
  • Identified issues within databases, troubleshooting technical problems and implementing practical solutions.
  • Assisted in production of annual yearbooks of statistics, online data services and other statistical products using different systems - Tableau
  • Identified redundant data and performing regular clean-up using Advance Excel/Macro
  • Problem-solving and critical thinking skill, including ability to understand data and its implications to identify patterns and relevant strategic risk insights
  • Tracked database KPIs, reporting key metrics and using results to plan improvement action.
  • Manage team of interns for data gathering from different countries
  • Provided trainings to different users at different levels along with maintained professional and technical knowledge by attending workshops, events, and different international meetings
  • Documenting diagrammed database designs and wrote technical documentation

Database Developer

Zeeruk International
03.2014 - 01.2016
  • Assisted in development of Road Asset Management Database (RAMD)
  • Improving effectiveness of database tools and services
  • Make sure information is protected and backed-up
  • Monitored database performance, Improving technology used
  • Build new databases, monitoring data entry procedures
  • Troubleshooted database
  • Ensured website are well designed, testable, efficient code by using best software development practices
  • Created website layout/user interface by using standard HTML/CSS practices
  • Integrated data from various back-end services and databases
  • Created and maintaining software documentation
  • Collaborated with web designers to match visual design intent
  • Used Asp.net, HTML, CSS, and other programming languages for website development tasks.

Education

Bachelor of Science - Computer Science (BSCS)

COMSATS University, Islamabad, Pakistan

Associate Data Engineer in SQL -

Datacamp
Virtual

Skills

  • Database management
  • Oracle Database
  • Data migration
  • Data visualisations
  • Oracle database management
  • Financial data analysis
  • Data gathering and documentation
  • Data analysing
  • Data quality checking
  • ETL processes
  • Reporting data
  • SAP
  • Problem-solving
  • Project Management
  • Data collection and analysis
  • Process development
  • Stakeholder management
  • Technical analysis
  • Data mapping
  • Gap analysis
  • Alteryx
  • Workday
  • Team building
  • Power Automate
  • Data interpretation
  • Workflow mapping
  • Document management

Certification

  • Understanding Artificial Intelligence - June 2024
  • Alteryx Designer Core Certified - June 2024
  • Understanding Data Visualization - June 2024
  • Introduction to Snowflake - May 2024
  • Introduction to Data Warehousing - April 2024
  • Understanding Cloud Computing - March 2024
  • Introduction to Python - Feb 2024
  • Database Design - Feb2024
  • Workday - Feb 2023
  • Drupal Camp - April 2015
  • VB.NET - Aug 2014
  • Web Development using PHP - June 2013
  • ESCAN IDEA - Nov 2010

Languages

English
Proficient (C2)
Urdu
Proficient (C2)
Arabic
Intermediate
Punjabi
Intermediate
German
Beginner

References

References available upon request.

Timeline

Data Migration Specialist

Legal and General
02.2023 - Current

HRIS Data Specialist

Fresenius Medical Care
03.2022 - 02.2023

Data Analyst

Magnum Utilities
07.2021 - 12.2021

Commercial Data Administrator

City and County Healthcare
03.2021 - 07.2021

Data Analyst

National Grid
08.2020 - 12.2020

Data Administrator

Harrods
10.2019 - 02.2020

Patient Access Coordinator - Temporary

NHS
10.2019 - 10.2024

Database Developer and Administrator

International Renewable Energy Agency (IRENA)
02.2017 - 04.2019

Database Developer

Zeeruk International
03.2014 - 01.2016

Bachelor of Science - Computer Science (BSCS)

COMSATS University, Islamabad, Pakistan

Associate Data Engineer in SQL -

Datacamp
Wardha Sajid Mir