Mohammed Shoeb Ahmed Shakeb Email & Phone Number

Connecticut, United States

Senior Data Analyst at Evernorth, the Health Services division of Cigna

Bloomfield, Connecticut

➤ Working on enhancing the data quality and data management strategy by analyzing health insurance data sets of over 100 million records in HADOOP using Python, Hive, Impala and data science methodologies like clustering on demographic variables and insurance group membership and summarizing the analysis results by building Tableau visualizations for the business stakeholders➤ Performed comparative analysis of master data provided by 3 different vendors by comparing with internal demographic data; provided recommendation for selecting the vendor having the most accurate location data ➤ Proved instrumental in saving $12 million in mailing costs & redelivery transportation costs by improving the customer address standardization process for successful mail delivery➤ Implemented a strategy for customer retention by identifying and encouraging frequent medical care-seeking customers to enroll in paperless EOB i.e. to receive Explanation of Benefits document via email thereby contributing to the environment by saving paper; also saved material costs for the organization

Hartford, Connecticut Area

Course: Data Mining and Business IntelligenceProfessor: Xue Bai➤ Tutoring students on time series forecasting techniques, text mining and advanced data mining concepts➤ Assisting the professor in grading projects and assignments

Sandy Hook, Connecticut

UCONN Graduate Consulting Client: Doors to Explore Inc. (www.doorstoexplore.com)_______________________________________________________________________Doors to Explore provides an online career resource for high school and college students to discover and explore STEM (Science, Technology, Engineering, Math) careers.➤ Developed a corporate business model for DTE, an online career resource start-up, by performing market research; formulated a marketing strategy by identifying best channels to increase product sales➤ Proposed a strategy for customer acquisition and retention by segmenting customers based on education level, course interest and demographics➤ Implemented web scrapers in R and Python to search and extract job posts off Indeed.com and recruiter profiles, relevant to a student’s major and interest as well as location preference➤ Imported customer data into HDFS from flat files; gathered iinsights by analyzing data in Apache Hive

Hyderabad Area, India

➤ Received the prestigious Applause and Spot awards for client commitment and driving the team➤ Analyzed the audit data as well as operational data by developing complex SQL queries and enabled strategic decision making for senior consultants and managers by developing reports➤ Reduced the query execution time by 25% by optimizing the SQL queries for analyzing 4 million records➤ Devised KPI’s & GQM (Goals Questions Metrics) reports and implemented Tableau dashboards for communicating the project progress to stakeholders for agile decision making➤ Reduced 66% of manual effort needed for Daily Status Report generation by automating the report generation process in MS Excel using VLOOKUP, pivot tables and nested formulae

Master’S Degree, Business Analytics & Project Management, 3.96/4.0

Activities and Societies: UCONN Graduate Consulting (UGC)➤ Student Consultant for Doors To Explore (DTE), an online career resource client.

Bachelor’S Degree (Chaitanya Bharathi Institute Of Technology), Electronics And Communication Engineering, 83.21%

Activities and Societies: SYNAPSE - National Technical Symposium➤ Organizer: SYNAPSE - National Technical Symposium ➤ Chess player.