Summary
Overview
Work History
Education
Skills
TOOLS USED
Certification
Timeline
SoftwareEngineer
SOUVIK PAL

SOUVIK PAL

Software Engineer
Kolkata

Summary

A highly dedicated and passionate Software Developer with 4 years and 4 months experience in developing and enhancement of multiple applications as per the requirements of the Client. Also, very keen to learn and explore new sets of skills and upscale my knowledge to meet the objectives of the organization.

Overview

5
5
years of professional experience
2021
2021
years of post-secondary education
2
2
Certifications
3
3
Languages

Work History

SOFTWARE ENGINEER

CNC State File Managed Service
06.2023 - Current
  • Modified the existing Illinois code using Spring Batch to error out records with non-numeric Medicaid IDs and add them to the outbound error report with the error description.
  • Developed a File Format Validation tool from scratch for Arkansas, Iowa and Ohio states in order to validate the outbound reports of these states using Spring Boot.
  • Modified the existing Arkansas batch job to update the carrier ids as well as to remove all the blank spaces between delimiters for empty fields in all the 8 Arkansas APCD outbound files.
  • Modified the existing end date logic for Ohio application using Spring Boot and JDBC so that the termed records in Portico are end dated one day before the start date.
  • Analyzed the end date of around 1000 termed records impacted due to Medicaid ID bulk load issue and developed a SQL script for DMR request to manually update those end dates in production as one day prior to start date.
  • Developed a new Portico extract SQL script for MCO Network Provider File from scratch for the Virginia state
  • Developed a CREATE TABLE SQL script to create two new tables KS.XTR.PROV_LOC_TERM_UDA and KS.XTR.PRAC_LOC_TERM_UDA in DEMOG database for Kansas application.Modified the existing KS.Load_XTR_PRACPROV_MCO Stored Procedure along with other two Views to incorporate term reason and term effective UDA data which are sourced from these two newly created tables.Modified the KS.LOAD_PRNU_DATA_FULL Stored Procedure to include the Term reason and Term effective date fields in the outbound JSON file.
  • Analyzed the Missouri outbound Demographic file created in production on 7/11 and determined the root cause for the sudden increase in the data volume of the file.

SOFTWARE ENGINEER

WBA_PHARMACY_APPDEV_FB
08.2020 - 05.2023
  • Developed 3 SOAP Webservices from scratch to get the details of Renewal and ScriptMed prescriptions for PNET2 application using Spring MVC,JDBC,JSP and JavaScript. Also, modified the Patient Profile window to display all the Renewal and ScriptMed prescriptions as well as modified the View Rx and Refill History windows in Patient Profile of this application to display the necessary details of Renewal and ScriptMed prescriptions.
  • Developed a new monthly and a weekly batch job from scratch using Spring Batch and Spring JDBC to parse the contents of around 9000 xml files present in two zip files and store the contents in database once parsing is completed. Implemented Word Wrap Algorithm and Comparison Algorithm for identifying differences between the database data and xml file data as well as Alert Mechanism with Bash Script for notifying issues to Run Ops team.
  • Modified the Patient Profile Window of Power CMC web application using Spring Boot,JDBC and JSP to implement the enablement and disablement of buttons for Renewal prescriptions. Also, enhanced the View Rx and Refill History windows in Patient Profile of Power CPO, CMC, REH applications to all display the necessary details of Renewal prescriptions.
  • Modified the DUR Comments window in Power CPO application to display the required details for Renewal prescriptions using Spring Boot.
  • Enhanced the existing NDCManagementApp batch job to parse an additional .csv file and insert the records in database

SOFTWARE ENGINEER INTERN

COGNIZANT TECHNOLOGY SOLUTIONS
02.2020 - 05.2020
  • Learned Core Java, JDBC, Spring MVC, Spring Boot, Html, CSS, JavaScript and SQL
  • Built an 'E-Commerce' project like Flipkart and Amazon with login and registration features using Spring MVC, JDBC and JSP

Education

B.TECH - Electronics and Communication Engineering

FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT

Skills

Spring Boot

TOOLS USED

  • Soap UI
  • Oracle SQL Developer
  • Microsoft SQL Server Management Studio
  • Control-M
  • GIT
  • SVN
  • Postman

Certification

AZ-900 Microsoft Azure Fundamentals

Timeline

SOFTWARE ENGINEER

CNC State File Managed Service
06.2023 - Current

SOFTWARE ENGINEER

WBA_PHARMACY_APPDEV_FB
08.2020 - 05.2023

SOFTWARE ENGINEER INTERN

COGNIZANT TECHNOLOGY SOLUTIONS
02.2020 - 05.2020

B.TECH - Electronics and Communication Engineering

FUTURE INSTITUTE OF ENGINEERING AND MANAGEMENT

Similar Profiles

CREATE PROFILE
SOUVIK PALSoftware Engineer