Description: Project aimed at deploying the DEW application using UiPath. DEW included different components like web application, database application and SSIS package. Whenever there was a change in the code all the components had to be deployed manually which was taking lot of time. DEW deployment automation project made the deployment process easy; by just running the UiPath automation project

Role

• Assessed the deployment process; interacted with the team and gathered necessary information
• Created UiPath automation and testing the process; fixed the application bugs and support

Description: It aimed at processing the checks failed in the validation process using the UiPath package. It checked the data for matching against the records provided by back-end team. Created the report for those items which were not matched and sent the report to respective person within the internal team. Validated the agency data from agency screen against the internal KAPPA data and prepared the daily report for submitting to the bank.

Role:

• Reviewed the requirement; interacted with the team and gathered necessary information
• Designed UiPath automation and testing the process as well as fixed the application bugs and support

BlueStar - web and mobile based application which helped the people to manage their chronic diseases such as diabetes. BlueStar integrating clinical, behavioural, and motivational applications with everyday technologies, like the internet and cell phone, to engage patients and healthcare providers in ways that dramatically improved outcomes and reduced healthcare costs

Role:

• Led the development of new features and testing of functionality
• Provided support in development and documentation of several Java and .NET based applications; fixed the application bugs
• Created SQL database schema, and created the tables required
• Developed numerous simple to complex SQL queries including joins and sub queries for diverse business requirement
• Followed best practice in creating tables, relationships, stored procedures and indexes; loaded the data from excel to SQL Server database and vice-versa using SSIS and import and export utility MongoDB installation
• Ensured Query MongoDB based on requirement and written repository code to fetch/insert/update data
• Conducted MongoDB backups and restored backups

• Description: It consisted of various messages sent for communication among banks for cheque clearance within two days of cycle in UK. Part of the team and worked on image achieving and reference data. The project had a valid XSD for all the messages passed between the beneficiary, participating and collecting banks; some of the features included:

• Message received from Message Orchestration along with the client node as a single message
• Message received from Message Orchestration includes KAPPA information
• Application designed to use within the premise, AD Group application permissions maintained in the database in configuration tables

• Role:

• Interacted between the business and the Off-shore Team; gathered requirement and prepared the design as well as processes the data using SQL and service broker
• Ensured:
• MVC .net, Web api application development and bug fixing
• Export and import data Sqoop from SQL server
• Prepared hive tables, loading with data and writing hive queries
• Executed solutions using Hadoop, Hive, Sqoop, Java UDF for Hive
• Communicated with the business and analytics team in gathering the system requirements; transformed large sets of structured and semi structured data
• Maintained data into Hive partitioned tables