Tech Stack: Rails 4.2, MySQL, MongoDB, Webpack, Vue.js, Bootstrap

My role in this Product is to develop the scalable Internal products for fulfilment centre, operations, Sales, finance and inventory teams.

This application is a location data service provider which collects location's information by scraping. It aggregates data that it collects by applying different heuristics/smart logic built into the system and passes through various stations/phases where it applies those logic
and normalises the data to more structured information, for examples the information could be the lists of retail store locations or geographic country information. Here are the different projects that I have worked on so far for this client.

Premium Application:

This application is for premium customers where they get access to all the location related information in various formats like csv, pdf, tsv etc.

Tech stack: Rails 4.2, MySQL, Redis

Requirements: Providing premium clients with an interface to various tools to access data
My role in this project was to understand the existing controllers, schema, models and the workflow of Rails applications and to create features like admin tools, publisher tools, data browser, list builder - programatically creating a very large data set, user
preferences(premium user).

Tools Project:
This project provides APIs to directly access the lists and locations data contained within the data library. These APIs are accessed by various clients and 3rd party services. It also acts as a middleware to whitelist the API requests to access the data from Apache Solr, by
generating Solr queries on the fly which does full-text, facet, group search and deals with 70+ millions of data sets.

Tech stack:Rails 4.2, MySQL, Redis
My role in this project was to create efficient REST APIs in rails and detailed documentation of request, response, and with examples. Here the users are restricted to access specific set of data based on roles and permissions granted to them. The role based access system and data access permissions are implemented using cancan gem. We have used resque-scheduler to schedule the data delivery via Google cloud, AWS S3 bucket, FTP automatically to various clients based on their preferences.

QAExpress:
This project is a Ruby library consist of various stations / phases to normalize and formats the scraped data to user ready format and imports the data to warehouse
This is an existing library, my role in this project is to add improvements, refactoring the existing logics, bug fixing based on business needs

Manual Geocoder:
This project is a full stack as well as 100% progressive web app for altering the existing geocodes with new ones. It uses Loopback 3 for backend APIs and Vue as frontend.

Tech stack:
Loopback 3(NodeJs Framework by IBM), MySQL, VueJs, GoogleMapsJs.

Backend:
This project splits the locations into working, verified and unverified geocodes. My role in this project is to create JSON APIs that filters
the data based on multiple filters like states, countries, tags, categories, types and allocates a batch of unverified locations to a
geocoder user. Once the locations allocated to a user then the other user won't get the same location again, to achieve this, we created
a node js bucket library to apply filters and to reserve a batch of locations to a user. We used role based authorisation for Admin and
Geocoder using role resolver by loopback.

Frontend:
This project gives interface to verify, reject and approve the locations from data library. It uses Vue, Vuex, Vue-router, Vuetiify, Vue-2-
google-maps, sw-precache, vue2-leaflet. My role in this project is to create shared components which can be dynamically reused for
different roles, dynamically register components to provide scopes in UI. Handled map, markers events to manage geocode
verifications. We have used role based access to routes using vue-router meta attributes, hooks and navigation guards. Implemented
100% progressive web app, with full responsiveness for mobile devices with push-notifications. Improved page load speed by using
webpack sw precache to dynamically cache js assets based on user access, also code splitting architecture to minimize the size of app
bundle.

My role in this project is to build an automation which can have various phases and validations to generate security keys on given
conditions

I've done major optimization in this project by writing cost effective MS SQL queries and bring down the turn around time of the overall
execution