Sourav Soloman

Gathered data from Alrtiris, SCCM, CMDB, ServiceNOow, SAP, Excel, and other sources. Transformed the data and produced reports using the Power BI platform. Optimized dashboard with a focus on usability and performance.

• Developed over 50 reports and dashboards resulting in a 30% increase in operational efficiency.
• Collaborated with cross-functional team to identify data sources and streamlined data collection resulting in a 25% reductions in report development time.
• Improved dashboard usability by implementing interactive visualization resulting in a 20% increase in user engagement.
• Optimized resource utilization by effectively prioritizing tasks based on project timelines and risk assessment outcomes.
• Fostered culture of quality, encouraging proactive identification and resolution of potential quality issues.

Data Modeling & ETL

• Data Extraction & Transformation: Extracted and cleansed data from multiple sources (SQL databases, Excel files) using Power Query, improving data accuracy by 60%.
• Data Modeling: Designed and optimized star-schema data models by establishing table relationships, enhancing query performance by 50%.
• DAX Development: Developed intermediate DAX formulas to create calculated measures and columns, enabling deeper data insights for business stakeholders.

Report & Dashboard Development

• Interactive Visualizations: Built Power BI dashboards with bar charts, line graphs, and scatter plots, driving data-driven decision-making for sales departments.
• User-Centric Design: Applied UI/UX best practices to create intuitive and visually compelling reports, reducing user training time by 50%.

Analysis & Collaboration

• Requirement Translation: Translated business needs into technical specifications, ensuring alignment between stakeholders and development teams.
• Data Validation: Assisted senior analysts in troubleshooting data-related issues and validating data accuracy.
• Documentation: Created detailed documentation on data sources, models, and report logic, streamlining future maintenance and onboarding.