Upwork home
Sign up
Secondary
Srinivasa R. Status: Offline
Hyderabad, India

14+yrs of MSBI,SSIS,SSRS,SSAS,PowerBI experience

14+ years in IT having extensive and diverse experience in Microsoft Azure Cloud and MSBI technologies. Have Data warehousing experience in Business Intelligence Technologies and Database with Extensive Knowledge in Data analysis, TSQL queries, ETL & ELT Process, Reporting Services (using SSRS, Power BI) and Analysis Services using SQL Server 2008/2012/2014 /2016/2019, T-SQL, MSBI Tools (SSIS, SSRS and SSAS), SQL Server Worked across diverse locations such as Australia & London for project & business-related issues. Designed and developed the shopper performance dashboards, including modeling, building the fact-and-dimension tables and dashboards using Power BI. Have good experience designing cloud-based solutions in Azure by creating Azure SQL database, setting up Elastic pool jobs and designing tabular models in Azure analysis services. Developed multiple Azure Data Factory pipelines to dynamically copy data into Azure Blob storage as per request. Provided Azure governance (Microsoft Purview) capabilities mechanisms and processes for organizations to maintain control over their applications and resources. Used SQL extensively for database needs in various apps and extensive experience in creating pipeline jobs, schedule. Built subscriptions Power BI dashboards using Azure Synapse, Data Factory, Analysis service and Power BI. Azure DevOps-CI/CD (Continuous Integration and Continuous Deployment) and test-driven develop practices. Expert in creating and developing Power BI Dashboards into rich look. Abilities in Mapping according to the ETL specifications for the Staging Area Data Load & Warehouse Data Load Developed OLTP systems and involved in creating facts, dimensions, Star Schema representation for the data mart. Expertise in Multidimensional OLAP and Tabular OLAP Cubes in SSAS. Experience in developing Dashboard Reports, Parameterized Reports, Linked reports and Sub reports. Expertise in writing complex DAX functions in Power BI and Power Pivot.  Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS. Experienced in all facets of Software Development Life Cycle (Analysis, request for proposal Design, Development, Testing and maintenance) using Waterfall and Agile methodologies. As part of project management have good knowledge of Cost Management techniques involved in projects.
Work history
Srinivasa R. has more jobs. Create an account to review them
Skills

Skills

  • Microsoft Power BI
  • Microsoft Azure SQL Database
  • Microsoft Power BI Development
  • Microsoft Business Intelligence Studio
  • Microsoft SQL Server
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • SQL Programming

Browse similar freelancers