Resume

Sign in

Engineer Data

Location:
Kearny, New Jersey, United States
Posted:
August 20, 2018

Contact this candidate

Resume:

Sonali Siddharam Kasture

Mobile. No. : +1-551-***-****

E-mail : ac6qp8@r.postjobfree.com

Linked in : https://www.linkedin.com/in/sonali-kasture-4981a4126/

Work Permit : EAD under L2 Visa Category

Address : Kearny, New Jersey, 07032

PROFESSIONAL SUMMARY

Over 3.5 years of work experience in design, development, deployment, documentation and implementation of many projects using Robotic Process Automation Technologies and Microsoft Technologies.

Trained a team of 20 in Automation Anywhere Foundation course at Infosys.

Over 2 years of experience in Robotic Process Automation using Automation Anywhere Tool and bit exposure in Uipath.

Extensive Development experience in Robotic Process Automation using Automation Anywhere Tool.

Good at installation of Automation Anywhere 9.8, 10.3 and 10.5 Control Room and Client.

Completed End to End Process implementation for multiple Clients using Automation Anywhere tool.

Experienced in working on different Environments like development, testing and production.

Good installation and managing control room activities for Automation Anywhere.

Apart from development, have experience in scope realization, feasibility check and documentation.

Proficient in developing bots using Automation Anywhere and .Net framework on Windows platform, SAP, Excel and Outlook.

Good knowledge of VBScript, JavaScript, HTML and CSS.

Proactively created solutions to enhance the productivity of the tools.

Knowledge and good understanding of SQL and experience working with SQL Server databases.

Learning new Robotic Process Automation Tool UIPath Foundation Course.

Strong knowledge of Metabots and various commands String Operation, Excel and CSV command, Error Handling, Send Email command, Object Cloning and Manage Web Controls, Database, Loop Command, If command and Schedule tasks.

Extracted data from Web applications, Windows Applications, PDF, Images, Web pages etc. and exported the output data to Database/Excel.

Good Knowledge on task scheduling using Automation Anywhere like Schedule Manager.

Innovatively integrated the advanced features of automation tools like OCR, Web Recorder for existing robots and improved the performance using Automation Anywhere.

Strong knowledge in Automation Anywhere for Developing BOTS and Setup bots in the control room.

Experienced in all the phases of Software Testing Life Cycle (STLC) - Requirements stage, Test Plan, Test Design, Test Execution, Defect Tracking, Bug reporting, and Regression/Retesting.

Capable of quickly learning and delivering solutions as an individual and as a part of team and Leading, supporting team across the implementation cycle, working closely with developers, debugging and solving technical issues, sharing technical knowledge to the team.

Having hands on exposure on Telecom, Retail and Finance Domain.

TECHNICAL SKILL

Operating Systems: Windows

Programming Languages: C#

Technologies: ASP.Net, VBScript, VBA, JavaScript, HTML, Basic JAVA, Windows Application

Database: SQL Server 2008

RPA Tool: Automation Anywhere, UIPATH basics

PROFESSIONAL EXPERIENCE

Tesco, India Oct 17 – Feb 18

Sr. RPA Developer

Finance Price Fallout Report

Team Size: 1

Extract the text files from mainframe system, which will be received in Outlook. Download the text files and copy into excel template. Apply the filters to check the cost difference in the client’s receipt and company’s receipt. Once it’s done then according to the rules make different files for different type of clients. Automated the process of generating a finance report for different teams.

Responsibilities:

Gathering detailed requirements from client for business requirements.

Fetching the input data from the various Sources like reading the data from Email, Excel and Text files into the Automation Anywhere.

Involved in Robotic Process Automation (RPA) from requirements gathering, solution designing, coding, testing, debugging, documentation and implementation on Automation Anywhere.

Extensively worked with commands like object cloning, web recorder; Terminal Emulator.

Setup bots in the Control room.

Provided End to End to solution for Business process using Robotic Process Automation.

Solid Design, Coding, Unit testing, UAT (User Acceptance Testing) and maintaining the RPA's (Robot's).

Extensively worked on debugging application for fixing bugs and Production support.

Deployment of the new application into the production environment.

Sent Daily Status Reports, SOPs and Issue Status Reports to the Onsite on behalf of the Team.

Environment: Automation Anywhere, Mainframe, Outlook, Excel, Notepad

