Experience

• 

  Kdn infotech

  Feb 2021 - Dec 2021

  Internship trainee
• 

  Bajaj finserv

  Aug 2021 - Sept 2022

  Associate software engineer

  Worked on Oracle Responsys, Axiom, Karix, CG, SFTP, ADF, SSIS for extraction & analysis of data. Also we handled SSMS,SSIS(ETL),Oracle,MySQL Migrate the data from the appropriate databases. Different servers monitored/handled regularly : ADF Pipelines ,SFTP ,Axiom ,CG. AXIOM : Axiom server is only based on OTP sms Text. we set Axiom server time regularly. SFTPserver : On SFTP server we check files that they are properly processing or not through Responsys Job.If they are stuck, then we check the error in that file and inform to end user who had uploaded this file on SFTP server. CG(communication governance) : CG is a another server in that promotional files are uploaded like SFTP server. We monitored and check files are processed or not. Creating the SQL view ,SMS & Email Campaigns and scheduling the programmes. Collaborated with business users and resolve there issues with azure IT request in Azure DevOps. Operates POSTMAN for SMS & Email Campaigns testing purpose. Design compare data reports in Power BI. Show less

• 

  Allscripts india

  Sept 2022 - now

  Ms associate systems analyst

  Using SQL server studio create the T-SQL queries according to client requirement.Also create the SSRS reports, SSIS packages ,Crystal Reports and scheduled then as per clients requirement.Monitoring the SSIS packages , crystal reports , SSRS reports and if they are failed to run then we checked the error in it and rerun the reports.Working on POWER BI reports, monitoring the Power Bi dashboard's and send the analysis to end user.Create the reports in POWER BI.Also working on the stored procedures, modifying the sp's , adding the various conditions in it, extract the data by client requirements. Show less