Data Analyst

Bhargav Tippinayani

470-***-**** *******.*@******.***

Summary:

More than six years of work experience in Data warehousing, Business Intelligence & Data Mining.

* ***** ** **** ********* experience in Retail industry which includes Data reporting on KPIs, predictive modelling methods, AB testing on websites using Drupal and Google Analytics etc.

2 years of experience in Health care analytics where I balanced simultaneous requests for data analysis, reporting and Modelling on data related to market, patient and financial outcomes.

Expertise in the field of Data Mining: Predictive Modeling, Segmentation, Text Mining, Sentiment Mining.

Experience working on A/B Testing, Cohort Analysis, Decision Trees, Regression Models, Neural Network Models, Ensemble Models, LARS models, LASSO models and ANOVA.

Proficient in RFM Analysis, Cluster Analysis, Market Basket Analysis, Credit Risk

Utilize data to assess the impact of potential business decisions on customer spend and profitability

Excel Expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad range of industries.

Skilled in VLOOKUP formula development, Pivot Table generation, and Power pivot reporting.

Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks.

Proficient in Python scripting for data abstraction, data cleaning and data manipulation. Well versed with Database Structures

Technical skills:

Data Analysis Software & Tools:

R, SAS Base, SAS Enterprise Guide, SAS Enterprise Miner, SAS Text Mining, Stata

Business Intelligence:

Micro-Strategy, IBM SPSS Modeler, SAP, Tableau.

Databases:

Oracle,SQL, SQLite, Microsoft-Access.

Programming:

Java, Python, SAS 9, Stata, R (Beginner)

Other Tools:

Visual Studio, Eclipse, Quality Center

Academic Courses:

Database Marketing, Data Mining and CRM Applications, Business Intelligence Tools and Techniques, Advance System Analysis Design, Advance Data Mining, Advance Database Management, Enterprise Resource Planning, Information Systems Project Management.

Professional certifications:

SAS certified Base Programmer for SAS 9

OSU and SAS Data Mining Certificate

Sun Certified Java Programmer 1.5 (SCJP)

Education:

Master of Science – MIS OSU and SAS Data Mining Certificate Dec-2015

Oklahoma State University, Stillwater, OK

Bachelor of Engineering – Electronics, Communication Engineering May-2010

Sri Krishna Devaraya University, Anantapur, India

Work Experience:

Tech Mahindra, Client: Google, Mountain View, CA Jan 2017- Till date

Data Analyst

I have conducted data analysis to make business recommendations (cost-benefit, invest-divest, forecasting, impact analysis).

I have delivered effective presentations of findings and recommendations to multiple levels of stakeholders, creating visual displays of quantitative information.

I have developed and automated reports, iteratively build and prototype dashboards in Pulse using Dremel and PLX to provide insights at scale, solving for analytical needs.

I have collaborated with cross-functional stakeholders to understand their business needs, formulate and complete end-to-end analysis that includes data gathering, analysis, ongoing scaled deliverables and presentations.

I have also helped Google to focus on key decisions to improve products and services.

UTHealth (Department of Neurology), Houston, TX Jan 2016 – Dec 2016

Data management Analyst:

I work on the data quality of different stroke net data bases like Registry, Lester and Endo-R.

I also worked on templates for building different Stroke database views which ensured the quality for easy statistical modelling.

I created reports on the data abnormalities found in the databases using tools like Stata, SQL and Tableau.

I created different descriptive statistics summary dashboards on the longitudinal databases which were used in different procedural decisions in the hospital.

I created different Survival analysis models and GEE models on Neural Stroke patients’ data using SAS.

I automated different reports by using SAS Macros and Standard Procedures in SQL for code reusability and customer convenience.

Environment: SAS Enterprise Guide, Stata, SQL, tableau, MS-Access.

Oklahoma State University, Tulsa, OK Aug 2014-Dec 2015

Graduate Research Assistant

Created Visualization dash boards to monitor website traffic and evaluate user experience using Google Analytics

Built Macros and Stored Procedures to automate the routine querying and updating activity

Designed and developed web-pages, web-forms utilizing various programming techniques including HTML, PHP, CSS, and Java Script.

Environment: Google Analytics, MS- Access, Excel, Drupal, Django, SQLite, Java Script.

Tata Consultancy Services(TCS) Mar 2011-Jul 2014

Data Analyst

Build store procedures using PL/SQL to extract the data from Data ware house tables.

Involved in Data Validation, Data Cleaning, Data Imputation and Data Transformation techniques

Created new variables from the existing data using SAS programming.

Developed SAS Macros for easy automation of daily processes which also helped in code re-usability.

Identify, develop and/or validate segmentations, key indicators and create weekly reports and dash boards for the same using SAS Enterprise Guide and Tableau

Environment: SAS Enterprise Guide, SAS Enterprise Miner, Tableau, Excel, Oracle, SQL Server

Publications:

“Association of splenic contraction and development of SIRS after acute ischemic stroke” – Published in Neurology on April 2017

“Abstract: Lone Star Stroke Consortium Tele-Stroke Registry”- Published in Stroke on February 2017

Contact this candidate