Padmaja R

Business data analyst-Leading UK bank - Mortgages

• Project 2 ( 01-02-2024 - current ) Collaborated with stakeholders to collect and analyze requirements, transforming business needs into technical solutions and actionable strategies.
• Performed data discovery across multiple sources to map relevant columns based on project requirements.
• Created Source-to-Target Mapping (STM) documents, outlining transformation logic based on project requirements for ETL developers in building the pipeline.
• Worked on data modelling to map attributes to the corresponding table in the target layer for effective data mapping and integration.
• Validated data to ensure accuracy and alignment with business requirements. Provided mentorship and guidance to junior team members, overseeing data analysis activities and driving project success.

Project 1 ( 15-03-2023 - 31.1.2024) Business Analyst-Leading UK bank. Data Migration: CDW-CCL

• Developed detailed Data Migration Methodology (DMM) and Functional Specification Document (FSD) for collateral systems, outlining comprehensive data mapping processes for seamless migration from multiple source systems to the target destination.
• Performed end-to-end data validation to ensure accuracy, consistency, and completeness throughout the data migration process from source to destination systems.
• Developed transformation logic for all attributes across multiple layers, ensuring accurate data flow and consistency throughout the data processing pipeline.

• Collecting, Cleaning, analyzing, and interpreting large sets of Financial, Credit, and CRM data.
• Created a loan performance portfolio dashboard and performed credit risk analysis. Proven ability to effectively communicate findings and insights to non-technical stakeholders through data visualization and storytelling.
• Provided credit risk analysis insights by evaluating credit rating and industry/sector exposure data.