Tumpa Bhaduri

• Design, develop, and maintain Power BI reports and dashboards to visualize business data and provide actionable insights. Extract, transform, and load (ETL) data from various sources into SQL databases for analysis and reporting purposes. Develop and optimize SQL queries, stored procedures, and functions to support data analysis and reporting requirements. Collaborate with business stakeholders to understand their data needs and translate requirements into technical solutions. Handled tickets in service now based on the issue raised by client or customer
• Analyzed customer feedback in order to recommend improvements that could be made in products and services offered by the organization.
• Assisted in developing processes to improve customer service efficiency.
• Developed training materials for customers on how to use specific applications and systems correctly.

Projects Worked:

1. Prudential America(2022 June - Current date )

• Performed data loading .creating error report and sending to client .
• Handled and support service now ticket, RITM
• Update Power bi Dash board .
• Used SQL server management studio to provide load confirmation to the client.
• Create report using SQL Lite and send to required team to take actioned .
• Used Microsoft Macros to convert Excell to text format for loading purpose .
• Create late file incident in service now and monitor it until its received .
• Raised update request to developer team to make changes in the data base based on the current requirement
• Used Informatica to check log incase of any fill missing .

2.AIG Japan (2022 Jan - 2022 May)

• Performed Delete ,Insert and update function in the test DB based on Clients request . Then passed the query to the Clients It team to update it on the Production db .

3.Marks and spencers.(2019 May - 2021 December)

• I was responsible for monitoring the performance and health of databases, using tools like SQL Server Management Studio (SSMS) and monitoring scripts.
• Conducted routine maintenance tasks such as index rebuilding, database backups, and transaction log management to ensure optimal performance and data integrity.
• Responded promptly to incidents and user-reported issues related to SQL queries, database connections, and performance degradation.
• Utilized SQL profiling tools and query execution plans to diagnose and resolve issues efficiently, minimizing downtime and impact on operations.

4.Target Retail support .

Supported all the service desk related query.(2018 sep to 2019 may)

• Resolved user issues by providing guidance over the phone or through remote access sessions.
• Diagnosed network connectivity problems using diagnostic tools.
• Investigated reported incidents involving security breaches or unauthorized access attempts.
• Provided technical support to users, troubleshooting hardware and software issues.
• Created user accounts, passwords and profiles in accordance with company policy.

• Handled tickets in service now based on the issue raised by client or customer
• Diagnose and resolve hardware and software issues reported by users with Dell laptops
• This involves identifying the root cause of problems through remote assistance, phone support, or onsite visits
• Assist users with operating system issues, driver conflicts, software errors, and application compatibility problems on Dell laptops
• Diagnose and resolve network issues reported by users or detected through monitoring systems
• This involves analyzing network traffic, logs, and configurations to identify the root cause of problems
• Provide technical assistance to end-users, including troubleshooting connectivity issues, VPN problems, and network performance issues
• Offer guidance on network-related best practices and assist with network configuration
• Maintain and manage network hardware such as routers, switches, firewalls, and access points
• Perform routine maintenance tasks, including firmware upgrades, patching, and hardware replacements as needed.

Project Name: Belkin and linksys Router support .

• Provided remote assistance to end-users when needed.
• Analyzed system logs for potential problems or errors related to system performance or security threats.
• Provided technical support to customers by troubleshooting and resolving hardware and software issues.
• Troubleshot network connectivity problems such as router configurations, IP addressing, and DHCP server setup.
• Installed and tested operating systems, applications, updates, patches, and service packs.
• Resolved complex technical problems through root cause analysis techniques.
• Assisted customers with troubleshooting software and hardware issues.
• Configured, maintained, and monitored computer systems for optimal performance.

Project name: Dell International Enterprise support