Swapnil Nirgude

"Experienced Power BI Developer with Strong SQL Server Skills"

Immediate Joiner! A Professional having 2 years of IT experience as Power BI developer. Creating and deploying interactive Dashboard and Reports. Having knowledge of SQL Server, Advanced Excel, ETL, Data Modelling, DAX, KPI, Data warehouse, schema's.

2 Years of Experience in Power Bi with global team and major Expertise in Power BI, Data Warehousing concepts. Power BI Development: Expertise in designing, developing, and implementing Power BI reports and dashboards. SQL Server: Advanced knowledge of T-SQL, SQL Server administration, and optimization techniques. Strong knowledge of SQL Server, including writing complex SQL queries, stored procedures, and working with large databases, Proficient in T-SQL, the proprietary SQL language used by SQL Server, for data manipulation and retrieval operations. Data Warehousing: Knowledge of data warehousing concepts and experience in implementing data warehousing solutions. ETL: Proficiency in data extraction, transformation, and loading (ETL) processes using SSIS and other tools. Worked on various types of transformations that are available Power Query. Have knowledge of parameters, appends, merge, filtering, referencing, duplicating tables and other functionalities in the query editor Experienced in data analysis and/or modelling efforts in partnership with solution architects, data scientists and data engineering teams Knowledge of T-SQL and ability to create and maintain Joins, stored procedures, views, and functions. Having a Knowledge of Advanced Excel with Basic formatting commands, Conditional and customer number formatting, Data transformation option, Formulas and functions, Text, Logical, Lookup and Reference, Statistical, Date & time, Pivot table and Charts etc. Work with Business and Product Owners to translate the Functional requirements into Data requirements and system Connecting data sources, importing data, and transforming data for Business intelligence Expert knowledge using advanced calculations using MS Power BI (Aggregate, Date, Logical, String, Table) Good at creating different visualizations using Bar Chart, Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. Experience in Custom Visuals and Groups Creation. Experience in Data Gateway for data refreshing, content Pack Library. Extensive knowledge in Data analysis, Designing Interactive Dashboards/Reports and Data Modelling of Star Schema and Snow Flake Schema patterns. Proficient in making DAX Queries in Power BI desktop with strong quantitative knowledge and attention to detail. Develop dashboards/reports in accordance with client requirements using Power BI. Participate in Scrum meeting to discuss about project progress report every day Familiarity with the latest advancements in Power BI and SQL Server, and commitment to staying up-to-date with these technologies. Data Analytics: Ability to analyze and interpret data and provide insights and recommendations to stakeholders. Cross-functional Collaboration: Ability to collaborate with cross-functional teams to deliver high-quality, data-driven solutions. Communication Skills: Excellent written and verbal communication skills for presenting findings and insights to stakeholders. Time Management: Ability to prioritize tasks and meet tight deadlines in a fast-paced environment. Attention to Detail: Strong attention to detail for ensuring data accuracy and consistency. Problem-solving: Ability to analyse and resolve performance issues and ensure data integrity and consistency. Adaptability: Flexibility to adapt to new technologies and tools as needed. Continuous Learning: Commitment to staying up-to-date with the latest advancements in Power BI and SQL Server. Technical Writing: Ability to create technical documents, such as data dictionaries and user manuals. Team Player: Ability to work well in a team environment and contribute to a positive team culture. Project Management: Experience in managing projects from conception to completion. Customer-focused: Ability to understand and prioritize customer needs and provide exceptional customer service.

B.A Economics 

Savitribai Phule Pune University 

completed - 2020