Vijayalakshmi Sugumar

Project: Horizontal Merger – Legal Data Migration and Transition

• Horizontal M&A project that involved end-to-end merging of the Legal LoB of two organizations that includes reconciliation of Process, Data, Software, UI, Legal Providers, HR, and Employees
• Migrating huge amount of UI and Legal Provider data into Legal applications such as TeamConnect, TyMterix360 and Clarity360 that involves in onboarding vendor, improvising cyber risk assessment questionnaire, Ongoing monitoring of legal provider, contract renewals and off boarding as part of Merger program
• Provide functional inputs to Data Migration team on application-to-application Data Mapping, Data analysis, Business data requirements, Loss events capture and validate data hierarchy
• Transition to new Cyber Risk Assessment application tool Kroll, from Legal legacy risk assessment tool that is used for assessing legal vendors while onboarding corresponding vendor
• Worked with stakeholders (Lawyers) in remodeling assessment questionnaire within intake tool Ariba and Coupa Providing inputs to respective stakeholders on Improvising matter management process, operational process, loss events for audit and reporting
• Automated the workflow for the operational processes and ensuring the Regulatory & Compliance
• End-end testing (FT, SIT, UAT/BAT, PAT and PROD) of Process, Data and Software

Project: Enterprise financial data analytics and data migration (Retail Banking - Loan and Mortgage)

• Migration of data that includes historical data into new Financial Data Warehouse (FDW) - data related to loans, mortgages, payment schedule, billing, collateral, Payment Collection Process and Collection Item, Card Payments, Acquiring and settlement
• Provide functional inputs to technical architect(s) for data modelling, review architecture, data analysis and validate data hierarchy
• Better Realtime knowledge of LOS and LMS, working with respective teams
• Validate/calculate loan repayment risk, competes mortgage loans by monitoring collection, verification, and preparation of mortgage loan documentation; scheduling and completing mortgage loan closing
• Working with card payments team both Debit and Credit cards for Card holder data and associated Businesses
• Understanding tailor Loans to customer's Personal and Financial Situation

Project: Invest Sea (Investment banking)

• Worked on detailed framework to setting up underwriting on investment portfolio.
• Develop recommendations for product offerings, Capital Markets and private equity transactions, IPO
• Working knowledge of deal structuring and closing principals
• Having good grasp of investment climate, with knowledge of popular investment plans.
• Prepare documentation of raising capital through issuing securities, whether debt or equity
• Mergers and acquisitions (M&A), and valuations

• Involving process of payment audit for compliances and post payment basis
• Discussion with business stake holders to gather payment audit requirements
• Provide functional inputs to post payments auditing team in improvising process and Reporting using Oracle.

Project: eXcite Migration (Insurance Project)

• Conversion is part of eXite program which is migrating lot of legacy application data into product Duck Creek application.
• Working with Source SMEs to understand source system, databases, functionalities
• Query using MS SQL and perform Data comparison and GAP analysis.
• Review line by line with both stake holders and bridge GAPS if any
• Working with DEV team to make them understand mapping logic and participate E2E testing
• Coordinate and lead fellow offshore analysts to consolidate business preparations
• Working with Payments team, Claims team, Legal team and external agencies

Project: Broker's website

• Complete free access for brokers to register and maintain their information which in turn could provide sales, mortgage, lease, listing and contact information about commercial properties
• Inspection – Application to gather information about natural disasters, hurricane etc., Inspect and associate with government authorities of USA for financial recovery
• Enriched data – Web application that gives information about Sales and Lease for most of states of USA
• E-valuation – web application to search for properties, provide estimation and summary report
• Commercial Appraisal - Web application for commercial real estate Appraisal and Assessment

Project: Pricing - Customer and Carrier

• Customer/Carrier pricing involves pricing Agreement between logistics and customer, Contracts– one agreement can have many contracts, Sections– visibility of Customer information and Cargo release

Project: OpEx - Operation Execution

• Linehaul of freights from Origin to Destination after orders are created, received with both Truck and Driver assigned, accepted, delivered and completed

• Worked as individual contributor for Retail-Logistic software applications using .Net technologies (C#, ASP.Net) and Oracle 10g.
• Performed Data Migration, New reporting tool application, Email triggering using SMPT and enhancing existing projects.