ROFESSIONAL BRIEF

Results-oriented person with experience in data analytics and process re-engineering seeking to leverage my analytical and business skills to develop a career in corporate strategy.

• Recognized record of contributions that streamlined operations, invigorated businesses, heightened productivity enhanced internal controls
• Combined multi-disciplinary experience across functions to optimise the entire value chain of business
• Possesses core competencies across:
• Leveraged entrepreneurial ability and skills in translating corporate vision, to overcome complex business challenges and deliver on high-impact decisions
• An effective communicator with strong leadership, analytical and relationship management skills
• Proven success in working with multi-disciplinary team across geographies in onshore offshore model

WORK EXPERIENCE

Business Analytics Manager

• Member and team lead of the strategy team for Consumer Distribution Branches, ATM, Mobile and Internet Banking.
• Collaborate with managers in Business Management Office on new initiatives to determine business process re-engineering, reporting, channels needs and distribution
• Accumulate business requirements from various business users across geographies Asia/Europe and translate them into Business requirements document
• Assist Project Manager with the project plan and business case documentation by identifying key business requirements, describing primary responsibilities, timelines, deliverables and key milestones
• Conducted various meeting sessions with the development team to understand the technology and the procedure of deployment
• Production and analysis of results to provide insightful management reports
• Gap Analysis from the current state to desired future state inclusive of objectives, business needs and impacted user groups
• Identify gaps in current business processes and implement processes changes to bring process improvement
• Writing and reviewing business, user and non-functional/system level requirements in the form of Use Cases, UML, and other similar structured requirements documentation
• Contribute in the training and execution of setting up project team
• Tools used Business Objects, VBA, MS Office and SAS Enterprise Guide, SharePoint

Major Highlights:

• Gold Ovation Winner for 2012 for 'Single View' reporting solution resulting in a saving of 1.2 million annually - the highest award in Business Services India given at a six monthly frequency for designing analytical solutions to business problems in UK Retail
• Silver Ovation Winner for 2013 for automation of hierarchy level strategic initiatives reports to drive improvements in customer support and customer service
• Customer Appreciation Award Winner Quarter 2, 2013 for implementing in-house developed survey tool 'Helpful Leader's Index' and building in-house scoring solutions for Net Promoter Score
• Identified opportunities for growth in teams in India, set up new teams and institutionalized their operating models

Business Planning Manager

Confidential

• Wallet' exercise and drive business penetration to optimize HSBC share in key markets, segments and client
• Responsible for defining the scope, and defining business rules of the project, gathering business requirements, doing gap analysis and documents them textually or within models
• Responsible for writing Functional Requirement Specifications FRS and User Requirement Specification
• URS
• Liaise with marketing and finance department for understanding business problems and marketing strategies
• Drive business process re-engineering and reporting automation solutions. Look after the enhancement of quality, usefulness, productivity and speed of reports automating and streamlining the manual reports processes
• Streamlining of legacy reporting suite for greater efficiency and data integrity
• Developing and articulating strategic recommendations based on data mart analysis
• Measuring and monitoring the performance of various individuals and units of Trade using Business Intelligence tools. Create reports, analysis and metrics dashboard that provide essential information to make strategic and data driven business decisions.
• Develop, prepare and present financial metrics and reports to communicate and monitor status of results vs. plans for business results and profitability, encompassing Business Volumes, Cost, Income and Profitability of various units
• Continually research, analyze and make recommendations from financial data while researching and identifying current trends and opportunities for increased revenue
• Support executive and production team decisions by utilizing data warehouse and analytics

Major Highlights:

• Developed and implemented new 'Revenue and Performance Reporting' tool based on COGNOS and SAS EG and de-commissioned legacy Excel spreadsheet based reporting system, resulting in efficiency increase of 30
• Creation and implementation of document extraction process within secured environment resulting in a production increase of 50
• Developed data lookup process within legacy systems improving analyst efficiency by 20 per issue
• Management liaison to Operations teams developing ad hoc and permanent analytics and processes
• Creation and management of daily ETL process with focus on reporting efficiency and accuracy
• Report creation and analytics using Excel front end and SAS EG-Mainframe backend

Assistant Manager, Commercial Banking Strategy and Analytics

Confidential

• Drive development and implementation of the market segmentation and 'Cross Sell' model for the Small and Medium Enterprise market team
• Drive Business Enabler projects which increased revenue of 20k per month
• Anti-Attrition Model
• Product Propensity Model

Segmentation

Channel Allocation

• Continually research, analyze and make recommendations from marketing campaigns while researching and identifying current trends and opportunities to increase revenue
• Drive implementation of One HSBC Business Intelligence OHBI tool in India identify reports for migration on to OHBI
• Prepare Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements
• Using Business Rules, Business Use-Case Model and Business Object Model participated in Requirement
• Analysis of the application and performed GAP analysis of the reports to be migrated with a possibility of developing various reports migrating the existing reports for production via BI Platform / COGNOS
• Ensured BI data provides universal solution for analytics and reporting linked the BI data-warehouse to analytic tools. Data stored in Mainframe and used SAS Enterprise Guide to access and analyze the data
• Test the application manually by executing Test Cases prior to Automation. Actively involved in User Acceptance Testing and Training of the end users
• Maintenance of Asia Pacific Commercial banking data-mart development and Mainframe HUB accessed through SAS Enterprise Guide
• Reporting suite developed includes KPI, month end, quarterly financial, partner reporting, customer detail reporting, root cause analysis, goal tracking and forecasting per internal standards

Major Highlights:

• Played an instrumental role in implementation of cross sell and anti attrition model in SME RM portfolio, maximizing potential revenue resulting in 1 million increased revenue over one year
• Efficaciously carried out the implementation of segmentation model in SME and automation of various ad-hoc business requirements on SAS
• Implemented customer life cycle management models, Anti Attrition and Product Propensity models, resulted in increase in customer wallet share and customer stickiness' and boost to the overall profitability

Confidential

• Developed and supported MS Access data warehouses by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex queries
• Created and maintained documentation on data warehouse processes and procedures
• Created subscription based and ad hoc reporting using MS Reporting Services. Reports included KPI, month end, quarterly financial, survey reporting, channel allocation and usage monitoring among others
• Measured monitored the performance of various individuals units of Transaction Banking Unit using SAS and Spreadsheet tools
• Co-related with the active accounts and overall transactions to identify the potential customers for migration to electronic channels such as phone banking and internet banking
• Worked on SOX reporting, Online Report Management System and Online Internal Survey System
• Ensured accessibility of reports through better functionality involved in raising requirements and giving sign off on delivery