Dwisha Shah

IT Specialist @Pacific Smoke International Inc.

Markham, ON, CA

Data Analysis and Reporting:Collaborated with cross-functional teams to define and refine BI requirement specifications, enhancing data-driven strategy alignment and achieving 95% stakeholder satisfaction.Leveraged SQL-based data mining methods to increase insights for initiative scoping, leading to a 15% boost in performance metrics.Utilized PowerBI and SQL to craft complex data models, converting extensive raw datasets into actionable business insights, improving decision-making efficiency by 15%.BI Tools and Dashboard Development:Developed automated processes using Power BI and DAX functions to enhance reporting efficiency, cutting down data retrieval time by 35%Designed and implemented advanced tabular models using SQL Server Analysis Services (SSAS) to enhance data processing capabilities.Create and run complex DAX and SQL queries and functions in Power BI.Maintenance and Improvement:Enhanced BI systems through regular SQL optimization and process automation, achieving a 25% increase in data processing efficiency.Help fix and enhance existing reports and dashboards.Collaboration and Support:Developed custom dashboards in Power BI that increased data visibility and usability for non-technical users, driving a 25% increase in report efficiency.Support BI end-users through training sessions, user guides, one-on-one consultations, advice, workshops, troubleshooting, downtime procedures, and issue resolution.Follow and enhance BI standards and best practices across the team.Project Coordination:Facilitated successful project delivery by coordinating cross-functional teams and employing agile methodologies to meet predefined project scopes.Enhanced project outcomes by facilitating effective communication between stakeholders and data engineering team.Data Governance:Ensure that data access is granted in a controlled and secure manner, following the organization’s data governance policies and procedures.

Gujarat Technological University (GTU)

Bachelor of Engineering, INFORMATION TECHNOLOGY

Vancouver Community College (VCC)

Master's degree, Business Administration and Management, General