Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
Additional Information
Generic
Somadittya Choudhury

Somadittya Choudhury

Business Data Analyst
Thane, Maharashtra

Summary

Forward-thinking Business Data Analyst equipped with advanced operational and functional knowledge of Reference Data Systems.

Offering 12 years of experience versed in Investment Banking Client/Trade Lifecycle Management Area for Client Onboarding, Product/Data Legal Maintenance, Accounts, Instrument Management and SSI’s.

Detail-focused Data Analyst with knowledge in ETL, Automation and data warehousing, process validation and business needs analysis.

Proven to understand customer requirements and translate into actionable project plans to forecast business trends as a Reference Data Analyst.

Proficiencies include SQL skills with Knowledge of Investment Banking Products Fenergo, Omgeo, Bloomberg, Broadridge INA, Datum, CACE.

Overview

12
12
years of professional experience
4
4
Certificates

Work History

Senior Specialist

LTIMindtree
Mumbai
07.2015 - Current
  • Role - Business Data Analyst
  • Client - Nomura
  • Tools Used - JIRA, Eclipse, HP ALM, Rapid SQL, VersionOne, SVN, Git, Jenkins, Selenium, Angular, Camunda.
  • Products - Fenergo, OMGEO, Bloomberg, Avox, Alacra.
  • Projects - RDM Applications (EVE, NEAM, CDAP)
    FENERGO, Bloomberg Integration & EVE implementation are one of the most ambitious projects of Nomura. NEAM & EVE are global Client Onboarding tool (CLEM) used to onboard Issuers, Guarantors Clients with the Accounts & SSI. Regulatory related to BCBS239, Dodd Frank, FATCA are managed using the FENERGO Integration with NEAM/EVE through different Approval routing process within the Compliance, Tax, and Legal & Credit. STP of data in Reference Data Management Systems and end user consumes. Front end of the Application is in Angular, Java Business workflow- - TIBCO I-process, Camunda & DB – Sybase/MS SQL.
    • Roles & Responsibilities
    - Developed and improved new user Stories with integrated reporting and analysis capabilities.
    - Articulated risks and issues to communicate concerns to various levels of managements and business in requirement gatherings project scope and gap analysis.
    - Analysis of Business key aspects for evaluating factors driving results and summarized into functional and Business specific User stories.
    - Executed analysis of risks and identified risk mitigation strategies.
    - Improved business direction by prioritizing customers and implementing changes based on collected feedback.
    - Utilized data visualization tools like Alteryx to effectively communicate business insights.
    - Transaction Analysis to build logical business intelligence model for real-time reporting needs.
    - Surveyed clients to ascertain requirements and expectations for product.
    - Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
    - Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
    - Creation of test plans, test cases based on business requirements, functional and technical specifications, development standards for assigned projects/applications
    - Mentor team both functionally and in Automation.
    - Track issues and work with project managers and development team to resolve issues.
    - Develop and maintain quality metrics, pre and postproduction.
    - Ensure deliverables as per agreed plans and Enforce adherence to QA best practices, status, and metric reporting

Consultant

CapGemini
Mumbai
08.2014 - 06.2015
  • Role - Functional/ETL Testing
  • Tools Used - QC, Oracle, AS400
  • Client - Farmers Insurance (Zurich International)
    Personal Lines Application enables Insurance Agents to create new policies and manage existing policies. All Policy administration tasks (premium Payment, client information changes, Policy Renew, Term Rewrite, policy cancellation, Policy Reinstatement etc.) can be effectively carried out on PLA.
  • Roles & Responsibilities
    - Creation of test scenarios and test objectives in ALM 11.0
    - Detailed study of SRS document
    - Peer review of test cases designed by members of team.
    - Execution of Test Cases and updating results in ALM.

Software Engineer

Accenture
Mumbai
09.2011 - 06.2014
  • Role - Automation/ETL Testing
  • Client - Nomura
  • Tools Used - JIRA, Eclipse, HP ALM, Rapid SQL, VersionOne, SVN, Git, Jenkins, Selenium.
  • Project - Nomura – NEAM/RDM Applications.
    NEAM is global Client Onboarding tool (CLEM) which is used to onboard Issuers, Guarantors Clients with Accounts & SSI. PDP application is to convert all feeds from all external vendors like Bloomberg, Routers and define instrument as per market pricing using various derivation logics.
  • Roles & Responsibilities
    - Identifying and raising Defects and tracking them to closure Requirement analysis of Reference Data Management (KYC, Products, Instruments and Books) Wealth Management and Portfolio Allocation.
    - Estimation of requirements in Sprint Planning Meetings and provide Sprint Retrospect's in VersionOne.
    - Run Automation scripts and modify scripts for new objects and flows implemented in various releases in HP Quick Test Professional 10.0 and Selenium Web driver 2.0.
    - Create and run SQL scripts to validate Product and Instrument details across various Database tables in dB Artesian
    - Highlighting project risks using Risk Based Testing (RBT) for various releases.

Associate Software Engineer

Accenture
Mumbai
05.2010 - 08.2011
  • Role - ETL Testing
  • Client - Best Buy Corporation
  • Project - Breeze, Connect
  • Tools - Informatica Power Center, Oracle, SQL Developer, QC, MS-SQL, IBM Rational Query Manager RQM 3.0,IBM Rational Clear Quest, IBM Rational Requisite Pro.
  • Project Description

Best Buy is among the leading electronic retailers in USA and Canada marketplace. Project is all about testing BBY's customer rewards point portal. Current project responsibility is to do the functional testing of the application

  • Roles & Responsibilities

- Coordinating with end clients

- Test Planning, Writing/updating, and executing test scripts

- Data validation and Creating test scenario for Ad-hoc testing

- Reporting bugs in QC and following it until it is resolved and closed

- Prepared Test plan and Test Scenarios

- Conducting daily offshore and onsite meetings for issues and concerns of modules

Education

Bachelor of Engineering - Computer Engineering

University of Mumbai, SIES Graduate School Of Tech
Navi Mumbai
2005.08 - 2009.08

Skills

    SQL

undefined

Certification

NCFM - Financial Markets

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Alteryx Core Certified

09-2022

Senior Specialist

LTIMindtree
07.2015 - Current

Consultant

CapGemini
08.2014 - 06.2015

Accenture - Capital Markets

06-2014

NCFM - Equity Derivatives

07-2013

NCFM - Financial Markets

03-2013

Software Engineer

Accenture
09.2011 - 06.2014

Associate Software Engineer

Accenture
05.2010 - 08.2011

Bachelor of Engineering - Computer Engineering

University of Mumbai, SIES Graduate School Of Tech
2005.08 - 2009.08

Additional Information

  • Passport: W3197454
  • Nationality: Indian
  • Date of Birth: 17th Feb 1987
  • Address: B2-204, Laxmi Residency, Khardigao, Diva Shil Road, Diva East, Thane -400612
  • Languages known: English, Bengali, Hindi and Marathi.
  • Marital Status: Married
Somadittya ChoudhuryBusiness Data Analyst