Rohit Raj

Data Analyst

Bengaluru, Karnataka, India1 yr 9 mos experience

Key Highlights

Expert in SQL and Power BI for data-driven insights.
Automated ETL processes enhancing data reliability.
Strong analytical skills with hands-on Python experience.

Stackforce AI infers this person is a Data Analyst with expertise in Business Intelligence and Data Engineering.

Contact

rohitraj.analyst@gmail.com LinkedIn

Skills

Core Skills

SqlPower BiEtl Pipelines

Other Skills

Microsoft Power BIPythonData AnalysisMicrosoft ExcelData VisualizationMicrosoft Power QueryDAXData CleaningData ModelingExploratory Data AnalysisGitTableauBusiness Intelligence (BI)Microsoft AzureITIL Certified

About

🚀 Data Analyst | SQL • Python • Power BI | IIT Patna MCA Candidate I turn raw, messy data into clear business decisions. With around 2 years of experience working with global organisations like EssilorLuxottica, I specialise in building automated ETL pipelines, interactive dashboards, and data-driven reports that help teams move faster and smarter. What I bring to the table: 🔹 SQL — complex queries, CTEs, window functions, data extraction 🔹 Python — Pandas, NumPy, Matplotlib, Seaborn for EDA and automation 🔹 Power BI — DAX, Power Query, KPI dashboards and sales reporting 🔹 Excel — PivotTables, VLOOKUP, Macros for business reporting 🔹 ETL Pipelines — end-to-end data cleaning and transformation Currently: 📌 Working as a Data Analyst at AuroPro Soft Systems (Client — EssilorLuxottica), Bengaluru 📌 Pursuing MCA from IIT Patna — expanding into Data Engineering, Cloud (Azure), and AI/ML Certifications: ✅ ITIL® 4 Foundation — PeopleCert ✅ Career Essentials in Data Analysis — Microsoft & LinkedIn ✅ Data Analytics Essentials — Cisco Networking Academy ✅ Data Science with Python — Infosys Springboard Open to: Data Analyst | Business Analyst | Data Engineer roles — Gurugram | Delhi | Noida | Pan India | Remote 📩 Let's connect — rohitraj.analyst@gmail.com

Experience

Auropro soft systems

2 roles

Data Analyst

Jul 2024 – Present · 1 yr 9 mos · Bengaluru, Karnataka, India · On-site

▸ Wrote and optimised complex SQL queries using joins, CTEs, and window functions to extract and
prepare customer and sales data for business reporting.
▸ Built and maintained interactive Power BI dashboards tracking key sales and customer metrics,
enabling faster and more informed decision-making.
▸ Automated ETL pipelines using Python (Pandas) to streamline data cleaning and transformation,
improving data reliability for downstream reporting.
▸ Performed exploratory data analysis using Python (Matplotlib, Seaborn) to identify trends in
customer and revenue data.
▸ Prepared and presented structured daily and weekly reports to stakeholders, translating complex
data into clear, actionable insights.

SQLMicrosoft Power BIPythonETL PipelinesData AnalysisPower BI

Intern

May 2024 – Jul 2024 · 2 mos · Bengaluru, Karnataka, India · On-site

▸ Extracted and cleaned raw sales and customer datasets using SQL and built Excel reports using
PivotTables and VLOOKUP to support senior analysts.
▸ Gained hands-on experience in data storytelling and business reporting through multiple projects
aligned with client goals.

SQLMicrosoft Excel