Data Analyst
Resume:
******************@*****.***
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