Smruti Rekha Batu
Senior Analyst
Bangalore,karnataka
Summary
Senior Analyst at HSBC Market Data with outstanding talents in client management, business operations,3, and leadership. Strong project management skills with adroitness in successfully managing multiple tasks at any given point. Over 3 years of background providing strategic analysis services to businesses.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Analyst
HSBC Market Data
11.2022 - Current
- Highly motivated and goal-driven Risk & Compliance Analyst having 3 + years of experience in the Market Data and Banking domain.
- Proven track record of analyzing and representing a massive volume of data to gain business insights using Advanced Excel, Google Sheets, Macros, Pivots, Tableau, and Power BI Desktop & Power Query.
- Collaborated with various departments within the organization to ensure effective implementation of risk mitigation strategies. Reviewed internal processes for identifying, measuring, monitoring, and reporting risks.
- Monitoring quality control, banking operations, and foreign asset control.
- Informed financial decisions by analyzing financial information to forecast business, industry, and economic factors.
- Documented all phases of test execution including results analysis and defect resolution.
- Collaborated with different departments to diagnose problems and devise solutions.
- Analyzed customer data to detect any unusual patterns or trends that may indicate possible money laundering activities.
- Completed annual examination of credit union policies and procedures to check compliance with applicable laws and regulations.
- Identified areas of non-compliance within an organization's anti-money laundering program and recommended corrective action plans accordingly.
Assistant Analyst
United Parcel Services (UPS)
08.2020 - 08.2022
- Prepared various BI dashboards in Tableau Desktop as well as Excel for month-end, quarter-end, and financial year closing business SLA reports
- Extract data from different tables as needed using SQL joins and sub-queries
- Help business by identifying business insights and forecasting the trends for future months using time series analysis using Excel
- Built optimum financial packages based on market conditions and clients' capital needs.
- Handled the complete accounting cycle, including opening, posting entries, and closing of accounts as well as Reconciliation & sorting of the invoices in the system
- Prepared outstanding invoice report, Hold and MAR Report, SLA Report, and Process Level Report for Revenue Service, applied credit funds, refund process, cleared payments
- Clearing and solving confidential accounts, suspense report accounts, validating Bank cheques & WIRE payments from AR Record, and preparing invoices and Credit Notes.
- Documented and reported on key risks and recommended mitigation strategies.
- Evaluated customer profiles against established criteria to identify potentially suspicious activities or transactions.
- Documented all activities related to case management services including contacts made, referrals given.
Education
Master of Business Administration - Finance and Marketing
Ravenshaw University
01.2020
Skills
- Quality check report, Anti-money laundering, transaction monitoring
- Interactive charts and dashboards using Advanced Excel and Power Pivot
- Extensive Dashboard Preparation using Power BI Desktop, transform Data using Power Query
- Expertise in accounts receivable accounts payable (AR), Account Payable(AP), Bill Processing, Reconciliation, Cash Application, Applying for Credit and Refunds, cash handling in Budgeting, Forecasting, Variance Analysis, General invoices, Internal Audits, and Corporate Finance
- Experience in preparing SLA Reports, AD-hoc reporting, declarations for clients, inventory management, and cash transaction reports
- Use SQL queries to extract Market data from databases for different accounts, and be responsible for cleaning, transforming, and organizing the data for further analysis
- Utilize Power BI and power query to create interactive and visually appealing dashboards and reports and effectively communicate insights and trends to stakeholders, making complex data accessible and actionable
- Conduct thorough market research to identify industry trends, competitor analysis, and consumer behavior pattern to help HSBC make informed decisions regarding pricing, product development, and market positioning
- Monitor key performance indicators (KPIs) and track market performance against HSBC's established goals and targets and highlighting any significant deviations or opportunities
Certification
- Advanced Excel in LinkedIn.
- LinkedIn Powerbi in Linkedin.
Timeline
Senior Analyst
HSBC Market Data
11.2022 - Current
Assistant Analyst
United Parcel Services (UPS)
08.2020 - 08.2022
Master of Business Administration - Finance and Marketing
Ravenshaw University
Similar Profiles
Arun YadavArun Yadav
Buisness ANALYST (Subject matter expert/Assistant Manager) at HSBC Securities Services, HSBC Electronic Data Processing India Pvt LtdBuisness ANALYST (Subject matter expert/Assistant Manager) at HSBC Securities Services, HSBC Electronic Data Processing India Pvt Ltd
SUBASH RAJ SSUBASH RAJ S
Global Services Executive-Trade Loan for UK&EU Ops at HSBC Data Processing CenterGlobal Services Executive-Trade Loan for UK&EU Ops at HSBC Data Processing Center
MAVIS ZHENGMAVIS ZHENG
Operation Manager at HSBC Electronic Data Processing (Foshan) Co.,LtdOperation Manager at HSBC Electronic Data Processing (Foshan) Co.,Ltd
SEENI MOHAMED MUDHASAR NSEENI MOHAMED MUDHASAR N
Skilled Backend Developer at TATA ELSXI LIMITEDSkilled Backend Developer at TATA ELSXI LIMITED
Tapas DasTapas Das
Machine Learning/AI Engineer at Intel Technology India Pvt. Ltd.Machine Learning/AI Engineer at Intel Technology India Pvt. Ltd.