Priyanka Gohain

Key Responsibilities:

• Working in Azure infrastructure with Microsoft Premier SQL BI customers on break fix and advisory issues.
• Working on migration of SQL Server on-premises BI solution to Azure platform.
• Implementing performance tuning of Analysis Services tabular models to improve processing and query execution times.
• Automating Azure Analysis Services tasks using Azure Data Factory pipeline, Azure Runbook, Azure Function and Logic Apps, PowerShell script.
• Experience in SSRS, Paginated reports and Power BI On-premises Data Gateway application.
• Collaborating with Customer Account Managers while on boarding new customers to Azure platform.
• Conducted technical triages on performance tuning and troubleshooting issues including Analysis Services whitepapers.
• Trained in Microsoft Fabric - Power BI workload.
• Contributed to Analysis Services documentation and trainings for Microsoft employees as SME.

Key Responsibilities:

• Developed SSIS packages to extract, transform and load data into SQL database from source SAP systems.
• Developed Power BI reports and experienced in using DAX functions for creating measures and calculated columns in Power BI.
• Provided data analytics insight to Sales and Logistics team of India business for optimizing sales and focusing on growth.
• Collaborating with SAP Consultants and Business Analyst to understand business requirements.
• Initiated two POC projects on creating predictive models for Sales forecast and Inventory Management using Python.

Key Responsibilities:

• Developed SSIS packages and SSRS reports for multiple Accenture projects.
• Experienced in SQL database design and SQL programming (creating procedures, views, functions, indexes, Cursors, CTEs, Merge concepts).
• Worked within project planning constraints and identified risks beforehand to avoid delays and complete builds within given timelines.
• Created Functional Design Document and Technical Design Document.
• Prepared Unit Test Cases and collaborated with Testing/Support Teams during UAT and rollout phases of project.