RAJEEV PAL
Data Analyst
North West
Summary
Analytical and detail-oriented Data Engineer with 5+ years of experience in designing and optimizing ETL pipelines, SQL development, and data automation. Skilled in Python (pandas, NumPy) for large-scale data transformation, web scraping, and workflow optimization, with proven success in reducing reporting turnaround by 60% through reusable scripts and automation. Experienced in managing SQL databases (MySQL, PostgreSQL, Snowflake) and building scalable solutions for market research and KPI tracking. Currently focused on Azure Data Engineering—leveraging Azure Data Factory, Synapse Analytics, and Blob Storage to migrate on-premises workflows to cloud-native, cost-efficient architectures. Adept at integrating Python-based ETL with cloud pipelines and preparing data models to support advanced analytics and Power BI reporting.
Overview
8
8
years of professional experience
2
2
Languages
Work History
Data Analyst
NS Matrix Services Pvt Ltd
10.2019 - Current
- Designed and optimized complex SQL queries across MySQL, PostgreSQL, and Snowflake for ETL and reporting.
- Automated scheduled jobs and stored procedures, supporting high-volume data operations with minimal latency.
- Improved reporting efficiency by 60% through reusable SQL scripts for forecasting and KPI tracking.
- Built Python ETL pipelines using pandas & NumPy for data cleaning, schema enforcement, and anomaly detection.
- Automated reporting workflows by integrating Python with Excel and Power BI, reducing manual effort and turnaround time.
- Developed modular Python utilities for data validation and standardization across client deliverables.
- Engineered web scraping solutions (requests, BeautifulSoup, Selenium) to collect real-time data from 50+ public/private sources.
- Implemented scrapers for JavaScript-rendered content, authentication, and pagination, ensuring complete data capture.
- Structured and stored scraped datasets in SQL databases, enabling downstream analytics and BI dashboards.
- Currently migrating on-premises ETL workflows to Azure Data Factory pipelines with Blob Storage staging.
- Exploring integration of Python ETL scripts with ADF orchestration, enabling seamless monitoring and automation.
- Building POCs with Azure Synapse Analytics for advanced reporting and data warehouse integration.
Data Analyst
Collegedunia Web Private
09.2017 - 09.2019
- Designed and executed data collection workflows for competitor and market analysis, integrating data from multiple web sources and CMS platforms.
- Conducted user behavior analysis using Google Analytics and backend logs, providing insights to improve website engagement and conversion.
- Built and maintained SQL queries and Excel models for reporting, forecasting, and gap analysis across education domain datasets.
- Automated recurring research reports into structured dashboards (Excel/Power BI), cutting manual reporting time by 30%.
- Performed primary and secondary research to collect large datasets (e.g., U.S.).
- Performed primary and secondary research to collect large datasets (e.g., U.S. vehicle sales, competitor data), cleaning and structuring them for downstream analytics.
- Collaborated with product and marketing teams to translate research findings into actionable KPIs for decision-making.
Education
Master of Computer Applications - Computer And Information Systems
Guru Gobind Singh Indraprastha University
New Delhi, India 04.2001 -
Bachelor of Computer Applications - Computer And Information Systems
Bharti Vidyapeeth Deemed University
New Delhi, India 04.2001 -
Skills
- Python
- Web scrapping
- Selenium
- Scrapy
- Beautiful soup
- SQL
- Azure
- Data Automation
- Pandas
- Numpy
- Flask API
- CI/CD pipelines
- Data Transformation
- Agile Methodologies
- Team Lead
Timeline
Data Analyst
NS Matrix Services Pvt Ltd
10.2019 - Current
Data Analyst
Collegedunia Web Private
09.2017 - 09.2019
Master of Computer Applications - Computer And Information Systems
Guru Gobind Singh Indraprastha University
04.2001 -
Bachelor of Computer Applications - Computer And Information Systems
Bharti Vidyapeeth Deemed University
04.2001 -