Swapnil Mule

Associate Partner

Pune, Maharashtra, India10 yrs 8 mos experience

Highly Stable

Key Highlights

Expert in data engineering and cloud computing.
Led projects reducing execution time and costs significantly.
Proficient in developing scalable data pipelines.

Stackforce AI infers this person is a Data Engineering expert in the Fintech industry with strong cloud computing capabilities.

Contact

Skills

Core Skills

Data EngineeringCloud ComputingData WarehousingPerformance TuningBusiness Intelligence

Other Skills

Adobe AnalyticsAnalyticsApache AirflowApache ImpalaApache KafkaApache SparkApache SqoopAxiomSLAzure Data FactoryAzure Data LakeAzure Synapse AnalyticsBatch ProcessingBig DataBig Data AnalyticsCommunication

About

● Around 9 of experience in IT having experience in Database Design, Development & Support of MS SQL Server 2014/2016. ● Proficient in Relational Database Management Systems (RDBMS). ● Expertise in T-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables. ● Experience in implementing business logic usingTriggers, Indexes, Views and Stored procedures. ● Experience with tools like SQL Server management studio (SSMS) and SQL Server integration (SSIS) and reporting services(SSRS). ● Proficient in Tuning T-SQL queries to improve the database performance and availability. ● Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. ● Expertise increating Packages using SQL Server Integration Services (SSIS) and Azure Data Factory. ● Expertise in data management by using Azure Databrisk, Azure Data Explorer and Power BI. ● Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Experience

10 yrs 8 mos

Total Experience

3 yrs

Average Tenure

1 yr 8 mos

Current Experience

Ubs

Associate Director

Oct 2024 – Present · 1 yr 8 mos · Pune, Maharashtra, India · Hybrid

Developed an event-driven DLT pipeline on the Databricks Lakehouse Platform to ingest Adobe Analytics data from UBS Financial Advisory’s website. Implemented custom logic to untar files, load data into the raw/bronze layer, and transform it into the silver layer using PySpark and Delta Lake tables.
Architected auto-scaling workflows triggered by cloud file arrival (e.g., Databricks Autoloader pattern), enabling real-time lead capture and contributing to ~$40M/month in Net New Wealth Management funds.
Engineered Databricks Workflows to ingest data from Microsoft Dynamics API for regulatory archiving, leveraging Delta Lake for audit compliance.

DatabricksAdobe AnalyticsPySparkDelta LakeData EngineeringCloud Computing

Bny mellon

2 roles

Lead Data Engineer

Feb 2023 – Oct 2024 · 1 yr 8 mos

Designed scalable pipeline which reduced the onboarding of new entity in datawarehouse efforts by 80% ;by parameterizing source table details, mapping and destination table details.
Developed the ETL using Azure Data Factory with metadata driven approach which loads data from multiple API to Snowflake.

Azure Data FactoryETLSnowflakeData EngineeringData Warehousing

Sr Data Engineer

Apr 2021 – Feb 2023 · 1 yr 10 mos

Led the 'Impala Migration Project' which results in a total reduction of 600 min of execution time and 25% in overall cost reduction.
Standardize schema and partitions of all the data sources (Parquet files) which results in less maintenance time.

ImpalaSchema StandardizationCost ReductionData EngineeringPerformance Tuning

Persistent systems

2 roles

Data Management Team Lead

Oct 2020 – Apr 2021 · 6 mos · On-site

Module Lead

Oct 2018 – Oct 2020 · 2 yrs · On-site

Implemented Hashing technique in all Slowly Changing Dimension (SCD) models which results in an average 8.5 min execution time reduction per 1 million records.

Bny mellon

Application Developer

Oct 2015 – Oct 2018 · 3 yrs · Pune/Pimpri-Chinchwad Area · On-site

Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).

SSRSSSISBusiness IntelligenceData Engineering