A Sarkar

Experience

• 

  Tata Tele Business Services

  Jun 2008 - Jun 2012

  Assistant Manager

  Technical Experiences: ● Involved in database testing for the application in SQL server● Implemented SQL queries for database interaction● Tested WebServices, providing required input data to request XML and validated response XML● Carried out the task of reviewing documents by coordinating with the application developers● Attended the business conference calls and provided solutions to the production issues● Prepared the user training materials and reduced the number of complaints significantlyAnalytical experiences ● Prepared test cases and analyzed test date to ensure high customer satisfaction in post-production of prepaid products. ● Analyzed CDRs (Call Detailed Records) for the MSCs (Mobile Switching Centers) prior to the regional launches. ● Performed User Acceptance Testing (UAT) in EVD (Electronic Voucher Distribution) system after development of Business Requests to eliminate any drawbacks in production. It increased prepaid market revenue significantly. ● Resolved post production billing issues and addressed complaints by co-ordination with internal teams. ● Analyzed the CCMs (Complaint tickets) related to post-paid billing issues and reduced the count of overall CCMs by greater than 30% annually by identifying the technical faults in the system. ● Utilized Oracle while performing UAT to ensure accuracy. ● Prepared relevant documentation related to product testing for the internal teams Management experiences ● Attended business conference calls with Business Owners, Tata Consultancy services and internal Tata Teleservices teams for necessary discussion and closure of gaps related to smooth rollout of Business Requests. ● Conducted instant escalation and interaction with vendors post observation of any alarm in IN (Intelligence Network) and ensured proper resolution to prevent revenue leakage. Show less

• 

  Elecsys Corporation

  Oct 2015 - Aug 2016

  Java Backend Developer

  Developed Elecsys e-commerce web based application to offer quick access to the most commonly used features for internal members. Members can also check the compatibility of the electronic products with their devices. Members can sign up with the member portal and can manage their accounts effectively and get latest updates on numerous gadgets.● Used Spring Security for authorization of users and implemented Spring Web-Services● Developed the DAO layer for the application using Spring, Hibernate and developed various business logics and reports using HQL and Hibernate criteria● Involved in handling Hibernate as part of DB connectivity and persistence as ORM tool and writing HQL queries● Collaborated with the team for developing enterprise inter-process communication framework using Spring RESTful web service● Fixed bugs and taken care of maintenance of the product● Used Cucumber to reveal and document, as well as drive development of, behavior in a large legacy code base● Work closely with business teams and external partners to define testing scenarios and progress application testing through UAT and SIT ● Assisted the internal teams in all the phases of SDLC including requirements collection, design and analysis of the customer specifications, development and customization of the application Show less

• 

  UnitedHealth Group

  Oct 2016 - Sept 2017

  Web Developer

  Designed Premium Development Application (PdaApp) which is intended to manage and update the requests, cases, and information and authorization roles for both the physicians as well as for the patients. As a part of this project the user can quickly visualize and navigate through the list of cases, requests, physicians and groups available in the application. Rich graphs are used to represent the aging and status of case completion. ● Developed and designed web pages using Angular JS, HTML5, CSS3, Bootstrap, Flex components.● Migrated the application from Bootstrap to Flex components to support for cross platforms● Involved in development of Spring Boot, Hibernate, Stored procs and RESTful web services components. ● Extensively worked on creating the custom directives in Angular JS and applied the same across the application● Used Angular two-way binding and implemented the search functionality for PDA Application● Used AngularJS factories and services to make Restful calls to get data in JSON format● Developed REST web services using Spring Boot framework● Created RESTful APIs in express and returned logic through AngularJS data binding● Developed REST service documentation using Swagger UI● Performed exception handling for REST web services● Developed various batch jobs which process bulk of data received from business partners in the XML format and flat files● Used stored procedures to get appropriate data from database filtered based on the business logic for each of the designs● Experienced in PL/SQL programming including complex SQL queries using stored procedures in MS-SQL● Experienced in Data Driven testing using frameworks like Junit● Worked on writing the Junit test case to test the RESTful APIs● Successfully analyzed the root cause of the high severity defects and provided suitable fix ● Participated in discussion with business and other team members to gather requirements and exchanged new ideas and improvements Show less

