SUMMARY

• Overall 7+ Plus years of IT experience including 3 years of RPA Process implementation using Blue Prism.
• Hands on experience in building Blue Prism Processes and Business Objects for various business systems robots.
• Experience in analyzing requirements & BOT development and facilitating improvement in applications, planning and building effective environments.
• Used process, objects, work queues, calculations stages to perform logical operations in Blue Prism.
• Hands on Experience using VB and VBA macros.
• Working on Queue Configurations, Monitoring, Internal Blue Prism Work Queue Actions, Exception handling, efficient use of stages, blocks, data types, session and environmental variables for processing of Business Process diagrams and Process flow charts using RPA tools.
• Performed stress test for BOT scripts to prove scalability and stability of RPA code.
• Experience in structured and pattern based data extraction using Web Data Extraction and export the data to Excel or a database.
• Hands on experience in managing robot's workloads using Blue Prism Work Queues.
• Experience in handling various backend data sources like MS SQL Server 2000/2005/2008 , MS Access, XML Data source, Oracle 9i/10g.
• Experience in writing stored Procedures, Triggers, Functions, Views, Indexes and Joins in SQL Server and Oracle.
• Has very strong background in a disciplined Software Development Life Cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Experience in working with source control systems like Team Foundation Server, GIT.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

RDBMS: SQL Server 2014/2012/2008/2005.

Database Tools: Management Studio (SSMS), BI Development Studio (BIDS), SQL Profiler, Query Analyzer.

Other Tools: Data Transformation Services (DTS), SQL Server Integration Service (SSIS), SQL Server Reporting services (SSRS).

Languages: SQL, Transact - SQL, PowerShell., Command Prompt.

Operating Systems: Windows 2003/2008/2012.

PROFESSIONAL EXPERIENCE

Confidential, Westerville, OH

RPA Developer

Environment: Blue Prism, MS office, Quality Center, Windows 2012, Quality Center 9.0, HTML, .Net, SQL server, XML, HTML, CSS.

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business.
• Experience in managing robot’s workloads using Blue Prism Work Queues.
• Experience in building Blue Prism processes and Business Objects for various business systems.
• Implemented new reporting techniques and facilitated the presentation to the clients.
• Identifying new process opportunities and accurately analyzing and estimating new Processes, quickly assessing feasibility.
• Communicating with Blue Prism on software related issues, suggested improvements and participating with other users in the Blue Prism community.
• Preparing reports for the day-to-day as well as weekly/monthly purposes.
• Working 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.
• Participated in Setting up the Blue Prism development environment (software installation, installation of related technologies such as Splunk/logging etc).
• Involved in designing, developing and implementation of Robotic process automation using Blue Prism.
• Automated routine backups and file management tasks.
• Worked on advance Blue Prism technology for Web Service which has reduced 50% development & maintenance effort.
• Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies.
• Created reusable automation framework with Meta-Bots and reusable libraries with data externalization for RPA implementation.

Confidential, Troy, MI

MS SQL Server Developer

Responsibilities:

• Developed Use Cases, Sequence and Class Diagram understanding the client requirements using MS-Visio.
• Implemented GUI using HTML, XML, Ajax control library, CSS and Web Form Controls to create web pages, developed Master Pages, classes for reuse.
• Involved in the migration of the Legacy ASP application to ASP.NET and MVC.
• Implemented AJAX support for better user experience and good performance.
• Involved in analysis, design, and development and testing of the application.
• Interacted with the client, for documenting business details and designing Software Requirement Specifications and Project Management.
• Designed the application using an MVC (Model View Control) architecture that promotes a clear separation of the presentation, business logic, and data access tiers.
• Developed Presentation layer (Web Forms) using ASP.NET, HTML, and JavaScript and C#.
• Created the User controls and worked on custom controls for the presentation layer.
• Used several server side controls like Data Grid, Calendar control, and validation controls.
• Generated entity classes based on the database schema and improved the development of N-tier architecture using LINQ.
• Assisted in the middle-tier design of XML, XSD’s, and XSLT’s for communicating data to and from the database via Web Services.
• Creation and implementation of stored procedures, triggers, views, and queries.
• Performed unit testing on every new version before sending it for User Acceptance Test.
• Used Team Foundation Server for integration, maintenance and Security of code.

Confidential

SQL Server Developer

Environment: VisualStudio.Net2005, C#.Net, SOAP, Scrum, Web Forms, n-tier, SOA, UML,ASP.NET, T-SQL, XML/XSLT, Web Services, Crystal Reports, VB Script, SQL SERVER 2005, SSRS, AJAX, SSIS, COM, Visual Source Safe.

Responsibilities:

• Involved in Requirement gathering, Design, Development, Testing and Implementation of the web application and used Scrum development life cycle.
• Involved in creating Use case diagrams, Class diagrams, and Sequence diagrams using MS Visio.
• Worked on CSS style sheets for the layout of the site with respect to the business requirements.
• Developed Business logic for Broadcasting Messages where any user type can create a message, edit a message and can broadcast a message at a scheduled time.
• Developed ASP.Net pages using ASP.NET web form controls, Custom user Controls, HTML server controls in C#.
• Used client side and server side validations for better performance of the system.
• Worked extensively with Data Grids.
• Used ADO.NET and data objects such as Data Adapter, Data Reader, Data Set, Data table for consistent access to SQL data sources
• Experience in setting up security and auditing for authentication of the application.
• Involved in using SSL implementation of XML Web services for secure communication between client and the web service.
• Wrote SQL Queries to create tables, stored procedures, triggers, creating DTS Packages using SQL server 2005.
• Involved in Unit and Integration testing of the application.