Ashok Bhatraju

908-***-****, ads50f@r.postjobfree.com, linkedin.com/in/ashokbk

EXPERIENCE

hMetrix - Product Strategy analyst / Data analyst June 2021 - Present

● Managed value based bundled episode program in collaboration with Maryland health department

● Responsible for project related documentation, backend data analysis, client communications and web portal

● Worked on identifying strategies to improve organizations business in acquiring APCD projects

● Working on a strategy to commercialize inbuilt products that can generate new revenue streams

● Created GTM strategies for in built engine and the required product and client outreach material SpotOnResponse (SABER) - Data Science Analyst - Capstone project, Chicago January 2021 – March 2021

● Administered data collection to predict shop closures during hurricanes based on the reported data.

● Performed data cleaning and reduced variables from 59 to 23 based on their relevance to outcome.

● Converted categorical variables to numeric and created new variables from outside resources. Strut Learning - PR and EQ Analytics Intern - Chicago, USA August 2020 – January 2021

● Developed a summary KPI document to provide insights from social media platforms to PR team and investors

● Monitored activity over companies website by Google analytics and provided insights to improve traffic by 50%.

● Created a final list of tables and database that can help calculate the EQ of kids and monitor their progress. ICICI Bank - Relationship Manager, INDIA June 2018 - August 2019

● Engaged in cross functional team activities to find potential clients after carefully analyzing data at hand.

● Performed due diligence, negotiations with customers and structured transactions to mitigate risk.

● Identified various additional revenue streams to gain a book value of $8.3 million during my stay.

● Appraised the credit transactions of medium - sized companies ranging from $1 million to $5 million. Hindustan Coca - Cola Beverages (Summer intern), INDIA April 2017 - June 2017

● Researched and finalized various available E-procurement software’s to perform online RFQ process.

● Optimized the route for Raw Material and Packaging Material which helped save $160,000 every quarter. EDUCATION

UNIVERSITY OF ILLINOIS CHICAGO - GPA: 3.88, Chicago, IL May 2021 Master of science in Business Analytics A lifetime member of Beta Gamma Sigma (BGS) INDIAN INSTITUTE OF MANAGEMENT, KOZHIKODE, INDIA - MBA - Marketing and Operations April 2018 SCHOOL OF PLANNING AND ARCHITECTURE, INDIA - Bachelor of Urban Planning May 2016 TECHNICAL SKILL

Programming tools: Structured query language (SQL), SAS, R, Python Functional: Decision making, Analytical thinking, Data collection, Planning, Analysis, Research and Exploration(EDA) Visualization/analytical: Tableau, Microsoft Power BI, Matplotlib, Microsoft Excel, Google Analytics, KPI Modelling: Unsupervised (Clustering, Dimensionality Reduction), Supervised ( Regression, Classification techniques, Ensemble methods), NLP (Stemming, Lemmatizing, part-0f-speech tagging, N-gram analysis, Sentiment Analysis) Machine learning/Database- Pandas, NumPy, Scikit – Learn, SQL server, Amazon Redshift, MongoDB Certification: Product Management, Statistics, Power BI, Machine Learning, Basics of AI, Data Storytelling ACADEMIC PROJECTS

Strategy Consulting Virtual Internship(BCG) – InsideSherpa

● Provided insights based on market research data of existing handset leasing markets across the world using Excel.

● Performed price comparison and suggested changes to the proposed plan that can increase subscription numbers. Market Segmentation: Segmenting Customers of Bath Soap (Unsupervised learning) – Using R

● Clustering analysis is performed on the basis of purchase behaviour(brand loyalty) and basis of purchase

● Various values of K are used to determine the best segmentation in data based on cluster distances

● Final K value of clustering is determined based on distance within clusters and between clusters. Taxi Fare Prediction: Prediction of fare (Supervised Learning) – Using Jupyter Python

● The New York taxi cabs data of 50 million data points is trimmed down to 5 million for analysis purposes.

● Data exploration followed by variables relevance to target variables is identified after visualizing various variables.

● Gradient boosting and Linear regression are used for prediction and Mean absolute error used for model accuracy. SQL Database creation: UIC students registration system for incoming students

● Identified the functions required and the business rules that are applicable to every student for registration.

● Identified every applicable Super type, Sub type, Unique attribute and created Metadata tables for every variable

● Created EERD diagram that will explain the flow of information and how each involved stakeholder is interacted.

● Created SQL database for academic process that involves students, professors, and departments in the university

Contact this candidate