Vaishali Patel Email & Phone Number

San Diego, Ca, Us

Diamond Bar, California, Us

Diamond Bar, California, Us

Waltham, Ma, Us

Served as liaison between the data scientists and product managers to gather and develop reporting for predictive models. Created multiple Power BI dashboards from SQL server, gitx, AWS, Cognos that allows to measure business performance. Partners with business leaders and leverage strong analysis skills to recommend KPIs and targets that generate meaningfulinsights. Identifies business challenges in the areas of commercial, marketing, finance, customer service and sales, andutilizes advanced analytics capabilities to mine data and recommend data science solutions. Manages the execution of programs and projects for Data Solutions for cross‐function divisions. Works within budget,schedule, and scope constraints while managing risk and ensuring adherence to established processes andmethodologies. Develop and execute analytical strategies for support of enterprise tools and internal reporting using Power BI, DAX, and Mlanguage solutions. Develops SQL queriesto generate datasets for MS Power BI dashboards and automates reports using Scripts. Extracts manipulate and analyses a vast amount of data to produce accurate reports and ad‐hoc datarequests. Executes projects using Agile methodology on Enterprise Lean Kit to participate in sprint planning, daily scrums, and sprintreviews.

Diamond Bar, California, Us

Worked closely with executives to define and prioritize key performance indicators to take data driven business decisions. Deployed over 25+ advanced tableau dashboards from 10 data sources that allow to track various departmental KPIs. Created budgets and CPU for all manufacturing units to ensure that labor and material costs were decreased comparatively. Reduced scrap rate by 11% and improved OEE by 1.2% to avoid 19.2 M manufacturing cost by deploying predictive model.  Created a demand planning model for supply chain to track and ensure the inventory levels across the network. Developed SQL queries to generate large datasets for ad‐hoc analysis and automated reports using Python and R Scripts Conducted analysis on key metrics, presented the insights, recommendations to executives and OEM for business expansion.

Diamond Bar, California, Us

Diamond Bar, California, Us

Fullerton, Ca, Us

• Collected and analyzed more than 35,000 data of all California Community Colleges to identify admission trends, for improving education system and offering new services to students.• Analyzed data and determined results through regression analysis and factor analysis by incorporating SPSS and R to recognize the opportunities for campus expansion.• Conducted geospatial and demographic analysis Cal optima members data using SPSS generated summary statistics, pivot tables and charts to enhance services and market expansion.• Created dashboards to gain insights about medical usage based on age, ethnicity and gender practicing Tableau.

New York, Ny, Us

• Documented business processes and inspected procedures to see if they would meet changing business needs.• Summarized raw data and prepared it for analysis, evolved insights from existing reports exercising Microsoft SQL Server and Microsoft Excel 2016.• Conducted exploratory data and cluster analysis to look for patterns to attain useful insights through IBM Watson.• Executed statistical models on sales data and identified trends to support business practicing Excel Add-in.• Interacted with client on a regular basis to capture requirements and translate them into Business process documents. • Analyzed and worked on some business problem, resolved it using quantitative analysis and statistical modelling skills. • Facilitate JAD (Joint Application Design) sessions to gather customized exchange process documents. • Extracted data from SQL database, created the reports and dashboard by utilizing IBM Watson for managers to review and decision making.