Business analyst

Arima Sarkar

Business Analyst

*****-***********@*****.***

Mobile- 636-***-****

SUMMARY

6+ years’ experience as an IT Analyst with more than 2 years working as a Business Analyst.

Extensive working experience in Telecom domain as well as Banking/Loan Processing/Mortgage Domain of major USA clients.

Has knowledge on Healthcare/Medical Domain.

Experience in working with UAT team in writing test cases and validating test results.

Experience in gathering requirements & conducting JAD sessions. Well versed with different stages of development I.e. analysis, design & QA.

Proficient in creating Use Case, Activity diagrams, flowcharts.

Excellent leadership and time management skills and strong work ethics and ability to learn new concepts.

Proficient in SQL and Oracle Database.

Hands on experience of using MS Word, MS PowerPoint, MS Excel, MS Visio and MS Project

Excellent communication, presentation and interpersonal skills with demonstrated experience in efficient interaction with customers and senior management.

ACCOMPLISHMENTS

Oracle Certification 12C (1Z0-071)- 2020

Project Management Professional PMP- 2018

TEAM APPLAUSE AWARD from employer - 2018

ON THE SPOT AWARD from employer – 2015

EDUCATIONAL DETAILS

BTech in Computer Science and Engineering (2011)

TECHNICAL SKILLS:

Operating System

Linux, Windows 7/XP/10

Database

Oracle Database 11g and 12c

Tools and technologies

SQL, SQLDEVELOPER, MS-EXCEL, MS-WORD, MS-POWERPOINT, MS-VISIO, MS Project, REMEDY, SSH TECTIA CLIENT, ORACLE ENTERPRISE MANAGER

Agile Tools

JIRA, Rally

PROFESSIONAL EXPERIENCE

Nov 2018-Present

I resigned from my job on Oct 2018 to stay with my spouse in St Louis, USA. I was waiting for my USA work permit since then. During this gap I continuously went through trainings and did certification to keep up with the industry standards and enhance my skills as a Business Analyst. I have received my H4-EAD work permit now and I am ready to join back and advance my career.

Sept 2017- Oct 2018

Tata Consultancy Services

Client- Citi

Business Analyst

The project focused on mapping all data elements used in servicing line of business of Citi mortgage with that of Cenlar as part of Cenlar-Citi contract wherein Cenlar will sub-service Citi’s loans. This would allow both Citi and Cenlar to build an entirely new mortgage Servicing system effectively.

Roles and Responsibilities:

Identified client needs and develop customized solutions; this involves understanding primary objectives and implementing.

Mapping & gapping the Citi-Cenlar fields/tables in Oracle along with impact analysis & risk evaluation.

Worked on PL/SQL (Oracle) to retrieve, check and confirm the data/ mappings and table/column designs.

Test user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories.

Worked with UAT team in writing test cases.

Led various meetings with ETL and other development teams to review Functional specification & design the database structure.

Created reports to communicate project progress to management.

June 2015 – August 2016

Tata Consultancy Services

Client- Cisco

Maintenance Business Analyst

This project was focused on Enhancement of alert management through Oracle Enterprise Manager. The project was a technical initiative to improve the monitoring of alerts through Enterprise Manager and reduce the number of junk alerts.

Roles and Responsibilities:

Facilitated JAD with stakeholders and technical team to refine functional requirement and propose solutions to improve existing drawbacks of the alert management system.

Worked as a Liaison between different stakeholders (client, DBA team, Enterprise manager team) to create an enhanced and more efficient alert management system

Worked with business and technical experts in gathering requirements from the client

Created monthly reports in Excel spreadsheet with pivot tables and charts and presented them to client with Microsoft PowerPoint.

Logged defects identified during testing using JIRA

Led a team of DBAs to validate and ensure that requirements were implemented successfully

July, 2011 – May 2015

Tata Consultancy Services

Client- Cisco

Database Administrator

This purpose of the project was to provide 24/7 support in maintaining and administering oracle databases and application environment.

Roles and Responsibilities:

Developed and enforced database security policies for data protection like setting up roles and privileges to users

Purging of auditing table and logs on regular basis.

Troubleshooting and resolving Oracle database and EBS application related issues (Issues related to Concurrent manager and Concurrent Program, Apache server bounce, DB Connections, Session Locks, DB Links, User Privileges, RAC related issues, Resources Unavailability, checking alert logs, Filesystem issues, Oracle Enterprise Manager issues etc.)

Configuring custom jar files on all the nodes of Oracle Applications

Involved in the setup of Oracle Wallet for Encryption Functions

Configured network components like TNSNAMES, Names Server etc. for easy and effective management of Oracle networking

Guided team members during execution of change requests as per standards and protocols

Helped team members in case of any issue faced during monthly and weekly releases.

Contact this candidate