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
Spring MVC
Spring BATCH
Spring JDBC
SOAP and Restful webservices
SQL
JavaScript
Html & CSS
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