• 

  Freddie Mac

  Oct 2017 - May 2018

  Web Developer

  Project 2Developed Correspondent Assignment Center (CAC) which is a loan advisor suite product. CAC product helps correspondents in assigning loans to various other sellers and aggregators who purchases at low interest rates.• Developed the REST web services API to consume and produce the JSON data• Used REST controller in Spring framework to create RESTFUL Web Services and JSON objects for communication• Used POSTMAN for Web Service testing and solid understanding of HTTP Status codes• Used Spring MVC to develop application architecture• Developed Spring JDBC to interact with database. Used AJAX to communicate with database for certain functionalities• Implemented database connectivity using Spring JDBC framework • Created DAO classes to implement CRUD operations by using JDBC transactions• Wrote DAO layer, required SQL queries and Spring Controller to handle data and request to Spring application• Developed SQL queries for table and data creation for the application• Integrated the Angular JS application with the RESTFUL Web Services• Involved in improving the performance of the application using Sonarqube• Worked on JUnit code coverage and made progress status to 80% coverage• Utilized Power BI tool to generate monthly loan assignment status reports by developing necessary SQL queries• Used RapidSQL to run the SQL queries for extraction of data from DB2 databaseProject 1Designed Employer Application (EmpApp) portal which was a dashboard for environment status management tool. This web application in parallel manage all the database, servers, web services availabilities in Freddie Mac• Implemented Angular Router to enable navigation from one view to the next as agent performs application tasks• Implemented major business flows in REST web services along with JUnits using Mockito framework• Tested REST web services using Swagger • Used Spring MVC 4 for the application development• Used HTTP request to extract JSON format data Show less

• 

  Capital One

  May 2018 - Dec 2018

  Web Developer

  Project 2Worked with the US card recovery team in estates service project. Developed the API endpoint to trigger the balance letters only to the eligible customers. • Developed the API endpoint based on the RESTful Webservices.• Used Postman to test the REST API end points• Utilized Spring Boot framework to develop the controller and service classes for DB interaction• Developed and executed the JUnit test plan and unit testing with JUnit• Utilized Angular 6 to develop the User Interface in order to trigger the API call to connect with the backend controller• Worked with team to build Spring Boot microservices for the delivery of software products across the enterprise• Used PostgreSql for maintain the database recordsProject 1Worked with the team in the testing and maintenance of dashboard application. Dashboard aims to provide a portal for tracking the work done by Capital One in various line of businesses. In its home page, it provides the status of Work completed, In progress and Outstanding. • Modified the dashboard code as per the business request in order to restrict the creation of new incidents. • Migrated the modified dashboard war file into production and ensured the smooth operation of the application• Deployed the dashboard war file into West region apart from East through creation of new EC2 instance.• Involved in the creation, Management and Configuration of EC2 instances, AMIs and Elastic Bean template• Created security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.• Managed AWS S3 account, redshift and RDS cluster creation• Created AWS Route53 to route traffic between different regions.• Utilized Amazon Route53 to manage DNS zones and assign public DNS names to elastic load balancers IP's.• Conducted testing of shell scripts by connecting to the AWS server through Unix environment and loading the corresponding test data into S3 bucket Show less

• 

  Charter Communications

  Jan 2019 - Jan 2020

  Web Developer

  Retail POSRetail POS Operational Application is a web application. The benefit of this tool is it reprocesses the failed Retail device sales transactions and updates the failed ASN records. Additionally the tool helps to obtain devices sale live report. Based on the assigned role admin access has been provided for addition and edition of any new user.• Utilized Spring Boot to develop the backend RESTful web services for the entire application.• Involved in the creation of REST API in Java/J2EE using Spring boot• Used REST Controller in Spring framework for creating and updating the list of users • Used Postman and SOAPUI to test the RESTful API for HTTP requests such as GET, POST , PUT etc.• Developed API’s using Spring JDBC, ORM for accessing Oracle database• Developed different types of business validations to restrict the user inputs from frontend• Performed unit testing using JUNIT, Mockito and Spring Unit Testing framework• Developed BDD and TDD script with Cucumber and written step definition for Gherkin based features• Used GIT as a version control tool for merging branches• Used Sourcetree and Beyondcompare for resolving conflictsDemo ApplicationDemo Application is a web based application for creating and checking the availability of a device in the market based on the SKU Number. User has the feasibility to visualize and download the Inventory and Sales reports if necessary.• Created connections to database using Hibernate Session Factory• Configured the Hibernate entity files to persist the data to MySQL database• Implemented and designed webservices based on RESTful webservices• Used Spring Boot framework to develop the application architecture• Worked with the team to develop the Admin, Inventory, Sale and Report pages using Angular 5• Used POSTMAN to test the RESTFUL API endpoints• Used MySQL database for storing the created records Show less