SANJEEV SINGH
Lead Analyst
Pune
Summary
Persistent professional equipped with 7.5 + years of comprehensive experience in Healthcare and Banking industry. Provides strong technical direction across multiple projects. Responsible and articulate individual with strengths in solutions optimization, mobile and cloud solutions and global project management.
Overview
7
7
years of professional experience
3
3
years of post-secondary education
1
1
Language
Work History
Senior Software Engineer
Microservice, Charles Schwab
07.2020 - Current
- 3.1, LINQ, SQL Server, RabbitMQ, Swagger Generator Tool, Xunit, Specflow,
- PCF, Splunk, Bamboo, SourceTree, Bitbucket
- Project Description:
- Questionnaire microservice is a solution providing common solution to WMT space where questions will be exposed from the microservice based on Questionnaire Key like UMP, SIP and SIIS which will be further consumed by the UI applications containing the list of questions and answer and its meta data
- These provided question will be used for auto-populating on the UI once the consumer select the questions and answer then it will be saved based on the user input as partially ,fully and when users again logged in and try to continue the flow we will show to start from the next question from the beginning which will be used as navigation strategy
- Responsibilities:
- Written the provider by using repository pattern to initialized the questionnaire objects from the database
- Written the logic to load the existing client data from the supplied input
- Written the logic to generate transaction reference id and captured required embedded data for questionnaire rendering for the given program and return response with first set of questions
- Written the logic to identifies next or previous questions to navigate based on the navigation strategy of the given program and temporary store client answers by using caching
- Written the logic to saves or updates questionnaire based on prospect true or false, archive existing client data and raise required rabbit events and initiate downstream data transfer and save to OnDemand
- Written the Xunit test cases for all the functionality and Specflow (Gherkin) for integration test cases
- Deployed the code changes to DEV and QA environment on pivotal cloud foundry
- WMT Specflow Integration Core Library
Senior Software Engineer
MPHASIS
Pune
02.2019 - 01.2021
- Checked client code for bugs and weaknesses using approved troubleshooting methods.
- Led software development initiative as subject matter expert and primary point-of-contact for project management staff.
- Worked with project managers, developers, quality assurance and customers to resolve technical issues.
Senior Software Engineer
Charles Schwab
04.2020 - 07.2020
- Xunit, SQL Server, MongoDB, RabbitMQ, Specflow, Splunk, Bamboo, SourceTree and Bitbucket
- Project Description:
- Developing C# library which will be consumed across all the WMT microservices to write the BDD(Integration) test automation suite
- This test automation core package will overcome all the problems of Ruby (Waitr)
- BDD and also will be used to migrate existing all the BDD test written into Waitr to Specflow
- Responsibilities:
- Created the core package and added all the logic related to container setup for Specflow, app transformation logic, reading data from test folder, project structuring and doing DI for services
- Written Safe Functions for calling microservices endpoint for HTTP verbs GET, POST, PUT, PATCH and
- DELETE
- Written Entity framework provider, mongo provider for data base operation
- Written the RabbitMQ drainer, processor for processing the messages from the Queue and do background jobs
- Integrated Zypher for publishing the test result after the test execution suite
- Integrated test suite with account, funding, questionnaire and audit Microservices
- Written integrated test cases for the account, funding, questionnaire and audit Microservices
Senior Software Engineer
Microservice, Charles Schwab
02.2020 - 04.2020
- Core API 3.1, LINQ, Xunit, MongoDB, RabbitMQ, Swagger Generator Tool, Specflow,
- PCF, Splunk, Bamboo, SourceTree, Bitbucket
- Project Description:
- Customer profile microservice is solution providing common solution to WMT space with integration of USSA financial consultant feature to Schwab Intelligent Provider
- The purpose of this microservice is to provide the financial consultant information to the BFF team
- Responsibilities:
- Worked on integrating the open-cli-generator, added controller, model, startup, model validations template as a form of mustache files
- Written the service definition file containing the swagger endpoints to create the controller by PowerShell
- Added PowerShell script to create the Swagger UI and Swagger Model based on service definition yml file
- Written the Business service layers containing the mapper, injecting the core library packages into extension and consuming swagger API data to the controller class
- Written the Core layer for communication to downstream service either by Rest Client or Soap Client to get the data from the downstream service and pass it to business service
- Written the Workflow layer for processing the message published in queue
- Written the Xunit test cases for all the functionality and Specflow (Gherkin) for integration test cases
- Created the Config files for the Pivotal Cloud Foundry Deployment.
Senior Software Engineer
Microservice, Charles Schwab
12.2019 - 02.2020
- Net Core API 3.1, LINQ, Xunit, MongoDB, RabbitMQ, Swagger Generator Tool, Specflow and SSDT
- Project Description:
- Questionnaire profile microservice is a solution providing a common solution to WMT space with the integration of USSA feature to Schwab Intelligent Provider
- The purpose of this microservice is to scale the business capabilities
- Responsibilities:
- Worked on integrating the open-cli-generator, added controller, model, startup, model validations template as form of mustache files
- Written the service definition file containing the swagger endpoints to create the controller by PowerShell
- Added PowerShell script to create the Swagger UI and Swagger Model based on service definition yml file
- Written the Business service layers containing the mapper, injecting the core library packages into extension and consuming swagger API data to the controller class
- Written the Core layer for communication to downstream service either by Rest Client to get the data from the downstream service and pass it to the business service
- Written the Workflow layer for processing the message published in queue
- Written the Xunit test cases for all the functionality and Specflow (Gherkin) for integration test cases
- Created the Config files for the Pivotal Cloud Foundry Deployment
- Schwab Intelligent Portfolios - Charles Schwab, Charles Schwab
- Team Size: 3
Senior Software Engineer
Mphasis
09.2019 - 12.2019
- Environment: C#.NET, Angular 7, .Net Core API 2.2, LINQ, Xunit, MongoDB, RabbitMQ, Swagger generator
- Project Description:
- Intelligent Portfolio is investing made easy providing solutions to end-user to use robo-advisor builds, monitors, and rebalances a diversified portfolio of exchange-traded funds
- Consumer can invest money and opt for SIP or SIPP plan where consumer money will be monitored by robo advisory which makes consumer money easy investment
- Responsibilities:
- Worked on payment withdrawal feature for the trading account for a monthly basis after setting up the target data which is coming from the robo-advisory team
- Consumer can withdraw a certain amount of money based on their target during the investment into funds
- Worked on service endpoints connecting to downstream services
- Worked on creating the endpoints for the user interface in WEB API 2
- Written the Xunit test cases for the implemented feature
- Worked on the BDD automation of the endpoints by using the Waitr drive
- Written the UI test cases by using jasmine and karma
- Deployed the changes to DEV and QA environments
- Fitos PLM for (Apparel Industry)
- Team Size: 1
Senior Software Engineer
06.2019 - 09.2019
- NET, Angular 7, ASP.Net Core API 2.2, Xunit, MySQL Connector & AWS
- Project Description:
- Fitos PLM is the solution which is providing the solution to the apparel industry where any company can develop, design and maintain their design with using Angular UI, where industry can create their color design of any color material coming from the API, not only color they can design their supplier and all the other modules related to Apparel industry
- Developing the application suite which works like Aras application for PLM
- Responsibilities:
- Developed the application architecture including Presentation, Common, Infrastructure-IOC, Core, Infrastructure-Data, Domain layers along with database design
- Writing Fitos API from scratch containing all logic for the different layers
- Developed middle-tier and database tier
- Worked on stored procedures on the MySQL server Database side
- Written API code by using C#, ADO.NET, Entity Framework &Core2.2
- Witten the complete Life Cycle including Analysis, Design, Development
- Written the dynamic API which can be used by angular UI for getting the data at high scalable rates
- Working on writing TDD & BDD the test cases for all the API endpoints written
- 7
- Project Title: Insurance Tracking Projects.
Senior Software Engineer
SWBC
03.2019 - 06.2019
- Environment: C#.NET, Hibernate, Angular 4, AS400, Web API, RabbitMQ, HTML, CSS, JavaScript, j query, AJAX, SQL Server 2016 and Xunit
- Project Description:
- Insurance Tracking is SWBC company solution, which is operating in the US, giving solutions to various banks like Bank of America, Credit Union etc
- To manage their Insurance, Loans, Claims and Policies
- Its offers insurance and financial solution for financial institutions, businesses, and individuals
- For financial institutions, it provides auto, mortgage, and commercial loan portfolio management as investment services
- Responsibilities:
- Working on the implementation of GAP, MTG and CPI claim implementation in the Product for the Coatrack account
- Writing business logic for Claims like GAP, MTG and CPI
- Written the stored procedure for pulling the data coming from the service and dumping into the SQL Server which is used in the grid for the data binding after the search
- Writing test cases for the GAP for Code Coverage using Xunit
- 8
- Project Title: Customer Master Interface (AERIE)
- Polaris
- Team Size: 1
Software Engineer
INFOBEANS TECHNOLOGIES PRIVATE LIMITED
Pune
11.2017 - 02.2019
Software Engineer
10.2018 - 01.2019
- Customer Master Interface is the development of an interface allowing Aerie to bulk load recipient’s records into the Polaris Customer Master
- The purpose of this interface is to ensure that the Individual HCP data received from the Aerie customer master system is made available in GCP
- The customer master data from the Polaris Customer Master system would then be used by GCP and STAR
- The main goal of this project to load Individual HCP data using Aerie Customer Master Templates into GCP Customer Master to automate the process
- Responsibilities:
- Created Business Logic Layer & Data Access Layers
- Written code to fetch xlsx data from SFTP locations, move into various folder structure, populate error based on error found in the file & process golden records to various tables so that those records should be made available on the GCP UI that will be further used in the HIP for nominating
- Developed functionality with the ASP.NET (C#.NET, ADO.NET, SQL Server)
- Implementation of field level and file level validations by writing stored procedure
- Implementation of sending mail based on success and failures of records processed with error messages
- Writing all the records into Achieve/Exception folder with error message for failed records
- Involved in refine testing for the developed windows service application
- Involved in the deployment of service on the different environment’s (QA, Beta, Production).
Software Engineer
Infobeans Technologies PVT. Ltd
08.2018 - 10.2018
- Project Description:
- Takaful is Insurance solution Provider Company which is operating in the Middle East of Dubai
- Takaful is a type of Islamic insurance, where members contribute money into a pool system in order to guarantee each other against loss or damage
- Takaful-branded insurance is based on sharia, Islamic religious law, and explains how it is the responsibility of individuals to cooperate and protect each other
- In this application, user have the capability to upload their basic details and could choose a listed plan on the bases of suitable criteria
- This application is divided into three section Admin, User and Report
- Responsibilities:
- Worked on the upload controls and applicant form where the user will fill the basic details
- Created separate pages for the applicant details containing Component, Module, Models files, View
- Implementation of client-side validations using Bootstrap and Angular Validation
- Integration of this Applicant component with the app component
- Integration of Web API for consuming the calls and saving Upload controls
- Project 10
- Project Title: HealthCare Provider Interaction Portal (HIP & J&J)
- Polaris
- Team Size: 10
Software Engineer
J&J
04.2018 - 08.2018
- NET 4.5, C# 5.0 ASP.NET MVC 5.0, HTML, CSS, JavaScript, j query, AJAX, Visual Studio 2015, SQL SERVER 2014, Entity Framework, TFS, JIRA
- Project Description:
- Polaris’ HCP Management Portal is a series of modules used to enrich the data associated with HCPs that is vital for selection and contracting yet not commonly stored in a Customer Master or other CRM applications
- Each of these additional modules can be used as a standalone tool or can be integrated with a full HIP system to provide more comprehensive information about the specialists used within the organization
- Responsibilities:
- Worked on Implementation of Audit Trail Log
- Created Business Logic Layer & Data Access Layers
- Implementation of client-side validations using J Query and ASP.NETMVC Validation
- Involved in Development of overall middle tier and database tier
- Extensively worked on stored procedures on the SQL server Database side
- Involved in refining testing for the developed application web pages
- Project 11, : LOV Utility for upload/download for HIP
Software Engineer
12.2017 - 02.2018
- LOV Utility allows easier to upload a list of values for client implementations
- In this application where the client will download the LOV Utility XLSX file containing all the data populated into it
- After that user will add new LOV’s according to their requirement and upload the same sheet
- New added LOV’s will be added back to the database
- In this application, the client can add new LOV’s, Update LOV’S by setting a flag on/off
- It has various validation checks which allow the user to upload correct LOV’s
- Responsibilities:
- Created Business Logic Layer & Data Access Layers
- Involved in using MVC pattern for UI development
- Developed functionality with the ASP.NET (C#.NET, ADO.NET, ASP.NET MVC)
- Implementation of client-side validations using JQuery and ASP.NETMVC Validation
- Involved in Development of overall middle tier and database tier
- Extensively worked on stored procedures on the SQL server Database side
- Configured Web.Config files for the configuration of the entire Web Application
- Involved in the writing code on ADO.NET to communicate with SQL Server
- Involved in the complete Life Cycle including Analysis, Design, Development and Testing
- Involved in the refine testing for the developed application web pages.
Education
B. Tech - CE
KDK College of Engineering, UCOE (RTMNU University
Nagpur 04.2011 - 06.2014
Skills
C#, TypescriptWeb Technologies
ASPNET MVC, Web API and NET Core API
Windows TechnologiesWWF, WCFData Access TechnologiesADONET, LINQ to SQL, Entity Framework, MySQL Connector andMongo ConnectorAngular
DatabaseSQL Server, MySQL 57 and Mongo DBDevelopment IDEMS Visual Studio, Visual Studio Code, MYSQL Workbench, Ruby Mine and WebStormVSTS, TFS, GIT, SourceTree and BambooJIRA and IQVIA JIRAArchitectural DesignCQRS, Onion, NET Clean Architecture and MicroserviceCloud TechnologiesAWS and Pivotal Cloud FoundryDevOpsDocker, Git, AWS, Ansible and Jenkins (Basic)TDD FrameworkXunitBDD FrameworkRuby-Gherkin, Waitr, SpecflowMessagingRabbitMQTimeline
Senior Software Engineer
Microservice, Charles Schwab
07.2020 - Current
Senior Software Engineer
Charles Schwab
04.2020 - 07.2020
Senior Software Engineer
Microservice, Charles Schwab
02.2020 - 04.2020
Senior Software Engineer
Microservice, Charles Schwab
12.2019 - 02.2020
Senior Software Engineer
Mphasis
09.2019 - 12.2019
Senior Software Engineer
06.2019 - 09.2019
Senior Software Engineer
SWBC
03.2019 - 06.2019
Senior Software Engineer
MPHASIS
02.2019 - 01.2021
Software Engineer
10.2018 - 01.2019
Software Engineer
Infobeans Technologies PVT. Ltd
08.2018 - 10.2018
Software Engineer
J&J
04.2018 - 08.2018
Software Engineer
12.2017 - 02.2018
Software Engineer
INFOBEANS TECHNOLOGIES PRIVATE LIMITED
11.2017 - 02.2019
B. Tech - CE
KDK College of Engineering, UCOE (RTMNU University
04.2011 - 06.2014