SUMMARY:

• Overall 7 years of professional experience in developing and analysis of web based, client/server and n - tier distributed applications using Microsoft technologies like VBA, ASP.NET, C#, Web Services and SQL Server in various domains, including around 2 years of experience in RPA and RDA process implementation.
• Good experience in requirement gathering, analysis and negotiation to provide quality solution and strong customer focus to ensure the finished product/service meets required quality.
• Experience as a Business Analyst in identifying and defining the requirements.
• Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing and deployment of automation.
• Good experience in Agile product development methodologies and following best scrum practices.
• Extensive experience in RPA tools Automation Anywhere 10.0, UiPath 2016.2 and Blue Prism 5.0.
• Exception handling design and correct use of stages and blocks correct use of data types, session and environment variables.
• Experience in troubleshooting and debugging automations.
• Oversee requirements capture, agile development, VBA programming (Access and Excel), and support of multiple database tools.
• Strong and precise understanding of Automation Anywhere & UiPath technological limitations and clear understanding of Windows/Web/Mainframe integration.
• Configuring new automated processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Developed and configured automation processes as per the technical design document (TDD)meet the defined requirements.
• Worked on different type of Stages like action, calculation, and multi calculation.
• Experience in Read, write, Code, Decision, Data item, Collection Stages.
• Experience in exception handling using Exception, Recover, Resume stages.
• Experience in troubleshooting and debugging automations.
• Strong and precise understanding of technological limitations and clear understanding of Windows/Web/Mainframe integration.
• Good understanding on salesforce concepts and automating.
• Configuring new automated processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Created and documented test procedures and scenarios for the pre-UAT phases. And supported operational teams during the UAT and rollout phases.
• Integrated the advanced features of automation tools like OCR, Web Recorder for existing robots and improved the performance.
• Managed bots scheduling and executed batch data processing.
• Experience in work queues configuration, monitoring and Internal Blue Prism & UiPath work queue actions.
• Implemented user authentication by defining user roles, creating users and setting password policies.
• Worked as team along with production support, designed and developed RPA solutions to accelerate Business processes.
• Worked on process definition document step by step keystroke level.
• Worked on solution diagrams and solution description and object model diagrams.
• Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.
• Worked extensively on data manipulation using string handling functions.
• Experience in CSV to Excel conversions, Word document and Outlook automations using Automation Anywhere.
• Supporting existing processes and implementing change requirements as part of a structured change control process.

TECHNICAL SKILLS:

Tools: RPA Tools Blue Prism V-5.0, Automation Anywhere V10,V10.2, UiPath 2016.2

Programming: C#, VB.Net

Packages: MS Office (Word, Excel, PowerPoint, Visio).

Database: SQL Server

Operating Systems: Windows7, 10 Linux/UNIX.

Reporting Tools: SQL Server Reporting Services, Crystal Reports

.Net Frameworks: .Net Framework 4.5/4.0/3.5/3.0/2.0

Servers: Windows Server 2008/2003/NT, Microsoft IIS (7.0/6.0/5.0/4.0 )

Scripting: VBA, Unix Shell scripting, JavaScript

Network Managements: SNMP, SSH, Telnet, ICMP, Net flow

LAN Technologies: VLAN, VTP, STP, RSTP, PVST,802.1x

WAN Technologies: HDLC, PPP, ATM, SONET, MPLS, VPN, IPSec-VPN

PROFESSIONAL EXPERIENCE:

RPA Developer

Confidential, NC

Responsibilities:

• Involved in the centralized infrastructure for maintaining several bots across the organization.
• Implemented new reporting techniques and facilitated the presentations to the clients.
• Innovatively integrated the advanced features of automation tools like OCR, Web Recorder for existing robots and improved the performance.
• Maintain and the several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization.
• Used String Operation to Compare and eliminate duplicates from the data.
• Maintain and/or modify existing procedures in VBA code in Access and Excel
• Executed Agile processes for enhancing performance.
• Maintain and make improvements to macro enabled spreadsheets using VBA to facilitate hierarchy building process.
• Experience in staging and deploying the automation solution into test and live environments.
• Interacting with clients and involved in business process walkthrough.
• Responsible for all support related issues.
• Involved in system design and development using collections and multithreading for the action classes.
• Created database connections to fetch the data and automated the process to arrange data with Automation Anywhere.
• Performed task scheduling using like Schedule Manager, Task Editor, Data Drive Tasking.
• Investigated existing SAS code, created query, maintained, and defined strategies to improve the efficacy of SAS programs.
• Developed robotic bots to automate process which was done using manual interference.
• Experience in using Send Email command to Email reports and errors.
• Proactively designed RPA Tasks as per application and business requirements.
• Identifying and debugging the errors using Error Handlers, log errors and screen shots.
• Utilized the bot framework and contribute towards enhancing it.
• Extensively worked with commands like object cloning, web recorder, Terminal Emulator.
• Developed and implemented new technical solutions for production applications to interact effectively with users.
• Setup bots in the Control room.
• Integrated IQ bots to provide end to end automation. Dealt with Metabots to improve RPA adoption and reduced downtime while updates.

Environment: Blue Prism V5.0, Automation Anywhere, VBA, MS EXCEL, IBM Mainframes, windows, excel, Agile Scrum, HTML, CSS, jQuery, VB.NET, C#, ASP.NET, .NET framework, OCR.

RPA Developer