Sumo Ordering

Team Size: 2

Run the macro to get the data to work upon and copy it into different sheet. Get the distinct cases according to few columns in the excel. Read the values from excel and enter in mainframe to get few more details. Finally accept the order and if any cases have fallout register it as well. Key stages which were common to all Validation of Documents, Data Capture, Data Approval, Updating the applications with latest information, Post Processing and Generating Success and Exception Report.

Responsibilities:

Interact with clients and identify the use cases for automation using RPA.

Sent Daily Status Reports, SOPs and Issue Status Reports to the Onsite on behalf of the Team.

Involved in Robotic Process Automation (RPA) from requirements gathering, solution designing, coding, testing, debugging, documentation and implementation on Automation Anywhere.

Developed the Task Bots for Excel data loading into the Applications.

Extensively worked with commands like object cloning, web recorder; Terminal Emulator.

Solid Design, Coding, Unit testing, UAT (User Acceptance Testing) and maintaining the RPA's (Robot's).

Implemented exception handling. Whenever an error occurs then a detailed Log File is generated and Email notification is sent to the authorized person regarding the exception.

Involved in Scrum meetings and activities.

Development and Testing of the bots done in strict deadlines. Completed enhancements from the client in strict deadlines.

Deployment of the new application into the production environment.

Environment: Automation Anywhere, Mainframe, Excel, .Net, SQL

Infosys BPO Ltd., India Sep 14 - Aug 17

Senior System/RPA Engineer

Client -Verizon

VoIP Disconnect Service (POC)

Team Size: 3

This was a POC (Proof of Concept) to check whether the process is feasible to automate or not. In this process client receives the disconnect request through a mailing application. Extract the details about that customer through multiple Websites. Check if there are any dues and if so inform customer, else proceed to disconnect the service. There was one application which was used to disconnect the services, where we had to enter the data extracted earlier and disconnect the service. Successfully automated the end to end process for data extraction and disconnection.

Responsibilities:

Gathering detailed requirements from client for business requirements.

Preparing the Solution Design Document (SDD).

Gathering entitlement access (DB Access, Application Access, AA Development Environment).

Extensively worked with commands like object cloning, web recorder; Terminal Emulator.

Provided End to End to solution for Business process using Robotic Process Automation.

Implemented exception handling. Whenever an error occurs then a detailed Log File is generated, and Email notification is sent to the authorized person regarding the exception.

Involved in important client meetings, mails, and support.

Successfully completed POC's to check the feasibility of business requirements.

Sent Daily Status Reports, SOPs and Issue Status Reports to the Onsite on behalf of the Team.

Environment: Automation Anywhere, Web Applications, Excel, Oracle DB, SQL Server, MetaBot

Client - Orange Business Service

Variance Analysis Report

Team Size: 1

This report was based on weekly data provided by client in an excel sheet. Map this data into the given Template using vlookup and copy pasting the data. Many Excel Manipulation like applying filters, formulas Created many Pivots and Tables to analyze the output.

Responsibilities:

Understanding Requirements of existing process using supplied documents and discussions with client and operational team.

Documentation of Unit test cases, Requirements, Estimates, Issue Fixes, MOM, important client mails, and support and Unit testing.

Learnt standard coding practices for VBA and used them to deliver bug-free code.

Implemented innovative solutions for various advanced excel operations.

Environment: VBA, SQL, EXCEL

Client - Rio Tinto

MIS Reporting

Team Size: 1

Extract the data from SAP in excel format. Apply different filters and excel manipulations to get the output data. Apply Pivots, charts as per the requirement. Take the screenshot of excel tables and draft a mail with the To and CC in outlook. Generated separate report at separate timings for 8 different regions. Being a single developer saved 1 FTE out of 2. Also rewarded with Infosys Quality Award.

Responsibilities:

Understanding Requirements of existing process using supplied documents and discussions with client and operational team.

Documentation of Unit test cases, Requirements, Enhancements, Analysis, Estimates, Issue Fixes, MOM, important client mails, and support and Unit testing.

Learn and use C#, ASP.Net, SAP and excel manipulations.

Environment: C#, .Net, SAP, Excel, SQL, Outlook

EDUCATION

Bachelor of Engineer in Electronics and Telecommunication with First Class, from “Solapur University”, 2014.



Contact this candidate