Nikhil Mehar Email & Phone Number

Irving, Texas, Us

Prioritized Service Events (PSE) team-Convert and translate PSE Alteryx lead workflows to PSE-Flow Python workflows-Creating Python functions for PSE description translations into nested dictionaries and other automation tasks-Monitor lead workflows runs and help execution of monthly PSE data releases-Leverage business intelligence skills in Alteryx to create and modify workflows, apps and dashboard metrics-Analyze PSE dashboard live sales funnel data for bugs/anomalies and make necessary adjustments in workflow logic/code-Assist in architecture creation of PSE Flow, solving data issues and bugs by data analysis, business analysis in Snowflake SQL on PSE data, salesforce data, STU data, DPO data, pricing data etc.-Create and modify custom views, stored procedures in snowflake and SQL server-Create and collaborate SQL/Python code with vs code, versioning code/ data with GitHub and Agile development with Azure DevOps-Assist retiring SQL server and migrate data to snowflake with adhoc data pipelines-Create presentations and documentation in confluence and present findings-Participated in LENS consumer data hackathon and created customer segmentation with K-nearest neighbors’ algorithm-Alteryx server, Alteryx gallery and Alteryx connect administration, updates and resolving user issues, help improve user workflows and apps-Perform system analysis and tweak configuration to improve performance of Alteryx server, reduce workflow queue wait timesAftermarket Services Warehouse (ASW), Sales to users (STU) team-Build and maintain template-based DAGs, custom DAGs for multiple projects-Perform SQL data validation across incoming data in Snowflake-Designed and created multi node EC2 cluster in AWS sandbox and prod environment for Alteryx server-Monitor and manage EC2 instances, S3 buckets in AWS accounts, create alerts with CloudWatch-Data governance for Snowflake instance-Create and deploy python functions to deliver quarterly governance reports to IIQ team

New York, Ny, Us

Team- Applied Data Intelligence- Fixed Income Multi Asset ClassBond Price QA, Anomaly Detection using machine learning techniques in Python, SQL to eliminate analyst intervention.Assist in QA framework creation.Implement Agile practices in data science with JIRA. Version control with Bitbucket.

Stillwater, Ok, Us

Graduate teaching assistant for LSB-3213 Legal studies in business. Duties:- Assist proctoring quizzes and tutorials. Help students understand various legal aspects of US court and US constitutional provisions relating to contracts, business relationships, ethical and philosophical approach to decision making. In depth study of contract formation, performance, breach and calculation of damages.

Mumbai, Maharashtra, In

1) Responsible for handling two,three wheeler and off highway bearing application customers of NRB Bearings Ltd.2) Suggested best/optimum performance product to satisfy application and customer demands with help of advanced simulation and statistical analysis techniques.3) Leveraged ERP systems from ORACLE to reduce delivery lead time and ensure quality solutions to be delivered to solutions.4) Assisted customers in handling warranty failures and customer complaints.5) Aided migration of NRB's database into a new PLM system from PTC Corporation.

Master'S Degree, Management Information Systems, General

Master Of Technology (M.Tech.), Metallurgical Engineering And Material Science

Bachelor'S Degree, Metallurgical Engineering