Power Bi Developer

*

Manish Samadhan Vanjari

Pune, Maharashtra +91-885**-***** **************@*****.*** linkedin.com/in/manish-vanjari/ PROFESSIONAL SUMMARY:

Power BI Developer with 2.5 years of experience in designing and deploying interactive BI solutions across Finance, HR, Operations, and CRM domains. Skilled in Power BI, DAX, Power Query, and SQL with strong expertise in data modelling, performance optimization, and KPI reporting. Proficient in integrating diverse data sources, implementing RLS, and delivering secure, scalable, and high-performing dashboards that drive data-driven decision- making.

TECHNICAL SKILLS:

• BI & Visualization Tools: Power BI Desktop, Power BI Service, Power BI Report Builder (Paginated Reports)

• DAX (Data Analysis Expressions): Custom Measures, Time Intelligence Functions, KPI Calculations, Row- Level Security (RLS)

• Data Modelling & Transformation: Star Schema Design, Snowflake Schema, Data Modelling, Power Query

(M Language), Dataflows, Relationships, Calculated Columns, Hierarchies

• Data Integration & ETL: SQL Server, MySQL, Excel, SharePoint, APIs, Flat Files, Data Gateway Configuration, Scheduled Refresh

• Dashboard & Reporting: Interactive Dashboards, KPI Scorecards, Drill-through Reports, Conditional Formatting, Custom Visuals, Bookmarks & Tooltips

• Performance Optimization: Query Folding, Aggregations, Incremental Refresh, Performance Analyzer, Efficient Data Models

• Deployment & Governance: Workspace Management, App Deployment, Data Security, Version Control, Usage Monitoring

• Productivity Tools: Microsoft Excel (Advanced – Pivot Tables, Power Query, VBA, Dashboarding), MS Word, PowerPoint

EMPLOYMENT HISTORY:

Power BI Developer Data Analyst Business Analyst Arabian Industries India Private Limited, Pune

BANER, PUNE - May 2023 – Current

• Designed and developed interactive Power BI dashboards and reports, enabling real-time insights for Finance, HR, and Operations teams.

• Created data models using star schema, relationships, and hierarchies, improving report performance and usability by 25%.

• Implemented DAX measures, calculated columns, and time intelligence functions to support dynamic KPIs and trend analysis.

• Developed ETL workflows using Power Query (M), integrating data from SQL Server, Excel, SharePoint, and APIs into unified models.

• Applied Row-Level Security (RLS) and workspace governance to ensure secure data access and compliance with organizational policies.

• Optimized dashboards using query folding, aggregations, and incremental refresh, reducing data refresh time by 40%.

• Automated reporting processes and scheduled data refreshes, improving reporting efficiency and reducing manual effort by 30%.

• Collaborated with stakeholders to gather requirements, design KPI scorecards, and deliver self-service BI solutions that improved decision-making across departments. 2

EMPLOYMENT HISTORY:

L1 Support Engineer Software Developer

Kotak Mahindra General Insurance Company, Mumbai

April 2019 – January 2022

• Administered and maintained multiple SQL Server, and MySQL databases, ensuring optimal performance, high availability, and secure access.

• Developed and maintained stored procedures, functions, triggers, views, synonyms, and SQL jobs, enhancing automation and reducing manual effort.

• Monitored SQL job activities, performed migrations and upgrades, and resolved incidents as a key escalation point.

• Deployed application changes and enhancements across multiple servers into live production environments with zero downtime.

• Worked with IIS to configure and create new environments for applications, troubleshoot deployment issues, and collaborate with development teams for resolution. PROJECTS:

• Azure Utilization Dashboard (IT Infrastructure / Cloud Cost Analysis)

• Company Cash Flow Statement Dashboard (Financial Domain)

• HR Attrition Prediction Dashboard

• Customer Support Analytics (Service Domain)

• Operations & Inventory Management Dashboard (Operations Domain)

• Sales Performance Dashboard (CRM Domain)

CERTIFICATION:

• Data Analytics Essentials – Cisco Networking Academy

• Data Visualisation: Empowering Business with Effective Insights – TATA (Forage)

• GenAI Powered Data Analytics Job Simulation – TATA (Forage)

• SQL (Intermediate) Certificate – HackerRank

• Microsoft PL-300: Power BI Data Analyst (In Progress) ACHIEVEMENTS:

• Selected for an international business trip to Oman, representing the organization for cross-border business discussions, knowledge sharing, and professional development. SOFT SKILLS:

• Strong analytical and problem-solving skills for data-driven decisions

• Effective time management and multitasking abilities

• Quick learner, adaptable to new tools and processes

• Collaborative team player with stakeholder management experience EDUCATION:

• Post Graduate Diploma in Advanced Computing (PG-DAC) MET IIT Bandra Bandra, Mumbai – Sept 2022 – Mar 2023

• B. Tech in Automobile Engineering Rajarambapu Institute of Technology Sangli, Maharashtra – Aug 2016 – Mar 2019

Contact this candidate