Praveenkumar A.

Praveenkumar A.

DotNet developer/UipPath developer/SQL developer

Bengaluru , India

Experience: 7 Years

Praveenkumar

Bengaluru , India

DotNet developer/UipPath developer/SQL developer

7 Years

Now you can Instantly Chat with Praveenkumar!

About Me

Certified RPA Developer -& completed UiPath Certification, offering nearly 8 years of rich experience in executing Web based Application Development / Enhancement & Maintenance Projects and ensuri...

  • Skilled in project planning & execution  from effort estimations, resource planning to status reporting and expert in .Net and SQL Server, UiPath and Hadoop Framework; knowledge also include Angular6
  • Gained working exposure for onsite UK location for the current project around one year
  • Expertise in designing and architecting applications and recommending the right solutions and technologies for the applications; skills include C#.Net, Web API, MVC, SQL Server, UiPath, Hadoop stack, HDFS, Sqoop,  Hive and MongoDB
  • Successfully led deployment of SSIS packages, database as well as web applications through MSI
  • Provided insightful knowledge of business process analysis (As-Is, To-Be) and design; managed application based process re-engineering, process optimization, cost control & revenue maximization from technical solutions using cutting-edge technologies
  • Recognised with Spot Award at ITC Infotech for exemplary performance
  • Led unit test implementation using MSTest and NUnit Agile Methodology; delivered application changes on test servers and on live environment

Familiar with the offshore –onsite services framework; accurate & precise in all work related assignments with strong team-building, analytical & problem-solving skills

 

Show More

Portfolio Projects

DEW

Company

DEW

Description

  • 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

Show More Show Less

Tools

TFS

Auction Data Analysis

Company

Auction Data Analysis

Description

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

 

Show More Show Less

Skills

UiPath

Tools

Git

Agency

Company

Agency

Description

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

Show More Show Less

Skills

UiPath

Tools

Git

BlueStar

Company

BlueStar

Description

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

Show More Show Less

Tools

Git