Deepu R

Experience

• 

  Theorem india

  Jun 2014 - now

  Production Analyst

  • Provide production/application support to the client on 24*5 basis.• Monitor jobs and resolve job failures.• Change or modify the shell script as per the client requirement.• Also write SQL code as per the client requirement.• Work on new test file and new build campaign.• Also work on file level and record level rejects.• Generate report on production status and send it to the client on a daily basis. • Run scheduled campaigns and FTP fulfillment files to vendors.• Validate incoming and outgoing vendor files.• Refresh different data marts as per the schedule.• Work on ticket request.• Check and remove a person from the database who wants to unsubscribe from Online Advertising.• Update application documents as per the process change. Show less

• 

  Theorem

  Apr 2017 - Oct 2020

  Salesforce marketing cloud , technical specialist
• 

  Mindtree

  Nov 2018 - Aug 2020

  • Developing solution.• Database designing.• Designing the reports which are based on the requirement specifications. Create new and/or modify existing SQL stored packages and procedures.• Using multiple databases to feed the data into the data file or excel file.• Analyze reports, data and solution when existing reports do not function properly. Correct these reports and/or data or solution.• Import data from Excel spreadsheets to SQL tables. Export data from SQL tables to Excel spreadsheets. • Generation of day to day wise, monthly, Quarterly, and yearly reports.• Identify various scenarios for unit and integration testing.• Creating test data based on the test cases and executing the test cases. Using SQL for checking the output of various reports. Show less

  • Associate Technical lead

    Dec 2018 - Aug 2020

  • Module Lead

    Nov 2018 - Mar 2019
• 

  Salesforce

  Aug 2020 - Apr 2023

  Customer Success Engineer