SQL, SAS, SSIS, Big Query, MS Visio, Confluence, Excel, Powerpoint, Jira
Varun Singhal
Senior Business Analyst
Bangalore
Summary
Result driven professional with overall 13+ years of experience as Senior Business Analyst and Data Transformation Manager. Hands on experience in handling enterprise level Data Transformation Projects in Banking industry.
Overview
13
13
years of professional experience
6
6
years of post-secondary education
2
2
Languages
Work History
Senior Business Analyst | Product Owner
Australia and New Zealand Bank
Bangalore
02.2021 - Current
- Applied structured approach to document the process map of multiple complex processes and 200 plus credit critical KPIs.
- Successfully lead 13 members squad to understand and streamline complex business transformation processes across enterprise risk.
- Laid the foundation to migrate of the existing processes from legacy infrastructure to Google cloud platform.
- Built a strong network with business stakeholders and technology squad to understand requirements and translate the same to developers.
- Articulated vision and user stories in a way clearly understandable to development team.
- Managed backlogs of multiple user stories simultaneously across multiple products such as Home loan, Cards, Personal loan etc.
- Conducted various trainings to uplift the process knowledge of the team members.
- Led projects and analyzed data to identify opportunities for improvement.
Manager - Data and Infrastructure
Australia and New Zealand Bank
Bangalore
10.2018 - 02.2021
- Lead wholesale banking stream to develop data strategy/business logic and BI reporting using Qlik suite
- Expanded cross-functional organizational capacity by collaborating across departments on priorities, functions and common goals.
- Developed end to end solutions starting from requirement gathering to project deployment to support regulatory (APRA) remediation requirements
- Managed and track RPA implementations using project governance framework to meet audit requirements
- Head a team of 6 developers to plan and prioritize their work
- Migrated and automated various manual Risk processes to BI platform
Transformation Manager - FP&A
Australia and New Zealand Bank
Bangalore
10.2016 - 09.2018
- Lead digital transformation initiative from India(Clearing house) in transforming the existing reporting through ESAR
- Prepared wireframes by analysing the existing solutions and new requirements
- End to end Delivery owner of various Qlikview based dashboards
- Liaising and negotiating with technologies to get exceptions and ensure smooth functioning of processes in case of system failures
- Played a key role in Standardizing/Automating (Qlik and Robotics)/Decommissioning ~500 BAUs and saved ~2000 hours Monthly for entire Institutional FP&A
Business Transformation Manager
American Express
Gurgaon
03.2015 - 10.2016
- Managed Global Standardization and Performance Analytics transformation Project, Global Standardization:
- Driven global standardization by aligning all regions to common definitions and calculation logics and resolving regional nuances in Corporate Card business of American Express
- Designed reporting solutions with better visualization capabilities to Directors, VPs and GMs for Sales Productivity, Bottom line, Clients at risk and other important parameters
- Performance Analytics Transformation:
- Branding Initiative: Creating interactive Playbook, designing Newsletter, devising delivery mechanism using SharePoint sites and tracking mechanism to measure the usage of the solutions
- Efficiency: Decommissioning the redundant reports and solutions, enabling self-service by automating all the solutions through Tableau and making them interactive with real time data build on Big Data Platform.
Business Analyst
Hewlett Packard
Bangalore
11.2013 - 02.2015
- Self Service using Qlikview:
- Designed and Developed Bid Desk Performance Management QlikView Dashboard for the Americas region to assess performance of deal approvers and their managers
- Designed performance measurement tool on Qlikview to measure the performance of the sales team by measuring authorizers discount approval pattern, price adherence, business unit escalations
- Self-serviced tool was designed to measure the adherence to price guidance tool, peer comparison and quote to consumption etc
- Program effectiveness:
- Simplify and standardize the deal process related to Promotions and Partner Special Negotiated Discounts and assess the health, usage, accountability etc to be able to derive increments and related returns and bring out the cannibalization effect
- Analyzed the data to have the visibility on the misuse of promotional offers leading to grey
- Significant Achievements
- Successfully developed self-serviced Qlikview based tool without any training and received wide appreciation from the business.
Business Analyst
Fidelity Investments
Bangalore
04.2011 - 10.2013
- Developed scorecards and reports
- Data consulting to various teams/VPs and help them develop self service capabilities
- Significant Achievements
- Created advisory services scorecard to aid company VP’s during critical business decision making
- Became subject matter expert for this product
- Streamlined the production and QC process for various reports using SQL/SAS/Excel resulting in at least two thousand hours labor saving annually
- Worked on the expansion of Guidance Scorecard which is one of the niche service introduced by Fidelity.
Senior Associate
Genpact
Bangalore
12.2008 - 03.2011
- Analysis of sales data from major vendors of Masterfoods Inc., a European based consumer goods manufacturer, and predict market trends and provide analysis
- Developed key metrics reports and detailed reference documents for Masterfoods
- Onshore coordinator in the UK for 6 months
- Lead a team of three market analysts and was responsible for planning resource allocation, scheduling, executing project activities, maintaining KPI and daily dashboards, Issuing error logs and 5 whys
- Significant Achievements
- Determined to be the best candidate amongst a seasoned team of 12 to travel to UK and help with knowledge and process transition
- Exceeded the target of report creation for the fifteen different regions in first year by 40%
- Improved process efficiency resulting in release of 2 FTEs
- Other Achievements
- Elected unanimously by the students and staff as the student secretary of Training and Placement committee, MMEC Mullana, Haryana .
Education
PGP - Bigdata and Machine
Great Lakes
03.2018 - 04.2019
PGPM - Marketing
International School of Management Excellence
08.2007 - 12.2008
B. Tech - Computer Science
Kurukshetra University
06.2003 - 06.2007
Skills
Business Intelligence
Business Analyst
Conceptual Skills
Agile and Scrum(Jira)
Communication
Project Management
Process Mapping
Team Management
Machine Learning
Data management
Software
Timeline
Senior Business Analyst | Product Owner
Australia and New Zealand Bank
02.2021 - Current
Manager - Data and Infrastructure
Australia and New Zealand Bank
10.2018 - 02.2021
PGP - Bigdata and Machine
Great Lakes
03.2018 - 04.2019
Transformation Manager - FP&A
Australia and New Zealand Bank
10.2016 - 09.2018
Business Transformation Manager
American Express
03.2015 - 10.2016
Business Analyst
Hewlett Packard
11.2013 - 02.2015
Business Analyst
Fidelity Investments
04.2011 - 10.2013
Senior Associate
Genpact
12.2008 - 03.2011
PGPM - Marketing
International School of Management Excellence
08.2007 - 12.2008
B. Tech - Computer Science
Kurukshetra University
06.2003 - 06.2007