● Having 7.5 + years of Professional experience in IT Industry with 2 years expertise in B2B Integration using Sterling B2B Integrator 5.2.2/5.2.4/5.2.5/6.1.2 , SSIS packages 2015, 2019 and Experienced Power BI Developer with 4+ years of experience in gathering data from various sources and transforming it into insightful reports and dashboards.
● Proficient in data modeling and integrating reporting components from multiple data sources.
● Expertise in importing data from multiple data sources into Power BI, created relationships between various data sets in power pivot.
● Translated business KPIs into tech specifications and DAX formulas.
● Experienced in developing Power BI reports and dashboards from various Data Sources like Databases (SQL, Teradata), and Excel files.
● Having knowledge in calculated columns, measures, relationships and transformations.
● Having experience in creating Filters like Visual level, page level, Drill through and Report level in Power BI.
● Having good experience in creating Parameters, Sorting and Grouping.
● Good Knowledge in identifying relationships between different aggregates and attributes.
● Experience on sharing reports, gateways, creating content packs and scheduling refreshes, solution for troubleshooting of tiles, reports, dashboards.
● Having knowledge in Query Folding.
● Created Joins by combining tables, Created Column Elements from available data sources and Created Filter elements to limit the data retrieved.
● Implemented role-based security as part of user level security in Power BI.
● Collaborated with cross-functional teams to optimize data visualization and enhance decision-making processes.
● Power BI: Created complex data models, visualizations, and custom measures
● SQL: Proficient in writing SQL queries for data extraction and transformation
● Data Modeling: Designed efficient data models for large datasets
● ETL: Extracted, transformed, and loaded data from various sources
● Data Visualization: Developed interactive dashboards and reports
● DAX Formulas: Created calculated columns and measures
● Excel: Spread sheet application used for storing, organizing and Manipulating data
● SSIS: SQL Server Integration Services to perform ETL operations