# AMIT RAJ SINHA - Data Analytics and Business Intelligence Professional
Source: https://hello.cv/amitsinha
Gurugram

## Links
- LinkedIn | https://linkedin.com/in/amit-raj-sinha
- GitHub | https://github.com/amitrajkval

## Education
### University Institute of Engineering and Technology, Panjab University Chandigarh | Electronics and Communication Engineering
7.25/10 CGPA | https://
### Kendriya Vidyalaya Aliganj Lucknow | Class 12 (CBSE)
93.2% | https://
### Kendriya Vidyalaya Aliganj Lucknow | Class 10 (CBSE)
92.6% | https://

## 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
### Data Analyst Intern - Data Strategy and Consulting Team | BharatPe
https://
Currently contributing to data strategy and consulting, analyzing large datasets to inform lending and POS device performance and develop actionable business insights.
- 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.
### Analytics Intern - UAE's BI Team and India's Procurement Team | CARS24
https://
Enhanced business intelligence and procurement processes by developing automated data solutions and improving reporting efficiencies for UAE and India teams.
- 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.
### Data Science Intern, Research and Development Team | Menthosa Solutions
https://
Contributed to aerospace research by developing data conversion tools, conducting exploratory data analysis, and applying machine learning models to improve drone metrics.
- 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
UIET | 2024-01-01
Led 90+ volunteers, coordinated placement efforts for over 600 students, and facilitated company collaborations.
### Amazon ML Summer School
Amazon | 2024-01-01
Selected among 80,000+ applicants for an advanced machine learning program.
### Google Cloud GenAI Hackathon - 4th Place
Google Cloud | 2024-01-01
Achieved 4th place nationally for innovation in generative AI solutions.
### Code with Cisco Hackathon Awardee
Cisco | 2024-01-01
Cleared national-level hackathon, awarded Pre-Placement Interview (PPI).
### Treasurer, IEEE UIET SB
IEEE UIET SB | 2023-01-01
Managed annual finances and served as PR & Marketing Head for the student branch.
### INSPIRE-MANAK Award
Government of India (INSPIRE-MANAK) | 2018-01-01
Recognized as Regional topper and National finalist for science innovation.

## Languages
- English

## Skills
### Programming Languages
Proficient
- Python
- SQL
- DAX
### Data Processing & ETL
Proficient
- Pandas
- NumPy
- BeautifulSoup
- Selenium
- Requests
- ETL Pipelines
- Data Preprocessing
- Data Cleaning
- Data Standardization
- Web Scraping
- API Parsing
- Workflow Automation
### Databases & Cloud Platforms
Proficient
- Snowflake
- MySQL
- BigQuery
- Google Cloud Platform (GCP)
- GCS
- PostgreSQL
### Data Visualization & BI Tools
Proficient
- Excel
- Tableau
- Power BI
- Google Sheets (App Script)
- Matplotlib
- Seaborn
- Streamlit
### Machine Learning
Proficient
- Scikit-learn
- Regression Models
- Classification Models
- Feature Selection
- Hyperparameter Tuning
- ML Models
### Other Tools & Methodologies
Proficient
- Cron
- Funnel Tracking
- KPI Tracking
- Generative AI Solutions

## Projects
### Credit Card Dashboard
https://
Developed a financial dashboard using Power BI, SQL, and DAX to track key performance indicators and analyze user behavior patterns.
### Heart Disease Prediction
https://
Developed and optimized machine learning models in Python using Scikit-learn to classify patient risk based on clinical indicators.
### Netflix Data Analysis
https://
Conducted in-depth data analysis using SQL and PostgreSQL to uncover user trends, genre preferences, and viewing habits.

## Source
Read this profile on Hello.cv: https://hello.cv/amitsinha
Create your free profile at https://hello.cv