AMIT RAJ SINHA

Data Analytics and Business Intelligence Professional
Gurugram, IN.

Education

University Institute of Engineering and Technology, Panjab University Chandigarh
Chandigarh, India, India

B.E.

Electronics and Communication Engineering

Grade: 7.25/10 CGPA

Kendriya Vidyalaya Aliganj Lucknow
Lucknow, Uttar Pradesh, India

High School Diploma

Class 12 (CBSE)

Grade: 93.2%

Kendriya Vidyalaya Aliganj Lucknow
Lucknow, Uttar Pradesh, India

High School Diploma

Class 10 (CBSE)

Grade: 92.6%

About

Highly analytical Data Analytics and Business Intelligence professional with an engineering background, specializing in leveraging Python, SQL, and cloud platforms like GCP and Snowflake to transform complex datasets into actionable insights. Proven expertise in developing robust ETL pipelines, automating workflows, and building scalable data systems has consistently driven process efficiencies by up to 80% and improved reporting turnaround by 30%.

Work

BharatPe
|

Data Analyst Intern - Data Strategy and Consulting Team

Gurugram, Haryana, India

Summary

Currently contributing to data strategy and consulting, analyzing large datasets to inform lending and POS device performance and develop actionable business insights.

Highlights

Analyzed lending and POS device performance by querying and processing large datasets from BigQuery, delivering data-driven insights for strategic decision-making.

Developed Excel pivot-based reports and dashboards, translating complex data into actionable business intelligence.

CARS24
|

Analytics Intern - UAE's BI Team and India's Procurement Team

Gurugram, Haryana, India

Summary

Enhanced business intelligence and procurement processes by developing automated data solutions and improving reporting efficiencies for UAE and India teams.

Highlights

Developed and deployed a modular web scraping framework across 4 platforms using Selenium Wire and BeautifulSoup on GCP VM, reducing manual data collection effort by 80%.

Engineered Python-based data pipelines for extraction, standardization, and fuzzy matching to internal MMVY standards, achieving 90%+ mapping accuracy.

Optimized SQL queries and integrated datasets into Snowflake for funnel tracking and performance audits, improving reporting turnaround by 30%.

Automated Loan Application Form (LAF) workflows with Google Apps Script, enhancing sales data capture and reducing processing errors by 25%.

Created automated KPI dashboards and trackers using SQL, Tableau, and Google Sheets, improving data visibility and execution hygiene across 3 teams.

Collaborated with cross-functional UAE and India teams to centralize analytics pipelines and standardize reporting for procurement decision-making.

Menthosa Solutions
|

Data Science Intern, Research and Development Team

Chandigarh, India, India

Summary

Contributed to aerospace research by developing data conversion tools, conducting exploratory data analysis, and applying machine learning models to improve drone metrics.

Highlights

Developed a Streamlit application for drone log data conversion (.bin to .csv), streamlining preprocessing for aerospace research.

Conducted extensive EDA and feature extraction to identify critical parameters impacting drone flight stability.

Applied regression and classification models to improve prediction accuracy for drone metrics by 15%.

Awards

Corporate Relations Head, Placement Cell UIET

Awarded By

UIET

Led 90+ volunteers, coordinated placement efforts for over 600 students, and facilitated company collaborations.

Amazon ML Summer School

Awarded By

Amazon

Selected among 80,000+ applicants for an advanced machine learning program.

Google Cloud GenAI Hackathon - 4th Place

Awarded By

Google Cloud

Achieved 4th place nationally for innovation in generative AI solutions.

Code with Cisco Hackathon Awardee

Awarded By

Cisco

Cleared national-level hackathon, awarded Pre-Placement Interview (PPI).

Treasurer, IEEE UIET SB

Awarded By

IEEE UIET SB

Managed annual finances and served as PR & Marketing Head for the student branch.

INSPIRE-MANAK Award

Awarded By

Government of India (INSPIRE-MANAK)

Recognized as Regional topper and National finalist for science innovation.

Languages

English

Skills

Programming Languages

Python, SQL, DAX.

Data Processing & ETL

Pandas, NumPy, BeautifulSoup, Selenium, Requests, ETL Pipelines, Data Preprocessing, Data Cleaning, Data Standardization, Web Scraping, API Parsing, Workflow Automation.

Databases & Cloud Platforms

Snowflake, MySQL, BigQuery, Google Cloud Platform (GCP), GCS, PostgreSQL.

Data Visualization & BI Tools

Excel, Tableau, Power BI, Google Sheets (App Script), Matplotlib, Seaborn, Streamlit.

Machine Learning

Scikit-learn, Regression Models, Classification Models, Feature Selection, Hyperparameter Tuning, ML Models.

Other Tools & Methodologies

Cron, Funnel Tracking, KPI Tracking, Generative AI Solutions.

Projects

Credit Card Dashboard

Summary

Developed a financial dashboard using Power BI, SQL, and DAX to track key performance indicators and analyze user behavior patterns.

Heart Disease Prediction

Summary

Developed and optimized machine learning models in Python using Scikit-learn to classify patient risk based on clinical indicators.

Netflix Data Analysis

Summary

Conducted in-depth data analysis using SQL and PostgreSQL to uncover user trends, genre preferences, and viewing habits.