Prathamesh Bagav

Experience

• 

  SVC Bank

  Aug 2010 - Jun 2017

  • Actively participated in interaction with users, Team lead, DBAs and technical manager to fully Understand the requirements of the system. • Used Joins, sub-queries for complex business queries involving Multiple tables from different Databases and implemented triggers and stored procedures and Enforced business rules Via checks and constraints. • Involved in Report Design and Coding for Standard Tabular type reports, Drill down ,Drill through And Graphical presentations such as Charts and Dashboard using SSRS. • Scheduled the monthly/weekly/daily Report Subscriptions to run automatically. • Creating on-demand reports and Send the reports via email. • Designed SSIS Packages to extract data from various data sources such as Excel ,SQL Tables From SQL Server 2012 for further Data Analysis and Reporting by using multiple transformations Provided by SSIS such as Data Conversion, Conditional Split, Merge, Union all, for loop, Sequence Container, For Each loop, Data Flows tasks, Execute Sql task Etc. Scheduled and maintained daily and weekly loads of data by creating the corresponding job tasks. • Enhanced performance using indexing and monitoring logs to ensure the completeness of batch Processes and scripts. • Maintain SQL Jobs, Job Steps and Schedules. • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and Customer representatives for various categories and regions, based on business needs using SQL Server Reporting services (SSRS). Show less • Development Experience in programming tasks-Stored Procedures, Triggers, Functions, Cursors, and Joins using SQL Server 2005 with T-SQL.• Design and development of SQL Server Integration Services (SSIS 2012) packages using various control flow task and data flow transformation. • Development of SSRS Reports.• Installed, configured and maintained SQL Server Reporting Services (SSRS).• Development, Designing, Tallying of Banking Reports as Per RBI Requirements.• Debugging of code for any new changes and bug rectification.• Installing and Testing software as and when required.• Providing software support required as and when.• Involved in Backing up and Restoring of databases. Show less

  • Assistant Manager

    Apr 2015 - Jun 2017

  • Senior Software Engineer

    Aug 2010 - Mar 2015
• 

  CitiusTech

  Jul 2017 - Aug 2021

  • Create, optimize and maintain ETLs for DW for a huge number of records .Extract and load data from various sources like SQL Server 2012, CSV, and Text file from Client servers.• Parallely handling sub project individually end to end from getting client requirements to implementing and delivering the same to customers of clients.• Review & Test packages, fixing bugs (if any) using SQL 2015 Business Intelligence Development Studio.• Analyzing the data quality issue and finding root cause along with implementing a fix.• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs.• Used SQL Profiler and Execution plans for Performance monitor to resolve Dead Locks and long running queries by checking appropriate changes. • Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks• Identifying of performance bottlenecks, Performance tuning of packages.• Actively participated in interaction with users, Team lead, DBAs and technical manager to fully understand the requirements of the system.• Analysing data for business using SSAS cubes and DW.• Building and deploying reports on SSRS for business.• Managing SQL server jobs and maintaining same.• Ad-Hoc analysis about data quality and existing data movement procedure for business.• Actively worked on SSAS cubes as a tool to access analytical data. Show less

  • Technical specialist I

    Apr 2021 - Aug 2021

  • Technical Lead Grade II

    Jul 2017 - Apr 2021
• 

  Tata Consultancy Services

  Sept 2021 - Nov 2023

  Associate Consultant
• 

  LTIMindtree

  Dec 2023 - now

  Senior Specialist - Data Engineering