Rajat Nimje | Automation and Data Analyst

Professional Summary

Fast-learning B.Tech Computer Engineering graduate with strong hands-on skills in Python (Pandas, NumPy), SQL, advanced Excel, and data automation workflows. Experienced in building dashboards, writing optimized queries, processing data via APIs, and automating reporting pipelines using tools like n8n and Gemini LLM. Eager to contribute to an Automation Team by building dashboards, maintaining data workflows, and delivering accurate, insight-driven reports.

Technical Skills

SQL

Complex Queries Joins Aggregations Subqueries Validation

Python

Pandas NumPy Matplotlib Automation Regex

Excel

Pivot Tables INDEX/MATCH VLOOKUP/XLOOKUP Dashboards Report Automation

BI and Dashboards

Power BI Tableau Superset Concepts SQL-backed Charts

APIs and Automation

REST API n8n ETL Pipelines Data Fetching

Tools

Git GitHub Gemini LLM

Projects

E-Commerce Customer Behavior and Shopping Trends Analysis

Python Pandas SQL Excel Power BI

Wrote optimized SQL queries to extract and aggregate 3900+ transaction records; applied data cleaning including null handling, deduplication, and anomaly detection.
Built interactive dashboards in Power BI and advanced Excel reports with Pivot Tables, XLOOKUP, and dynamic formulas to track revenue, seasonal trends, and demographic KPIs.
Automated a data transformation pipeline in Python and Pandas to process and load data, eliminating manual refresh steps and ensuring consistent, accurate reporting.
Structured outputs as reusable datasets suitable for Apache Superset-style SQL-backed visualization layers.

Statistical Profiling of Global Book Sales

Python Pandas NumPy Excel

Designed a data processing and automation workflow; cleaned, standardized, and validated records using vectorized Pandas operations and regex normalization.
Built Excel dashboards with complex formulas including INDEX/MATCH, IF nesting, and Pivot Tables for publisher performance ranking and unit-sales distribution analysis.
Produced governance-ready summary tables enabling reproducible reporting and fast dashboard refresh without manual intervention.

AI-Powered WhatsApp Automation for Restaurant Order Management

n8n Gemini LLM REST API

Integrated REST APIs including the WhatsApp Business API and Gemini LLM endpoint via n8n to fetch, process, and route real-time customer data.
Built end-to-end automation workflows to capture unstructured inputs, transform them into structured records, and trigger automated responses with zero manual handling.
Designed monitoring logic to track data accuracy and workflow consistency across live automation cycles.

Education

B.Tech in Computer Engineering

Smt. Radhikatai Pandav College of Engineering, Nagpur

2021 - 2025

Higher Secondary Education (Class XII)

Shri Ramswami Junior College, Nagpur

2020 - 2021

Secondary Education (Class X)

New English High School, Nagpur

2018 - 2019

Certifications and Additional

Cloud Computing

NPTEL · 2025

Languages

Hindi English Marathi

Interests

Bike Riding Trekking