Swapnil Vaidya
Pune
Summary
Extensive experience in DW/BI area. Proficient in Dimensional Modeling, Data Management, DW Architecture and Data Quality Management. Experience in Architect End-to-End Data Warehouse solutions. Empanelled as SME in Teradata DWH in Barclays and helped to develop and implement DW/ETL standards, procedures and best practices.
Overview
16
16
years of professional experience
1
1
Certification
Work History
AVP (Corporate Data Services-DWH Team)
Barclays
Pune
06.2012 - Current
- Currently working at Barclays as AVP (Corporate Data Services-DWH Team)
- Developed data warehouse models, including dimensional modeling, star schemas and snowflake schemas.
- Analyzed business requirements to design data warehouse solutions.
- Implemented ETL processes to extract, transform and load data into the data warehouse environment.
- Maintained database performance by troubleshooting query problems and optimizing queries for better results.
- Collaborated with other IT teams such as Business Intelligence and Database Administration groups in order to implement best practices in developing a successful Data Warehouse solution.
- Created logical and physical data models, leveraging ERwin Data Modeler.
- Performed complex SQL queries to extract data from multiple sources for reporting purposes.
- Implemented new features and enhancements using Teradata utilities such as BTEQ, FastLoad, MultiLoad .
Senior Associate
Morgan Stanley
Mumbai
06.2011 - 06.2012
- Developed ETL process to extract, transform and load data from Oracle database into the Data Warehouse using Informatica PowerCenter.
- Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
- Designed complex transformations using various transformation objects like Joiner, Lookup, Aggregator, Sorter in Informatica PowerCenter.
- Developed and implemented Teradata ETL processes for data extraction, transformation, and loading.
- Resolved performance issues in existing Teradata databases by tuning queries and modifying indexes.
- Provided technical guidance to junior developers on best practices for coding with Teradata toolsets.
- Optimized query performance by creating appropriate indexes based on workload analysis results.
Systems Engineer
Tata Consultancy Services
Bangalore
06.2010 - 06.2011
- Developed technical solutions for Teradata applications using SQL and stored procedures.
- Performed data analysis, tuning, optimization and troubleshooting of Teradata databases.
- Designed and implemented ETL processes to extract, transform and load data into the Teradata warehouse.
- Maintained performance of existing queries by analyzing query plans and optimizing code.
- Developed scripts for automating daily tasks such as backups, maintenance jobs.
Software Engineer
SuperValu Inc.
Bangalore
01.2008 - 06.2010
- Developed technical solutions for Teradata applications using SQL and stored procedures.
- Designed and implemented ETL processes to extract, transform and load data into the Teradata warehouse.
- Maintained performance of existing queries by analyzing query plans and optimizing code.
- Provided support to end users on various issues related to the use of Teradata systems.
- Assisted in developing test cases for validating accuracy and completeness of data migration across different platforms.
- Deployed application changes into production environment following established change management processes.
Education
Bachelor of Engineering - Electronics And Telecommunications
Shri Guru Gobind Singhji Institute of Engineering
Nanded08.2007
Skills
- Teradata
- AWS
- Azure
- Certified ScrumMaster (CSM)
- Certified Tableau Desktop Specialist
- Unix shell script
- Python
- SQL
- Netezza
- SQL Server
- Tivoli, Autosys
- Informatica
Certification
- Teradata V2R5 Certified Professional
- AWS Certified Solution Architect Associate
- Microsoft Azure Fundamentals Certified
- Certified ScrumMaster (CSM)
- Tableau Certified [Desktop Specialist]
- Financial Markets: A Beginner's Module(NCFM)
Accomplishments
- Received Global recognition from the Business stakeholders for integrating the data from 7 different sources & automating the data loading of Payments MI project which saved the bank 30K GBP annually.
- Received Certificate of Appreciation as a part of Barclays Values Recognition program for contribution towards automation and innovation conjuncture
- Developed an Automation tool for generation of Scripts for deployment of database objects
- Developed CI:CD pipeline for code deployment using JIRA Jenkins
- Felicitated with the Quarterly Star Award for development of automation tool for identifying database standard violations
Current Job Title
AVP (Corporate Data Services-DWH Team)
Data Modeling
Conceptual, Logical & Physical Modeling using ER Studio
Cloud Technologies
- AWS (Redshift, AWS Glue, AWS S3, AWS Lambda)
- Azure fundamentals
Marital Status
Married
Confirmation
I hereby confirm that all the above details provided are true and valid to best of my knowledge.
Current Employer
Barclays
Languages
- Marathi
- Hindi
- English
Timeline
AVP (Corporate Data Services-DWH Team)
Barclays
06.2012 - Current
Senior Associate
Morgan Stanley
06.2011 - 06.2012
Systems Engineer
Tata Consultancy Services
06.2010 - 06.2011
Software Engineer
SuperValu Inc.
01.2008 - 06.2010
Bachelor of Engineering - Electronics And Telecommunications
Shri Guru Gobind Singhji Institute of Engineering
Similar Profiles
Paola Di GiuseppePaola Di Giuseppe
VP Project Manager at BarclaysVP Project Manager at Barclays
THANDO JARVISTHANDO JARVIS
Assistant Vice President, Internal Audit at BarclaysAssistant Vice President, Internal Audit at Barclays
Harshwardhan ParasharHarshwardhan Parashar
Delivery Lead at BarclaysDelivery Lead at Barclays
Meher KalraMeher Kalra
Senior Analyst at BarclaysSenior Analyst at Barclays
Pratik ChaflePratik Chafle
Data Engineer Manager at SaksoftData Engineer Manager at Saksoft