Supriya Kukde
Senior Analyst
Cologne
Summary
6+ years of experience in Banking Operations with Core expertise in Banking Daily Enrichment Activities involving reconciliation of Banking data across India, collecting of Bulk Collection and Foreign Currency cheques, Handling of Bank Clients, providing and discussing reports with customers on email. Customers query resolving . Around 2 years of experience in Microsoft Power BI. Trained in Power BI reporting tool with Intellipat Bengraluru,India.
Overview
14
14
years of professional experience
4
4
Languages
Work History
Maternity + Childcare leave
12.2020 - 03.2024
Senior Officer (Analyst)
YES Bank LTD
05.2019 - 12.2020
- Expertise in Reporting using Microsoft Power BI
- Worked extensively in creating reports in power BI desktop with hands on experience on creating more than 100+ reports using DAX for complex data analytics calculation and deployed on Power BI Service
- Have good technical knowledge on power M query, DAX, BW connectors, Gateways, power BI service, RLS
- Knowledge of BI report development SQL queries, Data modeling and building report Visualization, having knowledge in SSRS, SSAS, SQL SERVER
- Have knowledge about develop ETL and data base solutions
- Have sound knowledge on Dataflows
- Created reports with parameters to solve the huge data refresh issues
- Monitoring the status of the Inward clearing files, inward status in ECPIX-NPCI site
- Authorization of MICR updating process in CTS application
- Tally the Inward clearing and Sub member with NPCI report
- Authorization of Date and Amount proofing of inward clearing cheques
- Downloading of unloadable files from CTS express clear application and upload in FLEXCUBE, DWMS, CMS DISBURSEMENT system
- Checking technical part of cheques in Signature Verification System (SVS)
- I.e
- Date, Amount in word and figure, Signature verification, endorsement and payee name
- Marking of inward return cheques in express clear and NPCI (National Payments Corporation of India) site
- Continuously Monitoring the Bundle stage & lodging the Instruments before the Cut off time
- Responsible for the Outward presentation instruments lodged completely at NPCI Site
- Creation of GEFU file for outward uploading
- Downloading NPCI (National Payments Corporation of India) reports
- Continuously follow up with our technology team regarding any issue/Slowness of system
- Solving the branches queries
- Sending MIS of team member to Senior.
Senior Associate Officer
Tata Consultancy Services, Cash Management Service
08.2014 - 03.2018
- Worked in Power BI Desktop, connected excel based data sources and SAP data sources for creating Visualizations for centralize cheque as per client requirement
- By using power bi tool, we created dashboard for all product i.e
- (CCHK, CSPD, CITI CHQ)
- Daily enrichment activity (Upload file in the system from vendors after processing across India)
- Preparing Upload file for the bulk data by using Macros
- Coordination between Branch offices and our Coordinators located all over India
- Sharing the Client reports with the client and make sure various internal that all deliverables
- Taking care of Customer Queries related to Cash Collections Deposit and Enrichment
- Verifying the file and processing the same by location wise and tallying by MIS received from branch clearing
- Keeping good communication with all the senior level persons both in branch and vendor's HO
- Management of Network Department for Cheques pickup process for last 3 years
- Tracking the deliverables & ensuring smooth pickups & returns of instruments (checks and demand drafts) for all customer across country
- Uploading of images received from hubs on the system
- Maintenance of location codes on the system for direct clearance
- Attending to various queries arising from internal & external sources & providing favorable solutions & feedback for the same
- Ensuring timely correspondent bank dry runs are conducted to check if bank has received instructions from their head office to start CMS activities
- Ensuring all schedules containing instruments are dispatched on timely basis to locations
- Tracking of schedules been received and deposited by coordinators on time
- Resolving issue faced by coordinators and bank if any with respect to schedules receiving for depositions.
Branch Executive
RAO IIT ACEDAMY
03.2012 - 08.2013
- Branch management
- Looking after the Administration of the Institute
- Scheduling the lectures, Coordination with Professors for lectures
- Student counseling regarding admissions with their Parents
- Students Data management (up to 500 students) etc.
Reconciliation Coordinator
SRS Consultants (Client: HSBC Bank)
08.2010 - 12.2011
- Processing of Bulk Collection Cheques for Corporate Customers: Efficiently Handling Bulk Collection Desk
- Presenting PDC's in Outward Clearing in all 23 Branch Location 63 Corp
- Bank Location
- Assisting in MIS preparation & Sending Day-to-Day MIS to Corporate Customer
- Providing Daily Reconciliation Reports of all Branch Location & Corp
- Bank to Head office executive of collection department and Reconciliation of Nostro Accounts and Branch Suspense accounts
- Processing of Foreign Currency Cheques under Cash-Letter Department: Cash Letter- Also handling the Cash-Letter department for GBP Currency (Great Britain Pound) and CAD (Canadian Dollar) for Collection to HSBC London & Canada and tracking
- Rate cheque- These are foreign currency cheques payable at a bank branch in India
- Same was sent to the drawee bank for collection with disposal instructions i.e
- Whether the funds are to be remitted in INR or remitted to our Nostro account in FCY.
Education
Bachelor of Science - Physics, Mathematics, Chemistry
Higher Secondary School Certification - undefined
Secondary School Certificate - undefined
Skills
Accomplishments
- 19 Dec 2016: Star Performance Award in TCS, Mumbai
- 21 Nov 2016: Star Performance Award in TCS, Mumbai
- 16 June 2016: Star Performance Award in TCS, Mumbai
- 19 May 2016: Star Performance Award in TCS, Mumbai
- Service and commitment award for 3 years in TCS, Mumbai
Power Bi - Training
Trained in Power BI reporting tool, created dashboards using DAX. Good understanding of Power BI Data Models, Hierarchy creation. Worked in Power BI Desktop, connected excel based data sources and SAP data sources for creation Visualizations. Expertise in Reporting using Microsoft Power BI. Worked extensively in creating reports in power BI desktop with hands on experience on creating more than 100 plus reports using DAX for complex data analytics calculation and deployed on Power BI Service.
Other Notes
I have Residential permit in Germany too.
Timeline
Maternity + Childcare leave
12.2020 - 03.2024
Senior Officer (Analyst)
YES Bank LTD
05.2019 - 12.2020
Senior Associate Officer
Tata Consultancy Services, Cash Management Service
08.2014 - 03.2018
Branch Executive
RAO IIT ACEDAMY
03.2012 - 08.2013
Reconciliation Coordinator
SRS Consultants (Client: HSBC Bank)
08.2010 - 12.2011
Bachelor of Science - Physics, Mathematics, Chemistry
Higher Secondary School Certification - undefined
Secondary School Certificate - undefined
Similar Profiles
Mohanad Abdel-RahmanMohanad Abdel-Rahman
Academic Peer Tutor at NAAcademic Peer Tutor at NA
Shlomo JaffeShlomo Jaffe
Highschool Math Tutor at NAHighschool Math Tutor at NA
CLÉLIA CROZE-LABBECLÉLIA CROZE-LABBE
Baby sitter at NABaby sitter at NA
Jaylen Tindale-SeymourJaylen Tindale-Seymour
Property Maintenance at NAProperty Maintenance at NA
Joerg LehnertJoerg Lehnert
Audio Visual Conference Engineer at Qvest GmbHAudio Visual Conference Engineer at Qvest GmbH