Aman Abhishek

Determined and passionate Senior Software Engineer at Capgemini who thinks out of box and deliver tasks on time

• Capgemini America, Inc and IBM Client
* Worked as a Developer for the clients Capgemini America, Inc and IBM in building Smart Home
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

• Prudential Assurance Company Singapore Client
∗ 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)