Sahir Mehta Email & Phone Number

Oakland, California, Us

• Developed logic and simulated the performance of Debit card risk rules in VISA by using quantitative statistical techniques to analyze data for transactions and authentication-based rules on the Google Cloud Platform to mitigate fraud risk and reduce member friction• Created dashboards on Google Data Studio and Looker to flag risky accounts and aid the operations team in investigations of risky and fraudulent entities• Analyzed large-scale data to identify fraud patterns in account takeovers and ACH payment transactions through statistical techniques like linear and logistic regression analysis and analysis of variance to improve rule performance and mitigate financial losses• Worked cross-functionally with Product, Engineering, and Operations teams to streamline the workflow of risk management across the customer lifecycle• Procured essential data from Vendors and created new tables in BigQuery using ETL techniques to get the data in the required format for analysis leading to better rule performance analysis

San Jose, California, Us

• Developed a data parsing workflow on nursing notes and forms using NLP techniques and Python on Google Cloud Platform to extract data and load them into Big Query tables leading to improved analytical capabilities for the customer• Conducted analysis on data related to medications causing Adverse Drug Reactions to reduce false positives leading to an increase in accuracy by 23%• Developed a chatbot using Dialogflow on Google Cloud Platform to interact with patients and answer queries regarding their medical needs leading to increased customer satisfaction

Chicago, Il, Us

Role: As a Data Analyst intern for the Reporting and Analytics team in the field of medical economics at AIM Specialty Health (a subsidiary of Anthem Inc.). I worked on claims data and Protected Health Information to improve utilization management for health insurance organizations. My duties were primarily for internal consulting and analytics to drive accurate decision making on the fly and allow business partners to create a data-backed business case in implementing changes and initiatives for benefits management.Primary Tools:Microsoft SQL Server, Business Objects, Qlik Sense, R, Microsoft Excel, Microsoft PowerPointResponsibilities and work:- Created reports using Business Objects in an Agile framework within tight deadlines using metrics such as CPTs and tests approved which enabled clients to make business decisions to increase revenue - Spearheaded the project in collaboration with the operations team to create an operations model using linear regression and decision trees through R, SQL, and Excel to identify the appropriate staff at call centers leading to projected savings- Created forecasting models using R to identify membership growth for AIM to scale business operations accordingly- Beyond given job duties, created visualizations using Qlik sense on membership, number of tests and tests approved to give stakeholders a clear view of trends occurring every month- Processed, analyzed and modeled data to depict the impact of AIM services for clients- Collaborated with the process engineering team analyzing operations at call centers to streamline workflow and reduce operational expenditure- Created reporting packages using Business Objects and shell script for monthly client reports- Automated the reporting inventory using SQL saving 150 man-hours for the team annually

Bielefeld, De

Role: As a Software Development Analyst in the healthcare data management team at NTT Data my primary responsibilities included working with Protected Health Information data and providing the healthcare client with data integration and storage capabilities. Primary Tools:Microsoft SQL Server, Microsoft Excel, Core JavaResponsibilities and work:- Developed stored procedures to automate the update in views using SQL leading to time and effort saved for the project team- Analyzed lab throughput using SQL queries, VBA, Macros, and Tableau to create visualizations for Tenet Healthcare to estimate the equipment and resources required in healthcare facilities - Integrated tables using complex SQL queries to provide the client with the information required for reportsRole: As a Software Development Analyst at NTT Data in the bank data management team, my primary responsibilities included working with transactional data, giving data-driven banking solutions, and providing customer insights to the client.Primary Tools:Microsoft SQL Server, Linux, Microsoft ExcelResponsibilities and work:- Conducted analysis and created dashboards on digital transactions for Citibank to identify the most popular payment methods used by customers and the risk associated with them using SQL, Excel Pivot tables, Vlookups, and Tableau to present to management for making business decisions- Created stored procedures to automate the update of views created from tables in the OLTP systems to reduce the manual effort for the team- Analyzed key performance indicators to identify transaction-based fraud in payments and transfers

St. Louis, Mo, Us

Role: As a Technology Intern in the wireless technology team at Emerson Process Management, my responsibilities included studying the Wireless Highway Addressable Remote Transducer (HART) technology used in measurement valves and provide recommendations on their use and improvement Primary Tools:Microsoft PowerPointResponsibilities and work:- Studied the Wireless HART technology system for valve positioning which uses non-contact, non-linkage, feedback sensors. - Developed the business requirement to customize the existing wireless product of Emerson specific to the oil industry- Presented recommendations to implement the wireless sensors in the refineries to increase efficiency by 25%, reduce cost by 50% and nearly eliminate installation costs

In

Role: As an Information Technology Intern in the Information Technology team at Hindustan Petroleum Corporation Limited my role was to assist in the development of a Web-based application for the Work Permit SystemPrimary Tools:C++, Java, Microsoft PowerPointResponsibilities and work:- Debugged programming code for the development team in analysis of a manual work permit system- Defined different types of Permits, their significance, and their impact on business.

Master Of Science - Ms, Information Technology And Management

Bachelor Of Technology, Electronics And Communications Engineering