Nishant Kumar

• Led a team of Business Analysts to deliver robust analytical solutions consistently and mentor the Analysts for their professional development.
• Understood the client's point of view and translated it into sound judgment calls in ambiguous analytical situations
• Synthesized the analysis and derived insights independently
• Analytics tools used are Python, SQL, Power BI, Tableau and Excel

Analytics –

• Credit cards product analytics using excel, VBA for multi-billion dollar of balances of an US bank
• Data Extraction using Essbase Hyperion SmartView software after which data manipulation and data preparation like cleaning, handling missing values, standardizing and preparing for data analysis
• Conducting exploratory data analysis to find patterns and understand relationships in data
• Modelling – using machine learning models to fit data and forecast future values within an error threshold.

Finance –

• Handling forecasting models for P&L statement of the credit cards department involved in backtesting and sensitivity analysis of data; maintaining model accuracy and providing analysis for breaches at instances
• Financial analysis of data, model working explanation document preparation, and limitations of models
• Invented solution for a time consuming problem reducing 30% time wastage due to circular references error
• Tools used – MS Excel, VBA, Powerpoint, SmartView, Pearl/Ruby, Python

• Developed from scratch – recommendation system, search engine, analytics dashboard, chatbot for website
• Scraped data from e-learning sites for model training and item integration in the main website
• Tools used – Python, SQL, HTML, Javascript, PHP

• Researched on Psychology of persuasion and modern marketing techniques
• Got remarked as extremely efficient, organized and hard working from the internship manager

• Analyzed Electrostatic Precipitator's data for modeling efficiency and executed energy economics of the entire power plant