JAY PATEL – Business Intelligence Analyst – 8+ years Exp Current Location : Chicago, IL – Ready to go On-Site

Consultant's Details: 

Consultant Name: Jay Patel

Visa Status: USC

Current Location : Chicago, IL

Employer Details:

Employer:Nextgen Technologies Inc

Contact Person:Kushal

Email:kushal.desai@nextgentechinc.com

Note: Please call between 09:30 AM PST to 06:00 PM PST

Phone: +1 (413) 424-0484

Jay Patel's Resume

SUMMARY: Business Intelligence professional with 8+ years of experience and an MBA in Information Systems (2024). Expertise in SQL, Power BI, Tableau, and advanced data visualization. Proven ability to deliver actionable insights, optimize BI systems, and lead cross-functional collaborations. Skilled at transforming complex data into strategic business solutions while driving innovation and efficiency across operations.

EDUCATION

MBA in Information System at University of Massachusetts Boston                                                                             Dec 2021 – June 2024

• Teaching Assistant for MBA classes in SQL, Finance Modeling, Database Management, and Accounting.

B.S in Accounting and Finance at Bridgewater State University                                                                                        Sep 2014- June 2016

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst at Ahold Delhaize – (Chicago, IL)                                                                                         Aug 2020 – Present

• Implemented predictive analytics models using Power BI DAX formulas and SQL stored procedures, enhancing demand forecasting accuracy by 15% through time-series modeling.
• Performed segmentation analysis using clustering algorithms in Power BI and SQL, driving a 10% increase in targeted marketing campaign ROI.
• Spearheaded BI migration from SSRS to Power BI, achieving a 25% reduction in report generation time and increasing adoption rates by 30% through customized training sessions.
• Partnered with 5+ departments to gather requirements, design custom Power BI dashboards, and streamline reporting processes—reducing reporting cycle time by 20%.
• Designed and deployed 15+ Power BI dashboards with embedded security measures and optimized data models, improving reporting efficiency by 20%.
• Developed and optimized SQL queries for data extraction and analysis, generating 50+ ad-hoc reports and enabling faster, data-driven decision-making across business units.
• Developed complex reports and dashboards using Cognos Analytics, including Framework Manager, Data Modules, and Active Reports. Provided end-user support and collaborated with teams to integrate new data sources for enhanced reporting.
• Utilized SQL, Power BI, and Python for data mining and exploratory analysis, uncovering trends that increased operational performance by 10%.
• Managed projects by providing estimated timelines, assisting with BI/IT budgets, and driving technology improvements for enhanced operational efficiency.
• Designed and tuned SQL databases (DDL, DML) for enhanced performance, improving query response time by 20% and supporting seamless data operations
• Familiar with the Agile Scrum framework and SDLC processes, actively participating in sprints and project meetings to ensure timely delivery of IT solutions for business intelligence needs.

Data Analyst at Toyotetsu – (Somerset, KY)                                                                                                                    May 2016 – Aug 2020 

• Developed supply chain performance dashboards, reducing delivery delays by 15% through actionable insights.
• Automated data extraction and transformation workflows using SSIS and Python scripts, cutting manual effort by 30% and reallocating resources to strategic initiatives, improving operational efficiency.
• Continuously enhanced the BI platform, optimizing user access to insights and ensuring seamless leverage of data-driven decisions.
• Analyzed large datasets using SQL, Python, and Tableau, identifying cost-saving trends and patterns that contributed to a 10% reduction in operational expenses
• Developed dynamic dashboards, visualizations, and reports in Power BI, providing key stakeholders with clear and impactful insights.
• Partnered with BI modeling and reporting teams to recommend and implement improvements, enhancing techniques, offerings, and operational processes.
• Collaborated with business stakeholders to gather requirements, address key needs, and foster collaboration with the BI team, ensuring the delivery of effective and accurate solutions.

Data Analysis and Visualization: Power BI, SSIS, SSAS, SSRS, Tableau, Microsoft Access

Database Management: MS SQL Server 2014/2012, MS Access, Oracle, MS Access, MYSQL

ERP and Supply Chain: PeopleSoft, Winweb, Manhattan Associates, and NetSuite

Certification: Power Bi Essential, Google Data Analytics,Salaceforce Administrator(in Process)

Project Management and Collaboration: JIRA, Microsoft Project, Smartsheet

Other: U.S. Citizen that does not require work authorization