RPA Developer

Kiran M

E-mail: *********@*****.***

Phone Number: 513-***-****

PROFESSIONAL SUMMARY

Over 6 years of professional experience in all phases of software development life cycle (SDLC) especially in Analysis, Design, Development, Testing and Deploying of applications and implementing n-tier Client/Server applications using Object Oriented design methodologies.

Hands on experience in Robotic Process Automation(RPA) using Automation Anywhere(AA) for about 3.5 years

Worked with AA 10 SP1 & 10 SP2 versions.(Until 10.5)

Had hands on experience with Client,Control Room, Task Bots, Metabots, Workflows and Bot Insight in 1.5 & 2.0

Automated several routine tasks using Automation Anywhere thereby reducing manual intervention

Had In depth Knowledge in taskbot commands and Metabot Assets and Logics.Integrated many DLL’s in tasks and in logics and scheduled tasks 24/7 using scheduler in the control room

Experienced in creating POC’s based on the business requirements

Experience working on object oriented concepts working on C#.Net,VB.Net,ASP.Net ADO.Net and AJAX

Comfortable with client side scripting technologies like JavaScript, AJAX, HTML/DHTML, CSS.

Having hands on experience with Microsoft Entity Framework, LINQ to SQL

Implemented N-Tier Architecture and integrated the UI with Data base for data retrieval and manipulation using ADO.NET data objects and ADO.NET Entity Framework.

Strong skills in .Net Framework 4.5/4.0/3.5, ASP. NET, C#, VB.NET, ADO.NET, SQL Server 2008,2012,2012 Oracle 9i/10g/11g, AJAX and Visual Basic.

Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML.

Extensive experience in architecting, designing and developing distributed scalable client/server and web application software using Web Forms and Win Forms.

Hands of experience in SQL Server in writing database queries using joins, Indexes and in creating Tables, Views, Indexes, writing Stored Procedures, Functions and Triggers using T-SQL, Maintaining Database, Experience in Query Optimization.

Prepared Technical design document, Use cases, Test casesandUser manualsfor various projects and good at Bug fixing, Code reviews, and Unit & System testing.

Experience in reporting and analysis using Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with the .net environment, SSAS.

SKILL SET:

Languages

C#, VB.NET, VB 6.0, PL/SQL, TSQL, SQL.

. NET Technologies

. NET Framework 4.0 and 4.5(WCF), WPF, ASP.NET, C#, Window forms, AJAX, Java Script, MVC, Web Services, SOAP, ADO.NET, XML, .Net, VB.NET, IIS.

Modeling Tools

UML, Rational Rose, Visio

Databases

SQL Server2008/2008 R2/2012, Oracle 10g/11g, MS Access.

Web Technologies

RPA(AA), HTML, HTML5, DHTML, Java Script, Ajax, XHTML, CSS3, XML Schema, Jquery, Bootstrap, AngularJS

IDE

Visual Studio 2012/2010/2008, SQL Server Management Studio

Operating Systems

Windows/XP, Unix

Reporting Tools

.NET Reports, Crystal Reports, SSRS, SSIS

RPA Tools

Automation Anywhere 10.5V,10.3V,10.2V(10(LTS)_ SP1 &_SP2), 9.0, Open Span RPA, Visual Studio 2015 with Pega Plugin

EXPERIENCE :

Client: Reynolds Consumer products, Lake Forest, IL Nov 2016 – Till Date

Role : Automation Engineer/RPA Developer

Description :

This project is to enhance to existing business to automate the daily regular activities and will reduce the time and efforts. With RPA tasks will process much faster than human, RPA will help company to avoid manual mistakes and will provide accurate details for audit trails.

Roles and Responsibilities:

Analyzing of Test Requirements

Review test requirements and test cases

Client co-ordination for Test Execution status updates and resolving clarifications.

Test data preparation for the test cases during test execution.

Participated in defect review meetings with the client.

Preparation and Review of Test Strategy and Test Plan.

Test Execution (system and regression testing) and Defect tracking.

Preparation of Daily status reports.

Attending sync up calls with the development team.

Attending bug triage calls and providing user acceptance testing (UAT) support for these applications.

Automation Anywhere is used in this project to develop and perform automate test data mapping based on day to day activities for a repetitive process(excel data mapping).

Developed different automations using variuous adaptors

Developed resuable procedures and various controls

For identified Use Cases - Configure, build, test and deploy robots to accomplish tasks

Involved in different phases of ChatBot creation, preparation of POC, developing logic,..etc

