Vikas Arora

Experience

• 

  Tata Consultancy Services

  Oct 2008 - Mar 2012

  Global Credit Risk Management solution for a renowned London based bank: To calculate the Credit Risk based on financial statements and ratios such as liquidity, asset turnover, debt to capital, cash flows etc. Also acquire credit risk figure from credit rating companies such as Moody’s, S&P, Fitch, CRISIL etc. Calculating Expected Loss based on LGD, AE/ EAD, and PD (probability of default).• Preparing detailed requirement documents such as Business Requirement Document BRD, FRS, UML Use Case & Activity Diagrams and Project Plan; reviewing traceability matrix, high level SRS, etc.• Implementing remedial action plan (Change requests) for based on GAP analysis• Actively involved in workforce maintenance; measuring & improving productivity as well as liaisoning among customer, developers and QA• Gathering business requirement via customer interviews, studying legacy systems and understand pain points• Effectuating Agile SDLC model with scrum meetings and maintaining scrum backlogsBusiness and GAP analysis• Understanding business process, studying and analysing workflow to design solutions (As-Is and To-Be Analysis); conducting gap analysis, impact analysis, assess scope of work and suggesting the most suited solution• Business Requirement Document (BRD) and mapped all the high level requirements to more detailed requirements (FRS), prototype.Project / Delivery Management Show less Worked in the capacity of Consultant, Business Analyst and Delivery Manager role for multiple accounts, for a cloud based ERP solution for SMBs• Responsible for business development: Generating leads from existing customer channels; assisting in product demos; replying to Tenders and RFPs; pricing strategy based on customization and implementation cost considering strategic importance of new account.• Certified Transformational Manager / Functional Consultant for Enterprise Resource Planning solution, one of very huge initiative from TCS.• Responsible for all client interaction activities, starting from kick off meeting, phase wise service delivery plan, client business’ need identification, process definition, quality of service, traceability matrix, resource planning etc. • Good knowledge of various ERP modules: CRM, HRMS, payroll, Procurement & Inventory, Finance & Accounting, Campus Management System, Biometrics, On-demand & drill down reports, manufacturing, private virtual community etc.• Business Analyst and Delivery Manager for banking solutions (Basel III guidelines enabled framework with regulatory reporting)Enterprise Resource Planning (for SMBs Education, Manufacturing domain as BA and Regional Delivery Manger, North India) • Preparing detailed requirement documents such as Business Requirement Document BRD, FRS, UML Use Case & Activity Diagrams and Project Plan; reviewing traceability matrix, high level SRS, etc.• Effectuating Agile SDLC model with scrum meetings and maintaining scrum backlogs Show less

  • Business and Functional Analyst, Consultant

    Oct 2008 - Mar 2012

  • Business Analyst

    Oct 2008 - Mar 2012
• 

  Tata Consultancy Services

  Apr 2014 - Jul 2016

  Consultant, Business Analyst

  Worked as Business Analysis / Consultant / Project or Delivery Management role with proven track record of successfully employing best business practices that improve efficiency, reduce operating costs whilst increasing performance in tight time scales and within budgets.Domain IT – Banking LOS/ FRM/ Investment Banking/ ERP- CRM.Project Summary• Business Analyst and Delivery Manager for banking solutions (Basel III guidelines enabled framework with regulatory reporting)o Loan Origination system framework for multiple domestic and foreign London based banks: End to end loan origination, sanctioning and monitoring framework developed for multiple domestic and foreign banks. Starting from borrower/counterparty details, loan proposal, financial information and health check, sanction workflow, monitoring. Customised reports such, value at risk; RWA based on counterparty’s loan amount, credit risk (including country and market risk), collateral value etc.• Sound understanding of derivative markets: over counter & exchange traded, company valuation, corporation financial ratio and financial analysis• Hands - on experience in leading teams for successful project implementation while ensuring a high-quality customer experience, elevating customer satisfaction in line with SLAs & work processes• Proficient in performing Business/ Functional Analysis, Impact & Risk Analysis, Gap Analysis and Process Modelling• Completed 1 year Course on Advance Business Analytics from IIT Bombay (2011-12, Part Time)- Project Evangelist & Team Builder-Business, data and GAP Analysis-Functional Consultancy-Agile SDLC methodology -UML and business documentation -Risk & Contingency Planner - Provide Structure, Direction & Vision • Preparing detailed requirement documents such as Business Requirement Document BRD, FRS, UML Use Case & Activity Diagrams and Project Plan; reviewing traceability matrix, high level SRS, etc. Show less

• 

  Royal Bank of Scotland (RBS)

  Aug 2016 - Aug 2018

  Senior Business Analyst

  Worked as Senior Business Analyst to create and maintain Golden Source reference, market and trade data application called data exchange containing mainly counter party details, instrument static, market & pricing data, credit rating details, holiday and calendar details etc sourced by various applications across bank.• Developing new and more agile data exchange (golden source) development for:  Cost savings by keeping single copy of data across bank, sourced from optimum vendor.  Cost saving by removing data license of multiple external applications replaced by single platform, 3 in-house applications.  Providing quick JIT request/response as well as subscription mechanism  Lower cost distributed among various consumers as per usage/ request model• Interact with more than 90 consumer applications/ teams such as settlements, front office trade applications, FI/equity/FnO and other asset class instruments, internal instruments & indices management, finance, reporting & BI teams etc. As senior BA, I am responsible to gather and track ever changing requirement from all consumers. • Working with all consumers (downstream) for on boarding them to new, under development, golden data source applications• Interact with more than 8 major internal and external data source (upstream). Understand the capability, costing and constraints for attaining data through intra-day and back office process.• Maintain requirement summary, CRs, PRs, FRS, RAID and negotiate on timelines and budget.• Identify GAPs, action to control data or process inconsistency. Reduce number of applications and servers by using single golden data source with quality data Show less

• 

  IHS Markit

  Oct 2018 - now

  • Associate Director - Product manager and Business Analyst at IHS Markit

    Sept 2018 - now

  • Design Manager and Business Analyst

    Oct 2018 - Mar 2020