Open to opportunities

Chandrajit Samanta

@chandrajitsamanta

Message

Experienced Solution Architect specializing in data engineering and analytics.

India

Message

What I'm looking for

I am looking for a challenging role in a dynamic environment that fosters innovation and growth.

I am a seasoned Solution Architect with over 22 years of experience in the IT industry, specializing in data engineering, database technologies, and business intelligence. My journey has taken me through various roles where I have honed my skills in data modeling, ETL processes, and cloud technologies, particularly with Snowflake, Azure, and SQL Server.

Throughout my career, I have successfully led multiple development teams, managed project deliveries, and collaborated with clients to understand their requirements. My technical expertise spans across various BI/ETL tools, including Power BI, Tableau, and SSIS, enabling me to deliver impactful data solutions that drive business decisions. I am passionate about mentoring and coaching teams, fostering a culture of continuous learning and improvement.

Experience

Work history, roles, and key accomplishments

Current

Solution Architect

Current

French MNC

Jan 2023 - Present (2 years 6 months)

As a Solution Architect, I participate in discussions with end users and sales teams for new requirements, perform system analysis, and create data models using Erwin. I manage project delivery, support teams, and troubleshoot issues while enhancing existing data pipelines and migrating legacy reports to SSRS.

Snowflake SQL Server Erwin DBT SSIS Power BI

Solution Architect

French MNC

May 2019 - Jan 2023 (3 years 8 months)

Managed project delivery and client communication, identified requirements, and led a team of 8. Enhanced SSRS reports and Tableau dashboards while migrating SSIS packages to ADF pipelines and automating Snowflake migration using Python and DBT.

Oracle Tableau ADFS Power BI Python DBT

Solution Architect

French MNC

Jan 2018 - Apr 2019 (1 year 3 months)

Analyzed new data sources, synchronized database models, and managed a technical team. Provided inputs for project delivery and designed ETL processes while working with SQL Server and Snowflake.

SQL Server Power BI DAX Snowflake ETL Team Management Performance Tuning

Technical Leader

Thomson Reuters

Feb 2010 - Feb 2017 (7 years)

Led a technical team in database analysis, design, and development. Managed data migration from Oracle to SQL Server and developed SSRS reports while providing support for planning and system design.

SQL Server Oracle SSIS Data Migration Team Management Performance Tuning Python

Database Architect

First Advantage Offshore Services

Mar 2009 - Nov 2009 (8 months)

Produced architectures and designs for database development and migration. Developed SSRS reports and created SSIS packages to load data from multiple sources.

SQL Server SSIS Database Design Data Migration Performance Tuning ASP.NET C++

Sr. Database Analyst

Source Code Infotech

Jul 2008 - Feb 2009 (7 months)

Produced architectures and designs while managing ETL operations. Developed SSIS packages and optimized database performance.

SQL Server SSIS ETL Data Modeling ASP.NET C++

Sr. Programmer

Metrica Systems

Apr 2007 - Jul 2008 (1 year 3 months)

Worked on a product providing support to management in contact centers. Developed applications using C#, ASP.NET, and SQL Server.

C++ASP.NET SQL Server OLAP Data Analysis Application Development Visual Studio

Software Developer

Cosmic Internet Technologies

Nov 2006 - Mar 2007 (4 months)

Developed applications for financial services, focusing on database design and XML data transfer. Responsible for coding and testing.

SQL Server ASP.NET C++XML Database Design Application Development Testing

Education

Degrees, certifications, and relevant coursework

Calcutta University

Master of Business Management, Management

2003 - 2005

Grade: 56.25%

Completed a Master's degree in Management with a focus on Operations Research and System Analysis, achieving a percentage of 56.25%. This program provided a strong foundation in analytical and decision-making skills applicable in various business contexts.

REC Jaipur

Bachelor of Engineering, Electrical Engineering

1992 - 1996

Grade: 57.66%

Earned a Bachelor of Engineering in Electrical Engineering, focusing on the principles of electrical systems and their applications. Graduated with a percentage of 57.66%, which included extensive practical training and project work.

West Bengal Council of Higher Secondary Education

Higher Secondary Certificate, Higher Secondary Education

1988 - 1990

Grade: 64.4%

Completed higher secondary education with a focus on science subjects, achieving a percentage of 64.4%. This education provided a solid foundation for further studies in engineering.

West Bengal Board of Secondary Education

Secondary School Certificate, Secondary Education

1986 - 1988

Grade: 72.3%

Completed secondary education with a focus on general studies, achieving a percentage of 72.3%. This foundational education was critical in preparing for higher academic pursuits.