SUMMARY

• Around 7+ years of experience with 2 Years in RPA Blue Prism technologies and with 5 years in SQL Planning, developing, testing, and implementing SQL Server DB import/export process.
• Created RPA structure and team along with production support, designed and developed RPA solutions to accelerate Business processes.
• Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing and deployment of automation.
• Used the Blue Prism Object Recorder to manage and execute Windows controls as a background process.
• Worked on Process Definition Document (PDD) step by step keystroke level.
• Deigned developed and tested Bots for tasks using Blue Prism.
• Worked on Business process diagrams and process flow charts with RPA tools.
• Worked on Available Process, Available Resource in Control Room.
• Debugging and identifying the errors using error handlers.
• Automated numerous routine tasks using Blue Prism, thereby reducing manual intervention.
• Identify and communicate the technical infrastructure requirements to design RPA process solutions in accordance with standard RPA design principles and conventions.
• 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.
• Designed different workflows to run several tasks using Workflow designer in Blue Prism.
• Experience in managing robot's workloads using Blue Prism Work Queues.
• Extensively worked with Workflow Designer, Trigger Manager, Report Designer, Schedule manager and Server Communication.
• Extracted data from Web applications, Windows Applications, PDF, Images, Web pages etc. and exported the output data to Database/Excel.
• Has Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• Extensive experience in writing complex stored Procedures, Triggers, Functions, Views, Indexes and Joins on SQL Server and Oracle.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Strong experience in design and development of relational database concepts with multiple RDBMS databases including Oracle 10g, MySQL, MS SQL Server & PL/SQL
• Hands - on experience with visualization tools such as MS Excel, MS Visio.

TECHNICAL SKILLS

Technologies: RPA Blue Prism

Languages: ASP.NET, T-SQL, PL/SQL

Web Technologies: HTML/HTML5, CSS/CSS3.

Tools: Visual Studio 2012, 2013, SQL Server 2008, 2012.

Database: Oracle9i, MySQL Server

Roles: Software Developer, Blue Prism Consultant.

Operating System: Windows XP/7/8 (Prof), Linux, Mac.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

RPA/ Blue Prism Developer

Responsibilities:

• Created Functional Requirements Documents (FRDs) for a Robotic Process Automation project, based on business process design discussions with business stakeholders.
• Involved in all phases of Software Development Life Cycle including design, development and creating test cases.
• Solid design, coding, testing and maintaining the RPA's (Robot's).
• Identifying and debugging the errors using Error Handlers.
• Interacted with window application and created an object and interacted all the objects in process studio and created work queue and ran the process.
• Interacted with window based application, called the process into the queues and interacted with mainframe based application.
• Created process model for windows based application using Blue Prism and testing it in the inbuilt control room provided by Blue prism.
• Worked on integrating applications like (Web Services, Mainframe, MS Office, GUI, Outlook etc.) using workflow automation tools Blue Prism.
• Assessed in defining end to end robotic process automation development and strategy.
• Developed the project using Agile methodologies and Test Driven Development.
• Worked with database SQL Server.
• Developed and configures automation processes as per the technical design document (TDD) to meet the defined requirements.
• Developed new processes/tasks/objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Reporting bugs to the Automation Architect
• Reviewing analytics and providing process improvement information to the Process Designer.

Environment: RPA, Blue Prism V-5.0, V-4.2, HTML, XML, CSS, Bootstrap, SQL Server 2014, Visual Studio 2015, Windows Applications, SQL server, Visual Studio 2015.

Confidential, Farmington Hills, MI

RPA/ Blue Prism Developer

Responsibilities:

