Experience

Mfinity

• United States
• Marketing Services
• 1 - 100 Employee

• Power BI Developer

  • Mar 2023 - Sep 2023

  Dublin, County Dublin, Ireland • Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI Desktop • Understand operational dashboards, business performance dashboards, interpret the results and summarize opportunities for improvement and make recommendations to senior leadership. • Experience using Power Query for data transformation and written effective DAX formulas and expressions. • Designed and developed new ETL/SSIS package… Show more • Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI Desktop • Understand operational dashboards, business performance dashboards, interpret the results and summarize opportunities for improvement and make recommendations to senior leadership. • Experience using Power Query for data transformation and written effective DAX formulas and expressions. • Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements. • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis. • Worked with table and matrix visuals, different filters like report level, visual level, page level filters, designed tabular model reports to slice and dice huge volumes of data. Show less



AFour Technologies

• India
• Software Development
• 300 - 400 Employee

• Data Analyst(Grade 4)

  • Feb 2021 - Jun 2022

  Mumbai, Maharashtra, India • Create, analyze and distribute ongoing reports as needed by key stakeholder by turning multiple data sets into valuable and interactive insights. • Utilized Power BI (Power View) to create various analytical dashboards that depicts KPIs such as profit margin, client retention rate, revenue per client along with slicers and dicers enabling end user to make filters. • Worked in creating complex stored procedures, SSIS package, triggers, cursors, tables, views and other SQL joins and… Show more • Create, analyze and distribute ongoing reports as needed by key stakeholder by turning multiple data sets into valuable and interactive insights. • Utilized Power BI (Power View) to create various analytical dashboards that depicts KPIs such as profit margin, client retention rate, revenue per client along with slicers and dicers enabling end user to make filters. • Worked in creating complex stored procedures, SSIS package, triggers, cursors, tables, views and other SQL joins and statement for the applications. • Wrote SQL queries to extract data from various databases such as My SQL Server along with creating and editing SQL queries. • Strong communication and facilitation skills with the ability to communicate at all business levels and lead requirement definition workshops. • Created databases and schema objects including tables, indexes and applied constraints. • Integrate and curate data from a wide range of internal and external sources to develop detailed reports and dashboards. • Designed an Extract-transform-Load to load 25Tb of data into a date ware-housing using SQL Server Integration service (SSIS). Show less



AFour Technologies

• India
• Software Development
• 300 - 400 Employee

• Data Analyst(Grade 5)

  • Jun 2016 - Dec 2018

  Mumbai, Maharashtra, India • Developed SQL scripts/queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregation. • Explored data in a variety of ways and across multiple visualization using Power BI, strategic expertise in design of experiment, data collection, analysis and visualization. • Data cleansing and analysis, using pivot tables, formulas (V-Lookup and others), data validation, graph and chart manipulation in MS Excel. • Designed Power BI… Show more • Developed SQL scripts/queries to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregation. • Explored data in a variety of ways and across multiple visualization using Power BI, strategic expertise in design of experiment, data collection, analysis and visualization. • Data cleansing and analysis, using pivot tables, formulas (V-Lookup and others), data validation, graph and chart manipulation in MS Excel. • Designed Power BI data visuals utilizing cross tabs, maps, scatter, pie, bar and density charts. • Report data and insights to clients and ensure they can make informed and strategic decisions based on data extracted. • Generated ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning. • Helped in making changes in SQL Data base that decreased the risk of data-corruption. • Utilized sets, groups, different types of filters, joins, tree maps, heat maps, dual axis etc. in Tableau. • Experience and continued interest in using SQL across various data sources and environments. Show less