Sangeetha Elumalai

ad1t3k@r.postjobfree.com

Contact: +1-336-***-****

linkedin.com/in/sangeetha-elumalai-69867b61

PROFESSIONAL SUMMARY

Overall 9+ Years of industrial experience with 4+ years in Payroll processing, 2+ years of experience in the banking domain (Campaign Management), Power BI experience of 2 years of experience and with 1 year of experience as RPA developer.

Worked on Campaign Management in banking sector with SAS EG (ETL) & SAS CI with 1.7 years of experience.

Worked as Senior ETL Test Engineer (SIT & UAT) in Hadoop & Data Lake layer technologies in data conversion projects.

Worked as Power BI consultant in developing reports and dashboards to the management to provide insights of the existing data and to analyse the scope for the future.

Worked as part of COE team to create some BOTS as part of automation and laid plans for future automation projects.

Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment & Software Test Life Cycle (STLC) for testing projects.

Competent in analysing the current business process and creating future state business process flows using industry standard BPM notations.

Exceptional working experience in GAP analysis and understanding of the AS-IS and TO-BE business processes.

Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.

Hands on Experience in creating PDD (Process Definition Document) and developed respective SDD (Solution Design Documents)

Adept with different software development methods like Water Fall and Agile (SCRUM) Method, Azure board.

Involve in analysing defects that have been reported in the JIRA and sending them over to the developers for a fix.

Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations.

Proficient in analysing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio.

Excellent skills in facilitating Joint Application Development (JAD) for eliciting functional requirements that support the High-Level business requirements.

Experience developing web-based applications screen mock-ups & UI.

Wrote PL/SQL code for data manipulation, validation, and reporting.

Designing and implementing database structures, including tables, indexes, and views.

Facilitating priority meetings with stakeholders to help business understand the impact of the JIRA & HP ALM in prioritizing them.

Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), High Level Design Document (HLD), Requirement Traceability Matrix (RTM) and testing documents.

Knowledge of Quality and Risk management concepts like risk management, mitigation, and contingency planning. Execution and was involved in the Testing Process

Expert in writing detail system use cases, developing business test cases, and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users.

Working knowledge of Change management and Release management.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, MVS

Testing Applications: HPQC, JIRA

Agile Methods: SCRUM, Azure boards, JIRA

Suites: Microsoft SharePoint, MS Project 2012, MS-Office 2013 (Word, Excel, Power Point, Outlook)

Other tools: Putty, Control -M, CI/CD : Git

Version Control Tools: SVN, Git

Requirement and Document Tools: Client approved in house templates.

RPA Tools: UiPath (V 2018.3)

Programming Languages: DB2, Base SAS (9.1 & 9.4), JCL, SAS- SQL, SAS ODS, SAS- Graph, SAS MACROS, SAS EG, SAS CI, UNIX, Hadoop,

SAS CI 360, Oracle PL/SQL, IBM DB2

Database: MS SQL Server 2012, MS access, IBM DB2, Oracle

PROFESSIONAL EXPERIENCE

Maven Companies Inc. - USA Oct 2023 – Till date

Business Consultant

Work with the team to enhance existing data privacy metrics to provide meaningful management information for senior management and board reporting

Assist the team to develop and deliver data privacy/protection and awareness

Rule development, testing and deployment

Working with teams to ensure corporate policies and standards

Assist with the co-ordination of the completion of GDPR privacy risk assessments to ensure key risks are identified and action plans produced to remediate

Assist in the investigation of privacy incidents/data protection breaches, to identify root causes and agree remediation actions

Created reports using Microsoft Visual Studio 2012 and using Report Builder for reporting.

Optimized PL/SQL queries and writing SQL scripts to enhance database performance and efficiency.

Identify and resolve errors and issues in the PL/SQL back-end and database and reported them and help the team to resolve the issues.

Documented technical specifications and processes.

Designed and implemented dashboards using Power BI.

Testing included - Have been involved in defect fixing (HP ALM) and deployment of the new solution.

DHL IT Services - Malaysia Jun 2017 – Apr 2019

Associate Consultant

