adlmjy@r.postjobfree.com

+91-897*******

SANJAY SELVARAJ

Skills

RPA development

Requirement Analysis

Blue Prism

Change Management

Bot Deployment

Production Support

Automation Anywhere

UI Test Automation

Data Analytics

Data Migration

ETL testing

Data warehouse

Smart Routing

Functional / DB testing.

Informatica

SQL

UNIX

ACL

XML

Quality Assurance

PowerBi

Certifications

Blue Prism Certified Developer

Oracle Certified Associate

ACL Certified Data Analyst

ISTQB Certified Tester

Education

Bachelors in Engineering from

Visveswaraya technological

University (VTU)

Professional Synopsis

Having 10+ years of experience implementing RPA solutions along with Support and Change Management in all functional areas of RPA Development from Feasibility Analysis to Product Deployment and Solution Design covering areas of Banking, Finance and Insurance.

Work Experience

Associate RPA Manager

Accenture-AIG

May 2020 – Present

Responsibilities:

Successfully transitioned RPA Processes and Bots from external RPA vendors.

Developed and migrated the new requiremts from business to Production.

Re-designed the existing RPA frameworks.

Managed the support and change management cycle for the RPA development team.

Part of new process walkthroughs and periodic peer code reviews for new business requirements.

Mentored, supervised and co-ordinated daily activity of RPA developers. Associate Lead

Deutsche Bank

May 2019 - April 2020

Responsibilities:

Successfully Automated Account opening Process for Deutsche bank .

Designed, developed and implemented the architecture for the RPA process.

Mentored development activities of Associates.

Successfully reduced the account opening time by 60 % implementing RPA .

Configured and Deployed Bots in Multi-Bot Architectural Environments. Project Lead

L&T Infotech

Nov 2017 - April 2019

Responsibilities:

Successfully Automated CITI banks KYC Process.

Reduced the UAT tests execution time by 50 percent.

Reduced FTE by implementing RPA SOlutions.

Migrated the complete CISCO's FPA data from Teradada to Postgres.

Improved the customer satisfaction by eliminating manual validations in KYC process.

Sr Analyst

Lore Software Solutions

Sep 2011 - October 2017

Performed Functional/ETL and DB and testing SMART .

Migrated client data to individual datamarts using informatica .

Automated the Regression cycle of smart Algorithm. Suport Associate

First Source Solutions

Oct 2009 - November 2010

Software Applications

RPA Tools:

Blue Prism

Automation Anywhere

Databases:

Oracle

Teradata

Postgres

Teradata

SQL Server

Oracle SQL developer

SQL Plus

DataLoad

Management and Tracking

tools

Rally

Quality center

Putty

SVN

Jira

Bugzilla

Languages

SQL

UNIX

ACL

Summary of Skills and Expertise

RPA and Automation:

Experienced in Automating Business process using Blue prism and ACL.

Automated Client on-boarding process for Deutsche bank using RPA.

Experience in Bot deployment to UAT and Production environments.

Worked on automating Citrix Mainframe SAP applications using Blue Prism.

Automated the complete regression of Smart Algorithm using an in-house tool

(Testing studio).

Experienced in automating Web, Window based applications using RPA tools.

Provided Proof of concepts for clients to kick start automation using Automation anywhere.

Automated the maker and checker process in CITI KYC using Blue Prism.

Worked on Informatica power center (ETL tool)

Trained on Tableau and Power BI (reporting tool). Database and ETL Responsibilities:

Tested DB objects like views, Indexes, constraints.

Performed different types of DB testing like Data Format testing, Data Type testing, and Data Size testing.

Have executed the stored procedures in QA sandbox.

Have read and understood mapping documents for writing ETL test cases.

Written ETL test cases for source to target evaluations.

Written SQL queries for executing the test cases.

Validated the source vs. target counts, data difference, duplicate checks, null checks between source and Tgts.

Tested Facts and Dimensions.

Tested Informatica mappings, workflows and transformations

Analyzed the incorrect data and suggested the dev team possible reasons for the failure.

Performed ETL test case review.

Tested the data migration between source and targets.

Reviewing the SQL queries

Projects Handled

RPA SOX Automation

Duration: May 2020 till date

Domain: Insurance

Role: Associate Manager

Company: Accenture-AIG

CLM- Onboarding /

Offboarding

Duration: May 2019 –May 2020

Domain: Wealth Management

Role: Lead Associate

Company: Deutsche Bank

CISCO FPA

Duration: Sep 2018 –Mar 2019

Domain: Finance

Role: Project Lead

Company: LTI-Cisco

CITI- KYC

Duration: Nov 2017 –Sep 2018

Domain: Banking

Role: Project Lead

Company: LTI-CitiBank

Projects Summary

RPA SOX Automation:

Description:

SOX control is a rule that prevents and detects errors within a process cycle of financial reporting. Sox Automation team was handling the Transitions and RPA automation of SOX controls using Blue Prism.

