Anubha Pant
*** **** ******, ******** ** ***** • 413-***-**** • ******.****@*****.*** • LinkedIn • Github Senior Consultant with Over 6 years of experience with companies like IBM, Bank Of America, CSC, MARKIT, Intuit in Data Analytics, Software development, and Team management. EDUCATION
University of Connecticut School of Business Hartford, CT Master of Business Analytics and Project Management Dec 2017 Uttar Pradesh Technical University Uttar Pradesh, India Bachelor of Technology in Information Technology May 2008 SKILLS
• Programming Languages & Tools: R, SAS JMP,SAS Enterprise Miner, SQL, Hive, Java, Rest API, R-Studio, Eclipse, Tableau, MS Excel, Visio, SQL Developer, SPSS, Advanced Excel, Agile/Waterfall, Visualization, Optimization
• Statistics and Machine Learning – Regression, Classification, Hypothesis Testing, Clustering, Random forest, Decision Trees, Clustering(K-Means /Hierarchical), Market Basket Analysis, PCA, Linear Optimization, Text Analytics
• Certifications: Oracle Certified Java Programmer, Oracle Certified Java Web Programmer, Python Programming-Data Camp, Tableau Certified-Udemy
EXPERIENCE
Life.IO - Capstone Project August 2017 - Present
• Developed master dataset to create a 360 degree view of user profile. Identified key metrics to define User Engagement. Used RFM technique to score User engagement. Used K means clustering to create customer segments
• Performed Logistic Regression, decision tree, significance testing & cluster analyses to identify relationships between decision Variables to perform customer profiling. Provided business recommendations to increase User engagement Intuit - Data Analytics Intern Mountain-View, CA US, May 2017-August 2017
• Risk Analytics: Translated business questions into verifiable Hypothesis. Identified key metrics KPI that indicate elevated risk. Performed Data preprocessing, Data aggregation using R & SQL created KPIs driven Interactive Dashboards 30 advanced visual reports comprising multiple views in Tableau
• Conducted meetings and interacted with various stakeholders and C level executives to capture Risk metrics
• Automated complete Risk Analysis Process instrumental in reducing the manual efforts by 200 man hours quarterly Bank of America - Senior Consultant December 2013-May 2015
• Performance Dashboard Performed adhoc analysis for Sales team and developed KPI driven dashboard for team to help them improve various operational efficiencies pertaining to allocation of manpower resources and helped boost sales
• Reporting – Developed a Java Based Reporting tool using Java Script and Rest Call API, which generated monthly report on banking application so that tellers can analyze the accounts created, opened, failed, closed on monthly basis
• Customer Response Model Marketing Campaign Designed a Response Model based on historical campaign data
&customer’s banking information and other socio economic factors to improve response rate by 14%.Used Gain and Lift chart to perform final model selection and improvement DXC Technologies- Senior Software Engineer July 2012-December 2013
• Created multiple REST web services to provide data needed for insurance client by third party applications
• SQL Performance Tuning: Using indexing partitioning re structured SQL queries returning large amount of data to perform faster retrieval of data. Increased the performance by 10% leading improved customer experience
• Hadoop/Hive- Extracted terabytes of point of sales big data (Hadoop; Hive) to analyze consumer behavior. Gathered client’s requirements for adhoc report development using SQL and Excel IBM India-Software Engineer January 2010-May 2012
• Developed new code, fixed production bugs, new enhancements for a web application using Java, MVC,& Struts
• Optimized SQL queries to reduce runtime of data load in production servers by 30%
• Used SQL for creating reports and fetching complicated data and performed data analysis, data preprocessing & reporting
• SQL& Java Automation - Automated 70% of the manual processes for my team through use of CRON, Java, SQL Academic Projects
• Sentiment Analytics Using R – Text Mining - Performed text analytics on the tweets for the United Airlines to analyze the sentiment, study the word cloud and predict the overall nature of the tweets
• Market Basket Analysis Cross Selling–Extracted sales data (SQL) for retail client and analyzed various transactional baskets. This was carried out in R (Apriori), generating product recommendations for the sales event.
• Retail Sales Forecasting Analytics – R, SAS JMP, SAS Enterprise Miner - Random forest, Linear Regression and Time series forecasting (ARIMA) - Predicted annual sales forecast for retail client; Constructed with seasonal adjustments