SQL Data Analyst & Developer
Contact Information:
▪ Name: Sudipto Banerjee
▪ Contact Number: 8788051479 / 9130853354
▪ Email-ID:
[email protected] ▪ LinkedIn: https://www.linkedin.com/in/sudipto-banerjee-b42617a1/
Professional Experience:
▪ 6.5+ years of experience as Business Intelligence Developer and Data Analyst in Production Environments.
▪ Strong Communication & Management skills with Excellent Role-playing capabilities.
▪ Extensive experience in Installation, Configuration and Updates of SQL Server.
▪ Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS,
Bulk Copy Program (BCP) and Bulk Insert.
▪ Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Flat files,
Oracle.
▪ Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
▪ Extensive experience in controlling the User Privileges, Monitoring the Security as per Standards.
▪ Expertise in handling Performance tuning, Optimization, Data integrity.
▪ Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and
Event Handling.
▪ Experienced in programming tasks-Stored Procedures, Triggers, using SQL Server 2012/2014 with T-SQL.
▪ Experienced in Data-Flow, Process Models, E-R Diagrams.
▪ Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS
Packages.
▪ Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock
Transformations.
▪ Expertise in generating reports using SQL Server Reporting Services, and MS Excel.
▪ Expertise in What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using
Warehouses and OLTP Connections
▪ Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modelling for Moderate to Large
Data Systems.
▪ Experience in Snowflake and Star Schema Data Modelling.
▪ Experience in working on OLAP and OLTP Database.
▪ Knowledge in Tableau View and Dashboard creation.
Educational/Professional Qualification
▪ B.Tech (Computer Science) -> Heritage Institute of Technology (WBUT) 2010 -> Marks. 65.20%
▪ HSC / 12th (Science) -> Burdwan Bidyarthi Bhaban High School (WBCHSE) -> Marks. 52.00%
▪ Madhyamika / 10th (General) -> Burdwan CMS High School (WBBSE) -> Marks. 70.38%
Technical Skills:
Databases: SQL SERVER 2012/2014/2016, Postgre-SQL and My-
SQL,Oracle 12C
Programming: SQL, T-SQL, Python
Operating
Windows 2003/2007/2010
System:
Tools: SSIS, SSRS, Birt, Tableau
Work Experience:
▪ Accenture -> February 2020 to January 2022
▪ Tech Mahindra -> December 2018 to February 2020
▪ Firstcry.com -> July 2017 to June 2018.
▪ Indiacom Limited -> February 2015 to July 2017.
Professional Summary:
Client: Kaiser
Place: Accenture Bangalore
Role: BI Engineer
Duration: March 2020 to January 2022
▪ Involved in creation/review of functional requirement specifications and supporting documents for
business systems, experience in database design process and Data Modelling process.
▪ Extracted data from various sources like SQL Server 2008/2012, Oracle12C, .CSV, Excel and Text file
from Client servers and through FTP.
▪ Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting
skills for quick issue resolution in large-scale production environments located globally.
▪ Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
▪ The packages created included a variety of transformations, for example Lookup, Aggregate, Derived
Column, Conditional Split, Multicast and Data Conversion.
▪ Create and maintain Container in SSIS package for process flow maintain.
▪ Working on BI Job failure issue and Job monitoring.
▪ Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery
mechanisms.
▪ Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
▪ Performed and finetuned Stored Procedures and SQL Queries and User Defined Functions.
▪ Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
▪ ETL job monitoring.
Environment: SQL server 2012, SQL server 2016, DTS, SSIS, T-SQL
Client: AT&T
Place: Tech Mahindra Pune
Role: SSIS Engineer
Duration: Jan 2019 to Feb 2020
▪ Involved in creation/review of functional requirement specifications and supporting documents for
business systems, experience in database design process and Data Modelling process.
▪ Extracted data from various sources like SQL Server 2008/2012, Oracle12C, .CSV, Excel and Text file
from Client servers and through FTP.
▪ Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting
skills for quick issue resolution in large-scale production environments located globally.
▪ Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
▪ The packages created included a variety of transformations, for example Lookup, Aggregate, Derived
Column, Conditional Split, Multicast and Data Conversion.
▪ Create and maintain Container in SSIS package for process flow maintain.
▪ Dashboard creation by using tableau.
▪ Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
▪ Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data
mart and warehouse systems.
Environment: SQL Server 2008 and SQL server 2012, DTS, SSIS, Oracle 12C, T-SQL
Client: Firstcry.com
Place: Firstcry.com Pune
Role: Data Analyst
Duration: Jul 2017 to Jun 2018
▪ Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Upgrading of
SQL Servers.
▪ Involved in Installation, Configuration and Deployment of SSRS Reports.
▪ Report designing and validation Using SSRS and SQL Server.
▪ Used Process Explorer for maintenance of stuck process, and to release the handles on files
▪ Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
▪ Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE) and
LINQ.
▪ Data validation and quality checking between different databases like MS-SQL Server, My-SQL, PostgreSQL
Environment: SQL Server 2008/2005, Postgre-SQL, My-SQL, Excel, SSRS
Client: Microsoft
Place: Indiacom Limited Pune
Role Process Handling and quality management.
Duration: Jul 2015 to Jun 2017
▪ Involved in creation/review of functional requirement specifications and supporting documents for
business systems, experience in database design process and data modelling process.
▪ Extracted data from various sources like SQL Server 2008, .CSV, Excel and Text file from Client servers and
through FTP.
▪ Report designing and validation Using SSRS, Excel, SQL Server.
▪ Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for
quick issue resolution in large-scale production environments located globally.
▪ Created Data-driven Packages in SSIS as part of the automating the process for the Report development
and quality management Process.
▪ The packages created included a variety of transformations, for example Lookup, Aggregate, Derived
Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
▪ Create and maintain Container for handling large number of Data Source in SSIS package for process
flow maintain.
▪ Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
▪ Studied existing Created facts, dimensions and star schema representation for the data mart and warehouse
systems.
▪ Implemented Table Partitioning, Advanced Error handling, Query writing, Create and maintain Store
procedure.
Environment: SQL Server 2008/2005, Excel, SSIS, SSRS, Python.
Client: Indiacom Limited
Place: Indiacom Limited Pune
Role: PMS
Duration: Feb 2015 to Jun 2015
▪ Database creation, Data flow checking index creation.
▪ Resolved kinds of software or database related issues such as data loading and migration
▪ Write complex query and store procedure
▪ Build and maintain efficient SSIS packages for processing fact and dimensional tables.
Environment: SQL Server 2008/2005, Excel, SSIS.
Personal Details:
Father’s
Suniti Banerjee
Name:
Mother’s Jayashree
Name: Banerjee
Date of Birth: 31/10/1987
Nationality: Indian
Marital Status: Married
Sex: Male
Declaration:
I confirm that the information provided by me in this application form is accurate and correct.
