Data Analyst Resume
TECHNICAL SKILLS:
Programming: S QL, SAS, R, Python, SciKit - Learn, J AV A, J2EE, MapReduce, Hadoop, Hive, Pig, NoSQL, Unix
Too ls: R Studio, Rattle, S AS En te r p ris e M in e r, Omniture, Google Analytics, Ad v a n ce d M S Exc el (Analytics addins), M S A c ce s s, Erwin, Tableau, QlikView, SAP Business Objects, Toad, SVN
Databases: Teradata, Or ac le, DB 2, My SQ L, MS SQ L Se r v er (Relational and OLAP), SSAS, SSIS, SSRS
Web Technologies: J SP, CSS, Ser v lets, JavaScript, A J A X, JSON, JQuery, XM L, XSD, HT ML, SOAP, RESTful
Design: Object oriented design, Data Structures, Distributed Computing, Error handling
PROFESSIONAL EXPERIENCE:
Confidential
Data AnalystResponsibilities:
- Dimension reduction from 142 to 26 through understanding of the dataset literature and correlation plots
- Target variable is Total charges for a hospitalized kid and objective is to find drivers
- 32 Primary diagnosis and 7 Primary procedures came out significant from running linear and stepwise regression, with an adjusted R-square statistic of 71%
- Improved 20% customer traffic across major business flows for Verizon wireless website (Activate and Switch Device, Current Plan Change), suggesting corrective actions for major session drops
- Extensive funnel analysis and exit paths by use of Teradata/Aster n-path analysis (advanced sql and pattern match) across funnels of the Verizon wireless website. Integration with VOC chat analysis and tell a story
- Delivered Tableau dashboards for channel mix and top selling devices
Confidential
Data AnalystResponsibilities:
- Applied data transformation, correlation analysis and predictive modelling using Logistic Regression, Random Forest and Decision tree. RF gave the highest test Confidential of 0.66
- Survey response rate, medication reconciliation rate, patient recommendation star rating, doctor communication star rating and patient electronic record access rate came out to be significant variables
- 69 explanatory variables including the client region, client category, industry and the date of project
- Achieved a true classification of 86.5%. Used MICE for imputation, VIF for collinearity check and Random Forest for modelling
Confidential
Data AnalystResponsibilities:
- Performance visualization of the 2016 Manchester United squad using Tableau
- Insights for future player selection through visualizations using D3, JSON, Shiny and ggplot2
- Multivariate regression analysis on the third largest brand recommending measures for it to gain more market share
- Time series analysis with 4 years data and forecast for the 5th year with the ARIMA (p, d, q) model.
- Hierarchical and non-hierarchical clustering of the variables of interest like Average Volume Purchased, Average Price Paid, Total volume purchased and Total dollars spent and map those to demographics
- Performed data cleaning, correlation analysis and regression analysis to narrow down to 23 significant variables (from 173)
- Achieved 63% accuracy for predicting customer churn using a logistic regression model on 100,000 data points
Confidential
Consultant
Responsibilities:
- Created enterprise-wide dimensional reporting based on complex views on MS SQL Server reporting status of procurement, production and logistics to management
- Owned the Metal Management System application running on JSF, Java, SQL and Stored Procedures
Confidential
Data Analyst
Responsibilities:
- Owned the Lloyds insurance data model
- Designed critical insurance web-services using SOAP, as part of migration to middleware insurance services from legacy java services
- Saved loss of 500 end user transactions by architecting a Store and Forward module using SQL , which stored end user messages in the database during daily maintenance hours
- Worked from the Lloyds office at Halifax, United Kingdom from November 2011 to October 2012
Senior Consultant
Confidential
Responsibilities:
- Led design, coding and testing enhancements of Websolutions insurance product using AJAX , JSON , JavaScript , Java , SQL and SOAP web services
- Led a team of 5 and transitioned project knowledge to IBM for support
Confidential
Senior Engineer
Responsibilities:
- Created $50000 financial benefit for the client by automating the daily synchronization of the eclipse workspace with source code repository, used by 20 developers
- Designed, coded and tested a complex futuristic banking platform using Java , enabling Misys to sign its first client
- Automated merging of business processes across multiple releases by deploying an Eclipse Plugins based intelligence tool
Confidential
Software Engineer
Responsibilities:
- Led coding and design activities for the Confidential web application, a CDI (Contractor Default Insurance) program of AON, across USA and Canada.
- Mentored a team of 3 and transitioned project knowledge to them
