Anshul Acharya

Professional Experience

• Having 2 year experience as a Power BI Developer and Data Analyst in Microsoft Power BI.
• Experienced on ETL (Extract, Transform, Load) Framework.
• Experienced on extracting data into power BI Desktop from various sources like SQL server, Excel, CSV file using direct query mode.
• Experience in writing DAX function
• Expert in publishing Power BI Reports of Dashboard in Power BI server and Scheduling the dataset to refresh for upcoming data in Power BI server.
• Experience on Microsoft BI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI desktop, Power BI service).
• Document process, models, designs using schemas and solutions and able to explain, represent and discuss with the team.
• Built Dashboards and Reports to meet the need of the business, gathering all appropriate requirements.
• Experience in creating Visual using basic Line/bar chart, tree chart, funnel, custom column charts etc., also used custom charts like tornado chart, sankey chart.
• Used My sql server database development in creating tables, writing queries, views,constraints.
• Good knowledge of DDL,DML,DCL.
• Solid understanding of SQL joins(Inner joins, Left joins,
• Right joins and full join).
• Imported custom visuals as per requirements like sankey chart, Tornado chart, Aster plot.

Project Experience

Client: All client across Affimintus Technologies and Internal Projects

Role: Team Member (PowerBI Analyst)

Technologies used: Power Platform (Power BI, Power apps), SQL Server

#Project 1: Silver Finance Solutions Private Limited

Description: Silver Finance Solutions Private ltd is a listed public company incorporated on 29- 07-2015. It is classified as a private limited company and is located in Indore.

Role:

• Involved in gathering the requirements from the clients, understanding them .
• Verify the data is transformed correctly according to business requirements .
• Created the reports using charts like Pie, Bar, Line, etc.
• Created Dashboard and shared with the business users .
• Developed User Interactive Reports satisfying the business needs .
• Worked on On-premises gateway to refresh the data sources .
• Used DAX Expressions in Power BI
• Experience in Power BI Service Admin Activities, creating workspaces and maintaining accesses

#Project 2: Nationwide Car Insurance Company

Description: Nationwide offers home insurance, auto insurance, life insurance and more to fit budget and needs.

Role:

• Understanding source systems and customer requirements .
• Created the reports by using visualizations and Dashboard with SQL Server as the data source.
• Used DAX expressions like Filter, Logical and Aggregations functions.
• Published the reports through apps sharing the apps with the end users.
• worked on Power BI Personal Gateways and On-premises Gateways .
• Used Bookmarks, Sync Slicers and Edit Interactions .
• Used Merge and Append queries.
• Developed Power BI reports and dashboards using Power BI Desktop and published it to Power BI service .
• Interacted with leadership teams to understand the requirements and provided the solutions with minimum efforts Interacted with the existing database developers and DBA to understand the existing schema.

#project 3: Neo Genomics Laboratories

Description: NeoGenomics is a leader in precision oncology testing, empowering healthcare experts to optimize patient care.

Role:

• Understanding source systems and customer requirements .
• Created the reports by using visualizations and Dashboard with SQL Server as the data source
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.
• Creation of various Visualizations such as bar graphs, scatter plots, pie-charts, and geographical visualizations.
• Generated context filters and data source filters while handling huge volume of data.
• Built Dashboards for measures with forecast, trend and reference lines