Mayank Vir Email & Phone Number

New York City Metropolitan Area

• Utilized techniques like Kaplan-Meier analysis, Cox proportional hazards regression modeling as well as Monte Carlo simulation.• Developed study design utilizing targeted maximum likelihood estimation (TMLE) and G-computation.• Implemented Multivariate Imputation by Chained Equations (MICE) method to handle missing covariates. • Engineered ETL pipelines in Databricks handling SDTM, ADaM, and other diverse data formats.• Automated descriptive analysis and reporting, saving at least 20 hours/week. • Developed impactful data visualization dashboards to drive insights and decision-making.• Conducted rigorous statistical analysis like Causal Inference and Survival analysis enabling project insights.• Orchestrated end-to-end project lifecycles including research, protocol design, analysis, and client presentations.• Led NLP initiative targeting depression detection on social media utilizing unsupervised machine learning techniques.• Headed a 5-person team to automate systematic literature reviews using APIs, web scraping, and integrating AI(ChatGPT 4), reducing resource requirements by 60-70% while improving efficiency.

Rochester, New York, United States

• Led data ingestion initiatives, managing storage and retrieval processes for a high-volume data lake hosted on AWS S3.• Designed and maintained data catalog tables on Amazon Athena, enabling structured data querying and analysis for stakeholders.• Conducted end-to-end unit testing to validate data pipelines, guaranteeing data accuracy and reliability. • Developed real-time dashboard for marketing team using Twitter API, Pandas, Matplotlib and Tableau.• Created telegram bot to collect inventory data from multiple sources via web scraping and APIs.• Applied NLP and ML to build parser for ingesting varied inventory sources.• Built real-time application monitoring systems to track user sessions, traffic, performance with DataDog.• Analyzed asset waterfall, created tools gathering user details, metrics and crash reports.

Delhi, India

• Developed Python scripts leveraging AWS S3, Lambda, and Athena to build cloud data platform ingesting retail transaction data.• Processed data into Parquet format and stored securely in S3 data lake architecture optimized for analytics.• Performed data transformations using Athena, SQL and Python lambda functions for cleansing and enrichment to enable analysis.• Built QuickSight dashboards connected to S3 data lake to provide self-service visualization of customer purchasing behavior.

Bengaluru Area, India

• Project: Call Log Analysis (Banking Infrastructure Analysis, Client: Morgan Stanley).• Analysed call logs addressing fraud detection, network health, audio data trends for a top US bank.• Managed large volumes of data from log processing systems (SPLUNK), Kafka, Spark streaming, and PostgreSQL.• Optimized SQL queries for faster OLAP and OLTP in PostgreSQL, utilizing concepts like shredding and column stores.• Project: Fraud Analytics - Real-Time Decision (Client: Morgan Stanley).• Implemented a real-time fraud prediction system, integrating ML models with existing fraud policies.• Optimized Hive queries via partitioning, bucketing; automated reporting with Pandas.• Built ETL pipelines for efficient data processing using Oozie workflows.• Project: Audit Notes Rejected Documents Analysis (Client: Morgan Stanley).• Applied unsupervised topic modelling and semantic matrix factorization in Python.• Parsed CLOB files into Hive, visualized topics, analysed large datasets using statistical and ML techniques.• Conducted data engineering, validation, and transformation using Python (PySpark and Pandas).• Project: Predictive Recruitment Analysis (Client: Morgan Stanley).• Developed binary classification models for recruitment team, aiding in candidate selection for college recruitment drives.• Created ETL pipelines with Dataiku; transformed data using Python scripts.• Ensured data cleanliness and validation, focusing on performance and unbiased machine learning solutions.

Master'S Degree, Data Science And Applications, A

Education record