Sai Upalekar
Pune,India
Summary
-IT Specialist with a total experience of 15 years primarily in database development , designing ,implementation & maintenance ,performance tuning, data migration , data analysis , data engineering to implement data pipelines and enhance data analytics for improved decision-making
-Product lead and Project management experience of 4.5 years with development and AMS teams under Agile methodology(Scrum, Kanban)
- Experience of interacting with clients from Germany, UK and Sweden
Overview
10
10
years of professional experience
Work History
IT Specialist
Volkswagen Group Digital Solutions, India
Pune
10.2015 - Current
Current project : Marketing Data Analytics (Scania)
Role : Data Engineer
Responsibilities :
-Implementation of business rules for tracking Scania websites usage, cookies, consent using Adobe Experience Platform and Adobe Analytics
-Designing and implementing data engineering pipeline for tracking Organic and Inorganic social media data of Scania websites for different markets board
-Requirement gathering, integration implementation, visualization of Usage Report of various Data Analytics applications and visualization of data in AWS OpenSearch Dashboard
-Creating and maintaining knowledge documentation in Confluence
Previous projects :
Role : Team Lead(Development and AMS) , Oracle and Microsoft SQL Server Developer
Responsibilities
-Daily Monitoring, Conducting daily stand-ups, sprint planning , sprint refinement, and retrospective.
-Conducting Risk Analysis for escalations and offering solutions
-L1 : Enhancements, Data migration , Data modification ,Data Analysis, Performance Tuning.
-L2 : Requirement gathering,Analysis, Development . Includes AMS as well as Development Project
-Maintaining DEV, QA , UAT and PROD environments post patching
-Maintain separate Release Notes for QA, UAT and PROD
-ETL operations using SSIS and SSMS Import/Export Wizard
-Conduct Weekly status calls with AMS and Project stakeholders and follow up when required
-Co-ordinate between environment and different stakeholders jointly using QA and UAT environments
-Documentation: Bi-weekly Status Report, OnCall Sheet, Service Now tickets , Service Improvement , PoC, Knowledge Acquisition documents
-Follow-up on tickets and mentor the team members
-Service improvements and Automation
-Data migration from DTS packages to Oracle Database
Education
Bachelor of Engineering - Electronics And Telecommunications
Maharashtra Institute of Technology
Pune05-2010
Skills
Primary Skills : Database developer, performance tuning
Database : Oracle , Microsoft SQL Server
Development & Design: Database Design, Index Tuning, Query Optimization, Joins, Stored Procedures, Triggers, ETL
Product lead & Project management
Secondary Skills:
Implementation of data engineering pipeline: Azure Data Factory, Power BI (Basic)
Adobe Experience Platform (Basic)
Adobe Analytics (Basic)
AWS OpenSearch Dashboard (Basic)
Power Automate (Basic)
Python(Basic)
Powershell Scripting(Basic)
SSIS(Basic)
Tools : Accutics, Funnel
Versioning Frameworks: SVN (Proficient), Gitlab CI/CD(Basic)
Timeline
IT Specialist
Volkswagen Group Digital Solutions, India
10.2015 - Current
Bachelor of Engineering - Electronics And Telecommunications
Maharashtra Institute of Technology