Manager Analytics
Air Canada
Total years of experience :16 years, 4 Months
• Responsible for the development and the management of data processes relevant to taxes, over very large volume of complex sensitive data from various data sources by using different analytical tools
• Lead and drive implementation of initiatives by managing a team to ensure that all data generated by business systems throughout the organization meet the requirements of the various tax laws and regulations
• Provide guidance & direction from a tax technical standpoint, as well as liaise with other system resources, to ensure timely production of high quality exception dashboards.
• Leading a Tax and Sale team’s data initiatives of migration of data from Teradata to new database system.
• Improved data models by using Lean Six Sigma approach which resulted in 70% efficiency improvement in data extraction and producing models, overall improvement of $1.8 million in 4th quarter of 2018.
• Extracted, mined and analyzed customer level data, identify trends, issues and opportunities to improve online sales, call effectiveness & efficiency, and overall customer experience using SAS and R.
• Identified $2 million opportunities by integrating historical Phone Channels data into centralized data repository for archiving and customer 360° view across TD Bank.
• Supported Digital Channels initiatives - data gathering, analysis, and providing monthly trend forecast and plan information.
• Successfully implemented K means clustering model using R to identify digital customers engaged with North America Phone channel.
• Data Stewards for data generated by Cisco routers to maintain data quality and implement data governance.
• Identified trends in digital and phone channels data, drawing conclusions and making actionable recommendations to key stakeholders within the organization using various data models
• Supported Speech Analysts for speech analytical study to identify digital products usage and demographics of users and non-users of digital products.
• Data quality check and setting standards for metadata
• Implemented data quality standards across Wealth management division
• Conducted resource study on vendors to perform data quality in databases
• Liaised with different IT teams to implement data quality and management tools
Develop and drive meaningful reporting and analytics; working closely with operations, marketing, business analysts, and data developers for root cause analysis and data analysis.
•Proactively identify issues in “SAP” and “Amdocs” billing system before they adversely impact the multimillion dollar bill cycle management, through data analysis using SQL and R.
•Recognize, verify, evaluate and validate hidden patterns in customer data. Understand changes to network and billing systems and impact on revenues.
•Analyze data from business functions and created statistical review reports for executive presentations. Various other ad hoc analyses and special projects as needed.
•Mapped process flow for marketing initiative and bill cycle management to standardize work across team members and provide support to team members on different databases and billing systems
•Partner with campaign and marketing teams to drive revenue generation opportunities with end to end analytics and resources planning.
Project Work:
•Project Scorpion: contributed in project of new brand ClearNet. Performed predictive analytics and hypothesis testing using SQL and R on Western Canadian provinces demographics.
•Hardware Transparency (HT): to introduce hardware subsidies and drawdown amount on invoice. Acted as prime for hardware device balance project by performing data analysis from newly created database and quality assurance. Performed K Means clustering by using R programming for client’s contract term grouping.
Conducted analyses that identify/assess business opportunities and address key business challenges.
•Assisted TELUS Mobility channel partners, channel managers and corporate clients to assess their needs and apply timely solutions
•Formulated and execute queries, with reports that clearly answer business questions related to cross-sell, up-sell, etc.
•Acted as a liaison with other departments as issues arise that require the expertise of other operational groups to ensure that the issue is resolved in a timely manner
•Worked with Directors, Senior Managers and Subject Matter Experts to ascertain business requirements and planning
SAS Base Programming II
Certificate in Data Analytics, Big Data, and Predictive Analytics.
•
B.A. Economics