PROFESSIONAL SUMMARY:

• Skilled certified professional having around 5+ years of IT Experience including 2 years of RPA process implementation using UiPath and Blue Prism and 3 years of experience in Database Design, Development and BI.
• Strong understanding of product capability, structure protocols, application integration, technology and architecture, deployment related to Robotic Process Automation
• Experience in Designing, Developing, Testing and deployment of Bot’s using tools Blue prism and UiPath
• Took training and have knowledge on Automation Anywhere tool
• Experienced in Determining RPA best practices and suggests how to improve current quality processes, standards and practices
• Certified in Diploma Of Completion in RPA Developer SAP Automation
• Experienced in setting up Queue configurations, Monitoring, Exception handling, efficient use of Stages, blocks, data types, for processing of Business Process diagrams and Process flow charts using RPA tools
• Hands on experience in building Blue Prism processes and Business Objects for various busi5=ness systems robots and in managing robot’s workload using Blue Prism Work Queues
• Expertized in using Blue Prism Object Recorder to manage execute windows controls as a background process
• Exposure to Blue Prism’s Single Sign - on implementing using Microsoft Active Directory
• Experienced in problem solving for the issues that arises in daily Blue Prism running and providing timely responses and solutions and preparing reports for defect statistics and tracking daily and weekly
• Extensive experience in using object cloning and key strokes to perform operation on web and mainframe applications
• Experienced in Designing solution, Implementing Blue Prism frame (Connectors, VBO, ACI, process studio, control room and system manager) work to update the provider directory from excel, website data through screen scraping and using OCR (Optical character recognition) from printed material
• Experienced in Robotic Process Automation Tool UiPath to automate web applications, desktop applications, and performed excel manipulations and validations
• Experienced in doing task recording, editing, scheduling and distribution using UiPath and working on different adapters like Application and Web to login to websites, searching in website, submitting web forms, or updating records on a website
• Expertise in implementing an automation of various processes like extracting data from CSV, Excel files, invoice processing, order processing, service desk automation etc. with the help of UiPath
• Strong knowledge in creating database connections using connect activity and .net framework Data Provider to fetch the data and automated the process to arrange data with UiPath
• Expertise in using Image comparison using Image recognition with OCR, ICR and machine leaning for designing in UiPath Studio
• Hands on experience working with various version controls like GitHub, Team Foundation server and Experience on identification and feasibility to help select the appropriate tool in RPA
• Highly proficient in participated in online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients
• Knowledge in understanding of the principles and best practices of Software Configuration Management (SCM) in Agile, Scrum, and Waterfall methodologies
• Strong knowledge on writing Functions, Views, Indexes and stored procedures in SQL database
• Hands on experience in working closely with Process SME’s to prepare Process Definition Document (PDD) & Solution Design Document(SDD) and educated SME’s to work with Bots in production
• Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Highly Proficient in working with databases like Oracle, MySQL
• Experience in enhancing and deploying the SSIS Packages from development server to production server
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure and strengthened in adaptability, analytical and problem-solving skill

TECHNICAL SKILLS

RPA Tools: Blue Prism, UiPath, Automation Anywhere

Programming Languages: C, C#, Java, SQL, Pyton

Databases: MS SQL Server 2005/2008/2008 R2/2012, MS ACCESS, Oracle

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating System: Windows, LINUX, UNIX

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service(SSIS)

Modelling Tools: UML, MS Visio, Visio Version Control

PROFESSIONAL EXPERIENCE:

Confidential, Eagan, Minnesota

RPA Developer/Business Analyst (UiPath)

Responsibilities:

