Gaurav Kumar
Bengaluru
Summary
A technocrat with 12 years of experience in Software Development. Presently Working with DXC Luxoft as Senior Consultant. Previously I worked with PWC SDC as Senior Associate. Adept in overall development of software products from requirement analysis to system study, testing, documentation and implementation with cross-cultural teams. Proficient in Appian Designer, SQL Server, SSIS, Transact SQL. Appian Senior Developer Certified. Having hands on experience with Appian BPM suite on versions 19.x,20.x, 21.x and 25.1. Done development, enhancement, support and analysis of Appian implementation in my current role. Proficient in SAIL, CDT, process model, expression rules, records, interfaces, designer, admin console. Good knowledge of Insurance, Banking, Healthcare, Drilling and Extraction domain. Good understanding of Agile execution methodology, use of best practices in development and testing activities.
Overview
3
3
Certifications
12
12
years of professional experience
Work History
Senior developer/ Individual Contributor
DXC Luxoft
07.2024 - Current
- Online Product Portal Appian applications – Enhancements Applications:- Payments Commissions and Fees Management (PCM), Supply Chain Finance (SCF), Commodity Finance Trade Assessment(CFTRA), Product Documentation Template Library (PDTL), Single Product View (SPV), Trade Supply Chain (TSC).
- Currently working on Development of two new application - Trade Asset Management and Single Product View.
- Work involves complete ownership of as individual contributor where I get opportunity to discuss the requirements from Product Owner, Propose the Appian solution, plan the development , Create Jira with BA for all the Sprints, Demo the Progress with the stakeholder and plan the release which is mostly planned every month last week. Apart from regular schedule I also work on any critical production issues with the help of support team for any existing applications in Transaction Banking.
- -Cater to the growing business need with effective solution
- Technology and Skills:
- Appian, SQL
- Domains:
- Banking, Corporate Finance, Investment bank / global markets
Senior Consultant
DXC Luxoft
10.2022 - Current
Appian Technical Lead
Halliburton
11.2023 - 07.2024
- HDBS Photo Appian mobile application provides a platform for Field Agents in Halliburton to take photos of Drill Bits after its usage. The pictures are the key metrics used to determine if the drill bits can be used further or it can be repaired before reuse and accordingly the billings and inventory management is done. It caters to the challenge of keeping track of number of drill bits in use and maintaining so many photos and their metadata their status, any physical damage which should be reported and how many times the drill bits are used. The Application is developed considering the offline capabilities of Appian.
- Responsibilities:
- Overall application design, data modelling and estimates based on requirements.
- Interacting with client to understand the requirements.
- Implement process design, user interface and integration.
- Work with Team on technical challenges, analyse the plugins that can be used to meet specific requirements and refinement of requirements into technical business logic.
- Sprint planning, Jira status Code review and deployments.
- Technology and Skills:
- Appian, SQL
Appian Technical Lead
Halliburton
10.2022 - 10.2023
- Halliburton Drill Bits Services (HDBS Field Ticket) provides drill bits (drilling equipment) which is used by various drilling companies in digging well in oil fields. Field agents provide delivery and pickup services to the customers in different regions of North America and Canada. During the delivery the field agents use the Appian mobile application to capture customer information, number of drill bits to be delivered, shipment details, estimates of various Charges and taxes via offline form. This information is used at the time of pickup when billing is generated in the pdf format specifying the expenses incurred in actuals. The Appian reports display the revenue generated through plant and customer in a month/year.
- Responsibilities:
- Overall application design, data modelling and estimates based on requirements captured.
- Implement process design, user interface, reports and integration.
- Work with Team on technical challenges and refinement of requirements.
- Sprint planning, Jira status Code review and deployments.
- Interacting with client to understand the requirements.
Senior Consultant
PWC SDC
05.2021 - 10.2022
Developer/Lead
PWC SDC
05.2021 - 09.2022
- DSI deals with on-boarding Health Care Professionals (HCP). As a pharmaceutical company DSI can engage HCPs from various countries. This Application basically helps the user to create the engagement and manage the entire lifecycle which includes creating up a roster for an engagement, screening, credentialing and how the HCPs are handled in the system. HCP can have certain workflows/ action that need to be completed before he/she could be considered fully eligible for engagement. We have contracting workflow between HCP and business owner where these two parties can undergo a contract which is taken care by digital signature so DSI users create a contract from Template that is created in the system and the final contract document created by the template is sent for the digital signatures via “Docusign” system. Once the contract is agreed upon both the parties then comes the payment part which is again one of the activities. Payments are often carried out offline or via meetings but the essential details are captured in the HCP engagement application. (Like how much is HCP paid
- What is his/her hourly rate
- Etc). The reports basically deal with the spend Cap of specific HCP which is available till date so the management could decide if HCP can be used in any other engagement.
- Participate in design discussions and documentation of technical design specifications.
- Carry out assigned technical tasks/development as per the project schedule interacting with client to understand the requirements.
- Develop various objects like Expression Rules, CDTs, Interfaces, Process Models, Records and Reports.
- Develop utility rules, user filters, query entities, gridlayout , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Role : Developer/Lead
- Technology : Appian
Technology Specialist
Coforge
07.2020 - 05.2021
Developer/Lead
Coforge
07.2020 - 05.2021
- This project aims to automate the KYC application in HSBC.To accomplish this there are more than 27 forms as of now which needs to be filled at different phases of the workflow. The forms are divided into sections and each section is having number of questions. In order to have dynamic question, question bank is setup with more than 3000 questions and at runtime based on possible answer selection by the user different set of question displayed in the form.The answers selected by the user is further processed through business logic to determine the risk profile of the customer based on the geographic location and type of business and the frequency of transactions done.
- Participate in design discussions and documentation of technical design specifications.
- Carryout assigned technical tasks/development as per the project schedule interacting with client to understand the requirements.
- Assist team members in reference data mapping, appropriate documentation and domain knowledge.
- Develop various objects like Expression Rules, CDTs ,Interfaces, Process Models, Records and Reports.
- Develop utility rules, user filters, query entities, gridlayouts , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Write test cases for unit testing.
Senior Software Engineer
Mphasis
11.2019 - 07.2020
Developer
Mphasis
01.2019 - 01.2020
- Reference Data System categorises the transaction details based on the nature of transaction, payment methods, Cost Centre and handles the approval chain. It provides a user friendly application through which an end user can quickly verify and approve the transaction details which are provided through an ETL source system and mark the transaction as processed for the other subsystem to further utilise this data in Ledger posting and Trial Balance.
- Carryout assigned technical tasks/development as per the project schedule interacting with client to understand the requirements.
- Carry out assigned technical tasks/development as per the project schedule interacting with client to understand the requirements.
- Develop utility rules, user filters, query entities, gridlayouts , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Develop utility rules, user filters, query entities, grid layouts , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Role: Developer
- Technology: Appian
Software Engineer
HSBC Software Development India Pvt. Limited
06.2016 - 09.2019
Developer
HSBC Software Development India Pvt. Limited
01.2018 - 01.2019
- IFRS9 and CCAR workflows are designed to adhere the policy of task management through process managers, preparer, approver and accepter chains in different work streams, regions and countries. Process Manager is the power user who can create and update runbooks which contains tasks being assigned to preparer, approver and accepter. A Preparer can start task, flag issue, add hours worked, attach documents, add comments and complete task. Approver and Accepter can approve or reject task, flag issue, add hours worked, attach documents, add comments. Task records contain all existing tasks with the details like Task id (Link to individual task record), Preparer, Status, Planned Start/End dates, Responsible Parties. Runbook records contain all runbook information. The application also contains reports which like Daily status report, Task report, Region-Country summary report, Flagged issue report. It also has features of Bulk Prepare, Bulk Approve, Bulk Reassign, Bulk Edit, Bulk Add that helps in taking quicker action by business users.
- Responsibilities:
- Participate in design discussions and documentation of technical design specifications.
- Develop various objects like Expression Rules, CDT, Interfaces, Process Models, Records and Reports.
- Develop utility rules, user filters, query entities, grid layout , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Write test cases for unit testing.
- Performing regression testing at the end of every sprint, creating bugs in JIRA which is assigned to respective developers who developed it including me and ensuring timely closure of all bugs on the board.
- IFRS9 and CCAR workflows are designed to adhere the policy of task management through process managers, preparer, approver and accepter chains in different work streams, regions and countries. Process Manager is the power user who can create and update runbooks which contains tasks being assigned to preparer, approver and accepter. A Preparer can start task, flag issue, add hours worked, attach documents, add comments and complete task. Approver and Accepter can approve or reject task, flag issue, add hours worked, attach documents, add comments. Task records contains all existing tasks with the details like Task id (Link to individual task record) ,Preparer, Status, Planned Start/End dates, Responsible Parties. Runbook records contain all runbook information. The application also contains reports which like Daily status report, Task report, Region-Country summary report, Flagged issue report. It also has features of Bulk Prepare, Bulk Approve, Bulk Reassign, Bulk Edit, Bulk Add that helps in taking quicker action by business users.
- Technology : Appian
Developer
HSBC Software Development India Pvt. Limited
01.2017 - 01.2018
- Software Asset Capitalisation Management is a case-based software capitalisation application that is widely used throughout HSBC by Project Managers for managing the book of works for the entire financial year and funding various projects. It caters to various needs of managers in expediting procurement of physical asset, new software requirement for a project, onboarding of associate, speculation of funds through a number of Appian actions, records and reports.
- Develop utility rules, user filters, query entities, gridlayout , export excel functionalities that could be used directly in other Interfaces and Process Models.
- Reference data mapping, appropriate documentation and domain knowledge.
- Creating various group structures for the application.
- Determining correct security of all components.
- Write test cases for unit testing.
- Performing regression testing at the end of every sprint, creating bugs in JIRA which are assigned to respective developers who developed it including me and ensuring timely closure of all bugs on the board.
- Technology : Appian
Developer
HSBC Software Development India Pvt. Limited
06.2016 - 01.2017
- The Global Finance Center IT caters to the IT needs of Global Finance centre based in Hyderabad, Gurgaon and Krakow. GFC IT was brought together in the latter 2015 as a new Finance Service Line. Project Mosaic caters to the needs of Period End Close (PEC) team in the financial control and reconciliations units. The goal of the project is to build a robust and reliable IT solution for the GFC PEC team. Mosaic is executed in AGILE and due to limited resource availability the next phases are further automation and adopting DevOps principles at it's core.
- Taking complete ownership of the sub-system right from the requirements gathering with the user till production deployment.
- Manage the development process through the entire lifecycle - Requirement Analysis, Design, Implementation, Quality Assurance, Build and Release..
- Carryout assigned technical tasks/development as per the project schedule Interacting with client to understand the requirements.
- Participate in design discussions and documentation of technical design specifications.
- Working on Agile methodologies giving daily status updates in scrum calls.
- Commitment to keep the pace of delivery of one sub-system a week.
- Assist team members with appropriate documentation and domain knowledge.
- Creating SSIS Packages for system interface.
- Writing Stored Procedures, Function, Views.
- Using Transact-SQL for data extractions and data analysis.
Associate Consultant
NTT Data Global Delivery Services
02.2014 - 05.2016
Developer
NTT Data Global Delivery Services
02.2014 - 05.2016
- The Data Management System platform represents Maintenance Hub and Distribution Hub for National Life Group. Maintenance Hub is enterprise level reference data acquisition, maintenance and reporting. Distribution hub is single product reference data source published by Maintenance Hub. Data Management System platform is meant to cater to recommendations laid down as a part of the “Business Transformation” initiative within National Life Group program to address with regard to the controls and processes required to monitor the selling of insurance products. It is also being enhanced to cater for the creation of a central repository to manage all insurance products and offer data.
- Responsibilities:
- Managed development process through entire life cycle: requirement analysis, design, implementation, quality assurance, build and release.
- Created SSIS packages to facilitate system interface.
- Writing Stored Procedures, Functions, Views.
- Creating SSIS Packages for system interface.
- Prepared test cases to ensure thorough testing for test teams.
- Role: Developer
- Environment: Windows 7, SQL Server 2012.
Education
PGDM - Finance
NMIMS Global Access School
01-2019
PG Diploma - Device Driver Development
CDAC Knowledge Park
Bangalore01-2014
Bachelors of Engineering - Computer Engineering
Priyadarshini College of Engineering
01-2013
Skills
Technical
Languages : Core Java, Python
Database : SQL Server 2008/2012, MySQL
Operating System : Linux/Unix, Windows
Software Tools : Appian BPM, SSIS, SQL Server, SSDT, Jira, QC, Control-M, TFS, RTC
Cloud Platform : Google Cloud Platform
Certification
Appian Senior Developer Certified (Jun-2022 Active).
Timeline
Senior developer/ Individual Contributor
DXC Luxoft
07.2024 - Current
Appian Technical Lead
Halliburton
11.2023 - 07.2024
Senior Consultant
DXC Luxoft
10.2022 - Current
Appian Technical Lead
Halliburton
10.2022 - 10.2023
Senior Consultant
PWC SDC
05.2021 - 10.2022
Developer/Lead
PWC SDC
05.2021 - 09.2022
Technology Specialist
Coforge
07.2020 - 05.2021
Developer/Lead
Coforge
07.2020 - 05.2021
Senior Software Engineer
Mphasis
11.2019 - 07.2020
Developer
Mphasis
01.2019 - 01.2020
Developer
HSBC Software Development India Pvt. Limited
01.2018 - 01.2019
Developer
HSBC Software Development India Pvt. Limited
01.2017 - 01.2018
Software Engineer
HSBC Software Development India Pvt. Limited
06.2016 - 09.2019
Developer
HSBC Software Development India Pvt. Limited
06.2016 - 01.2017
Associate Consultant
NTT Data Global Delivery Services
02.2014 - 05.2016
Developer
NTT Data Global Delivery Services
02.2014 - 05.2016
Bachelors of Engineering - Computer Engineering
Priyadarshini College of Engineering
PG Diploma - Device Driver Development
CDAC Knowledge Park
PGDM - Finance
NMIMS Global Access School