RAM SINGH
Mobile No: +91 8938482144 Email: ramsingh88 @gmail.com
OBJECTIVE
To excel and grow in the sphere of business by working with such a growing and reputed
organization, which gives me a better opportunity to prove my skills and utilize my talent,
rewarding to growth and expertise of the organization as well.
EXPERIENCE
5+ years of IT Experience including 3+ years of experience in RPA 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.
Supporting our customers in implementing the required changes to make effective use of the
automation.
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 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.
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.
Automated the data transfers, including importing/exporting data between applications or
files using UiPath.
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.
Constantly evaluate the RPA strategy and approach to identify areas of improvement.
Actively participated in Test plan preparation, validating the Client requirements and
identifying the various Scenarios for Automation Development.
Experience in Control Room Resources and Session Management and correct use of stages,
data types, and session and Environment variables.
TECHNICAL SKILLS
Automation Tool : RPA UiPath, UiPath Orchestrator, UiPath Robot,
Programming Languages : .NET,
Web Technologies : HTML
Database : MS-SQL Server 2008R, 2012
Operating Systems : Windows 7 and 1
ACADEMIC QUALIFICATION
MSC from University of Salford Manchester (United Kingdom).
PROFESSIONAL PROJECTS
In this Process RPA is divided into three parts: 1) Materials file analysis, 2) SAP blocking
and 3) STICC blocking. This process is triggered on a monthly basis. To get the database files to
perform the reference and validations. Getting Inputs and sending the output data in a excel and to
send Exception emails to client, and output excel files also to perform Customer blocking and
CEDIS notification perform Customer blocking
Responsibilities:
Worked with SME's to create PDD (Process Definition Document) and developed
separate SDD (Solution Design Documents).
Implemented End to End Robotic Process Automation (RPA) using UiPath.
Used UiPath automation elements such as Mouse, Keyboard and Attribute to automate the
desktop sequence activities.
Used Data Scraping method for extracting structured data from browser applications or
documents into a CSV file or Excel Spread sheet.
Used Excel automation for repetitive Excel data entry, appending and for comparing
columns.
Scheduling Jobs to all the Processes by using Triggers in Orchestrator.
Develop and maintain robust frameworks for the automation with effective exception
handling, retry mechanism and Alert Mechanisms.
Identifying and debugging the errors using Error Handlers.
Supporting application in response to business needs.
Fine tune performance and operation issues that arise with RPA Bots.
Client Description:
Tech Mahindra Limited is an Indian multinational provider of technology and Business solutions
to various industry verticals and horizontals. Tech Mahindra has provided me opportunity to work
with leading PepsiCo Latam order release process. I was involved in automating several business
processes using RPA tool UiPath.
Any order related to a customer ID in sap that needs validation prior release due to debt or
exceeded credit with Pepsi. Depending of the type of risk assigned to the client. Customers with
blocked orders should meet such conditions order to have their orders released. Any customer id
or order ids that do not meet the releasement condition criteria but have an exception email
authorizing order release within certain dates.
Responsibilities:
Implemented End to End Robotic Process Automation (RPA) using UiPath.
Developed the objects and workflows as per client requirement.
Worked with Business Teams to create PDD (Process Definition Document) and developed
separate SDD (Solution Design Documents).
Designed, Developed and tested Bot tasks using RPA UiPath.
Worked with the Business Analysts in identifying and defining the requirements.
Automated PDF, Excel, Web applications, Desktop Applications using RPA (UI Path).
Working on Business process diagrams and process flowcharts with RPA tools.
Created the test cases and captured the test results.
Test the robots in different test environments.
Code reviewing and maintain the best practice by the following framework, naming
conventions, using and setting reusable components, readable code.
Bug Fixing, Process Maintenance, and Application Support.
Used UiPath Orchestrator for deployment, monitoring and management of UiPath Robot
automation activity.
Worked with test teams during the Product test and UAT phases to fix assigned bugs.
Client Description:
Absa Group Limited, formerly Barclays Africa Group Limited, and originally Amalgamated
Banks of South Africa, is an African based financial services group, offering personal and business
banking, credit cards, corporate and investment banking, wealth and investment management.
Absa was founded in 1991.
This process automates the creation of “Pockets” product which is a savings account for the
existing customer for My Pocket initiative. When a client applies for a pocket online, an email lead
is generated and then assigned to an employee to complete. This process looks to pick up the lead
from a mailbox and automatically creates and link pockets the respective accounts.
Steps:
1. Access outlook to acquire the data required to create a My Pocket account.
2. Create all required My Pocket accounts on Banking Platform. Once the accounts have been
created, they will need to be linked to the relevant parent account.
3. The client will need to be sent an SMS at the end of the process whether successful or not. This
could be a message notifying them of the failure to create the pocket, whereby they will need to go
into a branch, or a notification that the pocket was successfully created.
Responsibilities:
Involved in creation of process documents like solution design document.
Gathering detailed requirements from Client for business requirements.
Developed and configured automation as per the SDD.
Daily update the process report and status to the client team.
Developed the objects and workflows as per client requirement
Created process model for windows-based application using UiPath and testing it in the
inbuilt controller provided by UiPath Studio.
Automated Banking platform, MS excel and outlook applications.
Involved in the processes QA (Manually and Machine Test) Sign off from team lead.
Involved in the process integration and test the process in control room with the help of
session management.
Preparing service introduction and release notes documents for support team.
Release the package with the help of release manager.
Deploy the process in production with the help of supporting team.
The Internal Settlement process is in the Group Finance division (services and support) space.
The process entails reconciling accounts (doc split, Internal Settlement) using various reports. The
applications assessed during the internal settlement process are SAP FI, Microsoft outlook and
Microsoft excel. The aim is to provide 150% efficiency by automating this process.
Steps:
1. Receive notification email from the SAP CoE.
2. Access and run management account report.
3. Run daily balance report- Shows all the daily balances posted for the day and to pick up whether
imbalances
have been created in the accounts.
4. Run GL line items.
5. Compare internal settlement recon to internal settlement YTD.
6. Check GL line items to find out which document type does not balance.
Responsibilities:
Involved in creation of process documents like solution design document.
Gathering detailed requirements from Client for business requirements.
Developed and configured automation as per the Solution design document (SDD) to meet
the defined requirements.
Automated the data transfers, including importing/exporting data between applications or
files using UiPath.
Daily update the process report and status to the client team.
Automated SAP FI, MS excel and outlook applications.
Involved in the processes QA (Manually and Machine Test) Sign off from team lead.
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.
Preparing service introduction and release notes documents for support team.
Deploy the process in production with the help of supporting team.
It is monthly based report and run on 2nd business of the month. Business team will place input
file in shared drive. Bot will collect the fields like Company code, From Date, To Date from input
file. For each record, Bot will navigate in web application to transaction tab and select the dates
and download the file to bot drive.
Under and Over Accrual report template is other shared drive folder. Copy the data from
downloaded report from for company and perform some calculations. Finally need to run macro to
generate the report. Each repot has to upload to share point as well as mailed to business team.
Follow the same procedure for all records.
Responsibilities:
Involved in creation of process documents like solution design document.
Gathering detailed requirements from Client for business requirements.
Developed and configured automation as per the Solution design document (SDD) to meet
the defined requirements.
Daily update the process report and status to the client team.
Involved in the processes QA (Manually and Machine Test) Sign off from team lead.
Preparing service introduction and release notes documents for support team.
Deploy the process in production with the help of supporting team.
Client Description:
Westpac bank is an Australian bank and financial-services provider headquartered at Westpac
Place in Sydney. It was established in 1817. Westpac has employs almost 40,000 people, and it
has a total branches is 1,204.
This process is a part of the Access Provisioning with a CIB identity and access management
process group. The main purpose of the process is provisioning access of user, i.e., granting
access rights to application through control SA application.
UAM Provisioning team downloads a report of all active access requests from SAP BO and
filters it accordingly. The team processes each request by extracting details from Sail point and
assigning profiles in control SA application. The control SA application provides a web-based
interface to administer user privileges and access rights. The team also identifies exceptions and
resolves it accordingly.
Responsibilities:
Gathering detailed requirements from Client for business requirements.
Developed and configured automation as per the Solution design document (SDD) to meet
the defined requirements.
Create use cases and test the bot on regular time bases.
Daily update the process report to client team.
Involved in the processes Integration and testing.
Preparing service introduction and release notes documents for support team.
Deploy the process in production with the help of supporting team.
The main purpose of this process is to track pending Remove access request for UK leavers
and follow up with the team responsible to manage such requests. As per BNP security policies all
access to leavers must be revoked within 10 days.
UAC control team downloads report of all active access requests from SAP BO and filters it
accordingly for UK leavers. The team sends the report to the respective team responsible to
manage such requests. The team also validates aging of work items and sends escalations for SLA
breaches. The team then tracks the pending access requests for processing and liaises with the
concerned team owner.
Responsibilities:
Gathering detailed requirements from Client for business requirements.
Developed and configured automation as per the SDD.
Weekly once process demo to client.
Automate the various applications like SAP BO, MS Excel and Outlook.
Involved in the processes QA and UAT testing.
Preparing service introduction and release notes documents for support team.
Deploy the process in production with the help of supporting team.
The American Red Cross (ARC) is a humanitarian Organization founded in 1881 and Head-
quartered in Washington D.C, USA. Donor Data Portal is a utility used by American Red Cross to
support the following.
Functionalities:
1. Donor Data Portal is used for all financial donations tracking & acknowledgments.
2. Searching for Gifts and exporting details for further analysis. Performing Gift Linking
3. Administrative overrides searching for constituent’s data and exporting/printing details for donor
meetings.
4. Searching for Relationship Managers and exporting/printing their portfolio profile Link to Sales
force announcement functionalities etc.
