Jay Mehta Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

San Francisco, Ca, Us

London, Gb

London, Gb

London, Gb

▪ Delivered Tableau dashboards with interactive views, trends and drill downs to help executives perform their independent analysis and make sales-force sizing and call planning decisions▪ Ensured easy maneuvering in Power BI reports for better end-user experience by embedding hierarchy, bookmarks, identifying KPI’s, using DAX to get slices of data across various time frame and linking all reports with an executive summary▪ Assisted client to identify bank’s Resiliency and establish IT Asset Mapping by calculating measures using set expressions and leveraging third-party extensions to develop Qlik Sense apps▪ Automated excel files data load, including multiple tabs and different table structure, in SQL Server using Python▪ Maintained data audit in SQL Server by developing dimensional load using SSIS and identifying erroneous records through data quality scripts

Evanston, Il, Us

▪ Facilitated meetings with stakeholders in an Agile project to gather business needs, translate them into comprehensive business requirements for the offshore team and present the solution approaches to the product owners▪ Performed process analysis of current business processes and provided recommendations for improvement▪ Ensured less than 5 seconds of Tableau reports refresh time by developing efficient business data models in AWS Redshift for reporting layer▪ Implemented agile development practices like facilitating daily scrum stand-up, backlog grooming and sprint planning meetings▪ Created and maintained business requirement document as and when the requirements were finalized

Evanston, Il, Us

▪ Developed data warehousing solutions for our Pharmaceutical client on Big Data platform for a critical product launch. Integral part of a team which was first in ZS Associates to create a data warehouse on Hadoop▪ Part of a team that has delivered multiple projects to migrate an existing legacy system from Teradata and Informatica platform to Big Data platform of Amazon Web Services (AWS)▪ Successfully led a 4-member team to seamlessly integrate and align the sales forces of a pharmaceutical company that was taken over by the client into the existing system. Work was spanned over multiple practice areas such as sales crediting, performance reporting, data investigations and data analysis, understanding the business requirements and developing metric calculation engine for the reporting layer▪ Responsible for heading a team of 3 members to develop, and automate the weekly and monthly operations overhead for a sales reporting project that successfully addressed the needs of merging 4 diverse sales forces into an existing system▪ End-to-end development experience in a Business Intelligence/Data warehousing project by working on various phases like Requirement Analysis, Design, Implementation, Testing, Operations and Support▪ Experience of working on projects dealing with Sales level data and Claims level data▪ In-depth knowledge and experience of understanding and developing the Sales Crediting Rules according to the criteria’s provided by the client, Business Rules implementation required for the Core Layer and Reporting Metrics required for the Reporting Layer using Hive, Impala, Pig and Python▪ Extensive experience of developing data warehouses for Sales and Claims level data and performing data reconciliation▪ Actively participated in devising testing strategies for all the projects that I have worked on

Dublin 2, Ie

▪ I was an integral part of data quality management team and responsible for tuning existing data quality checks and also develop new ones using SQL to cleanse the data before loading into fact tables. As a result, the operations team can identify defective records at the initial data loading phase▪ Optimized the excel sheets used for data testing by creating macros wherever possible, eliminating the manual efforts resulting in considerable time saving▪ By understanding the data model, created table definition scripts using SQL

Master'S Degree, Business Analytics And Project Management

Engineer'S Degree, Electronics Engineering

Associate’S Degree, Industrial Electronics Technology