Working with Multiple Customers to understand their data, study existing flow and relationships, bring over the Legacy Data into Hyland environment using various ETL tools. Cleaning of Data, implementing new logic, loading data into Datawarehouse (both on prem and cloud) and creating reports on top of it as per client requirements.

Developing BI solutions

Database warehouse management: Design and optimization of SQL queries. Monitoring data loads and resolving data related issues. Programming views, stored procedures and functions, and monitoring overall data warehouse performance.SSIS: Experience in High Level Design of ETL Packages for integrating data using different connections from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data etc.) by using different … Show more Database warehouse management: Design and optimization of SQL queries. Monitoring data loads and resolving data related issues. Programming views, stored procedures and functions, and monitoring overall data warehouse performance.SSIS: Experience in High Level Design of ETL Packages for integrating data using different connections from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data etc.) by using different transformations. Experience in providing Logging, Error handling by using Event Handler and Logging for SSIS Packages. Deploying, Monitoring and scheduling the packages. Debugging of SSIS Packages.SSAS: Creating dimensions, measures and calculated measures as per client requirements. Optimizing processing time by using partitions in multi-dimensional cubes. Experience in deploying and processing multi-dimensional cubes over different environments. Experience in handling tabular cubes.Power BI: Expertise in developing reports and dashboards using Microsoft Power BI. Expertise in working with power BI Service and Power BI Desktop. Experience in working with creating conditional formatting, Filters, calculated columns and measures in Power BI. Comfortable in working with filters/calculated columns/measures/relationships and transformations of edit Query section. Having Knowledge writing DAX in Microsoft Power BI Desktop.Incident management: Understanding issues reported by business analysts, short term and permanent solution for issues reported in a timely manner. Perform root cause analysis and carry out resolutions Monitor the data flow from Source systems through ETL tool SSIS and fix data and platform related issues. Show less