Mohsin Tamboli

Client : Damen Shipyards

• Analyzed user requirements, designed and developed orchestration pipelines to load enterprise data into the Data Warehouse in Azure Data Factory.
• Connected to the different sources like Salesforce, SAP, SQL Server, MySQL, Oracle, REST APIs using linked service in Azure Data Factory.
• Analyze the data of different source, to check the possibilities of delta load and full load.
• Created different datasets for different data sources in ADF.
• Extracted data from different sources, cleaned and transformed using different activities and mapping dataflow in adf.
• Created SQL views in Azure Synapse Analytics on top of data loaded in ADLS GEN2.
• Used Azure DevOps repos to store view scripts to move higher environment.
• Used Azure DevOps CI/CD pipelines to move created views objects and pipelines to higher environment.
• Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.

Client : Royal Bank of Scotland

• Created orchestration pipeline to copy data from one location to azure storage.
• Monitor the orchestration pipelines which are already running.
• To fetch daily updating data in SQL server from higher environment to the dev environment.
• Good knowledge of Hadoop ecosystem, hive, pyspark as got trained in organization.
• Good understanding of spark framework, RDD, dataframes, transformations and actions on RDD and dataframe, DAG, RDD persistence etc.
• Worked with different file formats like CSV, JSON, Parquet, ORC to load data in spark dataframes.

Client : HDB Financial Services Pvt. Ltd.

• Installation & Configuration of SQL Server 2014 and 2017.
• Create user and assign permissions base on the level of database access the user would need.
• Good experience in configuring and troubleshooting of Log Shipping.
• Expertise in extracting and transforming data using data transformation services like import/ export wizard.
• Installation SSRS Report Builder and creating report as per requirements.
• Created linked server from SQL to SQL, SQL to ORACLE, SQL to MYSQL.
• Experience in Scheduling and Configuring SQL Server agent Jobs, Alerts, operators and Database Mail Configuration.
• Backup and restore on daily, weekly and monthly basis of SQL Servers.
• Creation of Logins and Role
• Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like, Database complete backup, rebuilding indexes, Drill Activity)
• Design database backup and restoration Strategy.
• Performed DR drill activity
• Monitoring the server for High availability of the servers