Nitish Prasad

Experience

• 

  Western Coalfields Ltd.

  May 2013 - Jul 2013

  Summer Intern

  • Worked on project 'Testing the Viability of a Project using Capital Budgeting Technique"• Built a Financial Model to calculate the profitability of the project over its life. • Analyzed the profitability of the project considering the real environmental factors (Inflation and other constraints) and using NPV method of Capital budgeting.• Profitability calculated by forecasting the revenue and expenditure of the project considering its life as 16 years (As per organization's Norms). Show less

• 

  XL Dynamics India Pvt. Ltd.

  May 2014 - Apr 2017

  Financial Analyst

  XL Dynamics India Pvt Ltd. - Mumbai, MaharashtraDUTIES PERFORMED:• Assess the loan worthiness by reviewing Credit Report, Income documents, Appraisal Reports, Asset documents and other Financial statements.• Provided trend analysis of various KPIs and suggested action areas.• Study the Credit report of the customers to know their credit history.• Analyzing income statements and expenses of the borrower for Debt-to-Income ratio calculations. • Coordinate with underwriters, lenders, loan managers and securitization teams to manage portfolios• Worked in MIS reporting team and familiar with all the important Excel formulae’s, viz. Vlookup, Hlookup, If, concatenate, pivot tables, etc.• Provide analytical perspectives to some important strategic decisions• Generate MIS Report as per company requirement using MS Excel.• Prepare Internal audit reports and send the analysis to management for decision making.• Configure financial data and documents in the ERP system for data analysis and easy access to other team members.• Provide Training, guidance & assistance to junior colleague's, acting as a mentor for same. Show less

• 

  MAERSK

  Jul 2017 - May 2020

  Data Analyst

  ● Working in Business Intelligence team and preparing Various reports which helps in decision making and tracking the performance on Daily/Weekly/Monthly/Quarterly basis.● Monitors actual performance against targets, and based on thorough investigation preparing variance reports, and provide supporting analysis with insight for improvements● Provided recommendations after synthesizing trend data ● Worked on analytical and dashboarding tool like Power BI to develop quantitative and qualitative analysis ● Created visualization on Power BI using SQL Server to maintain the database and Python (sqlalchemy) for script writing.● Worked on PTP Reports like DPO (Days Payable Outstanding), Paid on Time, Debit Balances, NOPS by coordinating with regional leads to improve the cashflow.● Prepared decks for monthly connect to understand performance of KPIs, to provide key observations and area of improvement● Provided Predictive Analytics by creating Time Series Model on “Collection & Payment Forecasting” on R with around 90% accuracy● Developed a statistical model on R for target setting of various KPIs.● Have good understanding of Machine Learning algorithms like Regression, Supervised and Unsupervised Learning, Clustering, NLP, Apriori, PCA.● Automated the processing of the report in R Studio and saved the effort worth 2 hours weekly.● Prepared decks for monthly connect to understand performance of KPIs, to provide key observations and area of improvement ● Developed complex models and trend analysis on MS Excel.● Hands on experience in developing reports and dashboards in Power BI and MS Excel.● Familiar with SAP BI, SAP BW as we use these tools to extract raw data for our reports.● Interact with various internal stakeholders to improve quality and scope of the reports.● Provided continued maintenance and development of bug fixes for existing and new Power BI reports.● Evaluated and decommissioned least required reports. Show less

• 

  AkzoNobel

  May 2020 - Oct 2021

  KPI Analyst

  ● Developed and automated Overdue Report, Treasury KPIs dashboard on Power BI using HANA ODBC Connection.● Worked on a Machine Learning project to predict Customers Invoice Payments | RandomForest Classification | 95% Accuracy● Working on Data Science / Machine Learning project to predict stationary periods of vessels to measure fouling risks.● Worked on Time Series Analysis project to predict logistics KPIs like # Sales orders, Delivery counts etc.●Developed Power Flow to automate sending emails to Customers to alert for overdue payments.● Worked on an automated solution to upload invoices on the server using Python script.● Maintaining Project Management dashboard. Built Row Level Security to provide specific access to a specific audience.● Developed Power BI dashboard for HR Analytics to measure the accuracy of Payroll data on various systems● Provided team level training of Power BI Show less

• 

  Cognizant

  Oct 2021 - Sept 2022

  Data Scientist

  ● Worked on NLU project to migrate chatbot from Google Dialogflow ES to CX.● Reported action areas using classification reports and confusion matrix to improve the performance.

• 

  Michelin

  Sept 2022 - now

  Manager - Data Scientist

  ● NLP