• Responsible for implementing the full life cycle of RPA solutions: Identifying automation opportunities, gathered requirements, implement, test and deploy targeted automation solutions using industry leading RPA
• Gathered our customer’s business requirements and clearly documented them in order to our RPA Consultant teams to deploy automation projects in an optimal manner
• Delivered demos, technical trainings and support for new/existing clients
• Provided business analyst support expertise to Sales team to draft the RFI/RFP and POC stages and help sales team to draft the RFI/RFP responses
• Supporting our customers in implementing the required changes to make effective use of the automation
• Developed the objects and workflows as per client requirement
• Performed tool evaluation and feasibility to help in selecting Automation tool for RPA implementation
• Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Documents)
• Developed ROBOTS using UiPath to automate and accelerate 80% of standard business process with minimum human intervention for remaining non-standard processes
• Developed robots using UiPath studio, identifying and debugging the errors using error handlers and Participated in online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients
• Configured UiPath processes and objects using core workflow principles that are efficient, well structured, maintained and easy to understand for further requirement
• Automated Several Processes and Business activities for various business systems and Provided knowledge transfer/support/Assistance to the Application development and Support teams
• Supported business and technical teams during robotic projects and mitigate/Resolve risks and issues that may impact project schedule, cost, scope, quality.
• Worked with mainframe, windows, web application and CITRIX automation end-to-end process automation using UiPath.
• Created process model for windows-based application using UiPath and testing it in the inbuilt controller provided by UiPath Studio
• Used UiPath Orchestrator for deployment, monitoring and management of UiPath Robot automation activity
• Worked with OCR, ICR and Machine learning for designing in UiPath studio and with the UI team to design the appropriate icon and display for the screens
• Efficiently handled monitoring and troubleshooting the studio environment through Orchestrator
• Worked with Teams Both On-Shore and Off-shore Teams to ensure deliverables are smoothly achieved on time
• Involved in Logging into websites, searching websites, submitting web forms, or updating records on a website
• Automated the data transfers, including importing/exporting data between applications or files using UiPath
• Involved in code review and fine tuning the code for performance related issues and worked on debugging application for fixing bugs and Production support
• Maintained several RPA Bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization
• Worked with different teams in making changes in developed processes as per the Technical Design Document (TDD) to meet the defined requirements
• Worked with test teams during the Product test and UAT phases to fix assigned bugs

Environment: UiPath, .Net, C#, Web applications, Windows Applications, MS office reader, Oracle, SQL Server, SOAP, REST Services, TFS.

Confidential, Dallas, TX

RPA Developer (Blue Prism)

Responsibilities:

• Adept in Robotic Process Automation (RPA) from requirements gathering, solution designing, coding, testing, debugging, documentation
• Performed in building Blue Prism Processes and Business Objects for various business systems
• Involved in phases of Software Development Life Cycle of design and development
• Responsible for identifying the automation opportunities and gathering the requirements
• Worked closely with Process SME’s to translate process in to Process Definition Document (PDD) & Solution Design Document (SDD) and educated SME’s to work with bots in production
• Responsible for viewing current state process maps to optimize future state process and wrapped the OID and FRQ content with in the PDD
• Involved in preparing demos based on the automation performed and showcase the same to potential internal/external customers
• Actively Identified opportunity to automate manual tasks using Robotic Process Automation(RPA) technology
• Created solution on process automation for different Business Applications (Window based, Browser based, Java Mainframe) and managed a team of developers in an agile environment
• Automated user actions performed through interactions with Thin client application
• Implemented in building Blue Prism Process and Business Objects for various business models
• Automated various processes involved in SAP, billing system and CRM systems such as Account creation, invoice generation, “Order creation”, “Order submission”, “Creation of accounts” etc. to simplify the work for service desk using Blue Prism
• Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies
• Executed SQL Queries to check the data table updates after test execution using MySQL
• Participated in staging and deploying the automation solution into test and live environments and efficiently handed monitoring and troubleshooting the Blue Prism environment through Control room
• Involved in the centralized infrastructure for maintaining several robots across the organization
• Maintained 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
• Involved in Process Management, Defining, Designing, Development and Testing and Involved in developing, testing bot task using Blue prism
• Performed tool evaluation and feasibility to help in selecting a suitable Automation tool for RPA implementation
• Worked on Control Room Resource, Session Management, Blue Prism calculation functions and debugging of Process Solutions
• Created external scripts using VBS, VBA and integrated with Blue Prism to achieve process automation and created solid models by spying through Application Modeler
• Implemented exception handling techniques and setting alerts for the errors

