About Hetal
English
Native or bilingual
Experience
- Freelance Data EngineerData engineerMarch 2024 - May 2024 (2 months)Vadodara, IndiaExcel Consolidation & End-to-End Data Warehouse Implementation•Consolidated 20+ heterogeneous Excel files into a centralized staging database using SSIS.•Designed schema mapping and data cleansing rules to standardize inconsistent datasets.•Developed SQL transformations and data models for reporting.•Built interactive Power BI dashboards for automated reporting.•Reduced manual reporting efforts by 80% (saving ~12 hours per week).Technologies: SSIS, SQL Server, Power BI, Data Warehousing
- FreelancerFreelance Power BI DeveloperJanuary 2025 - March 2025 (2 months)Vadodara, IndiaRetail Sales & Inventory Dashboard – Clothing Store (Excel + SharePoint Integration)•Developed an end-to-end Power BI solution for a clothing retail store to monitor sales, stock levels, and product performance across branches.•Integrated multiple Excel files stored in SharePoint into Power BI using automated refresh configuration.•Designed ETL logic to clean, transform, and consolidate daily sales and inventory data.•Built a star schema data model with Fact Sales, Product, Store, and Date dimension tables.•Created advanced DAX measures including:•Total Revenue•Gross Profit & Profit Margin %•Inventory Turnover•Category-wise Sales•Month-over-Month & Year-over-Year Growth•Implemented drill-through pages for detailed product and store-level analysis.•Designed KPI dashboards to identify slow-moving inventory and seasonal trends.•Automated reporting process, reducing manual Excel-based reporting by 80%.•Configured scheduled refresh to ensure real-time visibility for store management.Technologies: Power BI, DAX, Excel, SharePoint, Data Modeling, ETL
- Freelance Azure Data EngineData engineerJuly 2024 - September 2024 (2 months)Vadodara, IndiaAzure Data Factory Orchestrated Data Aggregation Solution•Developed optimized SQL stored procedures for daily high-volume data aggregation.•Orchestrated end-to-end ETL pipelines using Azure Data Factory.•Implemented automated daily loads with logging and validation checks.•Delivered clean, aggregated datasets directly into Power BI dashboards for business reporting.Technologies: Azure Data Factory, SQL Server, Power BI
Recommendations
Be the first to recommend Hetal
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Bachelor of computer applicationsCharusat university, changa2021