AJIL BABY
Newport,UK
Summary
Data Analyst with 2+ years of experience transforming raw data into strategic insights using Power BI, SQL, and advanced Excel. Expert in building scalable BI solutions, automating reporting processes, and maintaining high standards of data quality and reconciliation across financial and operational systems. Skilled in communicating technical findings to non-technical audiences, and collaborating within Agile, cross-functional teams to deliver continuous improvement in data services.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work history
Data Analyst
Deloitte UK
Cardiff, UK
09.2024 - 12.2024
- Utilized advanced Excel and SQL to extract, manipulate, and format financial data from various ERP systems, ensuring data integrity for analysis in the Deloitte audit platform.
- Utilized SQL for data extraction, transformation, and reconciliations of general ledger, journals, and trial balance data from major corporations like (Cardiff Councils, DHL, Tesco, Admiral), identifying and resolving discrepancies to maintain financial record accuracy.
- Improved the quality of the dataset by ensuring that all data was consistent doing quality checks using SQL language, reducing errors by 15%.
- Conducted data reconciliation across disparate systems (CRM, finance, operations), using SQL queries and audit logic to pinpoint inconsistencies, reduce data drift, and ensure singlesource-of-truth alignment, achieving 99.9% data accuracy.
- Integrated Power BI with Excel and SQL Server for real-time, self-service BI solutions, enabling business stakeholders to explore data independently.
- Delivered clear and engaging data presentations to stakeholders by translating complex SQLdriven insights into visual reports using Power BI, which improved decision-making speed and boosted stakeholder confidence in the data.
Junior Data Scientist
Soften Technology
Kochi, India
02.2023 - 02.2024
- Built machine learning models using Python libraries (Scikit-learn, TensorFlow) and algorithms such as regression and classification, enhancing predictive accuracy and improving business forecasting by 20%.
- Developed and maintained data pipelines, automating repetitive tasks and improving operational efficiency by 25%.
- Developed impactful visualizations using ggplot2 for analysing trends and patterns and built automated reports using advanced Excel features including pivot tables, VLOOKUP/XLOOKUP, nested formulas, dynamic named ranges, and Power Query for ETL workflows.
- Developed a Power BI dashboard to visualize key insights, such as maintenance issues and delayed responses, helping managers prioritize improvements and reduce service delays by 20% through vendor-related adjustments.
- Trained internal teams on best practices for Power BI dashboard usage and Excel-based reporting templates, improving overall data literacy.
Data Administrator
Hazelwood Accountants LTD
Northampton, England
09.2022 - 02.2023
- Ensured the integrity of financial and operational data by conducting regular quality checks.
- Handle multiple projects and priorities, maintaining a strong focus on meeting deadlines under pressure.
- Liaised with clients to gather requirements and deliver customized data solutions.
- Utilized a wide range of advanced Excel functions such as VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IFERROR, and ARRAY formulas to analyse complex datasets and automate calculations.
Junior Data Analyst
ABS & AMS IT solutions
Kochi, India
01.2021 - 02.2022
- Built Excel dashboards to monitor campaign performance, integrating SQL extracts with dynamic visual reporting.
- Created an automated Excel-based reporting toolkit with Power Query and VBA, reducing report generation time by 70%.
- Designed and deployed interactive dashboards with slicers, drill-throughs, DAX measures, and KPIs to visualize sales, customer engagement, and operational data.
- Integrated SQL queries with data visualization tools like Power BI and Tableau to generate automated reports and dashboards, providing insights into key business metrics and trends.
Education
Master of Business Administration - Business Administration
University of Northampton
Northampton, England 01.2022 - 04.2023
Bachelor of Computer Application (BCA) - Computer Science and Programming
Mahatma Gandhi University
Kerala, India 06.2018 - 10.2021
Skills
- PowerBI
- SQL
- Excel
- DAX
- ETL
- DataModeling
- Visualization
- Python
- VBA
- PowerQuery
- Dashboards
- Reporting
- Analytics
- Insights
- Reconciliation
- Documentation
- Communication
- Problem-solving
- StakeholderManagement
- Adaptability
- Collaboration
Certification
- IBM Data Science
- Machine Learning with Python
- AWS-certified Data Analyst
- Data Analysis for Pricing Analysts in Excel (2018)
- Python Project
- Using Power BI with Excel
- Business Analytics: Marketing Data
Custom
References available upon request.
Timeline
Data Analyst
Deloitte UK
09.2024 - 12.2024
Junior Data Scientist
Soften Technology
02.2023 - 02.2024
Data Administrator
Hazelwood Accountants LTD
09.2022 - 02.2023
Master of Business Administration - Business Administration
University of Northampton
01.2022 - 04.2023
Junior Data Analyst
ABS & AMS IT solutions
01.2021 - 02.2022
Bachelor of Computer Application (BCA) - Computer Science and Programming
Mahatma Gandhi University
06.2018 - 10.2021
Similar Profiles
Anuj KumarAnuj Kumar
Senior Manager at Deloitte UKSenior Manager at Deloitte UK
Suryalok SarkarSuryalok Sarkar
Senior Consultant- Test Lead at Deloitte UKSenior Consultant- Test Lead at Deloitte UK
Irina Hauser-LenchukIrina Hauser-Lenchuk
Manager, Sustainability and Climate at Deloitte UKManager, Sustainability and Climate at Deloitte UK
Rebecca ParryRebecca Parry
Care Support Worker at Care CymruCare Support Worker at Care Cymru
Taise MathewTaise Mathew
Care Assistant at Thistle Court Nursing HomeCare Assistant at Thistle Court Nursing Home