Anish Ansari

Anish Ansari

Data Analyst
United States of America

About Me

Having 4+ Years of Experience as a Data Analyst. Successfully completed DP-500 Microsoft certification. Good knowledge and experience of Database Design, Development and Business Intelligence of Microsoft SQL Server. Ext…

Experience

Consultant

TREDENCE ANALYTICS SOLUTIONS PRIVATE LIMITED
Dec 2020 - Present · 5 years 7 months

Business Intelligence Developer with 4+ years of IT experience with expertise in analysis, Design, development and implementation of data warehouses, datamarts using Power bi, ETL tool (SSIS) and RDBMS like MS SQL Server, Azure Sql.
Experience in developing & publishing power bi reports with different data visualizations like Line, bar, pie, Histogram, Table, Matrix, Scattered chart, Funnel, Maps, bullet, etc and by creating both calculated columns and measures by using DAX.

Extensive experience on loading data from multiple sources to SQL by using SSIS ETL tool.

CLOROX
Present

Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Created VISTA Canada DOS & PPD DOS Power BI reports.
Creating calculated columns and measures by using DAX.
Implemented dynamic row level security to restrict unauthorized access of report.

Havells India pvt ltd
Dec 2026

Requirement gathering and creation of mapping document.
Data modeling and data security implementation.
Preparing sales, finance and other kinds of reports on Power BI.
Creating calculated columns and measures by using DAX.
SQL Server Integration Services (SSIS) for ETL.
Created stored procedures in SQL for SSRS reports.
Gathering requirement and applying logics for the reports.
Currently working on SQL Server 2016 and Visual Studio 2015.
Performed data updation by using SQL Server Integration Services.

Walmart
Oct 2026

Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Built Customer Experience Explorer report on Power BI.
Creating calculated columns and measures by using DAX.

Wonder Cement Ltd
Sep 2026

Requirement gathering and creation of mapping document.
Data modeling in SSAS Tabular.
Preparing sales, finance and other kinds of reports on Power BI.
Creating calculated columns and measures by using DAX.
SQL Server Integration Services (SSIS) for ETL.
Created stored procedures to load data from AX Dynamics to SQL DWH.
Gathering requirement and applying logics for the reports.
Worked on SQL Server 2016 and Visual Studio 2017.
Performed data updation by using SQL Server Integration Services.

EdgeWell Personal Care

Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Built Promax Insight report for two regions i.e., ANZ and NWE in Power BI.
Creating calculated columns and measures by using DAX.
Created daily sales report using Report Builder and scheduled auto mailer.

Skills

Data Scraping Full Stack Development Data Analysis and Reporting Data Analysis Database Design Business Intelligence Microsoft SQL Server SQL ETL SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) SQL Server Reporting Services (SSRS) PowerApps Power BI Power Query Power Pivot Power BI Report Builder DAX ADF Stored Procedures Views Joins Lookup Derived Column Conditional Split Sort Data Conversion Union All Merge Join OLE DB Command Data Modeling Data Security Report Builder Tableau Visual Studio Windows Microsoft Certified: Azure Enterprise Data Analyst Associate Interpersonal Skills Communication Skills Team Player Self-motivation Initiative Problem Solving
Report this Profile?