Sohanjit Mukherjee

Sohanjit Mukherjee Data Analyst - |-| linkedin.com/in/sohanjit-mukherjee-2a867a120 Whitby, Ontario CANADA (Open to Relocation) Experienced finance professional passionate about using technology for optimal utilization of human resources & improving Turn Around Time that drive high performance. Currently seeking data analyst opportunities in banking, e-commerce & fintech industry. Technical Skills LANGUAGES: Python (Pandas, Seaborn, Matplotlib, Numpy), SQL ANALYTICS/DATA VISUALIZATION: Microsoft Excel, Tableau, Power BI STATISTICAL ANALYSIS: Descriptive & Inferential Statistics, Regression Modeling, Hypothesis Testing Projects Tableau: Food Inflation Analysis of Pakistan A series of interactive Tableau dashboards focused on examining price trends of major commodities between- & analysing factors affecting them. SQL & Tableau: American Energy Market Regulator Analysis of hypothetical outage data from several participants to determine which companies have the most outages, the most average MW of lost energy due to those outages, and longest average outage duration. Creates a ranking system that considers all three metrics. Professional Experience Senior Analyst, Entitlements Jul ‘22 – Present Capital Markets Operations CIBC • Perform transaction due diligence of Dividend Payments for Canadian Depository for Securities Limited (CDS) & The Depository Trust and Clearing Company (DTCC). • Processing & validation of Elective Dividend Service (EDS) Payments for The Depository Trust and Clearing Company (DTCC). • • • Prime Accounts adjustment & Stock Loan payments for CDS & DTCC securities. Trial balance reconciliation for CDS & DTCC securities. Supervision of service request received from internal & external clients. Assistant Manager Canada Operations ICICI Bank • • • • Verification & maintenance of documents & Settlement of dues related to deceased clients. Processing & monitoring of customer service request for Business & Retail clients. Processing & maintenance of Line of Credit provided to Business & Retail clients. Analysing & reporting incidents related to Fraud & Ops Risk. Jan ‘18 – Jul ‘22 • • • • Processing & maintenance of registered accounts (TFSA, RRSP). • • • • • Monthly preparation of regulatory reports for Compliance, Finance & Product Team. • Annual tax related activities (checking & amendment of T5, NR4, contribution receipt & resolving queries related to CRA). • Monitoring income leakages. Process retail & corporate account opening applications. Follow-up & closure of irregular accounts for Business & Retail clients. Process credit card related requests (reconciliation of payments, recovery of funds from delinquent clients, waiver of minimum amount due, reversal of interest charges). Monitor and escalate reconciliation of Nostro and Office Accounts. Bill assessment & payment to vendors. Provide timely and effective servicing of mortgages from the advance of funds to the payoff of the loan. Process customer complaints related to digital banking (online banking, mobile banking, Interac & ABM transactions). May ‘09 – Dec ‘17 Manager State Bank of India • Showcased excellence in administering complete branch operations with key focus on bottom line profitability by achieving the assigned revenue targets and ensuring optimal utilization of available resources & cost control. • • Involved in the process of planning, organizing, controlling and evaluation of branch operations. • Proficiency in managing branch operations and gathering sound understanding of banking system, services and products. • Drove vision with demonstrated success in controlling & monitoring branch resources such as operating staff as well as the relationship manager channel for business acquisition and achievement of branch budgets. • • Expertise in ensuring quality and service norms to achieve customer satisfaction and business retention. • • Resourceful in obtaining profitable customers by providing products & services as per their needs. • Managed a portfolio of around CAD 35 million encompassing house-building loans, car loans, personal loans & other miscellaneous customer tailored products. • • Managed loan appraisal (personal advances) and credit rating as per internal rating standards • Maintained rapport with all external / internal clients at all levels and ensuring maximum client retention & achievement of revenue goals. Steered efforts in building and maintaining cordial and effective relationships with customers to increase customer base by 20% Sound knowledge of NPA Management in line with the organizational and regulatory guidelines to achieve desired goals. Orchestrated reduction in marketing costs and enhanced customer satisfaction which yielded optimization of lifetime value. Monitored documentation of records of loan and took necessary actions to prevent them from becoming NonPerforming Assets. Education Data Analytics Career Track, Springboard Bachelor of Arts (English), Symbiosis College of Arts & Commerce, India June 2023 June 2008