Jay Shah Email & Phone Number

Greater Los Angeles Area

Richmond, Virginia Area

• Extracted and analyzed data from multiple sources to derive business insights and recommend solutions• Created dynamic reports using SQL, PowerBI and Excel to be utilized by cross functional teams• Worked closely with the IT department to maintain and update data structure and quality• Audited databases for corrupt and missing data to ensure 100% availability and integrity of data• Supported the C-suite by creating dashboards to meet their Ad-hoc requests• Migrated various Excel reports to PowerBI dashboards by automating reporting which saved the weekly reporting time by 3 hours• Worked as a shared resource at Plow & Hearth Inc. and introduced PowerBI to various departments• Trained the business users with the integration and utilization of PowerBI as the resident PowerBI expert to enable better decision making• Created, managed and updated several customer data analysis reports for the retail and merchandising team

Hoboken, New Jersey

• Analyzed the incoming student data using Excel to improve standard working hours of the library and recommended the senior management to increase the current working schedule by 6 hours• Optimized the manual student interaction process by integrating an online chat box with the current CRM which gave the library a 4-point increase on the Stevens popularity scale• Led communications with major libraries on the East coast to ensure the availability of the requested books at all given times• Leveraged the library student database to create, update and maintain student records across various stages of bookkeeping• Assisted with hiring and training of incoming student assistants for the library

Mumbai, India

• Led various cross-functional team meetings with the technical team and senior management to gather and translate client requirements to create marketing strategies• Analyzed the buyer and seller consignment data using MS SQL and suggested a revised sales distribution strategy which led to a 12% increase in revenue• Leveraged the derived trends to understand the buyer seller behavior and modelled simplified dashboards on Tableau for senior management• Automated the manual transaction reporting process by migrating to online platform which improved the process-time by 3 hours• Elicited business requirements from external and internal stakeholders to prioritize project deliverables• Audited databases for corrupt and missing data to ensure 100% availability and integrity of data within SLA• Assisted with on-boarding of new clients and improving the standard process flow to ensure a smooth transition• Designed workflow diagrams and documented use cases outlining intermittent milestones depicting the workflow to be incorporated for project planning

Master'S Degree, Information Systems, 3.83

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering, 3.60