Nov 2023 – Jan 2025 · 1 yr 2 mos · Pune, Maharashtra, India · Hybrid

• 𝐃𝐞𝐩𝐚𝐫𝐭𝐦𝐞𝐧𝐭: Supply Chain Analytics
• 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐲: FMCG US
• 𝐏𝐫𝐨𝐣𝐞𝐜𝐭: Data Migration using Snowflake
• 𝐑𝐨𝐥𝐞𝐬 & 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
• Designed and implemented a data warehouse involving various data sources such as CSV files, JSON, and XML using Snowflake Data Warehouse.
• Copying the data from storage account to snowflake staging layer using integration object and using SnowPipe to query the data automatically into the Gold Table.
• Worked with finance team to identify data requirements and provide data insights to stakeholders.
• Created SQL Scripts for the schema creation of tables and auditing of data movement.
• Creation of Supply Chain Report using Power BI for the business to track the inventory value and volume on weekly and monthly.

Jan 2023 – Oct 2023 · 9 mos

• 𝐃𝐞𝐩𝐚𝐫𝐭𝐦𝐞𝐧𝐭: CoE Team
• 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐲: Oil and Refinery US
• 𝐏𝐫𝐨𝐣𝐞𝐜𝐭: SAP Data Migration using Azure Synapse & Power BI
• 𝐑𝐨𝐥𝐞𝐬 & 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
• Migrated the existing SAP tables to Azure ADLS using Azure Synapse CDC Connector.
• Designed, developed & implemented data pipelines for ingestion, processing & analysis using Synapse.
• Optimized ETL processes to improve data processing performance and reduce processing time.
• Data movement from Raw Zone, Consolidated Zone and Consumption Zone using Copy Activity.
• Transformation of data using Notebooks in Azure Synapse with the help of PySpark.
• Worked with cross-functional teams to identify data requirements and provide data insights to stakeholders.
• Created SQL Scripts for schema creation of tables and auditing of data movement.
• Built Power BI Reports on the migrated Finance data.
• Provide guidance and support to other team members on Azure data management best practices and techniques.

Feb 2022 – Dec 2022 · 10 mos

• 𝐃𝐞𝐩𝐚𝐫𝐭𝐦𝐞𝐧𝐭: CoE Team
• 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐲: Finance
• 𝐏𝐫𝐨𝐣𝐞𝐜𝐭: FinOps Dashboard using Azure Synapse & Power BI
• 𝐑𝐨𝐥𝐞𝐬 & 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
• Explicitly worked on identifying and consolidating subscriptions cost data from Azure Portal using cost management API's and ingesting into ADLSv2, further used Azure Synapse pipelines for performing ETL process.
• Also created a Synapse Pipeline for getting the Activity Logs from Azure Monitor and storing it in ADLS.
• Created view on top of the curated data, connected to Azure Synapse and imported the data into Power BI environment. Regressively worked on data cleaning and data modelling related tasks.
• Created reports in Power BI Desktop with various visuals and publishing them to Power BI service to monitor costs on a day-to-day basis.
• Applied Row Level Security, Data Sharing Policy, Scheduled Refresh, Bookmarks, Drill Down, Drill Through, Action enabled Buttons, Q&A feature (NLP), Power BI Theme, along with the Definition Tab and details.

Nov 2020 – Jan 2022 · 1 yr 2 mos

• 𝐃𝐞𝐩𝐚𝐫𝐭𝐦𝐞𝐧𝐭: CoE Team
• 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐲: Europe Retail Client
• 𝐏𝐫𝐨𝐣𝐞𝐜𝐭: Competitor Insights Dashboard
• 𝐑𝐨𝐥𝐞𝐬 & 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬:
• Gathering Business Requirements from client and recognizing the KPIs with objectives.
• E2E designing, creating and implementing interactive visual reports using Power BI tool.
• Created a Semantic Layer i.e. a view in SQL Database.
• Connected with SQL Database to get the data in the Power BI environment and transformed Data using Power Query Editor.
• Developed Report with KPIs comparing retailer to the competitor prices i.e. Count of
• Expensive, Cheaper and Same Price Items, Price Gap %, Monthly Trend in Price Change, Count of Matched and Unmatched Items etc.
• Enabled 30% manual efforts savings by providing a detailed view page to the client with all the calculations.
• The report helps client to decide the Price Change Strategy when compared with Competitor.

Jan 2020 – Apr 2020 · 3 mos · Pune, Maharashtra, India