Shubham Sawant

Shubham sawant

bookmark on deepenrich
location of Shubham SawantPune, Maharashtra, India
Followers of Shubham Sawant8000 followers
  • Timeline

  • About me

    SQL Developer | Power BI & SSRS Expert | Azure Data Engineer | ETL & SSIS Specialist

  • Education

    • Dr. dada gujar high school

      2013 - 2015
      Hsc 64%
    • Dr. dada gujar high school

      2012 - 2013
      Ssc 78%
    • Jspms jayawantrao sawant college of engineering, handewadi road, hadapsar, pune 28.

      2015 - 2019
      Engineer's degree mechanical engineering

      6.56 CGPA

  • 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

  • Licenses & Certifications

    • Database course (oracle)

      Kdn infotech
      Feb 2021
    • Sql server integration services

      Linkedin
      Sept 2022
      View certificate certificate
    • Machine learning with python

      Ibm
      Jun 2021
      View certificate certificate
    • Sql server: reporting services

      Linkedin
      Oct 2022
      View certificate certificate
    • Mysql 5.6 developer

      Great learning
      Jun 2021
    • Exam prep: microsoft azure fundamentals (az-900)

      Linkedin
      Oct 2022
      View certificate certificate
    • Program databases with transact-sql

      Linkedin
      Oct 2022
      View certificate certificate
    • Oracle database 19c: advanced sql

      Linkedin
      Oct 2022
      View certificate certificate
    • Learning microsoft sql server 2019

      Linkedin
      Sept 2022
      View certificate certificate
    • Introduction to programming using python

      Great learning
      Jun 2021