JAGAN Mobile: +91 7448991252

RPA CONSULTANT Email:jagan789150@gmail.com

Professional Summary

 Having 4.5 years of IT Experience ,in that 2+ years of Experience in Blue Prism Robotic
Process Automation Tool and remaining on DBA.
Roles & Responsibilities
 Work with Business and Technology terms to analyze and assess automation feasibility .
 Understand and Estimate the business criticality and timelines and deliver proper results.
 Create reusable Processes and/or extensions for the RPA Toolsets.
 Actively participating in Test plan preparation, validating the Client requirement and identifying
the various Scenarios for Automation Development.
 Having Experience in different Testing methodologies like Unit Integration testing, GUI testing,
System Testing, User Acceptance testing(UAT), Installation.
 Conduct code and process reviews to ensure the highest level of quality.
 Analyzing the process and designing the Robotic Automation Solution as per standard Blue prism
design principles.
 Have good understanding and involvement in making Process Design Document (PDD) and
Solution Design Document (SDD).
 Work closely with business experts to document and define business cases and best uses for
RPA.
 Working on Queue Configurations, Monitoring , Internal Blue Prism Work Queue Actions.
 Working on Exceptions handling, Blocks, Session and Environmental Variables for processing
of Business Process.
 Expertise with Control Room Resource, Session Management, Blue Prism Calculation functions
and debugging of process solutions.
 Worked with target applications using different spy modes like HTML, Win32, Accessibility,
Region.
 Experience in Automating Web, Excel, Outlook, Windows, SAP and Mainframe applications
using Blue Prism and also automated behind Citrix environment.
 Strong self-motivated and willing to take up responsibilities.
  Able to work in a high pressure environment and capable of working in a team as well as
individually.
 Ready to Accept new Challenges to meet or succeed objectives.
 Excellent communication and interpersonal skills with ability to co-ordinate team.

Technical Skills

 Automation Tools : Blue Prism (BP)-4.0, 5.

Professional Experience

 Working as Software Engineer in Virtusa since May-2014 to Till Date.

Education

 MCA From Osmania University.

Projects

Project 1:
Title : Automating Back End Documents Management System.
Client: MAERSK.
Tool : RPA

Project Description:
Container shipping and related activities is the largest business area for A.P. Moller–
Maersk, providing almost half of the group's revenue in 2008. It comprises worldwide container services,
logistics and forwarding solutions and terminal activities under the brand names: Maersk Line, Safmarine,
and Damco. Since 1996, Maersk has been the largest container shipping company in the world.

As the fast-paced international Logistics industry was experiencing massive growth, a major
player needed a solution to process documents as quickly and accurately as it delivered packages. To
meet its increasing global document processing needs, the company needed to process multiple
documents. The customer makes the request for shipment from one place to another to the portal. It
should auto locate the arrival and upload arrival notice. It’s should fill the missing data to TSM. Once
after updating the missing documents it’s should release all documents which are related to shipment
release then have to trigger the email of the release.

Project 2:
Title : Automating Financial Ombudsman Service.
Client: Lloyds Banking Group.
Tool : RPA

Project Description:

Lloyds Banking Group the best bank for customers. As the UK’s largest retail and
commercial bank, we have a footprint that touches nearly every community and household in the UK.
That gives us a big responsibility to support the UK economy, and to put customers at the heart of
everything we do.

If customer challenges our report and we decide that we need to review the information or
proposed resolutions, an ombudsman will make the final decision. The ombudsman’s final decision
signifies the end of our process. The ombudsman’s final decision cannot be challenged and there is no
right of appeal. If the customer accepts our final decision you have 28 days to carry out all of the actions.
We will continue to work with you and the customer to make sure that this happens. If the customer
declines the decision or fails to respond to us with the given time frame, the consumer loses the right to
the solution offered, but remains free to complain in another way, for example through the courts. In this
situation we have no further involvement in the complaint and the case is closed.

Project 3:
Title : Automating Fraud Chargeback Processing.
Client : Citi Bank.
Tool : RPA.

Project Description:

Citi began operations in India over a century ago in 1902 in Kolkata and today is a significant
foreign investor in the Indian financial market. As promoter-shareholder, Citi has played a leading role in
establishing important market intermediaries such as depositories, credit bureau, clearing and payment
institutions. Citi helped lay the foundation of the Indian software industry by establishing Citicorp
Overseas Software Ltd.

A Customer may begin a chargeback by approaching their issuing bank and filing a substantiated
complaint regarding one or more debit items on their statement. Chargeback also provide a means for
reversal of unauthorized transfers due to identity theft. Chargeback can also occur as a result of friendly
fraud, where the transaction was authorized by the consumer but the consumer later attempts to
fraudulently reverse the charges.
Project 4:
Title : Tax Resources.
Client : Tax Audit (USA).
Tool : MS-SQL Server 2005,2008R2/2012.(DBA).

Project Description:

Tax Audit is brought to you by the audit experts at Tax Resources, Inc. Tax Resources, Inc. began
in 1988. Since then, we have provided expert tax audit defense, tax help, tax representation, and tax return
review services to millions of clients across the nation. We serve individual taxpayers, tax professionals,
accountants, associations, and small businesses.

Tax Resources provide support to an organization’s tax or accounting department. Their role is a
combination of administrative assistance and accounting support. They must be able to run an office, as
well as perform higher level functions, such as processing tax returns and maintaining databases.

Roles & Responsibilities:

 Installation and configuration of MS SQL Server 2005&2008 on New Production and Test
Servers with latest Security updates involving Service Packs and Security patches.
 Verifying all instances are up and Running.
 Moving the databases from one location to another location. Involved in database Suspect mode.
 Day-to-day activities like backup (or schedule the backups daily for database and transaction log)
on disk and restore the databases and transaction log on production/development servers as per
requirement.
 Responsible to improve the Server performance. Monitored database status including CPU,
Memory, I/O, space and Dead Lock using SQL Server Utilities. Involved in creating Databases,
Tables, and Cluster/Non Cluster Index.
 Involved in implementation of Log shipping and Mirroring Architecture as High Availability
techniques.
 Monitoring and troubleshooting Log shipping, Mirroring.
 Experience in creation of logins, users and configuring permissions and assigning roles to users.
 Intensive experience in Monitoring and Tuning SQL Server and database performance using SQL
Profiler, Index Tuning Wizard, Windows Performance Monitor Managing of databases objects
like tables, views, indexes.
 Migrating SQL Server 2005 data bases into SQL Server 2008.