PRINCE BHARDWAJ

Created Email Data Pipeline using Python and AWS to fetch excel from mails and populate the result on product UI. Also added slack alerts and error mails notifications using Python. Handled ETL processes using See-Burger tools i.e BIC mapping designer and BIS frontend to extract data from client, applying transformations such as EDI-JSON, XML-JSON conversions and loading it to a data warehouse. Worked on MongoDB to perform basic operations like editing, deleting and updating schema. Worked on Docker and Kubernetes to monitor the pods and logs of different services.

Worked in Location Intelligence R&D department to develop and enhance existing geocoding processes. Created, Optimized and enhanced data pipeline which fetches data from data lake, store it on the cloud i.e., AWS S3 and then fed it into data warehouse i.e. PostgreSQL. Worked on various AWS services i.e. S3, EC2, RDS, Redshift, SQS etc and optimized the same in order to reduce overall AWS costs.

Worked closely with software development and testing team members to design and develop robust solutions to meet client requirements for functionality and performances. Worked on Amazon requirements to create Customer Scanning Dashboard which gives complete visibility of bags during multiple legs. MySQL was used for creating dataset, ZOHO for data analytics and python for data processing. Created GPS tracking dashboard using ZOHO Analytics, MySQL and Python. This dashboard gives proper visibility of GPS fitted assets location-wise, trip-wise and overall percentage offixed and portable GPS.

Worked on Research Project in National Institute of Technology, Surathkal, Karnataka that focusses on Energy consumption in location-based Android application which initially involves data analytics using R programming and python for data processing.