Offer Zone

$20

Hourly Consulting Rate

Contact Sunil

Sunil Patel

Independent Consultant

Industry Experience

Information Technology/IT

Location Supported

India

Languages Supported

English

Gujarati

Hindi

Skills

  • Programming
  • Robotic process automation

Product Specialization

  • UiPath Robotic Process Automation
  • Microsoft Power BI
  • Tableau Software

About

i have total 7+ years of experience in IT field.
I am certified UIPATH RPA developer with more than 2 years of experience. I completed many end to end projects; from requirement gathering phase to production deployment including testing. I also have experience of dot net, python.

Top Project Highlights

Purchase Order automation

  • Read Excel file for Order item and Address information.
  • Login to Fnacpro.com
  • Loop on excel data and search item in website
  • If item available then further process with qty, address and payment option.
  • If item or stock qty not available then update status in excel sheet.
  • Order success then update order number in excel sheet against item and customer name.

Bank Reconciliation in QBO

  • Bank statement available in Excel file or PDF file.
  • Login to QBO website.
  • Select Bank reconciliation.
  • Select bank account.
  • Read excel file and read QBO bank Reconciliation data.
  • Compare both data according to senario.
  • If same transaction found then create reconciliation of that transaction else keep as it is.
  • After complete whole process create report for all transaction which is done or not .
  • Send report to person email which is defined in settings.

Bank statement download and import in QBO and Xero

  • Read Client details from settings.
  • Login to client management website(podio.com).
  • Download client details with Bank url and credential.
  • Go to bank details using client bank url and credential.
  • Select bank account which client use (from multiple account, define in settings).
  • Download bank statement as per given date criteria.
  • Login to QBO or Xero software (which is client use define in settings).
  • Select account, select bank account.
  • Import downloaded bank account and after success or error or any message get data
  • Create process summary file and send it to client for process summary client.
  • After all process complete logout from podio, QBO and Xero software.

Update Spread Sheet in GSuite

  • Read Client List from Setting file.
  • Client wise read folder from local disk.
  • Get Folder value according to Year and month.
  • Get Folder name as Batch Number.
  • Get count of file available in folder.
  • Check if same batch is available then no need to read folder and update.
  • Update that count in G Suite Spreadsheet.

User wise Summary Update in Gsuite

  • Read G Suite Spreadsheet.
  • Read Invoice process by use.
  • Read count by user how much he had process.
  • Calculate client wise invoice process and batch document process.
  • Create summary sheet .
  • Create column date wise.
  • Add data client wise (invoice count, batch file count).
  • Create summary user wise process invoices, batch document for the same date.
  • Add user wise data on summary sheet.        

Employment

RPA Developer

2018 - Present

  • Worked on Solution Design Document (SDD).

    Worked on Process Definition Document (PDD) step by step keystroke level.

    Implemented End to End Robotic Process Automation (RPA) for web data scraping, Export to Excel, Excel Operation, CSV Files, Citrix Environment.

    Expert knowledge on Object Oriented Programming (OOP) concepts.

.Net Developer

2012 - 2018

  • Requirement, Analysis, Design, Development, Implementation and support various applications Technology(C#), both web and windows application including the hardware related projects.

    Excellent understanding of OOP (Object Oriented Programming),SQL Server, web Services. Having good experience on architecture design using Tiered architecture, design patterns.

    Experienced in design and development of windows application. Experience in Access, Security Technology Domain. Good experience in coordinating and working with developers (Offshore and Onsite) and End Users in Team based environment.

    Having Knowledge of design and development of application interface using API like sms Having experience in Laboratory Machine interface and Thumb Machine interface. Having good knowledge of working with hardware integration using SDK in Application.

Education

BE
2007-2012

Certification

UIPATH Developer Certificate
2019-2019

Ooops!

Maximum of Three products are allowed for comparision