Pranay Singh

Project Manager

Gurugram, Haryana, India5 yrs 9 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

Expert in building scalable ETL/ELT pipelines.
Proven track record in data quality and compliance.
Strong experience in BI and dashboarding with Tableau.

Stackforce AI infers this person is a Data Engineer with expertise in Fintech and E-Commerce industries.

Contact

Skills

Core Skills

Data EngineeringEtl/elt PipelinesData QualityData VisualizationData ManagementData Science

Other Skills

AWSAWS GlueAirflowAmazon RedshiftAmazon S3Amazon Web Services (AWS)AnacondaAnalytical SkillsAnalytical SolutionsAnalyticsApache AirflowApache KafkaApache SparkAzure DatabricksBig Data

About

Results-driven Data Engineer with 5+ years of experience designing and delivering scalable, high-performance data pipelines across Banking, Fintech, and E-Commerce domains. I specialize in transforming raw data into actionable insights that support business growth, regulatory compliance, and data-driven decision-making. Key expertise includes building ETL/ELT pipelines, data lakes, and automated reporting. I'm passionate about optimizing data workflows and have a strong track record of improving efficiency, reducing costs, and ensuring data quality at scale. I also bring experience in BI and dashboarding using Tableau, enabling cross-functional teams to access clear, real-time analytics. Skills: Python, SQL, PySpark, AWS, Databricks, Snowflake, Oracle, Tableau

Experience

Pnb housing finance limited

Project Manager

Mar 2024 – Present · 2 yrs · Gurugram, Haryana, India · On-site

Built and maintained end-to-end data pipelines using Python, SQL, and AWS Glue to ingest and transform core banking data (loans and deposits) from Oracle into Amazon Redshift.
Automated regulatory reporting processes with Python, AWS, and Tableau—reducing manual efforts by 85% and improving compliance timelines.
Integrated Databricks workflows to perform large-scale data transformations and enhance performance tuning.
Reduced backup storage footprint from 12 GB to 4 GB by optimizing file generation and eliminating redundancy, significantly cutting costs.
Led data migration from production systems to reporting environments, ensuring high data accuracy and consistency for analytics use cases.

PythonSQLAWS GlueAmazon RedshiftTableauData Engineering+1

Paytm

Team Lead - Data Engineer

Aug 2023 – Mar 2024 · 7 mos · Noida, Uttar Pradesh, India · Hybrid

Designed and implemented scalable ETL pipelines to ingest and archive daily EMI default data (Bucket 1/2/3, NPA) into Amazon S3 for real-time tracking and historical backup.
Built dynamic Tableau dashboards to visualize key financial metrics including loan disbursements, installment dues, recovery performance, NPA monitoring, and P&L insights—enabling faster, data-driven decisions.
Led the end-to-end data migration from production to reporting databases using Python and SQL, significantly improving data accuracy, query performance, and reporting efficiency.

ETLAmazon S3TableauPythonSQLData Engineering+1

Cashify

Senior Data Engineer

Jan 2022 – Jul 2023 · 1 yr 6 mos · Gurugram, Haryana, India · On-site

Automated daily, weekly, and monthly MIS reports using SQL, Python, and Tableau, significantly accelerating business insights and improving decision-making timelines.
Developed and deployed a machine learning model to predict customer intent to sell devices, achieving 80% accuracy—empowering the Operations team to focus on high-intent leads.
Spearheaded data migration initiatives from production to reporting databases, ensuring data integrity, minimal downtime, and optimized performance for analytics workflows.

SQLPythonTableauMachine LearningData EngineeringData Science

Collabera inc.

Data Engineer

May 2021 – Dec 2021 · 7 mos · Pune, Maharashtra, India

Automated reporting workflows using Python, replacing manual Excel and Alteryx processes—eliminating dependency on Alteryx licenses and cutting operational costs.
Built and deployed data pipelines to securely transfer and back up critical datasets into Amazon S3, ensuring data availability and compliance with internal policies.

PythonAmazon S3Data Engineering

Traveltriangle

Data Engineer

Aug 2018 – Sep 2019 · 1 yr 1 mo · Delhi NCR

Promoted to Data Engineer for optimizing and streamlining ETL workflows, resulting in improved processing speed and reduced manual intervention.
Designed and developed MIS reports and interactive Tableau dashboards to monitor daily business KPIs such as lead generation, conversion rates, and pipeline status.

ETLTableauData Engineering