Pranshu Agarwal Email and Phone Number

Crypto/Stock Market Enthusiast, Analyst, Trader & Investor. Always looking for new opportunities. Get in touch if you have any new & exciting opportunities to invest in.

Analyzing and Performing Data Analysis on Large Data Sets with multiple variables using Excel, Access, SQL etc.Creating VBA based excel dashboards and Business processes automation dashboards using large data sets.Projects - Price Point Variance analysis, Conjoint analysis, Analytic hierarchy Process implementation, Survey Analysis, String matching using 15 different algorithms including fuzzy logic, Outlook - excel automation, Interactive dashboard for excel workbook collation,… Show more Analyzing and Performing Data Analysis on Large Data Sets with multiple variables using Excel, Access, SQL etc.Creating VBA based excel dashboards and Business processes automation dashboards using large data sets.Projects - Price Point Variance analysis, Conjoint analysis, Analytic hierarchy Process implementation, Survey Analysis, String matching using 15 different algorithms including fuzzy logic, Outlook - excel automation, Interactive dashboard for excel workbook collation, Service Call analysis, Daily Route performance report, Excel - Web API connections etc. Show less

Modeling and quantifying natural catastrophe and terrorism risk by means of the vulnerability, hazard and financial module using commercial modeling software such as RMS’s Risk Link & Risk Browser.Understanding exposures in the Schedule of Values, application of the Financial Structure, generation of Event Loss Tables & EP Curves for desired Financial Perspectives, calculation of the Return Period losses and preparing the Final Deliverables to the client.Analyzing financial and… Show more Modeling and quantifying natural catastrophe and terrorism risk by means of the vulnerability, hazard and financial module using commercial modeling software such as RMS’s Risk Link & Risk Browser.Understanding exposures in the Schedule of Values, application of the Financial Structure, generation of Event Loss Tables & EP Curves for desired Financial Perspectives, calculation of the Return Period losses and preparing the Final Deliverables to the client.Analyzing financial and social losses due to the catastrophe risks, helping the clients in understanding the output of analysis, comparing different model results and recommending solutions to them for future growth. Consolidating the databases created & used during the analysis procedures.Managing large data sets with multiple countries and currencies with extensive use of Excel & SQL.Creating SQL scripts for Macro Enabled Excel Reports and managing report templates. Show less

Having experience in Analysis, Design and Development of Business Objects and Xcelsius.Created Iterative dashboards with Xcelsius and accessing data from BO using MS-Live office & QaaWS.Expertise in working of Business Objects like Web Intelligence, Desktop Intelligence, Import Wizard, Xcelsius 2008, Live Office and Crystal reports.Created Interactive dashboards power points using Xcelsius 2008.Experience in creating Dashboards for higher level management for… Show more Having experience in Analysis, Design and Development of Business Objects and Xcelsius.Created Iterative dashboards with Xcelsius and accessing data from BO using MS-Live office & QaaWS.Expertise in working of Business Objects like Web Intelligence, Desktop Intelligence, Import Wizard, Xcelsius 2008, Live Office and Crystal reports.Created Interactive dashboards power points using Xcelsius 2008.Experience in creating Dashboards for higher level management for future development. Show less

Acid Cleaning of boilers and measurement of internal deposition in Water-wall tubes and Study of Multi- Stages of chemical cleaning.

‘Comparative Study of Various Catalyst Additives’ under Mr. Pankaj Kasliwal (Deputy ResearchManager)Pre-Calcination, Metal Doping, H2 Reduction, Steaming (hydro Thermal Deactivation), Post-Calcination of the base catalyst (CED-1300. FCC) and additives (Indv, BCMT, BCA Intercat, Lab BCA, Co-converter).'Standardization of Microtrac Particle Size Distribution machine with CILAS (PSD)’ under Mr.Brijesh Verma.To calibrate Microtrac (instrument used for Particle size… Show more ‘Comparative Study of Various Catalyst Additives’ under Mr. Pankaj Kasliwal (Deputy ResearchManager)Pre-Calcination, Metal Doping, H2 Reduction, Steaming (hydro Thermal Deactivation), Post-Calcination of the base catalyst (CED-1300. FCC) and additives (Indv, BCMT, BCA Intercat, Lab BCA, Co-converter).'Standardization of Microtrac Particle Size Distribution machine with CILAS (PSD)’ under Mr.Brijesh Verma.To calibrate Microtrac (instrument used for Particle size measurement with use of lasers & ultrasonic) with CILAS. Show less