Pratik Sarkar
Kolkata,India
Summary
A seasoned Tech Lead with a proven track record at IBM India Pvt. Ltd., I excel in leveraging MSBI tools and Azure ADF to enhance data analytics and reporting processes. Skilled in SQL Server and Oracle, my leadership has driven significant improvements in project delivery and team performance, demonstrating exceptional analytical and team management abilities.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Tech Lead - Microsoft Analytics
IBM India Pvt. Ltd.
06.2010 - Current
- Tech lead– Microsoft Analytics (SSiS SSRS), SQL Server
Application Developer – MSBI/Azure Analytics
IBM India Pvt. Ltd.
10.2022 - 03.2024
- This project is basically a merger project
- The Client SIC is a Group Insurance company
- Which has acquired the company Securian
- Now SIC want to merge Securian Retirement Planning system into its System
- Project is a development project to merge securian RP features in to Sic RP system
- Working as team lead on Azure ADF, SSIS and SSRS technologies to understand analysis requirement for merging features and transform the same in the Sic System
- Identify the requirements to merge the acquired system in to existing
- Analyze the code behind of the dataflow and understand the logic
- Design the technical documents for the required changes need to merge the system
- Responsible for technical aspects of end-to-end solutions delivery, deployment, system integration, and customer acceptance of the project
- Environment: MSBI, Windows 10
- Team Size: 35
Application Developer – MSBI-Team Lead
IBM India Pvt. Ltd.
03.2021 - 09.2022
- Production Support and Maintenance project on Business Intelligence
- The Client Standard Insurance Company
- IBM is handling a portfolio of 35+ Business Intelligence ETL applications which are related to Employee Benefits, Contract, CRM to Salesforce etc
- The team is responsible to handle day to day incidents coming up in the production cycle and handle ETL enhancements and process improvements which will be considered as value add to the customer
- The team is also responsible for handling all external interfaces to third parties
- Worked on different phases of data warehouse development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, SSIS Packages and SSRS Reports
- Participated in the SIT/UAT along with the end-users
- Represented team in Change Advisory Board meetings to review changes in the production environment
- Taken care of proactive validations steps during major infrastructure changes with client’s applications
- Mentored and trained new hires to ensure their smooth on-boarding into the team
- Driving various performance tuning and ideation initiatives within team for better customer satisfaction
- Resolving the L2 defects from operations team
- Environment: MSBI, Windows 10, Powershell
- Team Size: 4
Team Lead – Power BI Data Modeling
IBM India Pvt. Ltd.
02.2020 - 02.2021
- This Project was a Power BI development Project
- This was to convert the Project from Business Object to Power BI and convert the whole Business object Universe into Power Bi data modeling Comprising all 107 reports to be converted in to power BI creating the entire data model in Power BI
- Identify the requirements to merge the acquired system in to existing
- Analyze the code behind of the dataflow and understand the logic
- Design the technical documents for the required changes need to merge the system
- Responsible for technical aspects of end-to-end solutions delivery, deployment, system integration, and customer acceptance of the project
- Environment: Oracle 10g, Business Object, Power Bi, SSAS
- Team Size: 4
Application Developer
IBM India Pvt. Ltd.
11.2015 - 08.2019
- Spice is a critical project of Phillip Morris
- This is one of the crucial Support projects with MSBI, PowerBI, etc
- Worked on different phases of data warehouse development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, SSIS Packages and SSRS Reports
- Participated in the SIT/UAT along with the end-users
- Represented team in Change Advisory Board meetings to review changes in the production environment
- Taken care of proactive validations steps during major infrastructure changes with client’s applications
- Mentored and trained new hires to ensure their smooth on-boarding into the team
- Driving various performance tuning and ideation initiatives within team for better customer satisfaction
- Resolving the L2 defects from operations team
- Environment: Sql Server, MSBI, C# Scripting, Cognos
- Team Size: 15
Application Developer
IBM India Pvt. Ltd.
06.2010 - 10.2015
- McCain Support is the support project
- The project is basically Business Intelligence support projects Based on ETL solution, Reporting/Data Visualization
- Worked on different phases of data warehouse development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, SSIS Packages and SSRS Reports
- Participated in the SIT/UAT along with the end-users
- Represented team in Change Advisory Board meetings to review changes in the production environment
- Taken care of proactive validations steps during major infrastructure changes with client’s applications
- Mentored and trained new hires to ensure their smooth on-boarding into the team
- Driving various performance tuning and ideation initiatives within team for better customer satisfaction
- Resolving the L2 defects from operations team
- Environment: Sql Server, MSBI, Crystal Report
- Team Size: 6
Developer -Team Lead
Comtel Technologies Pvt LTD
12.2008 - 05.2010
- Worked as Team leader and Software Engineer
- Responsible for Requirement study, Designing and Code Development and bug fixing as well as implementation of BI Applications in Client site
- Worked with technologies like Sql Server 2005/2008 Oracle 8i, Data Transformation Service and Crystal XI and Also includes the Roles to lead the team in the development implementation and post implementation support
Application Developer
Comtel Technologies Pvt LTD
01.2009 - 04.2010
- ISMS is Support and enhancement project a complete customized ERP
- Worked as Backend database Developer in SQL Server for the same
- Worked on different phases of backend application development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, Reports
- Participated in the SIT/UAT along with the end-users
Developer
Sunrise Technologies
04.2006 - 10.2008
- Worked as Developer
- Responsible for Requirement study, Designing and Code Development and bug fixing as well as implementation of BI Applications
- Worked with technologies like Sql Server 2005 Oracle 8i and Crystal XI, Data Report and Also includes the Roles to support the team in the development implementation and post implementation support
- IDS is Support project a Material Management System
- Worked as Backend database Developer in SQL Server for the same
- Worked on different phases of backend application development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, Reports
- Participated in the SIT/UAT along with the end-users
Application Developer
Robinson Innovation Technologies
09.2005 - 02.2006
- HRMS or Human Resource Management System is Support & development project to support small companies Human resource management
- Worked as Backend database Developer in SQL Server for the same
- Worked on different phases of backend application development lifecycle i.e
- Development implementation, testing, deployment and support
- Developed Complex database objects like Stored Procedures, Functions, Reports
Education
B.Com -
University of Calcutta
Skills
- MSBI (SSIS, SSRS, SSAS)
- Sql Server
- Oracle
- Azure ADF
- Databricks
- C#
- VBnet
- Python
- Powershell
- Cognos
- TOAD
Certification
Microsoft Azure Data Engineer Associate (DP-201, DP-200)
Awardsrecognition
Manager Choice Awards for Year-2021
Affiliations
- Manager choice Awards
Timeline
Application Developer – MSBI/Azure Analytics
IBM India Pvt. Ltd.
10.2022 - 03.2024
Application Developer – MSBI-Team Lead
IBM India Pvt. Ltd.
03.2021 - 09.2022
Team Lead – Power BI Data Modeling
IBM India Pvt. Ltd.
02.2020 - 02.2021
Application Developer
IBM India Pvt. Ltd.
11.2015 - 08.2019
Application Developer
IBM India Pvt. Ltd.
06.2010 - 10.2015
Tech Lead - Microsoft Analytics
IBM India Pvt. Ltd.
06.2010 - Current
Application Developer
Comtel Technologies Pvt LTD
01.2009 - 04.2010
Developer -Team Lead
Comtel Technologies Pvt LTD
12.2008 - 05.2010
Developer
Sunrise Technologies
04.2006 - 10.2008
Application Developer
Robinson Innovation Technologies
09.2005 - 02.2006
B.Com -
University of Calcutta
Similar Profiles
Pallavi Kumar Pallavi Kumar null
NA at IBM India Pvt Ltd, Bangalore IBM India PNA at IBM India Pvt Ltd, Bangalore IBM India P
Shruti PaintalShruti Paintal
SERVICE INTERGRATION MANAGER at Kyndryl India Pvt Ltd and IBM India Pvt LTDSERVICE INTERGRATION MANAGER at Kyndryl India Pvt Ltd and IBM India Pvt LTD
Akhila ShilpaAkhila Shilpa
Senior Project Manager at IBM India Pvt Ltd/ Kyndryl India Pvt LtdSenior Project Manager at IBM India Pvt Ltd/ Kyndryl India Pvt Ltd
Sudhir NigamSudhir Nigam
Senior Lead, Software Architecture (Automation Architect) at Kyndryl India Pvt Ltd (IBM India Pvt. Ltd.)Senior Lead, Software Architecture (Automation Architect) at Kyndryl India Pvt Ltd (IBM India Pvt. Ltd.)
UJJWAL NASKARUJJWAL NASKAR
Associate Administrator Production at Iffco Group Seville Chocolate LLC. BR.Associate Administrator Production at Iffco Group Seville Chocolate LLC. BR.