Sears IT & Management Services India Pvt Ltd., Listrak Migration and Listrak Data Import API, Listrak is a leading cross channel marketing platform. We started using Listrak to send Emails (Promotional, Transactional, Triggred, Points and Welcome) to our Email Opt Mmbers. We did the initial load of data and then we created daily process to send the data to Listrak SFTP which will consume the data and then populates its internal tables. Once the migration is completed we are required to get various data from Listrak like Campaign, Message, Email Activity, Link Click Activity etc. Created shell scripts to get the data by calling the Listrak Rest APIs and load the data into Big Query Tables. Implemented the logic to get the new token when the token expired and also implemented the cursor to get the next page data., Database: Big Query, Programming Language: Python 3.5, Shell Script Sears IT & Management Services India Pvt Ltd., Preference Center API, The purpose of this project is to create a Rest API which can handle the Email Preference of the Member when called from the Website and 3rd Party and store the data into database in Real-time. The Member can Opt-in or Opt-out from different promotional email or it can Opt-out for a month. The API should check that the data is in the correct format and all the required fields are provided. Created Endpoints for both POST and GET method. Cache the recent data using Redis., Google Cloud Technologies: Apache Beam Pipeline, Google Cloud Dataflow, Google Cloud Pub/Sub, App Engine, Redis, Database: Big Query, Programming Language: Python 3.5 Sears IT & Management Services India Pvt Ltd., Campaignmart, The purpose of this project is to collect all the email address from the different sources like Enterprise Data Lake, 3rd Party, Other Business Units like SYW, Home Services etc to create the tables like Email Source, Email Opt and Email Address. Furthermore it is used to collect different other Data like Thank You Purchase Offline and Online, Member Information, Profile Information, Address Information, Mobile Opt Information. These collected data are aggregated into different table like Audience, Profile and CustomerEmailOpt, ThankYouPurchase, MobileOpt and it is send to Adobe Campaign Standard for sending Promotional Emails and running different campaigns. Batch jobs are created and scheduled in Airflow to run daily., Google Cloud Technologies: Google Cloud Compute Engine, Cloud Storage, Database: Big Query, Programming Language: Python 3.5, Shell Script, Job Scheduling: Airflow Sears IT & Management Services India Pvt Ltd., Online Analytics and Marketplace Analytics, This project is used to collect the Online data of the Website from Adobe Tables and create the aggregate tables on business unit, marketing Channel, item store and calculate different metrics like traffic, visits, product views, orders, carts, sales, margin, burn points. Also created different tables for different activities like Cart Add, Cart View, Orders, Page View, Product Browse, Product View, Session etc. We also needs to make sure that the data is free from any BOTS. We also keep record of the Marketplace data keeping hierarchy of Marketplace Item, Marketplace Seller and creating different metrics like Sales, Return, Cancel, Commission, Total Orders for each sellers. We also have created a process to check which seller will win the buybox. These tables are then used as a source tables for different Tableau Reports used by Higher Management., Google Cloud Technologies: Cloud Storage, Compute Engine, Database: Big Query, Programming Language: Python 3.5, Shell Script, Job Scheduling: Crontab Sears IT & Management Services India Pvt Ltd., Email Click Data Feed into Real-Time Scoring, Earlier it was not possible to infer the Email Click Data links which Members clicked. It was not possible to send back the Member with curated offers in the Business Unit in which they are interested. The purpose of this project is to identify the Member who have clicked on the embedded links of the Promotional Emails that were sent to them and then figure out the Business Unit in which they have clicked and then create the data to re-score the Member by mapping the Business Unit to different MSM Models using the Scoring Engine. Once the Members are re-scored, that data can be used by different Marketing Team by Calling RTS API to get the Highest Scoring Business Unit of the Member and generate offers in that Business Unit., Google Cloud Technologies: Apache Beam Pipeline, Google Cloud Compute Engine, Google Cloud Dataflow, Google Cloud Pub/Sub, Cloud Datastore, Database: Big Query, Bigtable, Programming Language: Java(1.8) Sears IT & Management Services India Pvt Ltd., Consider Purchase System, The purpose of Considered Purchase System is to capture various Real Time occasion signals such as browse, duress, replacement, move etc. of a member and queue them for subsequent email communication. The system decides a send date for each email based on a set of priority rules and queues them. It also keeps track of the occasions that were sent in the past 30 days for a member and decides whether to send an email again or not. Once the emails are scheduled, a batch process runs and sends the queued email entries in outbox to Oracle Responsys which is an Email Management System of Oracle. The batch process then updates outbox to set the status of the communication as “sent”. Later, the Oracle Responsys sends out the actual emails to the members., Big Data Technologies: Apache Storm, Apache Kafka and Apache Zookeeper, Google Cloud Technologies: Apache Beam Pipeline, Google Cloud Compute Engine, Google Cloud Dataflow, Google Cloud Pub/Sub, Cloud Datastore, Database: MySQL and Google Cloud Datastore, Programming Language: Java(1.8) Sears IT & Management Services India Pvt Ltd., Real Time Scoring Pipeline, The purpose of the Real Time Scoring Pipeline is to re-score the Member Score in relevant product categories based on the Real Time events provided to these Pipelines. Member related events includes:- Customer buying something at the POS, Customer action on our websites (sears.com, kmart.com etc.), Email Feedback based on the response we get from the email that is sent to Member, Member Feedback on the feedback machine based on the Question and their Answers, Big Data Technologies: Apache Storm, Apache Kafka and Apache Zookeeper, Google Cloud Technologies: Apache Beam Pipeline, Google Cloud Compute Engine, Google Cloud Dataflow, Google Cloud Pub/Sub, Database: Mongo DB and Google Cloud Bigtable, Programming Language: Java(1.8), Modelling Technique: Logistic Regression / LightGBM Sears IT & Management Services India Pvt Ltd., Real Time Scoring API, This is a Rest API which is used to serve the Member propensity Score in different product categories based on defined arbitration such as Score, percentile and serves them to the different clients and helps them in generating offers in top product categories., Server: Linux Servers on which JBOSS were installed, Google Cloud Technologies: Google Cloud Compute Engine using Cent OS and Jetty to deploy the API, Database: Mongo DB and Google Cloud Bigtable, Programming Language: Java(1.8), Spring MVC Sears IT & Management Services India Pvt Ltd., Member Journey Tagging, This project is used to tagged each SYW (A reward program of Sears) Member into different Segments using the data mining techniques. These segments include various behavioral, lifecycle, predictive and demographic attributes. This can be used by Marketing Team to identify target population for promotional campaigns or targeted Member Communication., Database: Teradata, Google Cloud Big Query Amdocs Development Centre India Pvt. Ltd, Data Migration using ETL Tool, This project is about the merging the 11 DB into a single DB. The client wants to have a single platform to migrate all the data from the old system to 1 integrated system. The new system has complete different structure of tables compared to old system and thus we use an ETL tool for migrating the data. Also the project involves a strict timeline under which we have to complete the whole migration process., K2View (An ETL tool) Sears IT & Management Services India Pvt Ltd., On Going Activities, As part of On Going support, I need to solve defects open in Production in my Area of Work (Sales – Commission). Also I need to support the Batch cycle in case of any failures and need to provide fixes/solutions in the immediate time. Improving the performance of the Batch Jobs as well as the Summary Screen when there is huge data to process., Programming Language: Java, COBOL and Shell Script Sears IT & Management Services India Pvt Ltd., Value Package Long Term Solution, A value package is a kind of combo which is provided at a much lower cost than the individual items. To compute the combined and individual price of the component and package and calculation of commission to the sales rep., Programming Language: Java, COBOL and Shell Script Sears IT & Management Services India Pvt Ltd., Open First Solution, This was mainly involve to increase the sale by providing more customer friendly approach by assigning sales rep to door to the customer. It mainly involves mainly assigning the CSS (Customer Solution Services) to the customer to resolve their queries., Programming Language: Java, COBOL and Shell Script