Vipul Gupta

Experience

• 

  Growth Arrow Company

  Apr 2021 - Jun 2021

  Equity Research Intern

  ● Technical Research: Analysing indices and stocks on different timeframes, drawing trend lines, support, resistance & different indicators. Learned day trading & momentum trading strategies. Explored trading psychology and risk management techniques.● Fundamental Research: Industry analysis - Understanding industry cyclicality, market sizing & and trend analysis, industry KPIs. Financial analysis of the company using financial statements, ratios, peer comparison & understanding of various corporate actions. Explored company analysis using pricing & sustainability power, competitive advantage, SWOT analysis, risks in the business, and analyzing credit rating of companies. Show less

• 

  Societe Generale Global Solution Centre

  Jun 2022 - now

  Business Analyst

  ● Worked on two transformation projects (Retail & Non-Retail Monitoring module) to rebuild the Credit Risk Monitoring system (Legacy application).○ Studied the legacy applications to understand the existing processes and limitations.○ Developed a good knowledge of old databases and worked extensively on SQL Developer○ Analyzed the latest and advanced tools in Business Intelligence to identify the alternatives.○ Spearheaded the analysis of the project which brought about a cost saving of more than 80%○ Requirement capturing & documentation (BRD / FRD / Scoping / Wireframing)○ Internal progress review and pre UAT testing○ Client training and hand over to the client and assist in UAT● Developed Power BI reports (Retail Monitoring) as a transformed application.○ Created mock-up screen based on new requirements with global users.○ Specified MSBI cube to be connected with PBI reports.○ Created calculated Risk Indicators in PBI using DAX.○ Performed gap analysis between legacy and PBI data, and resolved data quality issues.○ Published transformed application on PBI Report Server.○ Managed user access globally.● Worked on SG’s internal web application to build Non-Retail Monitoring Module.○ Build UI design with dynamic screen using PowerPoint.○ Conducted workshops with global users to improve the user experience.● Facilitated data migration processes to upgrade from Oracle Exadata to the BigData platform.○ Conducted data mapping to transfer the required data into datalake.○ Specified design for UV in datalake for Target solutions.○ Identified and removed redundant and unused data to build a comprehensive new Ul.● Led the interactions with Paris counterparts and gathered requirements from users all around the globe.○ Conducted workshops with users to understand their pain points in the existing applications.● Additional responsibility: Represented Credit Risk Management at Central Functions - Technology. Show less