Jay Patel

Experience

• 

  DataOne

  Jan 2021 - Mar 2022

  SQL | BI Developer

  • Resolved 95% of technical support tickets related to Business Intelligence applications and databases within 24 hours.• Reduced the number of production outages by 50% by troubleshooting and debugging SQL Server Integration Services packages.• Maintained up-to-date documentation of database objects including table structure, column attributes, and relationships between tables, which improved the accuracy and efficiency of data processing.• Conducted unit testing of all changes made within the databases ensuring accuracy of data, which reduced the number of data errors by 75%.• Created dashboards with interactive visualizations using Power BI Desktop tools, which improved the ability of stakeholders to analyze data and make informed decisions.• Built cubes using Microsoft Analysis Services for faster reporting capabilities, which reduced the time it took to generate reports by 25%.• Developed SQL stored procedures and triggers to automate data processing tasks, which improved the efficiency of data processing.• Created reports using SSRS, Power BI, Tableau, and Excel, which provided stakeholders with a variety of options for viewing and analyzing data.• Utilized advanced functions such as pivot tables, VBA Macros, and custom formulas in Excel spreadsheets to analyze data sets, which provided stakeholders with more insights into their data.• Deployed complex queries on large datasets for business intelligence analysis, which helped the company to identify new market opportunities and improve operational efficiency. Show less

• 

  Fencecore

  May 2023 - now

  Data Analyst

  • Extract key observations and insights from internal and external data sources to drive decision-making, which results in a 5% reduction in costs.• Collaborate with other departments to ensure data accuracy and integrity, which improves customer satisfaction by 2%.• Create visual representations of data with charts, graphs, and infographics that are easy for non-technical audiences to understand.• Evaluate large datasets to identify trends and develop actionable insights, which helps the company to identify new market opportunities.• Leverage statistical methods to analyze data, which improve the accuracy of forecasting models.• Design and develop reports and analytics using modern data visualization tools, which reduces the time it took to generate reports by 50%.• Provide insights into customer behavior through the use of descriptive analytics tools, which helps the company to develop more effective marketing campaigns.• Create SQL queries to extract data from multiple sources for reporting purposes, which improves the efficiency of data processing.• Use automated reports to help stakeholders understand complex data, which reduces the time it took to make decisions.• Explain complex data sets in simple terms to non-technical audiences, which improves communication and collaboration across the company. Show less