MD NAIYAZ
Senior Solution Developer
Pune
Summary
Experienced MSBI Developer with 8 years of expertise in designing, developing, and implementing Business Intelligence solutions using Microsoft BI tools. Highly proficient in Power BI with 6 years of experience and expert-level skills in DAX (Data Analysis Expressions). Adept at transforming complex data into actionable insights, creating interactive dashboards, and optimizing data models to support business decision-making processes. Experienced in automating workflows with Microsoft Power Automate to streamline business processes and improve efficiency.
Overview
8
8
years of professional experience
3
3
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Senior Solution Developer
Data Semantics
03.2022 - Current
- Lead the development and implementation of business intelligence solutions using Microsoft BI stack, with a focus on Power BI, SQL, and Power Automate.
- Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications and data models.
- Design and develop complex Power BI reports and dashboards, incorporating advanced DAX calculations (e.g., CALCULATE, FILTER, RELATED) and time intelligence functions (e.g., SAMEPERIODLASTYEAR, DATESYTD) to analyze business performance.
- Streamline data integration processes using SQL Server Integration Services (SSIS) to ensure efficient ETL (Extract, Transform, Load) operations and maintain data integrity.
- Implement ETL job role monitoring and performance tuning techniques to optimize data processing and improve system scalability.
- Create automated workflows using Power Automate, including email alerts to business users based on predefined KPI thresholds, enhancing proactive decision-making and issue resolution.
- Develop Power Automate flows for automatic Power BI dataset refresh based on email triggers, enabling real-time data updates and ensuring the freshness of analytical insights.
Senior Power BI Engineer
Soho Dragon
12.2020 - 03.2022
- Developed and optimized ETL packages in SSIS to automate data integration tasks, enhancing data accuracy and reducing manual efforts.
- Created and maintained SSRS reports and dashboards for various departments, ensuring data consistency and usability.
- Enhanced data models in SSAS, leading to more efficient data retrieval and analysis for end-users.
- Implemented Power BI dashboards, utilizing advanced DAX calculations to support complex business requirements.
- Created custom visuals in Power BI to provide unique insights and improved data storytelling.
- Conducted Power BI workshops for business users, enhancing their ability to generate ad-hoc reports and perform self-service analytics.
- Collaborated with business analysts to understand data requirements and translate them into technical solutions.
- Developed detailed financial reports in Power BI, including balance sheets, income statements, and cash flow statements.
- Created automated workflows with Power Automate to integrate SharePoint lists with SQL tables and trigger alerts.
Data Analyst
Sahu Exports
09.2019 - 12.2020
- Developed and maintained data warehouse solutions using SQL Server and SSIS, ensuring data accuracy, consistency, and reliability.
- Collaborated with business analysts and end-users to understand reporting requirements and translate them into scalable data models and ETL processes.
- Created dynamic Power BI reports and dashboards to visualize sales trends, inventory levels, and operational metrics, enabling data-driven decision-making.
- Utilized DAX functions to perform calculations and create calculated columns for advanced analysis in Power BI.
BI Developer
Methods Apparel Consultancy
04.2016 - 09.2019
- Assisted in the design and development of SQL Server databases and SSIS packages to support business intelligence initiatives.
- Conducted data analysis and performance tuning to optimize query performance and enhance system scalability.
- Supported the creation of Power BI reports and dashboards, providing valuable insights into sales forecasts, customer segmentation, and inventory management.
- Implemented Power Automate workflows to automate repetitive tasks and streamline business processes.
Education
B.Tech (CS) - Computer Science
Sunrise University
Alwar, India 01.2014 - 01.2017
Skills
Power BI
SQL
SSIS
ADF
DAX
Power Automate
Python
Certification
PL 300 : Power BI
Timeline
PL 300 : Power BI
05-2024
Senior Solution Developer
Data Semantics
03.2022 - Current
Senior Power BI Engineer
Soho Dragon
12.2020 - 03.2022
Data Analyst
Sahu Exports
09.2019 - 12.2020
BI Developer
Methods Apparel Consultancy
04.2016 - 09.2019
B.Tech (CS) - Computer Science
Sunrise University
01.2014 - 01.2017
Similar Profiles
Noor FathimaNoor Fathima
Software Engineer at Data SemanticsSoftware Engineer at Data Semantics
Aswathi MohanAswathi Mohan
Software Engineer at Data Semantics Pvt LtdSoftware Engineer at Data Semantics Pvt Ltd
Wilson Rojesh NWilson Rojesh N
Software Engineer at Data Semantics Pvt LtdSoftware Engineer at Data Semantics Pvt Ltd