Design workflow which will helps in developing Automation Test Cases

Identified task for Automation so as to reduce time on Manual execution

Understand, learn and disseminate within the team the use cases to be automated.

Document the overall design and detailed design per use case adopting UML methodologies using Citi templates. Work closely with Citi Business Analyst.

Configure, build, test and deploy robots to accomplish tasks identified in the use cases.

Perform code reviews and document code quality audits.

Clearly document test strategy, its execution plan and record test results using best practices.

Document and Manage Change Requests.

Created reusauble automation framework with metabots.Had good knowledge on using metabots along with taskbots.

Used Metabots for online file filling from the data in the work flow applications.

Developed Metabots with DLL’s for reading Java script and for using windows credentials to login into the many applications.

Environment and Tools: Windows 7, Web Application, Eclips, Quality Center, Open Span RPA, Visual Studio 2015 with Pega Plugin, Automation Anywhere 9.0/10.0,

Client: USAA, San Antonio, TX Apr 2015 – Oct 2016

Role : Automation Engineer/RPA Developer

Project Description:

One of the USAA loan process involves sending Credit Score Disclosure (CSD) Documents to Members who have qualified for a loan. This involves moving the CSD documents from Cadence (Vendor Portal) to USAA Content Management System (Documentum) and then mailing these documents out to members via ECT (Enterprise Correspondence Tool). This process is performed manually by a team of 24 every day for 10 hours. We automated this process using Automation Anywhere and the entire process is being run by bots. The exception rate is around 8-10% mostly due to data issues and these are routed to be handled manually.

USAA has a member email communication portal using which Member Service Representatives (MSR’s) can track, view, assign and reply to all member emails to USAA. The member email communication team performs random Quality Audits on the communication sent to members. This is performed by retrieving a report of all emails replied by a MSR and assigning a random number. This is repeated for all MSR’s in the unit and the consolidated report is then Quality Audited. The report consolidation takes about 10 hours for an Auditor every week. We automated this process using Automation Anywhere and the entire process is being run by a bot. We have zero exception rate in this process.

Roles and Responsibilities:

• Analyses the feasibility of existing process suitable for automation.

• Implemented new reporting techniques and facilitated the presentations to the clients.

• Developed RPA Automation anywhere task for new account set up, loan process,email automation.

• Worked on task migration process from development to production systems through Control room.

• Helped on scheduling the night running RPA tasks through Control room.

• Experienced in building bots (tasks) on AA Processes for various business systems.

• Experience in using AA's Credential Manager for maintaining, securing and retrieving the user credentials.

• Experience in staging and deploying the automation solution into test and live environments and efficiently handled monitoring and troubleshooting the AA environment through Control room.

• Managed a team of developers in an agile environment.

Environment and Tools : Automation Anywhere 9.0,SQL Server, MS-Excel,PDF Converter, AWS Enviroment

Ford, Chennai Jan 2013 – Dec 2013

.Net Developer

Responsibilities:

Involved in all phases of Software Development Life-Cycle (SDLC) like Agile/Scrum methodologies.

Developed Web Application using Object Oriented Analysis and Design concepts (OOPs) including inheritance, polymorphism, encapsulation and abstraction

Worked with ASP.NET Web Forms, Web services, and State Management, Caching features, configuring optimizations and securing the web application.

Writing code in both code behind and web interface.

Using Cascading Style Sheets (CSS) for applying formatting rules.

Created Web User Controls to achieve maximum code reusability.

Designed and implemented a number of support tools using ASP.NET MVC, WEB API, JavaScript

Created generic class module to Load/Save/Validate data in the application and achieved maximum code reusability.

Involved in writing complicated queries compatible with both Oracle and SQL Server database.

Error Handling, versioning of application.

Deployment and Distribution of application.

Role also requires communicating with and supporting business users and troubleshooting their issues within critical time limits.

Senior .NET developer in a small startup, developing SaaS (software as a service) CRM system for QuickBooks. Mostly responsible for backend development of new features using C#, ASP.NET MVC and Web API.

Responsible for the development of applications by utilizing C#

Developing and installing software products and operating systems

Implemented the DAL using the Entity Framework 4 Code-First paradigm

Conducting test, and analysis of software products

Working on creating Rest Services using ASP.NET Web API and C#.

Performing coding and documentation

Designing many different modules like data parsing which was develop by using C#

Developed ASP.NET MVC 3 applications using Code First Approach in Entity Framework 4.1 and UI in Razor View Engine.

Analyze and provide on spot solution to GE User (End User/Front Office/Middle Office User)

