Rohan Chakraborty

• Led multiple data engineering initiatives by managing data lake architecture and building robust data pipelines using Databricks, Azure Data Factory, Python, PySpark, and SQL to process large datasets, reducing Azure service costs by 20%.
• Designing and implementing data ingestion pipelines from multiple sources using Azure Databricks.
• Integrate Azure storage with Azure Databricks, Build ELT pipeline using Databricks Jobs and Workflows.
• Orchestrate Azure databricks applications using ADF pipelines,
• Build Data pipelines using ADF pipelines and Databricks.
• Developed PySpark applications and deployed in Databricks cluster.
• Developed high-quality Python/PySpark code and implemented software development best practices to maintain high standards.
• Created Azure Synapse Analytics Workspace, used Azure Synapse Studio, Azure Synapse Serverless SQL.
• Integrating Azure Synapse Workspace and Data in ADLS Files, Creating External Tables on ADLS Files using Azure Synapse Workspace, Build ADF data flow using Azure SQL.
• Extensively worked on Azure Data Lake Analytics with the help of Azure Data bricks to implement SCD-1, SCD-2 approaches.
• · Designed and implemented end-to-end data engineering pipelines using ADLS, Azure Data Factory (ADF), Azure Databricks, Azure Synapse Analytics, Terraform/ARM Templates, Azure Kubernetes Service (AKS), and CI/CD practices.

This project objective is to Automate the Manual Reporting also make those Reports Dynamic and robust.

• Analyzed business requirements and created functional requirements specifications to build and deploy solutions.
• Automated manual reports to Tableau Server report using filters, parameters , and calculated sets that automatically qualified sales leads resulting in a lift in conversion rate of 27%
• Enabled automation of previously manually intensive dashboards allowing our company to reduce vendor costs by $14,500 annually.
• Implemented security guidelines by using user filters and row-level security reducing private data exposure by 72%.
• Built robust forecasting using parameters, trend lines, and reference lines that were reported directly to MassMutual Wall for quarterly earnings reports saving 42 hours of manual work in each quarter.
• Developed complex quantitative data in a simple, intuitive format to present finding in concise manner using Tableau.

This project was based on prod support with 24/7 support. Being in Prod support, it also involves a huge amount of analysis and maintenance tasks.

• Leading the production support team of skilled teammates.
• Provide an instant fix for any production job abends, finding the root cause, and providing a permanent resolution.
• Analyzing requirements and implementing maintenance projects.
• SME for different applications and insurance campaigns.

Corporate Cards were migrated from CARE System to GlobeStar, a part of this process the data associated with care system for a specific card member we migrated those data to GlobeStar.

• Enhancement & Development of the existing/new COBOL-DB2 modules, JCLs , Procs and Parms .
• Created Unit test cases and implemented the unit test results. Providing SIT and UAT Suppo rt.
• Understanding and creating mapping for several Online Screens (COBOL-CICS-IMS-DB/ DB2) progra ms.
• IM planning, RFC/PRC/SSR creation and execution and huge number of !MR Handling.
• Provide instant fix for any production job abends, finding the root cause and proving permanent resolution.