Kajal Takalkar
Pune,Maharashtra
Summary
- 9+ years of experience in database design, development and implementation using Microsoft SQL Server.
- 5+ years of experience in handling the BI tool i.e. SSIS for implementation of ETL methodology in data extraction, transformation, and loading.
- 6-month experience on ADF technology to enhance SSIS package performance using ADF pipeline and CICD. Working on ADF triggers and Azure runtime integration.
- Extensive experience in writing stored procedures, views, complex sub queries, T-SQL queries, correlated queries, and triggers.
- Expertise in applying data integration concepts in Medical verticals as well as in Credit card domain.
- Conducting root cause analysis for troubleshooting customer issues and correcting database defects, responding quickly to bug fixes and enhancement requests.
- Data-driven engineer attentive to system needs and knowledgeable about best practices. Focused on continuous improvement and optimisation in face of changing demands on efficiency, functionality and performance. Iterates professionally and delivers on-specification systems.
Overview
9
9
years of professional experience
Work history
Senior Software Data Engineer
Persistent System
Pune
08.2023 - Current
- Extensive experience in developing complex Stored Procedures, Functions, Exception handling, Views, Dynamic SQL using MS-SQL Server 2008, MSSQL Server 2012
- Good exposure to Statistical Analysis and Predictive Analysis
- Optimizing/Tuning mappings for better performance and efficiency
- Worked in team as well as independent on development of project work flow
- Weekly client calls for better understanding of requirement & solving clients concern over clinical data
- Involved in project documentation & team management
- Extensive work on Joins & Union as well as good exposure to Scripts & Stored procedures
- Extensive worked in creation of SQL Tables, Views, Constraints and good exposure to create Dynamic Scripts, Stored Procedure and Complex Queries
- Managed performance and tuning of SQL queries and fixed the slow running queries in production for better performance and efficiency
- Worked on SSIS Package for Insert, Update, Migrate the bulk data also import and export data.
Senior Software Data Engineer
Zensar Technologies
Pune
06.2021 - 08.2023
- Working on Gaming Domain, Casino and Progressive slots are the games used by client
- Manage the database of slot games using sql server terminology as well as SVN
- Created different slot games for Casino games also maintain history of each player
- Gather the requirement from client and work accordingly ,support the issues raised by clients while playing the game.
Senior Data Engineer
Bajaj Finserv
Pune
12.2018 - 06.2021
- Credit card Sourcing and offer creations (June 2019-June 2021) Share list of embossed customers to RBL for sourcing credit card applying standard rules and process
- This embossing done through daily scheduled job
- Also providing new offers for existing customer's using monthly offer refresh activity using risk rules and authentications
- For existing BFL customers, on monthly basis we qualify new customers for Credit Card offer basis all risk parameters
- The base constitutes primarily of BFL customers who have availed B2B, B2C or RCD products
- Viz: consumer durable/ Digital product loan/LSF/LCF/Personal Loan/Home Loan etc
- Some of these customers may have more than one product relationship with BFL
- Client: RBL Bank
- Language: SQL Server ,SSIS,ADF Responsibilities: Role:Database Developer Built and optimized the complex queries of the database project for customers & completed it with 98% customer satisfaction and timely delivery
- Changed the traditional methods of data insertion using SSIS
- Responsible for developing schemas, tables and rebuilding the indexes to improve the performance of the application
- Testing database and resolving bugs within the given timeline
- For Performance enhancement, Worked on ADF technology to move all the SSIS package into ADF
- Previously we have uploaded data through SSIS package but after introducing to ADF pipeline, ADF triggers
- We have uploaded offers through that
- Responsible for developing Azure Integration, System Variables and different types of data activity in ADF
- ADF schedule triggers used to schedule Azure pipeline to execute at specified time
- ADF Event Base Trigger can respond to specific event.
Associate Software Engineer
FIGmd India Pvt.Ltd
03.2015 - 11.2018
- Built and maintained complex SQL to extract data from the source system as per the business logic
- Worked on various levels of transformation on data before loading the reporting extracted data
- Extensive experience in developing complex Stored Procedures, Functions, Exception handling, Views, Dynamic SQL using MS-SQL Server 2008, MS-SQL Server 2012
- Good exposure to Statistical Analysis and Predictive Analysis
- Optimizing/Tuning mappings for better performance and efficiency
- Worked in team as well as independent on development of project work flow
- Weekly client calls for better understanding of requirement & solving clients concern over clinical data
- Involved in project documentation & team management
- Extensive work on Joins & Union as well as good exposure to Scripts & Stored procedures
- Extensive worked in creation of SQL Tables, Views, Constraints and good exposure to create Dynamic Scripts, Stored Procedure and Complex Queries
- Managed performance and tuning of SQL queries and fixed the slow running queries in production for better performance and efficiency
- Worked on SSIS Package for Insert, Update, Migrate the bulk data also import and export data
- Designing of SSRS Tabular Reports as per requirements.
Education
Bachelor of engineering - Information technology
University of Pune
Pune05.2014
Diploma of Higher Education - Information technologies
Government Polytechnic, Awasari(Pune)
PuneS.S.C. -
Mahatma Gandhi Vidyalaya, Rajgurunagar (Maharashtra State Board)
PuneSkills
- SQL Server
- SSIS
- T-SQL
- Performance Tuning and Optimization
- Azure fundamentals
- Datafactory
- Databricks
- Power BI
- ETL processes
- Data platform modernisation
- Data pipelining
- Sprint planning
- Dataflow
- Systems integration
- PYTHON
- Data collection
- Agile methodology
- Data Visualisation
- Problem Resolution
- Analytical modelling
- Data mining
- Software Development Life Cycle (SDLC)
- Business analysis
- Functional and non-functional requirements
- Data analysis strategies
- Software integration solutions
- Data extraction
- Programming and design skills
- Data mapping
- Data collection and analysis
- Strategic planning and review
- Business planning
- Process development
- Agile methodologies
- Computer programming
- Team player
- SQL
- Code reviews
- Database programming
Accomplishments
- Transformed various activity of performance and tuning of SQL queries and fixed the slow running queries as well as automate internal process which helps team to improve productivity and performance.
- Consistent 'Outstanding' performance and appreciated with 2 times employee of the month Award and annual excellence Award.
Work availability
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
Senior Software Data Engineer
Persistent System
08.2023 - Current
Senior Software Data Engineer
Zensar Technologies
06.2021 - 08.2023
Senior Data Engineer
Bajaj Finserv
12.2018 - 06.2021
Associate Software Engineer
FIGmd India Pvt.Ltd
03.2015 - 11.2018
Bachelor of engineering - Information technology
University of Pune
Diploma of Higher Education - Information technologies
Government Polytechnic, Awasari(Pune)
S.S.C. -
Mahatma Gandhi Vidyalaya, Rajgurunagar (Maharashtra State Board)
Similar Profiles
Ahmed FarazAhmed Faraz
Project Lead at Persistent SystemProject Lead at Persistent System
Abha AgarwalAbha Agarwal
Lead Software Engineer at Persistent SystemLead Software Engineer at Persistent System
Mohini SinhaMohini Sinha
Senior Scrum Master at Persistent SystemSenior Scrum Master at Persistent System
MRUNAL GOSAVIMRUNAL GOSAVI
Senior HR Business Partner at SaamaSenior HR Business Partner at Saama
Kavya MehtaniKavya Mehtani
Team Manager at Foundever (SITEL)Team Manager at Foundever (SITEL)