Hi, I'm Ilakkiyan A V

Data Analyst & Business Intelligence Specialist

Turning raw data into reliable insights using Power BI, SQL, Python, AI workflows, and optimized reporting systems to drive data-driven decisions.

View Projects Get In Touch Download Resume
Ilakkiyan A V - Data Analyst
5+ Years Experience
6 Cloud Certifications
95% SLA Achievement
30% Efficiency Boost

About Me

Data-driven professional with a passion for analytics and optimization

I'm a Senior Operations Analyst at DXC Technology with over 5 years of experience transforming complex data into actionable business insights. Currently pursuing an MBA in Business Analytics from Anna University, I combine technical expertise with business acumen to deliver impactful solutions.

My expertise spans Power BI dashboard development, SQL database optimization, Python automation, and cloud technologies (AWS & Oracle Cloud). I've led teams to achieve 95% incident resolution within SLA while maintaining 99.9% system uptime.

I'm passionate about leveraging data analytics and AI technologies to solve business challenges. With 6 professional certifications including Oracle AI Practitioner, AWS Cloud Practitioner, and specialized credentials in Data Science and Generative AI, I stay at the forefront of emerging technologies.

  • Problem Solver: Led optimization projects reducing system downtime by 20% and improving report effectiveness by 30%
  • Team Leader: Managed a team of 8, achieving operational excellence and mentoring colleagues in soft skills development
  • Performance Focused: Enhanced data processing speed by 25% through Python automation and optimized SQL queries
  • Business Impact: Created BI dashboards that reduced data-related expenses by 20% and projected 7% revenue increase
  • Cloud & AI Expertise: Certified in AWS, Oracle Cloud, AI, and Generative AI technologies

Contact Information

📧 Email: ilakkiyanilakks@gmail.com
📱 Phone: +91 9442640087
📍 Location: Chennai, Tamil Nadu, India

Skills & Expertise

Technical proficiencies and core competencies

📊 Analytical Tools

Power BI Advanced Excel DAX Studio Data Visualization Business Intelligence

đŸ’ģ Programming Languages

SQL Python Python Pandas PHP

🗄ī¸ Databases

MySQL AS400 Database Optimization Query Performance

☁ī¸ Cloud & DevOps

AWS CloudFront AWS S3 Oracle Cloud System Monitoring

🤖 AI & Emerging Tech

Artificial Intelligence Generative AI Data Science AI Workflows

đŸŽ¯ Soft Skills

Team Leadership Project Management Mentoring Problem Solving Communication

Featured Projects

Data analytics solutions delivering measurable business impact

📊

Business 360 Dashboard

Comprehensive Power BI dashboard integrating sales data from multiple sources (Excel/CSV and SQL databases). Optimized using DAX Studio to achieve 5% performance improvement and 20% reduction in data-related expenses. Provides 360-degree business insights for both brick-and-mortar and e-commerce operations.

Power BI SQL Excel DAX Studio
Live Demo GitHub Repo
📈

Sales Insights Dashboard

Designed an advanced Excel-based analytics report to analyze AtliQ Hardware's 4-year sales trends and performance metrics. Identified key growth opportunities and strategic recommendations projected to increase revenue by at least 7% in the following quarter through data-driven insights.

Excel SQL Data Analysis Business Intelligence
View Report GitHub Repo
🔄

Report Migration & Optimization

Led the migration of legacy reports to Power BI platform at DXC Technology. Performed comprehensive data validation and manual testing to ensure accuracy. Achieved 30% improvement in report effectiveness and enhanced user accessibility through modern visualization techniques.

Power BI Data Migration Testing Validation
Case Study Documentation
⚡

AS400 System Optimization

Spearheaded optimization initiative for AS400 legacy system, implementing performance enhancements and monitoring solutions. Reduced system downtimes by 20% and maintained 99.9% uptime through proactive incident management and continuous system health monitoring.

AS400 System Administration Performance Tuning Monitoring
Details Metrics

Professional Experience

Career journey and key accomplishments

Senior Operations Analyst

DXC Technology

📅 Oct 2021 - Present | Chennai, India
  • Performed comprehensive data validation and manual testing during report migration to Power BI, resulting in 30% improvement in report effectiveness and enhanced decision-making capabilities
  • Spearheaded optimization of AS400 legacy system, implementing performance enhancements that reduced system downtimes by 20% and improved operational reliability
  • Led and mentored a team of 8 analysts in day-to-day operational activities, achieving 95% incident resolution within SLA and maintaining high team productivity
  • Introduced intelligent automation solutions that enhanced scheduling efficiency by 15%, streamlining workflows and reducing manual intervention
  • Sustained 99.9% system uptime through proactive monitoring, rapid incident response, and implementation of preventive maintenance strategies
  • Received Champs Award for exemplary performance and outstanding contributions to operational excellence

Software Developer

ECBEE Innovations Pvt. Ltd

📅 Nov 2020 - Sep 2021 | Chennai, India
  • Improved data processing workflows using Python Pandas library, achieving 25% increase in processing speed and handling larger datasets efficiently
  • Enhanced image load time by 40% through implementation of AWS CloudFront CDN and S3 optimization, significantly improving user experience
  • Optimized SQL queries and PHP backend code, resulting in 15% performance improvement across application endpoints
  • Collaborated with cross-functional teams to deliver scalable cloud-based solutions using AWS services
  • Participated in code reviews and contributed to best practices for data handling and application performance

Education

Academic background and qualifications

M.B.A., Business Analytics

Anna University, Chennai

📅 Jun 2024 - Dec 2026 (Ongoing)

Currently pursuing Master of Business Administration with specialization in Business Analytics. Focusing on advanced analytics techniques, business intelligence strategies, data-driven decision making, and strategic management. Combining technical data skills with business acumen to drive organizational success.

B.A., Public Administration

Annamalai University, Chidambaram

📅 Graduated Apr 2021

Completed Bachelor of Arts degree with a strong foundation in organizational management, policy analysis, and administrative processes. Developed critical thinking and analytical skills applicable to data-driven decision making in business environments.

B.E., Mechanical Engineering

S.K.P Institute of Technology (Anna University Affiliated)

📅 Graduated Jun 2015

Bachelor of Engineering in Mechanical Engineering from institution affiliated to Anna University, Chennai. Built strong analytical and problem-solving foundation with emphasis on systems thinking, optimization, and technical documentation.

Certifications & Achievements

Professional credentials and recognition

☁ī¸

Oracle Cloud Infrastructure Certified

Oracle Certified Cloud Practitioner

🤖

Oracle AI Certified Practitioner

Oracle Certified AI Practitioner

✨

Generative AI Professional

Oracle Certified Generative AI Professional

📊

Data Science Professional

Oracle Certified Data Science Professional

🌩ī¸

AWS AI Practitioner

AWS Certified AI Practitioner

☁ī¸

AWS Cloud Practitioner

AWS Certified Cloud Practitioner

🏆

Champs Award Winner

Exemplary Performance at DXC Technology

đŸ‘Ĩ

Team Leadership

Managed team of 8 with 95% SLA achievement

🎓

Soft Skills Mentor

Coached community members in professional development

Get In Touch

Let's discuss how I can help drive your data initiatives

Let's Connect

I'm always open to discussing new projects, creative ideas, or opportunities to be part of your vision. Whether you're looking for a data analyst, need consulting on BI solutions, or want to collaborate on innovative projects, feel free to reach out!

📧 Email: ilakkiyanilakks@gmail.com
📱 Phone: +91 9442640087
📍 Location: Chennai, Tamil Nadu, India