Static Data setup.

Environment: Visual Studio 2010,.Net Framework 4.0/4.5, C#, ASP.NET, ADO.NET, IIS, XAML, AJAX, CSS, Web services, Oracle 9.0/11/, Agile methodologies, JavaScript, WEB API, Reporting API, Basic STK API’s and Trade/Asset Cash flows API, C#.Net, Entity Framework Ajax, Object Oriented Methodologies, INFRAGISTICS WinForm, .NET Framework 4.0, XML.

Diginode Solutions,India Sep 2012 to Dec 2013

.Net Developer

Developed a web based regional healthcare product for recording the patient care activities and patient health information for clinical radiology using .NET technologies for the client National Health Services (NHS), United Kingdom.

Responsibilities:

Involved in development of Web Forms, Classes using C# that incorporates both N-tier architecture and database connectivity.

Used Silverlight banners, Buttons, etc for enhanced user experience.

The web GUI was built using Silverlight, XAML, HTML, DHTML, Web Forms classes and AJAX control for providing a consistent look and their individual states persisted across sessions, thus saving individual preferences and providing a smooth navigation experience.

Developed ASP.Net pages using ASP.NET, web form controls, Custom user Controls, HTML server controls in C#.

Created event driven Web Forms using ASP.NET and implemented form validation using Validation controls using both Custom validation and JavaScript was written for Client side validations and also used the new validation controls in VS 2008/2010.

Enhanced and developed UI functionality using ASP.NET (3.0/2.0), HTML, and XML.

Used Silverlight Layout Panels and Control Templates for Customization.

Developed Web Services and invoking them by using XML SOAP and WSDL tool for creating proxy classes.

Designed & Deployed SQL Server Integration Services (SSIS) packages for updating the PO and Sales records from Excel to SQL database. Implemented check-points, scheduled using SQL Server Agent.

Expertise in Winforms applications, ASP.NET, XML, ADO.NET and TFS.

Implemented the SQL automation from VSTS2008 tool using ADO.net connections

Used Web Services (SOAP, WSDL) for communicating with other application and components.

Created CSS files to be applied to various web forms on the web pages.

Generated Crystal Reports for Job purpose.

Extensively used Web Services, SOAP, XML and XSL to expose the reports to facilitate information sharing.

Used Visual Studio.NET 2005 IDE to design the forms, develop and debug the application.

Involved in building a rich web experiences using JavaScript.

Deployed web application on Internet Information Server for production.

Used Ajax tool kit, Multi views, regular expressions, regular expression validates, user search controls

Extensively used ADO.NET, XML In Order to get the high level performance for the web controls.

Created Crystal reports on the web page by accessing the database.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for SQL 2008/2010.

Environment: Visual Studio 2008/2010, C#, COM, ASP.Net 3.0/2.0, ADO.Net, XML, SQL 2008/2010,Visual Source Safe, IIS6.0, Windows Server 2008, Web Services, SOAP, Web Forms, CSS, Silverlight 1.0, Team foundation Server, VSTS2008.

Ford Motor Company, Chennai June’11 to Jul’12

.Net Developer

Ford introduced methods for large-scale manufacturing of cars and large-scale management of an industrial workforce using elaborately engineered manufacturing sequences typified by moving assembly lines. The system deals with collection of all relevant master details such as department master, department standards, machine stoppage, machine master, machine group, process master, etc. Yarn production from the raw material and the departments involved in each stage of production are handled. Inventory details are maintained.

Responsibilities

Involved in implementing distributed application using Visual Studio.NET with C#.

Coded and developed various Web Interfaces with C# for login form, department details, machine details etc.

Used various Web Server Validation controls like Compare Validator, Required field Validator etc. to validate each and every control on a Web form and client side validations with JavaScript

Used ADO.Net Objects to connect the web forms to data sources such as MS SQL Server 2000 for accessing data in database

Used web methods in XML Web Services to retrieve information required for application.

Utilized OOPS concepts to make flexible, reliable and extendable application.

Used CVS for version control and for source code check-in.

Used XML to transfer data between the application server and the SQL server 2000 database.

Created SQL Functions, Stored Procedures and Triggers.

Defined technical/quality standards, best practices and involved in technical reviews.

Environment: .NET Framework 1.1, C#, JavaScript, XML, XSLT, HTML, ADO.NET, MS SQL Server 2008, IIS 5.0, CSS, ASP.NET 1.1, MS Visual Studio 2010, Web Services.

Contact this candidate