Summary
Overview
Work History
Education
Skills
Projects
Languages
Certification
Timeline
Generic

Soumyadeep Ghosh

Halifax,Canada

Summary

I have 14+ years in Software development, Data architecture, Data warehousing, Business Intelligence and analytics, Business analysis, Project Management and Training & Knowledge Sharing. Deft in software development activities entailing requirement gathering, coding, testing, deployment, technical documentation, etc. A team player with strong communication, analytical, logical and problem-solving skills. Ability to work under pressure situations and meet deadlines. Experience in Informatica Cloud Service (ICS - DI, DBMI, AI). Has ability in creating a process that can be invoked from a REST Client and has ability to work with Salesforce Objects in Informatica Cloud Real Time. Also has ability in creating a guide, invoke sub-process and create opportunity in SFDC. Completed trainings on Informatica Cloud and Real time through Informatica Cloud Academy. Certified as AWS Cloud practitioner and google cloud digital leader. Focused Project Manager adept at planning, directing and maintaining continuous operations in various departments. Experienced in directing manufacturing employees and keeping efficient production in accordance with quality standards. Applying creative and analytical approach to operations for continuous process improvement. Skilled at identifying or anticipating problems and providing solutions. Excels through mentoring, training and empowering team to excel in performance.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Manager – Projects

Cognizant Technology Solution ltd
09.2016 - Current
  • Offshore/Onshore ETL lead for the overall project
  • Involved in Data model designs
  • Implementation and management of data warehouse and data marts in starschema/snowflake models.
  • SPOC for all stake holders and Client. Responsible for solution design for data integration.
  • Analyze business requirement with various stake holders and create detail design to share with the development team for development, enhancement and maintenance
  • Developed ETL codes and unit test documents for business problems defined as scope within the project
  • Attend Scrum calls and define the goals and metrics for each sprints
  • POC for UAT checkpoint with business stake holders
  • Maintaining Data Quality checks through appropriate Data quality tool across all environments
  • Maintaining Information security control through a consistent documented process of data managements
  • Create and review all required Knowledge documents required for the project
  • Create and share WSR/MSR with all stake holders
  • Peer review of code and test documents leveraging various cognizant tools and platforms.

Technical Lead

Capgemini India ltd
04.2014 - 08.2016
  • Offshore ETL lead for the overall project
  • SPOC for all stake holders and Client
  • Analyze business requirement with various stake holders and create detail design to share with the development team for development, enhancement and maintenance
  • Developed ETL codes and unit test documents for business problems defined as scope within the project
  • Attend Scrum calls and define the goals and metrics for each sprints
  • POC for UAT checkpoint with business stake holders
  • Maintaining Data Quality checks through appropriate Data quality tool across all environments
  • Maintaining Information security control through a consistent documented process of data managements
  • Create and review all required Knowledge documents required for the project
  • Create and share WSR with all stake holders
  • Peer review of code and test documents leveraging various cognizant tools and platforms.

Senior Systems Engineer/Systems Engineer

Infosys ltd
02.2010 - 04.2014
  • Offshore ETL lead for the overall project
  • SPOC for all stake holders and Client
  • Analyze business requirement with various stake holders and create detail design to share with the development team for development, enhancement and maintenance
  • Developed ETL codes and unit test documents for business problems defined as scope within the project
  • Attend Scrum calls and define the goals and metrics for each sprints
  • POC for UAT checkpoint with business stake holders
  • Maintaining Data Quality checks through appropriate Data quality tool across all environments
  • Maintaining Information security control through a consistent documented process of data managements
  • Create and review all required Knowledge documents required for the project
  • Create and share WSR with all stake holders
  • Peer review of code and test documents leveraging various cognizant tools and platforms.

Education

Bachelor of Technology - Computer Science

WEST BENGAL UNIVERSITY OF TECHNOLOGY
04.2009

Skills

  • Informatica PowerCenter (v8 and above), Informatica Cloud Services, Snowflake, AWS EC2, Unix scripting, AWS Redshift, Oracle DB, PostgreSQL, Teradata, MS SQL, SAP BO and WEBI reporting
  • Hands on Google Cloud platform, AWS lambda and AWS S3
  • Agile tools like Jira and Trello

Projects

CustomServicing (October,2023 - Till Date), for a major timeshare client in US

  • The requirement of the project was to built a data integration layer for the legacy Case management data into more insightful snowflake database/data model which can be leveraged for insightful reporting.
  • This project is implemented with Informatica Cloud DI and Mass Ingestion tech stack to integrate the legacy data into saleforce case management module and create a reporting layer in snowflake for end user reporting and audit.
  • Implementation of the project would benefit the sales team and legal team to get near realtime data analysis over current case management data.


Down payment provide (April,2023 - July,2023), for a major timeshare client in US

  • The requirement of the project was integrate newly onboarded down payment provider data into the existing payment warehouse/data marts
  • This project was implemented with Informatica Cloud DI with multi layer of API calls to APIGEE services to get near realtime data on prospects, approval, credit, debit information into the payment mart.
  • Implementation of the project has helped the client to have near real time data available in payment data mart for accurate credit/debit information to be shared with various stake holder and closing GL audits.


Genesis Program (Oct 2022 - March,2023) for a major timeshare client in US

  • Customer was at a critical point with existing enterprise data warehouse after getting segregated from it's parent Group. The entire scope of project was to integrate the client current data into the existing EDM model coming from a new source system OFSLL.

Customer uses Data Warehouse and OAC to store, leverage and get insights from data for Agents, Member, Payment, Charges,Reservation and Contract details.

Following were the key business needs along with Digital transformation

Integrate the payment to Charge model on a details and summary level.

Integrate Snapshot facts and Atomic facts with WD data through multiple transformation and business cases. The challenge was to integrate dimension modelling which was restricted to a star schema.


Languages

English
Full Professional

Certification

  • AZ-900:Microsoft Azure Fundamentals
  • Google Cloud digital leader
  • AWS Certified Cloud Practitioner
  • AWS Migration factory ambasador
  • Informatica - IDMC

Timeline

Manager – Projects

Cognizant Technology Solution ltd
09.2016 - Current

Technical Lead

Capgemini India ltd
04.2014 - 08.2016

Senior Systems Engineer/Systems Engineer

Infosys ltd
02.2010 - 04.2014

Bachelor of Technology - Computer Science

WEST BENGAL UNIVERSITY OF TECHNOLOGY
Soumyadeep Ghosh