Senior Software Engineer
Send a job offer directly to this candidate
Determined and passionate Senior Software Engineer at Capgemini who thinks out of box and deliver tasks on time
• Capgemini America, Inc and IBM Client
Buying Solution - one stop shop for customer as well bank to provide smooth experience on home buying experience as well as perpetual KYC
∗ Worked on real-estate dataset, used excel functions for data cleaning, modifying and converting into required format, leading to more efficient project execution and increased profitability
∗ Created DB2 schema for Smart Buying Home Solution and leveraged different SQL operations with the property dataset
∗ Managed the consistency and integrity of thousands of property-data by utilizing transactions with
‘BEGIN TRANSACTION‘, ‘COMMIT‘ and ‘ROLLBACK‘commands
∗ Created Stored Procedure in estimating effort summary during migration of artifacts from lower environment to updated environment for pKYC
∗ Utilized SQL cursors to handle row-by-row processing of data in effort summary calculation with the given conditions and formulas
∗ Implemented multiple AJAX services on IBM Cloud Pak for Business Automation environment to perform CRUD operations which includes the submission of ID Proof of customer during pKYC
∗ Developed services for fetching records of existing customer and updating records of new customer from the customer personal details screen which includes customer’s personal data and his property preferences data
∗ Worked on searching of the property list with the given preferences by customer
∗ Handled large JSON data set as an input for database service creation
∗ Worked on the UI development of buyer screen of Smart Home Buying Solution application using
JavaScript, HTML, CSS
∗ Executed validations in buyer and seller screens including RegEx Validations and multiple
Drop-Down, Table, Button,etc Validations using JavaScript methods
∗ Worked on the Audit Table design and development of both pKYC and Home Buying Solution∗ Handled server side issues and Error SQL Codes with efficient resolution before timeline
∗ Performed troubleshooting and integration between DB2 and CP4BA environment
∗ Presented demo of the application to offshore clients on several sprints review
∗ Involved in giving Knowledge Transfer(KT) to new-comers in project ensuring team productivity,
timely project delivery, company profit
∗ Worked as a Junior Developer in the Insurance Domain (PACS), designed and developed database of Prudential application for DEV, SIT and UAT environments
∗ Gathered requirements from the Business Analyst and directly involved in the database management and interacting with the onsite coordinators on various forums to discuss the status of the project
∗ Proficient in Mircosoft SQL Server, T-SQL, and data analysis, with a strong background in creating efficient queries using Common Table Expressions (CTEs), CASE statements and Window
Functions for active-inactive policy holders
∗ Involved in writing Liquibase script for New Business, Policy Servicing, and Claims part using
IntelliJ IDEA for different environments
∗ Configured and developed server file using NodeJS and its integration with Micosoft SQL Server using Visual Studio Code editor
∗ Used Bitbucket and Git Bash for managing repositories, executing Git commands for pull, commit,
push, etc on daily basis
∗ Performed Transactions, DML commands on Business Data table with hundreds of policy numbers on daily basis and also experienced in configuring relationship between foreign key and primary key and implementing joins
∗ Worked on Claims Registration and Claims Assessment for multiple proposals
∗ Resolved authetication errors in SSMS and handled its configurations. Also, involved in taking database backup to ensure data integrity and disaster recovery readiness
∗ Resolved multiple JIRA tickets assigned during different phases of development and after production go-live
∗ Experienced in testing RESTful APIs using Swagger and Postman, payload fields and schema validation
BE in CS (2017-2021)
