MANAS ARORA
Ottawa,ON
Summary
Motivated and results-driven job seeker with proven track record in data analytics, business intelligence and risk mitigation. Identifies business needs and develops valuable solutions to improve accuracy and process optimization. Drives business success with recommendations based on data findings.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
Work History
Associate
Hero FinCorp
08.2018 - 04.2022
- Develop, maintain and optimize EWS (Early Warning System) model that helps to identify the risks associated with a potential fraud on an account at an early stage
- Outlining customer treatment strategies based on in-depth analysis of customer data
- Monitor strategy effectiveness and identify opportunities by validating and updating changes to the credit risk systems and fraud mitigation systems
- Portfolio Monitoring for different line of businesses to observe emerging trends
- Monitoring and optimization of customer acquisition model while automating the process
- Strategize loss preventive action on customer and reduce the risk involved
- Preparation and submission of regulatory reports to Reserve Bank of India as per their norms
- Create and maintain monthly reports for all markets using SAS, SQL, TABLEAU and Excel
- Develop programs for data extraction and manipulation using SAS and provide data insights
- Responsible for extracting internal/external data, cleaning and validation, data analysis and report generation
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Provided evaluative judgment based on analysis of information in complicated and unique situations and contributed to formulation of standards and strategies for functional areas.
- Built relationships and influenced and motivated employees to drive operational improvements.
- Developed and improved integrated reporting and analysis capabilities.
- Executed analysis of risks and identified risk mitigation strategies.
- Evaluated trends to understand competitive environments and assess current strategies.
- Delivered analysis of market, sales and consumer trend impact on long and short-term strategies.
- Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.
Lead Business Analyst
American Express India Pvt. Ltd, The American Express
07.2016 - 07.2018
- Company, also known as Amex, is an American multinational financial services corporation
- The company is best known for its charge card, credit card and traveler's cheque businesses
- Roles and Responsibilities
- Manage, master and leverage information across various data sources, synthesize and enrich information to provide meaningful, timely and accurate MIS and meet specific requirements of internal customers
- Provide analytical and decision support to regional leaders through data mining and advanced analytics
- Create and maintain analytical presentations using various business intelligence tools and techniques
- Provide data insights and business recommendations to senior leaders to support business strategies
- Create monthly reports and dashboards for all global markets using SQL, SAS, Python, HIVE, TABLEAU
- Perform data mining, cleaning, analysis on data received from various systems
- Providing support and maintenance to existing management information systems (MIS)
- Preparing PowerPoint presentations for business reviews
- Assist and monitor the team to ensure efficiency in process operations and meeting of individual and group targets
Senior Analyst
HCL Technologies Ltd, HCL Technologies Limited, Hindustan Computers Limited
08.2013 - 07.2016
- Is an Indian multinational technology company
- It operates across various sectors including banking, capital markets, automotive, energy and utilities, healthcare, insurance, media and entertainment, oil and gas, telecom etc
- Roles and Responsibilities
- Establishing strong customer relationship and understanding end to end data requirements
- Gathering requirements from customer with the help of team meetings, questionnaires and observation and documenting the same
- Design, develop, test and implement capabilities to capture and store data from application into various data tables
- Create data triggers and stored procedures that automatically get executed when a certain action is taken on a particular table in a database
- Applying QA check to ensure efficient and effective deliverable to the client
- Analyzing and publishing weekly/monthly performance update report
- Provide recommendations to update current reporting efficiency and consistency of the application
- Participate in cross-functional meetings to resolve recurring customer issues and improve Reporting and Dashboards
- Proficiencies
Education
Diploma - Business Management
NMIMS
08.2018 - 07.2019
Bachelor of Technology - Computer Science
Lovely Professional University
08.2009 - 07.2013
Skills
Data Analysis
undefinedAdditional Information
- Received quarterly recognition in Platinum Category at Hero Fincorp.
- Received prestigious Champions Award at Hero Fincorp. National Event
- Received client award twice for successful execution of a project at American Express
- Awarded with HCL Jewel for consistent performance 3 quarters in a row
- Received on spot award for hard work and dedication
Timeline
Diploma - Business Management
NMIMS
08.2018 - 07.2019
Associate
Hero FinCorp
08.2018 - 04.2022
Lead Business Analyst
American Express India Pvt. Ltd, The American Express
07.2016 - 07.2018
Senior Analyst
HCL Technologies Ltd, HCL Technologies Limited, Hindustan Computers Limited
08.2013 - 07.2016
Bachelor of Technology - Computer Science
Lovely Professional University
08.2009 - 07.2013
Similar Profiles
Vishakh V NairVishakh V Nair
Anchor Service Manager at Hero FinCorpAnchor Service Manager at Hero FinCorp
Abhishek VishwakarmaAbhishek Vishwakarma
Area Sales Manager at Hero FinCorp LTDArea Sales Manager at Hero FinCorp LTD
Sundeep KapoorSundeep Kapoor
Leading Procurement ,Admin and Facility Management at Hero FinCorp LtdLeading Procurement ,Admin and Facility Management at Hero FinCorp Ltd