Hardik Saluja

Experience

• 

  NielsenIQ

  Feb 2019 - Apr 2019

  Intern

  Platform API •Developed a LOG4J Appender in JAVA to convert one form of logs into another used by all platforms of the company •Developed J-Unit complex test cases for testing the LOG4J Appender created in the previous point

• 

  NielsenIQ

  Jul 2019 - Oct 2021

  Data Analyst

  Pulse Prediction Automation •Extracted Data from Oracle Database, Cleaned and Transformed it for analytics to gather insights for the BAU Steps that were being done to Audit Stores, with help of Python. Then Loaded the data into a PostgreSQL Database. Scheduled the script in a Cronjob. •Python Libraries Used: Pandas, Numpy, JayDeBeApi, Psycopg2, etc. Report Automation •Extracted Data from CSV files, cleaned and transformed it to plot graphs and insights for all the internal modules being used, a sent a health report to internal stakeholders, with the help of Python. •Python Libraries Used: Pandas, Numpy, Matplotlib, Table, etc. Web Scraping E-Leaflets •Developed JAVA code to convert a pdf of E-Leaflets to high-resolution images for a dataset for an ML model. Panel Management Utilities •Developed and Enhanced R code for Plan Generation of Stores for the following mentioned module. •Received Happy Client Award from the Stakeholder. Show less

• 

  Novartis

  Mar 2022 - Jul 2023

  Data Analyst

  Andromeda SP&S (Interactive Dashboard) •Added DB Manager page which is responsible for managing data from the various data tables in the PostgreSQL database.•Developed Snapshot Functionality which helps you choose in loading historical and Live Data on different pages of the application.•Added Portfolio Optimization Page, backend of Python, and frontend of R, which optimizes the portfolio based on complex input.•Optimized the DB which resulted in a more efficient and Optimized App and loading time faster by 97% for DB Manager Page.•Did Enhancement of the calculation engine that made dashboard backend processing and loading time faster by 50%.•Fixed Various Bugs throughout the Application.•Received Inspired Award, Star Award from the Stakeholder & Star Project from the Company•Technologies Used: R, R Shiny, PostgreSQLAndromeda NIBR (Interactive Dashboard) •Integrated and Ran Python Code (ML Model) with R code to have a backend of Python and a Frontend Dashboard of R.•Developed functionalities and added new features to the Dashboard •Received Galaxy Team Award from the Stakeholder.•Technologies Used: Python, R, R Shiny, R Reticulate. Field Medical of the Future (Analytical Report)•In charge of generating a Quarterly Analytics Report for the Stakeholders, which was done in Excel by getting data from the backend table of the Dashboard.•Automated the Report using Python, therefore, saving 80 hours of work every quarter.•Technologies Used: Python, Advanced Excel Show less

• 

  WTW

  Aug 2023 - now

  Senior Data Analyst