Hi, I’m
SRILINA DATTA
Data Analytics Professional
Bangalore
Summary
Analytics professional with 8+ years of experience in banking and financial data and market risk data. Deep technical knowledge with proficient use of technologies like SQL, Python, Microsoft SQL Server, Tableau, Oracle database and VBA. In-depth knowledge in process automation, analytical skills and process streamlining. Experienced in stakeholder management as well as project/process transitions and documentations.
Overview
8
years of professional experience
3
Languages
Work History
Wells Fargo, BANGALORE
Market Risk Analytics Associate
08.2019 - Current
Job overview
- Perform and lead various complex activities related to market risk data analysis, validation, reconciliations and automation.
- Perform data integrity validations using SQL & Python for 16 daily and two monthly reports. Cross functional in six more reports for the expanded team.
- Have automated eight manual reports using Python and four using VBA and two using Python & VBA combined that resulted in approx 410 hours of annual time savings, with increased efficiency and reduction in manual error. Handled four ad hoc automation projects in VBA for other teams so far.
- Develop dynamic dashboards for senior management; analyze key risk factors to help monitor market and counterparty risk.
- Provide cross functional training to team members for increased operational reliability.
- Working with onshore partners to support in market risk data migrations, system transitions, data-mapping, data lineage, data reconciliation and documentation in alignment to policy and governance.
- Developed and implemented reporting improvement strategies and promotes continuous improvement.
HSBCKolkata
Data Analytics - Subject Matter Expert
12.2014 - 07.2019
Job overview
- Perform Root Cause Analysis & support the same with documentation like presentation, dashboards, SOPs.
- Process automation - SQL and VBA
- Developing Oracle PL/SQL procedures, packages & Dynamic SQL.
- Performing reconciliation between systems to identify data redundancy.
- Working on DALs (Data Access Layer), i.e., changes in DATABASE (create, modify, alter etc) on the Tables, Views, Stored Procedures
- Using Oracle Analytical function and clause to analyze the output report. Performance tuning and normalization to improve execution time & accuracy.
- Structuring and streamlining projects & preparing dynamic MI reports
- Collaborate with Teams and onshore colleagues to achieve the overall goal for the project
Adapt Solutions Private LtdKolkata
Software Development & Maintenance - Junior Associate
10.2013 - 10.2014
Job overview
- Developing and maintaining software applications using J2EE technologies and database using PL/SQL. Proficient in Core MVC Framework and Hibernate.
- Developing MI Report in MS Excel.
- Uploading of files in the server using WinSCP and PuTTY. Importing bulk data using SQL Loader.
Education
West Bengal University of Technology
MCA from Computer Application
West Bengal University of Technology
BCA from Computer Application
Skills
Oracle SQL, PL/SQL
Python
VBA
Advanced ExcelMicrosoft SQL Server
Tableau
Process Automation
Analytical Skills
Documentations
JIRAAccomplishments
Wells Fargo:
- Received ‘Manager Spotlight’ award in Q1,2022
- Received ‘Shared Success’ for providing efficient solution in VBA
- Received appreciation from onshore partner on being diligent on market risk data
- Received ‘Shared Success’ from the onshore for constant support in regulatory project
- Received ‘Shared Success’ from the onshore for process improvement and automation in VBA of a monthly oversight report
HSBC:
- Awarded Star Performer of the Q3, 2017
- Received Spot awards for Stakeholder Management
- Service and Commitment Award from HSBC for successfully completing 3 years in the Organization
- Numerous onshore partner appreciations for BAU and ADHOC for delivering ahead of agreed timelines
Timeline
Market Risk Analytics Associate
Wells Fargo, BANGALORE
08.2019 - Current
Data Analytics - Subject Matter Expert
HSBC
12.2014 - 07.2019
Software Development & Maintenance - Junior Associate
Adapt Solutions Private Ltd
10.2013 - 10.2014
West Bengal University of Technology
MCA from Computer Application
06.2012
West Bengal University of Technology
BCA from Computer Application
06.2008