S

Samarth Malpani

Software Engineer

Indore, Madhya Pradesh, India0 mo experience

Key Highlights

  • Automated 15+ Power BI dashboards, cutting reporting time by 50%.
  • Developed dynamic KPI dashboards for real-time business insights.
  • Implemented data governance, reducing discrepancies by 90%.
Stackforce AI infers this person is a Data Analyst with strong BI and ETL expertise in SaaS environments.

Contact

Skills

Core Skills

Data AnalysisPower Bi

Other Skills

C (Programming Language)C++DAXData GovernanceData ModelingData Structure and AlgorithmsData StructuresData TransformationETLExtract, Transform, Load (ETL)Go (Programming Language)Informatica PowerCenterMicrosoft Power BIMySQLPower Query

Experience

Principal global services

2 roles

Software Engineer

Jul 2023Present · 2 yrs 8 mos · Pune, Maharashtra, India · Remote

  • Designed and automated 15+ interactive Power BI dashboards using DAX, Power Query, and advanced
  • data modeling, reducing manual reporting efforts by 50% and accelerating insight delivery to cross-functional
  • stakeholders.
  • Developed dynamic KPI dashboards to monitor sales, inventory, and financial performance, enabling 20% faster
  • decision-making through real-time visualization of business metrics.
  • Built scalable star-schema data models in Power BI, optimizing query performance by 30% and enabling seamless
  • integration with enterprise data warehouses.
  • Collaborated with stakeholders to translate business needs into technical BI solutions, increasing dashboard
  • adoption by 40% across finance, sales, and operations teams.
  • Implemented data governance frameworks to standardize metrics and reporting, reducing discrepancies by 90%
  • and ensuring compliance with industry regulations.
  • Automated data validation workflows using SQL and Power Query, reducing manual error-checking efforts by
  • 15 hours/month and enhancing data integrity.
  • Optimized ETL pipelines using Informatica PowerCenter, reducing data latency by 25% and aligning processes
  • with real-time analytics requirements.
  • Integrated Power BI with enterprise data systems (ERP, CRM, Azure SQL) via SQL and RESTful APIs,
  • ensuring real-time data synchronization and improving data accuracy by 35% for 200+ business users.
Data AnalysisMySQLPower BISQLETLInformatica PowerCenter

Trainee Developer intern

Jan 2023Apr 2023 · 3 mos · Pune, Maharashtra, India · Remote

  • Assisted in optimizing ETL workflows using Informatica PowerCenter, streamlining data transformations and
  • implementing parallel processing to reduce data pipeline execution time by 30%, ensuring timely availability of data
  • for BI dashboards.
  • Supported database performance tuning by refining SQL queries and optimizing indexing strategies, improving
  • real-time data retrieval speeds by 40% and enhancing responsiveness for business intelligence reporting.
  • Worked together with senior engineers to integrate RESTful APIs with ETL pipelines, enabling seamless extraction of
  • data from cloud sources for analytics use cases.
  • Contributed to the design of star-schema data models to support Power BI dashboards, aligning with business
  • requirements for sales and inventory tracking.
  • Documented ETL processes and data lineage to improve team transparency and compliance with data governance
  • standards.
Informatica PowerCenterSQL

Humans for humanity

Backend developer intern

Jun 2021Aug 2021 · 2 mos · Remote

  • Enhanced a REST API for an event management system using Go, implementing JWT-based authentication and
  • password hashing for secure user access.
  • Designed and integrated a SQL database for data persistence, creating endpoints for user signup, login, and event
  • management.
  • Applied middleware for authentication, ensuring secure and scalable API functionality.
Go (Programming Language)SQL

Education

Shri G S Institute of Technology & Science

B.Tech — Information Technology

Jan 2019Jan 2023

Stackforce found 100+ more professionals with Data Analysis & Power Bi

Explore similar profiles based on matching skills and experience