Advance Excel (Power Query)
Sunil Kumar B N
Bengaluru
Summary
Results-driven banking professional with over 11 years of experience at leading companies. Currently an Associate at Deutsche Bank, leading data analytics initiatives in transaction monitoring and data control. Demonstrates strong analytical and teamwork skills with proven ability to quickly adapt to new environment. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Associate
Deutsche India Private Limited
2022.04 - Current
- Led data analytics initiatives in transaction monitoring and data control by identifying false positives and improving auto-match rules.
- Utilized advanced Excel (complex formulas, pivot tables, data visualization) to generate detailed reports and insights for senior management.
- Streamlined operations through data analyses and automation using Power Automate, reducing manual touch points and improving workflow efficiency by over 80%.
- Monitored and controlled data quality across multiple systems, ensuring data accuracy, consistency, and compliance with internal controls.
- Collaborated with cross-functional teams (BFA, Tech) to implement data governance frameworks and mitigate data risks.
- Provided actionable insights and recommendations based on data analysis, driving informed decision-making and strategic initiatives in TMDC operations.
- Managed data migrations ensuring seamless transitions and minimal impact on day-to-day business processes.
- Conducted regular audits and reviews of data handling procedures, ensuring alignment with policies and regulations.
Team Leader
JP Morgan Chase & Co
2019.02 - 2022.04
- Automation initiatives within Global Custody Operation to minimize manual effort in payment processing and reporting
- Designed workflows to automate repetitive tasks in derivative operations using tools such as Alteryx and Tableau (Reporting).
- Analyzed historical data to identify trends and enhance decision-making processes.
- Collaborated with cross-functional teams to align client business requirements with product capabilities, ensuring customer needs were met.
- Conducted in-depth analysis of customer behavior patterns to inform strategic improvements and product offerings.
- Created and maintained Management Information Systems (MIS) and interactive dashboards, delivering real-time insights and key performance indicators (KPIs) to stakeholders.
Senior Analyst
Deutsche India Private Limited
2013.06 - 2019.01
- Sound knowledge on SWIFT, ISO 20022 majorly supporting cash message types.
- Generating MIS reports and effectively tracked the STP rate on monthly basis.
- Adept in managing and leading teams for running successful process. Experience of developing procedures and service standards for business excellence.
- Efficiently tracked and analyzed the errors and type of errors made by the team by preparing incident report on errors made, subsequently take preventive action for the same.
- Collaborate with IT teams to optimize promotion of products and services.
- Possess excellent interpersonal, communication and organizational skills with proven abilities in training & development, customer relationship management and planning.
- Conduct Cross Team Trainings and process induction to new joiners.
- Historical Data extraction of swift failure messages and fix the issue with help CSO and technical team.
Analyst
Fidelity Investments
2011.12 - 2012.12
- Supported Defined Contribution Process (401k)
- Maintained 100% accuracy
Education
Bachelor of Commerce - Finance
Mangalore University (MGM College)
Udupi03.2011
Skills
- Data Analysis (Descriptive and Predictive)
- Strategic Thinking
- Transition/Migration Management
- Cross-Functional Teamwork
- Management Support
- Event Coordination
- Interactive Dashboard
- Process Handling
Accomplishments
- Team Supervision: Supervised a team of 8 staff members
- Data Analysis for Enhancement: Collaborated with BFA to improve auto-match rules, reducing false positives by 80% in 2 regions (US &DE).
- Quality Assurance Team Setup: Established a quality assurance team for TMDC, implementing a new framework and testing criteria that identified 60k impacted transactions, successfully resolved with our tech partner in the first year.
- Streamlined Approval Activities: Proposed to management an electronic repair payment process for transactions under EUR 1 million using a two-eye principle, based on 6 months of data analysis, which could reduce FTEs by 4 for Germany Electronic Payments Team.
- MT202 POC Collaboration: Partnered with the CSO Team on a tap-based solution, reducing touchpoints from 150 to 15.
- Power Automate Implementation: Reduced manual touchpoints in TMDC operations from 50+ to zero through automation for work allocation.
- Transition : Led the transition from Abu Dhabi to Bangalore, establishing Key Operating Procedures (KOPs) in 2015.
Certification
Data Analytics Certification, Jigsaw Academy - 1 Year
Software
Power Automate
QlikView
R (Beginner)
SQL(Beginner)
Alteryx
Tableau
JIRA
Confluence
Core Competencies
- Swift payments -Cash Operations
- ISO 20022
- Transaction Monitoring and Data Control (CB)
- Reconciliation
- Investigation
Timeline
Associate
Deutsche India Private Limited
2022.04 - Current
Team Leader
JP Morgan Chase & Co
2019.02 - 2022.04
Senior Analyst
Deutsche India Private Limited
2013.06 - 2019.01
Analyst
Fidelity Investments
2011.12 - 2012.12
Bachelor of Commerce - Finance
Mangalore University (MGM College)
Data Analytics Certification, Jigsaw Academy - 1 Year
Similar Profiles
Subhashini NarayanamoorthySubhashini Narayanamoorthy
Assistant Vice President at Deutsche India Private LimitedAssistant Vice President at Deutsche India Private Limited
Pavan KasireddyPavan Kasireddy
Associate (Quality Control-Checker role) at Deutsche India Private LimitedAssociate (Quality Control-Checker role) at Deutsche India Private Limited
Avani SharmaAvani Sharma
Assistant Vice President at Deutsche India Private LimitedAssistant Vice President at Deutsche India Private Limited