Directed high-level requirements gathering sessions with Business Owners, Users, Departmental Heads, SMEs, and end customers for elicitations by means of JAD sessions, Interviews and Brainstorming Sessions.

Produced business cases, functional specifications, data validation mapping, SRS, BRD, FSD, non-functional specifications, use cases, RTM, mock-up Screens and user stories for web and mobile application changes and enhancements.

Created 10 +KPIs for the client team to monitor them for any discrepancies.

Created data models to convert data available in ServiceNow into actionable items.

Analyse and migrate existing reports - Involving in Requirements gathering from Business users and convert them to their desired

Report using MS Power BI, SSIS & SSAS.

Validated the test data in oracle (Service now) using PL/SQL queries.

Participated in database design reviews and providing recommendations for enhancements.

Prepared GAP analysis and Risk analysis via Document Analysis and Interface Analysis to understand the new business model and additional functionalities to be incorporated in agreement with the online processing compliances.

Have worked closely with client teams to understand the existing process and updated the existing dashboards for enhancements which could help in decision making.

Successfully managed UAT activities for Data Assurance, Data Quality, Management Accounting achieving all major milestones and deadlines.

RPA Automation

Piloted End to End Robotic Process Automation (RPA) using UiPath.

Developed the workflows as per client requirement.

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

Used Screen Scraping method, Web recorder, Data scrapping methods to extract text from running window application by appropriate output methods such as native, Full text and OCR.

Implemented Web Recorder for automating logging.

Configuring new processes and activities using core workflow principles that are efficient, well-structured, and manageable.

Deployed the process in UiPath Orchestrator and scheduled their execution.

Configured the Bots and deploying processes and scheduled the jobs in UiPath Orchestrator.

Participated with test teams during the Product test and UAT phases to fix assigned bugs.

Deployment of robots on VM’s

Created 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.

Analyze the feasibility of existing processes suitable for automation.

Automated Several 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 windows, web applications and CITRIX automation end-to end process automation using UiPath.

Scope International, Malaysia Jul 2016 – Jun 2017

Senior Test Engineer

Involved in Testing the Hadoop Framework end – to end of a project.

Have been involved in creating test plans, and helped junior testers to prepare the test cases, validation of the results, Test Strategy & Test Metrics.

Prepared daily status report on the status of the test cases executed, defects raised & status, Progress made on the project, timeline key issues / blockers & test phases with status.

Prepared UAT test cases & guided the users on the step-by-step instructions of how to execute them which would lead testers to the desired result.

Have been involved from UAT initiation, design, test execution & closure.

Involved In creating Test Plan, Test Strategy & Metrics.

Have been part of SIT & UAT Support.

Managed defects using HP ALM & JIRA.

Created the Test Metrics and have been served as a single point of contact for all the bug fixing and retesting.

Worked on Agile/Scrum development methodology.

Extensively used PL/SQL & SQL Queries and data validations.

Tested data from source to target Teradata platform.

Performed data sampling on a large set of datasets to perform validation against source data.

Encrypted data will be decrypted to see if the right set of data is being processed.

Created Test Strategy developed UAT Test cases and execution of Test cases.

Prepared test plans and executed Unit, Integration, User Acceptance testing using test cases to ensure that the systems conformed to specifications of business requirements & performance criteria.

CIMB Bank, Malaysia Nov 2014 – Jun 2016

Business Analyst – Campaign Management

Communicated with Line of Business and created Business Requirements Document (BRD), High Level Diagram (HLD), and part of Low level Diagram (LLD).

If necessary, created elements and attributes with consultation from Line of Business (LOB), for passing loan file information from one

service to another.

Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.

Execute day to day migration activities for Risk and Credit systems with success.

Analysed system impacts because of proposed changes. It entailed interaction with other systems users and Subject Matter Experts

(SMEs).

Provided quantitative analytical services to portfolio managers and senior leadership in areas including portfolio analysis &

optimization, asset allocations.

On the digital banking side, have created new and updated existing campaigns to target new and existing customers to be acquired

for Credit card & Personal loan (to improve the sales). Have been involved in Regression &Integration testing.

Used Macros in Excel to create and update data.

Have been a subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed.

