Pravinkumar Raja

Software Developer – Marlecha Interiors Pvt Ltd (MIPL Group)

📍 Chennai, India | Jan 2023 – Present

Key Contributions & Achievements:

Designed and implemented Google Workspace-based automation systems using Google Apps Script, Looker Studio, and Sheets, replacing manual Excel operations across multiple departments.

Reduced manual effort by 80% and increased productivity by 90% through end-to-end workflow automation.

Built department-specific automation tools (Sales, Procurement, Tendering, HR, and Finance).

Major Projects:

Sales Team Tracking System:
Integrated data from various CRM sources into a unified dashboard. Provided live team performance and KPI insights with automated daily WhatsApp and email summaries.

Tender & BOQ Automation:
Automated tender document generation and BOQ comparison using Google Sheets + Apps Script, saving hours of manual consolidation.

Procurement & ERP Billing:
Created a smart billing workflow with vendor comparison, GRN tracking, and purchase order automation — reducing approval time and improving transparency.

Geo-Fence Attendance & Material Tracking:
Developed mobile-friendly Apps Script web apps for site teams with GPS-based attendance, material entry logs, and auto-generated daily reports.

MD Dashboard & Live Reporting:
Delivered executive dashboards with live data visualization using Looker Studio and real-time Google Sheets backend updates.

Performance Evaluation (KPI/KRA):
Automated team and individual performance scorecards using Apps Script to calculate and deliver monthly reports automatically.

Tech Stack:
Google Apps Script | JavaScript (ES6+) | Looker Studio | Google Sheets | Gmail API | Forms | Drive API | REST API Integration | HTML | CSS

Community Support Representative – Uber India

📍 Chennai, India | 2019 – 2021

Handled support and communication between drivers and operations, resolving workflow issues through structured data handling.

Created internal spreadsheet automations to improve task efficiency and report turnaround times.

Built a strong foundation in data analytics, communication, and customer satisfaction processes.

Bachelor of Engineering – Mechanical Engineering
Anna University, Tamil Nadu
📅 Graduated: 2018

Developed strong analytical and problem-solving skills.

Applied engineering principles to real-world problem solving, later adapting them to process automation and software solutions.

Capstone project focused on efficiency improvement and data-driven system optimization.

🧾 Professional Certifications

1. Advanced Programming & Data Science (IIT Madras – GUVI Platform)
📅 May 2024 – November 2024

Specialized in Python, Machine Learning, Deep Learning, SQL, Data Visualization, and Statistics.

Completed a project on Loan Default Prediction (Finance domain) using machine learning and visualization.

Gained experience in Python libraries such as Pandas, NumPy, and Matplotlib.

2. Google Apps Script Developer Projects (Self-Learned & Industry Implementation)
📅 Ongoing – Practical Application at MIPL Group

Designed real-time automation workflows for Sales, Procurement, Tendering, and Project Tracking.

Hands-on experience integrating Google Workspace APIs, HTML/CSS UIs, and Looker Studio dashboards.

3. Web Development Fundamentals (Self-Taught)

Proficient in HTML, CSS, and JavaScript (ES6+) for front-end automation UI design.

Built internal dashboards and custom web interfaces for data entry and reporting.

4. Power BI & Data Visualization Certification (GUVI)

Gained practical knowledge in designing KPI dashboards and data visualizations.

Connected Power BI/Looker Studio with Google Sheets and Apps Script-based data pipelines.