Responsibilities:

• Acquire Transition from existing RPA vendors.

Code reviews of the Sox controls and manage the RPA solutions in production.

Support and maintenance of RPA processes those are live in Production and in Hyper-care.

Process enhancements as per business needs to existing controls. CLM-Onboarding/Offboarding:

Description:

CLM team is responsible for Onboarding, off boarding, and to perform the position and activity checks for Deutsche bank clients and entities. RPA team was handling automation of onboarding and off boarding process. Responsibilities:

• Understanding the data flow from the operations team and identifying the key areas of automation.

• Interaction with business analysts to understand the KSD/PSD.

• Design the architecture for the project.

• Performed end to end automation/testing and deployment of the bots.

• Support and maintenance of the process deployed in production.

• Bug fixing to the live processes in production.

• Involved in documentation of RPA artifacts like KSD,Test scripts, Test scenarios,Solution design document, Operational / Solution design Documents Cisco-FPA:

Description:

Cisco FPA is a process to move all the Cisco related financial data from Teradata to postgres Database for enhanced performance and to ease of data retrieval process. Responsibilities:

• Understanding the data flow and the staging layers between the source and target applications.

• Minimizing the data leaks during the migration of financial data from OLTP to OLAP

• Identifying the duplicate, junk data in target database.

• Testing the performance of Teradata by loading the bulk data.

• Testing the data correctness between source and target databases. CITI-KYC:

Description:

CitiKYC is a Compliance Technology designed web-based application which is implemented to perform Simplified and Enhanced Due Diligence for Citi Bank Customers across the globe and it primarily focuses on verifying the identity of the clients and understand their financial activities and manage its risks effectively. Responsibilities:

• Understanding the business flow of the application and identify the key areas of automation.

• Interaction with Client to understand the existing process and propose of Automation to improve the process.

• Design the Automation architecture for the project.

• End to End development of process and testing.

• Drafting the project artifacts for kickoff.

• Test execution on UAT environments.

Projects Handled

Triton execution

Duration: Aug 2016 –Sep 2017

Domain: Banking

Role: RPA Dev

Company: Lore-ITG

Smart Routing

Duration: May 2015 –Jul 2016

Domain: Finance-Trading

Role: Automation Analyst

Company: Lore-ITG

Smart TCA

Duration: Apr 2014 –Mar 2015

Domain: Finance-Trading

Role: Automation Analyst

Company: Lore-ITG

Smart Order Routing

Duration: Sep 2011 –Mar 2014

Domain: Electronic Brokerage

Role: Sr Analyst

Company: Lore-ITG

Projects Summary

Triton Execution:

Description:

Triton order/execution management is in-house windows based order management system designed to send the client orders with advanced broker neutral trading in ITG. Client logs into the tool and chooses the tool as per his needs to selecting various types of fix tags to send the trade orders. Triton is designed to send the client orders during various market hours. Responsibilities:

• Interaction with Client to understand the existing process and propose of Automation to improve the process.

• Identify the best suitable tool for automation.

• Providing POC to client to kick start automation.

• Requirement gathering and preparing Business requirement document (BRD).

• Execution of bots for each cycle of testing and analyzing the failure report.

• Perform enhancements in the scripts due to changes in the UI.

• Support and maintenance for the process which in LIVE. Smart Routing:

Description:

Smart router is an execution algorithm/execution strategy which is designed to give best execution of the client orders within shortest possible time which handles client’s orders during pre-market, Post-market and regular trading hours. Smart dynamically scans for the available liquidity in displayed sources and delivers rapid fills, enhances performance with price and size improvement.

Responsibilities:

• Involved in identifying the key areas of automation by understanding the regression tests.

• Designing the Architecture for the automation process.

• Documentation for Automated Test cases, Issues & enhancements.

• Performing the Feasibility study for the process.

• Bi weekly presentation of the automated tests to the clients.

• Interact with the automation tool developers for enhancement to enhance test coverage.

Smart Order Routing:

Description:

The ETL layer first gets the data from the external source systems, cleanses and stages the data into staging environments. The data then subsequently is integrated, transformed, consolidated and loaded into the Data marts and Enterprise Data warehouse. This helps in Business analysis like trend on clients transactions on the stocks traded etc. Responsibilities:

• Tracking and analyzing root cause for production issues.

• Writing test cases for ETL testing by understanding transformation rules.

• Creating Test cases by studying Mapping document for ETL from source & targets.

• Testing record difference and data mismatch between source and targets.

• Performed smoke, installation, regression and integration testing.

• Drafting test artifacts including Test plan, test cases, defect reports.

• Installation of build on various environments of windows 2003, 2008R2, 2012.

• Test execution on various QA environments.

• Have performed DB testing.

• Involved in Daily and weekly status meetings.

Contact this candidate