Asesh Das
Kitchener,ON
Summary
A result-driven data professional with wide experience in data engineering, analytics, reporting & visualization, data stewardship, business process simplification and automation that contributes to business strategies and initiatives for market growth and better client experience; an innovative thinker, analytical problem solver, multitasking team player, able to work in fast-paced environments, completing deliverables on time.
Overview
14
14
years of professional experience
Work History
Senior Manager – Strategic Data & Analytics
Canadian Private Banking, RBC
10.2020 - Current
- Provide actionable insights to support strategic decisions/business cases through deep dive & leveraging advanced analytics.
- Develop and maintain Private Banking critical reports, dashboards, statistical trends & analysis to support the Private Banking business.
- Govern and maintain PB data and ensure data quality, integrity and security and its responsible usages.
- Support cross-functional teams with various data analytics & Dashboard reporting.
- Coach and train the team members in SAS and SQL scripting, debug the code, and maintain a high level of coding hygiene and data validation
- Few major accomplishments:
- Data Hub: Have designed, built & implemented DH architecture for PB and established a single source of data in Data Lab, resulting speedy & accurate delivery of dashboard, reports & analytics.
- SAS Macro Library: Have built a generalized SAS macro library for ease of coding & data consistency which is being used by all the team members
- MCL: Have developed a robust process to maintain PB universe/MCL (Master Client List)
- Rebate Engine: As part of re-pricing strategy, have designed the framework and built, and implemented a process to prepare the list of Households eligible for rebate
- TRB (Total Relationship Balance): As part of re-pricing strategy, have designed the Framework and built, and implemented a process to prepare to identify the balance (from cross functional entities) to adjudicate Household for rebate.
- Mortgage Overview Dashboard: Have designed & built a comprehensive Mortgage (Upcoming Renewal & Renewed) Dashboard for Leaders
- Non-Resident Household/Client Dashboard: Have designed & built the dashboard to present the profile & financials for NR households & clients and QoQ comparative analysis.
- COB (Client On-Boarding) ETL: Have built a process to extract data from EDL to SAS.
- HSBC Integration: Successfully integrated HSBC households into PB householding universe and provided various analytics on financials growth perspective, profile mismatch for corrective action and the post LD1 attrition scenario by client/product, etc.
Campaign Execution Manager (HEF)
Client Interaction & Decision Management (CIDM), RBC
07.2013 - 10.2020
- Supported HEF business to grow through data analytics and process simplification
- Designed, developed & deployed Automated Mortgage Retention Client Treatment Plan (CTP) program, contributed achieving monthly 92% mortgage retention rate; also played an important role in designing & preparing MMD (Maturing Mortgage Dashboard) backend database
- Designed, developed & deployed Automated Mortgage Fulfillment process for client’s incentive, achieving 35% YoY increased in inbound lead volume, 38% increased on FTHB funded volume), better client experience, OMNI reporting and provided info to MS for transparency & facilitates additional positive engagement with client.
- Designed & built MWP Personalized Mortgage Welcome Video program which received the GOLD award in 2017 from CMA (Canadian Marketing Association)
- Designed, developed & deployed Automated process for a mini DATAMART to capture all new mortgages to support & facilitate quick turnaround of fulfillment and marketing campaigns.
- Provided deep dive analysis on client behavior & visualization on campaign progress reports.
- Streamlined decision-making processes to enhance client interactions and operational efficiency.
- Trained colleagues to ensure consistency in executing decision management protocols.
- Analyzed client feedback data to identify areas for improvement and drive strategic initiatives.
Consultant
Client Interaction & Decision Management (CIDM), RBC
07.2011 - 06.2013
- Supported HEF & Personal Lending business in Campaign design & Execution; Revamped the RCL campaign, Designed, developed & deployed Indirect Lending Campaign (IL2 for Hyundai), etc.
- Provided deep dive analysis on client behavior & visualization on campaign progress reports.
Education
MBA - Digital Technologies Management
Royal Roads University
BC, CanadaBusiness Analyst Master’s Certificate -
Schulich School of Business, York University
Toronto, ONSkills
- Teradata, Tableau, SAS EG, SQL Server, Snowflake Snowsight, Python, JSON, SAP Information Design Tool & Web Intelligent, Hummingbird, Webfocus, MS Office, etc
- Strategic planning
- Troubleshooting and problem resolution
- Data-driven decision making
- Documentation and reporting
- Data analytics
- Database development
- Business analysis and reporting
- Performance tracking and evaluation
- Analytical thinking
Languages
English
Full Professional
Timeline
Senior Manager – Strategic Data & Analytics
Canadian Private Banking, RBC
10.2020 - Current
Campaign Execution Manager (HEF)
Client Interaction & Decision Management (CIDM), RBC
07.2013 - 10.2020
Consultant
Client Interaction & Decision Management (CIDM), RBC
07.2011 - 06.2013
MBA - Digital Technologies Management
Royal Roads University
Business Analyst Master’s Certificate -
Schulich School of Business, York University
Employee Recognition Awards
RBC - RBC GOLD Award
BELL – BELL BRAVO Award, BELL VIP (Value, Innovation & Performance) Award