Open to opportunities

C Samanta

@csamanta

Message

Experienced Solution Architect specializing in data engineering and analytics.

India

Message

What I'm looking for

I am looking for per-hour basis contract jobs on database development and ETL operations.

With over 22 years of extensive experience in IT, I have honed my skills in data engineering, analytics, and solution architecture. My journey began with a solid foundation in Electrical Engineering, which has evolved into a robust career focused on database technologies and cloud solutions. I have successfully led multiple teams at Capgemini, where I played a pivotal role in delivering high-quality data solutions for clients like Uber Freight and Citibank.

My expertise spans across various database technologies including Snowflake, SQL Server, and Oracle, along with proficiency in ETL tools such as SSIS and ADF. I am passionate about leveraging data to drive business decisions and have a proven track record of managing complex projects, mentoring teams, and implementing innovative solutions that enhance operational efficiency. I am committed to continuous learning and professional growth, as evidenced by my recent training in DBT and cloud technologies.

Experience

Work history, roles, and key accomplishments

Current

Solution Architect

Current

Capgemini Technology Services India Limited

Jan 2023 - Present (2 years 4 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 also manage team delivery, troubleshoot issues, and enhance existing ADF pipelines.

Snowflake SQL Server Erwin DBT ADFS SSIS TFS

Solution Architect

Capgemini Technology Services India Limited

May 2019 - Jan 2023 (3 years 8 months)

Managed project delivery and client communication, identified requirements, and created/enhanced SSRS reports and Tableau dashboards. Migrated SSIS packages to ADF and built PowerBI dashboards.

Oracle Tableau ADFS Snowflake GitHub Power BI

Solution Architect

Capgemini Technology Services India Limited

Jan 2018 - May 2019 (1 year 4 months)

Analyzed new data sources, synchronized database models, and designed templates for database objects. Managed and mentored the technical team while providing inputs to higher management.

SQL Server DAX Erwin Snowflake

Solution Architect, Offshore Lead

Capgemini Technology Services India Limited

Mar 2017 - Jan 2018 (10 months)

Managed and mentored a technical team, performed database analysis and tuning, and designed PowerBI dashboards. Provided support in planning and system design.

SQL Server Power BI DAX Amazon Redshift C++SSIS

Technical Leader

Thomson Reuters

Feb 2010 - Feb 2017 (7 years)

Managed and mentored a technical team, performed database analysis and tuning, and conducted POCs for technology demonstration. Developed applications using SQLXML and provided production support.

SQL Server SSIS Oracle Pentaho Scala Spark

Database Architect

First Advantage Offshore Services Pvt. Ltd

Mar 2009 - Nov 2009 (8 months)

Produced architectures and designs, developed databases, and created SSIS packages for data loading. Implemented logging and error handling in SSIS packages.

SQL Server SSIS ASP.NET C++

Sr. Database Analyst

Source Code Infotech Ltd

Jul 2008 - Feb 2009 (7 months)

Produced architectures and designs, managed ETL operations, and optimized database performance. Developed migration and implementation plans based on business requirements.

SQL Server ASP.NET C++

Sr. Programmer

Metrica Systems Pvt. Ltd

Apr 2007 - Jul 2008 (1 year 3 months)

Developed a product providing support to management in contact centers. Worked on C#, ASP.NET, and SQL Server for database management and report generation.

C++ASP.NET SQL Server OLAP Visual Studio

Vocational Trainee

Interra Systems India Pvt. Ltd.

Aug 2006 - Oct 2006 (2 months)

Developed a Management Information System for manpower tracking and reporting using ASP and SQL Server. Generated test plans and sample outputs.

SQL Server VBScript IIS

Software Developer

Cosmic Internet Technologies Solutions Pvt. Ltd

Jul 2006 - Mar 2007 (8 months)

Developed applications for financial services, including database design and coding in C#. Managed data transfer and reporting functionalities.

SQL Server ASP.NET C++XML

Education

Degrees, certifications, and relevant coursework

Calcutta University

Master of Business Management, Management

2001 - 2005

Grade: 56.25%

Completed a Master's degree in Management with a focus on Operations Research and System Analysis. The program emphasized analytical skills and problem-solving techniques applicable in various business contexts.

REC Jaipur

Bachelor of Engineering, Electrical Engineering

1992 - 1996

Grade: 57.66%

Earned a Bachelor of Engineering degree in Electrical Engineering. The curriculum included extensive training in electrical systems, circuit design, and power generation.