Environment: Blue Prism, .Net, SQL Server 2012, HP-Load Runner, Visual Studio 2015, Git.

Confidential, Dallas, TX

RPA Developer (Blue Prism)

Responsibilities:

• Involved in End to End development of Business Process using Robotic Process Automation
• Performed required analysis by gathering both functional and non-functional requirements based on interactions with process owners, stake holders and designing, Testing, Debugging, Documentation and Implementation of Business Process Solutions
• Configured the Blue Prism infrastructure for development, test and live environments which comprises Interactive clients, Resource PCs, Application servers and Database servers
• Used Excel VBO object to perform operations in excel sheet while taking excel sheet data as input and Created Process, Objects, work queues, calculations stage to perform logical operations in Blue Prism
• Interacted with windows application and created object and interacted all the objects in process studio and created work queues and running processes
• Used Navigate stage to launch and navigate through other windows of an application along with the stages of read and write to input and extract the data from application
• Worked within project planning constraints, communicating any identified project risks and issues to the delivery/ project manager accordingly and providing inputs to the change control process
• Involved in communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community
• Created Database connections to fetch the data and automated the process to arrange data and created solution on process automation for different Business Applications (Windows based, Browser based and Main frame)
• Worked on Integration applications like (Web Services, Mainframe, MS Office, GUI, Outlook etc.) using workflow, automation tools (Blue Prism)
• Created and documented test procedures and scenarios for Pre-UAT phases supporting the operational teams during UAT and rollout phases and Analyzed the user stories and breaking up the user stories into sub-task with estimation

Environment: Blue Prism 4.2, SQL Server 2012, Web applications, MS office, Visual Studio 2015.

Confidential, Indianapolis, IN

SQL Developer/SSIS/SSRS

Responsibilities:

• Designed and created databases, DB Objects based on the business requirements
• Involved in creation of new databases, planning the location of data, index and transaction log files on the disks
• Created complex Stored Procedures, Triggers, Tables, Views and SQL joins and SQL Joins and other statements to maintained referential integrity and implemented complex business logic
• Designed Tables, Constraints, Views and Indexes etc. In coordination with the application development team
• Used Joins and sub queries to simplify complex queries involving multiple tables
• Provided technical support to move databases from development to test and production for multiple applications
• Created SSIS package to check XML file validation and data validation to match the requirements
• Created SSIS packages to transfer XML file data into SQL Server database
• Used SSIS and extract transform loading(ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application
• Improved performances of SQL Server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes
• Worked with SQL Server profiler to generate traces
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration
• Used SQL Server business intelligence Development studio to designs SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically
• Designed ETL packages dealing with different data sources (SQL Server and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and quarterly reports including status
• Involved in creating report datasets and using stored procedure parameters in SSRS

Environment: MS SQL Server 2008/2008R2/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010, SQL Server profiler, SQL Server Management Studio, SQL Server Data Tools (SSDT).

Confidential

SQL Developer

Responsibilities:

• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes
• Used SQL Server reporting services for creating, editing, and scheduling reports
• Created and maintained database objects, created complex Stored Procedures, Triggers, cursors, Tables, Views SQL Joins and Created stored procedures to use as the datasets for the Report Design by SQL Reporting services
• Created SSIS packages for different data loading operations for many applications
• Very extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice- versa
• Developed complex reports, which are migrated from different reporting tools
• Analyzed the existing application programs and tuned SQL queries using execution plan, SQL performance Monitor, SQL profiler
• Interacted with developers on various aspects, ranging from usage of utilities to SQL performance, test data and general troubleshooting
• SQL performance tuning by modifying SQL queries or changing/adding indexes
• Created and automating the regular jobs
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML and XML
• Integrated Stored Procedures to generate the Reports

Environment: MS SQL Server 2008, T-SQL, DTS, MS Access, Flat files, Windows XP