NITYAM JOSHI
+91-789******* **************@*****.***
P R O F I L E S U M M A R Y
Power BI Developer with 4 years of experience in designing dashboards, data models, and BI solutions across Finance, Banking, and Healthcare. Skilled in DAX, SQL, Power Query, RLS, and Azure Data Lake. Proven track record of improving reporting efficiency and delivering actionable insights for business growth. E X P E R I E N C E
4 years of experience as Power BI Developer in Tech Mahindra, Pune contracted through Platify Technologies Pvt Ltd, Bangalore from August 2021 to till date. S K I L L P R O F I L E
Primary Skills : Power BI Desktop, Power BI Service, Power BI Report Builder, DAX, M- code.
Database : SQL Server 2012/2016/2019, OData, Flat files, Teradata, Azure Databases, My SQL Server, PostgreSQL Server. ETL Tools : Power Query Editor
Reporting Tools : Excel, Power BI Desktop, Power BI Report Builder Analysis Tools : Power Pivot
Programming languages : SQL, T-SQL, DAX, M-Query
Operating systems : Windows 11, 10, 7, XP, Windows Server 2012/10. S O F T S K I L L S S U M M A R Y
Extensively Interacted with Clients directly.
Quick learner, always eager to learn.
Interacted with clients directly.
Ability to develop and execute projects on time and work under high-pressure.
A strong believer in teamwork.
Keen to know the reason to follow some rule.
.
P R O J E C T S D E T A I L S
Project # 1:
Industry : Finance
Client : Equiniti
Environment : Power BI Desktop, Power BI Service, Oracle Server, MS SQL Server, OData, API’s, Share Point, Azure Data Lake, Git & Microsoft 365. Role : Power BI Developer & Admin
Duration : January 2024 to till date
Roles and Responsibilities:
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta and history loads.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Extensive use of DAX (Data Analysis Expressions) functions for the reports and for the tabular models.
Experience in scheduling refresh of Power BI reports, hourly and on-demand.
Load the processed data into final view point centralized DWH for further Power BI reporting. Project # 2:
Industry : Banking
Client : Sasfin
Environment : Power BI, Power BI Service, Teradata, Azure Cosmos DB, Microsoft 365, Excel, SQL Server 2012/ 2016, Oracle Server & Flat files. Role : Power BI Developer
Duration : July 2022 to January 2024
Roles and Responsibilities:
To develop user interface design and usability of the visualization. Use of graphic design skillsets, ensure accessibility, and color aesthetics align with organizational requirements.
Implemented Visual Level, Page level, report level filters and pinning in dashboards.
Written DAX calculation as per the requirement to maintain business measures.
Worked on report permissions and dashboard permissions to provide access to different users.
Attend daily standup meeting for reporting.
Project # 3:
Industry : Healthcare
Client : Vitaldent
Environment : Power BI Desktop, Power BI Report Server, Windows Server MS SQL Server 2016/2019, Share Point Online, Flat files, Role : Power BI Developer
Duration : August 2021 to July 2022
Roles and Responsibilities:
Generated periodic reports based on the statistical analysis of the data from various time frame and division using power pivot, power query, power view.
Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
Created data marts and multi-dimensional models like Star schema and Snowflake schema.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries.
Apply the Business rules on the data coming from multiple operating companies. Maintain the business rules in a table for visibility to all required processes to develop Power BI reports & effective dashboards. E D U C A T I O N
B.Tech, Mechanical Engineering
Shivajirao Kadam Institute of Technology and Management, Indore (M.P.) 2017-2021 XII – CBSE
Paramount Academy, Barwani (M.P.) 2016-2017
X – CBSE
St. Mary’s English Medium School, Barwani (M.P.) 2015-2016 P E R S O N A L D E T A I L S
Name : Nityam Joshi
Year of Birth : 03- 08 -1998
Gender : Male
Marital status : Single
Nationality : Indian
Languages : English & Hindi
Current city : Pune
D E C L A R A T I O N
I hearby declare that the above information given by me is correct on the basis of best of my knowledge.
Place: Pune Nityam Joshi