NEERAJ KUMAR GUPTA
neeraj.gupta14111994@gmail.com | +91 9406722618 | LinkedIn
Summary
Data Analyst with 2.5 years of experience leveraging Azure Data Factory and SQL to design and build efficient on-premise ETL pipelines. Successfully migrated data preparation workflows from Azure Data Lake Prep to Power-BI, boosting data accessibility and streamlining analytics. Skilled in collaborating with cross-functional teams to deliver solutions, saving project costs by 20%. Seeking to utilize technical expertise in a challenging role to drive data-driven decision-making.
Skills
- Python
- Power-BI
- Metabase
- Azure Synapse Analytics
- Tableau
- SQL
- ETL
- Azure Data Factory
- Azure Data Lake
- Snowflake
- PLSQL
- Git
- GitHub
- Data Warehousing
Coursework
- Azure Data Engineer Specialization by Coursera - 2023
- Applied AI Course (June 2018 - June 2019)
Certification
- Azure DP-900
- Advanced SQL by Hackerrank
- Data Warehousing by Snowflake
Education
NATIONAL INSTITUTE OF TECHNOLOGY | ROURKELA
M-Tech | August 2019 - May 2021
Experience
RUPTUB SOLUTIONS PRIVATE LIMITED | Data Analyst | BI Developer | Analytics Engineer
November 2023 – Present | Bangalore, IN
- Implemented data pipeline, reducing data processing time by 25%.
- Reduced redundant activities of 8 departments by building Data Warehouse, Data modeling, and Data Ingestion activities.
- Optimized SQL queries by implementing indexing and query restructuring techniques, resulting in a 20% reduction in data retrieval time, enhancing overall system performance and user experience.
- Migrated data flows from Azure Blob Storage to BI, building a pipeline that reduced the manual data visualization process by 60%.
SHRI MAHAVIR FERRO ALLOYS PRIVATE LIMITED | Data Analyst | BI Developer
February 2023 – November 2023 | Rourkela, IN
- Spearheaded and successfully delivered 3+ diverse projects in collaboration with the chief consultant (PWC Team), surpassing set targets and driving an impressive 15% increase in production rates.
- Achieved a 25% reduction in unplanned plant halt time by introducing insightful KPIs and developing a Power BI dashboard to monitor equipment performance.
- Improved data extraction and cleaning efficiency by 40% by leveraging SQL, Excel, BI DAX, and Python for comprehensive analysis.
- Spearheaded the design and execution of a scalable data ingestion pipeline, increasing data throughput by 75% and enabling seamless integration of diverse data sources.
- Improved team efficiency by 50% by leading a cross-functional team of 5 across regions to identify and resolve productivity hurdles with data-driven solutions.
TUTORT ACADEMY | Data Analyst
June 2022 – December 2022 | Bangalore, IN
- Generated and maintained regular HR Excel reports and BI dashboards to track employee KPIs.
- Leveraged data-driven insights to identify and target prospective candidates with the highest potential for course enrollments, increasing CTA’s by 32%.
- Collected and analyzed onboarding feedback and suggested satisfactory actions.