Nikhil Gupta
Specialized in Data Engineering with a proven track record in designing, developing, and optimizing end-to-end data pipelines. Proficient in Apache Spark, Python, PySpark, SQL, NoSQL, and various AWS cloud services. Experienced in project management tools, Agile methodologies, and fostering collaborative team environments.
- Role
Data Science & Analytics - Databricks Engineer
- Years of Experience
4.30 years
Skillsets
- Mongo DB
- Delta Lake
- Cypher
- SparkSQL
- Seaborn
- pytest
- PySpark
- Postgre SQL
- pandas
- NumPy
- Neo4j
- MySQL
- AWS - 4.3 Years
- GraphQL
- GCP
- Core Java
- Boto3
- S3 - 4 Years
- dbt - 2 Years
- Snowflake - 4 Years
- Oop
- NO SQL - 4 Years
- SQL - 4 Years
- Python - 4.3 Years
Professional Summary
4.30Years
- Feb, 2023 - Present3 yr 2 months
Senior Data Engineer
FranConnect - Mar, 2022 - Feb, 2023 11 months
Data Engineer
FranConnect - Jul, 2020 - Mar, 20221 yr 8 months
Programmer Analyst
Cognizant
Applications & Tools Known
Jira
Confluence
Git
Bitbucket
Redshift
Glue
CloudWatch
S3
Lambda
Step Functions
MySQL
AWS Redshift
MongoDB
Snowflake
DynamoDB
EC2
Athena
GitHub
VS Code
BitBucket
.png)
Jenkins
Sonar
.png)
Docker
Databricks
CICD
Redshift
Work History
4.30Years
Senior Data Engineer
FranConnectFeb, 2023 - Present3 yr 2 months
Engineered a dynamic Profit & Loss Finance Analytics dashboard using PySpark, ensuring real-time data accuracy across various databases.
Data Engineer
FranConnectMar, 2022 - Feb, 2023 11 months
Led end-to-end development of the Franchise Scorecard Reporting Dashboard, optimizing data processing efficiency.
Programmer Analyst
CognizantJul, 2020 - Mar, 20221 yr 8 months
Engineered and maintained a serverless data pipeline for Bayer A-Cyrus Convergence Healthcare on AWS cloud.
Achievements
- Pinnacle Award - The Rising Star, 2022
- CDE AIA (Artificial Intelligence and Analytics) Department Award: Emerging Talent, 2021
- Pinnacle Award - The Rising Star (2022)
- Emerging Talent (Department Award: CDE AIA (Artificial Intelligence and Analytics), 2021)
Major Projects
4Projects
Research Organization Registry Data Insights using Neo4j | Data Analytics
Written SQL scripts for ingesting the ROR dataset into Google BigQuery and for creating the required SQL views. Python code for data cleansing, querying and visualizing the SQL query outputs using Pandas, BigFrames, and Seaborn. Ingested and modeled the institute hierarchy from the ROR CSV dataset into labels, nodes, and relationships in the Neo4j database using Cypher Queries.
Profit And Loss Finance Dashboard
Feb, 2023 - Present3 yr 2 months
Engineered a dynamic Profit & Loss Finance Analytics dashboard using PySpark, ensuring real-time data accuracy across various databases.
Franchise Scorecard Dashboard
Mar, 2022 - Feb, 2023 11 months
Led end-to-end development of the Franchise Scorecard Reporting Dashboard, optimizing data processing efficiency.
Cyrus Conversion A (Healthcare Domain)
Jul, 2020 - Mar, 20221 yr 8 months
Engineered and maintained a serverless data pipeline for Bayer A-Cyrus Convergence Healthcare on AWS cloud.
Education
B.Tech (APE)
UPES, Dehradun (2016)12th
KVAMC, Lucknow (2014)B.Tech
University of Petroleum and Energy Studies (2020)
Certifications
Aws certified cloud practitioner (clf01)
Databricks developer essentials
Databricks developer foundations
Graph data modeling
Aws ccp