Senior Consultant Analytics

• Transformed, cleaned final expense insurance data containing 2.3M policies; Implemented exploratory data analysis to better visualize data.• Performed feature engineering & features selection on 46 variables from datasets to train the model.• Built machine-learning models to predict the likelihood of policy lapse, got 85% accuracy from the logistic model.• Developed new agent profitability matric to help the organization in determine which agent is performing best among all.• Created visualization and analyzed data to provided actionable recommendations based on gender, population concentration.

• Analyzed customer review data of women clothing chain for the multinational brand.• Handled Missing data and created new variables to improve the model performance. • Visualized data using seaborn, wordcount and implemented TF-IDF for text mining. • Built AdaBoost, Naive Bayes algorithm to predict sentiments of customers based on their reviews and ratings. • Provided recommendations to improve customer satisfaction level and boost their business sales.

• Performed analysis, validation, visualization and gap analysis on the financial, customers and sales data • Analyzed customer behavior, interest, geographical area to provide impactful insights and helped business in data driven decision• Extracted raw data from multiple sources, performed data cleansing, Aggregation and loading data into databases• Identified, analyzed, and interpreted trends and patterns in complex data sets using statistical techniques• Designed tableau dashboards to track and monitor all key performance indicators (KPIs) and business metrics in one place• Built intuitive interfaces, visualizations and infographics with storytelling dashboards to help streamline and improve processes

• Gathered and analyzed business requirement; Built custom reports for the client.• Developed and modified ad-hoc Reports, Sub-Reports using SSRS as per client requirements• Investigated the root cause by backtracking the report to their golden sources and resolve any data anomaly• Optimized reports (SSRS) by optimizing long-running SQL queries using indexing strategies and query optimization techniques• Developed, shared and maintained daily, weekly, monthly and yearly reports with clients and performed bug fixing.• Worked on end to end migration project; included migration, up-gradation, testing of reports (SSRS)• Created Unix scripts to automate the process, helped in reducing the man-hours• Maintained Database by taking checkpoints, syncing data with production, creating Lockdowns