Ranjeet Kumar Jana
Data Analyst
Hyderabad
Summary
Solutions-driven and experienced professioal. Seeking opportunities to use analytical skills and strong people management skills to create cost- effective solutions.
Overview
8
8
years of professional experience
8
8
years of post-secondary education
Work History
Manager
Sumargsai Pvt Ltd (Family Business)
Hyderabad
03.2020 - Current
- Maximized performance by monitoring daily activities and mentoring team members.
- Developed and maintained relationships with customers and suppliers through account development.
- Planned and budgeted accurately to provide business with resources needed to operate smoothly.
- Communicated clearly with employees, suppliers and stakeholders to keep everyone on same page and working toward established business goals.
- Monitored and analyzed business performance to identify areas of improvement and make necessary adjustments.
- Controlled costs to keep business operating within budget and increase profits.
Student
Indian School of Business
Hyderabad
04.2020 - 10.2022
- Early Detection of Churning Customers which was directly impacting the business and model could help company to set their recharge plans, device price, resolve complaints of the customer, deals to the customers.
- Researched on various papers published in the Churn Prediction domain to understand the various frameworks and models used. Identified three major frameworks used across the industry including the prediction models used. Analyzed data using python to understand the key factors for user churn. Provided actionable insights to the product team and customer support team to reduce churn rate.
- Built multiple churn prediction models using different models and frameworks. Started working on basic models such as logistic regression and implemented advanced models such as Random Forest, XG Boost, SVM, and others. Compared the precision and recall scores for various models and frameworks and finalized the model with best precision and recall score.
- Conducted Pricing analytics projects to evaluate various prices between the network providers. Undertaken several projects to understand triggers and barriers for using postpaid,prepaid, DTH, ISP etc. Participated in Market Visit across India to evaluate the hypothesis.
- Collaborated with market research agencies to conduct market research studies including quantitative and qualitative studies to understand consumer behavior. Handled the entire projects from understanding the research requirements from the user team, identifying the market research agencies, floating brief to the agencies, collaborating with procurement team to finalize the pricing of the study and vendor and regularly connecting with the vendor to understand the challenges in project and providing them with the necessary support ensuring timely delivery of the project to the key stakeholders.
Software Engineer
WellsFargo
Charlotte
01.2017 - 12.2019
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Expert in Software Development Lifecycle (SDLC) and Service Oriented Architecture. Proficient in requirement analysis, system study, designing, testing, coding, de-bugging, database design, analysis, modelling, development, administration, implementation, troubleshooting and quality management. Professional knowledge of load balancing and highly available applications in multi-tiered distributed environment.
- Worked on the application, whose aim was to predict the trend of investing in BONDS for making money, so that the investors will explore different ways of investing in bonds. Randomly investing without a proper knowledge and going with the herd, often lead to a disasters and dwindles the investor wealth. Our application enabled customers to make an informed decision which mainly involves competitor analysis and how we stand out in the market leading to higher growth in investments, using the past data, company financials, news analytics and macro economic data system provides a holistic view on how the markets might be in the future.
- Product was built using the auto ML: Amazon Sage Maker with the data obtained from the sources by running the following regression and classification models. LSTM model, SVM model, Linear Regression, Random Forest, ARIMA model.
- Built regression models, for predicting yearly Bonds returns, classification models for predicting the direction of change in price, Version control of the models and old data stored in docker and RMSE as evaluation metrics.
- To evaluate the performance of the all the models, we used a RMSE metrics for bond returns prediction, Lower values of RMSE indicate better fit.
- Testing was based on business objectives on bonds price prediction and latency, ensuring robustness through frequent re- training of the model in regular intervals and on breach of certain parameters. Cloud based Deployment with high elasticity during initial stages.
Education
MBA - Analytics
Indian School of Business
Hyderabad 04.2020 - 10.2022
Master of Science - Computer Information System
Kent State University
Ohio 08.2015 - 12.2016
Bachelors of Technology - Computer Science
Guru Nanak Institutions Technical Campus
Hyderabad 08.2011 - 05.2015
Skills
Staff Management
Business Development
Financial Management
Project Management
Software Development
Python
RDBMS
Tableau
Unix
R
Accomplishments
- Played cricket at State Level (HCA)
- MBA capstone project was among the Top 3 in ISB
Timeline
Student
Indian School of Business
04.2020 - 10.2022
MBA - Analytics
Indian School of Business
04.2020 - 10.2022
Manager
Sumargsai Pvt Ltd (Family Business)
03.2020 - Current
Software Engineer
WellsFargo
01.2017 - 12.2019
Master of Science - Computer Information System
Kent State University
08.2015 - 12.2016
Bachelors of Technology - Computer Science
Guru Nanak Institutions Technical Campus
08.2011 - 05.2015