Ekta Sahoo
Milton Keynes,UK
Summary
Accomplished professional with expertise in data analysis and visualisation, project management, and technical and business liaison. Demonstrates proficiency in ETL performance optimisation and database performance enhancement, underpinned by a strong understanding of data governance principles and cloud computing fundamentals. Adept at enhancing customer communication skills to drive successful project outcomes.
Overview
2027
2027
years of professional experience
1
1
Certification
Work history
Sr Technical Analyst
Santander UK
Milton Keynes, UK
2025.06 - Current
- Mapped source files and structures of Various Interfaces to the AFCS data model, identifying gaps and applying data transformation rules.
- Partnered with technical team to understand interface logic and closing details.
- Outlined needs to meet end user requirements.
- Developed and implemented system testing plans in support of deployments.
- Monitored schedule and fixed bugs, defects, and failures in pre environment.
- Tested Trade 360 interface and logged technical issues until resolution.
- Deployed ODI scenarios to pre and production environments.
- Ran Unix scripts across pre and production environments.
- Analysed data with development and testing teams before Pre-Production and Prod release.
- Maintained a high level of industry awareness through continuous learning and professional development.
- Led cross-functional teams to achieve project objectives.
- Served as a key liaison between business and technology teams, fostering open communication.
Sr Technical Analyst
Santander UK
Milton Keynes, UK
- Mapped SAP interface source files and structures from Walker to new platform.
- Delivered training sessions to enhance team's technical knowledge and skills.
- Worked with technical teams to understand interface functionality and logic of SAP Hana Implementation.
- Tested SAP interfaces by flagging technical issues through resolution.
- Discussed new implementation approaches with client and provided technical solutions.
- Coordinated change management requests for deployment across multiple environments.
- Served as a key liaison between business and technology teams, fostering open communication.
- Collaborated with development and testing teams on data analysis and testing.
- Conveyed complex information in an understandable manner to non-technical individuals.
Senior Data Analyst
Capgemini UK
Bristol, UK
- Extracts, cleans, and engineers nuclear system data for analysis readiness using Azure.
- Applies SQL Server Management Studio workflows and Power BI reporting for clients.
- Supports HPC key clients by providing application performance analytics for strategy.
- Analysed complex datasets for key patterns and trends impacting business growth.
- Worked on documenting the detailed functional and non-functional requirements and created the comprehensive acceptance criteria that is easily understand across the whole team.
- Worked on creating the Data Catalogue, Data dictionaries, GAP analysis documentation of the various application. Collaborated with the IT Teams to devise data strategy.
Sr Data Analyst
Capgemini UK
, UK
- Project Name: Coca Cola
- Tools and Technology Used: IDQ, MS SQL, Excel, Informatica PowerCenter, Service Now, SailPoint.
- Working in Extracting, cleaning, and engineering data ready for analysis.
- Identity and Access Management (IAM) is how we manage- “who” every individual working with CCEP is (identity), and “what” they can do in our systems (access). IAM ensures that the right people get the right access to the right resources at the right times for the right reasons, enabling the right business outcomes.
- Analysed different systems to identify a single source that allows a single employee to have a permanent ID for all activities within CCEP systems and tools.
- We worked here to maintain central monitoring and intelligence while supporting agile, market focused local customization.
- Worked on Master data clean-up and on setting up a data governance for the golden source.
- Worked on Implementation of Informatica IDQ – deployed IDQ into client data centre managing various practical challenges to do so.
- Client stakeholder engagement – ongoing engagement with key business and service operation owners and established me as data SME
- Worked on Understanding of identity data employed and associated issues – involved in deep understanding of data and how employed in legacy systems. Impacts of poor-quality data on operations.
- Worked on Creating the Dashboards, Scorecards and representing the final data extracted from data warehouse to the stakeholders explaining the trend and patterns of data quality metrics and dimensions over the period.
- Worked on High level results and dashboarding - Overall cleansed the of key identity data to >98% - null manager; duplicate accounts; leading to alignment between legacy systems SAP IDM 7.2/8.0 and Regional and Group Ads
Sr Data Analyst
ITC Infotech UK
Milton Keynes, UK
- Analysing financial data for multiple management levels using Informatica and Oracle.
- Preparing and summarising financial reports with Unix, Oracle, and BOXI reports
- Monitoring delivery schedules and fixing bugs, defects, and SLA failures.
Sr Business Analyst
ITC Infotech UK
Milton Keynes, UK
- Wrote oracle queries to simplify analysis of 26 SOLIX archives for GDPR.
- Analysed complex SOLIX queries within Oracle database for GDPR use.
- Worked as data analyst categorising SOLIX archive entities for GDPR EEC features.
- Evaluated business requirements to formulate effective strategies.
- Streamlined business processes for increased efficiency.
- Led cross-functional team to successful project completion.
Education
Bachelor of Technology(Btech) - Information Technology
Silicon Institute of Technology
IndiaSkills
Data analysis and visualization
Project management
Technical and business liaison
ETL performance optimization
Data governance principles
Cloud computing fundamentals
Database performance enhancement
Customer communication skills
SQL expertise
Data analysis
Stakeholder relations
Technical documentation
Resource management
Data Integration and ETL
Certification
- Certified Business Analytics Professional
- Certified Teradata 12 Basics Professional.
- Teradata SQL Certified Professional.
- Teradata Technical Specialist.
- Oracle Certified Associate(OCA)
Accolades
Have been recognized by Santander Award category for my recent Training done in BigData and Hadoop. Got Token of Appreciation from Sr Santander team., Have been Awarded as Most Valuable IT Associate Consultant in 2016 November by ITC Infotech UK for my outstanding performance in Santander UK.
Timeline
Sr Technical Analyst
Santander UK
2025.06 - Current
Sr Technical Analyst
Santander UK
Senior Data Analyst
Capgemini UK
Sr Data Analyst
Capgemini UK
Sr Data Analyst
ITC Infotech UK
Sr Business Analyst
ITC Infotech UK
Bachelor of Technology(Btech) - Information Technology
Silicon Institute of Technology