Data Sales

Summary: Five+ years’ experience in Business Intelligence/Data Analysis across domains Life Sciences, Sales, Healthcare, Finance and Insurance. I have applied my analytical skills to discover business insights. Currently seeking role as a business analyst after finishing graduate degree.

EDUCATION

Santa Clara University

MS in Information Systems Graduated March 2020

SRM University

B. Tech in Instrumentation and Control Engineering Graduated August 2011

TECHNICAL SKILLS

Python, Business analytics, Sales operations, Sales finance, Data storytelling, Operational Excellence, Automation, Sales requirements, Business Requirements, Product design, Data warehousing and Architecture, Statistics, Machine Learning, Data infrastructure, Business operations, Data analysis, Data architecture, Documentation, SQL, MySQL, SQL Server, ETL Scripting, Data Science, Pentaho, Data Visualization, Tableau, QlikView, Seaborn, Finance, Power BI,Software Project Management, SDLC, Agile, Project Planning, MS Excel, Process mapping, Complex data sets, Sql Queries, datasets, Big Data, Data reporting, Hadoop, Marketing, Data analysis

Work Experience

Data Analyst Intern

Gilead Sciences, California Jun 2019 – Sep 2019

Automated the data pull request by creating a Python Script of usage statistics of the websites, perform ETL to prepare the input data for the Tableau dashboard, streamlining the data preparation process for data quality analysis and cleansing

Developed a Tableau dashboard that will be used to monitor, analyze, and optimize the behavior of the user with the online databases

The dashboard tracked website traffic created scorecards for high-level metrics and in-depth reports for user activity based on session, bounce rate, and page views, etc.

Forecasted the website usage for the next 13 months using past data using exponential smoothening models

Business Intelligence Technical Lead

Infosys Limited Client - Analog Devices, Massachusetts Sep 2016 – Jan 2017

Implemented enterprise-wide business Intelligence reports in Tableau for sales content analytics which resulted in 60% increase in sales productivity

Designed a data pipeline from Salesforce CRM to Tableau Server using REST API and Postman to facilitate self-service analytics and automating updates on the tableau dashboard.

The tableau dashboard tracked engagement across the sales content, identifying trends by teams, documents, and location.

Handled areas like estimations, resource forecasting, customer business requirements, client management and customer engagement, documented project best practices

Designed, developed, tested, and maintained Tableau reports based on the requirements using complex calculations like Row-level calculations, LODs, Actions, URL actions, Cross tabs, Parameter, Trend lines, Forecast lines, Maps, Dual-axis bar chart, Data blending and extract optimization.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Created basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.

Representing data using the visualizations such using Charts.

Use Trend Lines, Reference Lines and statistical techniques to describe the data.

Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions. Use parameters and input controls to give users control over certain values.

Combine data sources by joining multiple tables and using data blending.

Business Intelligence Developer

Cognizant Technology Solutions Client – MetLife, India Sep 2014 - Feb 2016

Designed BI analytics reports using Tableau which identified bottlenecks in sales claim processing system thereby increasing customer retention.

Implemented projection execution dashboard for project development lifecycle using KPIs and metrics

Developed an end to end data model with SQL pipeline to improve performance of the Tableau dashboard by 90%

Defined historical and incremental refresh frequency in tableau for the data refresh

Heavily Used combined axis and dual axis charts with multiple measures.

Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis.

Worked on Creating visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique within the tableau workbook.

Created different visualizations using cross tables, Bar charts, Pie charts, Maps, line charts, scatter plots using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using data blending and interactive views, trends and drill downs

Business Intelligence Developer

Tata Consultancy Services Client - Glaxo smith Kline, India Oct 2011 - Sep 2014

BI reporting in QlikView by analyzing huge database of drugs Rx and sales metrics provided by IMS health and analyzed trends of the drug demand around the strategy to launch and overall impact. Implemented a data warehousing solution and created data integration workflows and wrote SQL statements to support analytical and query requirements

Improved efficiency of code by performance tuning; performed code reviews for ETL interfaces

Designed and developed around 30+ QlikView reports

Performed re-architecture of the data model in QlikView to improve scalability and performance of the dashboard

Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

Developed load script using QlikView Functions (Date and Time, Keep, Join, Mapping, String, Interval match etc.)

Created QVD and updated on timely basis as database updates.

PROJECTS

Student Portal Web application

Developed a web application for Santa Clara University hosted on AWS using Django, MySQL and HTML to help current students connect and network with their peers, alumni, and mentors

Instacart Market Basket Analysis http://bit.ly/30GBwRy

Seaborn, matplotlib, pandas to visualize insights for Instacart to increase revenue by analyzing customer’s purchase behavior

Analyzed over 3 million selected grocery orders in Python using Pandas from Instacart users to understand customer’s purchase behavior and reorder pattern to predict future orders using data mining techniques

Predicted how position in cart affects reorder probability of products by implementing Decision Tree Regressor

Android Fundraising app http://bit.ly/36i8d97

Developed an android app using Java to create fund me campaigns and accept payments from campaign donors

Used Google Pay API to retrieve user payment information and integrated with Stripe SDK to accept donations

Integrated Google Firebase for database storage to store and donate campaign-related information

Startup Acquisition Analysis https://tabsoft.co/2NLqaGp

Tableau, Python, and D3.js to visualization to analyze the impact of education of startups founders & CEO on acquisition.

Visualized startup companies acquisition data from CrunchBase to find insights if higher degree (MBA, MS, PHD) is important for a successful acquisition.

Visualized and found insights for top locations, markets across US having higher acquisitions and the Education profiles of key individuals across top market segments

Sentiment Analysis http://bit.ly/37d0dXT

Pandas, NumPy for sentiment analysis to calculate the count of positive/negative words

Global Terrorism & Refugee Migration https://tabsoft.co/3at87P8

Used Tableau to identify top affected countries by terrorism and migration pattern of the refugees.

The dashboard visualized the time series analysis for terrorism patterns .

New York Airbnb Price Prediction http://bit.ly/37f4TN3

Seaborn, Matplotlib, Linear Regression & XGBoost to visualize insights & predict price for host by feature engineering

Kiva.Org Loan Analysis. http://bit.ly/30DBgTa

Pentaho ETL, Tableau for data warehouse creation, ETL routines, maps, materialized views, stored procedures to design dashboards showing insights about lenders and borrowers.

Book Recommendation System http://bit.ly/2TIiIzR

Cosine Similarity, Pandas to create a machine learning model for recommending books for users

The model recommended books for user based on reviews and past user history data

Contact this candidate