Visual Studio Code
Years of experience in Data Migration and Datawarehousing
Abhijit Sarkar
Azure Data Architect
Kolkata
Summary
With 14 years of experience in data architecture, data warehousing, data integration, and 5 years of expertise as an Azure data and DevOps engineer, I am a skilled Data Architect. My proficiency in Azure cloud services and ETL processes, coupled with my strong analytical and problem-solving skills, has enabled me to lead successful projects across various industries. I specialize in designing and implementing complex data solutions, optimizing data pipelines, and automating deployment processes using DevOps tools. As a leader, I possess strong management skills and have effectively managed teams of developers and engineers to deliver high-quality solutions within budget and on time. My communication and collaboration skills are exceptional, allowing me to work effectively with cross-functional teams and stakeholders to achieve business objectives. I am passionate about innovation and committed to delivering exceptional results through continuous improvement.
Overview
14
14
5
5
Years of experience as Azure Data Engineer and Architect
5
5
Certifications
3
3
Languages
Work History
Azure Data Architect
IBM
Kolkata
09.2016 - Current
- Designing and architecting software solutions that meet business requirements and align with technical standards
- Designed internal process improvements to automate repetitive tasks,shortening data delivery times
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
- Conducting code reviews and ensuring adherence to coding standards and best practices
- Providing technical guidance and mentoring to team members to enhance their skills and knowledge
- Collaborating with project managers and stakeholders to define project scope, goals, and deliverables
- Communicating project status and technical updates to stakeholders and senior management
- Identifying and evaluating new technologies and tools to improve development processes and outcomes
Technical Associates, Cognizant Technology Solutio
Cognizant Technology Solution
Kolkata
08.2014 - 09.2016
- Design and implement Data warehouse migration solution with ETL tools.
- Collaborating with cross-functional teams to design and implement technical solutions
- Conducting technical research and analysis to support project development
- Contributing to a positive and productive work environment.
- Developing and maintaining technical documentation, including user manuals and technical specifications
- Monitoring and analyzing system performance to identify areas for improvement
Team Lead
Indusnet Technology
Kolkata
05.2014 - 08.2014
- Design and implement migration solution with ETL tools.
- Supervise and manage a team of employees to ensure productivity and efficiency
- Identify and mitigate project risks and issues to minimize impact on project outcomes.
- Manage project timelines and budgets to ensure timely delivery of results
- Train and mentor team members to enhance their skills and knowledge
Senior Software Engineer
Citytech Software Pvt. Ltd.
Kolkata
02.2012 - 05.2014
- Design, develop, and maintain complex software systems and applications
- Collaborate with cross-functional teams to identify and solve technical challenges
- Lead and mentor junior software engineers to ensure high-quality code and timely delivery
- Develop and implement software development best practices and processes to improve efficiency and productivity
- Conduct code reviews and provide constructive feedback to improve code quality and maintainability
- Troubleshoot and debug software issues, and provide timely resolutions
- Develop and maintain technical documentation
Senior Executive Software and Support
Softweb Technologies Pvt. Ltd.
Kolkata
08.2010 - 02.2012
- Oversee the design, development, testing, and deployment of software applications and systems
- Manage software development projects from conception to completion, ensuring on-time delivery and within budget
- Collaborate with cross-functional teams to identify and resolve software issues and bugs
- Develop and maintain software documentation, including user manuals, technical specifications, and project plans
- Provide technical support and troubleshooting for software applications and systems
Software Engineer
Rice Pvt. Ltd.
Kolkata
03.2009 - 08.2010
- Design, develop, and maintain software applications and systems
- Write clean, efficient, and well-documented code
- Conduct thorough testing and debugging of software products
- Create technical documentation and user manuals for software products
- Provide technical support to end-users as needed.
- Develop and maintain technical documentation for software applications
Education
MCA - Computer Application
Birla Institute of Technology, Mesra
Mesra, Ranchi, India 06.2005 - 06.2008
BCA - Computer Application
Acharya Institute
Bangalore, India 06.2002 - 06.2005
Skills
Proficient in Azure data services such as Azure Databricks,Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake storage
Knowledge of programming languages such as Python, SQL, and PowerShell for data processing, orchestration and automation
Skilled in designing and implementing CI/CD pipelines for Azure data services using Azure Devops and Github
Experienced in designing deployment model for Azure Datalab resources in a different environment with YAML pipeline, ARM template, and Pester test cases
Proficient in designing deployment pipeline for PowerBI tabular model with Azure Devops
Experienced in working with TSQL and SparkSQL for data warehousing and database development
Experienced in developing and designing delta lake warehouse in Unity catalog using Azure Databricks
Proficient in working with big data technologies such as Hadoop, Spark
Experience in managing and monitoring Azure resources using Azure Log Analytics and Azure App Insight
Skilled in designing MSBI ETL process
Experience in agile methodologies and project management tools such as JIRA and Confluence
Ability to lead a team of developers and provide technical guidance and mentorship
Strong understanding of data warehousing concepts and data modeling techniques
Data Warehousing Architecture
Software
Azure Storage Explorer
Azure Data studio
Sql Server Management Studio
SSDT [Sql Server Data Tools]
Tabular Editor
Certification
Microsoft Certified: DevOps Engineer Expert [I738-0274]
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
Fact explains nothing. On the contrary, it is fact that requires explanation.
Marilynne Robinson
Timeline
Microsoft Certified: DevOps Engineer Expert [I738-0274]
05-2023
Microsoft Certified: Azure Administrator Associate [I738-0280]
05-2023
Certified SAFe® 5 Practitioner [31510715-6920]
02-2022
Microsoft Certified: Azure Fundamentals [H738-8180]
03-2021
Microsoft Certified: Azure Data Engineer Associate [I551-8973]
01-2021
Azure Data Architect
IBM
09.2016 - Current
Technical Associates, Cognizant Technology Solutio
Cognizant Technology Solution
08.2014 - 09.2016
Team Lead
Indusnet Technology
05.2014 - 08.2014
Senior Software Engineer
Citytech Software Pvt. Ltd.
02.2012 - 05.2014
Senior Executive Software and Support
Softweb Technologies Pvt. Ltd.
08.2010 - 02.2012
Software Engineer
Rice Pvt. Ltd.
03.2009 - 08.2010
MCA - Computer Application
Birla Institute of Technology, Mesra
06.2005 - 06.2008
BCA - Computer Application
Acharya Institute
06.2002 - 06.2005