Resume

Sign in

Project Data Analyst

Location:
Charlotte, NC
Posted:
March 21, 2018

Contact this candidate

Resume:

ac4v5a@r.postjobfree.com Sudipta Ghosh (***) ****106

RoundPoint Mortgage Corporation Business / QA Data Analyst Wipro Technologies SQL QA

Analyst

PROFESSIONAL SYNOPSIS

WORK AUTHORIZATION

Employment Authorization Document (EAD)

TECHNICAL EXPERTISE

Testing Tools Requirement

Analysis Tools

Data

Analytics

Tool

Languages Databases Content

Management

Tools

JIRA

ALM / Quality Center

MS Visio

VersionOne

MS Project

MicroStrategy C

C++

.Net

Core Java

SQL Developer

DB2

Oracle

PMUWS

SharePoint

EDUCATION

Degree College / University Year(s) of Pursuance

Masters in Computer Application

(MCA)

West Bengal University of Technology (Kolkata,

India)

2007 – 2010

Bachelor in Computer Application

(BCA)

West Bengal University of Technology (Kolkata,

India)

2004 - 2007

PROJECT EXPERIENCE

Offering 2+ years of Experience in Data Analysis, Software Quality Assurance and IT Business Analysis

● Solid hands-on experience in Database / SQL / ETL testing

● Sound experience in Agile Testing involving scrum methodologies

● Detailed Domain knowledge on both Mortgage and BFS business products

● Extensive knowledge on MicroStrategy Analytics tool Primarily involved in Data / Requirement Analysis with Business Stakeholders, and Performing Database / ETL Testing for technology reports

● Expertise in converting Business Requirements to Functional / Technical Requirements Involved actively in Requirement Analysis, Test Planning, Test Execution, Defect Management and Test Reporting throughout various phases of testing

● Hands-on experience of System / Integration / Regression Test Execution

● Experience in working with Business Stakeholders / Managers on a daily basis

● Good Communicator and Team Player

Project #3

Project Title MicroStrategy Report Migration

Role Business / QA Data Analyst

Period Jul’ 2017 – Current

Team Size 16

Role and Responsibilities

Project Details

Business users always had difficulties to create / analyze various corporate analytics reports for day to day activities. The objective of this migration is to ensure that all required reports can be generated by all relevant users using the MicroStrategy tool.

There are around 300+ reports for 7 different areas including Call Centers, Credit Reporting, Foreclosures etc. Users / Stakeholders can create on demand reports once the migration is completed to the MicroStrategy Platform.

Project #2

Project Title Corporate Email & Call Campaign Dashboard Role Business / QA Data Analyst

Period Aug’ 2016 – Jun’ 2017

Team Size 8

Role and Responsibilities

Project Details

The objective of this project is to transform corporate data in a format so that call center users can be provided with lists of impacted and defaulted customers every morning. Call Center Users then connect with the existing customers to minimize business impacts.

All SSRS Reports are developed based on the business defined KPIs and Metrics. The Email and Call Campaign Dashboards will help business leaders to monitor and act on any potential business risks. Project #1

Project Title Anti-Money Laundering System

Role SQL QA Analyst

Period Nov’ 2010 – Mar’ 2011

o Analyze and Finalize product requirements with Business o Develop Functional / Technical Requirements (FSD) for Corporate Analytics Reports o Requirement Analysis

o Test Plan / Test Cases preparation

o MicroStrategy Report Validation

o Database Report Testing through SQL query

o Integration, System, Regression Test Execution, and Defect Management with JIRA o Test Status Reporting to Business Stakeholders

o Prepared various reports and metrics for Project Management o Develop Functional / Technical Requirements (FSD) for Corporate Analytics Reports o ETL Validation of SSRS Reports

o Database Report Testing through SQL query

o Integration, System, Regression Test Execution, and Defect Management with JIRA o Test Status Reporting to Business Stakeholders

Team Size 6

Role and Responsibilities

Project Details

Proactive Risk Manager (PRM) is a comprehensive fraud detection solution to help card issuers, merchants, acquirers and financial institutions combat fraud schemes. From strategic user-defined rules to powerful neural network technology using custom modelling techniques, Proactive Risk Manager provides the means to cost effectively reduce losses and limit an organization’s risk exposure. Debit and Credit Cards Fraud Detection compares the characteristics of each transaction with the recorded patterns of behavior for every cardholders. The models are based on each issuer’s card portfolio rather than industry data. This custom modelling technique enhances the system’s fraud-detection capabilities, which produces lower false positives and provides maximum protection of the “value at risk”. Users can periodically update custom models to adapt to emerging fraud patterns. Training Details

Training taken on Software Testing and SQL Database : Oct’ 2010 – Nov’ 2010 TRANING / CERTIFICATIONS

o Requirement Analysis

o Preparation of Test Plan

o Writing Test Cases

o Reviewing Test Cases

o Database Testing through SQL query

o Integration, System, Regression Test Execution, and Defect Management with ALM / Quality Center Completed a major project on “AIRLINES RESERVATION SYSTEM” using ASP.NET and SQL.SERVER from CMC Ltd

o

o Completed a minor project on “E-INTERACTION DATABASE SYSTEM” o Underwent a training from ARDENT COLLABORATION on Core Java



Contact this candidate