Summary
Overview
Work History
Skills
Websites
Certification
Educationandcertifications
Timeline
Generic

Chitra Jethanandani

Mississaugua,Canada

Summary

Results-driven professional with extensive experience in Insurance, Banking, and Telecom industries. Proven track record in data mining, data visualization, and advanced analytics using tools such as SQL, Tableau, Power BI, and advanced Excel. Demonstrated ability to lead product development, manage stakeholder relationships, and deliver high-quality analytical solutions. Certified Scrum Master and Microsoft Certified Data Analyst with strong data analytics skills.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Senior Product Owner

Yash Technology, Canada (Caterpillar)
03.2021 - Current
  • Defined and prioritized data product features to align with business objectives and stakeholder requirements.
  • Developed comprehensive data strategies, ensuring robust data governance and quality management.
  • Created detailed user stories, use cases, acceptance criteria, and conducted thorough product testing.
  • Managed data domain dependencies and effectively communicated project impacts to stakeholders.
  • Delivered high-quality data analytics solutions and presented insights to diverse audiences.
  • Facilitated joint application development (JAD) sessions to gather and define data conversion and ETL requirements.
  • Acted as the primary liaison between client departments and the information systems department.
  • Developed and maintained detailed business requirement documents (BRD) and user stories for data products.
  • Conducted risk analysis associated with data requirements and developed strategies to mitigate them.
  • Ensured the product backlog was refined and prioritized based on stakeholder feedback and business value.
  • Collaborated with cross-functional teams to ensure successful delivery of data products.
  • Monitored and reported on data product performance and user satisfaction.

Data Analyst/Software Associate

Capgemini, Canada (Client: RBC Insurance)
03.2017 - 02.2021
  • Developed SQL queries / scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
  • Wrote SQL queries using joins and sub-Queries to obtain data from multiple tables to spool into CSV format and provide extracts to business and users
  • Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI
  • Developed various dashboards to know the SLA not met processes, Task processing time etc
  • Created advanced Power BI dashboards for process improvement which resulted in reduction of SLA of various processes- improved KPI by 15%
  • Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights
  • Merge queries and append queries, remove columns and split columns, choosing required columns in the data
  • Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

CSR (Part-time)

CIBC Bank, Canada
09.2014 - 03.2017
  • Handled retail banking systems ensuring compliance to best risk management practices and ensuring full compliance to Anti Money laundering policies & procedures
  • Provide exceptional customer experience for clients by responding to client-initiated requests and by identifying and capitalizing on potential referral opportunities
  • Handled variety of client enquiries and carried out bouquet of banking transactions for clients with highest level of satisfaction
  • Extensive knowledge of applications like CBFE, COINS, ECIF to conduct various business transactions.

Assistant Manager- Strategy

Girnar Soft Ltd., India
06.2012 - 02.2013
  • Delivered the comparison charts reading trends in sales increase/decrease monthly, quarterly & yearly dashboards report and analyzed the finding and suggested improvements
  • Created visualization of management dashboards & Scorecards (KPI) for call center and website visits based on Google analytics
  • The dashboards helped the UI team to dynamically modify and improve customer facing websites
  • Performed data extraction and analysis by using SQL and provided insights on sales data which drove 30% increase in sales.

Assistant Manager – Operations

HDFC Bank Ltd., India
09.2010 - 05.2012
  • Handled day to day Retail and Corporate Branch Banking operations
  • Extensive banking system, risk management principles, policies, procedures, and product knowledge to better educate customers on product to achieve targets and positive outcomes for customers and the bank
  • Generation of various branch performance report like dormant account report, inward/outward clearing report, suspense account report etc
  • Imparting branch operations training & sales team using Power point tools.

Customer Service Executive - Operations

Reliance Life Insurance Company Ltd., India
10.2007 - 09.2010
  • Developed daily, weekly & monthly customized reports and dashboards on critical business parameters like Premium collection, Policy issuance, Target achievement and Funnel status reports using advance Excel and Crystal reports
  • Management SPOC for agents and sales team commission calculations for the branch
  • Helped management to analyze & understand team performance by using Pivot tables and present areas of opportunities
  • These scheduled reports and dashboards significantly improved the accessibility and transparency of sales data which facilitated data-oriented decision making
  • Spearheaded data-oriented marketing analysis to integrate marketing strategy resulting in a 35% sales growth for the branch
  • Handled customer queries and escalations and created opportunity for upsell of insurance products
  • Implemented 5S process framework for the branch.

MIS Executive- Service Assurance

Airtel Ltd., India
10.2006 - 10.2007
  • Mined customer data retrieved from CRM system and surveys to analyze purchasing decisions from various aspects
  • Extracting manipulating and cleaning raw data from various data sources (offline and online)
  • Acquired useful data using MS Access to convert large data of CVS format by using various filters
  • Created weekly and monthly reports& PowerPoint presentations for senior managers on performance evaluation and criteria.

Skills

  • Microsoft Certified Data Analyst Associate
  • Data Analysis
  • Power BI
  • Tableau
  • Alteryx
  • SQL
  • MS Excel
  • Google Analytics
  • Strategic Planning
  • JIRA
  • DevOps
  • Customer Relationship Management
  • RPA UI Path
  • Python for data analytics
  • Snowflake

Certification

  • Certified Scrum Master (CSM)
  • Microsoft Certified Data Analyst Associate 2021
  • Currently pursuing training on SAS from SAS organization
  • Completed RPA UI Path Training at Capgemini 2021
  • Practical AI and Machine Learning Certification from George Brown College - 2020
  • Data Analytics, Big Data & Predictive Analytics Certificate - Ryerson University 2017 (Completed one module on R programming & SQL Course)

Educationandcertifications

  • Investment Funds of Canada (IFIC) Certification 2017- Canada
  • Master of Business Administration- DAVV University, India 2014
  • Master of Commerce – DAVV University, India 2004
  • Bachelor of Commerce - DAVV University, India 2002

Timeline

Senior Product Owner

Yash Technology, Canada (Caterpillar)
03.2021 - Current

Data Analyst/Software Associate

Capgemini, Canada (Client: RBC Insurance)
03.2017 - 02.2021

CSR (Part-time)

CIBC Bank, Canada
09.2014 - 03.2017

Assistant Manager- Strategy

Girnar Soft Ltd., India
06.2012 - 02.2013

Assistant Manager – Operations

HDFC Bank Ltd., India
09.2010 - 05.2012

Customer Service Executive - Operations

Reliance Life Insurance Company Ltd., India
10.2007 - 09.2010

MIS Executive- Service Assurance

Airtel Ltd., India
10.2006 - 10.2007

Similar Profiles

CREATE PROFILE
Chitra Jethanandani