Yash Malhotra Email & Phone Number

New York, Ny, Us

New York, Ny, Us

Cleveland, Oh, Us

Cleveland, Oh, Us

Cleveland, Ohio, Us

New Brunswick, Nj, Us

New Brunswick, Nj, Us

Client - Jhonsonn & Johnson (Medtech) Developing Data Products for the largest Pharmaceutical Conglomerate in Healthcare & Life Sciences Domain for their Data Engineering and Visualization Needs.Developing Data ingestion-oriented Serverless Frameworks and APIs (HTTP, and REST) on AWS Serviceslike API Gateway, Redshift, Athena, Spark Glue, Lambda, etc. with orchestration using Airflow.Developed robust pipelines on the spark in AWS Glue to Process 8.5 Million records into the Data Platformin < 30mins.Written a custom Python connector library to connect and run SQL Query on Redshift, Postgres, Mysql,Aurora DB, RDS, Oracle DB, Glue, Athena, etc. The Library is imported within Python and Pyspark scriptsto retrieve data or run queries on the respective DBs.Used OOPs concepts to develop all the classes for the above DBs, integrated pandas and SQL Alchemysupport within each class to make it reusable for the users/developers.The whole platform is a single config file driven, developed the file generation module autonomously andorchestrated it with airflow.Working with Different REST APIs with Python, such as Denodo JDBC API, Qlik REST APIand Python API for Spark - Pyspark.Creating Data Pipelines and File Processing Frameworks to apply transformations andData Cleaning for CSV, Excel, JSON and XML Files.Impact: - The File Processing Framework is an Intelligent tool that Checks for MetaDataValidation and Schema Evaluation for the latest Files in an AWS S3 Storage. It sends anEmail Notification to the user whenever it interacts with any old Files, empty files andSchema Change evaluated files. For the User and Support team to know about anyDiscrepancy faced at any point During

New Brunswick, Nj, Us

Creating Data Products for the largest Company in the Healthcare & Life sciences Domain.Working with Different REST APIs with Python, such as Denodo JDBC API, Qlik REST API and Python API for Spark - Pyspark. Creating Data Pipelines and File Processing Frameworks to apply transformations and Data Cleaning for CSV, Excel, JSON and XML Files.Impact: - The File Processing Framework is an Intelligent tool that Checks for MetaData Validation and Schema Evaluation for the latest Files in an AWS S3 Storage. It sends an Email Notification to the user whenever it interacts with any old Files, empty files and Schema Change evaluated files. For the User and Support team to know about any Descripency faced at any point During the Data Load Process.Ensuring a Hassle Proof ETL process.

New Brunswick, Nj, Us

| Artificial Intelligence and Analytics | Life Sciences

Teaneck, New Jersey, Us

Client - GlaxoSmithKline (GSK)Learnt & Created ANSI SQL Scripts in MySQL & SQL Server forboth OLTP & OLAP DBs & DWs respectively.Learnt about the Data Warehousing life cycle & ETL process withUnix & Shell scripting.Learnt ETL Process with Microsoft SSIS Tool in Visual Studio &creating Facts & Dimension Tables for raw Data.Learnt Azure Data Factory for creating Parametrized DataPipelines for Big Data Analysis using HDInsignts & Databricks.Learnt & created Multidimensional (MDX) cubes & KPIs for Datamining using MDX Query Language.Used Power BI for Data Transformation, Modelling & DataVisualization with the help of DAX Query Language.

Kolkata, West Bengal, In

Wattana, Bangkok, Th

Noida, Uttar Pradesh, In

✓Analysed KPI's and different metrics for different hierarchical levels of management of a power plant.✓Created PRDs for the apps & websites made for different managerial levels of the Power Plant.✓Created UI & UX Wireframes for the apps & websites for different Stakeholders.

Nashik, Maharashtra, In

✓Data curation✓Data Processing & Analysis✓Report Generationusing Google Sheets, Google Trends & Google Analytics

✓Formulated & changed the business model for the startup bytime to time according to market trends.✓Used city analytics & helped the team in developingalgorithms regarding the optimal solution for deliveryservices.✓Analysed the market & used customer experiences to retaincustomers & grow the customer base .✓Analysed customer needs & feedback & suggest changes inthe technology stack & User Interface of the website.✓Tied up with local wholesale stores for better growth as apart of our business expansion strategy.

✓Hands on experience VLSI, ASIC, FPGA Design Flows✓Digital Logic Design ✓Verilog HDL✓FPGA Prototyping ✓LInux OS(Ubuntu) ✓Shell Scripting.✓Designed & Emulated an ATM Controller (FSM)✓Designed & Emulated a Washing Machine Controller(FSM)✓Designed & Emulated a VGA Controller Protocol.

Master Of Science - Ms Thesis, Computer Science

Bachelor Of Engineering - Be, Electronics And Communication Engineering

Hsc, Aissce, Physics, Chemistry, Mathematics, Physical Education, English (Core)