CHIRANJIB DAS

CVS health (Aetna) Cloud Transformation (On prem- GCP migration)

• As a Cloud Solutions Architect, actively involved in all phases (discovery, pilot, ready state) of migrating existing mission critical business applications into GCP cloud-based environment. Activities required to re-host an application into the cloud includes architecture modifications, database and/or application server re-hosting, and potentially recoding of existing capabilities to take advantage of cloud platform services.
• Reverse engineering of 40+ applications from existing Hadoop system and build roadmap for GCP- BQ migration. Planning for pilot phase data migration for 3 applications, Collecting data sets that meets functional / non-functional business requirements. Working with data and analytics experts to strive for greater functionality in data system
• Guiding team of 20+ members on 3 tracks for reverse engineering, mapping creation and data pipeline creation. Building strategy for historical data migration (using existing data in Hadoop and SQL server) with minimum changes to accumulate exiting KPI’s and new data pipelines for on – going data (delta) ingestion
• Introduced Internal chatbot using chatgpt LLM by integrating internal github and servicenow with user prompt api which reduces 40% time for users to search internal knowledgebase
• Working closely with customer Directors and VP’s assisting them for continuous betterment of the program delivery and cost optimization introducing AI powered solutions

Project: PepsiCo Teradata to Synapse Migration

• As Cloud Solutions Architect, Actively involved in a program geared towards migrating existing mission and business applications into a cloud-based environment. Activities required to re-host an application into the cloud may include architecture modifications, database and/or application server re-hosting, and potentially recoding of existing capabilities to take advantage of cloud platform services.,
• Worked as Azure architect/Data management techno-functional lead from offshore, Approach finalization for historical and ongoing incremental data load, Worked in reverse engineering of the Teradata existing jobs to build the inventory for app migration.
• Worked in creating detailed level design document for pilot apps, Develop solutions for Pilot phase, to migrate ‘Power Of One’- Sales and Marketing KPI application from Teradata to Azure Synapse, by converting existing TD Bteq logics into ADB PySpark codes.
• Move Teradata ACQ layer data using S&T framework into Bronze and then build the silver and gold layer inside Delta lake. Finally move the data into Synapse using store procedures., Worked on production go-live/cutover for pilot apps, Responsible for mentoring the team of 10+ members in offshore for seamless delivery, Collecting data sets that meets functional / non-functional business requirements, Working with data and analytics experts to strive for greater functionality in data system, Prepare for future applications discovery and analysis for upcoming sprints

Project: Kellogg Kortex Migration

• As Cloud Solutions Architect, Strategist and AWS lead on re-engineering of applications to migrate from on premises and external file systems to AWS cloud services, which involved data warehouse rebuilding over AWS which will be accessed through all the reporting services and analytics team,
• Worked on classification of the existing tables in domain group (Master Data and Sales data major) in the activity of re-engineering and grouping of the existing tables for building domain granular model, Involved in Kellogg specific new data model activities which was restructuring the tables on domain and region basis, Architecting, developing and prototyping of different frameworks to bring data from on premises to cloud using Spark job (written in Python ) with AWS Glue services for non-SAP sources and confluence file type,
• Create end to end design for applications to host on AWS which involved s3 RAW-> S3 CleansedProcessed->Redshift Target Db for domain creating domain granular layer, Created STTM document for Cleansed to Redshift target tables using current transformation logics which were in on premises sql, Worked extensively with Cognizant accelerator framework (DIF tool) to move data raw to cleansed layer while developing all kind of file formats like csv/txt/xls/xlsb/json/dat to accumulate in cleansed layer,
• Worked extensively on analysis of SAP global tables ECC/SCM (major) modules for analysis and mapping for building domain granular data model, Successfully migrated Master data and Sales data in Domain Granular model(Material/Customer/location /Foundation reference/Sales- Execution/Strategy/Performance/Order etc) into AWS environment., Working as advisory to all the different tracks for data related issue fix/debugging in all around the tracks in Kellogg, Worked with AWS support for fixing different issues while executing the Glue codes which were not able to execute due to VPC/subnet mask.
• Managed a team of 20+ members in Agile POD model of execution