Alan Praveen Putty Francis Xavier
England,,United Kingdom
Summary
Analytical and detail-oriented Data Analyst with experience in SQL, Excel, and data reporting. Previously worked as a Senior Technical Engineer (2021–2023), building a strong technical foundation, followed by a Data Analyst Internship (Sep 2024 – May 2025) focused on data cleaning, analysis, and dashboard reporting. Strong problem-solving skills with the ability to translate data into actionable business insights.
Overview
4
4
years of professional experience
Work history
Data analyst intern
Adison Infotech
Ilford, United Kingdom
09.2024 - 05.2025
- Engineered SQL and Python (Pandas, NumPy) scripts to extract and categorize high-volume datasets, ensuring 100% accurate routing of records into functional workstreams.
- Developed interactive Power BI dashboards to visualize key performance metrics, including unit retention and escalation rates, improving stakeholder visibility into operational lifecycles.
- Performed duration-based analysis in Excel to identify system bottlenecks, contributing to a measurable improvement in processing trends and resource allocation.
- Enhanced data integrity by implementing automated cleansing scripts, reducing manual data entry errors and streamlining organization-wide reporting.
Senior technical support engineer
Tech Mahindra
Chennai, Tamil Nadu, India
01.2022 - 07.2023
- Subject Matter Expert (SME) for Telstra Telecommunications (Australia): Provided specialist technical guidance and acted as the primary point of contact for complex troubleshooting and network architecture reviews.
- Database & Query Optimization: Leveraged SQL to manage large-scale datasets, ensuring high-performing data retrieval and system stability for telecommunications applications.
- Lead Solution Design: Spearheaded the end-to-end design and development of scalable technical solutions, ensuring full alignment with Telstra’s global security and compliance standards.
- Leadership & Mentoring: Directed a team of junior engineers, conducting regular code and design reviews to maintain high-quality engineering standards and foster professional growth.
- Process Automation: Utilized SQL scripting and automation techniques to enhance daily operational efficiency and reduce manual data processing time.
Technical support engineer
Tech Mahindra
Chennai, India
07.2021 - 01.2022
- System Development: Contributed to the development of secure and high-performing technical solutions for large-scale telecommunications infrastructure.
- Data Validation: Used SQL to perform root-cause analysis on system-level issues, ensuring data accuracy and minimizing service downtime.
- Quality Assurance: Executed comprehensive testing and design validation to ensure all technical deliverables met industry best practices and client-specific requirements.
Education
Master of Science - Data Science
University of Hertfordshire
Hatfield 09/2023 - 12/2025
Bachelor of Engineering - Computer Science Engineering
Anna University
Chennai, India 06/2016 - 11/2020
Skills
- Strategic planning
- Innovative problem structuring
- Communication proficiency
- Decision-Making confidence
Languages
English
Fluent
Telugu
Native
Tamil
Fluent
Technologies
Data Analysis & Business Intelligence Tools:
• Advanced Microsoft Excel
• SQL
• Power BI
• Tableau
Databases & Warehousing
· SQL server
· Oracle
· MySQL
Programming languages:
· Python
· R
Timeline
Data analyst intern
Adison Infotech
09.2024 - 05.2025
Senior technical support engineer
Tech Mahindra
01.2022 - 07.2023
Technical support engineer
Tech Mahindra
07.2021 - 01.2022
Master of Science - Data Science
University of Hertfordshire
09/2023 - 12/2025
Bachelor of Engineering - Computer Science Engineering
Anna University
06/2016 - 11/2020