VIVEK KUMAR SINGH

Experience

• 

  Dell International Services

  Nov 2012 - Dec 2015

  Software Developer
• 

  Exusia, Inc.

  Jan 2016 - Mar 2017

  Senior Analyst
• 

  Morgan Stanley

  Apr 2017 - now

  • Provide L3 support to our production plant as well as also help FCG(Financial control group) user with their DQ related query.• Actively involved in designing, development and taking sign-off from user in migrating Sybase plant into GreenPlum which help in reducing SLA and boost performance.• Extract input from different upstream sources like flat file, MQ and different data source through Python utility or Informatica and then implement further transformation logic in function/procedure.• Responsible to create Recon and Trend report using Python utility and BI report.• Actively involved in creating automation tool of our project like Partition creation, Vacuum, Analyse and basic utility in Python and Shell scripts.• Responsible to take scrum calls and assign task within team. And strictly follow Agile methodology.• Have successfully optimized different data object using different optimization technique like using data storage table (AO/Heap), partition, Index and Explain Plan.• Actively interact with FCG user to check their business requirement and implement in different database object or Informatica mapping.• Also involved in successfully on-board ANR project which is the only datamart in the firm which provide the revenue for all asset class. Show less

  • Senior Manager

    Jan 2021 - now

  • Manager

    Apr 2017 - Jan 2021