Abhirup Ghosh Email and Phone Number

Data & Analytics team- Data Engineering Projects - Project 1: (Current)Regulatory compliance management solution creation. Creating a managed service solution for a major US investment firm to file the regulatory filings on time without fail. Technology Used: Databricks, Pyspark, MS Azure, PowerBI Project 2:Fincrime - AML rule development to prevent financial crime for a large US bank. The role involves looking at the pattern of huge chunk of data and creating the rules to detect different type of frauds across all the transactions customer make via the bank.Technology Used: PostgreSQL, Hive, Pyspark

• Responsible for project migration of Oracle to Sql Server• Usage of SSIS, SSMA (SQL Server Migration Assistant) in the migration project. • Handles the code conversion of SQL/PL-SQL to T-SQL.• Have used Azure Data Factory for data Ingestion, transformation and loading into Azure Data Lake. • Experience in data lake implementation on ADLS GEN 2• Experience as Data Modeler

• Part of Informatica Powercenter QA Team (Integration Service component in Powercenter Product) • Worked on different releases of Informatica PC latest being 10.2 • Enhanced the automation framework for automating various features of PC (Load Balancer & high availability).

• Part of ETL Informatica Development team. Gathered requirements from onshore/customer. Created HLD/TDS. Working on the deliverables within the timeframe. • Exposure to data analysis for different applications/projects mentioned for ongoing issues in a Timely manner. Worked with the Business Object team closely for reporting requirements. • Involved in enhancement (development and testing) of all the projects’ interfaces.

• Involved in development of all the mentioned projects’ interfaces, necessary code changes, Unit testing, System Integration testing.• Created End to End Mappings using various ETL transformations.• Involved in Performance tuning.• Involved in code Deployment for other environments.