Aman Goswami

• Involved in analysis, design documenting business requirement and data specifications. Supported data warehousing extraction program, end-user reports and queries.
• Interacted with Business Analysts to understand data requirements to ensure high quality data provided to customer.
• Worked on numerous ad-hoc data pulls for business analysis and monitoring writing SQL-Scripts.
• Built SQL complex queries for accessing and extracting data using MySQL and MS SQL Server.
• Constructed dashboard and ad-hoc reports Excel and Power BI.
• Perform verification and validation for accuracy of data in the monthly/quarterly reports.

Collaborated with Subject Matter Expert and Product Owners to define a data requirements and source-to-target mapping necessary to support advance analytics initiatives M&SC (Manufacturing and Supply Chain), including the interfaces between applications, database and platform.

Made Power BI reports more interact and activate by using storytelling features such as bookmark, selection panes, drill through filters.

Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform data.

Converted the boulder tables from excel to Power BI with better graphs and visualization for the understanding and improvement of business.

Used DAX to create custom calculations in PowerPivot for Excel workbook.

Worked on Power BI reports using multiple types of visualization such as doughnut chart, line charts, tables, matrix, KPI, scatter plots etc.

Utilize Power BI TO CREATE various analytical dashboard that helps business users to get quick insight of the data.