Over 10+ years of experience in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects on MSBI/PowerBI/Azure Data solutions. Hands on experience with Azure Data Factory, Power BI, Alteryx, Tableau Desktop, Tableau Reader and Tableau Server. Building up the automation pipeline for data flow from various sources Splunk, Hadoop to Oracle using Azure Data Factory. Hands on with building groups, hierarchies, parameters and sets to create detailed level summary reports and dashboards in PowerBI. Experience on Azure data Lake Storage, Azure SQL Database, Azure Databricks, Azure Logic Apps and Azure Data Factory using Azure Portal. Distributed Tableau reports using techniques like packaged workbooks, pdf, ppt slides through images, scheduled reports to authorized user community. Implemented Incremental loading in ADF pipelines for data ingested from various data sources like MS SQL ServerSQL Server, Splunk, Hadoop and Rest API’s.Rest API’s and Hadoop. Experience in extraction of data and setting up ETL processes from various sources (SQL servers, Hadoop – hive, Impala) and combining them for analysis into Tableau. Knowledge on labelling, annotations, data blending, data extract, publishing & re- using the data sources, quick filtering, applying filter and actions, setting up complex hierarchical structures, conditional formatting, grouping the rows and custom coding titles & captions. Design, develop ETL workflows and datasets in Alteryx (extensive use of macros and Alteryx gallery). High utilization of Alteryx gallery (schedule workflows) for end-to-end automation – from data gathering to data visualization. Used ACS (Alteryx connector for SAP) and salesforce connector extensively in Alteryx to extract data from SAP platform and put it in usable format for data analysis. Used SQL and SAS language for data extraction using In-DB tools and SAS sasb7dat archives.
Consultant with more than 9.7 years of cross-industrial experience in construction, engineering & healthcare. Highly experienced in design, development, implementation and maintenance of Business Intelligence apps. Experienced in data mining large data sets of structured and unstructured data, Data Acquisition, Data Modelling, Data Visualization and Enterprise Data Warehousing.