FRANKLIN XAVIER A

Software Engineer & Data Analyst
Bangalore, IN.

About

Highly motivated Software Engineer with 7+ months of full-stack web development and data analytics expertise, adept at building robust applications and driving data-driven insights. Proficient in React.js, Node.js, PHP, AWS, MySQL, and ETL pipeline development, I excel at leveraging Power BI and Tableau for impactful data visualization. Seeking to apply Agile methodologies and technical proficiency to deliver high-quality software solutions and contribute to innovative projects.

Work

Aloft Labs AI Technologies Pvt Ltd
|

Software Engineer

Bangalore, Karnataka, India

Summary

As a Software Engineer, I led the development of a full-stack Productivity Management System (PMS), enhancing employee productivity and operational efficiency through comprehensive monitoring and data insights.

Highlights

Developed a comprehensive full-stack Productivity Management System (PMS) to monitor employee work hours, system usage, and productivity metrics, improving operational oversight.

Designed and implemented a responsive, interactive frontend UI using React.js, Ant Design, Tailwind CSS, and Bootstrap, significantly enhancing user experience and accessibility.

Engineered secure session-based authentication, auto-logout, and inactivity tracking features, bolstering system security and data integrity.

Built robust RESTful APIs in Node.js and PHP for user sessions, data retrieval, and time logging operations, ensuring efficient data management.

Integrated and optimized a MySQL database for storing employee data, shift hours, logs, and performance metrics, ensuring data integrity and accessibility.

Deployed and maintained backend infrastructure on AWS EC2, ensuring high availability and performance for critical system operations.

Developed efficient ETL pipelines for data aggregation and transformation, enabling comprehensive analytics and reporting functionalities.

Utilized Jira for agile task management, sprint planning, and issue tracking, streamlining development workflows and improving project delivery.

Besant Technologies
|

Data Analyst Intern

Bangalore, Karnataka, India

Summary

As a Data Analyst Intern, I designed and developed a comprehensive e-commerce sales dashboard using Power BI Desktop, providing critical business insights and improving data-driven decision-making.

Highlights

Designed and developed an interactive e-commerce sales dashboard using Power BI Desktop, enabling real-time data visualization and analysis.

Analyzed key sales metrics, including Total Sales ($438K), Quantity Sold (5,615 units), Profit ($37K), and Average Order Value ($121K), to identify critical business performance indicators and trends.

Conducted in-depth trend analysis, showcasing monthly and quarterly performance patterns to inform strategic planning and resource allocation.

Identified 'Clothing' as the dominant product category, contributing 63% of total quantity sold, directly guiding inventory and marketing strategies.

Analyzed diverse payment preferences: COD (44%), UPI (21%), Credit Card (12%), and EMI (10%), optimizing payment gateway strategies.

Provided geographical insights, highlighting top-performing states (Maharashtra, Madhya Pradesh, Uttar Pradesh, Delhi, Rajasthan) to inform regional marketing efforts and expansion strategies.

Implemented custom filters for quarterly and yearly performance analysis, enhancing reporting flexibility and depth for stakeholders.

Integrated sales data from multiple sources, ensuring a comprehensive and unified view for reporting and decision-making.

Education

Loyola College
Chennai, Tamil Nadu, India

Bachelor

Computer Application

Grade: 8.9/10 CGPA

National Matriculation Higher Secondary School
Chennai, Tamil Nadu, India

Higher Secondary Certification

Secondary Education

Languages

English
Tamil
Hindi
Kannada

Certificates

Data Analyst

Issued By

BDZ

Python

Issued By

BDZ

Django

Issued By

BDZ

Skills

Frontend Technologies

HTML, CSS, JavaScript, TypeScript, React.js, Redux.js, Next.js, Angular.js, Tailwind CSS, Bootstrap, Ant Design, WordPress.

Backend Technologies

Node.js, Express.js, PHP, Python, C++.

Databases

MySQL, SQL, MongoDB.

Data & Analytics

Power BI, Tableau, ETL, Data Visualization, DAX, VBA, Statistics.

Cloud & DevOps

AWS, EC2, CI/CD Pipelines, Git, GitHub, GitLab.

Tools & Platforms

Jira, ServiceNow, ChatGPT, Claude, Gemini, Grok, DeepSeek.