Performed Form data validation checks on the details that are collected from the customer to ensure that they are correct, so that

they will be eligible for any promotion campaigns/Loyalty rewards before honouring them.

The data validation process has helped a lot in making right decisions and cut down a lot of reworks on the data processing and

reporting step if the invalid data have been in the system.

The data validations are mainly performed using Excel and PL/SQL, PostgreSQL, Teradata.

Gathered functional requirements, analysed workflows, and created narrative Use Cases to develop new process workflows for the

Campaign management.

Analysed the existing campaign Management workflow and provided recommendations to optimize the data flow.

Efficiently monitor project deliverables, milestones, and required tasks to successfully complete retail markets projects across multiple

stakeholders.

Always staying informed of emerging project management and Agile trends and best practices through contact with industry experts,

peers, internal and external, and professional organizations

Worked on GAP Analysis, Test Plan document, Project Plan, Traceability Matrix, User Acceptance Testing (UAT), and SWOT analysis.

Prepare and test data for credit cards and personal loan information.

Proficient in creating User Acceptance Test (UAT) Plans and implementing and coordinating UAT.

Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and

other potential users of the application.

Wrote complex sequential SQL queries and to generate statistics and developed Excel pivot tables to report the results.

Produced scheduled and on-demand risk management reports including building new reports and report delivery within defined time

frames.

Daily maintenance of credit risk application/credit batch; monitoring overage reports and breaches of counterparty credit limits, track

bug fixes, Coordinate resources across various applications, operations, or projects

Assisted with drafting provider manuals and business requirements documentation concerning payment methodologies.

Tracked the project flow and acquired signoffs from Business, System Development and Quality Analysis team.

Extracted the necessary customer information from the databases using SAS EG (Version 9.4)

Creating new Campaign (SAS CI 360).

Modify any existing campaign to meet the business needs (SAS CI 360).

Involved in Campaign management on an On-going basis (SAS CI 360).

Preparing the leads and send them to the RTC to call or the Clicks (Online)

Hewitt Associates India Pvt Ltd - Chennai, India Jan 2006 – May 2010

Batch Systems Analyst

Maintained client’s employee data to Hewitt’s system provided statistical reports and other related information to the client via Email and EFT on an Ad hoc /ongoing basis.

To perform all these activities on a huge population, batch jobs that run on MVS operating systems were made use of along with SAS

programs for reporting purposes.

Employees’ life insurance, coverage for employees & dependents and the Annual enrolment process, HR Client file processing, Payroll

processing are some examples of the kind of information involved in this project.

Involved in Production support for two runs for each job before it moved to ongoing team.

Providing the system side analysis using client requirement to team member to code the jobs and reviewing the files, loaded data in

tables before sending it to client.

Have prepared the test plans and validated the testing once complete by peers.

Created an EFT file to Aetna, which is the 3rd party vendor for the Prudential to send the eligibility file.

We determined the eligibility of the dependent that is eligible to receive the pension once the employee is deceased.

The data was loaded into Hewitt's database with some errors and decided to clean them up.

To perform the above activities on a huge population, batch jobs that run on MVS operating systems were made use of along with SAS programs (SAS 9.1) for mapping client requirements and loaded the right data to TBA.

Hands on experience in migrating codes from SAS 9.1 to SAS 9.4

The objective of this project is to set up a system to provide and maintain the payroll deduction information for the client’s employees

on an on-going basis (Using ETL).

Batch jobs with in-built as well as customized procedures and functions are largely involved in every activity of this project. SAS

programs and SQL queries are written whenever a report or mapping is required, a certain population needs to be identified.

Did Production support and Record keep activities daily.

Have migrated the jobs from dev to production using Migration jobs.

Have scheduled the prod reports for monthly/bi-weekly using Control-M.

Wrote SQL queries to test the source to target data.

Reported status to project management and project owners on a weekly and monthly basis.

Participated in release cycles of software developed.

EDUCATION

Master’s from Kongu Engineering College (Anna University) – 2005, Tamil Nadu, India

CERTIFICATIONS

Certified the RPA foundation course for UiPath (Online)

Certified the Microsoft Power BI Data Analyst Associate

Contact this candidate