Confidential, PA

Responsibilities:

• Involved in designing, developing and implementation of Robotic process automation (RPA) using UiPath.
• Effectively using Trigger mechanism for running the Bots.
• Efficient in using log file and Database commands for logging all the activities performed by Bot.
• Worked with web and Windows Applications.
• Worked on all the capturing commands for effective automation.
• Use Object Recorder to manage and execute windows controls as a background process.
• Involved in automate the business requirement using by creating tasks using task recorder and task editors.
• Development Business Objects with UiPath Tool.
• Involved in the designing solutions utilizing RPA (Robotic Process Automation) software, maintain technical responsibility for project delivery as the technical resource on a project.
• Involved in the creation of different tasks for RPA.
• Extensively used Excel and Access Macros and VBA with Excel Forms and Excel Charts.
• Strong ability to convert business logic/requirements to automations.
• Worked on Logging into websites, searching websites, submitting web forms, or updating records on a website.
• Experience in staging and deploying the automation solution into test and live environments.
• Effectively used String Commands, Excel Commands, PDF Operations, Metabots, Decision Rules, Loops, Variable Operations for performing various functions.
• Defined RPA automation strategy for process involving mainframes, web service calls and web applications implemented performed stress test for bot Scripts to prove the scalability and stability of RPA code.
• Setup bots in the Orchestrator.

Environment: UiPath, J2EE, Java Script, VB, VBA, SAS Software, C#, .Net, ASP.NET, SQL Server 2014, HTML, CSS, J Query, Angular JS .

VBA, VB.NET/Developer

Confidential, OH

Responsibilities:

• Designed and developed the application using agile methodology.
• Participating in the requirement gathering and feasibility analysis
• Collecting information (questions, answers, explanations, e-mail messages, documents) from off shore team and presenting it to the client.
• Low level design documents preparation.
• Low level design walkthroughs with the customer.
• Coding/ Unit testing for the modules assigned Coordinating with offshore for task completion and review their deliverables.
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Code review for VB.Net and Mainframe components.
• Peer review for onsite deliverables.
• Unit test results validation/ verification.
• Working as the first-level escalation point for problems related to the offshore team.
• User acceptance testing(UAT)/ documentation to users regarding the changes.
• Deployment activities discussion with all stakeholders.
• Deployment support and post deployment monitoring.

Environment: ADO.NET, ASP.NET,VBA, VB. NET, Visual Studio, IIS, Web Services, MS SQL, C#, CSS, HTML, DHTML, JQuery, Java Script, SSIS, Win forms, VSS.

.Net/Jr.Developer.

Confidential

Responsibilities:

• Understanding low level design document.
• Design modules developed by using C#.
• Develop applications using VBA and Visual Basic .net
• Code review for VB.Net and Mainframe components.
• Designed and developed web based UI in VB.Net using different controls like HTML Controls, Data Controls and Web Controls.
• Implemented TDD environment using Visual Studio Unit Test Framework.
• Built reusable .NET libraries and MVC 4 pages that utilized them.
• Involve Coding Using Classic ASP, extensively used VB Script.
• Developed classes and interfaces for the Data Access layer using VB.Net, ASP.NET ADO.NET, and SQL 2000 data access library.
• Designed and developed Web Forms using ASP.NET, C#, .NET and Visual Studio. Performing unit testing for various modules of the system.
• Responsible for imparting application knowledge and technical learning to the new team members inducted into the Project.
• Implemented and Used REST Web Services API with the help of WSDL and SOAP to get updates from the third parties
• Maintaining the application.
• Setting up the QA region for the System testing.
• Creation of Mainframe packages for components QA move Production move checklist preparation and change request creation

Environment: Visual Studio .NET 2008/2010, IIS 7.5, VBA, C#.NET, ADO.NET, ASP.NET, XML, XSLT, HTML, CSS, JavaScript, Windows Server 2008 R2, SQL Server 2008, DB2, WCF, JavaScript, TFS, CMS.

Web Application/Technical functional responsible.

Confidential

Responsibilities:

• Understanding low level design document
• Developed stored procedures and Functions SQL Server-2005
• Design and Develop business object layers using C#
• Developed system objectives, requirements, business models, user models, and business rules.
• Designed and validated the business processes of the application with use case diagrams, class diagrams, and sequence diagrams using UML enterprise architecture
• Assisted in designing web application architectures to utilize and work within corporate security guideline.
• Designed and coded 3-tier applications with front-end development in MS VB.NET, C#.NET, ASP.NET, SQL server 2005
• Designed and coded stored-procedures in MS SQL server 2005.
• Extensively used C#.NET technology to get advantage of disconnected data programming using technologies like datasets, data adapter, data reader, data tables, data view and data grid.
• Detailed documentation and code reviews.
• Extensively use CSS, JavaScript and AJAX for developing various web forms.
• Generated reports using Crystal reports.
• Involved in designing and developing the GUI for the user interface with various controls that include Grid View, Data List, Textbox, Calendar, List Controls, Dropdown, Validation Controls etc.
• Creation of Mainframe packages for components QA move
• Performed unit testing and involved in documentation.

Environment: VB.NET, .NET Framework 1.x/2.0, ASP.NET, C#, ADO.NET, XML, Web services, HTML, CSS, SQL Server2005, Crystal Reports, IIS 6.0, Windows 2000, VSS, Visual Studio 2008