Madhumitha Kannan

Experience

• 

  Bank Of America (TATA Consultancy Services)

  Oct 2012 - Mar 2015

  System Engineer

  ● Created several SQL queries with SQL, PL/SQL and MySQL to validate the data movement based on Transformation logic on Database Management Systems including Oracle, and DB2.● Optimized the performance of SQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes which in turn reduced the execution time by 15%.

• 

  DBS (Icon Business Solutions)

  Jun 2015 - Oct 2015

  Business Intelligence Consultant

  ● Designed and developed interactive dashboards for customer segmentation using Tableau. ● Presented findings to business stakeholders, which in turn increased sales by 25% andenabled better customer service.● Resolved high-priority changes and post-implementation bugs through review sessions with stakeholders.● Managed data volumes ranging from 20 to 50 million records and utilized Tableau's blending, LODs, and Table Calculation features to analyse and visualize the data effectively. Show less

• 

  THALES (Icon Business Solutions)

  Nov 2015 - Jan 2016

  Business Intelligence Consultant

  ● Successfully elicited business requirements by reviewing the existing data model with key stakeholders. Performed data pre-processing using SQL and Python.● Analysed and reported defective piece percentage, resulting in a 30% productivity increase. ● Generated complex reports with advanced mapping, month-to-week conversions, andconditional display of groups.● Created visualizations using Tableau from multiple data sources.● Developed an executive dashboard that improved customer experience and reduced Time- to-Access data by 70% for Aviation Parts Manufacturers. Show less