Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Sohini Banerjee

Data Analyst
Kolkata

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Talented Team Leader experienced and dedicated to enhancing employee satisfaction and business success. Diplomatic and friendly with proven commitment to employee training. Hardworking team player bringing necessary experience and knowledge to tackle any operational demand.

Experienced in directing activities of workgroups. Develops strategies, provides training, sets goals and obtains team feedback. Excellent interpersonal and communication skills. Big picture focus with excellence in communicating goals and vision to succeed. Problem solver, networker and consensus builder.

Builds positive rapport, inspire trust and guide teams toward achievement of organizational goals. Strong facilitator adept at working cross-departmentally with co-management and top-level leadership. Excellent trainer and mentor.

Overview

11
11
years of professional experience
18
18
years of post-secondary education

Work History

Team Leader

Capgemini India
Kolkata
02.2022 - Current
  • Creating financial reports for month end closing and sharing with Finance Controller.
  • Prepare revenue forecasts in accordance with financial analysts and account manager.
  • Review confirmed deals and signed SOWS for new deals.
  • Confirmed confidential budget reports remained up-to-date for manager.
  • Worked with colleagues to create automated reports using Power Query.
  • Participated in cross-functional team-building activities.
  • Implemented new working processes to deliver multiple improvements.

Senior Executive

Tata Cunsultancy Services
Kolkata
11.2011 - 02.2022

Liquidity Monitoring

  • Preparation of reports containing FX and Libor rates and providing the same to clients.
    • Analysis and reporting of overdrawn accounts and assisting in getting overdrafts funded helping in minimalizing bad debts
    • Preparation of reports containing deposits on client level basis, inferring the Top 10 Gainers and Decliners through analysis
    of the daily deposits and providing a summary to the client enabling them to ascertain premium customers, and find out
    problem areas in regards to Products and Sectors with a comparatively poor performance.
    • Presentation of reports to clients with interests accrued and paid on an account level basis for each clients, enabling them to
    differentiate between high and low interest bearing accounts.
    • Preparation of Notional pooling report differentiating between accounts having Single Currency Pooling and Multiple
    Currency Pooling and providing a summary based on account balance for each type.
    • Creating a summary of accounts bearing overdrafts on high FRR level and providing summary to clients for such accounts
    which are overdrawn and the amount by which the accounts are overdrawn enabling the clients to follow up and retrieve the
    overdrawn amount.
    • Providing month end report to client bearing state of accounts, balances overdrawn, back values cleared and accounts
    settled.
    • Following up on Overdrawn clients, managing client facility ratings

International Trade

  • Discounting of Loans on maturity based on treasury rate, booking of loans uploaded on customer end in collaboration
    with treasury.
    • Processing MT 202 and MT 103 swift messages using TRIMS and SAM Reconciliation of accounts with Mirror Accounts
    on a daily basis.
    • Signature Verification and KYC of customers using OFAC guidelines.
    • Reconciliation of Nostro Accounts.
    • Opening Accounts on client requests.
    • Balancing GL accounts
    • Preparing Credit Line report for end customers and providing to clients.
    • Collaborating with Controls and Analytics team regarding Nostro mismatch.
    • Holding Monthly client meetings for EOM performance progress on end customer level.


Education

BBA - Human Resource

Calcutta University
Kolkata
08.2008 - 08.2011

High School Diploma -

South Point High School
Kolkat
04.1993 - 03.2008

Skills

    Excel

undefined

Accomplishments

    • Certification of Tableau
    • Certification of SQL
    • Certification of Machine Learning with Python
    • Certification of Advanced Excel
    • Certification on Power BI beginner
    • Certification on Tableau
    • Certification on Python
    • Academy of Trade Finance Level 1 Certification
    • Academy of Trade Finance Level 2 Certification

Timeline

Team Leader

Capgemini India
02.2022 - Current

Senior Executive

Tata Cunsultancy Services
11.2011 - 02.2022

BBA - Human Resource

Calcutta University
08.2008 - 08.2011

High School Diploma -

South Point High School
04.1993 - 03.2008
Sohini BanerjeeData Analyst