Hemendra Pandya
Business Intelligence Developer
Ahmedabad
Summary
Experienced Business Intelligence Developer with 2+ years in data analysis, reporting, and dashboard development. Proficient in Power BI, SQL, and Azure Data Factory for building data pipelines and generating actionable insights. Adept at optimizing database performance, automating workflows, and developing complex queries. Strong communicator with expertise in project management and cross-functional collaboration.
Overview
2
2
years of professional experience
Work History
Power BI Developer
Atqor Technologies Pvt Ltd
Ahmedabad
07.2024 - Current
- Power BI Dashboard Development & SQL Optimization
Developed interactive Power BI dashboards, improving decision-making and increasing adoption by 65%. Optimized complex SQL queries for ETL processes. - Backend Data Structure Design & Data Integration
Designed efficient backend data structures, improving data processing . Automated data integration from SAP ECC and HANA to data warehouses using Azure Data Factory, along with transforming and storing Excel data in Azure Blob Storage to data warehouse. - Project Management & Dashboard Delivery
Independently managed projects from requirements gathering to deployment, delivering finance and marketing dashboards that increased campaign ROI by 37%. Collaborated cross-functionally to ensure alignment with business objectives.
Business Intelligence Developer
Shreeji Data Analytics Consultancy LLP
Ahmedabad
10.2023 - 07.2024
- Experienced and skilled in handling stakeholder calls and understanding, analyzing requirements for successful project outcomes.
- Developed and executed reliable and effective business insights from different data sources (Business central, NAV, Data Warehouse).
Data modeling and mapping tables as per business logic and well-architected data solutions that supported analytical reporting and decision-making procedures. - Involved in 3+ report and dashboard development projects.
- Involved in development and integrating Power Automate with Microsoft Dynamics 365 Business Central, proficient in creating dynamic nested level approval processes and automating payment approvals, directing them to relevant parties.
Associate Business Analyst
Bitscape Infotech PVT. LTD
Ahmedabad
11.2022 - 08.2023
- Power BI Development & SQL Management
Delivered Finance & Operations Power BI dashboards, optimized SQL databases, and modeled data to support analytical reporting. - Client Communication & Requirement Analysis
Managed client calls, gathered requirements, handled change requests, and created customized business proposals. - Data Integration & Automation
Integrated data from multiple sources (Business Central, NAV) and automated workflows with Power Automate in Microsoft Dynamics 365. - Project Management & Stakeholder Collaboration
Managed project timelines, ensured effective communication with stakeholders, and provided updates on progress and data issues.
Education
Data Science Masters - Data Science & AI
Jain University(Certification)
AhmedabadBachelor of Science - Information Technology
Institute of Distance & Open Learning- University of Mumbai
Skills
Microsoft Power BI
undefinedTimeline
Power BI Developer
Atqor Technologies Pvt Ltd
07.2024 - Current
Business Intelligence Developer
Shreeji Data Analytics Consultancy LLP
10.2023 - 07.2024
Associate Business Analyst
Bitscape Infotech PVT. LTD
11.2022 - 08.2023
Bachelor of Science - Information Technology
Institute of Distance & Open Learning- University of Mumbai
Data Science Masters - Data Science & AI
Jain University(Certification)
Similar Profiles
Ekta PrajapatiEkta Prajapati
General Manager HR at atQor Technologies Pvt Ltd (Formerly bitscape)General Manager HR at atQor Technologies Pvt Ltd (Formerly bitscape)
Renish AnkolaRenish Ankola
Senior Project Manager at Prompt Equipments Pvt. Ltd.Senior Project Manager at Prompt Equipments Pvt. Ltd.
Dev SompuraDev Sompura
Junior Data Analyst at Atqor SolutionsJunior Data Analyst at Atqor Solutions