Soujita Ghosh

Project: Azure to AWS migration.

Domain : Oil and gas Industry

Period: Jan 2024 to Nov 20224

1. Contributed to the successful migration from Azure to AWS, focusing on the seamless transfer of ADF pipelines to Snowpipe for enhanced data processing and automation.
2.Conducted a comprehensive assessment of existing workflows and collaborated in designing the target architecture to facilitate a smooth migration process.
3. Developed comprehensive Architecture Review Board (ARB) documentation for all workflows, ensuring alignment with best practices and strategic objectives.
4. Configured and established secure SFTP connections in AWS Jscape, enabling seamless and reliable vendor integrations.
5. Worked on migration of existing Python code to AWS infrastructure, ensuring full compatibility and optimization for cloud environments.
6. Collaborated extensively with external vendors to validate migration activities and ensure seamless file transfers post-migration.
7. Gained hands-on experience with AWS services, including managing policies, Secrets Manager, EC2 instances, and S3 buckets.

Project : Data Operations with BPX Energy

Domain : Oil and Gas Industry

Period : Feb 2022 to Dec 2023

1. Provided comprehensive operational support and enhancements for data integration processes, ensuring seamless operations with BPX Energy.

2. Developed and optimized data integration and ingestion workflows across multiple platforms, including Enterprise Data Hub, DataMart, Azure Data Lake, Azure File Storage, Snowflake, SharePoint, and on-premise databases.

3. Designed and implemented efficient ETL jobs using Azure Data Factory pipelines to streamline data processing workflows.

4. Developed and deployed Logic Apps to automate and address specific business requirements, enhancing operational efficiency.

5. Proactively identified and resolved data discrepancies by troubleshooting using SQL queries, ensuring data accuracy and consistency.

6. Collaborated closely with cross-functional teams to resolve production bugs, address data gaps, and troubleshoot automation failures to maintain smooth operations.

7. Utilized Snowflake to query data, analyze data gaps, and implement solutions. Possess hands-on experience with Snowflake unload tasks and Snowpipe for efficient data loading and processing.

8. Conducted rigorous testing and validation of data pipelines to ensure accuracy and completeness of data.

9. Developed Python scripts for extracting data from web services API's and loading into databases.

10. Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.

11. Proficient in ServiceNow, managing all P1 and P2 incidents, service requests, and change requests to ensure timely resolution and service continuity.

12. Implemented data visualization tools like Tableau and Power BI to create dashboards and reports for business stakeholders.

13. Streamlined data flow from diverse sources using Azure Data Factory, Azure Functions, Stonebranch and Jscape.

Project : Stonebranch

Domain : Oil and Gas Industry

Period : Aug 2021 to Jan 2022

1. Configured and deployed SSL certificates to ensure secure communication for the application.
2. Implemented and configured the Stonebranch application for BPX Energy, streamlining operational workflows.
3. Collaborated with product owners to gather and document comprehensive functional requirements.
4. Integrated Azure Data Factory pipeline triggers with Stonebranch for automated workflow execution.
5. Designed and orchestrated workflows using the Stonebranch Enterprise Tool to optimize business processes.
6. Managed secure file transfers to and from external parties using the Jscape SFTP tool, ensuring data integrity.
7. Configured job failure alerts within Stonebranch to proactively monitor and address issues.
8. Developed Python scripts to create and implement universal templates, enhancing workflow automation.
9. Created Python scripts tailored to specific business requirements, and scheduled them for execution via Stonebranch.
10. Proficient in implementing Continuous Integration and Continuous Deployment (CI/CD) pipelines using Azure DevOps.
11. Extensive experience in SDLC processes and Azure methodologies to drive efficient software development and deployment.
12. Collaborated in change management activities, working closely with change managers and the Change Advisory Board (CAB) to ensure seamless transitions.