Rohit Joshi

Project Name: Nimbus Tech Transformation

• The scope of this project is to migrate the existing on-premise legacy database (SQL database) to the cloud (Snowflake) and optimize, as well as eliminate, the existing redundant processes.
• Around 50 vendors' data, which is processed into common dimensions, hierarchies, and fact tables.
• Using Snowflake stage and external table, we have pulled data into Snowflake, where we are performing ETL operations in Snowflake.

Project Name: ORION

• The scope of the project is to provide better visibility to the end user in terms of prescription and market share owned by the prescriber by onboarding different drugs in different fields.
• It is part of the Nimbus tech transformation project and provides more flexibility to businesses to understand the process and help them provide better solutions.

Key Responsibilities:

• Gathering the requirements from the business and providing an efficient and cost-effective approach to achieve them.
• Handling the end user on a daily basis and making sure to understand their problems and support them.
• Developed a data quality framework and control checks to help users provide the correct data during the weekly refresh process.
• Handled complex problems and issues by understanding root causes and implementing solutions.
• Due to high dependency on users and a huge volume of data, I am capable of handling pressure and fixing the issue within the timeline.

Project Name: Finance Transformation

• Scope of this project is to integrate with all the identified general ledger systems and consolidate them into a global data model.

Key Responsibilities:

• Implemented Snowflake stage, external table, procedure, data masking, clustering, data sharing, materialized and secure view and many other features of snowflake to achieve the customer requirement
• Analyzing the data received on monthly basis and finally sharing the profit, cost of sale, expense received on monthly basis to business with the help of Tableau report.