Shivakaran Puramachety

Client: ATRIUM INNOVATIONS: Created Data warehouse on Azure SQL Database by integrating different sources like Salesforce, Magento, Jira and JDE. Worked on creating the CI/CD release Pipeline in Azure Devops to deploy the Data Factory JSON script from Dev to Prod. Worked on Azure functions to get the data from Graph API, Jira API using Python. Used Jira in work management and also integrated it with data warehouse and built Power Bi dashboard to help clients understand the workload of their employees. Worked on developing Power BI dashboards related to revenue, inventory, coupon sales etc. Worked on optimizing Analysis Server Data models to reduce the client cost for Azure cloud servies. Client: JUST FOOD FOR DOGS: Worked on building pipelines to Extract, Transform and Load data into data warehouse from sources like Blob storage, Mysql Database, Sharepoint using Azure Datafactory. Understood the business requirements of these clients and created the reporting tables using raw data tables from different sources. Client: CLEAR STAR: Created Analysis Services Tabular Data Models and deployed them in Azure Analysis Services. Automated Data model daily refresh using Azure Data Factory. Worked on developing Power BI dashboards related to revenue depending on client requirements. Client: VORY'S: Created Data warehouse on Azure SQL Database and Azure Synapse by extracted data by Blob Storage, API, Salesforce. Created Databricks Notebook using python for cleaning and uploading data to delta lake. Worked on Azure functions to get the data from Jira API using Python. Created Reporting tables by understanding the business context from the warehouse built.