• Creation, development and maintenance of automated MI Reporting of Blue Prism processes in MS Access and Excel, also looking into running this in MS SQL Server using MS Access front-end.
• Analyse the feasibility of existing process suitable for automation.
• Participate online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients
• Experienced in building Blue Prism Processes and Business Objects for various business systems.
• Worked with mainframe, windows, web application and surface automation. End to end process automation using Blue Prism.
• Implemented Blue Prism User authentication by defining user roles, creating users and setting password policies.
• Experience in using Blue Prism's Credential Manager for maintaining, securing and retrieving the user credentials.
• Exposure to Blue Prism, Single Sign-on implementation using Microsoft Active Directory.
• Develop blue print automation components based on Technical Architect recommendations following Blue Prism standards.
• Used Blue Prism MAPIEx adds on library for manipulating mail boxes.
• Experience in staging and deploying the automation solution into test and live environments.
• Extensively worked on debugging application for fixing bugs and Production support.
• Ensures that Blue Prism processes are designed in accordance with standard Blue Prism design principles and conventions.
• Developed scalable and efficient process automations and reusable components that can be leveraged across different lines of businesses.
• Efficiently handled monitoring and troubleshooting the Blue Prism environment through Control room.

Environment: Blue Prism 5.0, SQL Server, Oracle, Web services, Web applications, Windows Applications, MS office, Terminal, PDF reader, Oracle, SQL server, Services, Excel.

Confidential

SQL Developer

Responsibilities:

• Responsible for getting, understanding the business specs, preparing technical Specs, DTS Packages.
• Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
• Creating jobs for scheduling the SSIS packages.
• Getting data from different data sources.
• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
• Loading these data into data warehouse like SQL server.
• By using these data warehouse, based on client requirement wegenerate the multilingual reports in SSRS.
• Identifying of performance bottlenecks, Performance tuning of packages.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
• Prepared test plans for assembly testing & System Integration testing.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Created Procedures, Triggers, Functions and Packages.
• Database Query tuning and Implementation.
• Unit and System testing.
• Understanding the requirements and carrying out impact analysis.
• Implementation of the application on Production Server.
• Prepared root cause analysis for problems occurred
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.

Environment: Data Transformation Services (DTS), SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2005, Windows Server 2000/2003.

Confidential

SQL Server Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Configured and monitored database application.
• Created tables, indexes and constraints.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Managed the use of disk space, memory and connections.
• Designed and implemented several complex reports and administration modules.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Involved in performance tuning of the database and SQL queries using Explain Plan.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Rebuilding / monitoring the indexes at regular intervals for better performance.

Environment: SQL server 2000,MS SQL Server 2000/7.0, T-SQL, Windows 2003 Server, Crystal reports 8.0, MS SQL Server 6.5and Compuware QA Load test.

Confidential

SQL Developer

Responsibilities:

• Designed, developed, and maintained the company's Data Access Layer,maintained the necessary stored procedures, tables, and indexes required to support the data access layer
• Addressed system problems during off hours with the guidance from other members of the development staff as needed
• Partly Involved in System study and database designing.
• Install, configure and upgrade MS SQL Server.
• Porting the old data in to the new database using of BCP
• Assisted for Development and design the GUI with ActiveX Controls like MS Flex Grid, List View, Tree View, etc.
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Generated MIS reports using Crystal Reports.
• Client side implementation and testing.
• Maintain the application as per the users’ requirement.

Environment: SQL server 2000, MS SQL Server 2000/7.0, MS SQL Server 6.5, Microsoft Visual Source Safe 6.0, Visual Basic 6.0, Crystal Reports 8.0 and Windows 98.

Confidential

Junior SQL Developer

Responsibilities:

• Importing Source/Target tables from the respective databases by using Execute Package Task& using Control Tasks in SQL Server 2005 Integration services.
• Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services& SQL Server 2005.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, and sort and execute SQL Task to load data into Data Warehouse.
• Created Event Handlers to Handling Errors and Debugging for the Packages.
• Created Jobs and implemented it for scheduling the SSIS packages on a daily basis.
• Implemented unit testing.

Environment: Windows Server 2003, SQL Server Integration Services (SSIS), SQL Server 2005, SQL Server Reporting Services (SSRS).