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