Rajat Sharma

Project 1: 1PD Utilization Dashboard

▪ Build complex automated query and applied business logic using SQL scripts.

▪ Transformed data to build quality dashboard in Tableau and helped Clients in understanding consumers buying behavior.

Project 2: Closed Looped Sales Insight

▪ Stitching together the log level data of media served, transaction level data of sales and audience pool using python, big query and Alteryx.

▪ Understanding the behavior of Buyers vs Non-Buyers for optimizing future media strategies .

▪ Markov model helped in increasing the sales of product

▪ Forecasting sales of top selling KC product using Time Series .

Project3: New Brand Marketing

▪ Monitoring brand quality using sentiment analysis .

▪ Concise content and making it more accessible to audience using NLP readability technique .

▪ Image marketing with new campaigns based on fine image features.

Project 1 : ETL Tool (Data Connect)

▪ NQAGT : Developed jobs in ETL tool for multiple clients helping in populating the employee plans data in database. Led key endeavors to ensure data accuracy and performed Sanity Testing on ad-hoc basis .

Project 2 : Implementing and ETL Testing: HMH, TFI Client

▪ Preloading (Base Structure): Performed Data Analysis by tuning complex SQL queries to handle and ensure data integrity for large datasets, creating reports for data discrepancy .

▪ ETL & Reconciliation : Performed Quality Testing as per client specified mapping using ETL method and created compare queries to confirm data accuracy , thus improving quality by 30%.

Project 3 : RYG Dashboard

▪ Transformed data to build quality dashboard in Tableau reflecting the trend of RYG calc data, helping with modelling the forecasting of the upcoming year data.

▪ Drew meaningful insights about the product performance and growth rate of the tool usage.

Project 4 : Company Resource Feedback

▪ Classification ML algorithm model based on Client feedback helped in understanding the Client satisfaction rate towards our company facilities.

▪ Analyzed and extracted the information from the Contracts and conducted detailed quality check .

▪ Used SQL queries to verify Revenue claims calculation and reported the accuracy of the profile.

▪ Communicated closely with clients about business requests and performed data quality control.

▪ Clients ( insurance companies like Cigna,UHG etc) interaction on weekly basis for issue resolution.