Vrunda Shah

•Reduced project costs by 8% by initiating supplier spend analytics using PowerBI and e-Builder to determine vendors for RFP •Partnered with business analyst, data engineer to determine the requirements for extending data warehouse architecture •Acted as liaison between internal divisions and vendors throughout the bidding process, and implemented cost/budget analysis •Synthesized BI data to produce periodic and ad-hoc dashboards to oversee budget and energy usage using SQL and PowerBI •Automated ETL process by creating data pipeline for extracting daily data from various sources to Data warehouse in azure •Imported data from various sources and performed data validation to design annual report in Excel with VBA, PowerPivot, Pivot table, DAX functions, Vlookup; presented the results to leadership using Tableau •Recognized and fixed data inconsistency to build KPIs such as cost savings, spend vs budget and contract value metrics •Identified opportunity for process improvement and revamped RFQ process by 40% by automating process of maintaining data

•Assisted professor with coursework, projects, and lecture for class of Data Management for Analytics of above 50 students •Tutored students and conducted lab sessions to clear the doubts about MySQL, NoSQL, Python and R

•Collaborate with University sponsorship department for organizing, documenting and reporting of event •Communicate with industry professional ,Daeso committee , and faculties to organize events , seminars and workshops on different technology such as Python , Machine Learning

•Collaborated with cross functional team of product manager and business stakeholders to gather requirements and documented them in form of user stories using agile development process and executed SIT testing •Designed database using PostgreSQL and performed advance SQL querying on spatial data; reduced data retrieval time by 5% •Wrote ETL pipelining templates to populate data and constructed SSIS mapping to transform and apply business rules

Data Mining, Data Management for Analytics, Machine Learning, Engineering Statistics and Probability, Data Warehousing and Business Intelligence, Economic Decision Making, Operation Research, Computational and Visualization.