Sql Server Developer

TANAJI RAO SHAMRAINOLLA

RPA Developer Certified

Phone: 551-***-****

Email: *******.******@*****.***

Professional Summary:

●A highly self-motivated and enthusiastic professional with around 3+ years of overall experience in IT which includes around one and half years of experience in Robotic Process Automation (Blue Prism/UiPATH)

●Expertise in Blue Prism /UiPath Tools.

●Responsible for building RPA solutions using Blue Prism, UiPath to automate IT/Business process end to end (BOTS). Solution design, handling cross functionality teams, code review and delivering RPA applications forte with experience from various industries add to versatility of professional aortic to business and vendors /clients.

●Experience working on Waterfall and Agile Methodologies - Scrum.

●Performed tool evaluation and feasibility to help in selecting suitable Automation tool for RPA implementation.

●Gathered business requirements, current and future state process designs and translated them into process flows and Visual Business Objects within the Blue Prism object studio, Blue Prism process studio.

●Involved in process automation collaborations with business users globally to analyze business processes, recommend RPA based solutions for the processes, and develop robots using Blue Prism tool

●Worked on Integrating applications like (Web, Services, Mainframe, MS Office, GUI, Outlook etc.) using workflow, automation tools (BluePrism, UI Path).

Hand on experience in Robotic Process Automation (RPA) with UI Path across different platforms and successful implementation in Production environment.

●Working on Business process diagrams and process flow charts with RPA tools.

●Working knowledge of Blue prism for developing front office and back office robots

●Created end to end automation solutions for clients as per requirement which involves feasibility study, designing architecture, development, testing and deployment of automation.

●Experienced in developing Web applications using .Net, VB.NET, ASP.Net, SQL Server.

●Effectively used UML Diagrams (Behavioral: Use case, Sequence, Activity and Structural: class diagrams), Rational Rose Enterprise Edition, Star UML for developing system architectures.

●Proficient in developing applications using Object Oriented (OO) programming concepts

●Expertise in database design and developing Stored Procedures, Functions and Complex Queries on SQL server using SQL Server Management Studio

●Excellent communication, leadership and interpersonal skills with proven abilities in resolving complex software/ application related issues.

TECHNICAL SKILLS

• Blue Prism, Ui-Path

• RPA consulting and planning

• Bot Deployment strategy

• RPA Tool feasibility

• RPA Initial Process Assessment

• Bot maintenance planning

• Process Definition documentation

• Control room, Bot creator and Bot runner setup

• RPA Infra planning

• Architecture and Design

• RPA Test Strategy

• Functional, regression and performance Testing

• QTP Automation

• HTML, VB script, Java script.

• Experience in C#, .Net

• Performance testing with HP load test.

• Metrics, ROI and reporting

Professional Experience:

BCBS Jan 2017- Dec 2017

Role: RPA Developer – Ui-Path

Description: The main aim of using RPA is to automate the routine business process activities by designing and deploying efficient software bots expenses at regular expenses, we have deployed around 17 bots, running 13 processes and handling 1.7 million Requests-per/year.

Responsibilities:

●Worked with the Business Analysts in identifying and defining the requirements.

●Analyze the feasibility of existing process suitable for automation.

●Participated online meetings to demonstrate the capabilities of RPA for on-going projects and potential clients.

●Developed Ui-Path Processes and Business activities for various business systems.

●Provide knowledge transfer/support/Assistance to the Application development and Support teams.

●Supporting business and technical teams during robotic projects and mitigate/Resolve risks and issues that may impact project schedule, cost, scope, quality etc.

●Worked with mainframe, windows, web application and citrix automation end-to-end process automation using Ui Path.

●Worked with the UI team to design the appropriate icon and display for the screens.

●Experience in staging and deploying the automation solution into test and live environments.

●Efficiently handled monitoring and troubleshooting the Ui-Path environment through Orchestrator.

●Managed a team of developers in an agile environment.

●Lead the Teams Both On-shore and Off-shore Teams to ensure the deliverables are smoothly achieved on time.

●Extensively worked on debugging application for fixing bugs and Production support.

●Involved in code review and fine tuning the code for performance related issues.

●Maintaining several RPA bots as batch processes on daily basis and ensure quality and high performance to the internal and vendor applications of the organization.

●Working closing 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: UI-Path, ASP.Net 3.5, C#, Web Services using WCF, IBM DB2, IBM Clear Case, SQL Server 2008.

Liberty, Indianapolis, IN Feb 2016 - Dec 2016

Role: RPA Developer

Description: Implementation of RPA system for e-Invoice Data Entry process, Invoice Data Entry Process, Invoice Compliance Process. Collaborate with the Project Manager on written and oral communication to the stakeholders, and end-users and Create Metrics, Graphs and Status Report.

Responsibilities:

●Involving in identifying the opportunities to automate manual tasks using Robotics Process Automation (RPA) technology, and established Commercial-wide RPA program to deliver the first software bot in production

●Creating solution on process automation for different Business Applications (Windows based, Browser based, Java and Mainframe). Configuring new Blue Prism processes and objects using core workflow principles that are efficient, well structured, maintainable and easy to understand for further requirements.

●Feasibility study for RPA implementation by developing Proof of Concept (POC) and validating it with Proof of Value (POV).

●Working with advanced Blue Prism technology for Web Service which has reduced 50% development & maintenance effort.

●Managing governance & adopting Blue Prism best practice approaches.

●Involved in designing, developing and implementation of Robotic process automation using Blue Prism.

●Working in the centralized infrastructure for maintaining several robots across the organization.

●Created process model for browser based application using Blue Prism and testing it in the inbuilt control room provided by Blue prism.

●Automating data transfers, including importing/exporting data between applications or files.

●Automating routine backups and file management tasks.

●Creating Functional Requirements Documents (FRDs) for a Robotic Process Automation project, based on business process design discussions with business stakeholders.

●Participating in Setting up the Blue Prism development environment (software installation, installation of related technologies such as Splunk/logging etc).

●Designed solutions utilizing RPA best practices and maintain technical responsibility for project delivery.

●Created implementation plan for RPA solution design and get it sign of from operations.

Environment: Visual Studio 2015, SQL Server 2014, Blue prism 5.0, MS office, Quality Center, Windows 2012, Quality Center 9.0, HTML, .NET, SQL server, XML.

Wipro Technologies, Hyderabad May 2014 – June 2015

Role: Web developer

Description: Develop new web applications as identified by management using ASP.NET, WCF, web services, and MVC architecture. Maintain and enhance existing web applications and all integrated systems utilizing C#, ASP.NET, MVC4.

.NET Web application for Wipro managers

Developed the internal web application to view and modify employee and project details

Developed web application logic in C#.NET, ASP.NET using Visual Studio 2012

Developed the user interface in HTML, JavaScript which prompts the users and allows accessing the data according to their roles.

Developed complex SQL queries as per the filters applied by the user on the web application

Used SQL developer to retrieve the data from local Microsoft Azure cloud.

Used SQL data adapter to retrieve data from data tables to grid views from sql server to web application.

Played admin role of the database throughout the project and trained the support team of 5.

Environment: MS Access, MS SQL Server, Visual Studio 2012, MVC4, HTML, CSS, XML, JavaScript and JQuery, Google Analytics.

Education:

Bachelor’s Degree – JNTUH, Hyderabad, India-2014.

Master’s Degree – NPU-2016.

Contact this candidate