Ajay Jayaseelan
Hounslow,City of London
Overview
4
4
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work history
Senior data analyst
Ternary Technology Ltd
Reading, England
06.2021 - Current
- Contracted as Data Analyst, delivering comprehensive data reporting, analysis, and DBMS maintenance for diverse clients across various industries.
- Hands-on experience with Azure, with Azure Data Lake and Azure Synapse, to manage, analyze, and store large volumes of data efficiently within cloud environments. Developed and maintained interactive dashboards using tools like Power BI, Tableau, and AWS QuickSight to deliver actionable business insights. Increased dashboard efficiency for large datasets by implementing data pre-aggregation techniques
- Proficient in SQL for creating stored procedures, designing database tables, and automating data workflows to improve reporting efficiency and accuracy.
- Developed and maintained interactive dashboards using tools like Power BI, Tableau, AWS Quick Sight to deliver actionable business insights.
- Increased dashboards data efficiency even with large datasets by pre-aggregating datasets before processing to dashboards.
- Specialized in finance KPIs like margin, cost and revenue models.
- Managed ETL processes, ensuring efficient data extraction, transformation, and loading into cloud environments.
- Applied Data Analysis and Machine Learning to identify, analyze, and interpret patterns in complex data sets of 1M+ rows.
- Provided cloud maintenance solutions, focusing on data migration, optimization, and cost-effective storage strategies. Offering Cost savings in cloud up-to 40%.
- Integrated AI and ML technologies to enhance data-driven decision-making, predictive analysis, and process automation for clients.
- Proficient in Python for including scripting, automation, and data manipulation. (SQL Alchemy)
- Deployed Python-based data pipelines in AWS (Lambda, Glue).
- Collaborated with client companies on project basis, ensuring high-quality data solutions aligned with business objectives.
Senior data analyst
LycaMobile (Extended Contract)
Canary Wharf, Tower Hamlets
03.2023 - 05.2024
- Part of a team in migration of on-premises live and historical data (Over 200 TBs) to AWS cloud environment, utilizing AWS Redshift for data warehousing.
- Worked under Agile environment methodology with GIT for Source control and code maintenance.
- Post-migration, managed ETL processes in AWS Glue, ensuring smooth data transformation, loading, and pipeline maintenance.
- Worked under reporting team which involves developing 23-countries margin reportswhich involves large datasets extracting data for business stakeholder needs and ad-hoc requirements.
- Developed and optimized dashboards using AWS Quick Sight, Power-BI dashboards with more efficiency and delivering key insights and reports (e.g.,Financial margin and cost analysis) to business stakeholders with 20+ key metrics for enhanced decision making over 45% in business operations.
- Worked under Data Engineer Team which involved automating and orchestrated procedures workflows using AWS Step Functions, improving process efficiency across data pipelines and organizational reporting.
- Enhanced Data lake by integrating multiple data sources, focusing on cost-effective data ingestion and high-performance reporting solutions.
- Continuously optimized dashboards and ETL processes for improved performance and reduced costs in cloud-based environment.
Junior data analyst
BetterMocks
Chennai, India
10.2020 - 03.2021
- Analyzed datasets to generate insightful reports for clients and business stakeholders.
- Collaborated with teams to understand reporting needs and deliver tailored insights.
- Ensured data accuracy and integrity through thorough data cleaning and validation processes.
- Created written reports summarizing analysis findings and recommended actions.
- Presented analytical results to stakeholders, clearly communicating complex information.
- Reconciled reports and corrected many reports with advanced Excel and SQL proficiency.
Lab Assistant
Networkers Home
Bangalore, India
07.2020 - 08.2020
- Assisted in setup and maintenance of lab environments for CCNA training sessions.
- Supported instructors by preparing lab exercises and ensuring all equipment was operational.
- Helped students with hands-on practice in configuring routers and switches.
- Provided troubleshooting assistance for network configurations and issues encountered during labs.
- Documented lab procedures and created instructional materials to enhance learning experience.
Education
B.E - Electronics and Instrumentation
Prist University
India 04.2016 - 04.2020
Skills
- SQL
- Azure Data Lake
- AWS Quick Sight, Power-BI
- Git
- Python
- AWS Glue
- Redshift
- Step Functions
- Procedure
- Database management
- Data pipeline construction, Data Migration
Certification
- AWS Certified Data Engineer - https://www.credly.com/badges/562b9aea-a707-41e9-8e8d-d1d06431f800/public_url
- AWS Certified Cloud Practitioner - https://www.credly.com/badges/95252419-0985-464e-b324-51a0a4a11f45
- Advanced SQL - https://www.hackerrank.com/certificates/9b4007a77db5
-
Highly skilled Data Analyst with more than 3 years of advanced SQL expertise and proven experience in developing dynamic dashboards using Power BI and AWS Quicksight.
Adept at leveraging AWS cloud platforms and Azure for data storage, processing, and analytics. Known for automating complex workflows, optimizing data pipelines, and delivering actionable insights to drive business performance. Strong collaborator with a focus on enhancing data processes to meet evolving business needs.
Accolades & Extracurricular
- Winner of University Competition in Electrical Components Technology, recognized for innovative design and practical application of electrical systems
- Represented my State,University in Basketball
- Runner-up in the University Startup Pitch Competition for creating a smart-home automation system prototype
Timeline
Senior data analyst
LycaMobile (Extended Contract)
03.2023 - 05.2024
Senior data analyst
Ternary Technology Ltd
06.2021 - Current
Junior data analyst
BetterMocks
10.2020 - 03.2021
Lab Assistant
Networkers Home
07.2020 - 08.2020
B.E - Electronics and Instrumentation
Prist University
04.2016 - 04.2020
Similar Profiles
Nattakrit PreechavithNattakrit Preechavith
Cafe Manager and Barista at Ternary Tuckshop/SUM of US CafeCafe Manager and Barista at Ternary Tuckshop/SUM of US Cafe
Akibul HoqueAkibul Hoque
Food And Beverage Assistant at Novotel Hotels (The Ternary)Food And Beverage Assistant at Novotel Hotels (The Ternary)
Henk VolschenkHenk Volschenk
Training Supervisor at Cape Peninsula University of Technology (CPUT), South African Renewable Energy Technology Centre (SARETEC)Training Supervisor at Cape Peninsula University of Technology (CPUT), South African Renewable Energy Technology Centre (SARETEC)
Akkhila PenmetsaAkkhila Penmetsa
Quality assurance technician at Cranswick -Katsouris Brothers ltdQuality assurance technician at Cranswick -Katsouris Brothers ltd
Puru SharmaPuru Sharma
SLR TECHNOLOGIES at ASSISTANT IT ADMINISTRATORSLR TECHNOLOGIES at ASSISTANT IT ADMINISTRATOR