Jinal Patel Email & Phone Number

Toronto, On, Ca

Canada

● Analyzed business requirements for reporting and analysis and translated the emanating results into technical data design documents and worked with both structured and unstructured data for processing and storing data● Design and developed with business intelligence using SQL Server, Integration Services(SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX● Extracted data from multiple sources. Built data transformations using data cleansing, data mapping data association, entity mapping, and resolution techniques● Provided guidance and assistance for data visualization and report generation, specifically with visual data modeling tools such as Power BI and responsible for weekly report generation using Excel and presenting to stakeholders using Tableau Power BI Tool● Effectively communicated with partners to understand requirements and provide feasible analytical solutions and modified existing databases and database management systems or directed programmers and analysts to make changes● Interpreted data, analyzed results, and provided ongoing reports. Collaborated with team members to identify recommendations for process improvements● Improved data collection and analysis process, resulting in an increase in data accuracy and a reduction in data processing time● Conducted statistical analyses, data interpretation, and developed predictive models to identify and mitigate potential risks, resulting in improved business outcomes● Identified insights and predicted future trends using Excel by Pivots & VLOOKUP’s functions to assist business solutions● Worked closely with internal teams to organize user and client data into databases that can be analyzed and turned into web-based and static reports and dashboards for salespeople, clients, and executives and assisted with fulfilling periodic metric requirements and visualization dashboards for external stakeholders

India

● Applied analytical methods such as clustering, forecasting, and trend analysis using built-in Power BI features or DAX functions. ● Translated complex business questions into actionable analysis by writing SQL queries and Python scripts for data gathering, cleaning, organizing, and analysis, bridging the gap between technical data manipulation and business intelligence.● Designed and automated report generation using SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).● Created visually appealing dashboards and reports by connecting to data sources, performing data transformations, and designing interactive visualizations.● Utilized various chart types (e.g., bar charts, line charts, scatter plots) and interactive features (e.g., drill-down, filters) to effectively represent data insights.● Implemented advanced charting techniques and custom formatting options to visualize data effectively. And created interactive presentations and storytelling dashboards to communicate findings in a compelling manner.● Generated visually appealing reports and presentations within Excel, incorporating charts, graphs, and pivot tables and used CRM tools to collaborate with team members, track interactions, and manage relationships with stakeholders.● Maintain communication and collaboration with analysts and business specialists through CRM tools and collaborative features within BI platforms.